PREVIEW / stock_1min / 2007-12-18
file: by_date/stock_1min/2007/2007-12-18.parquet size: 12.8 MB rows: 1,039,542 symbols: 2,660
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:48:00 | AAPL | Stock | 6.6736 | 6.6736 | 6.6736 | 6.6736 | 8400.0 |
| 2007-12-18 05:54:00 | AAPL | Stock | 6.675 | 6.675 | 6.675 | 6.675 | 2800.0 |
| 2007-12-18 05:59:00 | AAPL | Stock | 6.6786 | 6.6786 | 6.6786 | 6.6786 | 5600.0 |
| 2007-12-18 06:43:00 | AAPL | Stock | 6.6786 | 6.6786 | 6.6786 | 6.6786 | 14000.0 |
| 2007-12-18 06:53:00 | AAPL | Stock | 6.6621 | 6.6621 | 6.6621 | 6.6621 | 8400.0 |
| 2007-12-18 06:54:00 | AAPL | Stock | 6.6621 | 6.6786 | 6.6621 | 6.6786 | 33460.0 |
| 2007-12-18 06:55:00 | AAPL | Stock | 6.6732 | 6.6732 | 6.6732 | 6.6732 | 28000.0 |
| 2007-12-18 06:56:00 | AAPL | Stock | 6.6786 | 6.6804 | 6.6732 | 6.6732 | 44800.0 |
| 2007-12-18 07:00:00 | AAPL | Stock | 6.6964 | 6.6964 | 6.6786 | 6.6786 | 62440.0 |
| 2007-12-18 07:07:00 | AAPL | Stock | 6.675 | 6.675 | 6.6732 | 6.6732 | 37800.0 |
| 2007-12-18 07:09:00 | AAPL | Stock | 6.6732 | 6.6732 | 6.6732 | 6.6732 | 5600.0 |
| 2007-12-18 07:12:00 | AAPL | Stock | 6.6782 | 6.6782 | 6.6782 | 6.6782 | 2800.0 |
| 2007-12-18 07:14:00 | AAPL | Stock | 6.6782 | 6.6782 | 6.6782 | 6.6782 | 8428.0 |
| 2007-12-18 07:16:00 | AAPL | Stock | 6.6618 | 6.6618 | 6.6611 | 6.6611 | 30800.0 |
| 2007-12-18 07:18:00 | AAPL | Stock | 6.6711 | 6.6711 | 6.6711 | 6.6711 | 2800.0 |
| 2007-12-18 07:22:00 | AAPL | Stock | 6.6696 | 6.6711 | 6.6696 | 6.6711 | 16604.0 |
| 2007-12-18 07:24:00 | AAPL | Stock | 6.6746 | 6.6746 | 6.6746 | 6.6746 | 2800.0 |
| 2007-12-18 07:27:00 | AAPL | Stock | 6.6714 | 6.6714 | 6.6714 | 6.6714 | 42000.0 |
| 2007-12-18 07:28:00 | AAPL | Stock | 6.6714 | 6.6714 | 6.6714 | 6.6714 | 14000.0 |
| 2007-12-18 07:29:00 | AAPL | Stock | 6.6629 | 6.6629 | 6.6607 | 6.6625 | 32200.0 |
| 2007-12-18 07:30:00 | AAPL | Stock | 6.6607 | 6.6625 | 6.6571 | 6.6571 | 37772.0 |
| 2007-12-18 07:33:00 | AAPL | Stock | 6.6575 | 6.6625 | 6.6575 | 6.6625 | 25340.0 |
| 2007-12-18 07:35:00 | AAPL | Stock | 6.6707 | 6.6707 | 6.6707 | 6.6707 | 2800.0 |
| 2007-12-18 07:36:00 | AAPL | Stock | 6.6679 | 6.6679 | 6.6679 | 6.6679 | 28000.0 |
| 2007-12-18 07:37:00 | AAPL | Stock | 6.6643 | 6.6643 | 6.6643 | 6.6643 | 5600.0 |
| 2007-12-18 07:40:00 | AAPL | Stock | 6.6643 | 6.6643 | 6.6643 | 6.6643 | 10500.0 |
| 2007-12-18 07:41:00 | AAPL | Stock | 6.6643 | 6.6643 | 6.6643 | 6.6643 | 2800.0 |
| 2007-12-18 07:42:00 | AAPL | Stock | 6.6643 | 6.6643 | 6.6643 | 6.6643 | 35700.0 |
| 2007-12-18 07:43:00 | AAPL | Stock | 6.6643 | 6.6679 | 6.6643 | 6.6679 | 5600.0 |
| 2007-12-18 07:47:00 | AAPL | Stock | 6.6579 | 6.6589 | 6.6579 | 6.6589 | 5600.0 |
| 2007-12-18 07:50:00 | AAPL | Stock | 6.6636 | 6.6636 | 6.6636 | 6.6636 | 2800.0 |
| 2007-12-18 07:51:00 | AAPL | Stock | 6.6571 | 6.6571 | 6.6571 | 6.6571 | 28000.0 |
| 2007-12-18 07:52:00 | AAPL | Stock | 6.6518 | 6.6518 | 6.6454 | 6.6454 | 8400.0 |
| 2007-12-18 07:53:00 | AAPL | Stock | 6.6632 | 6.6639 | 6.6632 | 6.6639 | 14000.0 |
| 2007-12-18 07:55:00 | AAPL | Stock | 6.6643 | 6.6643 | 6.6643 | 6.6643 | 2800.0 |
| 2007-12-18 07:56:00 | AAPL | Stock | 6.6604 | 6.6607 | 6.6604 | 6.6607 | 33600.0 |
| 2007-12-18 08:00:00 | AAPL | Stock | 6.6643 | 6.6786 | 6.6607 | 6.6696 | 426384.0 |
| 2007-12-18 08:01:00 | AAPL | Stock | 6.6679 | 6.6746 | 6.6679 | 6.6714 | 179228.0 |
| 2007-12-18 08:02:00 | AAPL | Stock | 6.6714 | 6.6786 | 6.6679 | 6.6786 | 362432.0 |
| 2007-12-18 08:03:00 | AAPL | Stock | 6.6779 | 6.6875 | 6.6743 | 6.6875 | 292236.0 |
| 2007-12-18 08:04:00 | AAPL | Stock | 6.6886 | 6.6964 | 6.6857 | 6.6929 | 380772.0 |
| 2007-12-18 08:05:00 | AAPL | Stock | 6.6936 | 6.6964 | 6.6893 | 6.6964 | 434140.0 |
| 2007-12-18 08:06:00 | AAPL | Stock | 6.6982 | 6.6982 | 6.6929 | 6.6929 | 308924.0 |
| 2007-12-18 08:07:00 | AAPL | Stock | 6.6918 | 6.6918 | 6.6893 | 6.6896 | 165424.0 |
| 2007-12-18 08:08:00 | AAPL | Stock | 6.6896 | 6.6896 | 6.6807 | 6.6814 | 128800.0 |
| 2007-12-18 08:09:00 | AAPL | Stock | 6.6811 | 6.685 | 6.6811 | 6.6839 | 53200.0 |
| 2007-12-18 08:10:00 | AAPL | Stock | 6.6821 | 6.6843 | 6.6821 | 6.6843 | 71960.0 |
| 2007-12-18 08:11:00 | AAPL | Stock | 6.6857 | 6.8114 | 6.6821 | 6.6825 | 308560.0 |
| 2007-12-18 08:12:00 | AAPL | Stock | 6.6825 | 6.6904 | 6.6821 | 6.6889 | 104300.0 |
> showing 50 of 1,039,542 rows — these rows as CSV