PREVIEW / stock_5min / 2007-10-05
file: by_date/stock_5min/2007/2007-10-05.parquet size: 4.2 MB rows: 307,834 symbols: 3,141
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 |
|---|---|---|---|---|---|---|---|
| 2007-10-05 06:00:00 | AAPL | Stock | 5.5893 | 5.5893 | 5.5893 | 5.5893 | 4200.0 |
| 2007-10-05 06:55:00 | AAPL | Stock | 5.5893 | 5.5893 | 5.5893 | 5.5893 | 15624.0 |
| 2007-10-05 07:10:00 | AAPL | Stock | 5.5814 | 5.5814 | 5.5814 | 5.5814 | 22400.0 |
| 2007-10-05 07:20:00 | AAPL | Stock | 5.5814 | 5.5814 | 5.5814 | 5.5814 | 2800.0 |
| 2007-10-05 07:25:00 | AAPL | Stock | 5.5714 | 5.5714 | 5.5714 | 5.5714 | 28000.0 |
| 2007-10-05 07:30:00 | AAPL | Stock | 5.5714 | 5.5764 | 5.5714 | 5.5714 | 98140.0 |
| 2007-10-05 07:50:00 | AAPL | Stock | 5.5893 | 5.5893 | 5.5857 | 5.5868 | 22400.0 |
| 2007-10-05 07:55:00 | AAPL | Stock | 5.5868 | 5.6014 | 5.5868 | 5.5929 | 50960.0 |
| 2007-10-05 08:00:00 | AAPL | Stock | 5.5893 | 5.6196 | 5.5893 | 5.6107 | 827232.0 |
| 2007-10-05 08:05:00 | AAPL | Stock | 5.6082 | 5.6104 | 5.6057 | 5.6071 | 400512.0 |
| 2007-10-05 08:10:00 | AAPL | Stock | 5.6071 | 5.6107 | 5.6036 | 5.6107 | 319340.0 |
| 2007-10-05 08:15:00 | AAPL | Stock | 5.6107 | 5.6161 | 5.6107 | 5.6143 | 492436.0 |
| 2007-10-05 08:20:00 | AAPL | Stock | 5.6161 | 5.6214 | 5.6143 | 5.6175 | 537432.0 |
| 2007-10-05 08:25:00 | AAPL | Stock | 5.6161 | 5.6171 | 5.61 | 5.61 | 358568.0 |
| 2007-10-05 08:30:00 | AAPL | Stock | 5.61 | 5.6286 | 5.61 | 5.6268 | 1902880.0 |
| 2007-10-05 08:35:00 | AAPL | Stock | 5.6268 | 5.6518 | 5.6211 | 5.6504 | 2886212.0 |
| 2007-10-05 08:40:00 | AAPL | Stock | 5.6511 | 5.6529 | 5.6421 | 5.6461 | 1924944.0 |
| 2007-10-05 08:45:00 | AAPL | Stock | 5.6461 | 5.6521 | 5.6432 | 5.6464 | 948976.0 |
| 2007-10-05 08:50:00 | AAPL | Stock | 5.6464 | 5.6525 | 5.6446 | 5.6446 | 989100.0 |
| 2007-10-05 08:55:00 | AAPL | Stock | 5.6436 | 5.6457 | 5.6279 | 5.6321 | 937188.0 |
| 2007-10-05 09:00:00 | AAPL | Stock | 5.6321 | 5.6421 | 5.6321 | 5.6418 | 316596.0 |
| 2007-10-05 09:05:00 | AAPL | Stock | 5.6418 | 5.6504 | 5.6407 | 5.6468 | 1484980.0 |
| 2007-10-05 09:10:00 | AAPL | Stock | 5.6468 | 5.6482 | 5.6389 | 5.6429 | 943600.0 |
| 2007-10-05 09:15:00 | AAPL | Stock | 5.6464 | 5.655 | 5.6429 | 5.6536 | 573552.0 |
| 2007-10-05 09:20:00 | AAPL | Stock | 5.6543 | 5.6696 | 5.6485 | 5.6671 | 914088.0 |
| 2007-10-05 09:25:00 | AAPL | Stock | 5.6632 | 5.6725 | 5.6493 | 5.6607 | 1270388.0 |
| 2007-10-05 09:30:00 | AAPL | Stock | 5.6586 | 5.6643 | 5.6364 | 5.6625 | 31768884.0 |
| 2007-10-05 09:35:00 | AAPL | Stock | 5.6621 | 5.6889 | 5.6577 | 5.6686 | 36475292.0 |
| 2007-10-05 09:40:00 | AAPL | Stock | 5.6686 | 5.6746 | 5.6507 | 5.6536 | 19563992.0 |
| 2007-10-05 09:45:00 | AAPL | Stock | 5.6536 | 5.6632 | 5.635 | 5.6429 | 18444916.0 |
| 2007-10-05 09:50:00 | AAPL | Stock | 5.6432 | 5.6471 | 5.6339 | 5.6354 | 11766076.0 |
| 2007-10-05 09:55:00 | AAPL | Stock | 5.6354 | 5.6582 | 5.6321 | 5.6571 | 13954864.0 |
| 2007-10-05 10:00:00 | AAPL | Stock | 5.6571 | 5.6589 | 5.6489 | 5.6529 | 9389408.0 |
| 2007-10-05 10:05:00 | AAPL | Stock | 5.6529 | 5.6757 | 5.6504 | 5.675 | 12446924.0 |
| 2007-10-05 10:10:00 | AAPL | Stock | 5.675 | 5.6832 | 5.6614 | 5.6693 | 15485540.0 |
| 2007-10-05 10:15:00 | AAPL | Stock | 5.6686 | 5.6736 | 5.6539 | 5.6568 | 12265932.0 |
| 2007-10-05 10:20:00 | AAPL | Stock | 5.6564 | 5.6646 | 5.6518 | 5.6586 | 6261500.0 |
| 2007-10-05 10:25:00 | AAPL | Stock | 5.6575 | 5.6604 | 5.6504 | 5.6504 | 5927628.0 |
| 2007-10-05 10:30:00 | AAPL | Stock | 5.6504 | 5.6625 | 5.6454 | 5.6611 | 9761556.0 |
| 2007-10-05 10:35:00 | AAPL | Stock | 5.6614 | 5.6707 | 5.6607 | 5.6664 | 9086644.0 |
| 2007-10-05 10:40:00 | AAPL | Stock | 5.6664 | 5.6746 | 5.6629 | 5.6736 | 6989556.0 |
| 2007-10-05 10:45:00 | AAPL | Stock | 5.6746 | 5.6775 | 5.6718 | 5.6739 | 8703940.0 |
| 2007-10-05 10:50:00 | AAPL | Stock | 5.6739 | 5.6768 | 5.6664 | 5.6668 | 9841636.0 |
| 2007-10-05 10:55:00 | AAPL | Stock | 5.6664 | 5.6864 | 5.6654 | 5.6854 | 12578888.0 |
| 2007-10-05 11:00:00 | AAPL | Stock | 5.6857 | 5.6864 | 5.6811 | 5.6821 | 13929944.0 |
| 2007-10-05 11:05:00 | AAPL | Stock | 5.6821 | 5.6857 | 5.6786 | 5.6796 | 8895264.0 |
| 2007-10-05 11:10:00 | AAPL | Stock | 5.6802 | 5.6868 | 5.6789 | 5.6857 | 9874732.0 |
| 2007-10-05 11:15:00 | AAPL | Stock | 5.6857 | 5.6943 | 5.6846 | 5.6921 | 18112136.0 |
| 2007-10-05 11:20:00 | AAPL | Stock | 5.6921 | 5.6968 | 5.6896 | 5.69 | 13997480.0 |
| 2007-10-05 11:25:00 | AAPL | Stock | 5.6896 | 5.69 | 5.6789 | 5.6839 | 9044644.0 |
> showing 50 of 307,834 rows — these rows as CSV