PREVIEW / stock_5min / 2009-03-30
file: by_date/stock_5min/2009/2009-03-30.parquet size: 4.4 MB rows: 305,974 symbols: 3,305
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-30 04:15:00 | AAPL | Stock | 3.7321 | 3.7321 | 3.7321 | 3.7321 | 19600.0 |
| 2009-03-30 04:50:00 | AAPL | Stock | 3.7007 | 3.7007 | 3.6861 | 3.6861 | 31360.0 |
| 2009-03-30 05:30:00 | AAPL | Stock | 3.6675 | 3.6686 | 3.6675 | 3.6686 | 5600.0 |
| 2009-03-30 05:40:00 | AAPL | Stock | 3.6718 | 3.6718 | 3.6718 | 3.6718 | 2800.0 |
| 2009-03-30 06:10:00 | AAPL | Stock | 3.6704 | 3.6704 | 3.6704 | 3.6704 | 5600.0 |
| 2009-03-30 06:15:00 | AAPL | Stock | 3.6686 | 3.6686 | 3.6686 | 3.6686 | 11200.0 |
| 2009-03-30 07:00:00 | AAPL | Stock | 3.6893 | 3.6893 | 3.6893 | 3.6893 | 12684.0 |
| 2009-03-30 07:10:00 | AAPL | Stock | 3.7168 | 3.7289 | 3.7168 | 3.7289 | 9716.0 |
| 2009-03-30 07:15:00 | AAPL | Stock | 3.7279 | 3.7321 | 3.7168 | 3.7168 | 50344.0 |
| 2009-03-30 07:30:00 | AAPL | Stock | 3.7318 | 3.7318 | 3.7318 | 3.7318 | 2800.0 |
| 2009-03-30 07:40:00 | AAPL | Stock | 3.7318 | 3.7318 | 3.7318 | 3.7318 | 13160.0 |
| 2009-03-30 07:45:00 | AAPL | Stock | 3.7304 | 3.7304 | 3.7243 | 3.7243 | 29400.0 |
| 2009-03-30 07:50:00 | AAPL | Stock | 3.7236 | 3.7236 | 3.7179 | 3.7179 | 14000.0 |
| 2009-03-30 07:55:00 | AAPL | Stock | 3.7214 | 3.7214 | 3.7214 | 3.7214 | 8400.0 |
| 2009-03-30 08:00:00 | AAPL | Stock | 3.7214 | 3.7318 | 3.71 | 3.7143 | 207480.0 |
| 2009-03-30 08:05:00 | AAPL | Stock | 3.7143 | 3.7296 | 3.7104 | 3.7104 | 29960.0 |
| 2009-03-30 08:10:00 | AAPL | Stock | 3.7143 | 3.7143 | 3.7143 | 3.7143 | 16800.0 |
| 2009-03-30 08:15:00 | AAPL | Stock | 3.7143 | 3.7232 | 3.7143 | 3.7143 | 35420.0 |
| 2009-03-30 08:20:00 | AAPL | Stock | 3.7129 | 3.7232 | 3.7107 | 3.7232 | 99400.0 |
| 2009-03-30 08:25:00 | AAPL | Stock | 3.7232 | 3.7321 | 3.7114 | 3.7114 | 209972.0 |
| 2009-03-30 08:30:00 | AAPL | Stock | 3.7143 | 3.7164 | 3.7143 | 3.7143 | 32452.0 |
| 2009-03-30 08:35:00 | AAPL | Stock | 3.715 | 3.7214 | 3.7132 | 3.7132 | 39200.0 |
| 2009-03-30 08:40:00 | AAPL | Stock | 3.7143 | 3.7204 | 3.7107 | 3.7204 | 79800.0 |
| 2009-03-30 08:45:00 | AAPL | Stock | 3.7179 | 3.725 | 3.7143 | 3.7214 | 208684.0 |
| 2009-03-30 08:50:00 | AAPL | Stock | 3.7243 | 3.7336 | 3.7232 | 3.7271 | 168056.0 |
| 2009-03-30 08:55:00 | AAPL | Stock | 3.7286 | 3.7329 | 3.725 | 3.7268 | 88284.0 |
| 2009-03-30 09:00:00 | AAPL | Stock | 3.7311 | 3.7311 | 3.7232 | 3.7275 | 212212.0 |
| 2009-03-30 09:05:00 | AAPL | Stock | 3.7257 | 3.7261 | 3.7254 | 3.7254 | 53200.0 |
| 2009-03-30 09:10:00 | AAPL | Stock | 3.7254 | 3.7296 | 3.7143 | 3.7179 | 313124.0 |
| 2009-03-30 09:15:00 | AAPL | Stock | 3.7164 | 3.7214 | 3.7161 | 3.7214 | 70560.0 |
| 2009-03-30 09:20:00 | AAPL | Stock | 3.725 | 3.7296 | 3.725 | 3.7296 | 52920.0 |
| 2009-03-30 09:25:00 | AAPL | Stock | 3.7296 | 3.7368 | 3.7182 | 3.7286 | 603820.0 |
| 2009-03-30 09:30:00 | AAPL | Stock | 3.7257 | 3.7475 | 3.7146 | 3.7451 | 16717876.0 |
| 2009-03-30 09:35:00 | AAPL | Stock | 3.7454 | 3.7482 | 3.7257 | 3.7457 | 11323564.0 |
| 2009-03-30 09:40:00 | AAPL | Stock | 3.7454 | 3.75 | 3.7336 | 3.7343 | 14616812.0 |
| 2009-03-30 09:45:00 | AAPL | Stock | 3.7346 | 3.7504 | 3.7321 | 3.7364 | 9276596.0 |
| 2009-03-30 09:50:00 | AAPL | Stock | 3.7361 | 3.7379 | 3.7164 | 3.73 | 9928520.0 |
| 2009-03-30 09:55:00 | AAPL | Stock | 3.73 | 3.735 | 3.7193 | 3.7336 | 7621096.0 |
| 2009-03-30 10:00:00 | AAPL | Stock | 3.7321 | 3.74 | 3.7239 | 3.7271 | 5968872.0 |
| 2009-03-30 10:05:00 | AAPL | Stock | 3.7268 | 3.7307 | 3.7196 | 3.7296 | 6445824.0 |
| 2009-03-30 10:10:00 | AAPL | Stock | 3.7296 | 3.7361 | 3.7193 | 3.7235 | 7604996.0 |
| 2009-03-30 10:15:00 | AAPL | Stock | 3.7239 | 3.7239 | 3.7021 | 3.7079 | 12190108.0 |
| 2009-03-30 10:20:00 | AAPL | Stock | 3.7082 | 3.7096 | 3.6996 | 3.7014 | 7334236.0 |
| 2009-03-30 10:25:00 | AAPL | Stock | 3.7021 | 3.7075 | 3.6893 | 3.6968 | 6864788.0 |
| 2009-03-30 10:30:00 | AAPL | Stock | 3.6968 | 3.6968 | 3.6786 | 3.6814 | 10228624.0 |
| 2009-03-30 10:35:00 | AAPL | Stock | 3.6818 | 3.6893 | 3.6804 | 3.6893 | 6783812.0 |
| 2009-03-30 10:40:00 | AAPL | Stock | 3.6889 | 3.69 | 3.67 | 3.6711 | 8430464.0 |
| 2009-03-30 10:45:00 | AAPL | Stock | 3.6711 | 3.6839 | 3.6646 | 3.6836 | 7472416.0 |
| 2009-03-30 10:50:00 | AAPL | Stock | 3.6839 | 3.6904 | 3.6793 | 3.6875 | 4710160.0 |
| 2009-03-30 10:55:00 | AAPL | Stock | 3.6871 | 3.6904 | 3.6789 | 3.6818 | 3943408.0 |
> showing 50 of 305,974 rows — these rows as CSV