select DATE_TRUNC('day',BLOCK_TIMESTAMP) as date1 ,

sum(SWAP_FROM_AMOUNT) as buy

from solana.defi.fact_swaps

where SWAP_FROM_MINT = 'ukHH6c7mMyiWCf1b9pnWe25TSpkDDt3H5pQZgZ74J82'

and SUCCEEDED = 'TRUE'

and date1>='2024-03-01'

group by 1

order by 1

),

selll as

select DATE_TRUNC('day',BLOCK_TIMESTAMP) as date2 ,

sum(SWAP_TO_AMOUNT) as sell

from solana.defi.fact_swaps

where SWAP_TO_MINT = 'ukHH6c7mMyiWCf1b9pnWe25TSpkDDt3H5pQZgZ74J82'

and SUCCEEDED = 'TRUE'

and date2>='2024-03-01'

group by 1

order by 1

select buyy.date1,selll.sell,buyy.buy

from selll,buyy