"Project",

"Transactions",

"AUs",

"Fees",

from

(select

date_trunc({{period_type}}, BLOCK_TIMESTAMP) as "Date",

iff( INITCAP(LABEL)='Move Dollar','Thala',INITCAP(LABEL)) as "Project",

count(*) as "Transactions",

count(distinct sender) as "AUs",

sum(((gas_used * gas_unit_price)/1e8)) as "Fees",

from (

select *,

from aptos.core.fact_events

where SUCCESS=true

and BLOCK_TIMESTAMP::date>='{{start_day}}'

-- and date_trunc({{period_type}}, BLOCK_TIMESTAMP)<='{{target_day}}'

) a

left join aptos.core.dim_labels b

on address = event_address

join aptos.core.fact_transactions using(tx_hash)

group by 1,2

)

where "Date" ='{{start_day}}' and "Date" <='{{target_day}}'

and "Project" is not NULL

and "Project" != 'Aptos'

order by "AUs" desc

limit 10