PREVIEW / stock_5min / 2008-11-05
file: by_date/stock_5min/2008/2008-11-05.parquet size: 4.4 MB rows: 314,419 symbols: 3,280
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-11-05 04:15:00 | AAPL | Stock | 3.9529 | 3.9529 | 3.9529 | 3.9529 | 8400.0 |
| 2008-11-05 06:55:00 | AAPL | Stock | 3.9425 | 3.9425 | 3.9282 | 3.9282 | 14000.0 |
| 2008-11-05 07:00:00 | AAPL | Stock | 3.9282 | 3.9282 | 3.9282 | 3.9282 | 2800.0 |
| 2008-11-05 07:05:00 | AAPL | Stock | 3.9286 | 3.9286 | 3.9282 | 3.9282 | 14000.0 |
| 2008-11-05 07:10:00 | AAPL | Stock | 3.9268 | 3.9286 | 3.9268 | 3.9286 | 177604.0 |
| 2008-11-05 07:15:00 | AAPL | Stock | 3.9289 | 3.9289 | 3.915 | 3.915 | 71596.0 |
| 2008-11-05 07:20:00 | AAPL | Stock | 3.9143 | 3.9143 | 3.9039 | 3.9118 | 14000.0 |
| 2008-11-05 07:30:00 | AAPL | Stock | 3.9207 | 3.9207 | 3.92 | 3.92 | 16800.0 |
| 2008-11-05 07:35:00 | AAPL | Stock | 3.9118 | 3.9146 | 3.9118 | 3.9136 | 75600.0 |
| 2008-11-05 07:40:00 | AAPL | Stock | 3.9039 | 3.9107 | 3.9039 | 3.9107 | 15204.0 |
| 2008-11-05 07:45:00 | AAPL | Stock | 3.905 | 3.905 | 3.8964 | 3.8964 | 131600.0 |
| 2008-11-05 07:50:00 | AAPL | Stock | 3.8968 | 3.9007 | 3.8929 | 3.8929 | 158396.0 |
| 2008-11-05 08:00:00 | AAPL | Stock | 3.8954 | 3.9107 | 3.8939 | 3.9036 | 269892.0 |
| 2008-11-05 08:05:00 | AAPL | Stock | 3.9036 | 3.9089 | 3.9021 | 3.9071 | 263284.0 |
| 2008-11-05 08:10:00 | AAPL | Stock | 3.9089 | 3.9161 | 3.9071 | 3.9139 | 461300.0 |
| 2008-11-05 08:15:00 | AAPL | Stock | 3.9125 | 3.9125 | 3.8893 | 3.8929 | 784028.0 |
| 2008-11-05 08:20:00 | AAPL | Stock | 3.8929 | 3.8936 | 3.8857 | 3.8861 | 310800.0 |
| 2008-11-05 08:25:00 | AAPL | Stock | 3.8861 | 3.8968 | 3.8857 | 3.8968 | 284620.0 |
| 2008-11-05 08:30:00 | AAPL | Stock | 3.8929 | 3.9064 | 3.8929 | 3.9064 | 270116.0 |
| 2008-11-05 08:35:00 | AAPL | Stock | 3.8975 | 3.8989 | 3.8893 | 3.8929 | 124740.0 |
| 2008-11-05 08:40:00 | AAPL | Stock | 3.8893 | 3.8914 | 3.8875 | 3.8893 | 120596.0 |
| 2008-11-05 08:45:00 | AAPL | Stock | 3.8918 | 3.8979 | 3.8893 | 3.8979 | 196224.0 |
| 2008-11-05 08:50:00 | AAPL | Stock | 3.8982 | 3.9 | 3.8943 | 3.8964 | 163800.0 |
| 2008-11-05 08:55:00 | AAPL | Stock | 3.8946 | 3.9039 | 3.8946 | 3.9039 | 208488.0 |
| 2008-11-05 09:00:00 | AAPL | Stock | 3.9036 | 3.9046 | 3.9004 | 3.9007 | 98504.0 |
| 2008-11-05 09:05:00 | AAPL | Stock | 3.9007 | 3.9025 | 3.8714 | 3.8804 | 1049860.0 |
| 2008-11-05 09:10:00 | AAPL | Stock | 3.8775 | 3.8829 | 3.8693 | 3.8829 | 552244.0 |
| 2008-11-05 09:15:00 | AAPL | Stock | 3.8821 | 3.8825 | 3.8736 | 3.8736 | 95060.0 |
| 2008-11-05 09:20:00 | AAPL | Stock | 3.8771 | 3.8925 | 3.8771 | 3.8911 | 244440.0 |
| 2008-11-05 09:25:00 | AAPL | Stock | 3.8864 | 3.9014 | 3.8832 | 3.8925 | 585956.0 |
| 2008-11-05 09:30:00 | AAPL | Stock | 3.8929 | 3.8946 | 3.8393 | 3.8532 | 33772284.0 |
| 2008-11-05 09:35:00 | AAPL | Stock | 3.8536 | 3.8632 | 3.8304 | 3.8571 | 27731284.0 |
| 2008-11-05 09:40:00 | AAPL | Stock | 3.8567 | 3.8604 | 3.8361 | 3.85 | 22134084.0 |
| 2008-11-05 09:45:00 | AAPL | Stock | 3.8488 | 3.8818 | 3.8436 | 3.8795 | 28791140.0 |
| 2008-11-05 09:50:00 | AAPL | Stock | 3.8775 | 3.9011 | 3.8721 | 3.8954 | 37733556.0 |
| 2008-11-05 09:55:00 | AAPL | Stock | 3.8954 | 3.8954 | 3.8689 | 3.8757 | 17196116.0 |
| 2008-11-05 10:00:00 | AAPL | Stock | 3.8761 | 3.9089 | 3.8671 | 3.8975 | 28377636.0 |
| 2008-11-05 10:05:00 | AAPL | Stock | 3.8971 | 3.9104 | 3.8832 | 3.9071 | 18073720.0 |
| 2008-11-05 10:10:00 | AAPL | Stock | 3.9071 | 3.9075 | 3.8825 | 3.8832 | 18937156.0 |
| 2008-11-05 10:15:00 | AAPL | Stock | 3.8821 | 3.8964 | 3.8768 | 3.8874 | 14810488.0 |
| 2008-11-05 10:20:00 | AAPL | Stock | 3.8875 | 3.9164 | 3.8875 | 3.9075 | 16992276.0 |
| 2008-11-05 10:25:00 | AAPL | Stock | 3.9068 | 3.9096 | 3.8918 | 3.9061 | 16544808.0 |
| 2008-11-05 10:30:00 | AAPL | Stock | 3.9064 | 3.9186 | 3.9018 | 3.9054 | 17088260.0 |
| 2008-11-05 10:35:00 | AAPL | Stock | 3.9057 | 3.9079 | 3.8861 | 3.8879 | 16299108.0 |
| 2008-11-05 10:40:00 | AAPL | Stock | 3.8872 | 3.8964 | 3.8825 | 3.8889 | 10691828.0 |
| 2008-11-05 10:45:00 | AAPL | Stock | 3.8896 | 3.8996 | 3.8804 | 3.8961 | 11355316.0 |
| 2008-11-05 10:50:00 | AAPL | Stock | 3.8961 | 3.8971 | 3.8732 | 3.8779 | 14058856.0 |
| 2008-11-05 10:55:00 | AAPL | Stock | 3.8775 | 3.8825 | 3.8625 | 3.8689 | 13392260.0 |
| 2008-11-05 11:00:00 | AAPL | Stock | 3.8696 | 3.8775 | 3.8632 | 3.8671 | 8917888.0 |
| 2008-11-05 11:05:00 | AAPL | Stock | 3.8675 | 3.8804 | 3.8625 | 3.8721 | 11652872.0 |
> showing 50 of 314,419 rows — these rows as CSV