par_rnEMOJI 02
Updated 2024-12-12
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
›
⌄
WITH price AS (
SELECT
hour :: date as datetime,
AVG(price) AS price
FROM
aptos.price.ez_prices_hourly
WHERE
symbol = 'APT'
GROUP BY
1
)
SELECT
date_trunc('day', block_timestamp) AS date,
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_apt,
SUM((EVENT_DATA:quote_volume / pow(10, 8)) * price) AS volume_usd
FROM
aptos.core.fact_events
JOIN price on block_timestamp :: date = datetime
WHERE
event_module = 'emojicoin_dot_fun'
AND event_resource = 'Swap'
GROUP BY
1
QueryRunArchived: QueryRun has been archived