date_trunc('day',p.block_timestamp) as date,

count(DISTINCT f.value) as wallets,

count(DISTINCT tx_id) as n_txns

FROM terra.transactions p,

table(flatten( parse_json(p.tx_from))) f

GROUP BY date

SELECT 'terra 2.0' as label,

date_trunc('day',block_timestamp) as date,

count(DISTINCT tx_sender) as wallets,

count(DISTINCT tx_id) as n_txns

FROM terra.core.fact_transactions

GROUP BY date