PREVIEW / stock_5min / 2008-10-03
file: by_date/stock_5min/2008/2008-10-03.parquet size: 4.5 MB rows: 318,374 symbols: 3,325
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-03 07:05:00 | AAPL | Stock | 3.6679 | 3.6679 | 3.6679 | 3.6679 | 8400.0 |
| 2008-10-03 07:10:00 | AAPL | Stock | 3.6643 | 3.6679 | 3.6607 | 3.6607 | 26040.0 |
| 2008-10-03 07:20:00 | AAPL | Stock | 3.6679 | 3.6679 | 3.6607 | 3.6607 | 11200.0 |
| 2008-10-03 07:25:00 | AAPL | Stock | 3.6679 | 3.6786 | 3.6679 | 3.6786 | 11312.0 |
| 2008-10-03 07:35:00 | AAPL | Stock | 3.6711 | 3.6711 | 3.6711 | 3.6711 | 14000.0 |
| 2008-10-03 07:55:00 | AAPL | Stock | 3.6293 | 3.6293 | 3.6293 | 3.6293 | 14000.0 |
| 2008-10-03 08:00:00 | AAPL | Stock | 3.6311 | 3.6611 | 3.6293 | 3.6429 | 368760.0 |
| 2008-10-03 08:05:00 | AAPL | Stock | 3.6464 | 3.6586 | 3.6425 | 3.6536 | 182420.0 |
| 2008-10-03 08:10:00 | AAPL | Stock | 3.6536 | 3.6586 | 3.6304 | 3.6343 | 287028.0 |
| 2008-10-03 08:15:00 | AAPL | Stock | 3.6311 | 3.6514 | 3.6311 | 3.6386 | 336056.0 |
| 2008-10-03 08:20:00 | AAPL | Stock | 3.6382 | 3.6429 | 3.6314 | 3.6411 | 300608.0 |
| 2008-10-03 08:25:00 | AAPL | Stock | 3.6393 | 3.6446 | 3.6314 | 3.6314 | 217224.0 |
| 2008-10-03 08:30:00 | AAPL | Stock | 3.6314 | 3.6704 | 3.6107 | 3.6589 | 1986488.0 |
| 2008-10-03 08:35:00 | AAPL | Stock | 3.6586 | 3.6818 | 3.6421 | 3.6696 | 1573628.0 |
| 2008-10-03 08:40:00 | AAPL | Stock | 3.6661 | 3.6707 | 3.6589 | 3.6668 | 469868.0 |
| 2008-10-03 08:45:00 | AAPL | Stock | 3.6682 | 3.6911 | 3.6679 | 3.6782 | 924280.0 |
| 2008-10-03 08:50:00 | AAPL | Stock | 3.6768 | 3.6839 | 3.6725 | 3.6811 | 538104.0 |
| 2008-10-03 08:55:00 | AAPL | Stock | 3.6807 | 3.6807 | 3.6554 | 3.6561 | 571480.0 |
| 2008-10-03 09:00:00 | AAPL | Stock | 3.6561 | 3.6607 | 3.6479 | 3.6607 | 1227268.0 |
| 2008-10-03 09:05:00 | AAPL | Stock | 3.66 | 3.6625 | 3.655 | 3.6611 | 295400.0 |
| 2008-10-03 09:10:00 | AAPL | Stock | 3.6596 | 3.6821 | 3.6561 | 3.6761 | 593768.0 |
| 2008-10-03 09:15:00 | AAPL | Stock | 3.675 | 3.6829 | 3.675 | 3.6757 | 640696.0 |
| 2008-10-03 09:20:00 | AAPL | Stock | 3.6779 | 3.6832 | 3.675 | 3.6818 | 303016.0 |
| 2008-10-03 09:25:00 | AAPL | Stock | 3.6804 | 3.74 | 3.6804 | 3.7129 | 4795420.0 |
| 2008-10-03 09:30:00 | AAPL | Stock | 3.7136 | 3.75 | 3.7096 | 3.7214 | 42454972.0 |
| 2008-10-03 09:35:00 | AAPL | Stock | 3.7214 | 3.7679 | 3.7202 | 3.7668 | 36814148.0 |
| 2008-10-03 09:40:00 | AAPL | Stock | 3.7668 | 3.8036 | 3.6936 | 3.7157 | 92893780.0 |
| 2008-10-03 09:45:00 | AAPL | Stock | 3.7161 | 3.7207 | 3.3804 | 3.5693 | 176773856.0 |
| 2008-10-03 09:50:00 | AAPL | Stock | 3.5682 | 3.6861 | 3.3979 | 3.6746 | 201608596.0 |
| 2008-10-03 09:55:00 | AAPL | Stock | 3.6721 | 3.71 | 3.6393 | 3.6436 | 84282548.0 |
| 2008-10-03 10:00:00 | AAPL | Stock | 3.6432 | 3.6957 | 3.6421 | 3.6711 | 45897180.0 |
| 2008-10-03 10:05:00 | AAPL | Stock | 3.6725 | 3.6932 | 3.6443 | 3.6761 | 42536676.0 |
| 2008-10-03 10:10:00 | AAPL | Stock | 3.6754 | 3.6754 | 3.6071 | 3.6664 | 47547472.0 |
| 2008-10-03 10:15:00 | AAPL | Stock | 3.6664 | 3.6839 | 3.6536 | 3.6714 | 22931888.0 |
| 2008-10-03 10:20:00 | AAPL | Stock | 3.6721 | 3.7143 | 3.6657 | 3.6946 | 29420132.0 |
| 2008-10-03 10:25:00 | AAPL | Stock | 3.695 | 3.7143 | 3.6904 | 3.6983 | 21459480.0 |
| 2008-10-03 10:30:00 | AAPL | Stock | 3.7021 | 3.7496 | 3.7014 | 3.7464 | 25802896.0 |
| 2008-10-03 10:35:00 | AAPL | Stock | 3.7457 | 3.7496 | 3.7161 | 3.7261 | 24398024.0 |
| 2008-10-03 10:40:00 | AAPL | Stock | 3.7264 | 3.7339 | 3.6964 | 3.7057 | 20126176.0 |
| 2008-10-03 10:45:00 | AAPL | Stock | 3.7068 | 3.7207 | 3.7018 | 3.7107 | 9335116.0 |
| 2008-10-03 10:50:00 | AAPL | Stock | 3.7107 | 3.75 | 3.7089 | 3.7489 | 16210740.0 |
| 2008-10-03 10:55:00 | AAPL | Stock | 3.7489 | 3.7496 | 3.7182 | 3.7261 | 13928796.0 |
| 2008-10-03 11:00:00 | AAPL | Stock | 3.7271 | 3.7464 | 3.7157 | 3.7297 | 15043392.0 |
| 2008-10-03 11:05:00 | AAPL | Stock | 3.7296 | 3.7396 | 3.7286 | 3.7379 | 12168296.0 |
| 2008-10-03 11:10:00 | AAPL | Stock | 3.7371 | 3.7382 | 3.7232 | 3.7304 | 8223432.0 |
| 2008-10-03 11:15:00 | AAPL | Stock | 3.7311 | 3.745 | 3.6979 | 3.6982 | 13921544.0 |
| 2008-10-03 11:20:00 | AAPL | Stock | 3.6975 | 3.7204 | 3.6968 | 3.7064 | 13048084.0 |
| 2008-10-03 11:25:00 | AAPL | Stock | 3.7082 | 3.7175 | 3.6986 | 3.7021 | 10202668.0 |
| 2008-10-03 11:30:00 | AAPL | Stock | 3.7021 | 3.7239 | 3.6964 | 3.7232 | 10301704.0 |
| 2008-10-03 11:35:00 | AAPL | Stock | 3.7239 | 3.7371 | 3.7221 | 3.7332 | 12933284.0 |
> showing 50 of 318,374 rows — these rows as CSV