DAY2 | SELL_VOLUME_USD | BUY_VOLUME_USD | SELL_EVENTS | BUY_EVENTS | |
|---|---|---|---|---|---|
1 | 2024-01-25 00:00:00.000 | 748.95 | 0 | 2 | 0 |
2 | 2024-01-19 00:00:00.000 | 0 | 6861.35 | 0 | 3 |
3 | 2024-01-22 00:00:00.000 | 12152.2 | 9033.3 | 7 | 2 |
4 | 2024-01-14 00:00:00.000 | 11308.37 | 4983.44 | 8 | 4 |
5 | 2024-01-15 00:00:00.000 | 11065.89 | 10863.25 | 6 | 5 |
6 | 2024-01-20 00:00:00.000 | 3177.54 | 5791.31 | 2 | 5 |
7 | 2024-01-26 00:00:00.000 | 11590.75 | 15782.6 | 10 | 12 |
8 | 2024-01-29 00:00:00.000 | 13940.95 | 13452.99 | 15 | 12 |
9 | 2024-01-18 00:00:00.000 | 2639.71 | 0 | 3 | 0 |
10 | 2024-01-27 00:00:00.000 | 7088.3 | 10748.7 | 6 | 9 |
11 | 2024-01-24 00:00:00.000 | 1325.34 | 2398.99 | 2 | 4 |
12 | 2024-01-16 00:00:00.000 | 1928.1 | 0 | 2 | 0 |
13 | 2024-01-28 00:00:00.000 | 6855.12 | 11404.85 | 7 | 8 |
14 | 2024-01-21 00:00:00.000 | 10966.31 | 7531.1 | 6 | 5 |
15 | 2024-01-17 00:00:00.000 | 6903.55 | 7662.2 | 4 | 5 |
16 | 2024-01-23 00:00:00.000 | 890.65 | 524.38 | 2 | 1 |
jackguyNFT-token-dash-3 copy copy copy copy copy copy
Updated 2024-01-29
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 copy copy @ https://flipsidecrypto.xyz/edit/queries/08bfbc55-fa37-41db-aab5-6ed6a1d0f9ed
-- forked from NFT-token-dash-3 copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/35d75434-c989-4c75-bce5-3a4a416caaca
-- 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
Last run: about 1 year agoAuto-refreshes every 6 hours
16
749B
3s