blanchemariaswap direction
Updated 2023-05-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
case
when AMOUNT1_ADJUSTED < 0 then 'Swap BLUR to USDC'
when AMOUNT1_ADJUSTED > 0 then 'Swap USDC to BLUR'
end as swap_direction,
count(distinct tx_hash) as swap_number_count,
sum(abs(AMOUNT1_ADJUSTED)) as swap_volume,
count(distinct sender) as number_of_swapper
from
ethereum.uniswapv3.ez_swaps
where
POOL_NAME = 'BLUR-USDC 3000 60'
and BLOCK_TIMESTAMP >= current_date - interval '{{last_x_day}} days'
group by 1
Run a query to Download Data