wanlinDaily general info copy
Updated 2023-05-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- forked from sami-1990 / Daily general info @ https://flipsidecrypto.xyz/sami-1990/q/2023-05-02-09-33-am-IasJ50
select
date_trunc ('day',BLOCK_TIMESTAMP) as date,
count (DISTINCT ORIGIN_FROM_ADDRESS) as swappers,
count (DISTINCT TX_HASH) as swaps,
sum (AMOUNT_IN_USD) as volume
from ethereum.core.ez_dex_swaps
WHERE PLATFORM = 'uniswap-v3'
and POOL_NAME like '%USDC-WETH%'
and EVENT_NAME='Swap'
and block_timestamp >= '2022-11-04'
AND block_timestamp <= '2022-11-18'
and AMOUNT_IN_USD is not NULL
GROUP BY 1
Run a query to Download Data