daus as (

SELECT distinct

sender as users,

trunc(block_timestamp, 'week') as weeks,

count(distinct trunc(block_timestamp, 'day')) as active_days

from

aptos.core.fact_transactions

group by

1,

2

having

active_days >= 4),

pc as (

select

HOUR::date as days ,

SYMBOL ,

TOKEN_ADDRESS ,

avg(PRICE) as pricee

from

aptos.price.ez_hourly_token_prices

group by 1,2,3

,

middle as (

select

t.* , symbol , DECIMALS

from

aptos.core.fact_transfers t join aptos.core.dim_tokens

using (TOKEN_ADDRESS)