superflyMarket Cap and Supply
Updated 2025-01-04
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 token_data AS (
SELECT
t.ORIGIN_TO_ADDRESS AS token_address,
SUM(t.AMOUNT) AS total_transferred,
COUNT(DISTINCT t.ORIGIN_FROM_ADDRESS) AS unique_buyers
FROM
base.core.ez_token_transfers t
WHERE
t.BLOCK_TIMESTAMP >= DATEADD(MONTH, -1, CURRENT_DATE)
AND t.ORIGIN_TO_ADDRESS = '0x4f9fd6be4a90f2620860d680c0d4d5fb53d1a825'
GROUP BY
t.ORIGIN_TO_ADDRESS
),
latest_price AS (
SELECT
token_address,
MAX(price) AS current_price
FROM
base.price.ez_prices_hourly
WHERE
LOWER(token_address) = '0x4f9fd6be4a90f2620860d680c0d4d5fb53d1a825'
GROUP BY
token_address
)
SELECT
td.token_address,
lp.current_price,
td.total_transferred,
td.unique_buyers
FROM
token_data td
JOIN
latest_price lp
ON
LOWER(td.token_address) = LOWER(lp.token_address)
QueryRunArchived: QueryRun has been archived