MLDZMNFSR1
    Updated 2022-12-13
    select
    date_trunc('{{Time_basis}}',BLOCK_TIMESTAMP) as date,
    'Osmosis' as blockchain,
    count(distinct tx_id) as no_txn,
    count(distinct BLOCK_ID) as no_blocks,
    count(distinct TX_FROM) as no_wallets,
    no_txn/no_wallets as txn_per_wallets,
    no_txn/no_blocks as txn_per_block
    from osmosis.core.fact_transactions
    where TX_STATUS ='SUCCEEDED'
    and block_timestamp >= '2022-01-01'
    group by 1,2
    union all
    select
    date_trunc('{{Time_basis}}',BLOCK_TIMESTAMP) as date,
    'Flow' as blockchain,
    count(distinct tx_id) as no_txn,
    count(distinct BLOCK_HEIGHT) as no_blocks,
    count(distinct PROPOSER) as no_wallets,
    no_txn/no_wallets as txn_per_wallets,
    no_txn/no_blocks as txn_per_block
    from flow.core.fact_transactions
    where tx_succeeded = 'TRUE'
    and block_timestamp >= '2022-01-01'
    group by 1,2
    union all
    select
    date_trunc('{{Time_basis}}',BLOCK_TIMESTAMP) as date,
    'Ethereum' as blockchain,
    count(distinct tx_hash) as no_txn,
    count(distinct BLOCK_NUMBER) as no_blocks,
    count(distinct FROM_ADDRESS) as no_wallets,
    no_txn/no_wallets as txn_per_wallets,
    Run a query to Download Data