date(block_timestamp) as dates,

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_contract_address,

(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)

),

randomearth as (select

date_trunc('day', dates) as dt,

sum(round(amount,2)) as Total_sale_Volume

from re

where amount > 0.1 and dates >= CURRENT_DATE - 90

group by 1

order by 1 desc),

luart as (select block_timestamp, tx_id, event_attributes:nft_contract_address::string as NFTs, event_attributes:"1_token_id" as NFT_ID,

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')

group by 1,2),

luart_vol as (select date_trunc('day', block_timestamp) as dt, sum(price) as vol

from luart

where price is not null and currency = 'uluna'