flipside

    Details_Contract_Last_30_Days
    oscarqDetails_Contract_Last_30_Days
    Updated 2025-01-23
    SELECT
    NAME,
    SYMBOL AS SYMBOL,
    ADDRESS AS CONTRACT_ADDRESS,
    CREATED_BLOCK_TIMESTAMP AS DATE_CREATED,
    CREATOR_ADDRESS,
    FROM
    {{blockchain}}.core.dim_contracts
    WHERE
    (
    SYMBOL = '{{Symbol}}'
    AND NAME = '{{Name}}'
    )
    AND date_trunc('day', CREATED_BLOCK_TIMESTAMP) >= current_date - 30
    ORDER BY
    CREATED_BLOCK_TIMESTAMP DESC


    Last run: 2 months ago
    NAME
    SYMBOL
    CONTRACT_ADDRESS
    DATE_CREATED
    CREATOR_ADDRESS
    1
    		Uniswap V2UNI-V20x38374f7014287ec8b16da26c3985df6e1a56a1bc2025-04-11 13:37:47.0000x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f
    2
    		Uniswap V2UNI-V20x211642ccc14664f68c59a5d41579b69d4fe62e432025-04-11 13:37:35.0000x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f
    3
    		Uniswap V2UNI-V20xbe3711a0da29752a4cfcbd36d8a1a036192642822025-04-11 13:37:11.0000x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f
    4
    		Uniswap V2UNI-V20xc53a8277ae968fc3050507c64046241bb4d901422025-04-11 12:58:35.0000x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f
    5
    		Uniswap V2UNI-V20xce7cc35770d04ae79e7080faf5aaabc6d6ec18562025-04-11 12:54:11.0000x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f
    6
    		Uniswap V2UNI-V20xac4bb9814dd7518ddbd8f8508e744dd506b05a2e2025-04-11 12:52:11.0000x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f
    7
    		Uniswap V2UNI-V20x32f9a6cf39161cef3df1292511a1e8d7ede6cfbc2025-04-11 12:47:35.0000x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f
    8
    		Uniswap V2UNI-V20xfb062bc8ddea2a331f32c96960200f3fe45dc3642025-04-11 12:25:11.0000x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f
    9
    		Uniswap V2UNI-V20x4986da0380cd0ec5af0833e30352ff0cfb8d8d0e2025-04-11 12:23:23.0000x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f
    10
    		Uniswap V2UNI-V20xdf2f2030b7bc074506b49bee4b3074b105bbe6742025-04-11 12:16:35.0000x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f
    11
    		Uniswap V2UNI-V20x88f901951832979f0c93bc100a01e59e629646bc2025-04-11 12:16:23.0000x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f
    12
    		Uniswap V2UNI-V20xa8971253974d2b7802186833586acd468a7b6e042025-04-11 12:07:59.0000x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f
    13
    		Uniswap V2UNI-V20xb50d48d7433ff79c5c9b09a537cc1fcf6f264ebe2025-04-11 12:01:47.0000x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f
    14
    		Uniswap V2UNI-V20x57009a3938ddfed7dad65ab745067a43bedec4182025-04-11 12:00:23.0000x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f
    15
    		Uniswap V2UNI-V20x4955ef3a346b0d8267f86a8364732be12dacb82a2025-04-11 11:28:47.0000x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f
    16
    		Uniswap V2UNI-V20x17b73c8effe5e16c3c231a96661ba288f1e1ada82025-04-11 11:13:59.0000x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f
    17
    		Uniswap V2UNI-V20x8258b4b68a1caddd3a07a6c226dceea7e8de96802025-04-11 11:11:23.0000x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f
    18
    		Uniswap V2UNI-V20xbe6840fb6e3c2b1debbdf703323bdf600fa3c1eb2025-04-11 11:07:11.0000x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f
    19
    		Uniswap V2UNI-V20x32e816ec9d9dd66bc4559fcbeec292b2b1819a572025-04-11 11:01:47.0000x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f
    20
    		Uniswap V2UNI-V20x70c0af432b715570da5031be7c0c85e77c1fed832025-04-11 10:25:35.0000x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f
    ...
    5538
    757KB
    34s