adriaparcerisasFourthwall deployed contracts: Polygon
    Updated 2023-11-14

    select
    -- x.*
    distinct decoded_log:proxy as "Wallet address", x.block_timestamp as "Date time"
    from polygon.core.fact_decoded_event_logs x
    join polygon.core.fact_event_logs xx on x.tx_hash=xx.tx_hash
    join ethereum.core.dim_function_signatures y on xx.origin_function_signature=y.bytes_signature
    where x.contract_address=lower('0x5DBC7B840baa9daBcBe9D2492E45D7244B54A2A0')
    and text_signature='deployProxyByImplementation(address,bytes,bytes32)'
    --group by 1 order by 2 desc
    order by 2 desc
    limit {{amount_of_new_contracts}}


    Run a query to Download Data