SocioCryptoeth vs polygon
Updated 2022-08-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT 'polygon' as label,
date_trunc('{{Interval}}',block_timestamp) as date,
count(DISTINCT tx_hash) as n_swaps,
sum(amount_in_usd) as amnt_usd,
count(DISTINCT origin_from_address) as n_swappers
FROM polygon.sushi.ez_swaps
GROUP BY date
UNION
SELECT 'ethereum' as label,
date_trunc('{{Interval}}', block_timestamp) as date,
COUNT (DISTINCT tx_hash) as n_swaps,
sum(amount_in_usd) as amnt_usd,
count(DISTINCT origin_from_address) as n_swappers
FROM ethereum.core.ez_dex_swaps
WHERE platform like 'sushiswap'
GROUP BY date
Run a query to Download Data