SELECT date_trunc('day', block_timestamp) AS dayzz,

Symbol as symbolz,

avg(price_usd) * 1 as avgg

FROM terra.oracle_prices

WHERE block_timestamp >= CURRENT_DATE - 400

group by dayzz, symbolz

order by dayzz DESC

limit 10000

),

shuttlez as (

select

date_trunc('day', block_timestamp) AS dayz,

COUNT(DISTINCT tx_id) AS n_shuttlez,

-- COUNT(DISTINCT FROM_ADDRESS) as n_peeps,

SYMBOL ,

sum(AMOUNT) as dsum

from ethereum.udm_events

where to_address = lower('0x0000000000000000000000000000000000000000')

and (symbol = 'LUNA'

or symbol = 'UST')

group by dayz, SYMBOL

order by dayz desc

limit 100000

),

combine as (

select * FROM

shuttlez

left join prices

on shuttlez.dayz = prices.dayzz

and shuttlez.SYMBOL = prices.symbolz

order by dayz