PREVIEW / stock_5min / 2007-10-31
file: by_date/stock_5min/2007/2007-10-31.parquet size: 4.4 MB rows: 316,945 symbols: 3,180
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-10-31 07:10:00 | AAPL | Stock | 6.7071 | 6.7071 | 6.7071 | 6.7071 | 14000.0 |
| 2007-10-31 07:15:00 | AAPL | Stock | 6.7071 | 6.7071 | 6.7071 | 6.7071 | 2800.0 |
| 2007-10-31 07:20:00 | AAPL | Stock | 6.7143 | 6.7143 | 6.7143 | 6.7143 | 3444.0 |
| 2007-10-31 07:25:00 | AAPL | Stock | 6.7107 | 6.7107 | 6.7107 | 6.7107 | 32956.0 |
| 2007-10-31 07:30:00 | AAPL | Stock | 6.71 | 6.71 | 6.71 | 6.71 | 8400.0 |
| 2007-10-31 07:35:00 | AAPL | Stock | 6.71 | 6.71 | 6.71 | 6.71 | 11200.0 |
| 2007-10-31 07:40:00 | AAPL | Stock | 6.7107 | 6.7107 | 6.7107 | 6.7107 | 16800.0 |
| 2007-10-31 07:45:00 | AAPL | Stock | 6.7189 | 6.7196 | 6.7189 | 6.7196 | 16800.0 |
| 2007-10-31 07:50:00 | AAPL | Stock | 6.7196 | 6.7196 | 6.7196 | 6.7196 | 5600.0 |
| 2007-10-31 07:55:00 | AAPL | Stock | 6.7286 | 6.7286 | 6.7286 | 6.7286 | 14000.0 |
| 2007-10-31 08:00:00 | AAPL | Stock | 6.7196 | 6.7196 | 6.6964 | 6.7036 | 859460.0 |
| 2007-10-31 08:05:00 | AAPL | Stock | 6.7046 | 6.7107 | 6.6982 | 6.7107 | 198100.0 |
| 2007-10-31 08:10:00 | AAPL | Stock | 6.7111 | 6.7268 | 6.7075 | 6.7121 | 411432.0 |
| 2007-10-31 08:15:00 | AAPL | Stock | 6.7107 | 6.7139 | 6.7089 | 6.7093 | 350616.0 |
| 2007-10-31 08:20:00 | AAPL | Stock | 6.7089 | 6.7132 | 6.7054 | 6.7132 | 241164.0 |
| 2007-10-31 08:25:00 | AAPL | Stock | 6.7114 | 6.7114 | 6.71 | 6.7111 | 112000.0 |
| 2007-10-31 08:30:00 | AAPL | Stock | 6.7111 | 6.7129 | 6.7071 | 6.7071 | 373912.0 |
| 2007-10-31 08:35:00 | AAPL | Stock | 6.71 | 6.7143 | 6.7096 | 6.7111 | 363020.0 |
| 2007-10-31 08:40:00 | AAPL | Stock | 6.7129 | 6.7143 | 6.7036 | 6.7054 | 486668.0 |
| 2007-10-31 08:45:00 | AAPL | Stock | 6.7054 | 6.7086 | 6.7036 | 6.7075 | 180460.0 |
| 2007-10-31 08:50:00 | AAPL | Stock | 6.7079 | 6.7107 | 6.7057 | 6.7079 | 235200.0 |
| 2007-10-31 08:55:00 | AAPL | Stock | 6.7079 | 6.7104 | 6.7057 | 6.7057 | 230076.0 |
| 2007-10-31 09:00:00 | AAPL | Stock | 6.7057 | 6.7057 | 6.6993 | 6.7036 | 383096.0 |
| 2007-10-31 09:05:00 | AAPL | Stock | 6.705 | 6.7096 | 6.7032 | 6.7071 | 116480.0 |
| 2007-10-31 09:10:00 | AAPL | Stock | 6.7025 | 6.7057 | 6.7025 | 6.705 | 161532.0 |
| 2007-10-31 09:15:00 | AAPL | Stock | 6.7007 | 6.7007 | 6.6932 | 6.6982 | 339584.0 |
| 2007-10-31 09:20:00 | AAPL | Stock | 6.6996 | 6.7071 | 6.6993 | 6.7036 | 255360.0 |
| 2007-10-31 09:25:00 | AAPL | Stock | 6.7021 | 6.7029 | 6.7 | 6.7029 | 308840.0 |
| 2007-10-31 09:30:00 | AAPL | Stock | 6.7029 | 6.7179 | 6.6925 | 6.7093 | 19155584.0 |
| 2007-10-31 09:35:00 | AAPL | Stock | 6.7093 | 6.7479 | 6.7064 | 6.745 | 20579440.0 |
| 2007-10-31 09:40:00 | AAPL | Stock | 6.7454 | 6.7489 | 6.7154 | 6.7271 | 15476580.0 |
| 2007-10-31 09:45:00 | AAPL | Stock | 6.7271 | 6.7393 | 6.7232 | 6.7332 | 7696444.0 |
| 2007-10-31 09:50:00 | AAPL | Stock | 6.7336 | 6.7386 | 6.7225 | 6.73 | 7375536.0 |
| 2007-10-31 09:55:00 | AAPL | Stock | 6.7282 | 6.7379 | 6.7282 | 6.7329 | 6332312.0 |
| 2007-10-31 10:00:00 | AAPL | Stock | 6.7329 | 6.7429 | 6.7325 | 6.7366 | 5883276.0 |
| 2007-10-31 10:05:00 | AAPL | Stock | 6.7368 | 6.745 | 6.725 | 6.7368 | 10899868.0 |
| 2007-10-31 10:10:00 | AAPL | Stock | 6.7364 | 6.7375 | 6.7286 | 6.7329 | 5130608.0 |
| 2007-10-31 10:15:00 | AAPL | Stock | 6.7329 | 6.7371 | 6.7318 | 6.7339 | 2257332.0 |
| 2007-10-31 10:20:00 | AAPL | Stock | 6.7336 | 6.7396 | 6.7321 | 6.7379 | 4216912.0 |
| 2007-10-31 10:25:00 | AAPL | Stock | 6.7386 | 6.7486 | 6.7375 | 6.7436 | 7482160.0 |
| 2007-10-31 10:30:00 | AAPL | Stock | 6.7436 | 6.7482 | 6.7379 | 6.74 | 5751592.0 |
| 2007-10-31 10:35:00 | AAPL | Stock | 6.7393 | 6.7446 | 6.7368 | 6.7425 | 6447896.0 |
| 2007-10-31 10:40:00 | AAPL | Stock | 6.7414 | 6.7454 | 6.7375 | 6.7404 | 4035304.0 |
| 2007-10-31 10:45:00 | AAPL | Stock | 6.7404 | 6.7429 | 6.7321 | 6.734 | 6095432.0 |
| 2007-10-31 10:50:00 | AAPL | Stock | 6.7346 | 6.7393 | 6.7311 | 6.7343 | 4781476.0 |
| 2007-10-31 10:55:00 | AAPL | Stock | 6.735 | 6.7393 | 6.7304 | 6.732 | 6186404.0 |
| 2007-10-31 11:00:00 | AAPL | Stock | 6.7311 | 6.7389 | 6.7304 | 6.7389 | 4937632.0 |
| 2007-10-31 11:05:00 | AAPL | Stock | 6.7389 | 6.7421 | 6.7357 | 6.7357 | 2849868.0 |
| 2007-10-31 11:10:00 | AAPL | Stock | 6.7359 | 6.7386 | 6.7254 | 6.73 | 7444500.0 |
| 2007-10-31 11:15:00 | AAPL | Stock | 6.7293 | 6.7411 | 6.7261 | 6.7375 | 4496856.0 |
> showing 50 of 316,945 rows — these rows as CSV