badboyUntitled Query
Updated 2022-12-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with apeprice
as (
select hour::date
as day,
avg (price)
as APE_Price
from ethereum.core.fact_hourly_token_prices
where token_address = '0x4d224452801aced8b2f0aebe155379bb5d594381'
group by 1)
select block_timestamp::date
as date,
APE_Price,
count (distinct tx_hash) as TX_Count,
count (distinct origin_from_address) as Users_Count,
sum (event_inputs:value/1e18) as Claimed_Ape_Volume,
avg (event_inputs:value/1e18) as Average_APE_Volume,
median (event_inputs:value/1e18) as Median_APE_Volume,
min (event_inputs:value/1e18) as Minimum_APE_Volume,
max (event_inputs:value/1e18) as Maximum_APE_Volume,
sum (TX_Count) over (order by date) as Cumulative_Claims_Count,
sum (Claimed_Ape_Volume) over (order by date) as Cumulative_Received_Volume
from ethereum.core.fact_event_logs t1 join apeprice t2 on t1.block_timestamp::date = t2.day
Run a query to Download Data