with tokens as (

SELECT * FROM (values

('ibc/C140AFD542AE77BD7DCC83F13FDD8C5E5BB8C4929785E6EC2F4C636F98F17901','stATOM'),

('ibc/84502A75BCA4A5F68D464C00B3F610CE2585847D59B52E5FFB7C3C9D2DDCD3FE','stJUNO'),

('ibc/5A0060579D24FBE5268BEA74C3281E7FE533D361C41A99307B4998FEC611E46B','stSOMM'),

('ibc/D176154B0C63D1F9C6DCFB4F70349EBF2E2B5A87A05902F57A6AE92B863E9AEC', 'stOSMO'),

('ibc/C5579A9595790017C600DD726276D978B9BF314CF82406CE342720A9C7911A01','stEVMOS'),

('ibc/C491E7582E94AE921F6A029790083CDE1106C28F3F6C4AD7F1340544C13EC372','stLUNA'),

('ibc/02F196DA6FD0917DD5FEA249EE61880F4D941EE9059E7964C5C9B50AF103800F','stUMEE'),

('ibc/5DD1F95ED336014D00CE2520977EC71566D282F9749170ADC83A392E0EA7426A','stSTARS')

) as a (currency, symbol)

,

tb1 as (

SELECT

block_timestamp,

tx_id,

transfer_type,

sender,

amount/pow(10,decimal) as amounts,

a.currency,

b.symbol,

receiver

FROM osmosis.core.fact_transfers a

JOIN tokens b using(currency)

WHERE sender ilike 'stride%' OR receiver ilike 'stride%'

,

usd_price as (

SELECT 'stATOM' as symbol,

TO_TIMESTAMP(value[0]::string) as date,

value[1] as price,

((price - LAG(price)over(ORDER BY date))/LAG(price)over(ORDER BY date))*100 as daily_change