A common pattern I've used in analytics
Great article! I recently discovered asof joins for this kind of analysis . Under hood, asof joins might very well be expanding to same thing as your final query.
https://duckdb.org/docs/guides/sql_features/asof_join.html
Thank you. I have not looked into the asof joins yet, but they sound intriguing
Great article! I recently discovered asof joins for this kind of analysis . Under hood, asof joins might very well be expanding to same thing as your final query.
https://duckdb.org/docs/guides/sql_features/asof_join.html
Thank you. I have not looked into the asof joins yet, but they sound intriguing