-- select
-- date_trunc('day',block_timestamp) as daily,
-- count(tx_id) as transactions,
-- sum(case when succeeded = 'FALSE' then 1 else 0 end) as failed_txs
-- from solana.transactions
-- where block_timestamp >= '2021-12-15' and block_timestamp <= '2021-12-31'
-- group by 1
-- order by 1
select *
from solana.transactions
limit 10