sum(msg_value:execute_msg:execute_order:order:order:taker_asset:amount/1e6) as volume_luna

from terra.msgs

where msg_value:execute_msg:execute_order:order:order:maker_asset:info:nft:contract_addr::string = 'terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k'

and msg_value:execute_msg:execute_order:order:order:maker_asset:info:nft:token_id::string is not null and tx_status = 'SUCCEEDED'

group by 1),

price as (select avg(price_usd) as luna, date_trunc('day', block_timestamp) as dt

from terra.oracle_prices

where symbol = 'LUNA'

group by 2)

select a.tx_date, a.tx_count, a.volume_luna, b.luna, (a.volume_luna * b.luna) as volume_usd

from gp a

join price b on a.tx_date = b.dt