LTirrellNFTs Whale with metadata
Updated 2023-08-02
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
large_sales as (
select
block_timestamp,
marketplace,
tx_id,
purchaser,
mint,
sales_amount,
p.close as sol_price,
(sales_amount * sol_price) as usd_amount,
l.address_name,
l.label,
l.label_subtype,
l.label_type
from
solana.core.fact_nft_sales
join solana.core.ez_token_prices_hourly p on date_trunc(hour, block_timestamp) = p.recorded_hour
left join solana.core.dim_labels l on l.address = mint
where
date(block_timestamp) >= current_date() -30
and p.token_address = 'So11111111111111111111111111111111111111112'
and usd_amount >= 1000
and succeeded = 'true'
order by
block_timestamp desc
),
mints as (
select distinct
mint as m
from
large_sales
),
mints_with_rn as (
select
m,
Run a query to Download Data