feyikemi$KMNO Houry Traded Volume
Updated 2024-05-06
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
›
⌄
WITH KMNO AS (
SELECT
date_trunc('hour', block_timestamp) as date,
sum(amount) as KMNO_Total_volume
FROM
solana.core.fact_transfers a
WHERE
mint = 'KMNo3nJsBXfcpJTVhZcXLW7RmTwTt4GVFE7suUBo9sS'
GROUP BY 1
)
,
USD AS (
SELECT
AVG(Price) AS USD_Price
FROM
solana.price.ez_prices_hourly b
WHERE
Token_address = 'KMNo3nJsBXfcpJTVhZcXLW7RmTwTt4GVFE7suUBo9sS'
)
SELECT
Date,
KMNO_Total_volume * USD_Price as USD_Total_Traded_Volume
FROM KMNO JOIN USD
QueryRunArchived: QueryRun has been archived