Sleep Correlations using Google BigQuery

Sara Robinson is an advocate for Google Machine Learning and an OuraRing user. She has posted a helpful tutorial on her blog explaining the process she used to gather two months worth of sleep and activity data using Oura’s API and upload it to Google’s BigQuery. The beautiful thing about Sara’s  guide is that it shows how we can have some confidence that small lifestyle changes are increasing aspects of our healthspan.
The results of Sara’s analysis can be summarized as going to bed at a consistent early time resulted in better REM sleep and a lower heart rate. Exercise can promote more deep sleep. While these results might seem to be intuitive it is reassuring to see this small data set confirm that. Both forms of sleep REM or DEEP are critical to performance. If you have not already heard Matthew Walkers three part interview on the Peter Attia Drive Podcast this will quickly explain why biohackers are obsessing over the total, REM and DEEP sleep. Matthews book “Why We Sleep” is also an essential read and a NYT bestseller.
While our fitness trackers are excellent of keeping tally of our daily health metrics and rest they provide very little in the way of correlating certain activities. It is easy for me to download my lowest resting heart rate for the last three years, but extremely difficult for me to confirm which lifestyle change made it so low. Today the tools we need to analyze diet macros, caloric intake, fasting windows, heart rate variability, blood glucose and fitness tracker collected health data are all available, but in isolated forms. We are seeing applications such as Cronometer which is really a food tracker, but allows all the health data to be synced into one dashboard. MementoLabs is trying to do the same by creating group experiments and collecting data from many popular quantifiedself devices which can be cross referenced. It is good to see that Google’s BigQuery is another helpful utility that can be used to merge data across different health apps and fitness tracker. Those with the patience to configure it can add to their selftracking toolbox.

Adafruit publishes a wide range of writing and video content, including interviews and reporting on the maker market and the wider technology world. Our standards page is intended as a guide to best practices that Adafruit uses, as well as an outline of the ethical standards Adafruit aspires to. While Adafruit is not an independent journalistic institution, Adafruit strives to be a fair, informative, and positive voice within the community – check it out here:

Join Adafruit on Mastodon

Adafruit is on Mastodon, join in!

Stop breadboarding and soldering – start making immediately! Adafruit’s Circuit Playground is jam-packed with LEDs, sensors, buttons, alligator clip pads and more. Build projects with Circuit Playground in a few minutes with the drag-and-drop MakeCode programming site, learn computer science using the CS Discoveries class on, jump into CircuitPython to learn Python and hardware together, TinyGO, or even use the Arduino IDE. Circuit Playground Express is the newest and best Circuit Playground board, with support for CircuitPython, MakeCode, and Arduino. It has a powerful processor, 10 NeoPixels, mini speaker, InfraRed receive and transmit, two buttons, a switch, 14 alligator clip pads, and lots of sensors: capacitive touch, IR proximity, temperature, light, motion and sound. A whole wide world of electronics and coding is waiting for you, and it fits in the palm of your hand.

Have an amazing project to share? The Electronics Show and Tell is every Wednesday at 7pm ET! To join, head over to YouTube and check out the show’s live chat – we’ll post the link there.

Join us every Wednesday night at 8pm ET for Ask an Engineer!

Join over 36,000+ makers on Adafruit’s Discord channels and be part of the community!

CircuitPython – The easiest way to program microcontrollers –

Maker Business — “Packaging” chips in the US

Wearables — Enclosures help fight body humidity in costumes

Electronics — Transformers: More than meets the eye!

Python for Microcontrollers — Python on Microcontrollers Newsletter: Silicon Labs introduces CircuitPython support, and more! #CircuitPython #Python #micropython @ThePSF @Raspberry_Pi

Adafruit IoT Monthly — Guardian Robot, Weather-wise Umbrella Stand, and more!

Microsoft MakeCode — MakeCode Thank You!

EYE on NPI — Maxim’s Himalaya uSLIC Step-Down Power Module #EyeOnNPI @maximintegrated @digikey

New Products – Adafruit Industries – Makers, hackers, artists, designers and engineers! — #NewProds 7/19/23 Feat. Adafruit Matrix Portal S3 CircuitPython Powered Internet Display!

Get the only spam-free daily newsletter about wearables, running a "maker business", electronic tips and more! Subscribe at !

No Comments

No comments yet.

Sorry, the comment form is closed at this time.