DAY2 | SELL_VOLUME_USD | BUY_VOLUME_USD | SELL_EVENTS | BUY_EVENTS | |
|---|---|---|---|---|---|
1 | 2024-01-20 00:00:00.000 | 48.29 | 822.17 | 1 | 2 |
2 | 2024-01-19 00:00:00.000 | 0 | 1770.61 | 0 | 2 |
3 | 2024-01-25 00:00:00.000 | 345.97 | 0 | 1 | 0 |
4 | 2024-01-22 00:00:00.000 | 1901.14 | 748.21 | 4 | 1 |
5 | 2024-01-18 00:00:00.000 | 1993.28 | 0 | 2 | 0 |
6 | 2024-01-27 00:00:00.000 | 550.93 | 654.8 | 2 | 2 |
7 | 2024-01-29 00:00:00.000 | 733.19 | 673.91 | 4 | 3 |
8 | 2024-01-28 00:00:00.000 | 210.54 | 0 | 1 | 0 |
9 | 2024-01-21 00:00:00.000 | 783.83 | 320.17 | 2 | 1 |
10 | 2024-01-17 00:00:00.000 | 727.18 | 1625.59 | 1 | 2 |
11 | 2024-01-23 00:00:00.000 | 935.96 | 788.41 | 2 | 2 |
12 | 2024-01-24 00:00:00.000 | 0 | 825.7 | 0 | 2 |
13 | 2024-01-26 00:00:00.000 | 417.48 | 1603.56 | 1 | 5 |
14 | 2024-01-15 00:00:00.000 | 483.1 | 0 | 1 | 0 |
jackguyNFT-token-dash-3 copy copy copy 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 NFT-token-dash-3 copy copy copy @ https://flipsidecrypto.xyz/edit/queries/548590a5-d6ee-46db-ba17-ae3aef5bd727
-- forked from NFT-token-dash-3 copy copy @ https://flipsidecrypto.xyz/edit/queries/04875cc6-7874-4dbc-ae10-297b93db17ec
-- forked from NFT-token-dash-3 copy @ https://flipsidecrypto.xyz/edit/queries/7bf481c7-419e-49e3-a865-0f24860579ca
-- forked from NFT-token-dash-3 @ https://flipsidecrypto.xyz/edit/queries/e16b1af8-2991-4d67-9af6-eef86b3ba6df
with tab1 as (
SELECT
date_trunc('day', block_timestamp) as day2,
sum(
case when case when TOKEN1_SYMBOL LIKE 'WETH' then AMOUNT1_USD else AMOUNT0_USD end > 0 then
case when TOKEN1_SYMBOL LIKE 'WETH' then AMOUNT1_USD else AMOUNT0_USD end
else 0 end
) as sell_volume_usd,
sum(
case when case when TOKEN1_SYMBOL LIKE 'WETH' then AMOUNT1_USD else AMOUNT0_USD end < 0 then
case when TOKEN1_SYMBOL LIKE 'WETH' then AMOUNT1_USD else AMOUNT0_USD end
else 0 end * -1
) as buy_volume_usd,
sum(
case when case when TOKEN1_SYMBOL LIKE 'WETH' then AMOUNT1_USD else AMOUNT0_USD end > 0 then
1
else 0 end
) as sell_events,
sum(
case when case when TOKEN1_SYMBOL LIKE 'WETH' then AMOUNT1_USD else AMOUNT0_USD end < 0 then
1
else 0 end
) as buy_events
FROM ethereum.uniswapv3.ez_swaps
where pool_address IN (
lower('0x5ee84bed805df225ee23aec4160cc0bfcf1bd892'),
Last run: over 1 year agoAuto-refreshes every 6 hours
14
616B
3s