PREVIEW / stock_5min / 2009-08-10
file: by_date/stock_5min/2009/2009-08-10.parquet size: 4.6 MB rows: 319,309 symbols: 3,400
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-10 07:10:00 | AAPL | Stock | 5.9193 | 5.9193 | 5.9193 | 5.9193 | 5600.0 |
| 2009-08-10 07:25:00 | AAPL | Stock | 5.92 | 5.92 | 5.92 | 5.92 | 2800.0 |
| 2009-08-10 07:40:00 | AAPL | Stock | 5.9632 | 5.9643 | 5.9311 | 5.955 | 44800.0 |
| 2009-08-10 07:45:00 | AAPL | Stock | 5.9386 | 5.9386 | 5.9325 | 5.9325 | 73864.0 |
| 2009-08-10 07:55:00 | AAPL | Stock | 5.9457 | 5.9457 | 5.9457 | 5.9457 | 5600.0 |
| 2009-08-10 08:00:00 | AAPL | Stock | 5.9382 | 5.9382 | 5.9339 | 5.9339 | 27104.0 |
| 2009-08-10 08:05:00 | AAPL | Stock | 5.9346 | 5.9346 | 5.8982 | 5.9321 | 154000.0 |
| 2009-08-10 08:10:00 | AAPL | Stock | 5.9332 | 5.9339 | 5.9286 | 5.9304 | 227836.0 |
| 2009-08-10 08:15:00 | AAPL | Stock | 5.9304 | 5.9321 | 5.9261 | 5.9261 | 177380.0 |
| 2009-08-10 08:20:00 | AAPL | Stock | 5.9232 | 5.9257 | 5.9225 | 5.9246 | 58100.0 |
| 2009-08-10 08:25:00 | AAPL | Stock | 5.925 | 5.9286 | 5.9214 | 5.9286 | 99876.0 |
| 2009-08-10 08:30:00 | AAPL | Stock | 5.9282 | 5.9286 | 5.9229 | 5.9286 | 42560.0 |
| 2009-08-10 08:35:00 | AAPL | Stock | 5.9268 | 5.9293 | 5.925 | 5.9293 | 90076.0 |
| 2009-08-10 08:40:00 | AAPL | Stock | 5.9293 | 5.9293 | 5.925 | 5.9254 | 67536.0 |
| 2009-08-10 08:45:00 | AAPL | Stock | 5.925 | 5.925 | 5.925 | 5.925 | 42000.0 |
| 2009-08-10 08:50:00 | AAPL | Stock | 5.9246 | 5.925 | 5.9232 | 5.925 | 50848.0 |
| 2009-08-10 08:55:00 | AAPL | Stock | 5.925 | 5.925 | 5.925 | 5.925 | 44800.0 |
| 2009-08-10 09:00:00 | AAPL | Stock | 5.9218 | 5.9218 | 5.9 | 5.9125 | 265720.0 |
| 2009-08-10 09:05:00 | AAPL | Stock | 5.9018 | 5.9093 | 5.9 | 5.9093 | 92400.0 |
| 2009-08-10 09:10:00 | AAPL | Stock | 5.9107 | 5.9107 | 5.9039 | 5.9039 | 85008.0 |
| 2009-08-10 09:20:00 | AAPL | Stock | 5.9121 | 5.9121 | 5.9036 | 5.9036 | 14000.0 |
| 2009-08-10 09:25:00 | AAPL | Stock | 5.9079 | 5.9079 | 5.9061 | 5.9061 | 5600.0 |
| 2009-08-10 09:30:00 | AAPL | Stock | 5.9164 | 5.9411 | 5.8936 | 5.9286 | 13182176.0 |
| 2009-08-10 09:35:00 | AAPL | Stock | 5.9286 | 5.95 | 5.9268 | 5.9421 | 9728768.0 |
| 2009-08-10 09:40:00 | AAPL | Stock | 5.9425 | 5.9475 | 5.9311 | 5.9329 | 7735252.0 |
| 2009-08-10 09:45:00 | AAPL | Stock | 5.9339 | 5.9382 | 5.9271 | 5.935 | 5720596.0 |
| 2009-08-10 09:50:00 | AAPL | Stock | 5.9346 | 5.9389 | 5.9286 | 5.935 | 6422892.0 |
| 2009-08-10 09:55:00 | AAPL | Stock | 5.9357 | 5.9407 | 5.9275 | 5.9283 | 6083644.0 |
| 2009-08-10 10:00:00 | AAPL | Stock | 5.9286 | 5.9304 | 5.9164 | 5.9218 | 6845720.0 |
| 2009-08-10 10:05:00 | AAPL | Stock | 5.9225 | 5.9289 | 5.9211 | 5.9236 | 2820244.0 |
| 2009-08-10 10:10:00 | AAPL | Stock | 5.9241 | 5.9357 | 5.9214 | 5.9279 | 4521524.0 |
| 2009-08-10 10:15:00 | AAPL | Stock | 5.9271 | 5.9279 | 5.9057 | 5.91 | 5914160.0 |
| 2009-08-10 10:20:00 | AAPL | Stock | 5.9086 | 5.9189 | 5.9054 | 5.9189 | 4839408.0 |
| 2009-08-10 10:25:00 | AAPL | Stock | 5.9193 | 5.9257 | 5.9154 | 5.9226 | 4266528.0 |
| 2009-08-10 10:30:00 | AAPL | Stock | 5.9225 | 5.9271 | 5.9196 | 5.9225 | 3630424.0 |
| 2009-08-10 10:35:00 | AAPL | Stock | 5.9214 | 5.9219 | 5.9136 | 5.9171 | 2904132.0 |
| 2009-08-10 10:40:00 | AAPL | Stock | 5.9164 | 5.917 | 5.9011 | 5.9025 | 5011328.0 |
| 2009-08-10 10:45:00 | AAPL | Stock | 5.9025 | 5.9107 | 5.9018 | 5.9032 | 4022228.0 |
| 2009-08-10 10:50:00 | AAPL | Stock | 5.9036 | 5.9146 | 5.9007 | 5.9111 | 3303384.0 |
| 2009-08-10 10:55:00 | AAPL | Stock | 5.9111 | 5.9121 | 5.9011 | 5.9054 | 2175208.0 |
| 2009-08-10 11:00:00 | AAPL | Stock | 5.905 | 5.9143 | 5.9036 | 5.9143 | 2681448.0 |
| 2009-08-10 11:05:00 | AAPL | Stock | 5.9143 | 5.9143 | 5.8979 | 5.8979 | 4171496.0 |
| 2009-08-10 11:10:00 | AAPL | Stock | 5.8979 | 5.9079 | 5.8968 | 5.9039 | 3726324.0 |
| 2009-08-10 11:15:00 | AAPL | Stock | 5.9029 | 5.9064 | 5.8979 | 5.9009 | 3281292.0 |
| 2009-08-10 11:20:00 | AAPL | Stock | 5.9011 | 5.9018 | 5.8932 | 5.8986 | 4359936.0 |
| 2009-08-10 11:25:00 | AAPL | Stock | 5.8986 | 5.8996 | 5.8875 | 5.8914 | 4299624.0 |
| 2009-08-10 11:30:00 | AAPL | Stock | 5.8911 | 5.8946 | 5.8893 | 5.89 | 3267180.0 |
| 2009-08-10 11:35:00 | AAPL | Stock | 5.8896 | 5.8943 | 5.8811 | 5.8911 | 4712400.0 |
| 2009-08-10 11:40:00 | AAPL | Stock | 5.8914 | 5.8957 | 5.89 | 5.8939 | 2686964.0 |
| 2009-08-10 11:45:00 | AAPL | Stock | 5.8938 | 5.895 | 5.8875 | 5.8925 | 2847628.0 |
> showing 50 of 319,309 rows — these rows as CSV