SELECT

date_trunc('hour', block_timestamp) AS date,

from_address,

SUM(value) AS sei_Volume

FROM

sei.core_evm.fact_transactions

GROUP BY

1, 2

),

price_data AS (

SELECT

date_trunc('hour', INSERTED_TIMESTAMP) AS date,

AVG(PRICE) AS avg_price

FROM

osmosis.price.ez_prices

WHERE

SYMBOL = 'SEI'

GROUP BY

1

),

user_volume AS (

SELECT

td.date,

td.from_address,

td.sei_Volume,

p.avg_price,

td.sei_Volume * p.avg_price AS USD_Volume

FROM

transaction_data td

JOIN

price_data p