pandaETH Down Bad | MATIC Price and Volume
Updated 2022-12-23Copy Reference Fork
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 matic_PriceTrend AS
(
SELECT
hour::date as timestamps,
avg(price) as usd_Price
FROM
ethereum.core.fact_hourly_token_prices
WHERE
TOKEN_ADDRESS = lower('0x7D1AfA7B718fb893dB30A3aBc0Cfc608AaCfeBB0')
AND
timestamps >= CURRENT_DATE - 14
GROUP BY
1
),
swap_Transactions AS
(
SELECT
BLOCK_TIMESTAMP::date as timestamps,
CASE WHEN SYMBOL_IN = 'MATIC' AND SYMBOL_OUT != 'MATIC' then 'SELL'
WHEN SYMBOL_IN != 'MATIC' AND SYMBOL_OUT = 'MATIC' then 'BUY'
END AS decision,
AMOUNT_IN_USD as USD_IN,
AMOUNT_OUT_USD as USD_OUT,
TX_HASH
FROM
ethereum.core.ez_dex_swaps
WHERE
EVENT_NAME = 'Swap'
AND
SYMBOL_IN = 'MATIC'
AND
SYMBOL_OUT != 'MATIC'
AND
timestamps >= CURRENT_DATE - 14
Run a query to Download Data