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 CONTRACT_ADDRESS = '{{Contract_address}}'

),

newusers as (

SELECT DISTINCT

FROM_ADDRESS as wallet,

min(date) as joindate

from

df

group by

1

)

date,