EMOJI_SYMBOL | NUM_SWAPS | CURRENT_PRICE | CURRENT_MARKET_CAP_USD | MIN_PRICE_USD | MAX_PRICE_USD | |
|---|---|---|---|---|---|---|
1 | 🌮🔔 | 275 | 0.00006545614437 | 1676.610058156 | 0 | 0.0002448492117 |
ellerydurwintotaly_test
Updated 2025-02-09
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
apt_price AS (
SELECT
hour::date AS date,
AVG(price) AS price_usd
FROM
aptos.price.ez_prices_hourly
WHERE
symbol = 'APT'
GROUP BY 1
),
market_registrations AS (
SELECT
block_timestamp,
TRY_HEX_DECODE_STRING(SUBSTR(EVENT_DATA:market_metadata:emoji_bytes, 3)) AS emoji,
(EVENT_DATA:last_swap:avg_execution_price_q64 / 1e20) * 3.4 AS price_apt,
price_apt * price_usd AS price_usd,
event_data:cumulative_stats:quote_volume / 1e8 AS amount_apt,
amount_apt * price_usd AS amount_usd,
event_data:cumulative_stats:n_swaps AS swaps,
event_data:instantaneous_stats:market_cap / 1e8 AS market_cap_apt,
market_cap_apt * price_usd AS market_cap_usd,
event_data:instantaneous_stats:total_value_locked / 1e8 AS tvl_apt,
tvl_apt * price_usd AS tvl_usd
FROM
aptos.core.fact_events
LEFT JOIN
apt_price ON block_timestamp::date = date
WHERE
event_module = 'emojicoin_dot_fun'
AND emoji = '🌮🔔'
AND event_data:cumulative_stats:quote_volume > 0
)
SELECT
Last run: 2 months ago
1
70B
15s