HOUR1 | SWAPPERS | HOUR2 | SWAPS | SWAP_VOLUME_USD | |
|---|---|---|---|---|---|
1 | 2024-01-26 09:00:00.000 | 1 | 2024-01-26 09:00:00.000 | 2 | 1770.31 |
2 | 2024-01-22 20:00:00.000 | 1 | 2024-01-22 20:00:00.000 | 1 | 241.52 |
3 | 2024-01-26 23:00:00.000 | 1 | 2024-01-26 23:00:00.000 | 1 | 905.79 |
4 | 2024-01-15 15:00:00.000 | 2 | 2024-01-15 15:00:00.000 | 3 | 14049.38 |
5 | 2024-01-26 18:00:00.000 | 1 | 2024-01-26 18:00:00.000 | 1 | 1570.74 |
6 | 2024-01-27 21:00:00.000 | 3 | 2024-01-27 21:00:00.000 | 3 | 3675.52 |
7 | 2024-01-27 03:00:00.000 | 3 | 2024-01-27 03:00:00.000 | 3 | 3999.68 |
8 | 2024-01-14 06:00:00.000 | 1 | 2024-01-14 06:00:00.000 | 1 | 2249.73 |
9 | 2024-01-23 03:00:00.000 | 1 | 2024-01-23 03:00:00.000 | 1 | 4.95 |
10 | 2024-01-14 04:00:00.000 | 1 | 2024-01-14 04:00:00.000 | 1 | 804.94 |
11 | 2024-01-17 18:00:00.000 | 1 | 2024-01-17 18:00:00.000 | 1 | 1412.16 |
12 | 2024-01-15 00:00:00.000 | 1 | 2024-01-15 00:00:00.000 | 1 | 1066.48 |
13 | 2024-01-15 14:00:00.000 | 1 | 2024-01-15 14:00:00.000 | 1 | 1228.3 |
14 | 2024-01-20 18:00:00.000 | 1 | 2024-01-20 18:00:00.000 | 1 | 1542.18 |
15 | 2024-01-15 05:00:00.000 | 1 | 2024-01-15 05:00:00.000 | 1 | 689.64 |
16 | 2024-01-22 08:00:00.000 | 3 | 2024-01-22 08:00:00.000 | 4 | 17971.55 |
17 | 2024-01-20 21:00:00.000 | 1 | 2024-01-20 21:00:00.000 | 1 | 1249.06 |
18 | 2024-01-22 02:00:00.000 | 1 | 2024-01-22 02:00:00.000 | 1 | 491.45 |
19 | 2024-01-19 08:00:00.000 | 1 | 2024-01-19 08:00:00.000 | 1 | 1522.44 |
20 | 2024-01-29 02:00:00.000 | 3 | 2024-01-29 02:00:00.000 | 6 | 5298.84 |
jackguyNFT-token-dash-1 copy 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-1 copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/79cd0bd7-9a06-484c-bdb1-4187878d2b93
-- forked from NFT-token-dash-1 copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/0961a38b-4bec-4b94-9077-68bf69839322
-- forked from NFT-token-dash-1 copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/c22193c1-5207-4759-bbc1-7013d9ab739e
-- forked from NFT-token-dash-1 copy copy copy @ https://flipsidecrypto.xyz/edit/queries/86638ee4-63b4-4e26-8b80-09910687f573
-- forked from NFT-token-dash-1 copy copy @ https://flipsidecrypto.xyz/edit/queries/dd52b3cb-9155-4ca5-927d-7e0faacc0aa6
-- forked from NFT-token-dash-1 copy @ https://flipsidecrypto.xyz/edit/queries/52c3fb30-3b47-48e9-8032-828861f0a877
-- forked from NFT-token-dash-1 @ https://flipsidecrypto.xyz/edit/queries/587397d5-88b0-482d-8623-2ad6031ef252
with tab1 as (
SELECT
date_trunc('hour', block_timestamp) as hour1,
count(DISTINCT from_address) as swappers
FROM ethereum.core.fact_transactions
WHERE tx_hash in (
SELECT
DISTINCT tx_hash
FROM ethereum.uniswapv3.ez_swaps
where pool_address IN (
lower('0x5ee84bed805df225ee23aec4160cc0bfcf1bd892'),
lower('0xe72377ae353edc1d07f6c0be34969a481d030d19'),
lower('0x882784c5807d5e2e4950ae2327ca5d9b56a1015a'),
lower('0x92741be6adcb2722681925afce9af0a7306ce90f'),
lower('0x4a382e0fb2abc4bc087d2f7953a4689ecbb96374'),
lower('0xb17015d33c97a2caca73be2a8669076a333fd43d'),
lower('0x01a8227d4e7c3068ad1000c97a059af5c5fa3476')
)
AND ( token0_symbol LIKE 'μELEM'
OR token1_symbol LIKE 'μELEM' )
AND BLOCK_TIMESTAMP > current_date - {{ past_days }}
)
Last run: about 1 year agoAuto-refreshes every 6 hours
97
6KB
11s