date_trunc('day', block_timestamp) as date,

case when SUCCESSFUL = 'TRUE' then 'Success' else 'Faild' end as type,

count(DISTINCT transaction_hash) as txns,

count(DISTINCT account) as n_accounts,

avg(FEE_CHARGED/pow(10,7)) as avg_fee,

avg( max_fee/pow(10,7)) as avg_max_fee

from stellar.core.fact_transactions

where block_timestamp::date >= current_date - 90

group by 1 , 2

select count(distinct id)

from stellar.core.fact_operations

select sum(TRANSACTION_COUNT),

sum(operation_count)

from stellar.core.fact_ledgers

select sum(amount)

from stellar.core.ez_operations

where from_account = 'GBHNGLLIE3KWGKCHIKMHJ5HVZHYIK7WTBE4QF5PLAKL4CJGSEU7HZIW5'

select

sum(amount)

from stellar.core.ez_operations

where to_account = 'GBHNGLLIE3KWGKCHIKMHJ5HVZHYIK7WTBE4QF5PLAKL4CJGSEU7HZIW5'

select

from stellar.core.ez_operations

where asset = 'USDPEND:GBHNGLLIE3KWGKCHIKMHJ5HVZHYIK7WTBE4QF5PLAKL4CJGSEU7HZIW5'

and type_string = 'create_claimable_balance'