Sbhn_NPpetite-yellow
Updated 2024-11-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with price as (
select hour::date as datee,
avg(price) as usdprice
from aptos.price.ez_prices_hourly
where symbol = 'APT'
group by 1
)
select
count(DISTINCT EVENT_DATA:swapper) as swapper,
count(DISTINCT EVENT_DATA:market_id) as market_id,
sum(EVENT_DATA:quote_volume/pow(10,8)) as volume,
sum((EVENT_DATA:quote_volume/pow(10,8))*usdprice) as volume_usd
from aptos.core.fact_events
join price on block_timestamp::date=datee
where event_module = 'emojicoin_dot_fun'
and event_resource = 'Swap'
QueryRunArchived: QueryRun has been archived