DAY2 | SELL_VOLUME_USD | BUY_VOLUME_USD | SELL_EVENTS | BUY_EVENTS | |
|---|---|---|---|---|---|
1 | 2024-01-29 00:00:00.000 | 2615.6 | 2460.5 | 7 | 6 |
2 | 2024-01-27 00:00:00.000 | 12060.78 | 15107.01 | 9 | 12 |
3 | 2024-01-18 00:00:00.000 | 1065.76 | 261.08 | 5 | 2 |
4 | 2024-01-25 00:00:00.000 | 1011.68 | 866.36 | 2 | 2 |
5 | 2024-01-19 00:00:00.000 | 205.53 | 255.04 | 1 | 1 |
6 | 2024-01-22 00:00:00.000 | 7100.68 | 7099.17 | 7 | 7 |
7 | 2024-01-23 00:00:00.000 | 349.75 | 484.72 | 3 | 3 |
8 | 2024-01-20 00:00:00.000 | 216.11 | 138.64 | 1 | 1 |
9 | 2024-01-24 00:00:00.000 | 1458.74 | 1343.44 | 6 | 5 |
10 | 2024-01-15 00:00:00.000 | 5852.76 | 2909.89 | 8 | 3 |
11 | 2024-01-16 00:00:00.000 | 1102.35 | 48.41 | 3 | 1 |
12 | 2024-01-26 00:00:00.000 | 1039.62 | 1107.98 | 2 | 3 |
13 | 2024-01-28 00:00:00.000 | 2421.91 | 4131.77 | 5 | 5 |
14 | 2024-01-17 00:00:00.000 | 2040.48 | 785.37 | 4 | 2 |
15 | 2024-01-21 00:00:00.000 | 12618.51 | 12364.9 | 3 | 2 |
jackguyNFT-token-dash-3 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 @ 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'),
lower('0xe72377ae353edc1d07f6c0be34969a481d030d19'),
lower('0x882784c5807d5e2e4950ae2327ca5d9b56a1015a'),
lower('0x92741be6adcb2722681925afce9af0a7306ce90f'),
lower('0x4a382e0fb2abc4bc087d2f7953a4689ecbb96374'),
lower('0xb17015d33c97a2caca73be2a8669076a333fd43d'),
lower('0x01a8227d4e7c3068ad1000c97a059af5c5fa3476')
Last run: about 1 year agoAuto-refreshes every 6 hours
15
712B
2s