PREVIEW / stock_5min / 2009-12-18
file: by_date/stock_5min/2009/2009-12-18.parquet size: 5.1 MB rows: 343,288 symbols: 3,450
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-12-18 04:20:00 | AAPL | Stock | 6.9089 | 6.9089 | 6.9089 | 6.9089 | 2800.0 |
| 2009-12-18 06:45:00 | AAPL | Stock | 6.8893 | 6.8893 | 6.8893 | 6.8893 | 2800.0 |
| 2009-12-18 07:00:00 | AAPL | Stock | 6.9018 | 6.9096 | 6.9018 | 6.9096 | 8400.0 |
| 2009-12-18 07:10:00 | AAPL | Stock | 6.9107 | 6.9107 | 6.8964 | 6.8964 | 50596.0 |
| 2009-12-18 07:20:00 | AAPL | Stock | 6.9004 | 6.9004 | 6.9004 | 6.9004 | 2800.0 |
| 2009-12-18 07:30:00 | AAPL | Stock | 6.9004 | 6.9071 | 6.9 | 6.9071 | 25200.0 |
| 2009-12-18 07:35:00 | AAPL | Stock | 6.8957 | 6.8964 | 6.8954 | 6.8954 | 16800.0 |
| 2009-12-18 07:40:00 | AAPL | Stock | 6.9046 | 6.9046 | 6.9046 | 6.9046 | 2800.0 |
| 2009-12-18 07:45:00 | AAPL | Stock | 6.9029 | 6.9036 | 6.9029 | 6.9036 | 11200.0 |
| 2009-12-18 07:50:00 | AAPL | Stock | 6.9036 | 6.9071 | 6.9036 | 6.9054 | 11200.0 |
| 2009-12-18 07:55:00 | AAPL | Stock | 6.9054 | 6.9054 | 6.8946 | 6.8961 | 79100.0 |
| 2009-12-18 08:00:00 | AAPL | Stock | 6.8996 | 6.92 | 6.8996 | 6.9071 | 503244.0 |
| 2009-12-18 08:05:00 | AAPL | Stock | 6.9082 | 6.9089 | 6.8893 | 6.8932 | 179116.0 |
| 2009-12-18 08:10:00 | AAPL | Stock | 6.8929 | 6.9054 | 6.8929 | 6.9054 | 309316.0 |
| 2009-12-18 08:15:00 | AAPL | Stock | 6.9057 | 6.9079 | 6.9032 | 6.9054 | 98700.0 |
| 2009-12-18 08:20:00 | AAPL | Stock | 6.9036 | 6.9079 | 6.9032 | 6.9079 | 119896.0 |
| 2009-12-18 08:25:00 | AAPL | Stock | 6.9036 | 6.9054 | 6.8946 | 6.9054 | 196616.0 |
| 2009-12-18 08:30:00 | AAPL | Stock | 6.9054 | 6.91 | 6.9054 | 6.9068 | 258020.0 |
| 2009-12-18 08:35:00 | AAPL | Stock | 6.9054 | 6.9089 | 6.9029 | 6.9054 | 187180.0 |
| 2009-12-18 08:40:00 | AAPL | Stock | 6.9036 | 6.905 | 6.9018 | 6.9036 | 76580.0 |
| 2009-12-18 08:45:00 | AAPL | Stock | 6.9036 | 6.9039 | 6.9 | 6.9025 | 106400.0 |
| 2009-12-18 08:50:00 | AAPL | Stock | 6.9025 | 6.9025 | 6.9018 | 6.9018 | 33600.0 |
| 2009-12-18 08:55:00 | AAPL | Stock | 6.9018 | 6.9032 | 6.9007 | 6.9014 | 145600.0 |
| 2009-12-18 09:00:00 | AAPL | Stock | 6.9007 | 6.9011 | 6.8996 | 6.8996 | 87416.0 |
| 2009-12-18 09:05:00 | AAPL | Stock | 6.9 | 6.9 | 6.8971 | 6.9 | 246120.0 |
| 2009-12-18 09:10:00 | AAPL | Stock | 6.8993 | 6.9 | 6.8991 | 6.9 | 123760.0 |
| 2009-12-18 09:15:00 | AAPL | Stock | 6.9 | 6.9 | 6.8968 | 6.8968 | 42700.0 |
| 2009-12-18 09:20:00 | AAPL | Stock | 6.8968 | 6.9 | 6.8964 | 6.8964 | 106400.0 |
| 2009-12-18 09:25:00 | AAPL | Stock | 6.895 | 6.9 | 6.8929 | 6.8973 | 101080.0 |
| 2009-12-18 09:30:00 | AAPL | Stock | 6.8989 | 6.9164 | 6.8964 | 6.9018 | 93608620.0 |
| 2009-12-18 09:35:00 | AAPL | Stock | 6.9014 | 6.9046 | 6.8818 | 6.8957 | 12027400.0 |
| 2009-12-18 09:40:00 | AAPL | Stock | 6.8961 | 6.9132 | 6.8786 | 6.9111 | 14909468.0 |
| 2009-12-18 09:45:00 | AAPL | Stock | 6.9114 | 6.9268 | 6.9107 | 6.9193 | 16881760.0 |
| 2009-12-18 09:50:00 | AAPL | Stock | 6.9193 | 6.9221 | 6.9057 | 6.9182 | 7009324.0 |
| 2009-12-18 09:55:00 | AAPL | Stock | 6.9179 | 6.9318 | 6.9129 | 6.9243 | 14283500.0 |
| 2009-12-18 10:00:00 | AAPL | Stock | 6.9236 | 6.9375 | 6.92 | 6.9228 | 10697904.0 |
| 2009-12-18 10:05:00 | AAPL | Stock | 6.9239 | 6.9296 | 6.9129 | 6.9211 | 6900824.0 |
| 2009-12-18 10:10:00 | AAPL | Stock | 6.9207 | 6.9282 | 6.9146 | 6.9282 | 5419204.0 |
| 2009-12-18 10:15:00 | AAPL | Stock | 6.9282 | 6.9329 | 6.9207 | 6.9225 | 6452152.0 |
| 2009-12-18 10:20:00 | AAPL | Stock | 6.9225 | 6.9246 | 6.9154 | 6.9189 | 6761888.0 |
| 2009-12-18 10:25:00 | AAPL | Stock | 6.9179 | 6.9311 | 6.9175 | 6.9289 | 7057092.0 |
| 2009-12-18 10:30:00 | AAPL | Stock | 6.9296 | 6.9311 | 6.9143 | 6.9214 | 5771696.0 |
| 2009-12-18 10:35:00 | AAPL | Stock | 6.9213 | 6.9213 | 6.9071 | 6.9136 | 6563312.0 |
| 2009-12-18 10:40:00 | AAPL | Stock | 6.9136 | 6.9146 | 6.8921 | 6.8921 | 9173360.0 |
| 2009-12-18 10:45:00 | AAPL | Stock | 6.8925 | 6.9214 | 6.8882 | 6.8882 | 7625800.0 |
| 2009-12-18 10:50:00 | AAPL | Stock | 6.8875 | 6.9018 | 6.8821 | 6.8986 | 7023212.0 |
| 2009-12-18 10:55:00 | AAPL | Stock | 6.8986 | 6.9082 | 6.8986 | 6.9061 | 4503352.0 |
| 2009-12-18 11:00:00 | AAPL | Stock | 6.9071 | 6.9107 | 6.9029 | 6.9029 | 3554488.0 |
| 2009-12-18 11:05:00 | AAPL | Stock | 6.9036 | 6.9039 | 6.895 | 6.8961 | 3831576.0 |
| 2009-12-18 11:10:00 | AAPL | Stock | 6.8961 | 6.9046 | 6.8943 | 6.8982 | 3446744.0 |
> showing 50 of 343,288 rows — these rows as CSV