SocioCryptoOver time
Updated 2022-08-21
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT date_trunc('{{Interval}}', block_timestamp) as date,
COUNT (DISTINCT CASE WHEN platform like 'uniswap%' THEN tx_hash END) as n_txns_uni,
COUNT (DISTINCT CASE WHEN platform like 'sushiswap' THEN tx_hash END) as n_txns_sushi,
SUM(CASE WHEN platform like 'uniswap%' THEN amount_in_usd ELSE 0 END) as amnt_usd_uni,
SUM(CASE WHEN platform = 'sushiswap' THEN amount_in_usd ELSE 0 END) as amnt_usd_sushi,
COUNT (DISTINCT CASE WHEN platform like 'uniswap%' THEN origin_from_address END) as n_swappers_uni,
COUNT (DISTINCT CASE WHEN platform like 'sushiswap' THEN origin_from_address END) as n_swappers_sushi
FROM ethereum.core.ez_dex_swaps
WHERE date between '2020-09-08' AND CURRENT_DATE-1
GROUP BY date
Run a query to Download Data