jackguyETH Down Bad 4
Updated 2022-11-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
-- date_trunc('day', block_timestamp) as day,
sum(CASE WHEN symbol_in LIKE '{{ token }}' then amount_in_usd END) volume_sold,
sum(CASE WHEN symbol_out LIKE '{{ token }}' then amount_in_usd END) volume_bought,
sum(CASE WHEN symbol_in LIKE '{{ token }}' then -1 * amount_in_usd
WHEN symbol_out LIKE '{{token}}' then amount_in_usd END) as net_volume,
count(*) as swap_evetns
FROM ethereum.core.ez_dex_swaps
where block_timestamp > CURRENT_DATE - 30
--GROUP by 1
Run a query to Download Data