Moestark - nft mints copy
    Updated 2023-08-29
    -- with t0 as (SELECT DISTINCT tx_hash as hash
    -- from external.tokenflow_starknet.decoded_traces
    -- where FUNCTION = 'mint'
    -- and CONTRACT = '0x01b22f7a9d18754c994ae0ee9adb4628d414232e3ebd748c386ac286f86c3066'),

    -- x as

    -- (SELECT
    -- count(DISTINCT tx_hash) as txs,
    -- 'Argent NFTs mints' as type
    -- from external.tokenflow_starknet.decoded_transactions join t0 on tx_hash = hash
    -- where TIMESTAMP::date >= '2023-05-16'
    -- and CHAIN_ID = 'mainnet'

    -- union

    -- SELECT count(DISTINCT tx_hash) as txs, 'Other transactions' as type
    -- from external.tokenflow_starknet.decoded_transactions
    -- where TIMESTAMP::date >= '2023-05-02'
    -- and CHAIN_ID = 'mainnet'
    -- and tx_hash not in (SELECT DISTINCT hash from t0))

    -- SELECT * from x order by type

    SELECT DISTINCT FUNCTION
    from external.tokenflow_starknet.decoded_traces



    Run a query to Download Data