Sbhn_NPOP Overall
Updated 2022-09-28Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
--credit : akbaridria
with data_claimed as (
select
block_timestamp::date as date,
try_to_number(event_inputs:amount::string)/pow(10, 18) as amount,
event_inputs:recipient as user
from
optimism.core.fact_event_logs
where
-- tx_hash = '0x4afc33784549bc633b3618efb8c88e663890728889f21d467f39257c18d33156'
-- and
contract_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'
and
event_name = 'Claimed'
)
select
sum(amount) as total_op,
count(distinct user) as address
from
data_claimed
Run a query to Download Data