'osmosis --> stride' as type,

a.currency,

b.symbol,

count(DISTINCT tx_id) as n_action,

count(DISTINCT sender) as n_user,

sum(amount/1e6) as amounts,

sum((amount* b.usd_price)/1e6) as amount_usd

FROM osmosis.core.fact_transfers a

LEFT JOIN ( -- last price of symbols

SELECT

date_trunc('d', recorded_hour) as date,

currency,

symbol,

median(price) as usd_price

FROM osmosis.price.ez_prices

GROUP BY 1 , 2 , 3

)b ON date_trunc('d', a.block_timestamp) = b.date AND a.currency = b.currency

WHERE receiver ilike 'stride%'

GROUP BY 2 , 3

ORDER BY n_action DESC