saratheth_deriva1
Updated 2022-09-13
99
1
2
3
4
5
6
7
8
9
10
11
12
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