msg_value:execute_msg:ledger_proxy:msg:execute_order:order:order:maker_asset:info:nft:contract_addr::string as nft_maker,

msg_value:execute_msg:ledger_proxy:msg:execute_order:order:order:taker_asset:info:nft:contract_addr::string as nft_taker, case

when nft_maker is not null then nft_maker

when nft_maker is null then nft_taker end as nft_collections,

(msg_value:execute_msg:ledger_proxy:msg:execute_order:order:order:taker_asset:amount::int)/1000000 as amount

from terra.msgs

where msg_value:contract::string = 'terra1eek0ymmhyzja60830xhzm7k7jkrk99a60q2z2t'

and tx_status = 'SUCCEEDED'

and (msg_value:execute_msg:execute_order is not null or msg_value:execute_msg:ledger_proxy:msg:execute_order is not null)

and date(block_timestamp) = CURRENT_DATE - 1)

select nft_collections, case

when nft_collections = 'terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k' then 'Galactic Punks'

when nft_collections = 'terra1ca9peph7c20eqr9cns2vhn6sp6cp7vv4jnzjrc' then 'Derby Stars Horse'

when nft_collections = 'terra1trn7mhgc9e2wfkm5mhr65p3eu7a2lc526uwny2' then 'Lunabulls'

when nft_collections = 'terra1k0y373yxqne22pc9g7jvnr4qclpsxtafevtrpg' then 'Levana Eggs'

when nft_collections = 'terra1934kn7p03ns94htl75zpzsg0n4yvw8yf2746ep' then 'Styllar'

when nft_collections = 'terra1p70x7jkqhf37qa7qm4v23g4u4g8ka4ktxudxa7' then 'Levana Meteor Dust'

when nft_collections = 'terra1lfr4aja5a2xpxvnrl4gyjpru0wwglu7k87jmeq' then 'HERO'

when nft_collections = 'terra1flwpxxfl8ldxhdgzxkwet2r37c45hutapgjwkg' then 'LUNArt'

when nft_collections = 'terra1f89xq3qhu98v4jch4y5xcrkhl9gytrne99x74t' then 'Terrapins'

when nft_collections = 'terra1chrdxaef0y2feynkpq63mve0sqeg09acjnp55v' then 'Levana Meteors'

else 'others' end as nft_collection,

sum(round(amount,2)) as Volume

from re

group by 1

order by 3 desc