-- forked from Playwo / Volume @ https://flipsidecrypto.xyz/Playwo/q/O1su8dcL4eGP/volume

WITH timeframe AS (

SELECT

date_trunc('{{Time_Interval}}',date_day) AS date

FROM crosschain.core.dim_dates

WHERE date_day >= TO_DATE('{{start_date}}')

AND date_day < CURRENT_DATE()

),

osmo_levana_contracts AS (

SELECT $1 AS contract_address, $2 AS asset, $3 AS asset_decimals

FROM (VALUES

('osmo1nzddhaf086r0rv0gmrepn3ryxsu9qqrh7zmvcexqtfmxqgj0hhps4hruzu', 'BTC', 6),

('osmo1hd7r733w49wrqnxx3daz4gy7kvdhgwsjwn28wj7msjfk4tde89aqjqhu8x', 'ATOM', 6),

('osmo127aqy4697zqn27z0vqr3x2n8lraf27t7udvl6ef5hcwmwhjadegq9vytdj', 'OSMO', 6),

('osmo19c7hdlfvu7cddr0smfz9luaj8375qhfr3s0gtsk087laqfzxlu3qsnk47e', 'ETH', 6),

('osmo186nlf2fwfglq8u4nj3f7mwg8uc79j22qhaau4scdyur47e0fatas34vcn9', 'SEI', 6)

)

),

osmo_volume_events AS (

SELECT

a__contract_address.tx_id,

a__contract_address.block_timestamp,

a__contract_address.attribute_value AS contract,

a_volume_usd.attribute_value AS volume_usd

FROM

osmosis.core.fact_msg_attributes AS a__contract_address,

osmosis.core.fact_msg_attributes AS a_volume_usd

WHERE a__contract_address.block_timestamp > (SELECT min(date) FROM timeframe)

AND a__contract_address.attribute_key = '_contract_address'

AND a_volume_usd.attribute_key = 'volume-usd'

AND a__contract_address.tx_id = a_volume_usd.tx_id

AND a__contract_address.msg_index = a_volume_usd.msg_index

AND (a__contract_address.msg_group = a_volume_usd.msg_group