PREVIEW / stock_5min / 2010-06-25
file: by_date/stock_5min/2010/2010-06-25.parquet size: 5.5 MB rows: 370,512 symbols: 3,446
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-25 05:10:00 | AAPL | Stock | 9.6111 | 9.6111 | 9.6111 | 9.6111 | 2800.0 |
| 2010-06-25 05:20:00 | AAPL | Stock | 9.5989 | 9.5989 | 9.5989 | 9.5989 | 2800.0 |
| 2010-06-25 05:45:00 | AAPL | Stock | 9.5896 | 9.5896 | 9.5896 | 9.5896 | 2800.0 |
| 2010-06-25 06:00:00 | AAPL | Stock | 9.5825 | 9.5825 | 9.5754 | 9.5754 | 22400.0 |
| 2010-06-25 06:10:00 | AAPL | Stock | 9.5736 | 9.5736 | 9.5736 | 9.5736 | 16800.0 |
| 2010-06-25 06:15:00 | AAPL | Stock | 9.5711 | 9.5711 | 9.5711 | 9.5711 | 7588.0 |
| 2010-06-25 06:40:00 | AAPL | Stock | 9.6004 | 9.6004 | 9.6004 | 9.6004 | 2800.0 |
| 2010-06-25 07:00:00 | AAPL | Stock | 9.635 | 9.6357 | 9.635 | 9.6357 | 9100.0 |
| 2010-06-25 07:05:00 | AAPL | Stock | 9.6168 | 9.6179 | 9.6168 | 9.6179 | 5600.0 |
| 2010-06-25 07:10:00 | AAPL | Stock | 9.625 | 9.6375 | 9.6182 | 9.6375 | 53200.0 |
| 2010-06-25 07:15:00 | AAPL | Stock | 9.6261 | 9.6429 | 9.6261 | 9.6382 | 58520.0 |
| 2010-06-25 07:20:00 | AAPL | Stock | 9.6343 | 9.6343 | 9.6343 | 9.6343 | 2800.0 |
| 2010-06-25 07:25:00 | AAPL | Stock | 9.6379 | 9.6379 | 9.6339 | 9.6343 | 18200.0 |
| 2010-06-25 07:30:00 | AAPL | Stock | 9.6429 | 9.6711 | 9.6429 | 9.6711 | 44436.0 |
| 2010-06-25 07:35:00 | AAPL | Stock | 9.6711 | 9.6711 | 9.6554 | 9.6675 | 105000.0 |
| 2010-06-25 07:40:00 | AAPL | Stock | 9.6625 | 9.6643 | 9.6607 | 9.6643 | 19600.0 |
| 2010-06-25 07:50:00 | AAPL | Stock | 9.6696 | 9.6696 | 9.6607 | 9.6607 | 36400.0 |
| 2010-06-25 07:55:00 | AAPL | Stock | 9.6571 | 9.6571 | 9.6521 | 9.6521 | 5600.0 |
| 2010-06-25 08:00:00 | AAPL | Stock | 9.6625 | 9.6629 | 9.6293 | 9.6336 | 185920.0 |
| 2010-06-25 08:05:00 | AAPL | Stock | 9.6345 | 9.6429 | 9.6343 | 9.6386 | 158648.0 |
| 2010-06-25 08:10:00 | AAPL | Stock | 9.6362 | 9.6387 | 9.6307 | 9.6307 | 190876.0 |
| 2010-06-25 08:15:00 | AAPL | Stock | 9.63 | 9.6379 | 9.63 | 9.6379 | 188888.0 |
| 2010-06-25 08:20:00 | AAPL | Stock | 9.6382 | 9.6382 | 9.6293 | 9.6332 | 194656.0 |
| 2010-06-25 08:25:00 | AAPL | Stock | 9.6318 | 9.6336 | 9.625 | 9.625 | 233492.0 |
| 2010-06-25 08:30:00 | AAPL | Stock | 9.6307 | 9.6307 | 9.6004 | 9.6129 | 939484.0 |
| 2010-06-25 08:35:00 | AAPL | Stock | 9.6136 | 9.6429 | 9.6136 | 9.6389 | 447860.0 |
| 2010-06-25 08:40:00 | AAPL | Stock | 9.6414 | 9.6607 | 9.635 | 9.6561 | 536760.0 |
| 2010-06-25 08:45:00 | AAPL | Stock | 9.6561 | 9.6589 | 9.6482 | 9.6543 | 227920.0 |
| 2010-06-25 08:50:00 | AAPL | Stock | 9.6554 | 9.6571 | 9.6496 | 9.6496 | 95200.0 |
| 2010-06-25 08:55:00 | AAPL | Stock | 9.6461 | 9.6514 | 9.6429 | 9.6468 | 204148.0 |
| 2010-06-25 09:00:00 | AAPL | Stock | 9.6479 | 9.6557 | 9.6461 | 9.6514 | 148484.0 |
| 2010-06-25 09:05:00 | AAPL | Stock | 9.6489 | 9.6536 | 9.6461 | 9.6536 | 166096.0 |
| 2010-06-25 09:10:00 | AAPL | Stock | 9.6532 | 9.6589 | 9.6471 | 9.6471 | 197120.0 |
| 2010-06-25 09:15:00 | AAPL | Stock | 9.6475 | 9.6496 | 9.6318 | 9.6318 | 237636.0 |
| 2010-06-25 09:20:00 | AAPL | Stock | 9.6368 | 9.6464 | 9.6264 | 9.6457 | 117600.0 |
| 2010-06-25 09:25:00 | AAPL | Stock | 9.6429 | 9.6482 | 9.6329 | 9.6464 | 198800.0 |
| 2010-06-25 09:30:00 | AAPL | Stock | 9.6468 | 9.6525 | 9.5982 | 9.6075 | 16105404.0 |
| 2010-06-25 09:35:00 | AAPL | Stock | 9.6057 | 9.6073 | 9.54 | 9.5747 | 20413764.0 |
| 2010-06-25 09:40:00 | AAPL | Stock | 9.5753 | 9.5918 | 9.5446 | 9.5493 | 14005404.0 |
| 2010-06-25 09:45:00 | AAPL | Stock | 9.5477 | 9.5746 | 9.5436 | 9.5671 | 10676148.0 |
| 2010-06-25 09:50:00 | AAPL | Stock | 9.5661 | 9.5661 | 9.5321 | 9.5564 | 13669404.0 |
| 2010-06-25 09:55:00 | AAPL | Stock | 9.5554 | 9.6017 | 9.5532 | 9.5975 | 17615724.0 |
| 2010-06-25 10:00:00 | AAPL | Stock | 9.6 | 9.6336 | 9.5954 | 9.6029 | 17051412.0 |
| 2010-06-25 10:05:00 | AAPL | Stock | 9.6004 | 9.6279 | 9.6004 | 9.6039 | 9469712.0 |
| 2010-06-25 10:10:00 | AAPL | Stock | 9.6043 | 9.6246 | 9.5946 | 9.601 | 8467060.0 |
| 2010-06-25 10:15:00 | AAPL | Stock | 9.6029 | 9.6061 | 9.5614 | 9.5692 | 9256240.0 |
| 2010-06-25 10:20:00 | AAPL | Stock | 9.5696 | 9.5786 | 9.5404 | 9.5414 | 9180444.0 |
| 2010-06-25 10:25:00 | AAPL | Stock | 9.5421 | 9.5582 | 9.5275 | 9.5568 | 12081412.0 |
| 2010-06-25 10:30:00 | AAPL | Stock | 9.5568 | 9.5639 | 9.5304 | 9.5514 | 8743336.0 |
| 2010-06-25 10:35:00 | AAPL | Stock | 9.5493 | 9.5536 | 9.5246 | 9.5361 | 10555188.0 |
> showing 50 of 370,512 rows — these rows as CSV