SELECT

COUNT(DISTINCT from_address) AS active_users,

COUNT(DISTINCT tx_hash) AS transactions,

SUM(value) AS txn_volume

FROM kaia.core.fact_transactions

WHERE tx_succeeded = 'TRUE'

AND block_timestamp::date >= '2024-09-25' -- Kaia Wave Launch

),

usd_stats AS (

SELECT

AVG(price) AS price

FROM kaia.price.ez_prices_hourly

WHERE symbol = 'KAIA'

AND hour::date >= '2024-09-25'

k.active_users,

k.transactions,

k.txn_volume AS total_txn_volume,

ROUND(txn_volume * (SELECT price FROM usd_stats), 2) AS USD_txn_volume

FROM Kaia_stats k