mrwildcatrabby subsidies on uniswap v1
    Updated 2024-07-28
    WITH subsidy_transactions AS (
    SELECT
    'optimism' AS chain,
    AMOUNT_USD AS subsidy_amount,
    BLOCK_TIMESTAMP AS subsidy_timestamp,
    TO_ADDRESS AS subsidized_address,
    TX_HASH AS subsidy_tx_hash
    FROM optimism.core.ez_native_transfers
    WHERE ORIGIN_FROM_ADDRESS = '0x76dd65529dc6c073c1e0af2a5ecc78434bdbf7d9'
    AND BLOCK_TIMESTAMP::date >= '2024-03-01'

    UNION ALL

    SELECT
    'arbitrum' AS chain,
    AMOUNT_USD AS subsidy_amount,
    BLOCK_TIMESTAMP AS subsidy_timestamp,
    TO_ADDRESS AS subsidized_address,
    TX_HASH AS subsidy_tx_hash
    FROM arbitrum.core.ez_native_transfers
    WHERE ORIGIN_FROM_ADDRESS = '0x76dd65529dc6c073c1e0af2a5ecc78434bdbf7d9'
    AND BLOCK_TIMESTAMP::date >= '2024-03-01'

    UNION ALL

    SELECT
    'polygon' AS chain,
    AMOUNT_USD AS subsidy_amount,
    BLOCK_TIMESTAMP AS subsidy_timestamp,
    TO_ADDRESS AS subsidized_address,
    TX_HASH AS subsidy_tx_hash
    FROM polygon.core.ez_native_transfers
    WHERE ORIGIN_FROM_ADDRESS = '0x76dd65529dc6c073c1e0af2a5ecc78434bdbf7d9'
    AND BLOCK_TIMESTAMP::date >= '2024-03-01'

    UNION ALL