PREVIEW / stock_5min / 2008-01-14
file: by_date/stock_5min/2008/2008-01-14.parquet size: 4.3 MB rows: 317,933 symbols: 3,266
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-14 04:30:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.2143 | 6.2143 | 5600.0 |
| 2008-01-14 04:40:00 | AAPL | Stock | 6.2086 | 6.2096 | 6.2086 | 6.2096 | 5600.0 |
| 2008-01-14 04:45:00 | AAPL | Stock | 6.2086 | 6.2086 | 6.2086 | 6.2086 | 5600.0 |
| 2008-01-14 04:55:00 | AAPL | Stock | 6.2096 | 6.2096 | 6.2096 | 6.2096 | 2800.0 |
| 2008-01-14 05:05:00 | AAPL | Stock | 6.2096 | 6.2107 | 6.2096 | 6.2107 | 6440.0 |
| 2008-01-14 05:10:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.2143 | 6.2143 | 11200.0 |
| 2008-01-14 05:15:00 | AAPL | Stock | 6.1971 | 6.1971 | 6.1971 | 6.1971 | 5600.0 |
| 2008-01-14 05:30:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.2143 | 6.2143 | 2800.0 |
| 2008-01-14 05:35:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.2143 | 6.2143 | 53200.0 |
| 2008-01-14 05:40:00 | AAPL | Stock | 6.2232 | 6.2232 | 6.2232 | 6.2232 | 56000.0 |
| 2008-01-14 05:50:00 | AAPL | Stock | 6.2321 | 6.2321 | 6.2321 | 6.2321 | 3752.0 |
| 2008-01-14 05:55:00 | AAPL | Stock | 6.2282 | 6.2282 | 6.2282 | 6.2282 | 5600.0 |
| 2008-01-14 06:05:00 | AAPL | Stock | 6.2271 | 6.2271 | 6.2271 | 6.2271 | 14000.0 |
| 2008-01-14 06:10:00 | AAPL | Stock | 6.2411 | 6.2411 | 6.2411 | 6.2411 | 33600.0 |
| 2008-01-14 06:25:00 | AAPL | Stock | 6.2229 | 6.2229 | 6.2229 | 6.2229 | 2800.0 |
| 2008-01-14 06:35:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.2143 | 6.2143 | 8400.0 |
| 2008-01-14 06:45:00 | AAPL | Stock | 6.2143 | 6.2143 | 6.2143 | 6.2143 | 2800.0 |
| 2008-01-14 06:50:00 | AAPL | Stock | 6.2232 | 6.2232 | 6.2232 | 6.2232 | 34440.0 |
| 2008-01-14 07:00:00 | AAPL | Stock | 6.2232 | 6.2232 | 6.2214 | 6.2214 | 47460.0 |
| 2008-01-14 07:05:00 | AAPL | Stock | 6.2214 | 6.2214 | 6.22 | 6.22 | 39340.0 |
| 2008-01-14 07:10:00 | AAPL | Stock | 6.2179 | 6.2179 | 6.2161 | 6.2175 | 89600.0 |
| 2008-01-14 07:15:00 | AAPL | Stock | 6.2182 | 6.2182 | 6.2161 | 6.2161 | 10920.0 |
| 2008-01-14 07:20:00 | AAPL | Stock | 6.2211 | 6.2211 | 6.2143 | 6.2143 | 84672.0 |
| 2008-01-14 07:25:00 | AAPL | Stock | 6.2143 | 6.2179 | 6.2143 | 6.2143 | 83720.0 |
| 2008-01-14 07:30:00 | AAPL | Stock | 6.225 | 6.2493 | 6.225 | 6.2493 | 194740.0 |
| 2008-01-14 07:35:00 | AAPL | Stock | 6.2643 | 6.3 | 6.2507 | 6.2807 | 274400.0 |
| 2008-01-14 07:40:00 | AAPL | Stock | 6.2857 | 6.2979 | 6.2839 | 6.2896 | 256676.0 |
| 2008-01-14 07:45:00 | AAPL | Stock | 6.2857 | 6.2893 | 6.2768 | 6.2893 | 192108.0 |
| 2008-01-14 07:50:00 | AAPL | Stock | 6.2986 | 6.3 | 6.2893 | 6.2929 | 137200.0 |
| 2008-01-14 07:55:00 | AAPL | Stock | 6.2857 | 6.2964 | 6.2804 | 6.2804 | 285600.0 |
| 2008-01-14 08:00:00 | AAPL | Stock | 6.2857 | 6.2946 | 6.2646 | 6.2857 | 1731884.0 |
| 2008-01-14 08:05:00 | AAPL | Stock | 6.2871 | 6.3086 | 6.2857 | 6.3086 | 1869952.0 |
| 2008-01-14 08:10:00 | AAPL | Stock | 6.3071 | 6.3107 | 6.2979 | 6.3054 | 761376.0 |
| 2008-01-14 08:15:00 | AAPL | Stock | 6.3046 | 6.3071 | 6.2754 | 6.285 | 1103312.0 |
| 2008-01-14 08:20:00 | AAPL | Stock | 6.285 | 6.2968 | 6.285 | 6.2921 | 1344112.0 |
| 2008-01-14 08:25:00 | AAPL | Stock | 6.2893 | 6.2996 | 6.2861 | 6.2875 | 1767052.0 |
| 2008-01-14 08:30:00 | AAPL | Stock | 6.2911 | 6.3036 | 6.2864 | 6.2932 | 626192.0 |
| 2008-01-14 08:35:00 | AAPL | Stock | 6.2932 | 6.3 | 6.2843 | 6.2993 | 2067800.0 |
| 2008-01-14 08:40:00 | AAPL | Stock | 6.295 | 6.3 | 6.2879 | 6.2975 | 1219932.0 |
| 2008-01-14 08:45:00 | AAPL | Stock | 6.3 | 6.3125 | 6.2932 | 6.3107 | 1381800.0 |
| 2008-01-14 08:50:00 | AAPL | Stock | 6.3107 | 6.345 | 6.3104 | 6.325 | 4273528.0 |
| 2008-01-14 08:55:00 | AAPL | Stock | 6.3261 | 6.3321 | 6.3214 | 6.3225 | 1500884.0 |
| 2008-01-14 09:00:00 | AAPL | Stock | 6.3225 | 6.3461 | 6.3225 | 6.3429 | 2175432.0 |
| 2008-01-14 09:05:00 | AAPL | Stock | 6.3421 | 6.3554 | 6.3418 | 6.3418 | 2936612.0 |
| 2008-01-14 09:10:00 | AAPL | Stock | 6.3414 | 6.3479 | 6.3307 | 6.3343 | 1640072.0 |
| 2008-01-14 09:15:00 | AAPL | Stock | 6.3346 | 6.3446 | 6.3332 | 6.3396 | 800128.0 |
| 2008-01-14 09:20:00 | AAPL | Stock | 6.3393 | 6.3432 | 6.3289 | 6.3425 | 570556.0 |
| 2008-01-14 09:25:00 | AAPL | Stock | 6.3404 | 6.3532 | 6.3196 | 6.3393 | 3796660.0 |
| 2008-01-14 09:30:00 | AAPL | Stock | 6.3393 | 6.3446 | 6.3004 | 6.3107 | 45706220.0 |
| 2008-01-14 09:35:00 | AAPL | Stock | 6.3115 | 6.3282 | 6.3068 | 6.3132 | 28958048.0 |
> showing 50 of 317,933 rows — these rows as CSV