par_rnEMOJI 01
Updated 2024-12-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
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
COUNT(DISTINCT EVENT_DATA:swapper) AS user,
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'
QueryRunArchived: QueryRun has been archived