HOUR | NEW_HOLDERS | |
|---|---|---|
1 | 2024-01-23 03:00:00.000 | 1 |
2 | 2024-01-25 07:00:00.000 | 1 |
3 | 2024-01-22 17:00:00.000 | 1 |
4 | 2024-01-25 08:00:00.000 | 1 |
5 | 2024-01-27 08:00:00.000 | 1 |
6 | 2024-01-28 11:00:00.000 | 2 |
7 | 2024-01-22 20:00:00.000 | 1 |
8 | 2024-01-22 08:00:00.000 | 1 |
9 | 2024-01-28 13:00:00.000 | 1 |
10 | 2024-01-24 06:00:00.000 | 1 |
11 | 2024-01-28 19:00:00.000 | 1 |
12 | 2024-01-23 21:00:00.000 | 1 |
13 | 2024-01-21 05:00:00.000 | 1 |
14 | 2024-01-20 00:00:00.000 | 1 |
15 | 2024-01-29 21:00:00.000 | 1 |
16 | 2024-01-19 20:00:00.000 | 1 |
17 | 2024-01-26 14:00:00.000 | 1 |
18 | 2024-01-16 21:00:00.000 | 1 |
19 | 2024-01-18 11:00:00.000 | 1 |
20 | 2024-01-24 23:00:00.000 | 1 |
jackguyNFT-token-dash-7 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-7 copy copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/560ed0ee-aeff-4991-9675-c09864c7995a
-- forked from NFT-token-dash-7 copy copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/7f331313-9c63-40dc-8391-98e7f36a704f
-- forked from NFT-token-dash-7 copy copy copy copy @ https://flipsidecrypto.xyz/edit/queries/09929711-54c8-4c99-af5b-f3d8cf480d9b
-- forked from NFT-token-dash-7 copy copy copy @ https://flipsidecrypto.xyz/edit/queries/6b3b24a6-64a8-491f-9be0-9d3831479ad9
-- forked from NFT-token-dash-7 copy copy @ https://flipsidecrypto.xyz/edit/queries/4f3b0477-cf6d-4d31-88b7-80e2480fb4b5
-- forked from NFT-token-dash-7 copy @ https://flipsidecrypto.xyz/edit/queries/920256b9-5fd2-47ec-bec6-faa83a54ba43
-- forked from NFT-token-dash-7 @ https://flipsidecrypto.xyz/edit/queries/47272795-20b4-4026-9d6c-26c083cae91e
with tab1 as (
SELECT
case when TOKEN1_SYMBOL LIKE 'WETH' then TOKEN0_ADDRESS else TOKEN1_ADDRESS end as token
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' )
)
SELECT
hour,
count(*) as new_holders
Last run: about 1 year agoAuto-refreshes every 6 hours
21
631B
122s