Cool! Made me want to try building it in Quadratic because you can tie the live data source into the spreadsheet.
I didn’t use the more comprehensive dataset in big query [1] and I didn't use the firebase API [2] either because it's so much data to go through. Instead I used the Algolia search API [3] because it was easy ha.
The resulting charts [4] are, if nothing else, interesting to look at and on first glance similar to what I see in the og google sheet.
Disclosure: I work on Quadratic and this was a good exercise in using the product (and finding bugs). The spreadsheet is available to look at publicly [5]
I didn’t use the more comprehensive dataset in big query [1] and I didn't use the firebase API [2] either because it's so much data to go through. Instead I used the Algolia search API [3] because it was easy ha.
The resulting charts [4] are, if nothing else, interesting to look at and on first glance similar to what I see in the og google sheet.
Disclosure: I work on Quadratic and this was a good exercise in using the product (and finding bugs). The spreadsheet is available to look at publicly [5]
[1] https://console.cloud.google.com/bigquery?p=bigquery-public-...
[2] https://github.com/HackerNews/API?tab=readme-ov-file
[3] https://hn.algolia.com/api
[4] https://github.com/user-attachments/assets/a97ba432-d6dd-4d1...
[5] https://app.quadratichq.com/file/033d2fa7-b205-4c27-9fce-247...