PREVIEW / stock_5min / 2005-09-14
file: by_date/stock_5min/2005/2005-09-14.parquet size: 2.7 MB rows: 201,122 symbols: 2,063
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-14 08:00:00 | AAPL | Stock | 1.8107 | 1.8107 | 1.8107 | 1.8107 | 8400.0 |
| 2005-09-14 08:20:00 | AAPL | Stock | 1.82 | 1.8204 | 1.82 | 1.8204 | 139860.0 |
| 2005-09-14 08:40:00 | AAPL | Stock | 1.8196 | 1.8196 | 1.8196 | 1.8196 | 8400.0 |
| 2005-09-14 08:45:00 | AAPL | Stock | 1.8196 | 1.82 | 1.8196 | 1.82 | 140000.0 |
| 2005-09-14 08:50:00 | AAPL | Stock | 1.8179 | 1.835 | 1.8179 | 1.825 | 1173340.0 |
| 2005-09-14 08:55:00 | AAPL | Stock | 1.825 | 1.8286 | 1.825 | 1.825 | 134400.0 |
| 2005-09-14 09:00:00 | AAPL | Stock | 1.8254 | 1.8286 | 1.8254 | 1.8257 | 280560.0 |
| 2005-09-14 09:05:00 | AAPL | Stock | 1.8264 | 1.8271 | 1.8204 | 1.8261 | 355040.0 |
| 2005-09-14 09:10:00 | AAPL | Stock | 1.8261 | 1.8268 | 1.8261 | 1.8261 | 64400.0 |
| 2005-09-14 09:15:00 | AAPL | Stock | 1.825 | 1.825 | 1.8243 | 1.825 | 42700.0 |
| 2005-09-14 09:20:00 | AAPL | Stock | 1.8243 | 1.8271 | 1.8243 | 1.8268 | 57960.0 |
| 2005-09-14 09:25:00 | AAPL | Stock | 1.8271 | 1.8286 | 1.8246 | 1.8279 | 1208480.0 |
| 2005-09-14 09:30:00 | AAPL | Stock | 1.8236 | 1.8282 | 1.8196 | 1.8257 | 12444012.0 |
| 2005-09-14 09:35:00 | AAPL | Stock | 1.8254 | 1.8257 | 1.8168 | 1.8193 | 10346392.0 |
| 2005-09-14 09:40:00 | AAPL | Stock | 1.8189 | 1.8232 | 1.8182 | 1.8211 | 7516628.0 |
| 2005-09-14 09:45:00 | AAPL | Stock | 1.8211 | 1.8214 | 1.8157 | 1.82 | 8136156.0 |
| 2005-09-14 09:50:00 | AAPL | Stock | 1.8196 | 1.8218 | 1.8146 | 1.8154 | 6858740.0 |
| 2005-09-14 09:55:00 | AAPL | Stock | 1.815 | 1.8154 | 1.8089 | 1.8104 | 10306464.0 |
| 2005-09-14 10:00:00 | AAPL | Stock | 1.8107 | 1.8218 | 1.8093 | 1.8211 | 9188900.0 |
| 2005-09-14 10:05:00 | AAPL | Stock | 1.8214 | 1.8229 | 1.8161 | 1.8189 | 8731268.0 |
| 2005-09-14 10:10:00 | AAPL | Stock | 1.8189 | 1.8204 | 1.8189 | 1.8196 | 2730980.0 |
| 2005-09-14 10:15:00 | AAPL | Stock | 1.8196 | 1.82 | 1.8164 | 1.8186 | 3703952.0 |
| 2005-09-14 10:20:00 | AAPL | Stock | 1.8186 | 1.8193 | 1.8168 | 1.8175 | 2258480.0 |
| 2005-09-14 10:25:00 | AAPL | Stock | 1.8171 | 1.8179 | 1.8139 | 1.815 | 6863892.0 |
| 2005-09-14 10:30:00 | AAPL | Stock | 1.8154 | 1.8189 | 1.8121 | 1.8171 | 12186916.0 |
| 2005-09-14 10:35:00 | AAPL | Stock | 1.8168 | 1.8193 | 1.8154 | 1.8161 | 4400368.0 |
| 2005-09-14 10:40:00 | AAPL | Stock | 1.8161 | 1.8211 | 1.8161 | 1.8189 | 5226368.0 |
| 2005-09-14 10:45:00 | AAPL | Stock | 1.8189 | 1.8196 | 1.8168 | 1.8196 | 3397352.0 |
| 2005-09-14 10:50:00 | AAPL | Stock | 1.82 | 1.825 | 1.82 | 1.8239 | 7611408.0 |
| 2005-09-14 10:55:00 | AAPL | Stock | 1.8236 | 1.8243 | 1.8189 | 1.82 | 3998764.0 |
| 2005-09-14 11:00:00 | AAPL | Stock | 1.8204 | 1.8214 | 1.8182 | 1.8196 | 3433640.0 |
| 2005-09-14 11:05:00 | AAPL | Stock | 1.8196 | 1.8243 | 1.8193 | 1.8229 | 3668280.0 |
| 2005-09-14 11:10:00 | AAPL | Stock | 1.8232 | 1.8232 | 1.8186 | 1.8189 | 2312184.0 |
| 2005-09-14 11:15:00 | AAPL | Stock | 1.8193 | 1.82 | 1.8164 | 1.8179 | 4440240.0 |
| 2005-09-14 11:20:00 | AAPL | Stock | 1.8175 | 1.8189 | 1.8168 | 1.8179 | 2667644.0 |
| 2005-09-14 11:25:00 | AAPL | Stock | 1.8182 | 1.8182 | 1.8171 | 1.8179 | 1966552.0 |
| 2005-09-14 11:30:00 | AAPL | Stock | 1.8179 | 1.8193 | 1.8175 | 1.8189 | 2046576.0 |
| 2005-09-14 11:35:00 | AAPL | Stock | 1.8186 | 1.8229 | 1.8175 | 1.8211 | 3681468.0 |
| 2005-09-14 11:40:00 | AAPL | Stock | 1.8211 | 1.8214 | 1.8175 | 1.8175 | 2343264.0 |
| 2005-09-14 11:45:00 | AAPL | Stock | 1.8175 | 1.8204 | 1.8171 | 1.8204 | 3056228.0 |
| 2005-09-14 11:50:00 | AAPL | Stock | 1.82 | 1.8204 | 1.8168 | 1.8175 | 1769124.0 |
| 2005-09-14 11:55:00 | AAPL | Stock | 1.8179 | 1.8179 | 1.8161 | 1.8161 | 2753940.0 |
| 2005-09-14 12:00:00 | AAPL | Stock | 1.8157 | 1.8161 | 1.8143 | 1.8146 | 2571856.0 |
| 2005-09-14 12:05:00 | AAPL | Stock | 1.8143 | 1.8157 | 1.8136 | 1.8136 | 3129112.0 |
| 2005-09-14 12:10:00 | AAPL | Stock | 1.8136 | 1.8161 | 1.8136 | 1.815 | 2459940.0 |
| 2005-09-14 12:15:00 | AAPL | Stock | 1.815 | 1.8161 | 1.8136 | 1.8139 | 1868580.0 |
| 2005-09-14 12:20:00 | AAPL | Stock | 1.8139 | 1.8146 | 1.8111 | 1.8114 | 3324384.0 |
| 2005-09-14 12:25:00 | AAPL | Stock | 1.8118 | 1.8118 | 1.8089 | 1.8089 | 3929856.0 |
| 2005-09-14 12:30:00 | AAPL | Stock | 1.8093 | 1.8093 | 1.8071 | 1.8082 | 4736284.0 |
| 2005-09-14 12:35:00 | AAPL | Stock | 1.8082 | 1.8086 | 1.805 | 1.8054 | 4399696.0 |
> showing 50 of 201,122 rows — these rows as CSV