PREVIEW / stock_5min / 2009-03-11
file: by_date/stock_5min/2009/2009-03-11.parquet size: 4.4 MB rows: 307,497 symbols: 3,331
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2009-03-11 06:05:00 | AAPL | Stock | 3.1964 | 3.1964 | 3.1964 | 3.1964 | 8400.0 |
| 2009-03-11 07:15:00 | AAPL | Stock | 3.2004 | 3.2004 | 3.1979 | 3.1979 | 19600.0 |
| 2009-03-11 07:25:00 | AAPL | Stock | 3.2071 | 3.2071 | 3.2071 | 3.2071 | 5600.0 |
| 2009-03-11 07:30:00 | AAPL | Stock | 3.2068 | 3.2107 | 3.2068 | 3.2107 | 47404.0 |
| 2009-03-11 07:35:00 | AAPL | Stock | 3.2071 | 3.2071 | 3.2071 | 3.2071 | 14000.0 |
| 2009-03-11 07:40:00 | AAPL | Stock | 3.2071 | 3.2071 | 3.2 | 3.2 | 77196.0 |
| 2009-03-11 07:50:00 | AAPL | Stock | 3.2 | 3.2054 | 3.2 | 3.2054 | 16800.0 |
| 2009-03-11 07:55:00 | AAPL | Stock | 3.2036 | 3.2036 | 3.1868 | 3.1868 | 5600.0 |
| 2009-03-11 08:00:00 | AAPL | Stock | 3.205 | 3.2054 | 3.1861 | 3.1861 | 69384.0 |
| 2009-03-11 08:05:00 | AAPL | Stock | 3.1868 | 3.1971 | 3.1839 | 3.185 | 52500.0 |
| 2009-03-11 08:10:00 | AAPL | Stock | 3.1868 | 3.1993 | 3.1839 | 3.1993 | 251552.0 |
| 2009-03-11 08:15:00 | AAPL | Stock | 3.1989 | 3.1989 | 3.1979 | 3.1982 | 41440.0 |
| 2009-03-11 08:20:00 | AAPL | Stock | 3.1982 | 3.2007 | 3.1982 | 3.1996 | 89180.0 |
| 2009-03-11 08:25:00 | AAPL | Stock | 3.1979 | 3.1982 | 3.1979 | 3.1982 | 155960.0 |
| 2009-03-11 08:30:00 | AAPL | Stock | 3.1982 | 3.2036 | 3.1982 | 3.2021 | 287896.0 |
| 2009-03-11 08:35:00 | AAPL | Stock | 3.2021 | 3.2021 | 3.1979 | 3.2004 | 152012.0 |
| 2009-03-11 08:40:00 | AAPL | Stock | 3.2011 | 3.2011 | 3.1964 | 3.1993 | 110376.0 |
| 2009-03-11 08:45:00 | AAPL | Stock | 3.1979 | 3.2007 | 3.1979 | 3.2 | 166264.0 |
| 2009-03-11 08:50:00 | AAPL | Stock | 3.2007 | 3.2011 | 3.1986 | 3.1986 | 77056.0 |
| 2009-03-11 08:55:00 | AAPL | Stock | 3.2011 | 3.2093 | 3.2011 | 3.2071 | 310492.0 |
| 2009-03-11 09:00:00 | AAPL | Stock | 3.2093 | 3.2107 | 3.2071 | 3.2079 | 159992.0 |
| 2009-03-11 09:05:00 | AAPL | Stock | 3.2079 | 3.2107 | 3.2071 | 3.2071 | 397292.0 |
| 2009-03-11 09:10:00 | AAPL | Stock | 3.2096 | 3.2121 | 3.2071 | 3.2121 | 266700.0 |
| 2009-03-11 09:15:00 | AAPL | Stock | 3.2118 | 3.2143 | 3.2093 | 3.2096 | 164332.0 |
| 2009-03-11 09:20:00 | AAPL | Stock | 3.2082 | 3.2089 | 3.2061 | 3.2061 | 146468.0 |
| 2009-03-11 09:25:00 | AAPL | Stock | 3.205 | 3.2136 | 3.205 | 3.2086 | 386624.0 |
| 2009-03-11 09:30:00 | AAPL | Stock | 3.2075 | 3.2339 | 3.1993 | 3.2168 | 29818964.0 |
| 2009-03-11 09:35:00 | AAPL | Stock | 3.2164 | 3.2454 | 3.2089 | 3.2454 | 27974632.0 |
| 2009-03-11 09:40:00 | AAPL | Stock | 3.2453 | 3.2786 | 3.2382 | 3.2756 | 23902340.0 |
| 2009-03-11 09:45:00 | AAPL | Stock | 3.2761 | 3.2982 | 3.2743 | 3.2871 | 27459348.0 |
| 2009-03-11 09:50:00 | AAPL | Stock | 3.2875 | 3.2946 | 3.2754 | 3.2879 | 17600884.0 |
| 2009-03-11 09:55:00 | AAPL | Stock | 3.2886 | 3.2929 | 3.2725 | 3.2903 | 15493044.0 |
| 2009-03-11 10:00:00 | AAPL | Stock | 3.2907 | 3.3089 | 3.2886 | 3.3021 | 23461928.0 |
| 2009-03-11 10:05:00 | AAPL | Stock | 3.3021 | 3.315 | 3.2921 | 3.2939 | 17234868.0 |
| 2009-03-11 10:10:00 | AAPL | Stock | 3.294 | 3.2971 | 3.28 | 3.2936 | 14900116.0 |
| 2009-03-11 10:15:00 | AAPL | Stock | 3.2932 | 3.3011 | 3.2775 | 3.2979 | 15338904.0 |
| 2009-03-11 10:20:00 | AAPL | Stock | 3.2971 | 3.3068 | 3.2857 | 3.2893 | 12350940.0 |
| 2009-03-11 10:25:00 | AAPL | Stock | 3.2893 | 3.3196 | 3.2879 | 3.3196 | 17217928.0 |
| 2009-03-11 10:30:00 | AAPL | Stock | 3.3193 | 3.3286 | 3.3096 | 3.3121 | 14570304.0 |
| 2009-03-11 10:35:00 | AAPL | Stock | 3.3114 | 3.3154 | 3.3057 | 3.3122 | 8810900.0 |
| 2009-03-11 10:40:00 | AAPL | Stock | 3.3121 | 3.3125 | 3.2993 | 3.3025 | 10067064.0 |
| 2009-03-11 10:45:00 | AAPL | Stock | 3.3025 | 3.3061 | 3.2904 | 3.3046 | 9047836.0 |
| 2009-03-11 10:50:00 | AAPL | Stock | 3.3036 | 3.3179 | 3.3018 | 3.3161 | 7386764.0 |
| 2009-03-11 10:55:00 | AAPL | Stock | 3.3171 | 3.325 | 3.3129 | 3.3179 | 7723380.0 |
| 2009-03-11 11:00:00 | AAPL | Stock | 3.3179 | 3.3279 | 3.3179 | 3.3207 | 8370516.0 |
| 2009-03-11 11:05:00 | AAPL | Stock | 3.3211 | 3.3246 | 3.3111 | 3.3211 | 7960540.0 |
| 2009-03-11 11:10:00 | AAPL | Stock | 3.3214 | 3.3332 | 3.3193 | 3.3326 | 8876224.0 |
| 2009-03-11 11:15:00 | AAPL | Stock | 3.3325 | 3.3386 | 3.3268 | 3.3277 | 10013052.0 |
| 2009-03-11 11:20:00 | AAPL | Stock | 3.3279 | 3.3304 | 3.3064 | 3.3125 | 11588472.0 |
| 2009-03-11 11:25:00 | AAPL | Stock | 3.3125 | 3.3204 | 3.31 | 3.3125 | 6357176.0 |
> showing 50 of 307,497 rows — these rows as CSV