purifCubquest - Badges mint
Updated 2024-10-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
--this is per event, so can be multiple transfers per tx_hash, amount here refers to
select badge_id, minters_count, minted_amount, sum(minted_amount) over (order by badge_id) as cum_minted, count(badge_id) over (order by badge_id) as badges,
avg(minters_count) over (order by badge_id) as avg_minters from (
select badge_id, count(distinct minter) as minters_count, sum(minted_amount) as minted_amount, max(minted_amount) as max_mintable from (
select tx_hash,decoded_log['amount'] as minted_amount, decoded_log['id'] as badge_id, decoded_log['to'] as minter from berachain.testnet.fact_decoded_event_logs
where CONTRACT_ADDRESS=lower('0x886D2176D899796cD1AfFA07Eff07B9b2B80f1be')
and decoded_log['from']=lower('0x0000000000000000000000000000000000000000')
)
group by 1
order by badge_id desc
)
order by badge_id desc
QueryRunArchived: QueryRun has been archived