df as (

select

date_trunc(

'{{Interval_for_charts}}',

a.BLOCK_TIMESTAMP

) as date,

a.TX_HASH,

-- CONTRACT_ADDRESS,

project_name as dApp,

FROM_ADDRESS,

TX_FEE, -- AVAX

GAS_PRICE, --nAVAX

GAS_LIMIT,

GAS_USED,

round(GAS_USED * 100 / GAS_LIMIT) as GAS_USED_PERC

FROM

avalanche.core.fact_transactions a

join avalanche.core.fact_event_logs b on a.TX_HASH = b.TX_HASH

join avalanche.core.dim_labels c on b.CONTRACT_ADDRESS = c.ADDRESS

where

STATUS = 'SUCCESS'

and label_type = 'dapp'

and date >= DATEADD(

{{Period}},

- {{ago}},

GETDATE ()

)

)

sum(TX_FEE) as sum_TX_FEE,

avg(TX_FEE) as avg_TX_FEE,

median(TX_FEE) as median_TX_FEE,

sum(GAS_USED) as sum_GAS_USED,

avg(GAS_USED) as avg_GAS_USED,

median(GAS_USED) as median_GAS_USED