keshanTerra NFT: top 10 projects
    Updated 2022-02-11
    select msg_value:execute_msg:ledger_proxy:msg:post_order:order:order:taker_asset:info:nft:contract_addr as address,
    (case address when 'terra180tvldnt7h3lts6sp0n3kq7x496sf8cuvqf4xd' then 'Luna Monkey Business'
    when 'terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k' then 'Galactic Punks'
    when 'terra1zvmesqul8ss2ty84eml8aqkq0kq5ydwjuyf6a3' then 'BabyBulls'
    when 'terra1hj0dga445h3faxu85gm0293608qntsj3a727ck' then 'TerraBots'
    when 'terra1trn7mhgc9e2wfkm5mhr65p3eu7a2lc526uwny2' then 'LunaBulls'
    when 'terra1934kn7p03ns94htl75zpzsg0n4yvw8yf2746ep' then 'Styllar'
    when 'terra1fnv8f2202zgsnvpju7auehmygmdfj93xls8x0s' then 'Goochi Goochi'
    when 'terra1f89xq3qhu98v4jch4y5xcrkhl9gytrne99x74t' then 'Terrapins on Terra'
    when 'terra1598rvtgufwr7pnpqhrlajjrmvte4l8a6xkty6y' then 'Galactic Baby Ape Club'
    when 'terra1fsfnnv08cgwcyfyh3p89rf44tfy4tlgnsapyda' then 'Terra Name Service'
    when 'terra1vhuyuwwr4rkdpez5f5lmuqavut28h5dt29rpn6' then 'Levana Dragons-LVNDRG'
    when 'terra1k0y373yxqne22pc9g7jvnr4qclpsxtafevtrpg' then 'Levana Eggs'
    when 'terra1chrdxaef0y2feynkpq63mve0sqeg09acjnp55v' then 'Levana Dragons-LVN'
    when 'terra1jp5fjj7rlc0erw4z3qr5zuvmg2w49pfzyhvsnk' then 'wagmimonkeez'
    when 'terra1p70x7jkqhf37qa7qm4v23g4u4g8ka4ktxudxa7' then 'Levana Meteor Dust'
    when 'terra14gfnxnwl0yz6njzet4n33erq5n70wt79nm24el' then 'Levana Loot'
    else 'other' end) as project,
    sum(case when msg_value:execute_msg:ledger_proxy:msg:post_order:order:order:maker_asset:info:native_token:denom = 'uluna'
    then msg_value:execute_msg:ledger_proxy:msg:post_order:order:order:maker_asset:amount else 0 end)/1e6 as luna_amount
    FROM terra.msgs
    WHERE msg_value:contract = 'terra1eek0ymmhyzja60830xhzm7k7jkrk99a60q2z2t'
    AND msg_type = 'wasm/MsgExecuteContract'
    AND tx_status = 'SUCCEEDED'
    AND msg_value:execute_msg:ledger_proxy:msg:post_order is not null
    AND block_timestamp::date >= date_trunc('day', CURRENT_DATE) - 30
    GROUP BY address, project
    ORDER BY luna_amount desc
    limit 10