Ali3NDistribution of Squid Users By Their Number of Bridges (Breakdown by Chain)
    Updated 2023-02-18
    with SquidT as (
    select 'Ethereum' as chain,
    block_timestamp,
    tx_hash,
    origin_from_address
    from ethereum.core.fact_event_logs
    where contract_address = '0x4f4495243837681061c4743b74b3eedf548d56a5'
    and origin_to_address = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666' -- Squid
    and event_name is null

    UNION ALL

    select 'Arbitrum' as chain,
    block_timestamp,
    tx_hash,
    origin_from_address
    from arbitrum.core.fact_event_logs
    where contract_address = '0xe432150cce91c13a887f7d836923d5597add8e31'
    and origin_to_address = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666' -- Squid
    and event_name is null

    UNION ALL

    select 'Avalanche' as chain,
    block_timestamp,
    tx_hash,
    origin_from_address
    from avalanche.core.fact_event_logs
    where contract_address = '0x5029c0eff6c34351a0cec334542cdb22c7928f78'
    and origin_to_address = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666' -- Squid
    and event_name is null

    UNION ALL

    select 'Binance Smart Chain' as chain,
    block_timestamp,
    Run a query to Download Data