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.