KaskoazulUntitled Query
Updated 2022-04-05
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select block_timestamp::date as fecha,
tx_from,
tx_to,
tx_id,
concat_ws('#', 'SMB', token_id)
from solana.dim_nft_metadata md
left join solana.fact_transfers ft
on md.mint = ft.mint
where contract_address = ('9uBX3ASjxWvNBAD1xjbVaKA74mWGZys3RGSF7DdeDD3F') --contract_name = ('Solana Monkey Business')
and md.mint is not null