df as (

select

date_trunc(

'{{Interval_for_charts}}',

a.BLOCK_TIMESTAMP

) as date,

a.TX_HASH,

-- CONTRACT_ADDRESS,

NAME as contract_name,

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_contracts c on b.CONTRACT_ADDRESS = c.ADDRESS

where

STATUS = 'SUCCESS'

and NAME is not null

and date >= DATEADD(

{{Period}},

- {{ago}},

GETDATE ()

)

)

date,

count(DISTINCT contract_name) as count_contracts,

count(DISTINCT TX_HASH) as count_transactions,

count(DISTINCT FROM_ADDRESS) as count_users,

sum(TX_FEE) as sum_TX_FEE,

sum(sum_TX_FEE) over (