From Solana.swaps

Where block_timestamp::date >= '2021-12-01'

And succeeded = 'True'

And SWAP_PROGRAM='jupiter aggregator v2'

AND swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

Group by block_day

) ,

B as (

Select date_trunc('day',block_timestamp) as block_day , count(swap_to_amount) as swapcountusdt

From Solana.swaps

Where block_timestamp::date >= '2021-12-01'

And succeeded = 'True'

And SWAP_PROGRAM='jupiter aggregator v2'

AND swap_to_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'

Group by block_day)

, C as (

Select date_trunc('day',block_timestamp) as block_day , count(swap_to_amount) as swapcountust

From Solana.swaps

Where block_timestamp::date >= '2021-12-01'

And succeeded = 'True'

And SWAP_PROGRAM='jupiter aggregator v2'

AND swap_to_mint = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i'

Group by block_day)

select aa.block_day, aa.swapcountusdc, bb.swapcountusdt , cc.swapcountust

from A aa

join B bb on aa.block_day = bb.block_day

join C cc on aa.block_day = cc.block_day