PREVIEW / stock_5min / 2006-01-23
file: by_date/stock_5min/2006/2006-01-23.parquet size: 2.9 MB rows: 215,652 symbols: 2,171
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 |
|---|---|---|---|---|---|---|---|
| 2006-01-23 04:15:00 | AAPL | Stock | 2.6982 | 2.6982 | 2.6982 | 2.6982 | 5600.0 |
| 2006-01-23 04:30:00 | AAPL | Stock | 2.7 | 2.7 | 2.6964 | 2.6964 | 30800.0 |
| 2006-01-23 05:20:00 | AAPL | Stock | 2.7089 | 2.7089 | 2.7089 | 2.7089 | 14000.0 |
| 2006-01-23 05:30:00 | AAPL | Stock | 2.6964 | 2.6964 | 2.6964 | 2.6964 | 2800.0 |
| 2006-01-23 05:45:00 | AAPL | Stock | 2.6964 | 2.6964 | 2.6964 | 2.6964 | 8400.0 |
| 2006-01-23 06:40:00 | AAPL | Stock | 2.7125 | 2.7125 | 2.7125 | 2.7125 | 4620.0 |
| 2006-01-23 07:05:00 | AAPL | Stock | 2.7161 | 2.7161 | 2.7143 | 2.7143 | 33600.0 |
| 2006-01-23 07:15:00 | AAPL | Stock | 2.7143 | 2.7143 | 2.7143 | 2.7143 | 36400.0 |
| 2006-01-23 07:20:00 | AAPL | Stock | 2.7143 | 2.7143 | 2.7143 | 2.7143 | 14000.0 |
| 2006-01-23 07:30:00 | AAPL | Stock | 2.7161 | 2.7161 | 2.7161 | 2.7161 | 8400.0 |
| 2006-01-23 07:35:00 | AAPL | Stock | 2.7179 | 2.7179 | 2.7143 | 2.7143 | 61600.0 |
| 2006-01-23 07:45:00 | AAPL | Stock | 2.7179 | 2.7179 | 2.7179 | 2.7179 | 5600.0 |
| 2006-01-23 07:55:00 | AAPL | Stock | 2.7179 | 2.7179 | 2.7179 | 2.7179 | 50400.0 |
| 2006-01-23 08:00:00 | AAPL | Stock | 2.7179 | 2.7286 | 2.7146 | 2.7268 | 508452.0 |
| 2006-01-23 08:05:00 | AAPL | Stock | 2.7268 | 2.7321 | 2.725 | 2.7321 | 197652.0 |
| 2006-01-23 08:10:00 | AAPL | Stock | 2.7339 | 2.7357 | 2.7275 | 2.7321 | 197400.0 |
| 2006-01-23 08:15:00 | AAPL | Stock | 2.7321 | 2.7346 | 2.7314 | 2.7329 | 218232.0 |
| 2006-01-23 08:20:00 | AAPL | Stock | 2.7339 | 2.7339 | 2.7293 | 2.7318 | 168588.0 |
| 2006-01-23 08:25:00 | AAPL | Stock | 2.7296 | 2.7321 | 2.7296 | 2.7307 | 141120.0 |
| 2006-01-23 08:30:00 | AAPL | Stock | 2.7307 | 2.7314 | 2.7307 | 2.7314 | 49280.0 |
| 2006-01-23 08:35:00 | AAPL | Stock | 2.7307 | 2.7311 | 2.725 | 2.7275 | 208292.0 |
| 2006-01-23 08:40:00 | AAPL | Stock | 2.7275 | 2.7286 | 2.725 | 2.725 | 89544.0 |
| 2006-01-23 08:45:00 | AAPL | Stock | 2.725 | 2.7254 | 2.7218 | 2.7225 | 1709036.0 |
| 2006-01-23 08:50:00 | AAPL | Stock | 2.7211 | 2.7232 | 2.7179 | 2.7207 | 420252.0 |
| 2006-01-23 08:55:00 | AAPL | Stock | 2.7204 | 2.7296 | 2.7204 | 2.7286 | 428064.0 |
| 2006-01-23 09:00:00 | AAPL | Stock | 2.7286 | 2.7314 | 2.7286 | 2.7293 | 275240.0 |
| 2006-01-23 09:05:00 | AAPL | Stock | 2.7304 | 2.7311 | 2.7218 | 2.7264 | 313628.0 |
| 2006-01-23 09:10:00 | AAPL | Stock | 2.7264 | 2.7275 | 2.7232 | 2.7232 | 529256.0 |
| 2006-01-23 09:15:00 | AAPL | Stock | 2.7232 | 2.7243 | 2.7211 | 2.7229 | 122836.0 |
| 2006-01-23 09:20:00 | AAPL | Stock | 2.7229 | 2.7229 | 2.7179 | 2.72 | 818664.0 |
| 2006-01-23 09:25:00 | AAPL | Stock | 2.72 | 2.7311 | 2.7182 | 2.7186 | 5762932.0 |
| 2006-01-23 09:30:00 | AAPL | Stock | 2.7179 | 2.7325 | 2.7175 | 2.7232 | 34752620.0 |
| 2006-01-23 09:35:00 | AAPL | Stock | 2.7232 | 2.7314 | 2.7161 | 2.7239 | 22532132.0 |
| 2006-01-23 09:40:00 | AAPL | Stock | 2.7236 | 2.7321 | 2.7229 | 2.7229 | 22026424.0 |
| 2006-01-23 09:45:00 | AAPL | Stock | 2.7232 | 2.7232 | 2.7164 | 2.7232 | 12425168.0 |
| 2006-01-23 09:50:00 | AAPL | Stock | 2.7232 | 2.7311 | 2.7179 | 2.7307 | 16493904.0 |
| 2006-01-23 09:55:00 | AAPL | Stock | 2.7304 | 2.7314 | 2.7189 | 2.7196 | 13274016.0 |
| 2006-01-23 10:00:00 | AAPL | Stock | 2.7196 | 2.7229 | 2.7143 | 2.7214 | 17315200.0 |
| 2006-01-23 10:05:00 | AAPL | Stock | 2.7214 | 2.7264 | 2.7189 | 2.7239 | 12707268.0 |
| 2006-01-23 10:10:00 | AAPL | Stock | 2.7231 | 2.7429 | 2.7218 | 2.7329 | 23005892.0 |
| 2006-01-23 10:15:00 | AAPL | Stock | 2.7329 | 2.7411 | 2.725 | 2.7307 | 12271168.0 |
| 2006-01-23 10:20:00 | AAPL | Stock | 2.7311 | 2.7457 | 2.7286 | 2.745 | 14125776.0 |
| 2006-01-23 10:25:00 | AAPL | Stock | 2.745 | 2.7611 | 2.7439 | 2.7532 | 26667900.0 |
| 2006-01-23 10:30:00 | AAPL | Stock | 2.7532 | 2.7536 | 2.7432 | 2.7468 | 18686136.0 |
| 2006-01-23 10:35:00 | AAPL | Stock | 2.7461 | 2.7479 | 2.7379 | 2.7464 | 7588140.0 |
| 2006-01-23 10:40:00 | AAPL | Stock | 2.7464 | 2.7486 | 2.7414 | 2.7421 | 7997332.0 |
| 2006-01-23 10:45:00 | AAPL | Stock | 2.7418 | 2.7468 | 2.7375 | 2.7443 | 9006116.0 |
| 2006-01-23 10:50:00 | AAPL | Stock | 2.7443 | 2.7525 | 2.7436 | 2.7518 | 11512648.0 |
| 2006-01-23 10:55:00 | AAPL | Stock | 2.7521 | 2.7732 | 2.75 | 2.7721 | 22354612.0 |
| 2006-01-23 11:00:00 | AAPL | Stock | 2.7721 | 2.7775 | 2.7654 | 2.775 | 15508192.0 |
> showing 50 of 215,652 rows — these rows as CSV