PREVIEW / stock_5min / 2008-03-24
file: by_date/stock_5min/2008/2008-03-24.parquet size: 4.5 MB rows: 325,338 symbols: 3,298
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 |
|---|---|---|---|---|---|---|---|
| 2008-03-24 07:00:00 | AAPL | Stock | 4.7686 | 4.7686 | 4.7686 | 4.7686 | 2800.0 |
| 2008-03-24 07:20:00 | AAPL | Stock | 4.7686 | 4.7686 | 4.7686 | 4.7686 | 86800.0 |
| 2008-03-24 07:25:00 | AAPL | Stock | 4.7704 | 4.7857 | 4.7704 | 4.7854 | 11200.0 |
| 2008-03-24 07:30:00 | AAPL | Stock | 4.7857 | 4.7946 | 4.7857 | 4.7925 | 70000.0 |
| 2008-03-24 07:45:00 | AAPL | Stock | 4.7868 | 4.7868 | 4.7779 | 4.7779 | 14000.0 |
| 2008-03-24 07:50:00 | AAPL | Stock | 4.7786 | 4.7786 | 4.7786 | 4.7786 | 12852.0 |
| 2008-03-24 08:00:00 | AAPL | Stock | 4.7771 | 4.7832 | 4.7679 | 4.775 | 100268.0 |
| 2008-03-24 08:05:00 | AAPL | Stock | 4.7757 | 4.7857 | 4.7757 | 4.7854 | 268408.0 |
| 2008-03-24 08:10:00 | AAPL | Stock | 4.7854 | 4.7857 | 4.7821 | 4.7821 | 130228.0 |
| 2008-03-24 08:15:00 | AAPL | Stock | 4.7821 | 4.7832 | 4.7771 | 4.7807 | 142800.0 |
| 2008-03-24 08:20:00 | AAPL | Stock | 4.7771 | 4.7836 | 4.775 | 4.7804 | 287224.0 |
| 2008-03-24 08:25:00 | AAPL | Stock | 4.7804 | 4.7875 | 4.7804 | 4.7857 | 327936.0 |
| 2008-03-24 08:30:00 | AAPL | Stock | 4.7796 | 4.7854 | 4.7789 | 4.7846 | 86100.0 |
| 2008-03-24 08:35:00 | AAPL | Stock | 4.7843 | 4.7854 | 4.78 | 4.7821 | 78960.0 |
| 2008-03-24 08:40:00 | AAPL | Stock | 4.7829 | 4.7829 | 4.7807 | 4.7807 | 47152.0 |
| 2008-03-24 08:45:00 | AAPL | Stock | 4.7807 | 4.7814 | 4.7804 | 4.7811 | 201796.0 |
| 2008-03-24 08:50:00 | AAPL | Stock | 4.7811 | 4.785 | 4.7807 | 4.7829 | 207200.0 |
| 2008-03-24 08:55:00 | AAPL | Stock | 4.7846 | 4.7857 | 4.7836 | 4.7857 | 203224.0 |
| 2008-03-24 09:00:00 | AAPL | Stock | 4.7857 | 4.7864 | 4.7821 | 4.7825 | 256620.0 |
| 2008-03-24 09:05:00 | AAPL | Stock | 4.7839 | 4.7893 | 4.7836 | 4.7879 | 334992.0 |
| 2008-03-24 09:10:00 | AAPL | Stock | 4.79 | 4.7943 | 4.7889 | 4.7932 | 342468.0 |
| 2008-03-24 09:15:00 | AAPL | Stock | 4.7918 | 4.7936 | 4.7829 | 4.7839 | 324828.0 |
| 2008-03-24 09:20:00 | AAPL | Stock | 4.7854 | 4.7857 | 4.7839 | 4.7839 | 345072.0 |
| 2008-03-24 09:25:00 | AAPL | Stock | 4.7829 | 4.7911 | 4.7821 | 4.7864 | 559860.0 |
| 2008-03-24 09:30:00 | AAPL | Stock | 4.7861 | 4.8093 | 4.7857 | 4.8007 | 30035684.0 |
| 2008-03-24 09:35:00 | AAPL | Stock | 4.8014 | 4.8018 | 4.7729 | 4.8007 | 23246272.0 |
| 2008-03-24 09:40:00 | AAPL | Stock | 4.8011 | 4.8182 | 4.7996 | 4.8089 | 20128332.0 |
| 2008-03-24 09:45:00 | AAPL | Stock | 4.8086 | 4.8132 | 4.7857 | 4.8007 | 16478392.0 |
| 2008-03-24 09:50:00 | AAPL | Stock | 4.8007 | 4.8193 | 4.7968 | 4.8018 | 13505240.0 |
| 2008-03-24 09:55:00 | AAPL | Stock | 4.8011 | 4.8121 | 4.795 | 4.8104 | 13471892.0 |
| 2008-03-24 10:00:00 | AAPL | Stock | 4.81 | 4.8407 | 4.805 | 4.8368 | 23795352.0 |
| 2008-03-24 10:05:00 | AAPL | Stock | 4.8371 | 4.8454 | 4.8312 | 4.8364 | 12844384.0 |
| 2008-03-24 10:10:00 | AAPL | Stock | 4.8356 | 4.8743 | 4.8339 | 4.8721 | 16741256.0 |
| 2008-03-24 10:15:00 | AAPL | Stock | 4.8714 | 4.8743 | 4.8611 | 4.87 | 13701408.0 |
| 2008-03-24 10:20:00 | AAPL | Stock | 4.8704 | 4.875 | 4.8529 | 4.875 | 15188320.0 |
| 2008-03-24 10:25:00 | AAPL | Stock | 4.875 | 4.9164 | 4.8736 | 4.9079 | 29460676.0 |
| 2008-03-24 10:30:00 | AAPL | Stock | 4.9089 | 4.9529 | 4.9046 | 4.9332 | 27070232.0 |
| 2008-03-24 10:35:00 | AAPL | Stock | 4.9321 | 4.9389 | 4.9179 | 4.9282 | 14891996.0 |
| 2008-03-24 10:40:00 | AAPL | Stock | 4.9286 | 4.9304 | 4.9143 | 4.925 | 13589744.0 |
| 2008-03-24 10:45:00 | AAPL | Stock | 4.925 | 4.9275 | 4.9146 | 4.9195 | 10362296.0 |
| 2008-03-24 10:50:00 | AAPL | Stock | 4.9189 | 4.9268 | 4.9096 | 4.9107 | 8516788.0 |
| 2008-03-24 10:55:00 | AAPL | Stock | 4.9107 | 4.9225 | 4.9046 | 4.9214 | 13006504.0 |
| 2008-03-24 11:00:00 | AAPL | Stock | 4.9214 | 4.9266 | 4.9182 | 4.9229 | 8950144.0 |
| 2008-03-24 11:05:00 | AAPL | Stock | 4.9232 | 4.9371 | 4.9225 | 4.9271 | 12118596.0 |
| 2008-03-24 11:10:00 | AAPL | Stock | 4.9268 | 4.9432 | 4.9268 | 4.9397 | 12150404.0 |
| 2008-03-24 11:15:00 | AAPL | Stock | 4.9414 | 4.9493 | 4.9329 | 4.9404 | 11495820.0 |
| 2008-03-24 11:20:00 | AAPL | Stock | 4.9404 | 4.9532 | 4.9357 | 4.952 | 9800140.0 |
| 2008-03-24 11:25:00 | AAPL | Stock | 4.9529 | 4.9696 | 4.9471 | 4.9654 | 17819284.0 |
| 2008-03-24 11:30:00 | AAPL | Stock | 4.9654 | 4.9782 | 4.9596 | 4.9764 | 13678056.0 |
| 2008-03-24 11:35:00 | AAPL | Stock | 4.9764 | 4.9886 | 4.9754 | 4.9877 | 16221688.0 |
> showing 50 of 325,338 rows — these rows as CSV