select

date_hour as block_time

from crosschain.core.dim_date_hours

where date_hour >= current_date - interval'30 days'

union all

select

dateadd('minute', 15, date_hour) as block_time

from crosschain.core.dim_date_hours

where date_hour >= current_date - interval'30 days'

union all

select

dateadd('minute', 30, date_hour) as block_time

from crosschain.core.dim_date_hours

where date_hour >= current_date - interval'30 days'

union all

select

dateadd('minute', 45, date_hour) as block_time

from crosschain.core.dim_date_hours

where date_hour >= current_date - interval'30 days'

, bal_v2_pool as (

select

block_number

, time_slice(block_timestamp, 15, 'minute') as block_time

, 'Bal V2 WMATIC/MaticX' as feed

, 2 as sort_order

, event_inputs:amountIn/1e18 as wmatic_amount

, event_inputs:amountOut/1e18 as maticx_amount

, div0(wmatic_amount, maticx_amount) as wmatic_maticx_price

from polygon.core.fact_event_logs

where contract_address = '0xba12222222228d8ba445958a75a0704d566bf2c8' -- Balancer V2 Vault

and block_timestamp >= current_date - interval'30 days'