PREVIEW / stock_5min / 2005-10-10
file: by_date/stock_5min/2005/2005-10-10.parquet size: 2.7 MB rows: 197,874 symbols: 2,073
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-10-10 07:05:00 | AAPL | Stock | 1.8464 | 1.8464 | 1.8464 | 1.8464 | 2800.0 |
| 2005-10-10 07:20:00 | AAPL | Stock | 1.8411 | 1.8411 | 1.8411 | 1.8411 | 25200.0 |
| 2005-10-10 08:00:00 | AAPL | Stock | 1.8429 | 1.8568 | 1.8429 | 1.8493 | 197596.0 |
| 2005-10-10 08:05:00 | AAPL | Stock | 1.85 | 1.8536 | 1.8482 | 1.8536 | 288400.0 |
| 2005-10-10 08:10:00 | AAPL | Stock | 1.8539 | 1.8539 | 1.85 | 1.85 | 176036.0 |
| 2005-10-10 08:15:00 | AAPL | Stock | 1.8536 | 1.8536 | 1.8482 | 1.8482 | 39900.0 |
| 2005-10-10 08:20:00 | AAPL | Stock | 1.8464 | 1.85 | 1.8464 | 1.85 | 47712.0 |
| 2005-10-10 08:25:00 | AAPL | Stock | 1.85 | 1.85 | 1.8482 | 1.85 | 72520.0 |
| 2005-10-10 08:35:00 | AAPL | Stock | 1.8507 | 1.8521 | 1.85 | 1.8521 | 36680.0 |
| 2005-10-10 08:40:00 | AAPL | Stock | 1.8504 | 1.8536 | 1.8482 | 1.8521 | 79548.0 |
| 2005-10-10 08:45:00 | AAPL | Stock | 1.85 | 1.8518 | 1.8489 | 1.8518 | 48440.0 |
| 2005-10-10 08:50:00 | AAPL | Stock | 1.8507 | 1.8507 | 1.8464 | 1.8468 | 105280.0 |
| 2005-10-10 08:55:00 | AAPL | Stock | 1.8464 | 1.8471 | 1.8464 | 1.8471 | 19600.0 |
| 2005-10-10 09:00:00 | AAPL | Stock | 1.8475 | 1.8475 | 1.8464 | 1.8464 | 30968.0 |
| 2005-10-10 09:05:00 | AAPL | Stock | 1.8475 | 1.8475 | 1.8454 | 1.8454 | 65520.0 |
| 2005-10-10 09:10:00 | AAPL | Stock | 1.8454 | 1.8464 | 1.845 | 1.8464 | 29400.0 |
| 2005-10-10 09:15:00 | AAPL | Stock | 1.8464 | 1.8471 | 1.8457 | 1.8461 | 95200.0 |
| 2005-10-10 09:20:00 | AAPL | Stock | 1.8464 | 1.8464 | 1.8457 | 1.8464 | 137872.0 |
| 2005-10-10 09:25:00 | AAPL | Stock | 1.845 | 1.8593 | 1.845 | 1.8529 | 1781864.0 |
| 2005-10-10 09:30:00 | AAPL | Stock | 1.8486 | 1.8539 | 1.8429 | 1.8439 | 15439368.0 |
| 2005-10-10 09:35:00 | AAPL | Stock | 1.8432 | 1.8461 | 1.8389 | 1.8439 | 11301360.0 |
| 2005-10-10 09:40:00 | AAPL | Stock | 1.8439 | 1.8454 | 1.8364 | 1.8382 | 9021852.0 |
| 2005-10-10 09:45:00 | AAPL | Stock | 1.8382 | 1.8446 | 1.8332 | 1.835 | 16159920.0 |
| 2005-10-10 09:50:00 | AAPL | Stock | 1.8346 | 1.8357 | 1.8171 | 1.8175 | 15995448.0 |
| 2005-10-10 09:55:00 | AAPL | Stock | 1.8175 | 1.8229 | 1.81 | 1.8171 | 19939640.0 |
| 2005-10-10 10:00:00 | AAPL | Stock | 1.8168 | 1.8214 | 1.8139 | 1.8157 | 14659344.0 |
| 2005-10-10 10:05:00 | AAPL | Stock | 1.8157 | 1.8243 | 1.8157 | 1.8221 | 9859976.0 |
| 2005-10-10 10:10:00 | AAPL | Stock | 1.8225 | 1.8346 | 1.8143 | 1.815 | 8415232.0 |
| 2005-10-10 10:15:00 | AAPL | Stock | 1.815 | 1.8196 | 1.8132 | 1.8193 | 5440400.0 |
| 2005-10-10 10:20:00 | AAPL | Stock | 1.8189 | 1.8229 | 1.8171 | 1.8207 | 8017688.0 |
| 2005-10-10 10:25:00 | AAPL | Stock | 1.8211 | 1.8214 | 1.815 | 1.8189 | 4679164.0 |
| 2005-10-10 10:30:00 | AAPL | Stock | 1.8186 | 1.8207 | 1.8175 | 1.8186 | 2238236.0 |
| 2005-10-10 10:35:00 | AAPL | Stock | 1.8189 | 1.8205 | 1.8157 | 1.8175 | 4050256.0 |
| 2005-10-10 10:40:00 | AAPL | Stock | 1.8175 | 1.8193 | 1.815 | 1.8189 | 3194184.0 |
| 2005-10-10 10:45:00 | AAPL | Stock | 1.8193 | 1.8214 | 1.8175 | 1.8193 | 4005372.0 |
| 2005-10-10 10:50:00 | AAPL | Stock | 1.8193 | 1.8239 | 1.8189 | 1.8218 | 3805452.0 |
| 2005-10-10 10:55:00 | AAPL | Stock | 1.8218 | 1.8264 | 1.82 | 1.8225 | 6392708.0 |
| 2005-10-10 11:00:00 | AAPL | Stock | 1.8225 | 1.8286 | 1.8204 | 1.8279 | 6718908.0 |
| 2005-10-10 11:05:00 | AAPL | Stock | 1.8279 | 1.8321 | 1.8232 | 1.8304 | 7915740.0 |
| 2005-10-10 11:10:00 | AAPL | Stock | 1.8307 | 1.8321 | 1.8275 | 1.8293 | 4974312.0 |
| 2005-10-10 11:15:00 | AAPL | Stock | 1.8293 | 1.8293 | 1.8218 | 1.8225 | 4941804.0 |
| 2005-10-10 11:20:00 | AAPL | Stock | 1.8229 | 1.8282 | 1.8218 | 1.8264 | 5263860.0 |
| 2005-10-10 11:25:00 | AAPL | Stock | 1.8264 | 1.83 | 1.8246 | 1.8279 | 4080552.0 |
| 2005-10-10 11:30:00 | AAPL | Stock | 1.8279 | 1.8321 | 1.8268 | 1.8286 | 6076672.0 |
| 2005-10-10 11:35:00 | AAPL | Stock | 1.8286 | 1.83 | 1.8268 | 1.8268 | 3846192.0 |
| 2005-10-10 11:40:00 | AAPL | Stock | 1.8271 | 1.8304 | 1.8268 | 1.8296 | 2854908.0 |
| 2005-10-10 11:45:00 | AAPL | Stock | 1.8293 | 1.8293 | 1.8218 | 1.8236 | 6262984.0 |
| 2005-10-10 11:50:00 | AAPL | Stock | 1.8236 | 1.8254 | 1.8221 | 1.8239 | 2884868.0 |
| 2005-10-10 11:55:00 | AAPL | Stock | 1.8243 | 1.825 | 1.8225 | 1.8229 | 3522428.0 |
| 2005-10-10 12:00:00 | AAPL | Stock | 1.8225 | 1.8261 | 1.8221 | 1.825 | 3836560.0 |
> showing 50 of 197,874 rows — these rows as CSV