info as (

select x.block_timestamp, x.event_data:id as inscription, x.tx_id

from flow.core.fact_events x

where

x.block_timestamp>'2023-12-20'

and x.event_contract='A.d2abb5dbf5e08666.Fixes'

and x.event_type='InscriptionCreated'

and x.event_data:metaProtocol='frc20'

),

info2 as (

select x.block_timestamp, x.event_data:value as paid

from flow.core.fact_events x

where x.block_timestamp>'2023-12-20'

and x.event_contract='A.d2abb5dbf5e08666.Fixes'

and x.event_type='InscriptionCreated'

and x.event_data:metaProtocol='frc20'

),

info3 as (

select y.block_timestamp, y.event_data:to as account

from flow.core.fact_events y

where y.block_timestamp>'2023-12-20'

and tx_id in (select tx_id from info)

and y.event_contract='A.d2abb5dbf5e08666.FRC20Indexer'

and y.event_type='FRC20Minted'

),

info4 as (

select event_data:value/0.2162 as n_inscriptions

from flow.core.fact_events y

where y.block_timestamp>'2023-12-20'

and tx_id in (select tx_id from info)

and y.event_contract='A.d2abb5dbf5e08666.Fixes'

and y.event_type='InscriptionExtracted'