PREVIEW / stock_5min / 2009-03-19
file: by_date/stock_5min/2009/2009-03-19.parquet size: 4.6 MB rows: 318,323 symbols: 3,336
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-03-19 05:30:00 | AAPL | Stock | 3.6036 | 3.6036 | 3.6036 | 3.6036 | 2800.0 |
| 2009-03-19 07:00:00 | AAPL | Stock | 3.6243 | 3.6243 | 3.6243 | 3.6243 | 3500.0 |
| 2009-03-19 07:30:00 | AAPL | Stock | 3.6243 | 3.6243 | 3.6243 | 3.6243 | 2800.0 |
| 2009-03-19 07:40:00 | AAPL | Stock | 3.6393 | 3.6393 | 3.6393 | 3.6393 | 2800.0 |
| 2009-03-19 07:45:00 | AAPL | Stock | 3.6321 | 3.6321 | 3.6321 | 3.6321 | 14000.0 |
| 2009-03-19 07:55:00 | AAPL | Stock | 3.6321 | 3.6321 | 3.6257 | 3.6257 | 19600.0 |
| 2009-03-19 08:00:00 | AAPL | Stock | 3.625 | 3.6286 | 3.6071 | 3.6279 | 44520.0 |
| 2009-03-19 08:05:00 | AAPL | Stock | 3.6282 | 3.6286 | 3.6125 | 3.6125 | 18200.0 |
| 2009-03-19 08:10:00 | AAPL | Stock | 3.6143 | 3.6143 | 3.6018 | 3.6018 | 128912.0 |
| 2009-03-19 08:15:00 | AAPL | Stock | 3.6004 | 3.6018 | 3.5954 | 3.6018 | 30800.0 |
| 2009-03-19 08:20:00 | AAPL | Stock | 3.6025 | 3.6071 | 3.5968 | 3.6071 | 46536.0 |
| 2009-03-19 08:25:00 | AAPL | Stock | 3.6214 | 3.6214 | 3.6161 | 3.6182 | 8400.0 |
| 2009-03-19 08:30:00 | AAPL | Stock | 3.6179 | 3.6282 | 3.6125 | 3.6207 | 109200.0 |
| 2009-03-19 08:35:00 | AAPL | Stock | 3.6214 | 3.625 | 3.6214 | 3.625 | 82600.0 |
| 2009-03-19 08:40:00 | AAPL | Stock | 3.6286 | 3.6286 | 3.6211 | 3.6214 | 46452.0 |
| 2009-03-19 08:45:00 | AAPL | Stock | 3.6229 | 3.6229 | 3.6179 | 3.6225 | 86800.0 |
| 2009-03-19 08:50:00 | AAPL | Stock | 3.6264 | 3.6286 | 3.6264 | 3.6286 | 27944.0 |
| 2009-03-19 08:55:00 | AAPL | Stock | 3.6286 | 3.6404 | 3.6275 | 3.6404 | 130620.0 |
| 2009-03-19 09:00:00 | AAPL | Stock | 3.6307 | 3.6361 | 3.6307 | 3.6361 | 354004.0 |
| 2009-03-19 09:05:00 | AAPL | Stock | 3.6361 | 3.6429 | 3.6339 | 3.6414 | 207284.0 |
| 2009-03-19 09:10:00 | AAPL | Stock | 3.6429 | 3.6514 | 3.6411 | 3.6493 | 293636.0 |
| 2009-03-19 09:15:00 | AAPL | Stock | 3.6511 | 3.6514 | 3.6464 | 3.6482 | 119084.0 |
| 2009-03-19 09:20:00 | AAPL | Stock | 3.6479 | 3.6482 | 3.6393 | 3.6393 | 144004.0 |
| 2009-03-19 09:25:00 | AAPL | Stock | 3.6361 | 3.6489 | 3.6357 | 3.6404 | 1609776.0 |
| 2009-03-19 09:30:00 | AAPL | Stock | 3.6375 | 3.6489 | 3.5804 | 3.5993 | 15701812.0 |
| 2009-03-19 09:35:00 | AAPL | Stock | 3.5996 | 3.6261 | 3.5971 | 3.6225 | 9554048.0 |
| 2009-03-19 09:40:00 | AAPL | Stock | 3.6221 | 3.6221 | 3.5968 | 3.6154 | 8615824.0 |
| 2009-03-19 09:45:00 | AAPL | Stock | 3.6121 | 3.6436 | 3.6082 | 3.6354 | 11064032.0 |
| 2009-03-19 09:50:00 | AAPL | Stock | 3.6361 | 3.6361 | 3.6096 | 3.6193 | 7739368.0 |
| 2009-03-19 09:55:00 | AAPL | Stock | 3.6186 | 3.6232 | 3.6 | 3.6036 | 7400904.0 |
| 2009-03-19 10:00:00 | AAPL | Stock | 3.6054 | 3.6132 | 3.5907 | 3.6089 | 8901564.0 |
| 2009-03-19 10:05:00 | AAPL | Stock | 3.6096 | 3.615 | 3.6036 | 3.6071 | 5706904.0 |
| 2009-03-19 10:10:00 | AAPL | Stock | 3.6064 | 3.6429 | 3.5996 | 3.6343 | 11245976.0 |
| 2009-03-19 10:15:00 | AAPL | Stock | 3.6343 | 3.6571 | 3.6318 | 3.6564 | 10992184.0 |
| 2009-03-19 10:20:00 | AAPL | Stock | 3.6561 | 3.6782 | 3.6554 | 3.6725 | 13073424.0 |
| 2009-03-19 10:25:00 | AAPL | Stock | 3.6725 | 3.675 | 3.6661 | 3.6661 | 7105644.0 |
| 2009-03-19 10:30:00 | AAPL | Stock | 3.6664 | 3.6696 | 3.6518 | 3.6654 | 6661452.0 |
| 2009-03-19 10:35:00 | AAPL | Stock | 3.6657 | 3.6732 | 3.6596 | 3.6668 | 3965248.0 |
| 2009-03-19 10:40:00 | AAPL | Stock | 3.6671 | 3.6857 | 3.6661 | 3.6832 | 10175704.0 |
| 2009-03-19 10:45:00 | AAPL | Stock | 3.6829 | 3.685 | 3.6707 | 3.6732 | 6301484.0 |
| 2009-03-19 10:50:00 | AAPL | Stock | 3.6739 | 3.6754 | 3.6496 | 3.6546 | 7712852.0 |
| 2009-03-19 10:55:00 | AAPL | Stock | 3.6543 | 3.6689 | 3.6511 | 3.6593 | 7555464.0 |
| 2009-03-19 11:00:00 | AAPL | Stock | 3.6568 | 3.6714 | 3.6461 | 3.6461 | 7575120.0 |
| 2009-03-19 11:05:00 | AAPL | Stock | 3.6461 | 3.6582 | 3.6439 | 3.6479 | 6212500.0 |
| 2009-03-19 11:10:00 | AAPL | Stock | 3.6486 | 3.6543 | 3.6418 | 3.6521 | 6295464.0 |
| 2009-03-19 11:15:00 | AAPL | Stock | 3.6529 | 3.6607 | 3.65 | 3.6564 | 4444776.0 |
| 2009-03-19 11:20:00 | AAPL | Stock | 3.6564 | 3.6589 | 3.6514 | 3.6521 | 4513432.0 |
| 2009-03-19 11:25:00 | AAPL | Stock | 3.6521 | 3.6546 | 3.6282 | 3.6286 | 6284684.0 |
| 2009-03-19 11:30:00 | AAPL | Stock | 3.6286 | 3.6421 | 3.6268 | 3.6367 | 6551104.0 |
| 2009-03-19 11:35:00 | AAPL | Stock | 3.6354 | 3.6514 | 3.6346 | 3.6436 | 5031908.0 |
> showing 50 of 318,323 rows — these rows as CSV