shadilStargate User Growth - amount of STG staked over time since inception
    Updated 2022-04-22
    SELECT
    date_trunc('hour', block_timestamp) as hour,
    -- date(block_timestamp) as date,
    sum(event_inputs:value/1e18) as amount,
    COUNT(DISTINCT event_inputs:provider) as wallet
    from ethereum_core.fact_event_logs
    where date(block_timestamp) >= '2022-04-20'
    and contract_address = '0x0e42acbd23faee03249daff896b78d7e79fbd58e' -- veSTG token
    -- and tx_hash = '0x9fb545785e578ac37c8a550555a28c385eb6bb7d6aab2662d25790c194369806' -- sample stake trx
    and event_name = 'Deposit'
    and event_inputs:locktime is not NULL
    GROUP BY hour
    Run a query to Download Data