PREVIEW / stock_5min / 2010-03-01
file: by_date/stock_5min/2010/2010-03-01.parquet size: 4.8 MB rows: 332,130 symbols: 3,474
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-01 04:30:00 | AAPL | Stock | 7.3586 | 7.3586 | 7.3586 | 7.3586 | 2800.0 |
| 2010-03-01 04:35:00 | AAPL | Stock | 7.3557 | 7.3557 | 7.3557 | 7.3557 | 2800.0 |
| 2010-03-01 05:10:00 | AAPL | Stock | 7.3671 | 7.3671 | 7.3671 | 7.3671 | 28000.0 |
| 2010-03-01 05:40:00 | AAPL | Stock | 7.3679 | 7.3679 | 7.3679 | 7.3679 | 2800.0 |
| 2010-03-01 07:00:00 | AAPL | Stock | 7.3407 | 7.3407 | 7.3407 | 7.3407 | 9212.0 |
| 2010-03-01 07:05:00 | AAPL | Stock | 7.3429 | 7.3482 | 7.3429 | 7.3482 | 8400.0 |
| 2010-03-01 07:10:00 | AAPL | Stock | 7.3568 | 7.3568 | 7.3482 | 7.3482 | 76244.0 |
| 2010-03-01 07:15:00 | AAPL | Stock | 7.3404 | 7.3404 | 7.3404 | 7.3404 | 2800.0 |
| 2010-03-01 07:25:00 | AAPL | Stock | 7.3386 | 7.3404 | 7.3386 | 7.3404 | 25200.0 |
| 2010-03-01 07:30:00 | AAPL | Stock | 7.3446 | 7.3446 | 7.3411 | 7.3411 | 13832.0 |
| 2010-03-01 07:35:00 | AAPL | Stock | 7.3443 | 7.3443 | 7.3443 | 7.3443 | 2800.0 |
| 2010-03-01 07:40:00 | AAPL | Stock | 7.35 | 7.3536 | 7.35 | 7.3532 | 45360.0 |
| 2010-03-01 07:45:00 | AAPL | Stock | 7.35 | 7.35 | 7.35 | 7.35 | 2800.0 |
| 2010-03-01 07:50:00 | AAPL | Stock | 7.3443 | 7.3468 | 7.3386 | 7.3386 | 106064.0 |
| 2010-03-01 07:55:00 | AAPL | Stock | 7.3425 | 7.3425 | 7.3321 | 7.3321 | 79268.0 |
| 2010-03-01 08:00:00 | AAPL | Stock | 7.3286 | 7.335 | 7.3204 | 7.3282 | 555884.0 |
| 2010-03-01 08:05:00 | AAPL | Stock | 7.3286 | 7.3289 | 7.325 | 7.325 | 119280.0 |
| 2010-03-01 08:10:00 | AAPL | Stock | 7.325 | 7.3289 | 7.325 | 7.3289 | 151060.0 |
| 2010-03-01 08:15:00 | AAPL | Stock | 7.3286 | 7.3304 | 7.3286 | 7.3296 | 116312.0 |
| 2010-03-01 08:20:00 | AAPL | Stock | 7.3268 | 7.3282 | 7.3079 | 7.3079 | 57960.0 |
| 2010-03-01 08:25:00 | AAPL | Stock | 7.3282 | 7.3304 | 7.3261 | 7.3304 | 54656.0 |
| 2010-03-01 08:30:00 | AAPL | Stock | 7.3289 | 7.3311 | 7.3275 | 7.3311 | 218288.0 |
| 2010-03-01 08:35:00 | AAPL | Stock | 7.3321 | 7.3357 | 7.3318 | 7.3339 | 918540.0 |
| 2010-03-01 08:40:00 | AAPL | Stock | 7.3357 | 7.3407 | 7.3357 | 7.3407 | 483784.0 |
| 2010-03-01 08:45:00 | AAPL | Stock | 7.3407 | 7.3429 | 7.3393 | 7.3393 | 546280.0 |
| 2010-03-01 08:50:00 | AAPL | Stock | 7.3379 | 7.3414 | 7.3346 | 7.3346 | 203560.0 |
| 2010-03-01 08:55:00 | AAPL | Stock | 7.3379 | 7.3425 | 7.3375 | 7.3421 | 140280.0 |
| 2010-03-01 09:00:00 | AAPL | Stock | 7.3421 | 7.3429 | 7.34 | 7.3429 | 54600.0 |
| 2010-03-01 09:05:00 | AAPL | Stock | 7.3446 | 7.3446 | 7.3411 | 7.3429 | 237748.0 |
| 2010-03-01 09:10:00 | AAPL | Stock | 7.3429 | 7.3446 | 7.3411 | 7.3429 | 187908.0 |
| 2010-03-01 09:15:00 | AAPL | Stock | 7.3443 | 7.3443 | 7.3393 | 7.3396 | 202636.0 |
| 2010-03-01 09:20:00 | AAPL | Stock | 7.3421 | 7.3429 | 7.3407 | 7.3407 | 93520.0 |
| 2010-03-01 09:25:00 | AAPL | Stock | 7.3407 | 7.3482 | 7.3393 | 7.3482 | 947492.0 |
| 2010-03-01 09:30:00 | AAPL | Stock | 7.3475 | 7.3896 | 7.3375 | 7.3861 | 25658276.0 |
| 2010-03-01 09:35:00 | AAPL | Stock | 7.387 | 7.3925 | 7.3718 | 7.3893 | 17733324.0 |
| 2010-03-01 09:40:00 | AAPL | Stock | 7.3896 | 7.3929 | 7.3793 | 7.3921 | 12022248.0 |
| 2010-03-01 09:45:00 | AAPL | Stock | 7.3918 | 7.3921 | 7.3821 | 7.3906 | 8078392.0 |
| 2010-03-01 09:50:00 | AAPL | Stock | 7.3896 | 7.4046 | 7.3879 | 7.3907 | 16378236.0 |
| 2010-03-01 09:55:00 | AAPL | Stock | 7.3918 | 7.3982 | 7.3843 | 7.3957 | 9164176.0 |
| 2010-03-01 10:00:00 | AAPL | Stock | 7.3929 | 7.4264 | 7.3868 | 7.4204 | 23123380.0 |
| 2010-03-01 10:05:00 | AAPL | Stock | 7.42 | 7.4382 | 7.4168 | 7.4316 | 19946864.0 |
| 2010-03-01 10:10:00 | AAPL | Stock | 7.4314 | 7.4432 | 7.4314 | 7.435 | 11372256.0 |
| 2010-03-01 10:15:00 | AAPL | Stock | 7.4354 | 7.4514 | 7.4346 | 7.4418 | 13395424.0 |
| 2010-03-01 10:20:00 | AAPL | Stock | 7.4425 | 7.4518 | 7.4357 | 7.4425 | 9718268.0 |
| 2010-03-01 10:25:00 | AAPL | Stock | 7.4436 | 7.4489 | 7.4361 | 7.4446 | 9265676.0 |
| 2010-03-01 10:30:00 | AAPL | Stock | 7.4446 | 7.4514 | 7.4375 | 7.4396 | 10851036.0 |
| 2010-03-01 10:35:00 | AAPL | Stock | 7.4396 | 7.4446 | 7.4339 | 7.4343 | 9986200.0 |
| 2010-03-01 10:40:00 | AAPL | Stock | 7.4354 | 7.4464 | 7.4343 | 7.4461 | 8448244.0 |
| 2010-03-01 10:45:00 | AAPL | Stock | 7.4461 | 7.455 | 7.4418 | 7.4489 | 10225376.0 |
| 2010-03-01 10:50:00 | AAPL | Stock | 7.4493 | 7.4607 | 7.4475 | 7.4525 | 10524528.0 |
> showing 50 of 332,130 rows — these rows as CSV