PREVIEW / stock_1min / 2001-07-27
file: by_date/stock_1min/2001/2001-07-27.parquet size: 3.0 MB rows: 247,103 symbols: 1,078
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 |
|---|---|---|---|---|---|---|---|
| 2001-07-27 08:02:00 | AAPL | Stock | 0.332 | 0.332 | 0.332 | 0.332 | 5600.0 |
| 2001-07-27 08:05:00 | AAPL | Stock | 0.332 | 0.332 | 0.332 | 0.332 | 151200.0 |
| 2001-07-27 08:19:00 | AAPL | Stock | 0.3323 | 0.3323 | 0.3323 | 0.3323 | 5600.0 |
| 2001-07-27 08:20:00 | AAPL | Stock | 0.3323 | 0.3323 | 0.3323 | 0.3323 | 5600.0 |
| 2001-07-27 08:22:00 | AAPL | Stock | 0.3323 | 0.3323 | 0.3323 | 0.3323 | 5600.0 |
| 2001-07-27 08:23:00 | AAPL | Stock | 0.3323 | 0.3323 | 0.3323 | 0.3323 | 5600.0 |
| 2001-07-27 08:24:00 | AAPL | Stock | 0.3323 | 0.3323 | 0.3323 | 0.3323 | 16800.0 |
| 2001-07-27 08:29:00 | AAPL | Stock | 0.3323 | 0.3323 | 0.3323 | 0.3323 | 5600.0 |
| 2001-07-27 08:30:00 | AAPL | Stock | 0.332 | 0.332 | 0.332 | 0.332 | 56000.0 |
| 2001-07-27 08:59:00 | AAPL | Stock | 0.3316 | 0.3316 | 0.3316 | 0.3316 | 5600.0 |
| 2001-07-27 09:09:00 | AAPL | Stock | 0.3321 | 0.3321 | 0.3321 | 0.3321 | 16800.0 |
| 2001-07-27 09:10:00 | AAPL | Stock | 0.3321 | 0.3321 | 0.3316 | 0.3316 | 44800.0 |
| 2001-07-27 09:11:00 | AAPL | Stock | 0.3321 | 0.3321 | 0.3321 | 0.3321 | 56000.0 |
| 2001-07-27 09:15:00 | AAPL | Stock | 0.3321 | 0.3321 | 0.332 | 0.332 | 268800.0 |
| 2001-07-27 09:16:00 | AAPL | Stock | 0.332 | 0.332 | 0.332 | 0.332 | 5600.0 |
| 2001-07-27 09:28:00 | AAPL | Stock | 0.3339 | 0.3339 | 0.3339 | 0.3339 | 56000.0 |
| 2001-07-27 09:29:00 | AAPL | Stock | 0.3339 | 0.3346 | 0.3339 | 0.3346 | 375200.0 |
| 2001-07-27 09:30:00 | AAPL | Stock | 0.3348 | 0.3354 | 0.3338 | 0.3338 | 2833600.0 |
| 2001-07-27 09:31:00 | AAPL | Stock | 0.3339 | 0.3355 | 0.3313 | 0.332 | 3712800.0 |
| 2001-07-27 09:32:00 | AAPL | Stock | 0.3318 | 0.3329 | 0.3311 | 0.3314 | 1075200.0 |
| 2001-07-27 09:33:00 | AAPL | Stock | 0.3314 | 0.3318 | 0.3314 | 0.3318 | 1282400.0 |
| 2001-07-27 09:34:00 | AAPL | Stock | 0.3318 | 0.333 | 0.3318 | 0.333 | 1265600.0 |
| 2001-07-27 09:35:00 | AAPL | Stock | 0.3348 | 0.335 | 0.3338 | 0.3339 | 1103200.0 |
| 2001-07-27 09:36:00 | AAPL | Stock | 0.3339 | 0.3371 | 0.3338 | 0.3371 | 1092000.0 |
| 2001-07-27 09:37:00 | AAPL | Stock | 0.3373 | 0.3377 | 0.3357 | 0.3377 | 2385600.0 |
| 2001-07-27 09:38:00 | AAPL | Stock | 0.3375 | 0.3379 | 0.3357 | 0.3375 | 2408000.0 |
| 2001-07-27 09:39:00 | AAPL | Stock | 0.3375 | 0.3398 | 0.3373 | 0.3391 | 2464000.0 |
| 2001-07-27 09:40:00 | AAPL | Stock | 0.3398 | 0.3402 | 0.3379 | 0.3379 | 1097600.0 |
| 2001-07-27 09:41:00 | AAPL | Stock | 0.3379 | 0.3398 | 0.3379 | 0.3379 | 2223200.0 |
| 2001-07-27 09:42:00 | AAPL | Stock | 0.3379 | 0.3388 | 0.3377 | 0.3388 | 1204000.0 |
| 2001-07-27 09:43:00 | AAPL | Stock | 0.3388 | 0.3391 | 0.3384 | 0.3388 | 1030400.0 |
| 2001-07-27 09:44:00 | AAPL | Stock | 0.3388 | 0.3388 | 0.337 | 0.3375 | 1327200.0 |
| 2001-07-27 09:45:00 | AAPL | Stock | 0.3375 | 0.3384 | 0.3366 | 0.3366 | 2576000.0 |
| 2001-07-27 09:46:00 | AAPL | Stock | 0.3368 | 0.3389 | 0.3366 | 0.3384 | 1097600.0 |
| 2001-07-27 09:47:00 | AAPL | Stock | 0.3384 | 0.3393 | 0.3384 | 0.3384 | 1708000.0 |
| 2001-07-27 09:48:00 | AAPL | Stock | 0.3384 | 0.3395 | 0.338 | 0.338 | 974400.0 |
| 2001-07-27 09:49:00 | AAPL | Stock | 0.3384 | 0.3384 | 0.3363 | 0.337 | 935200.0 |
| 2001-07-27 09:50:00 | AAPL | Stock | 0.3368 | 0.3382 | 0.3361 | 0.3368 | 2324000.0 |
| 2001-07-27 09:51:00 | AAPL | Stock | 0.3368 | 0.3368 | 0.3355 | 0.3359 | 1176000.0 |
| 2001-07-27 09:52:00 | AAPL | Stock | 0.3355 | 0.3368 | 0.3348 | 0.3348 | 2996000.0 |
| 2001-07-27 09:53:00 | AAPL | Stock | 0.3345 | 0.3357 | 0.333 | 0.3341 | 1943200.0 |
| 2001-07-27 09:54:00 | AAPL | Stock | 0.3339 | 0.3339 | 0.333 | 0.3336 | 1416800.0 |
| 2001-07-27 09:55:00 | AAPL | Stock | 0.333 | 0.3336 | 0.3314 | 0.332 | 1411200.0 |
| 2001-07-27 09:56:00 | AAPL | Stock | 0.3314 | 0.333 | 0.3305 | 0.3309 | 1814400.0 |
| 2001-07-27 09:57:00 | AAPL | Stock | 0.3304 | 0.3311 | 0.3304 | 0.3304 | 1584800.0 |
| 2001-07-27 09:58:00 | AAPL | Stock | 0.3304 | 0.3314 | 0.3304 | 0.3313 | 756000.0 |
| 2001-07-27 09:59:00 | AAPL | Stock | 0.3307 | 0.332 | 0.3304 | 0.3304 | 963200.0 |
| 2001-07-27 10:00:00 | AAPL | Stock | 0.3307 | 0.333 | 0.3305 | 0.3329 | 1036000.0 |
| 2001-07-27 10:01:00 | AAPL | Stock | 0.333 | 0.3339 | 0.332 | 0.3325 | 1528800.0 |
| 2001-07-27 10:02:00 | AAPL | Stock | 0.3325 | 0.3348 | 0.3321 | 0.3348 | 1579200.0 |
> showing 50 of 247,103 rows — these rows as CSV