Moestark - nft mints copy
Updated 2023-08-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
›
⌄
-- 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