jackguyUniswap Fe - 1
Updated 2023-10-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
date(block_timestamp),
count(DISTINCT tx_hash),
sum(amount_usd) as fee_volume
FROM ethereum.core.ez_token_transfers
WHERE to_address LIKE lower('0xeb4Af8a64070Ef0dEa6260e0Bf2310748f014d88')
and tx_hash in (
SELECT tx_hash
FROM ethereum.uniswapv3.ez_swaps
ORDER by block_timestamp DESC
)
and amount_usd < 1000000000
--AND from_address = ORIGIN_FROM_ADDRESS
GROUP BY 1
Run a query to Download Data