mboveiriUntitled Query
Updated 2022-09-18
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
--block_timestamp::date as date,
sum(event_inputs:value/1e18) as Staked,
sum(case when ORIGIN_FUNCTION_SIGNATURE = '0x28cc4e41' then (event_inputs:value/1e18) end) as Restake,
count(distinct origin_from_address) as users
from
ethereum.core.fact_event_logs
where contract_address = '0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0'
and event_name = 'Transfer'
and event_inputs:to = '0x5e3ef299fddf15eaa0432e6e66473ace8c13d908'
and block_timestamp >= '2022-07-01'
--group by date
Run a query to Download Data