PREVIEW / stock_5min / 2005-08-18
file: by_date/stock_5min/2005/2005-08-18.parquet size: 2.7 MB rows: 197,339 symbols: 2,060
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-18 08:00:00 | AAPL | Stock | 1.6821 | 1.6857 | 1.6821 | 1.6857 | 22652.0 |
| 2005-08-18 08:20:00 | AAPL | Stock | 1.6786 | 1.6786 | 1.6786 | 1.6786 | 2800.0 |
| 2005-08-18 08:45:00 | AAPL | Stock | 1.6786 | 1.6786 | 1.6768 | 1.6768 | 19600.0 |
| 2005-08-18 09:00:00 | AAPL | Stock | 1.6768 | 1.6768 | 1.6768 | 1.6768 | 32200.0 |
| 2005-08-18 09:05:00 | AAPL | Stock | 1.6786 | 1.6786 | 1.6786 | 1.6786 | 30800.0 |
| 2005-08-18 09:10:00 | AAPL | Stock | 1.6786 | 1.6804 | 1.6786 | 1.6789 | 372400.0 |
| 2005-08-18 09:15:00 | AAPL | Stock | 1.6796 | 1.6804 | 1.6786 | 1.6789 | 131936.0 |
| 2005-08-18 09:20:00 | AAPL | Stock | 1.6789 | 1.6789 | 1.6786 | 1.6786 | 112000.0 |
| 2005-08-18 09:25:00 | AAPL | Stock | 1.6786 | 1.6786 | 1.675 | 1.675 | 524720.0 |
| 2005-08-18 09:30:00 | AAPL | Stock | 1.6754 | 1.6786 | 1.6607 | 1.6639 | 20827380.0 |
| 2005-08-18 09:35:00 | AAPL | Stock | 1.6636 | 1.6643 | 1.6575 | 1.6636 | 11471600.0 |
| 2005-08-18 09:40:00 | AAPL | Stock | 1.6632 | 1.6636 | 1.6589 | 1.66 | 5856368.0 |
| 2005-08-18 09:45:00 | AAPL | Stock | 1.6604 | 1.6636 | 1.6589 | 1.6614 | 6575968.0 |
| 2005-08-18 09:50:00 | AAPL | Stock | 1.6611 | 1.6621 | 1.6557 | 1.6557 | 7119980.0 |
| 2005-08-18 09:55:00 | AAPL | Stock | 1.6557 | 1.6607 | 1.6525 | 1.6586 | 11643604.0 |
| 2005-08-18 10:00:00 | AAPL | Stock | 1.6589 | 1.6618 | 1.6554 | 1.6596 | 6485752.0 |
| 2005-08-18 10:05:00 | AAPL | Stock | 1.6596 | 1.6607 | 1.6554 | 1.6582 | 5707716.0 |
| 2005-08-18 10:10:00 | AAPL | Stock | 1.6579 | 1.6582 | 1.6554 | 1.6561 | 4919432.0 |
| 2005-08-18 10:15:00 | AAPL | Stock | 1.6561 | 1.6571 | 1.6529 | 1.6561 | 6699140.0 |
| 2005-08-18 10:20:00 | AAPL | Stock | 1.6561 | 1.66 | 1.6529 | 1.6546 | 8448916.0 |
| 2005-08-18 10:25:00 | AAPL | Stock | 1.655 | 1.6579 | 1.6539 | 1.6557 | 4768428.0 |
| 2005-08-18 10:30:00 | AAPL | Stock | 1.6557 | 1.6596 | 1.655 | 1.6582 | 5104120.0 |
| 2005-08-18 10:35:00 | AAPL | Stock | 1.6582 | 1.6582 | 1.6525 | 1.6539 | 5497576.0 |
| 2005-08-18 10:40:00 | AAPL | Stock | 1.6539 | 1.6546 | 1.6518 | 1.6521 | 4278708.0 |
| 2005-08-18 10:45:00 | AAPL | Stock | 1.6518 | 1.6543 | 1.6511 | 1.6518 | 5621980.0 |
| 2005-08-18 10:50:00 | AAPL | Stock | 1.6521 | 1.6536 | 1.6432 | 1.6432 | 14414624.0 |
| 2005-08-18 10:55:00 | AAPL | Stock | 1.6432 | 1.6518 | 1.6371 | 1.6386 | 24153668.0 |
| 2005-08-18 11:00:00 | AAPL | Stock | 1.6386 | 1.6411 | 1.6339 | 1.6404 | 14180740.0 |
| 2005-08-18 11:05:00 | AAPL | Stock | 1.6404 | 1.6411 | 1.6361 | 1.6404 | 8572032.0 |
| 2005-08-18 11:10:00 | AAPL | Stock | 1.6404 | 1.6429 | 1.6389 | 1.6411 | 6960184.0 |
| 2005-08-18 11:15:00 | AAPL | Stock | 1.6411 | 1.6479 | 1.6396 | 1.645 | 8700972.0 |
| 2005-08-18 11:20:00 | AAPL | Stock | 1.6454 | 1.6468 | 1.6439 | 1.6454 | 8144304.0 |
| 2005-08-18 11:25:00 | AAPL | Stock | 1.6454 | 1.65 | 1.6446 | 1.6475 | 5297320.0 |
| 2005-08-18 11:30:00 | AAPL | Stock | 1.6471 | 1.6471 | 1.6446 | 1.645 | 4069856.0 |
| 2005-08-18 11:35:00 | AAPL | Stock | 1.6444 | 1.645 | 1.6414 | 1.6425 | 3655568.0 |
| 2005-08-18 11:40:00 | AAPL | Stock | 1.6425 | 1.6453 | 1.6414 | 1.6421 | 2264836.0 |
| 2005-08-18 11:45:00 | AAPL | Stock | 1.6421 | 1.6432 | 1.6404 | 1.6414 | 4024272.0 |
| 2005-08-18 11:50:00 | AAPL | Stock | 1.6411 | 1.6454 | 1.6411 | 1.6425 | 4143776.0 |
| 2005-08-18 11:55:00 | AAPL | Stock | 1.6425 | 1.6429 | 1.6404 | 1.6411 | 1763048.0 |
| 2005-08-18 12:00:00 | AAPL | Stock | 1.6407 | 1.645 | 1.6404 | 1.6432 | 3500840.0 |
| 2005-08-18 12:05:00 | AAPL | Stock | 1.6429 | 1.6457 | 1.6429 | 1.6457 | 1925392.0 |
| 2005-08-18 12:10:00 | AAPL | Stock | 1.6457 | 1.6464 | 1.6414 | 1.6418 | 2553684.0 |
| 2005-08-18 12:15:00 | AAPL | Stock | 1.6418 | 1.6443 | 1.6418 | 1.6429 | 1344924.0 |
| 2005-08-18 12:20:00 | AAPL | Stock | 1.6429 | 1.6439 | 1.6407 | 1.6425 | 1981532.0 |
| 2005-08-18 12:25:00 | AAPL | Stock | 1.6425 | 1.6454 | 1.6421 | 1.6429 | 1799308.0 |
| 2005-08-18 12:30:00 | AAPL | Stock | 1.6429 | 1.6443 | 1.6421 | 1.6429 | 3026352.0 |
| 2005-08-18 12:35:00 | AAPL | Stock | 1.6429 | 1.6439 | 1.6421 | 1.6439 | 1275316.0 |
| 2005-08-18 12:40:00 | AAPL | Stock | 1.6439 | 1.6439 | 1.6429 | 1.6436 | 1461208.0 |
| 2005-08-18 12:45:00 | AAPL | Stock | 1.6432 | 1.6436 | 1.6421 | 1.6425 | 1696268.0 |
| 2005-08-18 12:50:00 | AAPL | Stock | 1.6421 | 1.6429 | 1.6407 | 1.6425 | 3989020.0 |
> showing 50 of 197,339 rows — these rows as CSV