SteemSQL is a publicly available Microsoft SQL database, it should contain all the Steem blockchain data. Very valuable information, if you know how to write SQL.
This post will guide you through the setting up DBsteem in Server Management Studio, and get you started querying.
First download SQL Server Management Studio (SSMS) aprox 800 MB
Run SSMS as administrator.
Use these credientials
Login Steemit
Pass Steemit
Check trust server certificate
Now you should be connected and able to write a query...
Lets do a test
SELECT TOP (100) [ID]
,[tx_id]
,[type]
,[from]
,[to]
,[amount]
,[amount_symbol]
,[memo]
,[request_id]
,[timestamp]
FROM [DBSteem].[dbo].[TxTransfers]
order by amount desc
I use top 100 to reduce the load time, and i order by desc to get the highest amount first.
You should get something like this
