HOUR | AMT_OUT | AMT_IN | NET_NEW_HOLDERS | TOTAL_HOLDERS | |
|---|---|---|---|---|---|
1 | 2024-01-30 01:00:00.000 | 0 | 0 | 0 | 2837 |
2 | 2024-01-30 00:00:00.000 | 1 | 2 | 1 | 2837 |
3 | 2024-01-29 23:00:00.000 | 2 | 0 | -2 | 2836 |
4 | 2024-01-29 22:00:00.000 | 0 | 2 | 2 | 2838 |
5 | 2024-01-29 21:00:00.000 | 2 | 2 | 0 | 2836 |
6 | 2024-01-29 20:00:00.000 | 0 | 3 | 3 | 2836 |
7 | 2024-01-29 19:00:00.000 | 2 | 2 | 0 | 2833 |
8 | 2024-01-29 18:00:00.000 | 0 | 1 | 1 | 2833 |
9 | 2024-01-29 17:00:00.000 | 1 | 2 | 1 | 2832 |
10 | 2024-01-29 16:00:00.000 | 0 | 0 | 0 | 2831 |
11 | 2024-01-29 15:00:00.000 | 1 | 2 | 1 | 2831 |
12 | 2024-01-29 14:00:00.000 | 1 | 3 | 2 | 2830 |
13 | 2024-01-29 13:00:00.000 | 3 | 2 | -1 | 2828 |
14 | 2024-01-29 12:00:00.000 | 0 | 2 | 2 | 2829 |
15 | 2024-01-29 11:00:00.000 | 0 | 0 | 0 | 2827 |
16 | 2024-01-29 10:00:00.000 | 0 | 3 | 3 | 2827 |
17 | 2024-01-29 09:00:00.000 | 0 | 2 | 2 | 2824 |
18 | 2024-01-29 08:00:00.000 | 1 | 0 | -1 | 2822 |
19 | 2024-01-29 07:00:00.000 | 0 | 2 | 2 | 2823 |
20 | 2024-01-29 06:00:00.000 | 2 | 2 | 0 | 2821 |
jackguyNFT-token-dash-5
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
›
⌄
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 '{{ token }}'
OR token1_symbol LIKE '{{ token }}' )
), tab2 as (
SELECT
block_timestamp,
tx_hash,
user,
sum(CASE when flow like 'out' then -1 * amount else amount end) as net_flow
FROM (
SELECT
block_timestamp,
tx_hash,
from_address as user,
'out' as flow,
RAW_AMOUNT_PRECISE::NUMBER(38, 0) as AMOUNT
from ethereum.core.fact_token_transfers
WHERE contract_address in (SELECT * FROM tab1)
UNION
SELECT
block_timestamp,
Last run: about 1 year agoAuto-refreshes every 3 hours
...
2493
96KB
80s