PREVIEW / stock_5min / 2010-04-12
file: by_date/stock_5min/2010/2010-04-12.parquet size: 4.8 MB rows: 327,739 symbols: 3,492
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-04-12 04:25:00 | AAPL | Stock | 8.6629 | 8.6629 | 8.6629 | 8.6629 | 13300.0 |
| 2010-04-12 04:50:00 | AAPL | Stock | 8.6746 | 8.6746 | 8.6746 | 8.6746 | 16772.0 |
| 2010-04-12 04:55:00 | AAPL | Stock | 8.6746 | 8.6746 | 8.6746 | 8.6746 | 6244.0 |
| 2010-04-12 05:00:00 | AAPL | Stock | 8.6746 | 8.6746 | 8.6746 | 8.6746 | 2800.0 |
| 2010-04-12 05:10:00 | AAPL | Stock | 8.675 | 8.675 | 8.675 | 8.675 | 5628.0 |
| 2010-04-12 05:15:00 | AAPL | Stock | 8.6714 | 8.6714 | 8.6714 | 8.6714 | 2800.0 |
| 2010-04-12 05:55:00 | AAPL | Stock | 8.6614 | 8.6614 | 8.6614 | 8.6614 | 8400.0 |
| 2010-04-12 06:05:00 | AAPL | Stock | 8.6607 | 8.6607 | 8.6607 | 8.6607 | 13216.0 |
| 2010-04-12 06:30:00 | AAPL | Stock | 8.6607 | 8.6607 | 8.6607 | 8.6607 | 14000.0 |
| 2010-04-12 06:35:00 | AAPL | Stock | 8.6607 | 8.6607 | 8.6607 | 8.6607 | 20048.0 |
| 2010-04-12 07:10:00 | AAPL | Stock | 8.6625 | 8.6629 | 8.6571 | 8.6571 | 44352.0 |
| 2010-04-12 07:15:00 | AAPL | Stock | 8.6589 | 8.6589 | 8.6546 | 8.6546 | 51772.0 |
| 2010-04-12 07:20:00 | AAPL | Stock | 8.6557 | 8.6561 | 8.6436 | 8.6436 | 42336.0 |
| 2010-04-12 07:30:00 | AAPL | Stock | 8.6464 | 8.6464 | 8.6429 | 8.6429 | 25228.0 |
| 2010-04-12 07:35:00 | AAPL | Stock | 8.6518 | 8.6518 | 8.6429 | 8.6429 | 14000.0 |
| 2010-04-12 07:45:00 | AAPL | Stock | 8.6429 | 8.6429 | 8.6375 | 8.6375 | 11200.0 |
| 2010-04-12 07:50:00 | AAPL | Stock | 8.6429 | 8.6429 | 8.6429 | 8.6429 | 2800.0 |
| 2010-04-12 08:00:00 | AAPL | Stock | 8.65 | 8.6568 | 8.6429 | 8.6464 | 406056.0 |
| 2010-04-12 08:05:00 | AAPL | Stock | 8.6464 | 8.6571 | 8.6464 | 8.6539 | 164248.0 |
| 2010-04-12 08:10:00 | AAPL | Stock | 8.6536 | 8.6571 | 8.6514 | 8.655 | 141764.0 |
| 2010-04-12 08:15:00 | AAPL | Stock | 8.6543 | 8.6543 | 8.6514 | 8.6532 | 157780.0 |
| 2010-04-12 08:20:00 | AAPL | Stock | 8.65 | 8.6521 | 8.6457 | 8.6475 | 201992.0 |
| 2010-04-12 08:25:00 | AAPL | Stock | 8.6493 | 8.6493 | 8.6411 | 8.6461 | 163492.0 |
| 2010-04-12 08:30:00 | AAPL | Stock | 8.6446 | 8.6461 | 8.6425 | 8.6461 | 86800.0 |
| 2010-04-12 08:35:00 | AAPL | Stock | 8.6439 | 8.6468 | 8.6432 | 8.6432 | 96096.0 |
| 2010-04-12 08:40:00 | AAPL | Stock | 8.6396 | 8.6457 | 8.6396 | 8.6457 | 50400.0 |
| 2010-04-12 08:45:00 | AAPL | Stock | 8.6457 | 8.6464 | 8.6439 | 8.6446 | 35364.0 |
| 2010-04-12 08:50:00 | AAPL | Stock | 8.6446 | 8.6486 | 8.6429 | 8.6464 | 127596.0 |
| 2010-04-12 08:55:00 | AAPL | Stock | 8.6436 | 8.6461 | 8.6429 | 8.6429 | 106680.0 |
| 2010-04-12 09:00:00 | AAPL | Stock | 8.6429 | 8.6457 | 8.6429 | 8.6457 | 67200.0 |
| 2010-04-12 09:05:00 | AAPL | Stock | 8.6464 | 8.6468 | 8.6439 | 8.6443 | 109368.0 |
| 2010-04-12 09:10:00 | AAPL | Stock | 8.6457 | 8.6475 | 8.6436 | 8.6475 | 81368.0 |
| 2010-04-12 09:15:00 | AAPL | Stock | 8.6464 | 8.65 | 8.6461 | 8.6471 | 97328.0 |
| 2010-04-12 09:20:00 | AAPL | Stock | 8.6468 | 8.6475 | 8.6457 | 8.6475 | 75656.0 |
| 2010-04-12 09:25:00 | AAPL | Stock | 8.6471 | 8.6571 | 8.6446 | 8.6571 | 715820.0 |
| 2010-04-12 09:30:00 | AAPL | Stock | 8.6518 | 8.675 | 8.6443 | 8.6525 | 13487796.0 |
| 2010-04-12 09:35:00 | AAPL | Stock | 8.6532 | 8.6629 | 8.6496 | 8.6568 | 9226000.0 |
| 2010-04-12 09:40:00 | AAPL | Stock | 8.6571 | 8.6668 | 8.6568 | 8.6646 | 7913304.0 |
| 2010-04-12 09:45:00 | AAPL | Stock | 8.6657 | 8.6689 | 8.6525 | 8.6532 | 8076852.0 |
| 2010-04-12 09:50:00 | AAPL | Stock | 8.6525 | 8.6582 | 8.6389 | 8.6389 | 8480920.0 |
| 2010-04-12 09:55:00 | AAPL | Stock | 8.6386 | 8.6518 | 8.6361 | 8.6407 | 10017588.0 |
| 2010-04-12 10:00:00 | AAPL | Stock | 8.64 | 8.6579 | 8.6389 | 8.6575 | 7131292.0 |
| 2010-04-12 10:05:00 | AAPL | Stock | 8.6579 | 8.6607 | 8.6518 | 8.6568 | 5471396.0 |
| 2010-04-12 10:10:00 | AAPL | Stock | 8.6571 | 8.6696 | 8.6571 | 8.6664 | 8738520.0 |
| 2010-04-12 10:15:00 | AAPL | Stock | 8.6657 | 8.6664 | 8.6504 | 8.6532 | 5510680.0 |
| 2010-04-12 10:20:00 | AAPL | Stock | 8.6539 | 8.6646 | 8.6529 | 8.6639 | 4009628.0 |
| 2010-04-12 10:25:00 | AAPL | Stock | 8.6629 | 8.6721 | 8.6607 | 8.6714 | 5650204.0 |
| 2010-04-12 10:30:00 | AAPL | Stock | 8.6718 | 8.6718 | 8.6568 | 8.6661 | 6313216.0 |
| 2010-04-12 10:35:00 | AAPL | Stock | 8.6679 | 8.6679 | 8.6518 | 8.6557 | 5653676.0 |
| 2010-04-12 10:40:00 | AAPL | Stock | 8.6554 | 8.6682 | 8.6532 | 8.6643 | 8740340.0 |
> showing 50 of 327,739 rows — these rows as CSV