Updated 2022-09-21
    SELECT date_trunc('day',a.block_timestamp) as date,
    count(DISTINCT a.tx_hash) as n_stake,
    count(DISTINCT c.event_inputs:to) as n_stakers,
    sum(b.event_inputs:value)/pow(10,18) as amnt,
    sum(amnt) OVER (ORDER BY date) as cum_amnt,
    avg(b.event_inputs:value)/pow(10,18) as avg_amnt
    FROM ethereum.core.fact_event_logs a, ethereum.core.fact_event_logs b, ethereum.core.fact_event_logs c
    WHERE a.tx_hash = b.tx_hash
    AND a.tx_hash = c.tx_hash
    AND a.contract_address = '0xa59c847bd5ac0172ff4fe912c5d29e5a71a7512b' AND a.event_name = 'ShareMinted'
    AND b.contract_address = '0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0' AND b.event_name = 'Transfer'
    AND c.contract_name = 'ValidatorShareProxy' AND c.event_name = 'Transfer' AND c.event_inputs:from = '0x0000000000000000000000000000000000000000'
    GROUP BY date
    ORDER BY date DESC

    --example tx_hash = '0x53b17e1fb6faaf1a5482b635c4dffa89a1a75d5b721b83b1b8bab59ce700aa11'

    Run a query to Download Data