day | no of $BMT holders | |
|---|---|---|
1 | 2025-03-11 00:00:00.000 | 44114 |
2 | 2025-03-12 00:00:00.000 | 43412 |
3 | 2025-03-13 00:00:00.000 | 42967 |
4 | 2025-03-14 00:00:00.000 | 42157 |
5 | 2025-03-15 00:00:00.000 | 41392 |
6 | 2025-03-16 00:00:00.000 | 41130 |
7 | 2025-03-17 00:00:00.000 | 39563 |
8 | 2025-03-18 00:00:00.000 | 35379 |
9 | 2025-03-10 00:00:00.000 | 7 |
10 | 2025-03-09 00:00:00.000 | 3 |
11 | 2025-03-07 00:00:00.000 | 2 |
12 | 2025-03-08 00:00:00.000 | 2 |
13 | 2025-03-01 00:00:00.000 | 1 |
14 | 2025-03-04 00:00:00.000 | 1 |
15 | 2025-02-27 00:00:00.000 | 1 |
16 | 2025-03-02 00:00:00.000 | 1 |
17 | 2025-03-03 00:00:00.000 | 1 |
18 | 2025-03-06 00:00:00.000 | 1 |
19 | 2025-02-26 00:00:00.000 | 1 |
20 | 2025-02-28 00:00:00.000 | 1 |
defi__joshDaily token holders for EVM compactible chains (AVAX & BSC)
Updated 2025-03-19
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
›
⌄
⌄
/*
daily
*/
--- DAILY HOLDERS OF BMT TOKEN (CA: 0x7d814b9eD370Ec0a502EdC3267393bF62d891B62)
--- https://bscscan.com/ (BSC blockchain explorer)
-- a list of all possible addresses
-- a list of dates from when the token was created (2025-02-26) to 2025-03-18
with raw as (
select
block_timestamp,
from_address,
to_address,
amount
from bsc.core.ez_token_transfers
where contract_address = lower('0x7d814b9eD370Ec0a502EdC3267393bF62d891B62')
and block_timestamp::date >= '2025-02-26'
),
addresses as (
select
distinct to_address as address
from raw
),
all_dates as (
select
date_day as days
from crosschain.core.dim_dates
where date_day::date between '2025-02-26' and '2025-03-18'
),
Last run: about 1 month ago
21
663B
8s