VOLUME_GROUP | EVENTS | |
|---|---|---|
1 | F/ $100K+ | 158203 |
2 | C/ $100 - $1K | 391804 |
3 | B/ $10 - $100 | 75361 |
4 | A/ Below $10 | 13608 |
5 | E/ $10K - $100K | 476686 |
6 | D/ $1K - $10K | 629222 |
jackguyUniswap Fe - 4 copy
Updated 2024-01-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from Uniswap Fe - 4 @ https://flipsidecrypto.xyz/edit/queries/03cc5b15-6ac6-4b47-ba1e-aeb47a2c76a0
with tab1 as (
SELECT
tx_hash
FROM ethereum.core.ez_token_transfers
WHERE to_address LIKE lower('0x37a8f295612602f2774d331e562be9e61B83a327')
and tx_hash in (
SELECT tx_hash
FROM ethereum.uniswapv3.ez_swaps
ORDER by block_timestamp DESC
) AND block_timestamp >= '2023-10-17'
UNION all
SELECT
tx_hash
from ethereum.core.ez_eth_transfers
WHERE eth_to_address LIKE lower('0x37a8f295612602f2774d331e562be9e61B83a327')
and tx_hash in (
SELECT tx_hash
FROM ethereum.uniswapv3.ez_swaps
ORDER by block_timestamp DESC
) AND block_timestamp >= '2023-10-17'
)
SELECT
CASE when ABS(AMOUNT0_USD) < 10 then 'A/ Below $10'
when ABS(AMOUNT0_USD) < 100 then 'B/ $10 - $100'
when ABS(AMOUNT0_USD) < 1000 then 'C/ $100 - $1K'
when ABS(AMOUNT0_USD) < 10000 then 'D/ $1K - $10K'
when ABS(AMOUNT0_USD) < 100000 then 'E/ $10K - $100K'
else 'F/ $100K+' end as volume_group,
count(DISTINCT tx_hash) as events
FROM ethereum.uniswapv3.ez_swaps
Last run: about 1 year agoAuto-refreshes every 6 hours
6
146B
61s