PREVIEW / stock_5min / 2010-03-08
file: by_date/stock_5min/2010/2010-03-08.parquet size: 4.7 MB rows: 324,372 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-08 04:15:00 | AAPL | Stock | 7.8268 | 7.8286 | 7.8268 | 7.8286 | 8400.0 |
| 2010-03-08 04:20:00 | AAPL | Stock | 7.8339 | 7.8339 | 7.8339 | 7.8339 | 2800.0 |
| 2010-03-08 04:30:00 | AAPL | Stock | 7.8386 | 7.85 | 7.8386 | 7.85 | 5600.0 |
| 2010-03-08 04:40:00 | AAPL | Stock | 7.8539 | 7.8539 | 7.8539 | 7.8539 | 2800.0 |
| 2010-03-08 04:50:00 | AAPL | Stock | 7.8539 | 7.8539 | 7.8539 | 7.8539 | 5600.0 |
| 2010-03-08 05:15:00 | AAPL | Stock | 7.8411 | 7.8411 | 7.8411 | 7.8411 | 5600.0 |
| 2010-03-08 05:25:00 | AAPL | Stock | 7.8464 | 7.8464 | 7.8464 | 7.8464 | 5600.0 |
| 2010-03-08 07:00:00 | AAPL | Stock | 7.8329 | 7.8329 | 7.8243 | 7.8243 | 30940.0 |
| 2010-03-08 07:05:00 | AAPL | Stock | 7.8318 | 7.8318 | 7.8318 | 7.8318 | 8400.0 |
| 2010-03-08 07:10:00 | AAPL | Stock | 7.8393 | 7.8393 | 7.8393 | 7.8393 | 2800.0 |
| 2010-03-08 07:15:00 | AAPL | Stock | 7.8296 | 7.8296 | 7.8296 | 7.8296 | 5600.0 |
| 2010-03-08 07:25:00 | AAPL | Stock | 7.8368 | 7.8411 | 7.8321 | 7.8389 | 33600.0 |
| 2010-03-08 07:30:00 | AAPL | Stock | 7.8425 | 7.8457 | 7.8375 | 7.8457 | 19600.0 |
| 2010-03-08 07:35:00 | AAPL | Stock | 7.8389 | 7.8393 | 7.8375 | 7.8393 | 53200.0 |
| 2010-03-08 07:40:00 | AAPL | Stock | 7.8389 | 7.8396 | 7.8357 | 7.8393 | 67760.0 |
| 2010-03-08 07:45:00 | AAPL | Stock | 7.8454 | 7.8464 | 7.8404 | 7.8404 | 16800.0 |
| 2010-03-08 07:50:00 | AAPL | Stock | 7.8393 | 7.8461 | 7.8393 | 7.8446 | 51100.0 |
| 2010-03-08 07:55:00 | AAPL | Stock | 7.8464 | 7.8464 | 7.8429 | 7.8464 | 37072.0 |
| 2010-03-08 08:00:00 | AAPL | Stock | 7.8446 | 7.8786 | 7.8429 | 7.8786 | 1074248.0 |
| 2010-03-08 08:05:00 | AAPL | Stock | 7.8782 | 7.8807 | 7.8714 | 7.8807 | 773220.0 |
| 2010-03-08 08:10:00 | AAPL | Stock | 7.8807 | 7.8807 | 7.8686 | 7.8704 | 680904.0 |
| 2010-03-08 08:15:00 | AAPL | Stock | 7.8679 | 7.8729 | 7.8629 | 7.8675 | 677768.0 |
| 2010-03-08 08:20:00 | AAPL | Stock | 7.8679 | 7.8786 | 7.8654 | 7.8786 | 663376.0 |
| 2010-03-08 08:25:00 | AAPL | Stock | 7.8768 | 7.8839 | 7.875 | 7.8839 | 586264.0 |
| 2010-03-08 08:30:00 | AAPL | Stock | 7.8857 | 7.8893 | 7.8786 | 7.8786 | 620536.0 |
| 2010-03-08 08:35:00 | AAPL | Stock | 7.8789 | 7.8789 | 7.875 | 7.8768 | 351484.0 |
| 2010-03-08 08:40:00 | AAPL | Stock | 7.8754 | 7.8793 | 7.8714 | 7.8732 | 660016.0 |
| 2010-03-08 08:45:00 | AAPL | Stock | 7.8721 | 7.8732 | 7.8654 | 7.8654 | 198324.0 |
| 2010-03-08 08:50:00 | AAPL | Stock | 7.8657 | 7.8671 | 7.8582 | 7.8607 | 574952.0 |
| 2010-03-08 08:55:00 | AAPL | Stock | 7.8621 | 7.8621 | 7.8571 | 7.8593 | 457268.0 |
| 2010-03-08 09:00:00 | AAPL | Stock | 7.8579 | 7.8611 | 7.8554 | 7.8596 | 451304.0 |
| 2010-03-08 09:05:00 | AAPL | Stock | 7.8607 | 7.8693 | 7.8593 | 7.8675 | 408996.0 |
| 2010-03-08 09:10:00 | AAPL | Stock | 7.8675 | 7.8675 | 7.8621 | 7.8621 | 117348.0 |
| 2010-03-08 09:15:00 | AAPL | Stock | 7.8639 | 7.8654 | 7.86 | 7.8636 | 212268.0 |
| 2010-03-08 09:20:00 | AAPL | Stock | 7.8639 | 7.8661 | 7.8607 | 7.8625 | 179760.0 |
| 2010-03-08 09:25:00 | AAPL | Stock | 7.8625 | 7.8625 | 7.8525 | 7.8571 | 575960.0 |
| 2010-03-08 09:30:00 | AAPL | Stock | 7.8579 | 7.8604 | 7.8336 | 7.8539 | 37973208.0 |
| 2010-03-08 09:35:00 | AAPL | Stock | 7.8546 | 7.8546 | 7.8204 | 7.8218 | 18902128.0 |
| 2010-03-08 09:40:00 | AAPL | Stock | 7.8214 | 7.8464 | 7.8207 | 7.8421 | 14679728.0 |
| 2010-03-08 09:45:00 | AAPL | Stock | 7.8421 | 7.8421 | 7.8271 | 7.8321 | 10992632.0 |
| 2010-03-08 09:50:00 | AAPL | Stock | 7.8321 | 7.8482 | 7.8286 | 7.8443 | 11906552.0 |
| 2010-03-08 09:55:00 | AAPL | Stock | 7.8446 | 7.8446 | 7.7946 | 7.8018 | 16940532.0 |
| 2010-03-08 10:00:00 | AAPL | Stock | 7.8007 | 7.8168 | 7.7986 | 7.8168 | 10162796.0 |
| 2010-03-08 10:05:00 | AAPL | Stock | 7.8157 | 7.8196 | 7.8107 | 7.8161 | 7114184.0 |
| 2010-03-08 10:10:00 | AAPL | Stock | 7.8161 | 7.8243 | 7.8129 | 7.8221 | 6504708.0 |
| 2010-03-08 10:15:00 | AAPL | Stock | 7.8211 | 7.8368 | 7.8196 | 7.8343 | 6933864.0 |
| 2010-03-08 10:20:00 | AAPL | Stock | 7.8343 | 7.8371 | 7.8311 | 7.8343 | 5448576.0 |
| 2010-03-08 10:25:00 | AAPL | Stock | 7.8354 | 7.8389 | 7.8221 | 7.8236 | 6564404.0 |
| 2010-03-08 10:30:00 | AAPL | Stock | 7.8237 | 7.8257 | 7.8125 | 7.822 | 7192780.0 |
| 2010-03-08 10:35:00 | AAPL | Stock | 7.8221 | 7.8354 | 7.8214 | 7.8314 | 5353684.0 |
> showing 50 of 324,372 rows — these rows as CSV