HessishTop 10 most traded NFT tokens
    Updated 2023-03-22
    select DISTINCT DECODED_LOG:tokenId as "NFT Token" , CONTRACT_NAME as "Collection", count(DISTINCT TX_hash) as "trades"
    from avalanche.core.ez_decoded_event_logs
    where BLOCK_TIMESTAMP::date >= '2023-01-01'
    and EVENT_NAME = 'Transfer'
    and ORIGIN_TO_ADDRESS = '0xae079eda901f7727d0715aff8f82ba8295719977'
    --and tx_hash = '0x7c6a74e6347d29f3022b0aefd8e46dacdb1843616e8e5fff8a6b72d20d0b9db2'

    group by 1,2
    having "NFT Token" > 0
    order by 3 desc
    limit 10
    Run a query to Download Data