MLDZMNnfts1
Updated 2023-04-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- thanks to marqu for valubel tips
with tb2 as (select
RECORDED_HOUR::date as day,
avg(close) as price_token
from solana.core.fact_token_prices_hourly where SYMBOL='SOL'
group by 1)
select
count(distinct tx_id) as no_mints,
count(distinct INSTRUCTION:accounts[1]) as no_minter,
count(distinct SIGNERS[0]) as no_collections,
no_mints/no_minter as average_mint_minter,
no_mints/count(distinct date_trunc(day, block_timestamp)) as average_mint_day,
no_minter/count(distinct date_trunc(day, block_timestamp)) as average_minter_day
from solana.core.fact_events
where PROGRAM_ID ='BGUMAp9Gq7iTEuizy4pqaxsTyUCBK68MDfK752saRPUY'
and SUCCEEDED ='TRUE'
and BLOCK_TIMESTAMP>='2023-04-06'
limit 10
Run a query to Download Data