alirsBAAS-01-top 10
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
›
⌄
select --block_timestamp::date as Date,
origin_from_address,
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 event_name = 'Transfer'
and origin_function_signature = '0x48c54b9d'
group by 1
order by "Claimed APE Volume" desc
limit 10
Run a query to Download Data