winnie-fsEUROC Swap Vol copy
999
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
›
⌄
-- forked from cloudr3n / EUROC Swap Vol @ https://flipsidecrypto.xyz/cloudr3n/q/im2WAmtNmn_A/euroc-swap-vol
with
px_tb as
(
SELECT
*
FROM
avalanche.core.fact_hourly_token_prices
WHERE
token_address in ('0xc891eb4cbdeff6e073e859e987815ed1505c2acd','0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e','0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7')
and date(hour)>='2023-05-25'
),
pxeuroc as (
SELECT * FROM px_tb WHERE token_address='0xc891eb4cbdeff6e073e859e987815ed1505c2acd'
),
pxusdc as (
SELECT * FROM px_tb WHERE token_address='0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'
),
pxwavax as (
SELECT * FROM px_tb WHERE token_address='0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7'
),
px2 as (
SELECT
t1.hour,
t1.price as avax_px,
t2.price as usdc_px,
t3.price as euroc_px
FROM
pxwavax t1
left JOIN pxusdc t2 on t1.hour=t2.hour
left join pxeuroc t3 on t1.hour=t3.hour
),
swaps as (
Run a query to Download Data