PREVIEW / stock_5min / 2007-11-01
file: by_date/stock_5min/2007/2007-11-01.parquet size: 4.5 MB rows: 323,825 symbols: 3,193
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-11-01 04:40:00 | AAPL | Stock | 6.7757 | 6.7757 | 6.7757 | 6.7757 | 16800.0 |
| 2007-11-01 07:00:00 | AAPL | Stock | 6.7686 | 6.7686 | 6.7646 | 6.7646 | 30016.0 |
| 2007-11-01 07:05:00 | AAPL | Stock | 6.7646 | 6.7646 | 6.7646 | 6.7646 | 5600.0 |
| 2007-11-01 07:30:00 | AAPL | Stock | 6.7511 | 6.7511 | 6.7511 | 6.7511 | 14000.0 |
| 2007-11-01 07:40:00 | AAPL | Stock | 6.7518 | 6.7518 | 6.7518 | 6.7518 | 42000.0 |
| 2007-11-01 07:45:00 | AAPL | Stock | 6.7529 | 6.7529 | 6.7521 | 6.7521 | 42000.0 |
| 2007-11-01 07:50:00 | AAPL | Stock | 6.7636 | 6.7636 | 6.7518 | 6.7636 | 86856.0 |
| 2007-11-01 07:55:00 | AAPL | Stock | 6.7521 | 6.7554 | 6.7521 | 6.7554 | 18200.0 |
| 2007-11-01 08:00:00 | AAPL | Stock | 6.7554 | 6.7639 | 6.75 | 6.7568 | 679980.0 |
| 2007-11-01 08:05:00 | AAPL | Stock | 6.7571 | 6.8211 | 6.7518 | 6.7589 | 500416.0 |
| 2007-11-01 08:10:00 | AAPL | Stock | 6.7557 | 6.7568 | 6.7432 | 6.7482 | 921872.0 |
| 2007-11-01 08:15:00 | AAPL | Stock | 6.7482 | 6.7482 | 6.7414 | 6.7443 | 463008.0 |
| 2007-11-01 08:20:00 | AAPL | Stock | 6.745 | 6.745 | 6.7321 | 6.7371 | 510020.0 |
| 2007-11-01 08:25:00 | AAPL | Stock | 6.7357 | 6.7411 | 6.7325 | 6.7411 | 313292.0 |
| 2007-11-01 08:30:00 | AAPL | Stock | 6.7443 | 6.7486 | 6.7439 | 6.7486 | 176764.0 |
| 2007-11-01 08:35:00 | AAPL | Stock | 6.7496 | 6.7536 | 6.7396 | 6.7425 | 789880.0 |
| 2007-11-01 08:40:00 | AAPL | Stock | 6.7407 | 6.7407 | 6.7343 | 6.7375 | 281400.0 |
| 2007-11-01 08:45:00 | AAPL | Stock | 6.7361 | 6.7361 | 6.7221 | 6.7286 | 808276.0 |
| 2007-11-01 08:50:00 | AAPL | Stock | 6.7268 | 6.7268 | 6.7143 | 6.7232 | 814408.0 |
| 2007-11-01 08:55:00 | AAPL | Stock | 6.7214 | 6.7282 | 6.7214 | 6.7243 | 374864.0 |
| 2007-11-01 09:00:00 | AAPL | Stock | 6.7271 | 6.7296 | 6.7214 | 6.7246 | 603428.0 |
| 2007-11-01 09:05:00 | AAPL | Stock | 6.7236 | 6.7246 | 6.7143 | 6.7171 | 892416.0 |
| 2007-11-01 09:10:00 | AAPL | Stock | 6.7164 | 6.7168 | 6.7107 | 6.7139 | 830172.0 |
| 2007-11-01 09:15:00 | AAPL | Stock | 6.7139 | 6.7196 | 6.7136 | 6.7161 | 162456.0 |
| 2007-11-01 09:20:00 | AAPL | Stock | 6.7196 | 6.7839 | 6.7179 | 6.7196 | 274176.0 |
| 2007-11-01 09:25:00 | AAPL | Stock | 6.7196 | 6.7493 | 6.7179 | 6.7321 | 2450224.0 |
| 2007-11-01 09:30:00 | AAPL | Stock | 6.7321 | 6.7454 | 6.7 | 6.7289 | 29089956.0 |
| 2007-11-01 09:35:00 | AAPL | Stock | 6.7293 | 6.7439 | 6.7025 | 6.7054 | 20444648.0 |
| 2007-11-01 09:40:00 | AAPL | Stock | 6.7061 | 6.7304 | 6.7004 | 6.7257 | 18145372.0 |
| 2007-11-01 09:45:00 | AAPL | Stock | 6.7264 | 6.7268 | 6.7071 | 6.7154 | 15864800.0 |
| 2007-11-01 09:50:00 | AAPL | Stock | 6.715 | 6.7357 | 6.715 | 6.7325 | 20135164.0 |
| 2007-11-01 09:55:00 | AAPL | Stock | 6.7336 | 6.7346 | 6.7086 | 6.7157 | 15849820.0 |
| 2007-11-01 10:00:00 | AAPL | Stock | 6.7164 | 6.7286 | 6.7096 | 6.7182 | 11171468.0 |
| 2007-11-01 10:05:00 | AAPL | Stock | 6.7182 | 6.7232 | 6.7089 | 6.7146 | 11302760.0 |
| 2007-11-01 10:10:00 | AAPL | Stock | 6.7143 | 6.7143 | 6.6786 | 6.6939 | 22870260.0 |
| 2007-11-01 10:15:00 | AAPL | Stock | 6.6932 | 6.7143 | 6.6643 | 6.6696 | 15809836.0 |
| 2007-11-01 10:20:00 | AAPL | Stock | 6.6693 | 6.705 | 6.6664 | 6.6986 | 15907808.0 |
| 2007-11-01 10:25:00 | AAPL | Stock | 6.6971 | 6.7136 | 6.6964 | 6.7075 | 11645844.0 |
| 2007-11-01 10:30:00 | AAPL | Stock | 6.7079 | 6.7207 | 6.7029 | 6.71 | 10354904.0 |
| 2007-11-01 10:35:00 | AAPL | Stock | 6.7111 | 6.7189 | 6.7061 | 6.7176 | 8362452.0 |
| 2007-11-01 10:40:00 | AAPL | Stock | 6.7175 | 6.7214 | 6.7089 | 6.7125 | 7999488.0 |
| 2007-11-01 10:45:00 | AAPL | Stock | 6.7129 | 6.7232 | 6.7118 | 6.7204 | 6553764.0 |
| 2007-11-01 10:50:00 | AAPL | Stock | 6.7207 | 6.7232 | 6.7121 | 6.7129 | 6867532.0 |
| 2007-11-01 10:55:00 | AAPL | Stock | 6.7128 | 6.7268 | 6.7104 | 6.725 | 9275952.0 |
| 2007-11-01 11:00:00 | AAPL | Stock | 6.7243 | 6.7254 | 6.7135 | 6.715 | 6036380.0 |
| 2007-11-01 11:05:00 | AAPL | Stock | 6.7157 | 6.7196 | 6.7107 | 6.7161 | 6548444.0 |
| 2007-11-01 11:10:00 | AAPL | Stock | 6.7154 | 6.7311 | 6.7143 | 6.7211 | 8779764.0 |
| 2007-11-01 11:15:00 | AAPL | Stock | 6.7214 | 6.73 | 6.7182 | 6.7296 | 5722668.0 |
| 2007-11-01 11:20:00 | AAPL | Stock | 6.7296 | 6.7404 | 6.7275 | 6.7339 | 9572612.0 |
| 2007-11-01 11:25:00 | AAPL | Stock | 6.7343 | 6.7375 | 6.7279 | 6.7375 | 9278388.0 |
> showing 50 of 323,825 rows — these rows as CSV