DATE | ASSET | NFT_SALES | VOLUME | TOTAL_VOLUME | AVG_NFT_PRICE | |
|---|---|---|---|---|---|---|
1 | 2025-03-01 00:00:00.000 | A.f1ab99c82dee3526.USDCFlow.Vault | 10927 | 24136.7 | 153989.7 | 1.104806152 |
2 | 2025-02-01 00:00:00.000 | A.f1ab99c82dee3526.USDCFlow.Vault | 7371 | 16941.5 | 129853 | 1.139920603 |
3 | 2025-01-01 00:00:00.000 | A.f1ab99c82dee3526.USDCFlow.Vault | 17646 | 43045.25 | 112911.5 | 1.214183967 |
4 | 2024-12-01 00:00:00.000 | A.f1ab99c82dee3526.USDCFlow.Vault | 20785 | 48838.3 | 69866.25 | 1.171491281 |
5 | 2024-11-01 00:00:00.000 | A.f1ab99c82dee3526.USDCFlow.Vault | 10030 | 21027.95 | 21027.95 | 1.043726113 |
adriaparcerisasapp bz 3
Updated 4 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
trunc(y.block_timestamp,'month') as date,
y.event_data:type as asset,
count(distinct y.tx_id) as nft_sales,
sum(y.event_data:amount) as volume,
sum(volume) over (order by date) as total_volume,
avg(y.event_data:amount) as avg_nft_price
from flow.core.fact_events x join flow.core.fact_events y on x.tx_id=y.tx_id
where x.block_timestamp>'2024-01-01' and x.tx_succeeded='TRUE' and x.event_contract='A.7d09be7121e058eb.NBAsageNFT' and x.event_type='NFTPurchased'
and x.event_data:name='NBAsage Yes' and y.event_type='Deposited' and y.event_data:to<>'0xf919ee77447b7497' and y.event_data:amount is not null
group by 1,2 order by 1 desc
-- per saber volume, event_type='Deposited' and event_data:to <> '0xf919ee77447b7497' -- es nomes per fees
-- agafar el event_data:amount i el event_data:to com a seller i el event_data:type com a moneda
Last run: 4 days ago
5
495B
20s