SWAPPERS | SWAPS | SWAP_VOLUME_USD | |
|---|---|---|---|
1 | 15 | 50 | 24559.22 |
jackguyNFT-token-dash-2 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-2 copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/63e08cb5-aa64-45cc-a439-acef2d9c4038
-- forked from NFT-token-dash-2 copy copy copy @ https://flipsidecrypto.xyz/edit/queries/a848c242-0ca1-4946-9cf2-a289e0e2c03c
-- forked from NFT-token-dash-2 copy copy @ https://flipsidecrypto.xyz/edit/queries/23ec246c-fb26-4db0-856b-98ddf4866e14
-- forked from NFT-token-dash-2 copy @ https://flipsidecrypto.xyz/edit/queries/6c3da969-2839-4494-849a-dc58aaaf98ea
-- forked from NFT-token-dash-2 @ https://flipsidecrypto.xyz/edit/queries/ae20edbf-0e97-4651-ab61-9fb52f1c92bd
with tab1 as (
SELECT
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 'μy00t'
OR token1_symbol LIKE 'μy00t' )
AND BLOCK_TIMESTAMP > current_date - {{ past_days }}
)
), tab2 as (
SELECT
count(DISTINCT tx_hash) as swaps,
sum(
ABS(case when TOKEN1_SYMBOL LIKE 'WETH' then AMOUNT1_USD else AMOUNT0_USD end)
Last run: about 1 year agoAuto-refreshes every 6 hours
1
18B
12s