On a development machine get a recent Lisk mainnet snapshot and
dropdb --if-exists lisk_main
createdb lisk_main
gunzip -fcq lisk_main_backup-*.gz | psql --quiet --dbname lisk_main
Use a SQL tool to perform this query and export data (e.g. as CSV)