--- title: Powering Real-Time Transit Analytics From a 1 TB Table description: Hopthru utilizes Timescale to power real-time transit analytics from a 1 TB table. They collect and analyze automated passenger counting (APC) data from... canonical: https://daily.dev/posts/powering-real-time-transit-analytics-from-a-1-tb-table-ljctwhxs6 twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Powering Real-Time Transit Analytics From a 1 TB Table | daily.dev og:description: Hopthru utilizes Timescale to power real-time transit analytics from a 1 TB table. They collect and analyze automated passenger counting (APC) data from... og:url: https://daily.dev/posts/powering-real-time-transit-analytics-from-a-1-tb-table-ljctwhxs6 og:image: https://api.daily.dev/og/posts/LJcTWHXS6.png og:image:alt: Powering Real-Time Transit Analytics From a 1 TB Table og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Powering Real-Time Transit Analytics From a 1 TB Table **[TigerData \(Creators of TimescaleDB\)](https://daily.dev/sources/tigerdata)** · 9 min read · 2 upvotes · 0 comments ## Summary Hopthru utilizes Timescale to power real-time transit analytics from a 1 TB table. They collect and analyze automated passenger counting (APC) data from transit agencies to help improve public transportation. With Hopthru's analysis suite, agencies can optimize their routes and network based on ridership data. They make use of TimescaleDB's performance capabilities and features like hypertables and continuous aggregates. Hopthru's future roadmap includes building a product called Hopthru Cleanse to improve data accuracy and help agencies achieve NTD certification. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: --- Tags: [#data-analysis](https://daily.dev/tags/data-analysis) [View this post on daily.dev](https://daily.dev/posts/powering-real-time-transit-analytics-from-a-1-tb-table-ljctwhxs6) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Powering Real-Time Transit Analytics From a 1 TB Table","url":"https://daily.dev/posts/powering-real-time-transit-analytics-from-a-1-tb-table-ljctwhxs6","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/powering-real-time-transit-analytics-from-a-1-tb-table-ljctwhxs6"},"datePublished":"2024-05-15T16:51:01.254Z","dateModified":"2024-05-15T16:51:00.499Z","description":"Hopthru utilizes Timescale to power real-time transit analytics from a 1 TB table. They collect and analyze automated passenger counting (APC) data from...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/295e50621fc81fd6611558f18dab9245?_a=AQAEuiZ","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/295e50621fc81fd6611558f18dab9245?_a=AQAEuiZ","isAccessibleForFree":true,"articleSection":"TigerData (Creators of TimescaleDB)","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"TigerData (Creators of TimescaleDB)","logo":"https://media.daily.dev/image/upload/s--bsnY3goS--/f_auto/v1756960371/squads/timescale?_a=BAMClqZW0","url":"https://daily.dev/squads/tigerdata"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/powering-real-time-transit-analytics-from-a-1-tb-table-ljctwhxs6","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":2},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"data-analysis","timeRequired":"PT9M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"TigerData (Creators of TimescaleDB)","item":"https://daily.dev/squads/tigerdata"},{"@type":"ListItem","position":3,"name":"Powering Real-Time Transit Analytics From a 1 TB Table"}]} ```