SandeshRonin_contracts_trend
    Updated 2025-03-10

    with res AS (
    SELECT
    livequery.live.udf_api(
    'GET',
    'https://science.flipsidecrypto.xyz/googlesheets/readsheet',
    { 'Content-Type': 'application/json' },
    {
    'sheets_id' : '1OyUssDN960O2o-ss6UWjQ7tVZ7_IPznSEX3mH1N-yrs/',
    'tab_name' : 'contracts'
    }
    ) as result
    from DUAL
    ),

    data AS (
    select result:data as json_result_must_pivot from res
    ),
    historical_contracts as
    (
    SELECT
    TO_DATE(d.value:"CREATED_BLOCK_TIMESTAMP") AS date,
    TRY_CAST(NULLIF(d.value:"CREATED_TX_HASH"::STRING, '') AS VARCHAR) AS CREATED_TX_HASH,
    TRY_CAST(NULLIF(d.value:"Address"::STRING, '') AS VARCHAR) AS Address,
    TRY_CAST(NULLIF(d.value:"creator_address"::STRING, '') AS VARCHAR) AS creator_address,
    -- TRY_CAST(NULLIF(d.value:"contract_abi"::STRING, '') AS VARCHAR) AS contract_abi,
    TRY_CAST(NULLIF(d.value:"Name"::STRING, '') AS VARCHAR) AS Name,
    TRY_CAST(NULLIF(d.value:"Symbol"::STRING, '') AS VARCHAR) AS Symbol
    FROM
    data,
    LATERAL FLATTEN(input => data.json_result_must_pivot::VARIANT) d
    ),
    human_generated_contracts as
    (
    Last run: 11 days ago
    DEPLOYMENT_DATE
    CALL_BIN_LABEL
    DEPLOYER
    CONTRACTS_DEPLOYED
    UNIQUE_DEPLOYERS
    SEVEN_DAY_MOVING_AVG
    TOTAL_CONTRACTS_DEPLOYED
    1
    2025-02-28 00:00:00.00075-90%Human Generated1114.7145452
    2
    2025-02-28 00:00:00.00090-100%Human Generated4214.2855452
    3
    2025-02-28 00:00:00.00050-75%Human Generated9514.1425452
    4
    2025-02-28 00:00:00.0000-25%Human Generated531115.7145452
    5
    2025-02-28 00:00:00.00025-50%Human Generated52135452
    6
    2025-02-28 00:00:00.00090-100%other1113.4285452
    7
    2025-02-28 00:00:00.00050-75%other1115.7145452
    8
    2025-02-28 00:00:00.0000-25%other8614.7145452
    9
    2025-02-28 00:00:00.00050-75%tama.meme1114.2855452
    10
    2025-02-28 00:00:00.00025-50%tama.meme91105452
    11
    2025-02-28 00:00:00.0000-25%tama.meme70112.4285452
    12
    2025-02-28 00:00:00.00075-90%tama.meme1114.4285452
    13
    2025-02-27 00:00:00.00090-100%Human Generated32145289
    14
    2025-02-27 00:00:00.00025-50%Human Generated2114.1425289
    15
    2025-02-27 00:00:00.0000-25%Human Generated3368.4285289
    16
    2025-02-27 00:00:00.00050-75%Human Generated3213.5715289
    17
    2025-02-27 00:00:00.0000-25%other754.1425289
    18
    2025-02-27 00:00:00.00090-100%other1113.2855289
    19
    2025-02-27 00:00:00.00050-75%other114.1425289
    20
    2025-02-27 00:00:00.0000-25%tama.meme71113.2855289
    ...
    266
    17KB
    42s