DAY | MARKETPLACE | N_TXS | AMOUNT_USD | |
|---|---|---|---|---|
1 | 2025-01-01 00:00:00.000 | tensorswap | 163 | 17181.383810739 |
2 | 2024-12-21 00:00:00.000 | magic eden | 127 | 26444.084663329 |
3 | 2025-01-04 00:00:00.000 | exchange art | 2 | 129.790407343 |
4 | 2025-01-04 00:00:00.000 | tensorswap | 142 | 16031.866969696 |
5 | 2024-12-20 00:00:00.000 | tensorswap | 351 | 49904.842532032 |
6 | 2024-12-24 00:00:00.000 | magic eden | 60 | 9158.479841677 |
7 | 2024-12-20 00:00:00.000 | magic eden | 132 | 23566.08660012 |
8 | 2025-01-02 00:00:00.000 | magic eden | 107 | 35248.256607265 |
9 | 2025-01-10 00:00:00.000 | tensorswap | 102 | 16052.608950076 |
10 | 2024-12-26 00:00:00.000 | magic eden | 107 | 10222.967126185 |
11 | 2025-01-10 00:00:00.000 | magic eden | 91 | 5936.823873119 |
12 | 2025-01-12 00:00:00.000 | tensorswap | 213 | 8206.26659535 |
13 | 2024-12-21 00:00:00.000 | tensorswap | 475 | 52309.726935968 |
14 | 2025-01-03 00:00:00.000 | hadeswap | 1 | 6181.74009111 |
15 | 2025-01-07 00:00:00.000 | magic eden | 103 | 25163.281950136 |
16 | 2024-12-29 00:00:00.000 | tensorswap | 214 | 32485.390123816 |
17 | 2024-12-20 00:00:00.000 | exchange art | 2 | 317.616589733 |
18 | 2024-12-18 00:00:00.000 | hadeswap | 1 | 794.090207232 |
19 | 2025-01-11 00:00:00.000 | magic eden | 88 | 67469.404824493 |
20 | 2025-01-03 00:00:00.000 | magic eden | 122 | 45440.641081538 |
ArioBONK Holders Activity - NFT - Daily - [10M-100M $BONK)
Updated 2025-01-16
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
›
⌄
with address_balance as (
select
OWNER,
BALANCE,
row_number() over(partition by owner order by block_timestamp desc) as rank
from solana.core.fact_token_balances
where SUCCEEDED
and mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
),
Holders as (
select owner as Holder_Address,
BALANCE
from address_balance
where balance > 0
and rank = 1
)
select
date_trunc(day, block_timestamp) as day,
case when MARKETPLACE ilike 'magic eden%' then 'magic eden' else MARKETPLACE end as MARKETPLACE,
count(DISTINCT tx_id) as N_TXs,
sum(SALES_AMOUNT * price) as Amount_USD
-- count(DISTINCT SELLER) as N_Sellers,
-- count(DISTINCT PURCHASER) as N_Buyers
from solana.nft.fact_nft_sales join solana.price.ez_prices_hourly on date_trunc(hour, block_timestamp) = hour and token_address = 'So11111111111111111111111111111111111111112'
join Holders on (fact_nft_sales.SELLER = Holders.Holder_Address or fact_nft_sales.PURCHASER = Holders.Holder_Address)
where 1=1
and block_timestamp >= current_timestamp - interval '29 Days'
and SUCCEEDED
and BALANCE between pow(10,7) and pow(10,8)
group by 1,2
Last run: 3 months ago
85
5KB
366s