Owen
← Daily Learnings

Daily Learning · 2023-02-07

DUNE, BB

Dune - used Torino docs to find out how to parse out object (json) columns in sql.

Select
	id
	, json_query(column_header
							, 'lax $.json_field'
							) AS JSON_field
From table_1

Dune - 2 new topics to explore are derivatives and VC wallets.

BB - (Brownian Bridge) did some good exploration. Maybe 1.5 hrs. From my understanding it is a model that pins the starting value and ending value (bridge). Then uses randomizing functions in the middle to find a path. This is then reiterated to find different pathways. When used in derivatives and stable de-pegging it looks to specify the deviation from the underlying that needs to be reached.