avg(CLOSE) as price

from

crosschain.core.fact_hourly_prices

where

ID ilike 'terra-luna-2'

and

RECORDED_HOUR::date >= '2022-01-01'

group by 1)

,raw as (select

t.*,

AMOUNT*price/1e6 AS usd_Volume

from terra.core.ez_transfers t , prices p

where BLOCK_TIMESTAMP::date = date

and CURRENCY='uluna')

select

iff(BLOCK_TIMESTAMP::date ilike '2022%', '2022', '2023') as type,

count(distinct TX_ID) AS txns,

count(distinct SENDER) AS act_users,

sum(usd_Volume) AS volume,

volume/act_users as volume_per_sender,

volume/txns as volume_per_tx,

volume/count(distinct BLOCK_TIMESTAMP::date ) as volume_per_day,

txns/act_users as txs_per_user,

txns/count(distinct BLOCK_TIMESTAMP::date ) as txs_per_day,

act_users/count(distinct BLOCK_TIMESTAMP::date ) as wallets_per_day

from raw

group by 1