RE: Using Snapshots of steemd.com to estimate Hive per MVest

You can get the data from hivesql, from the VOFillVestingWithdrawals table.

Here is a query I run once per month to get the data for the previous month ... adjust the dates for whatever period you need:

DECLARE @MonthRange INT = -1;
DECLARE @QueryDay INT = 1;

SELECT
CONVERT(DATE,timestamp) as T_date,
SUM(deposited)/SUM(withdrawn) as HIVEVESTS

FROM VOFillVestingWithdraws
WHERE
CONVERT(DATE,timestamp) BETWEEN DATEADD(MONTH, @MonthRange, GETDATE()-@QueryDay) AND GETDATE()-@QueryDay
AND deposited_symbol = 'HIVE'

GROUP BY CONVERT(DATE,timestamp)
ORDER BY CONVERT(DATE,timestamp) asc