saratheth_deriva1
    Updated 2022-09-13
    select distinct origin_from_address,
    sum(event_inputs:value / pow(10,18)) as amount,
    count(distinct origin_from_address) as uniuse,
    min(date_trunc('day', block_timestamp))
    from ethereum.core.fact_event_logs
    where contract_address like lower('0xae78736cd615f374d3085123a210448e74fc6393')
    and origin_to_address like lower('0xae78736cd615f374d3085123a210448e74fc6393')-- rocketpool
    and event_inputs:value is not null -- must have value
    and event_name like 'Transfer' -- staking method
    and block_timestamp like '2022%'
    group by 1
    order by 2 DESC
    limit 1000
    Run a query to Download Data