-- forked from OP Buy Sell Copy copy @ https://flipsidecrypto.xyz/edit/queries/2cb15429-4aa2-44ee-acc0-4de7696a5484

-- forked from ARB Buy Sell Copy @ https://flipsidecrypto.xyz/edit/queries/f28d112f-4b1a-4e87-86dd-cb8f5d59399e

-- forked from WBTC Buy/ Sell @ https://flipsidecrypto.xyz/edit/queries/1251b161-7be3-4989-9acd-2d376f77b1e1

-- forked from ETH Buy and Sell @ https://flipsidecrypto.xyz/edit/queries/3dd736dd-e4fe-4805-a12a-8282f2f88fe7

WITH buys AS(

select

date_trunc('hour',BLOCK_TIMESTAMP) AS DATE,

SUM(amount_out) AS total_bought

from polygon.core.ez_dex_swaps

WHERE DATE BETWEEN {{start_date}} AND {{end_date}}

AND token_out=lower('0x0d500B1d8E8eF31E21C99d1Db9A6444d3ADf1270')

group by 1

),

sells AS(

select

date_trunc('hour',BLOCK_TIMESTAMP) AS DATE,

SUM(amount_in) AS total_sold

from polygon.core.ez_dex_swaps

WHERE DATE BETWEEN {{start_date}} AND {{end_date}}

AND token_in=lower('0x0d500B1d8E8eF31E21C99d1Db9A6444d3ADf1270')

group by 1

),

price AS(

select

date_trunc('hour', HOUR) AS DATE,

Symbol,

avg(price) as price

from crosschain.core.ez_hourly_prices

WHERE DATE BETWEEN {{start_date}} AND {{end_date}}

AND SYMBOL='WMATIC'