Moebridges 2 copy
    Updated 2023-03-18
    -- forked from 9dfef9d0-e62e-4bf7-a10e-7bf60b60e5f3

    --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>=current_date - 30
    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 (
    Run a query to Download Data