KaskoazulUntitled Query
    Updated 2022-04-05
    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