alirsBAAS-01-period
Updated 2022-12-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
select block_timestamp::date as Date,
case when date>='2022-03-17' and date<'2022-04-01' then 'March 2022'
else 'After Murch 2022' end as time_period,
count (distinct tx_hash) as "Number of Claims",
count (distinct origin_from_address) as"Number of Users",
sum (event_inputs:value/pow(10,18)) as "Claimed APE Volume",
150000000 - "Claimed APE Volume" AS "APE unclaimed Volume"
,("Claimed APE Volume" / 150000000) * 100 AS "APE claimed Ratio"
,( "APE unclaimed Volume" / 150000000) * 100 AS "APE unclaimed Ratio"
,sum ("Number of Users") over (order by Date) as "Cumulative APE Claim ount"
,sum ("Claimed APE Volume") over (order by Date) as "Cumulative Claimed APE Volume"
from ethereum.core.fact_event_logs
where origin_to_address = '0x025c6da5bd0e6a5dd1350fda9e3b6a614b205a1f'
and tx_status = 'SUCCESS'
and date>='2022-03-17' and date<='2022-12-06'
and event_name = 'Transfer'
and origin_function_signature = '0x48c54b9d'
group by date,time_period
order by date
Run a query to Download Data