Updated 2023-06-05
    select
    block_timestamp::date as day,
    'stake' as actions,
    count(distinct tx_hash) as count_txn,
    sum(raw_amount/pow(10,18)) as daily_amount,
    avg(raw_amount/pow(10,18)) as avg_volume
    from ethereum.core.fact_token_transfers
    where contract_address = lower('0x4da27a545c0c5b758a6ba100e3a049001de870f5')
    and origin_function_signature= '0xadc9772e'
    and block_timestamp >= CURRENT_DATE - 30
    group by 1
    union all
    select
    block_timestamp::date as day,
    'unstake' as actions,
    count(distinct tx_hash) as count_txn,
    sum(raw_amount/pow(10,18)) as daily_amount,
    avg(raw_amount/pow(10,18)) as avg_volume
    from ethereum.core.fact_token_transfers
    where contract_address = lower('0x4da27a545c0c5b758a6ba100e3a049001de870f5')
    and origin_function_signature= '0x1e9a6950'
    and block_timestamp >= CURRENT_DATE - 30
    group by 1


    Run a query to Download Data