date(fe.INSERTED_TIMESTAMP) as txn_date

,count(distinct event_data:token) as nft_minted

,avg(ft.gas_unit_price*gas_used)/100000000 as avg_gas_price

,sum(ft.gas_unit_price*gas_used)/100000000 as gas_used

from aptos.core.fact_events fe

LEFT JOIN aptos.core.fact_transactions ft on ft.tx_hash = fe.tx_hash

where event_type = '0x4::collection::MintEvent'

and account_address in (

,'0xbdead289e28d12e4819bc17f45d979c0cf2753a28f3cd425322e1caa48e9d159'

,'0x2bed7aeca079697ec1700cc48bee658b2331d80996b05e56dfcb39fae22cbb63'

,'0x778adb39026a14009cf5aa93eb53d81299e40c7a8dbcdbf7b490cbc29749d259'

,'0xfceefe7c83abbe577f606a7fa5b98cfed37d941f38721dede6ca601b61ddc59c'

and fe.success = 'TRUE'

group by 1

order by 1

select *

from aptos.core.fact_events

where event_type = '0x4::collection::MintEvent'

and account_address in (

,'0xbdead289e28d12e4819bc17f45d979c0cf2753a28f3cd425322e1caa48e9d159'

,'0x2bed7aeca079697ec1700cc48bee658b2331d80996b05e56dfcb39fae22cbb63'

,'0x778adb39026a14009cf5aa93eb53d81299e40c7a8dbcdbf7b490cbc29749d259'

,'0xfceefe7c83abbe577f606a7fa5b98cfed37d941f38721dede6ca601b61ddc59c'

limit 10

select * from aptos.core.fact_transactions

where tx_hash = '0x855592222291b9525d9f5bafda5bdb85c5383c989e35ac32adb2d1f38b74365e'