PREVIEW / stock_5min / 2008-10-31
file: by_date/stock_5min/2008/2008-10-31.parquet size: 4.6 MB rows: 326,802 symbols: 3,358
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-31 04:15:00 | AAPL | Stock | 3.9386 | 3.9386 | 3.9121 | 3.9121 | 8400.0 |
| 2008-10-31 04:35:00 | AAPL | Stock | 3.8596 | 3.8596 | 3.8596 | 3.8596 | 2800.0 |
| 2008-10-31 04:40:00 | AAPL | Stock | 3.9196 | 3.9196 | 3.9196 | 3.9196 | 55160.0 |
| 2008-10-31 06:55:00 | AAPL | Stock | 3.8929 | 3.8929 | 3.8929 | 3.8929 | 28000.0 |
| 2008-10-31 07:30:00 | AAPL | Stock | 3.9532 | 3.9532 | 3.9532 | 3.9532 | 2800.0 |
| 2008-10-31 07:35:00 | AAPL | Stock | 3.9246 | 3.9246 | 3.9179 | 3.9179 | 11200.0 |
| 2008-10-31 07:40:00 | AAPL | Stock | 3.9239 | 3.9246 | 3.9196 | 3.9196 | 39620.0 |
| 2008-10-31 07:45:00 | AAPL | Stock | 3.9246 | 3.9246 | 3.9107 | 3.9143 | 42000.0 |
| 2008-10-31 07:50:00 | AAPL | Stock | 3.9196 | 3.9246 | 3.9179 | 3.9179 | 11200.0 |
| 2008-10-31 08:00:00 | AAPL | Stock | 3.9243 | 3.9354 | 3.9107 | 3.9107 | 197120.0 |
| 2008-10-31 08:05:00 | AAPL | Stock | 3.9107 | 3.9143 | 3.8989 | 3.9043 | 215292.0 |
| 2008-10-31 08:10:00 | AAPL | Stock | 3.8982 | 3.9143 | 3.8968 | 3.8982 | 618632.0 |
| 2008-10-31 08:15:00 | AAPL | Stock | 3.9018 | 3.9129 | 3.9018 | 3.9129 | 203672.0 |
| 2008-10-31 08:20:00 | AAPL | Stock | 3.9125 | 3.9186 | 3.9036 | 3.9107 | 233660.0 |
| 2008-10-31 08:25:00 | AAPL | Stock | 3.9107 | 3.9246 | 3.9104 | 3.9232 | 314132.0 |
| 2008-10-31 08:30:00 | AAPL | Stock | 3.9186 | 3.9286 | 3.9182 | 3.925 | 221060.0 |
| 2008-10-31 08:35:00 | AAPL | Stock | 3.9286 | 3.9318 | 3.9182 | 3.9207 | 364168.0 |
| 2008-10-31 08:40:00 | AAPL | Stock | 3.9182 | 3.9243 | 3.9179 | 3.9207 | 233884.0 |
| 2008-10-31 08:45:00 | AAPL | Stock | 3.9236 | 3.9261 | 3.9211 | 3.9218 | 80220.0 |
| 2008-10-31 08:50:00 | AAPL | Stock | 3.9196 | 3.9282 | 3.9154 | 3.9239 | 746256.0 |
| 2008-10-31 08:55:00 | AAPL | Stock | 3.9264 | 3.9396 | 3.9207 | 3.9286 | 966252.0 |
| 2008-10-31 09:00:00 | AAPL | Stock | 3.9339 | 3.9375 | 3.9161 | 3.9179 | 916300.0 |
| 2008-10-31 09:05:00 | AAPL | Stock | 3.9175 | 3.9196 | 3.8964 | 3.9107 | 2600976.0 |
| 2008-10-31 09:10:00 | AAPL | Stock | 3.9057 | 3.9107 | 3.8936 | 3.8939 | 2871204.0 |
| 2008-10-31 09:15:00 | AAPL | Stock | 3.8946 | 3.895 | 3.8511 | 3.8511 | 3092992.0 |
| 2008-10-31 09:20:00 | AAPL | Stock | 3.8504 | 3.8518 | 3.8179 | 3.8321 | 4169760.0 |
| 2008-10-31 09:25:00 | AAPL | Stock | 3.8293 | 3.8393 | 3.8079 | 3.8368 | 5019056.0 |
| 2008-10-31 09:30:00 | AAPL | Stock | 3.8318 | 3.8464 | 3.7871 | 3.7975 | 52299408.0 |
| 2008-10-31 09:35:00 | AAPL | Stock | 3.7979 | 3.8186 | 3.7779 | 3.8118 | 44556204.0 |
| 2008-10-31 09:40:00 | AAPL | Stock | 3.8111 | 3.8129 | 3.7682 | 3.7686 | 44975420.0 |
| 2008-10-31 09:45:00 | AAPL | Stock | 3.7689 | 3.7975 | 3.755 | 3.7757 | 34106604.0 |
| 2008-10-31 09:50:00 | AAPL | Stock | 3.7757 | 3.795 | 3.762 | 3.7825 | 29254456.0 |
| 2008-10-31 09:55:00 | AAPL | Stock | 3.7818 | 3.7943 | 3.7561 | 3.7882 | 32260284.0 |
| 2008-10-31 10:00:00 | AAPL | Stock | 3.7875 | 3.8096 | 3.7679 | 3.8071 | 36583708.0 |
| 2008-10-31 10:05:00 | AAPL | Stock | 3.8068 | 3.8393 | 3.7929 | 3.8389 | 36179808.0 |
| 2008-10-31 10:10:00 | AAPL | Stock | 3.8389 | 3.8571 | 3.8275 | 3.8443 | 35648424.0 |
| 2008-10-31 10:15:00 | AAPL | Stock | 3.8443 | 3.8511 | 3.8261 | 3.8282 | 26509532.0 |
| 2008-10-31 10:20:00 | AAPL | Stock | 3.8289 | 3.8389 | 3.815 | 3.8225 | 20384168.0 |
| 2008-10-31 10:25:00 | AAPL | Stock | 3.8229 | 3.8275 | 3.8107 | 3.8189 | 20187720.0 |
| 2008-10-31 10:30:00 | AAPL | Stock | 3.8193 | 3.8393 | 3.8175 | 3.8239 | 22523508.0 |
| 2008-10-31 10:35:00 | AAPL | Stock | 3.8239 | 3.8268 | 3.8125 | 3.8175 | 16338504.0 |
| 2008-10-31 10:40:00 | AAPL | Stock | 3.8179 | 3.8214 | 3.8036 | 3.8175 | 14674856.0 |
| 2008-10-31 10:45:00 | AAPL | Stock | 3.8172 | 3.825 | 3.8039 | 3.8225 | 12476128.0 |
| 2008-10-31 10:50:00 | AAPL | Stock | 3.8218 | 3.8218 | 3.8071 | 3.8114 | 14012124.0 |
| 2008-10-31 10:55:00 | AAPL | Stock | 3.8111 | 3.8179 | 3.7979 | 3.8175 | 16597784.0 |
| 2008-10-31 11:00:00 | AAPL | Stock | 3.8175 | 3.8354 | 3.8118 | 3.8282 | 17388532.0 |
| 2008-10-31 11:05:00 | AAPL | Stock | 3.8289 | 3.8307 | 3.8104 | 3.82 | 14562156.0 |
| 2008-10-31 11:10:00 | AAPL | Stock | 3.8204 | 3.8293 | 3.7979 | 3.8093 | 14579152.0 |
| 2008-10-31 11:15:00 | AAPL | Stock | 3.8093 | 3.8564 | 3.8089 | 3.8539 | 29596448.0 |
| 2008-10-31 11:20:00 | AAPL | Stock | 3.8539 | 3.8607 | 3.8446 | 3.8473 | 26875828.0 |
> showing 50 of 326,802 rows — these rows as CSV