PREVIEW / stock_5min / 2008-09-30
file: by_date/stock_5min/2008/2008-09-30.parquet size: 4.7 MB rows: 333,642 symbols: 3,384
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-09-30 04:10:00 | AAPL | Stock | 3.7882 | 3.7882 | 3.7857 | 3.7857 | 31052.0 |
| 2008-09-30 04:20:00 | AAPL | Stock | 3.8211 | 3.8211 | 3.7746 | 3.8136 | 96600.0 |
| 2008-09-30 04:25:00 | AAPL | Stock | 3.8032 | 3.8032 | 3.8032 | 3.8032 | 5600.0 |
| 2008-09-30 04:30:00 | AAPL | Stock | 3.7786 | 3.7857 | 3.7786 | 3.7821 | 89600.0 |
| 2008-09-30 04:35:00 | AAPL | Stock | 3.7857 | 3.7857 | 3.7821 | 3.7821 | 25200.0 |
| 2008-09-30 05:05:00 | AAPL | Stock | 3.7768 | 3.7768 | 3.7768 | 3.7768 | 2800.0 |
| 2008-09-30 05:10:00 | AAPL | Stock | 3.7768 | 3.7768 | 3.7768 | 3.7768 | 2800.0 |
| 2008-09-30 05:15:00 | AAPL | Stock | 3.7839 | 3.7911 | 3.7839 | 3.7839 | 25200.0 |
| 2008-09-30 05:20:00 | AAPL | Stock | 3.7839 | 3.8 | 3.7839 | 3.8 | 78820.0 |
| 2008-09-30 05:25:00 | AAPL | Stock | 3.8 | 3.8 | 3.7857 | 3.7857 | 19600.0 |
| 2008-09-30 05:30:00 | AAPL | Stock | 3.7839 | 3.7946 | 3.7839 | 3.7946 | 16800.0 |
| 2008-09-30 05:35:00 | AAPL | Stock | 3.7857 | 3.7857 | 3.7857 | 3.7857 | 64540.0 |
| 2008-09-30 05:40:00 | AAPL | Stock | 3.7961 | 3.7964 | 3.7961 | 3.7964 | 5600.0 |
| 2008-09-30 05:45:00 | AAPL | Stock | 3.8 | 3.8 | 3.8 | 3.8 | 2800.0 |
| 2008-09-30 05:50:00 | AAPL | Stock | 3.8068 | 3.8214 | 3.8 | 3.8214 | 39900.0 |
| 2008-09-30 05:55:00 | AAPL | Stock | 3.8179 | 3.8214 | 3.8179 | 3.8214 | 19600.0 |
| 2008-09-30 06:10:00 | AAPL | Stock | 3.8214 | 3.8214 | 3.8214 | 3.8214 | 2800.0 |
| 2008-09-30 06:15:00 | AAPL | Stock | 3.7964 | 3.7964 | 3.7964 | 3.7964 | 28000.0 |
| 2008-09-30 06:20:00 | AAPL | Stock | 3.7964 | 3.8036 | 3.7857 | 3.8036 | 123200.0 |
| 2008-09-30 06:25:00 | AAPL | Stock | 3.8036 | 3.8036 | 3.795 | 3.795 | 64400.0 |
| 2008-09-30 06:30:00 | AAPL | Stock | 3.7861 | 3.7943 | 3.7857 | 3.7943 | 47600.0 |
| 2008-09-30 06:35:00 | AAPL | Stock | 3.7857 | 3.7857 | 3.7857 | 3.7857 | 61656.0 |
| 2008-09-30 06:40:00 | AAPL | Stock | 3.7857 | 3.7857 | 3.7857 | 3.7857 | 70000.0 |
| 2008-09-30 06:45:00 | AAPL | Stock | 3.7857 | 3.8036 | 3.7857 | 3.8036 | 192444.0 |
| 2008-09-30 06:55:00 | AAPL | Stock | 3.7896 | 3.7896 | 3.7743 | 3.7768 | 232428.0 |
| 2008-09-30 07:00:00 | AAPL | Stock | 3.7768 | 3.8029 | 3.7714 | 3.7714 | 304472.0 |
| 2008-09-30 07:05:00 | AAPL | Stock | 3.7714 | 3.7804 | 3.7596 | 3.7768 | 196084.0 |
| 2008-09-30 07:10:00 | AAPL | Stock | 3.7768 | 3.7854 | 3.7693 | 3.7696 | 478072.0 |
| 2008-09-30 07:15:00 | AAPL | Stock | 3.7757 | 3.7757 | 3.7746 | 3.775 | 50120.0 |
| 2008-09-30 07:20:00 | AAPL | Stock | 3.775 | 3.7757 | 3.7743 | 3.7757 | 150472.0 |
| 2008-09-30 07:25:00 | AAPL | Stock | 3.7757 | 3.7911 | 3.7757 | 3.7911 | 432096.0 |
| 2008-09-30 07:30:00 | AAPL | Stock | 3.7911 | 3.7979 | 3.79 | 3.7979 | 215096.0 |
| 2008-09-30 07:35:00 | AAPL | Stock | 3.7979 | 3.8071 | 3.7929 | 3.8036 | 374360.0 |
| 2008-09-30 07:40:00 | AAPL | Stock | 3.8068 | 3.8232 | 3.8064 | 3.8179 | 400876.0 |
| 2008-09-30 07:45:00 | AAPL | Stock | 3.8179 | 3.8179 | 3.8 | 3.8 | 222068.0 |
| 2008-09-30 07:50:00 | AAPL | Stock | 3.8 | 3.8068 | 3.7971 | 3.8068 | 16800.0 |
| 2008-09-30 07:55:00 | AAPL | Stock | 3.8068 | 3.8293 | 3.8054 | 3.8111 | 525196.0 |
| 2008-09-30 08:00:00 | AAPL | Stock | 3.7857 | 3.8207 | 3.7589 | 3.8129 | 933856.0 |
| 2008-09-30 08:05:00 | AAPL | Stock | 3.8125 | 3.8129 | 3.7879 | 3.7879 | 678468.0 |
| 2008-09-30 08:10:00 | AAPL | Stock | 3.7879 | 3.8107 | 3.7825 | 3.8061 | 1111292.0 |
| 2008-09-30 08:15:00 | AAPL | Stock | 3.8079 | 3.8161 | 3.8 | 3.8071 | 550256.0 |
| 2008-09-30 08:20:00 | AAPL | Stock | 3.8075 | 3.825 | 3.8036 | 3.8207 | 653324.0 |
| 2008-09-30 08:25:00 | AAPL | Stock | 3.8207 | 3.8314 | 3.8143 | 3.8218 | 1022896.0 |
| 2008-09-30 08:30:00 | AAPL | Stock | 3.8225 | 3.8661 | 3.8225 | 3.8554 | 1632148.0 |
| 2008-09-30 08:35:00 | AAPL | Stock | 3.8554 | 3.8643 | 3.8464 | 3.855 | 917896.0 |
| 2008-09-30 08:40:00 | AAPL | Stock | 3.8536 | 3.8554 | 3.8321 | 3.8421 | 550340.0 |
| 2008-09-30 08:45:00 | AAPL | Stock | 3.8421 | 3.8457 | 3.8132 | 3.8289 | 1086904.0 |
| 2008-09-30 08:50:00 | AAPL | Stock | 3.8289 | 3.8339 | 3.8211 | 3.8275 | 630952.0 |
| 2008-09-30 08:55:00 | AAPL | Stock | 3.8275 | 3.8275 | 3.7996 | 3.8071 | 1253140.0 |
| 2008-09-30 09:00:00 | AAPL | Stock | 3.8057 | 3.8196 | 3.8054 | 3.8143 | 829668.0 |
> showing 50 of 333,642 rows — these rows as CSV