PREVIEW / stock_5min / 2009-05-11
file: by_date/stock_5min/2009/2009-05-11.parquet size: 4.7 MB rows: 323,532 symbols: 3,348
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-05-11 04:15:00 | AAPL | Stock | 4.67 | 4.67 | 4.67 | 4.67 | 2800.0 |
| 2009-05-11 07:30:00 | AAPL | Stock | 4.5714 | 4.5714 | 4.5714 | 4.5714 | 18200.0 |
| 2009-05-11 07:35:00 | AAPL | Stock | 4.5714 | 4.5714 | 4.5714 | 4.5714 | 5600.0 |
| 2009-05-11 07:50:00 | AAPL | Stock | 4.5714 | 4.5714 | 4.5554 | 4.5554 | 8316.0 |
| 2009-05-11 08:00:00 | AAPL | Stock | 4.5804 | 4.5804 | 4.5796 | 4.5796 | 23016.0 |
| 2009-05-11 08:05:00 | AAPL | Stock | 4.5714 | 4.5732 | 4.5571 | 4.5571 | 90720.0 |
| 2009-05-11 08:10:00 | AAPL | Stock | 4.5696 | 4.5714 | 4.5625 | 4.5625 | 13160.0 |
| 2009-05-11 08:15:00 | AAPL | Stock | 4.5625 | 4.5636 | 4.5589 | 4.5589 | 30408.0 |
| 2009-05-11 08:20:00 | AAPL | Stock | 4.5579 | 4.5589 | 4.5579 | 4.5589 | 27832.0 |
| 2009-05-11 08:25:00 | AAPL | Stock | 4.5643 | 4.5643 | 4.5643 | 4.5643 | 11200.0 |
| 2009-05-11 08:35:00 | AAPL | Stock | 4.5607 | 4.57 | 4.5607 | 4.57 | 42140.0 |
| 2009-05-11 08:40:00 | AAPL | Stock | 4.5714 | 4.5714 | 4.57 | 4.5714 | 152264.0 |
| 2009-05-11 08:45:00 | AAPL | Stock | 4.5721 | 4.5786 | 4.5704 | 4.5704 | 84000.0 |
| 2009-05-11 08:50:00 | AAPL | Stock | 4.5696 | 4.5714 | 4.5679 | 4.5714 | 28000.0 |
| 2009-05-11 08:55:00 | AAPL | Stock | 4.5693 | 4.5714 | 4.5643 | 4.5696 | 30800.0 |
| 2009-05-11 09:00:00 | AAPL | Stock | 4.5679 | 4.5679 | 4.5679 | 4.5679 | 42000.0 |
| 2009-05-11 09:05:00 | AAPL | Stock | 4.5643 | 4.5714 | 4.5643 | 4.5671 | 63504.0 |
| 2009-05-11 09:10:00 | AAPL | Stock | 4.5643 | 4.5643 | 4.5643 | 4.5643 | 23296.0 |
| 2009-05-11 09:15:00 | AAPL | Stock | 4.5643 | 4.5643 | 4.5621 | 4.5643 | 38500.0 |
| 2009-05-11 09:20:00 | AAPL | Stock | 4.5661 | 4.5671 | 4.5621 | 4.5621 | 29680.0 |
| 2009-05-11 09:25:00 | AAPL | Stock | 4.5604 | 4.5643 | 4.5475 | 4.5482 | 362656.0 |
| 2009-05-11 09:30:00 | AAPL | Stock | 4.5489 | 4.5793 | 4.54 | 4.5657 | 12809748.0 |
| 2009-05-11 09:35:00 | AAPL | Stock | 4.565 | 4.5893 | 4.565 | 4.585 | 10188892.0 |
| 2009-05-11 09:40:00 | AAPL | Stock | 4.5846 | 4.5964 | 4.5629 | 4.5639 | 9551948.0 |
| 2009-05-11 09:45:00 | AAPL | Stock | 4.5654 | 4.5768 | 4.5589 | 4.5696 | 7842968.0 |
| 2009-05-11 09:50:00 | AAPL | Stock | 4.5696 | 4.5779 | 4.5611 | 4.5646 | 6387948.0 |
| 2009-05-11 09:55:00 | AAPL | Stock | 4.5639 | 4.5675 | 4.5475 | 4.5657 | 8087212.0 |
| 2009-05-11 10:00:00 | AAPL | Stock | 4.5661 | 4.5704 | 4.5554 | 4.5696 | 5419988.0 |
| 2009-05-11 10:05:00 | AAPL | Stock | 4.5696 | 4.5807 | 4.5652 | 4.5771 | 5743696.0 |
| 2009-05-11 10:10:00 | AAPL | Stock | 4.5775 | 4.5971 | 4.5732 | 4.595 | 7725984.0 |
| 2009-05-11 10:15:00 | AAPL | Stock | 4.5954 | 4.6132 | 4.5857 | 4.6129 | 10679256.0 |
| 2009-05-11 10:20:00 | AAPL | Stock | 4.6125 | 4.6325 | 4.6114 | 4.62 | 11941356.0 |
| 2009-05-11 10:25:00 | AAPL | Stock | 4.62 | 4.6311 | 4.6161 | 4.625 | 6734532.0 |
| 2009-05-11 10:30:00 | AAPL | Stock | 4.6254 | 4.6396 | 4.6071 | 4.6368 | 8442952.0 |
| 2009-05-11 10:35:00 | AAPL | Stock | 4.6364 | 4.6589 | 4.6332 | 4.6561 | 11465832.0 |
| 2009-05-11 10:40:00 | AAPL | Stock | 4.6559 | 4.6707 | 4.65 | 4.6564 | 10115476.0 |
| 2009-05-11 10:45:00 | AAPL | Stock | 4.6568 | 4.6582 | 4.6393 | 4.6421 | 6818028.0 |
| 2009-05-11 10:50:00 | AAPL | Stock | 4.6429 | 4.6432 | 4.6336 | 4.6371 | 3343872.0 |
| 2009-05-11 10:55:00 | AAPL | Stock | 4.637 | 4.6371 | 4.6221 | 4.63 | 6890688.0 |
| 2009-05-11 11:00:00 | AAPL | Stock | 4.63 | 4.6386 | 4.6264 | 4.6289 | 3867948.0 |
| 2009-05-11 11:05:00 | AAPL | Stock | 4.6289 | 4.6321 | 4.6214 | 4.6283 | 4512592.0 |
| 2009-05-11 11:10:00 | AAPL | Stock | 4.6275 | 4.6464 | 4.6261 | 4.6429 | 4581892.0 |
| 2009-05-11 11:15:00 | AAPL | Stock | 4.6432 | 4.6564 | 4.6411 | 4.6436 | 6120436.0 |
| 2009-05-11 11:20:00 | AAPL | Stock | 4.6439 | 4.6442 | 4.625 | 4.6275 | 3032372.0 |
| 2009-05-11 11:25:00 | AAPL | Stock | 4.6268 | 4.6279 | 4.6214 | 4.625 | 2416652.0 |
| 2009-05-11 11:30:00 | AAPL | Stock | 4.6254 | 4.6432 | 4.6182 | 4.6211 | 7246960.0 |
| 2009-05-11 11:35:00 | AAPL | Stock | 4.6211 | 4.6304 | 4.6196 | 4.6293 | 3816596.0 |
| 2009-05-11 11:40:00 | AAPL | Stock | 4.6293 | 4.6336 | 4.6236 | 4.63 | 2266572.0 |
| 2009-05-11 11:45:00 | AAPL | Stock | 4.63 | 4.6464 | 4.6257 | 4.6432 | 2730700.0 |
| 2009-05-11 11:50:00 | AAPL | Stock | 4.6429 | 4.6446 | 4.6325 | 4.6343 | 2902032.0 |
> showing 50 of 323,532 rows — these rows as CSV