SELECT date_trunc('month', block_timestamp) as weekly

, sum(amount) as inflow

from ethereum.udm_events U

where weekly > '2021-01-01'

and to_address ='0x8798249c2e607446efb7ad49ec89dd1865ff4272'

group by 1

,

outflow_xsushi as(

SELECT date_trunc('month', block_timestamp) as weekly

, sum(amount) as OUtflo

from ethereum.udm_events U

where weekly > '2021-01-01'

and from_address ='0x8798249c2e607446efb7ad49ec89dd1865ff4272'

group by 1

, flow as(

SELECT I.weekly , inflow, -outflo as outflow , inflow-outflo as net_flow

from inflow_xsushi I , outflow_xsushi O

where I.weekly = O.weekly

) ,

price as (

SELECT date_trunc('month', hour) as weekly , max(price) as xsushi_price , min(price) as min_price

from ethereum.token_prices_hourly

where symbol = 'xSUSHI'

and weekly > '2021-01-01'

group by 1

)

SELECT P.weekly , xsushi_price as monthly_maximum_price , net_flow , min_price as monthly_minimum_price

from price P , flow F

where P.weekly = F.weekly