date(block_timestamp) as date,

event_attributes:"0_contract_address" as token,

address_name as token_name,

sum(event_attributes:"amount"/pow(10,6)) as alts_sold,

sum(event_attributes:"return_amount"/pow(10,6)) as usd_received,

usd_received/alts_sold as alts_price_usd

FROM terra.msg_events

LEFT JOIN terra.labels ON address = event_attributes:"0_contract_address"

WHERE event_type = 'from_contract'

AND event_attributes:"1_contract_address" IN

('terra1v4kpj65uq63m4x0mqzntzm27ecpactt42nyp5c', 'terra106a00unep7pvwvcck4wylt4fffjhgkf9a0u6eu', 'terra163pkeeuwxzr0yhndf8xd2jprm9hrtk59xf7nqf', 'terra1gm5p3ner9x9xpwugn9sp6gvhd0lwrtkyrecdn3',

'terra1e59utusv5rspqsu8t37h5w887d9rdykljedxw0', 'terra1zkyrfyq7x9v5vqnnrznn3kvj35az4f6jxftrl2', 'terra1xj2w7w8mx6m2nueczgsxy2gnmujwejjeu2xf78',

'terra1l7xu2rl3c7qmtx3r5sd2tz25glf6jh8ul7aag7', 'terra1yjg0tuhc6kzwz9jl8yqgxnf2ctwlfumnvscupp', 'terra1jzqlw8mfau9ewr7lufqkrpgfzk4legz9zx306p',

'terra1pn20mcwnmeyxf68vpt3cyel3n57qm9mp289jta', 'terra1hqnk9expq3k4la2ruzdnyapgndntec4fztdyln', 'terra1etdkg9p0fkl8zal6ecp98kypd32q8k3ryced9d',

'terra19pg6d7rrndg4z4t0jhcd7z9nhl3p5ygqttxjll', 'terra1tn8ejzw8kpuc87nu42f6qeyen4c7qy35tl8t20', 'terra1mz0p4wzz5tmethu7rca2jjrw077hv2ypj7h06z',

'terra12mzh5cp6tgc65t2cqku5zvkjj8xjtuv5v9whyd' , 'terra178jydtjvj4gw8earkgnqc80c3hrmqj4kw2welz' )

AND event_attributes:"ask_asset" = 'uusd'

AND tx_status = 'SUCCEEDED'

GROUP BY 1,2,3

SELECT

date(block_timestamp) as luna_date,

event_attributes:ask_asset as token,

event_attributes:ask_asset as token_name,

sum(event_attributes:"return_amount"/pow(10,6)) as luna_bought,

sum(event_attributes:"offer_amount"/pow(10,6)) as usd_offered, -- usd_offered

usd_offered/luna_bought as luna_price

FROM terra.msg_Events

WHERE -- TX_ID = '8223BA2E8261C3E36BD69C1E58C21F3B210F1C696F30F5BC1E12CB80A3D30E78'

event_type = 'from_contract'

AND (event_attributes:"contract_address" = 'terra1tndcaqxkpc5ce9qee5ggqf430mr2z3pefe5wj6' OR

event_attributes:"contract_address" = 'terra1m6ywlgn6wrjuagcmmezzz2a029gtldhey5k552' OR -- ASTROPORT

event_attributes:"0_contract_address" = 'terra1tndcaqxkpc5ce9qee5ggqf430mr2z3pefe5wj6' )-- LUNA-UST Terra Swap

AND event_attributes:"offer_asset" = 'uusd'