MLDZMNsudootc3
    Updated 2024-05-21
    -- forked from sudootc1 @ https://flipsidecrypto.xyz/edit/queries/0f87a448-b13b-4607-ad90-a9d84be46ba6
    with tb1 as (
    select
    s.BLOCK_TIMESTAMP AS day,
    e.tx_hash,
    e.amount AS weth,
    NFT_ADDRESS AS address
    from
    ethereum.core.ez_decoded_event_logs s
    JOIN ethereum.core.ez_token_transfers AS e ON e.tx_hash = s.tx_hash
    JOIN ethereum.nft.ez_nft_transfers AS t ON t.tx_hash = s.tx_hash
    where
    s.CONTRACT_ADDRESS = '0x080bf510fcbf18b91105470639e9561022937712'
    and s.EVENT_NAME = 'Fill'
    and s.DECODED_LOG:feeRecipientAddress = lower('0x4e2f98c96e2d595a83AFa35888C4af58Ac343E44')
    AND NFT_ADDRESS IN (
    '0xf17bb82b6e9cc0075ae308e406e5198ba7320545',
    '0x2c889a24af0d0ec6337db8feb589fa6368491146',
    '0x9e629d779be89783263d4c4a765c38eb3f18671c',
    '0xb4e570232d3e55d2ee850047639dc74da83c7067',
    '0x32bb5a147b5371fd901aa4a72b7f82c58a87e36d'
    )
    ),
    tb2 as (
    select
    s.tx_hash,
    COUNT(e.tx_hash) AS no_txn
    from
    ethereum.core.ez_decoded_event_logs s
    JOIN ethereum.core.ez_token_transfers AS e ON e.tx_hash = s.tx_hash
    JOIN ethereum.nft.ez_nft_transfers AS t ON t.tx_hash = s.tx_hash
    where
    s.CONTRACT_ADDRESS = '0x080bf510fcbf18b91105470639e9561022937712'
    and s.EVENT_NAME = 'Fill'
    and s.DECODED_LOG:feeRecipientAddress = lower('0x4e2f98c96e2d595a83AFa35888C4af58Ac343E44')
    AND e.contract_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
    QueryRunArchived: QueryRun has been archived