with final_tab as (

with table3 as (

WITH SELL AS (WITH TAB1 AS (SELECT swapper, DATE_TRUNC('DAY',BLOCK_TIMESTAMP) AS DATE, SUM(SWAP_FROM_AMOUNT) AS SELLING_VOLUME,

count(distinct tx_id) as selling_count

FROM solana.core.fact_swaps

WHERE SWAP_FROM_MINT='DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

GROUP BY 1,2

ORDER BY 1),

tab2 as (SELECT DATE_TRUNC('DAY',RECORDED_HOUR) AS DATE, AVG(close) as AVG_PRICE

from solana.core.fact_token_prices_hourly

where symbol='BONK'

GROUP BY 1

ORDER BY 1)

SELECT swapper, TAB1.DATE AS DATE, SELLING_VOLUME*AVG_PRICE AS SELLING_VOLUME, selling_count

FROM TAB1 LEFT JOIN TAB2 ON TAB1.DATE=TAB2.DATE

WHERE TAB1.DATE>='2022-12-30'

ORDER BY 1),

BUY AS (WITH TAB1 AS (SELECT swapper, DATE_TRUNC('DAY',BLOCK_TIMESTAMP) AS DATE, SUM(SWAP_TO_AMOUNT) AS BUYING_VOLUME,

count(distinct tx_id) as buying_count

FROM solana.core.fact_swaps

WHERE SWAP_TO_MINT='DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

GROUP BY 1,2

ORDER BY 1),

tab2 as (SELECT DATE_TRUNC('DAY',RECORDED_HOUR) AS DATE, AVG(close) as AVG_PRICE

from solana.core.fact_token_prices_hourly

where symbol='BONK'

GROUP BY 1

ORDER BY 1)

SELECT swapper, TAB1.DATE AS DATE, BUYING_VOLUME*AVG_PRICE AS BUYING_VOLUME, buying_count

FROM TAB1 LEFT JOIN TAB2 ON TAB1.DATE=TAB2.DATE

WHERE TAB1.DATE>='2022-12-30'

ORDER BY 1)

SELECT sell.swapper as "Swapper", sell.date as "Date", SELLING_VOLUME, BUYING_VOLUME,