PREVIEW / stock_5min / 2010-04-16
file: by_date/stock_5min/2010/2010-04-16.parquet size: 5.0 MB rows: 334,487 symbols: 3,476
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-04-16 04:30:00 | AAPL | Stock | 8.8639 | 8.8639 | 8.8639 | 8.8639 | 6160.0 |
| 2010-04-16 04:35:00 | AAPL | Stock | 8.8639 | 8.8639 | 8.8639 | 8.8639 | 14000.0 |
| 2010-04-16 04:45:00 | AAPL | Stock | 8.8639 | 8.8639 | 8.8639 | 8.8639 | 5600.0 |
| 2010-04-16 05:10:00 | AAPL | Stock | 8.8639 | 8.8639 | 8.8639 | 8.8639 | 4284.0 |
| 2010-04-16 05:20:00 | AAPL | Stock | 8.8639 | 8.8639 | 8.8639 | 8.8639 | 2800.0 |
| 2010-04-16 06:00:00 | AAPL | Stock | 8.8714 | 8.8714 | 8.8714 | 8.8714 | 2800.0 |
| 2010-04-16 06:15:00 | AAPL | Stock | 8.8607 | 8.8607 | 8.8607 | 8.8607 | 2800.0 |
| 2010-04-16 06:35:00 | AAPL | Stock | 8.8607 | 8.8607 | 8.8607 | 8.8607 | 2800.0 |
| 2010-04-16 07:00:00 | AAPL | Stock | 8.8607 | 8.8607 | 8.8607 | 8.8607 | 2800.0 |
| 2010-04-16 07:05:00 | AAPL | Stock | 8.8607 | 8.8607 | 8.8607 | 8.8607 | 28000.0 |
| 2010-04-16 07:15:00 | AAPL | Stock | 8.8661 | 8.875 | 8.8661 | 8.875 | 20300.0 |
| 2010-04-16 07:20:00 | AAPL | Stock | 8.8675 | 8.8675 | 8.8675 | 8.8675 | 31080.0 |
| 2010-04-16 07:25:00 | AAPL | Stock | 8.8571 | 8.8571 | 8.8571 | 8.8571 | 2800.0 |
| 2010-04-16 07:30:00 | AAPL | Stock | 8.8632 | 8.8632 | 8.8632 | 8.8632 | 5600.0 |
| 2010-04-16 07:35:00 | AAPL | Stock | 8.8632 | 8.8632 | 8.8536 | 8.8632 | 11200.0 |
| 2010-04-16 07:40:00 | AAPL | Stock | 8.8632 | 8.8632 | 8.8632 | 8.8632 | 2800.0 |
| 2010-04-16 07:50:00 | AAPL | Stock | 8.8625 | 8.8632 | 8.8625 | 8.8632 | 28000.0 |
| 2010-04-16 07:55:00 | AAPL | Stock | 8.8604 | 8.8604 | 8.8571 | 8.8571 | 56000.0 |
| 2010-04-16 08:00:00 | AAPL | Stock | 8.8611 | 8.8661 | 8.8575 | 8.8607 | 101276.0 |
| 2010-04-16 08:05:00 | AAPL | Stock | 8.865 | 8.8754 | 8.8639 | 8.8679 | 509292.0 |
| 2010-04-16 08:10:00 | AAPL | Stock | 8.8679 | 8.8736 | 8.8679 | 8.8729 | 100436.0 |
| 2010-04-16 08:15:00 | AAPL | Stock | 8.8725 | 8.8725 | 8.8571 | 8.8625 | 235480.0 |
| 2010-04-16 08:20:00 | AAPL | Stock | 8.8661 | 8.8696 | 8.8643 | 8.8668 | 21560.0 |
| 2010-04-16 08:25:00 | AAPL | Stock | 8.865 | 8.8654 | 8.8643 | 8.8654 | 80640.0 |
| 2010-04-16 08:30:00 | AAPL | Stock | 8.8654 | 8.8714 | 8.8654 | 8.8679 | 36540.0 |
| 2010-04-16 08:35:00 | AAPL | Stock | 8.865 | 8.8671 | 8.8629 | 8.8664 | 59612.0 |
| 2010-04-16 08:40:00 | AAPL | Stock | 8.8643 | 8.8646 | 8.8554 | 8.8568 | 309960.0 |
| 2010-04-16 08:45:00 | AAPL | Stock | 8.8554 | 8.8571 | 8.8536 | 8.8539 | 85540.0 |
| 2010-04-16 08:50:00 | AAPL | Stock | 8.8571 | 8.8586 | 8.8543 | 8.8586 | 35896.0 |
| 2010-04-16 08:55:00 | AAPL | Stock | 8.8604 | 8.8625 | 8.8604 | 8.8625 | 56924.0 |
| 2010-04-16 09:00:00 | AAPL | Stock | 8.8607 | 8.8614 | 8.8557 | 8.8614 | 56000.0 |
| 2010-04-16 09:05:00 | AAPL | Stock | 8.8621 | 8.8621 | 8.8543 | 8.8543 | 116676.0 |
| 2010-04-16 09:10:00 | AAPL | Stock | 8.8546 | 8.8546 | 8.8518 | 8.8521 | 75292.0 |
| 2010-04-16 09:15:00 | AAPL | Stock | 8.8518 | 8.8554 | 8.8414 | 8.85 | 290864.0 |
| 2010-04-16 09:20:00 | AAPL | Stock | 8.8518 | 8.8568 | 8.8507 | 8.855 | 138600.0 |
| 2010-04-16 09:25:00 | AAPL | Stock | 8.8529 | 8.8786 | 8.8529 | 8.8775 | 724304.0 |
| 2010-04-16 09:30:00 | AAPL | Stock | 8.8775 | 8.9136 | 8.875 | 8.8975 | 29651720.0 |
| 2010-04-16 09:35:00 | AAPL | Stock | 8.8964 | 8.9032 | 8.8904 | 8.9018 | 14070756.0 |
| 2010-04-16 09:40:00 | AAPL | Stock | 8.9018 | 8.9129 | 8.8875 | 8.8896 | 14278264.0 |
| 2010-04-16 09:45:00 | AAPL | Stock | 8.8896 | 8.8945 | 8.8821 | 8.8929 | 10429412.0 |
| 2010-04-16 09:50:00 | AAPL | Stock | 8.8921 | 8.8968 | 8.8818 | 8.8839 | 10657472.0 |
| 2010-04-16 09:55:00 | AAPL | Stock | 8.8818 | 8.9054 | 8.8818 | 8.905 | 18068932.0 |
| 2010-04-16 10:00:00 | AAPL | Stock | 8.9046 | 8.9193 | 8.8979 | 8.9107 | 12906264.0 |
| 2010-04-16 10:05:00 | AAPL | Stock | 8.9107 | 8.925 | 8.9096 | 8.9218 | 11044656.0 |
| 2010-04-16 10:10:00 | AAPL | Stock | 8.9218 | 8.9436 | 8.92 | 8.9429 | 21436828.0 |
| 2010-04-16 10:15:00 | AAPL | Stock | 8.9427 | 8.9693 | 8.94 | 8.9514 | 28190960.0 |
| 2010-04-16 10:20:00 | AAPL | Stock | 8.9511 | 8.9589 | 8.94 | 8.9521 | 11017636.0 |
| 2010-04-16 10:25:00 | AAPL | Stock | 8.9511 | 8.9596 | 8.9396 | 8.9396 | 8246196.0 |
| 2010-04-16 10:30:00 | AAPL | Stock | 8.9396 | 8.955 | 8.9396 | 8.9436 | 5919872.0 |
| 2010-04-16 10:35:00 | AAPL | Stock | 8.9439 | 8.9507 | 8.9104 | 8.9107 | 14169932.0 |
> showing 50 of 334,487 rows — these rows as CSV