PREVIEW / stock_5min / 2005-08-30
file: by_date/stock_5min/2005/2005-08-30.parquet size: 2.7 MB rows: 197,086 symbols: 2,059
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-30 08:00:00 | AAPL | Stock | 1.6411 | 1.6514 | 1.6393 | 1.6514 | 1247680.0 |
| 2005-08-30 08:05:00 | AAPL | Stock | 1.6518 | 1.6518 | 1.6471 | 1.6471 | 291676.0 |
| 2005-08-30 08:10:00 | AAPL | Stock | 1.6471 | 1.6471 | 1.6471 | 1.6471 | 36400.0 |
| 2005-08-30 08:15:00 | AAPL | Stock | 1.6471 | 1.6471 | 1.6471 | 1.6471 | 33600.0 |
| 2005-08-30 08:20:00 | AAPL | Stock | 1.6482 | 1.6482 | 1.6482 | 1.6482 | 112000.0 |
| 2005-08-30 08:25:00 | AAPL | Stock | 1.6482 | 1.6514 | 1.6482 | 1.65 | 381640.0 |
| 2005-08-30 08:30:00 | AAPL | Stock | 1.65 | 1.6507 | 1.6496 | 1.65 | 99120.0 |
| 2005-08-30 08:35:00 | AAPL | Stock | 1.6486 | 1.65 | 1.6486 | 1.65 | 293300.0 |
| 2005-08-30 08:40:00 | AAPL | Stock | 1.65 | 1.65 | 1.6486 | 1.6486 | 80080.0 |
| 2005-08-30 08:45:00 | AAPL | Stock | 1.6489 | 1.6489 | 1.6482 | 1.6482 | 56000.0 |
| 2005-08-30 08:50:00 | AAPL | Stock | 1.6479 | 1.6479 | 1.6429 | 1.6429 | 294812.0 |
| 2005-08-30 08:55:00 | AAPL | Stock | 1.6439 | 1.6439 | 1.6439 | 1.6439 | 42000.0 |
| 2005-08-30 09:00:00 | AAPL | Stock | 1.6439 | 1.6446 | 1.6439 | 1.6446 | 266700.0 |
| 2005-08-30 09:05:00 | AAPL | Stock | 1.6446 | 1.6446 | 1.6439 | 1.6439 | 8400.0 |
| 2005-08-30 09:10:00 | AAPL | Stock | 1.6446 | 1.6446 | 1.6429 | 1.6432 | 395360.0 |
| 2005-08-30 09:15:00 | AAPL | Stock | 1.6432 | 1.6432 | 1.6382 | 1.6386 | 182560.0 |
| 2005-08-30 09:20:00 | AAPL | Stock | 1.6393 | 1.6393 | 1.6393 | 1.6393 | 26600.0 |
| 2005-08-30 09:25:00 | AAPL | Stock | 1.6396 | 1.6432 | 1.6393 | 1.6421 | 408240.0 |
| 2005-08-30 09:30:00 | AAPL | Stock | 1.6425 | 1.6507 | 1.6421 | 1.6507 | 15453340.0 |
| 2005-08-30 09:35:00 | AAPL | Stock | 1.6507 | 1.6525 | 1.6471 | 1.6525 | 11128796.0 |
| 2005-08-30 09:40:00 | AAPL | Stock | 1.6521 | 1.6532 | 1.6464 | 1.6471 | 11671212.0 |
| 2005-08-30 09:45:00 | AAPL | Stock | 1.6468 | 1.6471 | 1.64 | 1.6471 | 11664408.0 |
| 2005-08-30 09:50:00 | AAPL | Stock | 1.6471 | 1.6536 | 1.6468 | 1.6511 | 12242496.0 |
| 2005-08-30 09:55:00 | AAPL | Stock | 1.6511 | 1.6654 | 1.65 | 1.6636 | 20643700.0 |
| 2005-08-30 10:00:00 | AAPL | Stock | 1.6636 | 1.6675 | 1.6589 | 1.6661 | 16904356.0 |
| 2005-08-30 10:05:00 | AAPL | Stock | 1.6661 | 1.6661 | 1.6614 | 1.6636 | 10672816.0 |
| 2005-08-30 10:10:00 | AAPL | Stock | 1.6636 | 1.6711 | 1.6625 | 1.67 | 13480404.0 |
| 2005-08-30 10:15:00 | AAPL | Stock | 1.67 | 1.67 | 1.6643 | 1.6643 | 8556184.0 |
| 2005-08-30 10:20:00 | AAPL | Stock | 1.6643 | 1.6664 | 1.6625 | 1.6643 | 7278404.0 |
| 2005-08-30 10:25:00 | AAPL | Stock | 1.6646 | 1.6654 | 1.6621 | 1.6654 | 5916932.0 |
| 2005-08-30 10:30:00 | AAPL | Stock | 1.6654 | 1.6664 | 1.6621 | 1.6646 | 6854988.0 |
| 2005-08-30 10:35:00 | AAPL | Stock | 1.665 | 1.6654 | 1.6621 | 1.6625 | 6505548.0 |
| 2005-08-30 10:40:00 | AAPL | Stock | 1.6625 | 1.665 | 1.6557 | 1.6571 | 11139212.0 |
| 2005-08-30 10:45:00 | AAPL | Stock | 1.6568 | 1.6593 | 1.6564 | 1.6586 | 7173796.0 |
| 2005-08-30 10:50:00 | AAPL | Stock | 1.6582 | 1.6586 | 1.655 | 1.6582 | 6163892.0 |
| 2005-08-30 10:55:00 | AAPL | Stock | 1.6579 | 1.6604 | 1.6579 | 1.6585 | 3416392.0 |
| 2005-08-30 11:00:00 | AAPL | Stock | 1.6582 | 1.6593 | 1.6561 | 1.6564 | 3227868.0 |
| 2005-08-30 11:05:00 | AAPL | Stock | 1.6561 | 1.6568 | 1.6504 | 1.6511 | 7800660.0 |
| 2005-08-30 11:10:00 | AAPL | Stock | 1.6514 | 1.6529 | 1.6496 | 1.6511 | 6389264.0 |
| 2005-08-30 11:15:00 | AAPL | Stock | 1.6511 | 1.6514 | 1.6446 | 1.6482 | 11303684.0 |
| 2005-08-30 11:20:00 | AAPL | Stock | 1.6479 | 1.6511 | 1.6464 | 1.6507 | 6413008.0 |
| 2005-08-30 11:25:00 | AAPL | Stock | 1.6511 | 1.6546 | 1.6511 | 1.6543 | 6303136.0 |
| 2005-08-30 11:30:00 | AAPL | Stock | 1.6543 | 1.655 | 1.6518 | 1.6521 | 6726832.0 |
| 2005-08-30 11:35:00 | AAPL | Stock | 1.6518 | 1.6532 | 1.6507 | 1.6521 | 2230732.0 |
| 2005-08-30 11:40:00 | AAPL | Stock | 1.6521 | 1.6521 | 1.6486 | 1.6511 | 2891448.0 |
| 2005-08-30 11:45:00 | AAPL | Stock | 1.65 | 1.6514 | 1.65 | 1.6507 | 4085760.0 |
| 2005-08-30 11:50:00 | AAPL | Stock | 1.6504 | 1.6507 | 1.6493 | 1.6496 | 1213100.0 |
| 2005-08-30 11:55:00 | AAPL | Stock | 1.65 | 1.6514 | 1.6489 | 1.6496 | 2854068.0 |
| 2005-08-30 12:00:00 | AAPL | Stock | 1.6496 | 1.6532 | 1.6486 | 1.6529 | 5121116.0 |
| 2005-08-30 12:05:00 | AAPL | Stock | 1.6529 | 1.6557 | 1.6529 | 1.6557 | 4559296.0 |
> showing 50 of 197,086 rows — these rows as CSV