shahdadi-9ptm8Ythorchain vs. ethereum vs. solana vs. algorand swaps
    Updated 2022-06-13
    with thorchain as(
    select
    date_trunc('day',block_timestamp) date,
    count(tx_id) thorchain_swaps,
    count(distinct from_address) thorchain_swapper
    from flipside_prod_db.thorchain.swaps
    where date >='2022-01-01'
    group by date
    ),ethereum as(
    select
    date_trunc('day',block_timestamp) date,
    count(tx_hash) ethereum_swaps,
    count(distinct SENDER) ethereum_swapper
    from ethereum.core.ez_dex_swaps
    where date >='2022-01-01'
    group by date
    ),solana as(
    select
    date_trunc('day',block_timestamp) date,
    count(tx_id) solana_swaps,
    count(distinct swapper) solana_swapper
    from solana.core.fact_swaps
    where date >='2022-01-01' and SUCCEEDED='TRUE'
    group by date
    ),algorand as(
    select
    date_trunc('day',block_timestamp) date,
    count(tx_group_id) algorand_swaps,
    count(distinct swapper) algorand_swapper
    from flipside_prod_db.algorand.swaps
    where date >='2022-01-01'
    group by date
    )
    select thorchain.date,thorchain_swaps,thorchain_swapper,ethereum_swaps,ethereum_swapper,solana_swaps,solana_swapper,algorand_swaps,algorand_swapper
    from thorchain
    join ethereum on thorchain.date=ethereum.date
    Run a query to Download Data