Hessishourn - nft mints copy
Updated 2023-09-26
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
-- forked from ourn - nft mints @ https://flipsidecrypto.xyz/edit/queries/3439be53-320c-4191-a06e-ea478d33dfd4
with t0 as (SELECT DISTINCT tx_hash as hash
from external.tokenflow_starknet.decoded_traces
where FUNCTION = 'mint' and CONTRACT = '0x01b22f7a9d18754c994ae0ee9adb4628d414232e3ebd748c386ac286f86c3066')
SELECT DISTINCT contract as user, tx_hash
from external.tokenflow_starknet.decoded_transactions join t0 on tx_hash = hash
where TIMESTAMP::date >= '2023-05-16'
and CHAIN_ID = 'mainnet'
limit 10
Run a query to Download Data