event_attributes:price/1e6 as Price,

event_attributes:denom::string as currency

from terra.msg_events

where event_type = 'wasm' and event_attributes:"1_sender"::string = 'terra1fj44gmt0rtphu623zxge7u3t85qy0jg6p5ucnk' and tx_status = 'SUCCEEDED'

and event_attributes:method::string = 'execute_order'),

luna_p as (select date_trunc('day', block_timestamp) as dt, currency, avg(price_usd) as prices

from terra.oracle_prices

where symbol in ('LUNA', 'UST')

group by 1,2

),

final as (select date_trunc('day', block_timestamp) as dt, NFTs, currency, sum(price) as vol, count(distinct tx_id) as sales_count, case

when currency = 'uluna' then 'LUNA'

when currency = 'uusd' then 'UST' end as denom

from luart

where price is not null

group by 1,2,3)

select a.dt, a.NFTs as NFT, case

when NFT = 'terra1uv9w7aaq6lu2kn0asnvknlcgg2xd5ts57ss7qt' then 'Hellcats'

when NFT = 'terra1nyqyxamvuhtd8h756tkqsejc7plj6lr5gdfj5e' then 'LUNI'

when NFT = 'terra1zvmesqul8ss2ty84eml8aqkq0kq5ydwjuyf6a3' then 'BabyBulls'

when NFT = 'terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k' then 'Galactic Punks'

when NFT = 'terra1934kn7p03ns94htl75zpzsg0n4yvw8yf2746ep' then 'Styllar'

when NFT = 'terra1ggv86dkuzmky7ww20s2uvm6pl2jvl9mv0z6zyt' then 'dystopAI'

when NFT = 'terra1trn7mhgc9e2wfkm5mhr65p3eu7a2lc526uwny2' then 'LunaBulls'

when NFT = 'terra1qpu42s4hrrnvxsxr428scd5st9zd4fmn5me38t' then 'Luna Shield'

when NFT = 'terra1lfr4aja5a2xpxvnrl4gyjpru0wwglu7k87jmeq' then 'Hero NFT'

when NFT = 'terra1jp5fjj7rlc0erw4z3qr5zuvmg2w49pfzyhvsnk' then 'wagmimonkeez'

when NFT = 'terra1wcdapxh8030czdketyfemsa7lndsmpmk2e76l5' then 'wagmikongz'

when NFT = 'terra1np0zunma7m6380munyvmnk9qezjd5p742geed6' then 'LUNI 2'

when NFT = 'terra1jdt2wnfhgy4ptk6m5kxacyj0k6e8rc7e2ugulz' then 'TerraWhales'

when NFT = 'terra1xv0as2esvwqcuaqtdhvrdhykrfe75qw42tgh6f' then 'Astroverse #02'

when NFT = 'terra1p4mlfdwm4h0hvyv0c64kmj3afs5zzj3t2jszvw' then 'Columbus Omnia Luna'