from solana.transactions

where succeeded = 'TRUE' and block_timestamp >= '2022-01-01'

group by 1),

usdt as (select date_trunc('day', block_timestamp) as dt, count(tx_id) as usdt

from solana.transactions

where succeeded = 'TRUE' and block_timestamp >= '2022-01-01' and pre_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'

group by 1),

usdc as (select date_trunc('day', block_timestamp) as dt, count(tx_id) as usdc

from solana.transactions

where succeeded = 'TRUE' and block_timestamp >= '2022-01-01' and pre_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

group by 1),

ust as (select date_trunc('day', block_timestamp) as dt, count(tx_id) as ust

from solana.transactions

where succeeded = 'TRUE' and block_timestamp >= '2022-01-01' and pre_mint = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i'

group by 1)

select a.dt, a.total_tx, b.usdt, c.usdc, d.ust, (a.total_tx-b.usdt-c.usdc-d.ust) as total_nonstablecoin ,((b.usdt + c.usdc + d.ust)/a.total_tx) as stablecoins_perc,

(1-stablecoins_perc) as other_perc

from total a

left join usdt b on a.dt = b.dt

left join usdc c on a.dt = c.dt

left join ust d on a.dt = d.dt