dai_price as (

SELECT

trunc(hour,'day') as date,

avg(price) as dai_price

from ethereum.core.fact_hourly_token_prices where token_address='0x6b175474e89094c44da98b954eedeac495271d0f' --dai token address

GROUP BY 1

),

labels as (

SELECT

address,

address_name

from gnosis.core.dim_labels

),

tx_user as (

SELECT

distinct from_address,

trunc(block_timestamp,'day') as date,

count(distinct tx_hash) as txs_user

from gnosis.core.fact_transactions where date >= '2022-09-01'

group by 1,2

),

tx_user_2 as (

select date,

avg(txs_user) as avg_txs_user

from tx_user

group by 1

),

transactions as (

SELECT

trunc(block_timestamp,'day') as date,

count(distinct tx_hash) as txs,

count(distinct from_address) as active_users,

sum(tx_fee) as fees,

avg(tx_fee) as avg_tx_fee

from gnosis.core.fact_transactions x