0xHaM-dAll Chains
    Updated 2022-12-17
    with txns as (
    select
    block_timestamp,
    'FLOW' as chain,
    TX_ID,
    payer as wallet
    from flow.core.fact_transactions
    where block_timestamp >= '2022-01-01'

    UNION
    select
    block_timestamp,
    'Ethereum' as chain,
    TX_HASH,
    FROM_ADDRESS as wallet
    from ethereum.core.fact_transactions
    where block_timestamp >= '2022-01-01'

    UNION
    select
    block_timestamp,
    'Algorand' as chain,
    TX_ID,
    TX_SENDER as wallet
    from algorand.core.fact_transaction
    where block_timestamp >= '2022-01-01'

    UNION
    select
    block_timestamp,
    'NEAR' as chain,
    TX_HASH,
    TX_SIGNER as wallet
    Run a query to Download Data