WEEKLY | New Buyers | Cumulative New Buyers | |
|---|---|---|---|
1 | 2023-06-05 00:00:00.000 | 56 | 2648 |
2 | 2024-07-22 00:00:00.000 | 9 | 6030 |
3 | 2023-01-16 00:00:00.000 | 92 | 394 |
4 | 2023-08-14 00:00:00.000 | 26 | 3063 |
5 | 2023-10-30 00:00:00.000 | 37 | 3717 |
6 | 2024-01-15 00:00:00.000 | 42 | 4505 |
7 | 2024-03-25 00:00:00.000 | 54 | 5161 |
8 | 2023-10-09 00:00:00.000 | 43 | 3550 |
9 | 2023-07-24 00:00:00.000 | 38 | 2984 |
10 | 2024-02-26 00:00:00.000 | 100 | 4827 |
11 | 2023-04-17 00:00:00.000 | 99 | 1880 |
12 | 2024-04-22 00:00:00.000 | 84 | 5482 |
13 | 2023-08-07 00:00:00.000 | 30 | 3037 |
14 | 2024-11-25 00:00:00.000 | 64 | 6521 |
15 | 2024-02-05 00:00:00.000 | 36 | 4615 |
16 | 2023-01-23 00:00:00.000 | 188 | 582 |
17 | 2024-10-07 00:00:00.000 | 10 | 6203 |
18 | 2024-12-09 00:00:00.000 | 47 | 6620 |
19 | 2023-06-12 00:00:00.000 | 46 | 2694 |
20 | 2024-07-29 00:00:00.000 | 9 | 6039 |
hessWeekly New Buyers
Updated 2025-01-26
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 price as ( select hour::date as date,
avg(price) as avg_price
from flow.price.ez_prices_hourly
where symbol = 'FLOW'
group by 1
)
,
base as (select block_timestamp,
tx_id,
nft_id,
buyer,
price,
seller,
case when currency ilike '%flow%' then price*avg_price else price end as price_usd
from flow.nft.ez_nft_sales a left outer join price b on a.block_timestamp::date = b.date
where nft_collection = 'A.0b2a3299cc857e29.TopShot'
)
,
base1 as ( select *
from flow.core.fact_events
where event_type in ('OfferCompleted','ListingCompleted')
and event_contract in ('A.3cdbb3d569211ff3.NFTStorefrontV2','A.b8ea91944fd51c43.OffersV2')
and tx_succeeded = 'true'
and event_data:purchased = 'true')
,
base2 as ( select EVENT_DATA:offerAddress::string as buyer,
EVENT_DATA:offerAmount::float as sales_amount,
EVENT_DATA:offerType::string as collection,
EVENT_DATA:nftId::integer as nft_id,
EVENT_DATA:paymentVaultType as token,
tx_id,
trunc(block_timestamp,'day') as day
from base1
where event_type = 'OfferCompleted'
AND event_data::string like '%0x6590f8918060ef13%')
,
Last run: 3 months ago
...
109
4KB
133s