Peimancount new smart contracts since 180 days ago
    Updated 2022-08-02
    with code1 as (
    SELECT TX_RECEIVER, TXN_HASH
    FROM flipside_prod_db.mdao_near.transactions
    where BLOCK_TIMESTAMP>=CURRENT_DATE-180
    ),
    code2 as (
    select TXN_HASH
    from flipside_prod_db.mdao_near.actions_events
    where ACTION_NAME='DeployContract'
    )
    SELECT COUNT (distinct TX_RECEIVER) as "new smart contracts"
    from code1 a join code2 b on a.TXN_HASH=b.TXN_HASH

    Run a query to Download Data