Date | Number of Holders | |
|---|---|---|
1 | 2021-12-22 00:00:00.000 | 15 |
2 | 2021-12-23 00:00:00.000 | 17 |
3 | 2021-12-29 00:00:00.000 | 18 |
4 | 2022-01-02 00:00:00.000 | 19 |
5 | 2022-01-04 00:00:00.000 | 27 |
6 | 2022-01-05 00:00:00.000 | 39 |
7 | 2022-01-06 00:00:00.000 | 43 |
8 | 2022-01-07 00:00:00.000 | 45 |
9 | 2022-01-08 00:00:00.000 | 47 |
10 | 2022-01-10 00:00:00.000 | 48 |
11 | 2022-01-11 00:00:00.000 | 52 |
12 | 2022-01-12 00:00:00.000 | 53 |
13 | 2022-01-13 00:00:00.000 | 563 |
14 | 2022-01-14 00:00:00.000 | 564 |
15 | 2022-01-15 00:00:00.000 | 575 |
16 | 2022-01-16 00:00:00.000 | 577 |
17 | 2022-01-17 00:00:00.000 | 589 |
18 | 2022-01-18 00:00:00.000 | 592 |
19 | 2022-01-19 00:00:00.000 | 593 |
20 | 2022-01-20 00:00:00.000 | 595 |
Eman-RazTotal Number of AXL Holders Over Time (Not Optimized Query)
Updated 2 days ago
999
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 holders_data as (
--------------------------------------------------------------------arbitrum
with arbitrum as (with transactions as (
select
block_timestamp :: date as date,
from_address as address,
- amount as amount
from
arbitrum.core.ez_token_transfers
where
contract_address = lower('0x23ee2343B892b1BB63503a4FAbc840E0e2C6810f')
union
all
select
block_timestamp :: date as date,
to_address as address,
amount as amount
from
arbitrum.core.ez_token_transfers
where
contract_address = lower('0x23ee2343B892b1BB63503a4FAbc840E0e2C6810f')
),
date_list as (
select
block_timestamp :: date as date
from
arbitrum.core.ez_token_transfers
where
block_timestamp :: date >= '2022-12-01'
),
all_dates AS (
SELECT
DISTINCT date
FROM
date_list
),
Last run: 2 days agoAuto-refreshes every 24 hours
...
1088
36KB
1016s