PREVIEW / stock_5min / 2009-08-06
file: by_date/stock_5min/2009/2009-08-06.parquet size: 4.7 MB rows: 325,881 symbols: 3,341
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-08-06 06:45:00 | AAPL | Stock | 5.8693 | 5.8693 | 5.8693 | 5.8693 | 16828.0 |
| 2009-08-06 06:50:00 | AAPL | Stock | 5.8693 | 5.8693 | 5.8693 | 5.8693 | 2828.0 |
| 2009-08-06 07:00:00 | AAPL | Stock | 5.8696 | 5.8696 | 5.8693 | 5.8693 | 8400.0 |
| 2009-08-06 07:05:00 | AAPL | Stock | 5.8786 | 5.8786 | 5.8786 | 5.8786 | 2800.0 |
| 2009-08-06 07:15:00 | AAPL | Stock | 5.8821 | 5.8821 | 5.8821 | 5.8821 | 2828.0 |
| 2009-08-06 07:35:00 | AAPL | Stock | 5.8821 | 5.8821 | 5.8821 | 5.8821 | 5600.0 |
| 2009-08-06 07:40:00 | AAPL | Stock | 5.8821 | 5.8821 | 5.8821 | 5.8821 | 14000.0 |
| 2009-08-06 07:45:00 | AAPL | Stock | 5.8821 | 5.8821 | 5.8793 | 5.8793 | 12600.0 |
| 2009-08-06 07:50:00 | AAPL | Stock | 5.8821 | 5.8821 | 5.8821 | 5.8821 | 5600.0 |
| 2009-08-06 07:55:00 | AAPL | Stock | 5.8821 | 5.8857 | 5.8821 | 5.8857 | 22400.0 |
| 2009-08-06 08:00:00 | AAPL | Stock | 5.8968 | 5.8968 | 5.8696 | 5.8696 | 159376.0 |
| 2009-08-06 08:05:00 | AAPL | Stock | 5.8768 | 5.8821 | 5.8764 | 5.8818 | 44380.0 |
| 2009-08-06 08:10:00 | AAPL | Stock | 5.8893 | 5.8893 | 5.8893 | 5.8893 | 8400.0 |
| 2009-08-06 08:15:00 | AAPL | Stock | 5.8893 | 5.8911 | 5.8879 | 5.8911 | 78680.0 |
| 2009-08-06 08:20:00 | AAPL | Stock | 5.8843 | 5.8843 | 5.8775 | 5.8843 | 17080.0 |
| 2009-08-06 08:25:00 | AAPL | Stock | 5.8907 | 5.8929 | 5.8889 | 5.8929 | 44800.0 |
| 2009-08-06 08:30:00 | AAPL | Stock | 5.8886 | 5.9121 | 5.8886 | 5.9089 | 154672.0 |
| 2009-08-06 08:35:00 | AAPL | Stock | 5.9071 | 5.9107 | 5.9036 | 5.9107 | 75600.0 |
| 2009-08-06 08:40:00 | AAPL | Stock | 5.9107 | 5.9179 | 5.9107 | 5.9179 | 85988.0 |
| 2009-08-06 08:45:00 | AAPL | Stock | 5.9171 | 5.9196 | 5.915 | 5.9179 | 174832.0 |
| 2009-08-06 08:50:00 | AAPL | Stock | 5.9179 | 5.9196 | 5.9175 | 5.9182 | 193816.0 |
| 2009-08-06 08:55:00 | AAPL | Stock | 5.9179 | 5.9182 | 5.9114 | 5.9161 | 132916.0 |
| 2009-08-06 09:00:00 | AAPL | Stock | 5.9157 | 5.9218 | 5.9143 | 5.9175 | 414512.0 |
| 2009-08-06 09:05:00 | AAPL | Stock | 5.9175 | 5.9189 | 5.9157 | 5.9175 | 90132.0 |
| 2009-08-06 09:10:00 | AAPL | Stock | 5.9171 | 5.9193 | 5.9168 | 5.9168 | 117264.0 |
| 2009-08-06 09:15:00 | AAPL | Stock | 5.9179 | 5.9179 | 5.9168 | 5.9168 | 37800.0 |
| 2009-08-06 09:20:00 | AAPL | Stock | 5.9179 | 5.9204 | 5.9071 | 5.9204 | 92764.0 |
| 2009-08-06 09:25:00 | AAPL | Stock | 5.92 | 5.92 | 5.9021 | 5.9125 | 666484.0 |
| 2009-08-06 09:30:00 | AAPL | Stock | 5.9136 | 5.9464 | 5.9046 | 5.9403 | 13048084.0 |
| 2009-08-06 09:35:00 | AAPL | Stock | 5.94 | 5.9468 | 5.9266 | 5.9371 | 13813100.0 |
| 2009-08-06 09:40:00 | AAPL | Stock | 5.9361 | 5.9382 | 5.8946 | 5.9025 | 10225264.0 |
| 2009-08-06 09:45:00 | AAPL | Stock | 5.9018 | 5.9021 | 5.8839 | 5.8871 | 7531552.0 |
| 2009-08-06 09:50:00 | AAPL | Stock | 5.8869 | 5.9039 | 5.8864 | 5.8964 | 7691600.0 |
| 2009-08-06 09:55:00 | AAPL | Stock | 5.8964 | 5.9071 | 5.8925 | 5.8954 | 8462608.0 |
| 2009-08-06 10:00:00 | AAPL | Stock | 5.8957 | 5.9007 | 5.8857 | 5.8986 | 7706104.0 |
| 2009-08-06 10:05:00 | AAPL | Stock | 5.8982 | 5.9018 | 5.8821 | 5.885 | 6577172.0 |
| 2009-08-06 10:10:00 | AAPL | Stock | 5.8849 | 5.8896 | 5.8761 | 5.8821 | 4841368.0 |
| 2009-08-06 10:15:00 | AAPL | Stock | 5.8832 | 5.8886 | 5.875 | 5.8861 | 6233752.0 |
| 2009-08-06 10:20:00 | AAPL | Stock | 5.8857 | 5.8893 | 5.8789 | 5.8789 | 3581396.0 |
| 2009-08-06 10:25:00 | AAPL | Stock | 5.8789 | 5.8796 | 5.8668 | 5.8725 | 5090848.0 |
| 2009-08-06 10:30:00 | AAPL | Stock | 5.8721 | 5.8786 | 5.87 | 5.8707 | 2896096.0 |
| 2009-08-06 10:35:00 | AAPL | Stock | 5.8696 | 5.8882 | 5.8693 | 5.8814 | 4378640.0 |
| 2009-08-06 10:40:00 | AAPL | Stock | 5.8818 | 5.8868 | 5.8782 | 5.8807 | 2096668.0 |
| 2009-08-06 10:45:00 | AAPL | Stock | 5.8804 | 5.8843 | 5.8757 | 5.8768 | 2584008.0 |
| 2009-08-06 10:50:00 | AAPL | Stock | 5.8761 | 5.8767 | 5.8543 | 5.8571 | 9562588.0 |
| 2009-08-06 10:55:00 | AAPL | Stock | 5.8571 | 5.8618 | 5.8561 | 5.8604 | 3149160.0 |
| 2009-08-06 11:00:00 | AAPL | Stock | 5.8603 | 5.8729 | 5.8596 | 5.8696 | 3890432.0 |
| 2009-08-06 11:05:00 | AAPL | Stock | 5.8704 | 5.8861 | 5.8704 | 5.8718 | 5386024.0 |
| 2009-08-06 11:10:00 | AAPL | Stock | 5.8721 | 5.8811 | 5.8707 | 5.8782 | 2432500.0 |
| 2009-08-06 11:15:00 | AAPL | Stock | 5.8771 | 5.8911 | 5.8771 | 5.8879 | 4480224.0 |
> showing 50 of 325,881 rows — these rows as CSV