PREVIEW / stock_5min / 2005-09-12
file: by_date/stock_5min/2005/2005-09-12.parquet size: 2.7 MB rows: 202,602 symbols: 2,070
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-12 08:00:00 | AAPL | Stock | 1.8339 | 1.8339 | 1.8325 | 1.8325 | 30800.0 |
| 2005-09-12 08:05:00 | AAPL | Stock | 1.8325 | 1.8325 | 1.8325 | 1.8325 | 26460.0 |
| 2005-09-12 08:10:00 | AAPL | Stock | 1.8321 | 1.8321 | 1.8286 | 1.8286 | 146272.0 |
| 2005-09-12 08:15:00 | AAPL | Stock | 1.8286 | 1.8311 | 1.8286 | 1.8286 | 44240.0 |
| 2005-09-12 08:20:00 | AAPL | Stock | 1.8268 | 1.8268 | 1.8257 | 1.8257 | 15400.0 |
| 2005-09-12 08:25:00 | AAPL | Stock | 1.8261 | 1.8286 | 1.8261 | 1.8286 | 9800.0 |
| 2005-09-12 08:30:00 | AAPL | Stock | 1.825 | 1.8286 | 1.825 | 1.8286 | 35000.0 |
| 2005-09-12 08:35:00 | AAPL | Stock | 1.8293 | 1.8293 | 1.8221 | 1.8221 | 196560.0 |
| 2005-09-12 08:40:00 | AAPL | Stock | 1.825 | 1.8286 | 1.825 | 1.8286 | 672000.0 |
| 2005-09-12 08:45:00 | AAPL | Stock | 1.8318 | 1.8318 | 1.825 | 1.825 | 49000.0 |
| 2005-09-12 08:50:00 | AAPL | Stock | 1.8254 | 1.8271 | 1.8236 | 1.8268 | 84560.0 |
| 2005-09-12 08:55:00 | AAPL | Stock | 1.8271 | 1.8293 | 1.8271 | 1.8293 | 8120.0 |
| 2005-09-12 09:00:00 | AAPL | Stock | 1.8296 | 1.8296 | 1.8286 | 1.8286 | 54600.0 |
| 2005-09-12 09:05:00 | AAPL | Stock | 1.8286 | 1.8286 | 1.8282 | 1.8282 | 764400.0 |
| 2005-09-12 09:10:00 | AAPL | Stock | 1.8279 | 1.8293 | 1.8279 | 1.8293 | 222768.0 |
| 2005-09-12 09:15:00 | AAPL | Stock | 1.8279 | 1.8293 | 1.8279 | 1.8279 | 865200.0 |
| 2005-09-12 09:20:00 | AAPL | Stock | 1.8293 | 1.8293 | 1.8264 | 1.8268 | 202440.0 |
| 2005-09-12 09:25:00 | AAPL | Stock | 1.8268 | 1.8286 | 1.8232 | 1.8232 | 1086232.0 |
| 2005-09-12 09:30:00 | AAPL | Stock | 1.825 | 1.8375 | 1.8229 | 1.83 | 26107088.0 |
| 2005-09-12 09:35:00 | AAPL | Stock | 1.8304 | 1.8311 | 1.8179 | 1.8236 | 18894736.0 |
| 2005-09-12 09:40:00 | AAPL | Stock | 1.8236 | 1.8329 | 1.8232 | 1.8282 | 15907612.0 |
| 2005-09-12 09:45:00 | AAPL | Stock | 1.8279 | 1.8286 | 1.8236 | 1.8254 | 14310324.0 |
| 2005-09-12 09:50:00 | AAPL | Stock | 1.825 | 1.8254 | 1.8189 | 1.82 | 11970308.0 |
| 2005-09-12 09:55:00 | AAPL | Stock | 1.82 | 1.8225 | 1.8161 | 1.8225 | 11942000.0 |
| 2005-09-12 10:00:00 | AAPL | Stock | 1.8225 | 1.8261 | 1.8218 | 1.8232 | 9136848.0 |
| 2005-09-12 10:05:00 | AAPL | Stock | 1.8232 | 1.8243 | 1.8196 | 1.8243 | 8677368.0 |
| 2005-09-12 10:10:00 | AAPL | Stock | 1.8239 | 1.8254 | 1.8214 | 1.8214 | 4406220.0 |
| 2005-09-12 10:15:00 | AAPL | Stock | 1.8214 | 1.8261 | 1.8175 | 1.8261 | 10037468.0 |
| 2005-09-12 10:20:00 | AAPL | Stock | 1.8261 | 1.8314 | 1.825 | 1.8275 | 10072104.0 |
| 2005-09-12 10:25:00 | AAPL | Stock | 1.8279 | 1.8293 | 1.8268 | 1.8279 | 3803296.0 |
| 2005-09-12 10:30:00 | AAPL | Stock | 1.8275 | 1.8279 | 1.8243 | 1.8254 | 3276784.0 |
| 2005-09-12 10:35:00 | AAPL | Stock | 1.8254 | 1.8264 | 1.8214 | 1.8246 | 4773748.0 |
| 2005-09-12 10:40:00 | AAPL | Stock | 1.825 | 1.8296 | 1.8239 | 1.8289 | 4267060.0 |
| 2005-09-12 10:45:00 | AAPL | Stock | 1.8286 | 1.8307 | 1.8239 | 1.8239 | 6247164.0 |
| 2005-09-12 10:50:00 | AAPL | Stock | 1.8239 | 1.8246 | 1.8207 | 1.8218 | 5155892.0 |
| 2005-09-12 10:55:00 | AAPL | Stock | 1.8214 | 1.8243 | 1.8193 | 1.8207 | 6872684.0 |
| 2005-09-12 11:00:00 | AAPL | Stock | 1.8211 | 1.8214 | 1.8207 | 1.8211 | 1699796.0 |
| 2005-09-12 11:05:00 | AAPL | Stock | 1.8207 | 1.8211 | 1.8164 | 1.8179 | 6879684.0 |
| 2005-09-12 11:10:00 | AAPL | Stock | 1.8179 | 1.8179 | 1.8129 | 1.815 | 7959952.0 |
| 2005-09-12 11:15:00 | AAPL | Stock | 1.815 | 1.8154 | 1.8111 | 1.8111 | 5912284.0 |
| 2005-09-12 11:20:00 | AAPL | Stock | 1.8111 | 1.8154 | 1.8111 | 1.8146 | 4101496.0 |
| 2005-09-12 11:25:00 | AAPL | Stock | 1.8143 | 1.8193 | 1.8143 | 1.8193 | 9396100.0 |
| 2005-09-12 11:30:00 | AAPL | Stock | 1.8193 | 1.82 | 1.8168 | 1.8171 | 3318140.0 |
| 2005-09-12 11:35:00 | AAPL | Stock | 1.8171 | 1.8182 | 1.8157 | 1.8168 | 2494856.0 |
| 2005-09-12 11:40:00 | AAPL | Stock | 1.8169 | 1.8179 | 1.8118 | 1.8125 | 5407528.0 |
| 2005-09-12 11:45:00 | AAPL | Stock | 1.8125 | 1.8132 | 1.8064 | 1.8075 | 8478260.0 |
| 2005-09-12 11:50:00 | AAPL | Stock | 1.8075 | 1.8107 | 1.8068 | 1.8104 | 4782568.0 |
| 2005-09-12 11:55:00 | AAPL | Stock | 1.8104 | 1.8193 | 1.8093 | 1.8154 | 9914044.0 |
| 2005-09-12 12:00:00 | AAPL | Stock | 1.8157 | 1.8186 | 1.8143 | 1.8182 | 1990212.0 |
| 2005-09-12 12:05:00 | AAPL | Stock | 1.8186 | 1.8211 | 1.8179 | 1.8189 | 3091256.0 |
> showing 50 of 202,602 rows — these rows as CSV