PREVIEW / stock_5min / 2006-12-26
file: by_date/stock_5min/2006/2006-12-26.parquet size: 3.1 MB rows: 231,971 symbols: 2,461
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 |
|---|---|---|---|---|---|---|---|
| 2006-12-26 08:00:00 | AAPL | Stock | 2.9479 | 2.9479 | 2.9357 | 2.9429 | 65800.0 |
| 2006-12-26 08:05:00 | AAPL | Stock | 2.9357 | 2.9357 | 2.9304 | 2.9304 | 75320.0 |
| 2006-12-26 08:10:00 | AAPL | Stock | 2.9321 | 2.9389 | 2.9321 | 2.9329 | 136108.0 |
| 2006-12-26 08:15:00 | AAPL | Stock | 2.935 | 2.935 | 2.9325 | 2.9325 | 49420.0 |
| 2006-12-26 08:20:00 | AAPL | Stock | 2.9307 | 2.935 | 2.9307 | 2.935 | 148568.0 |
| 2006-12-26 08:25:00 | AAPL | Stock | 2.9357 | 2.9382 | 2.9357 | 2.9382 | 14000.0 |
| 2006-12-26 08:30:00 | AAPL | Stock | 2.9325 | 2.9393 | 2.9325 | 2.9393 | 68600.0 |
| 2006-12-26 08:35:00 | AAPL | Stock | 2.9364 | 2.9364 | 2.9364 | 2.9364 | 42000.0 |
| 2006-12-26 08:40:00 | AAPL | Stock | 2.9339 | 2.9357 | 2.9339 | 2.9357 | 64400.0 |
| 2006-12-26 08:45:00 | AAPL | Stock | 2.9357 | 2.9357 | 2.9339 | 2.9339 | 21000.0 |
| 2006-12-26 08:50:00 | AAPL | Stock | 2.9357 | 2.9364 | 2.9339 | 2.9364 | 114800.0 |
| 2006-12-26 08:55:00 | AAPL | Stock | 2.9339 | 2.9339 | 2.9339 | 2.9339 | 25200.0 |
| 2006-12-26 09:00:00 | AAPL | Stock | 2.9339 | 2.9339 | 2.9325 | 2.9325 | 46480.0 |
| 2006-12-26 09:05:00 | AAPL | Stock | 2.9339 | 2.9339 | 2.9314 | 2.9314 | 65800.0 |
| 2006-12-26 09:10:00 | AAPL | Stock | 2.9314 | 2.9321 | 2.9307 | 2.9314 | 120400.0 |
| 2006-12-26 09:15:00 | AAPL | Stock | 2.9307 | 2.9321 | 2.9307 | 2.9321 | 91000.0 |
| 2006-12-26 09:20:00 | AAPL | Stock | 2.9321 | 2.9346 | 2.9321 | 2.9346 | 302540.0 |
| 2006-12-26 09:25:00 | AAPL | Stock | 2.9339 | 2.9346 | 2.9325 | 2.9343 | 94080.0 |
| 2006-12-26 09:30:00 | AAPL | Stock | 2.9339 | 2.9357 | 2.9196 | 2.925 | 15226820.0 |
| 2006-12-26 09:35:00 | AAPL | Stock | 2.9243 | 2.9382 | 2.9182 | 2.9368 | 14360948.0 |
| 2006-12-26 09:40:00 | AAPL | Stock | 2.9379 | 2.9489 | 2.9357 | 2.9364 | 13240360.0 |
| 2006-12-26 09:45:00 | AAPL | Stock | 2.9368 | 2.9475 | 2.9357 | 2.9364 | 9998156.0 |
| 2006-12-26 09:50:00 | AAPL | Stock | 2.9364 | 2.9425 | 2.9293 | 2.9311 | 9652496.0 |
| 2006-12-26 09:55:00 | AAPL | Stock | 2.9314 | 2.9357 | 2.9204 | 2.9243 | 9908500.0 |
| 2006-12-26 10:00:00 | AAPL | Stock | 2.9246 | 2.9286 | 2.9204 | 2.9232 | 8215340.0 |
| 2006-12-26 10:05:00 | AAPL | Stock | 2.9232 | 2.9264 | 2.9143 | 2.9143 | 9357376.0 |
| 2006-12-26 10:10:00 | AAPL | Stock | 2.9143 | 2.9193 | 2.9125 | 2.9189 | 8522808.0 |
| 2006-12-26 10:15:00 | AAPL | Stock | 2.9193 | 2.9261 | 2.9186 | 2.9261 | 6958056.0 |
| 2006-12-26 10:20:00 | AAPL | Stock | 2.9257 | 2.9329 | 2.9211 | 2.9218 | 5880728.0 |
| 2006-12-26 10:25:00 | AAPL | Stock | 2.9218 | 2.9236 | 2.9186 | 2.9232 | 3949344.0 |
| 2006-12-26 10:30:00 | AAPL | Stock | 2.9232 | 2.9264 | 2.9229 | 2.9232 | 3607044.0 |
| 2006-12-26 10:35:00 | AAPL | Stock | 2.9236 | 2.9264 | 2.9207 | 2.9254 | 4143468.0 |
| 2006-12-26 10:40:00 | AAPL | Stock | 2.9254 | 2.9261 | 2.9146 | 2.9146 | 6999132.0 |
| 2006-12-26 10:45:00 | AAPL | Stock | 2.9146 | 2.9329 | 2.9021 | 2.9075 | 16125172.0 |
| 2006-12-26 10:50:00 | AAPL | Stock | 2.9075 | 2.9079 | 2.8993 | 2.9071 | 11095084.0 |
| 2006-12-26 10:55:00 | AAPL | Stock | 2.9071 | 2.9075 | 2.9004 | 2.9068 | 8523620.0 |
| 2006-12-26 11:00:00 | AAPL | Stock | 2.9071 | 2.9118 | 2.905 | 2.9064 | 6674248.0 |
| 2006-12-26 11:05:00 | AAPL | Stock | 2.9064 | 2.9146 | 2.9041 | 2.9146 | 10426360.0 |
| 2006-12-26 11:10:00 | AAPL | Stock | 2.9146 | 2.915 | 2.9089 | 2.9125 | 4232256.0 |
| 2006-12-26 11:15:00 | AAPL | Stock | 2.9125 | 2.9171 | 2.9121 | 2.9129 | 5596192.0 |
| 2006-12-26 11:20:00 | AAPL | Stock | 2.9131 | 2.9146 | 2.9079 | 2.9079 | 6990284.0 |
| 2006-12-26 11:25:00 | AAPL | Stock | 2.9093 | 2.9104 | 2.9068 | 2.9086 | 4730880.0 |
| 2006-12-26 11:30:00 | AAPL | Stock | 2.9086 | 2.9096 | 2.9036 | 2.906 | 4665640.0 |
| 2006-12-26 11:35:00 | AAPL | Stock | 2.9061 | 2.9079 | 2.905 | 2.9061 | 3273172.0 |
| 2006-12-26 11:40:00 | AAPL | Stock | 2.9057 | 2.9061 | 2.9 | 2.9 | 5119156.0 |
| 2006-12-26 11:45:00 | AAPL | Stock | 2.9004 | 2.9004 | 2.8907 | 2.8925 | 14746060.0 |
| 2006-12-26 11:50:00 | AAPL | Stock | 2.8921 | 2.9029 | 2.8914 | 2.9025 | 8819552.0 |
| 2006-12-26 11:55:00 | AAPL | Stock | 2.9029 | 2.9029 | 2.8989 | 2.8996 | 4031944.0 |
| 2006-12-26 12:00:00 | AAPL | Stock | 2.8993 | 2.9 | 2.8968 | 2.8982 | 4855452.0 |
| 2006-12-26 12:05:00 | AAPL | Stock | 2.8978 | 2.8989 | 2.8956 | 2.8965 | 6062000.0 |
> showing 50 of 231,971 rows — these rows as CSV