Finding Start/End Times of All Trips Utilizing GTFS

[DavidC]

Hi All,

Relatively new to utilizing GTFS. I have an exercise in mind that would output a list of all Trip patterns and their earliest start times and latest end times in a normal weekday. 

Based on the GTFS diagram below, does one have to connect the first/last stop of the trip (stops) to the first/last departure time (stop_times) before connecting it to a trip?

I am looking into how long a route with numerous trips are active in a standard day. 

Would you be able to output the information into a table like: 

route_id

trip_shortname

direction_id

starting_trip_time

latest_trip_time

I have access to ArcGIS Desktop and Pro, but cannot find a solution in the Public Transit Toolbox documentation. Thanks!