MLDZMNNKB3
    Updated 2023-02-24
    --credit to 0xHamde

    with nonGPM as (
    SELECT
    sender,
    min(block_timestamp) as min_date
    FROM axelar.core.fact_transfers
    WHERE transfer_type LIKE 'IBC_TRANSFER_IN'
    and block_timestamp>='2023-01-01'
    GROUP BY 1
    )
    , GMPTb as (
    SELECT
    'Ethereum' as chain,
    from_address,
    min(block_timestamp) as min_date
    FROM ethereum.core.fact_transactions
    WHERE tx_hash in (
    SELECT
    tx_hash
    FROM ethereum.core.fact_decoded_event_logs
    WHERE contract_address LIKE lower('0x4F4495243837681061C4743b74B3eEdf548D56A5')
    AND event_name LIKE 'Contract%'
    )
    GROUP by 1,2

    UNION

    SELECT
    'Polygon' as chain,
    from_address,
    min(block_timestamp) as min_date
    FROM polygon.core.fact_transactions
    WHERE tx_hash in (
    SELECT
    tx_hash
    Run a query to Download Data