PREVIEW / stock_5min / 2007-12-18
file: by_date/stock_5min/2007/2007-12-18.parquet size: 4.5 MB rows: 326,809 symbols: 3,255
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-18 04:15:00 | AAPL | Stock | 6.6321 | 6.6321 | 6.6321 | 6.6321 | 2800.0 |
| 2007-12-18 05:45:00 | AAPL | Stock | 6.6736 | 6.6736 | 6.6736 | 6.6736 | 8400.0 |
| 2007-12-18 05:50:00 | AAPL | Stock | 6.675 | 6.675 | 6.675 | 6.675 | 2800.0 |
| 2007-12-18 05:55:00 | AAPL | Stock | 6.6786 | 6.6786 | 6.6786 | 6.6786 | 5600.0 |
| 2007-12-18 06:40:00 | AAPL | Stock | 6.6786 | 6.6786 | 6.6786 | 6.6786 | 14000.0 |
| 2007-12-18 06:50:00 | AAPL | Stock | 6.6621 | 6.6786 | 6.6621 | 6.6786 | 41860.0 |
| 2007-12-18 06:55:00 | AAPL | Stock | 6.6732 | 6.6804 | 6.6732 | 6.6732 | 72800.0 |
| 2007-12-18 07:00:00 | AAPL | Stock | 6.6964 | 6.6964 | 6.6786 | 6.6786 | 62440.0 |
| 2007-12-18 07:05:00 | AAPL | Stock | 6.675 | 6.675 | 6.6732 | 6.6732 | 43400.0 |
| 2007-12-18 07:10:00 | AAPL | Stock | 6.6782 | 6.6782 | 6.6782 | 6.6782 | 11228.0 |
| 2007-12-18 07:15:00 | AAPL | Stock | 6.6618 | 6.6711 | 6.6611 | 6.6711 | 33600.0 |
| 2007-12-18 07:20:00 | AAPL | Stock | 6.6696 | 6.6746 | 6.6696 | 6.6746 | 19404.0 |
| 2007-12-18 07:25:00 | AAPL | Stock | 6.6714 | 6.6714 | 6.6607 | 6.6625 | 88200.0 |
| 2007-12-18 07:30:00 | AAPL | Stock | 6.6607 | 6.6625 | 6.6571 | 6.6625 | 63112.0 |
| 2007-12-18 07:35:00 | AAPL | Stock | 6.6707 | 6.6707 | 6.6643 | 6.6643 | 36400.0 |
| 2007-12-18 07:40:00 | AAPL | Stock | 6.6643 | 6.6679 | 6.6643 | 6.6679 | 54600.0 |
| 2007-12-18 07:45:00 | AAPL | Stock | 6.6579 | 6.6589 | 6.6579 | 6.6589 | 5600.0 |
| 2007-12-18 07:50:00 | AAPL | Stock | 6.6636 | 6.6639 | 6.6454 | 6.6639 | 53200.0 |
| 2007-12-18 07:55:00 | AAPL | Stock | 6.6643 | 6.6643 | 6.6604 | 6.6607 | 36400.0 |
| 2007-12-18 08:00:00 | AAPL | Stock | 6.6643 | 6.6964 | 6.6607 | 6.6929 | 1641052.0 |
| 2007-12-18 08:05:00 | AAPL | Stock | 6.6936 | 6.6982 | 6.6807 | 6.6839 | 1090488.0 |
| 2007-12-18 08:10:00 | AAPL | Stock | 6.6821 | 6.8114 | 6.6821 | 6.6889 | 868784.0 |
| 2007-12-18 08:15:00 | AAPL | Stock | 6.6889 | 6.6893 | 6.6586 | 6.6643 | 635180.0 |
| 2007-12-18 08:20:00 | AAPL | Stock | 6.6607 | 6.6882 | 6.6571 | 6.6804 | 655508.0 |
| 2007-12-18 08:25:00 | AAPL | Stock | 6.675 | 6.6907 | 6.6739 | 6.6796 | 202440.0 |
| 2007-12-18 08:30:00 | AAPL | Stock | 6.6793 | 6.6875 | 6.6757 | 6.6875 | 437052.0 |
| 2007-12-18 08:35:00 | AAPL | Stock | 6.6821 | 6.6882 | 6.6754 | 6.6754 | 595504.0 |
| 2007-12-18 08:40:00 | AAPL | Stock | 6.6754 | 6.6779 | 6.6743 | 6.6743 | 191912.0 |
| 2007-12-18 08:45:00 | AAPL | Stock | 6.6736 | 6.6736 | 6.6696 | 6.6696 | 151648.0 |
| 2007-12-18 08:50:00 | AAPL | Stock | 6.6661 | 6.6693 | 6.6607 | 6.6661 | 320208.0 |
| 2007-12-18 08:55:00 | AAPL | Stock | 6.6675 | 6.6732 | 6.6661 | 6.6689 | 168140.0 |
| 2007-12-18 09:00:00 | AAPL | Stock | 6.6661 | 6.6679 | 6.6607 | 6.6643 | 202832.0 |
| 2007-12-18 09:05:00 | AAPL | Stock | 6.6643 | 6.675 | 6.6611 | 6.6718 | 227220.0 |
| 2007-12-18 09:10:00 | AAPL | Stock | 6.6729 | 6.6768 | 6.6696 | 6.675 | 206472.0 |
| 2007-12-18 09:15:00 | AAPL | Stock | 6.6768 | 6.6779 | 6.6736 | 6.6757 | 159040.0 |
| 2007-12-18 09:20:00 | AAPL | Stock | 6.675 | 6.675 | 6.6607 | 6.6607 | 396060.0 |
| 2007-12-18 09:25:00 | AAPL | Stock | 6.66 | 6.6711 | 6.6596 | 6.6654 | 513408.0 |
| 2007-12-18 09:30:00 | AAPL | Stock | 6.6614 | 6.6904 | 6.6504 | 6.6761 | 27089692.0 |
| 2007-12-18 09:35:00 | AAPL | Stock | 6.6768 | 6.679 | 6.6282 | 6.6325 | 24350844.0 |
| 2007-12-18 09:40:00 | AAPL | Stock | 6.6321 | 6.6396 | 6.5893 | 6.5982 | 23249548.0 |
| 2007-12-18 09:45:00 | AAPL | Stock | 6.6 | 6.6168 | 6.5786 | 6.5831 | 18705372.0 |
| 2007-12-18 09:50:00 | AAPL | Stock | 6.5846 | 6.6296 | 6.5821 | 6.6225 | 17636528.0 |
| 2007-12-18 09:55:00 | AAPL | Stock | 6.6225 | 6.6339 | 6.6068 | 6.6182 | 17122420.0 |
| 2007-12-18 10:00:00 | AAPL | Stock | 6.6182 | 6.6275 | 6.5821 | 6.5829 | 18124456.0 |
| 2007-12-18 10:05:00 | AAPL | Stock | 6.5825 | 6.6064 | 6.5657 | 6.5818 | 23574180.0 |
| 2007-12-18 10:10:00 | AAPL | Stock | 6.5804 | 6.5825 | 6.5268 | 6.5336 | 29138984.0 |
| 2007-12-18 10:15:00 | AAPL | Stock | 6.5339 | 6.5492 | 6.5118 | 6.5354 | 19522496.0 |
| 2007-12-18 10:20:00 | AAPL | Stock | 6.5357 | 6.5646 | 6.5296 | 6.5604 | 17246292.0 |
| 2007-12-18 10:25:00 | AAPL | Stock | 6.56 | 6.5846 | 6.555 | 6.5693 | 21594804.0 |
| 2007-12-18 10:30:00 | AAPL | Stock | 6.5693 | 6.5836 | 6.55 | 6.5511 | 11470424.0 |
> showing 50 of 326,809 rows — these rows as CSV