KeyrockSOL-USDC Volume[2] copy <> Thanos
Updated 2024-05-23
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
›
⌄
-- forked from andreafiandro / SOL-USDC Volume[2] @ https://flipsidecrypto.xyz/andreafiandro/q/PNOiUBGq0HGY/sol-usdc-volume-2
-- forked from SOL-USDC Volume @ https://flipsidecrypto.xyz/edit/queries/781e662f-3d8a-4d74-90f3-a0a9510391c7
WITH raw_data AS (
SELECT
livequery.live.udf_api(
'https://dlmm-api.meteora.ag/pair/FbkX1h2YTs171cEMa4GrV7XbAiQt5zSmV2CjfYWxXJDP/analytic/pair_trade_volume?num_of_days=90'
) AS resp
)
SELECT
flattened.value:day_date::DATE AS date,
flattened.value:trade_volume::DECIMAL(18, 4) AS trade_volume,
flattened.value:fee_volume::DECIMAL(18, 4) AS fee_volume
FROM
raw_data,
LATERAL FLATTEN(input => PARSE_JSON(RESP):data) AS flattened;
QueryRunArchived: QueryRun has been archived