drone-mostafasolana
Updated 2022-07-10
9
1
2
3
4
5
6
7
›
⌄
select BLOCK_TIMESTAMP::date as date,count(TX_ID)as tx_count,
case
when SUCCEEDED='TRUE' then 'TRUE'
when SUCCEEDED='FALSE' then 'FALSE' end as tx_status
from flipside_prod_db.solana.fact_transactions
where date>=current_date-180
group by 1,3
Run a query to Download Data