price_token AS

SELECT

date_trunc( 'day' , a.recorded_hour ) AS date

, avg( a.price ) AS price_usd

, a.symbol AS token_name

, a.currency AS token_address

FROM

osmosis.core.ez_prices a

GROUP BY

1 , 3 , 4

SELECT

sum( ( a.from_amount / power( 10 , a.from_decimal ) ) * b.price_usd ) AS swap_from_ARB

, b.token_name AS token_names

FROM

osmosis.core.fact_swaps a

INNER JOIN

price_token b

ON

date_trunc( 'day' , a.block_timestamp ) = b.date

AND a.from_currency = b.token_address