PREVIEW / stock_5min / 2005-10-11
file: by_date/stock_5min/2005/2005-10-11.parquet size: 2.8 MB rows: 204,284 symbols: 2,089
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-11 07:30:00 | AAPL | Stock | 1.8093 | 1.8146 | 1.8093 | 1.8146 | 8400.0 |
| 2005-10-11 07:35:00 | AAPL | Stock | 1.8164 | 1.8179 | 1.8164 | 1.8179 | 8400.0 |
| 2005-10-11 08:00:00 | AAPL | Stock | 1.8214 | 1.8232 | 1.8111 | 1.8146 | 652568.0 |
| 2005-10-11 08:05:00 | AAPL | Stock | 1.8164 | 1.8179 | 1.8154 | 1.8179 | 109116.0 |
| 2005-10-11 08:10:00 | AAPL | Stock | 1.8207 | 1.8221 | 1.8196 | 1.8196 | 346584.0 |
| 2005-10-11 08:15:00 | AAPL | Stock | 1.8211 | 1.8214 | 1.8204 | 1.8211 | 187600.0 |
| 2005-10-11 08:20:00 | AAPL | Stock | 1.8211 | 1.8232 | 1.8207 | 1.8232 | 423920.0 |
| 2005-10-11 08:25:00 | AAPL | Stock | 1.8232 | 1.8246 | 1.8196 | 1.8211 | 412244.0 |
| 2005-10-11 08:30:00 | AAPL | Stock | 1.8214 | 1.8232 | 1.8207 | 1.8221 | 241920.0 |
| 2005-10-11 08:35:00 | AAPL | Stock | 1.8207 | 1.8221 | 1.8207 | 1.8218 | 108360.0 |
| 2005-10-11 08:40:00 | AAPL | Stock | 1.8221 | 1.8232 | 1.8214 | 1.8229 | 115920.0 |
| 2005-10-11 08:45:00 | AAPL | Stock | 1.8229 | 1.8232 | 1.8214 | 1.8229 | 174944.0 |
| 2005-10-11 08:50:00 | AAPL | Stock | 1.8229 | 1.825 | 1.8229 | 1.825 | 519848.0 |
| 2005-10-11 08:55:00 | AAPL | Stock | 1.825 | 1.825 | 1.8243 | 1.8243 | 216384.0 |
| 2005-10-11 09:00:00 | AAPL | Stock | 1.825 | 1.8296 | 1.8246 | 1.8293 | 481320.0 |
| 2005-10-11 09:05:00 | AAPL | Stock | 1.8286 | 1.8286 | 1.8271 | 1.8279 | 483420.0 |
| 2005-10-11 09:10:00 | AAPL | Stock | 1.8282 | 1.8307 | 1.8282 | 1.8304 | 719460.0 |
| 2005-10-11 09:15:00 | AAPL | Stock | 1.8311 | 1.8321 | 1.8244 | 1.8293 | 704984.0 |
| 2005-10-11 09:20:00 | AAPL | Stock | 1.8304 | 1.8318 | 1.8268 | 1.8268 | 413476.0 |
| 2005-10-11 09:25:00 | AAPL | Stock | 1.8239 | 1.8346 | 1.8221 | 1.8293 | 2521596.0 |
| 2005-10-11 09:30:00 | AAPL | Stock | 1.8296 | 1.8321 | 1.8161 | 1.8175 | 27575240.0 |
| 2005-10-11 09:35:00 | AAPL | Stock | 1.8171 | 1.8232 | 1.8143 | 1.8161 | 17820264.0 |
| 2005-10-11 09:40:00 | AAPL | Stock | 1.8161 | 1.8196 | 1.8154 | 1.8164 | 13056484.0 |
| 2005-10-11 09:45:00 | AAPL | Stock | 1.8161 | 1.8168 | 1.8064 | 1.8118 | 22271396.0 |
| 2005-10-11 09:50:00 | AAPL | Stock | 1.8125 | 1.8157 | 1.8 | 1.8064 | 22870680.0 |
| 2005-10-11 09:55:00 | AAPL | Stock | 1.8064 | 1.8111 | 1.8018 | 1.8096 | 17477404.0 |
| 2005-10-11 10:00:00 | AAPL | Stock | 1.8082 | 1.8093 | 1.8018 | 1.8064 | 15653204.0 |
| 2005-10-11 10:05:00 | AAPL | Stock | 1.8064 | 1.8129 | 1.8032 | 1.8089 | 9743608.0 |
| 2005-10-11 10:10:00 | AAPL | Stock | 1.8093 | 1.8171 | 1.8089 | 1.8118 | 11540508.0 |
| 2005-10-11 10:15:00 | AAPL | Stock | 1.8121 | 1.8179 | 1.8118 | 1.8161 | 8894284.0 |
| 2005-10-11 10:20:00 | AAPL | Stock | 1.8157 | 1.8189 | 1.8146 | 1.8182 | 9942324.0 |
| 2005-10-11 10:25:00 | AAPL | Stock | 1.8186 | 1.8286 | 1.8164 | 1.8279 | 19589892.0 |
| 2005-10-11 10:30:00 | AAPL | Stock | 1.8271 | 1.8357 | 1.8268 | 1.8279 | 18156964.0 |
| 2005-10-11 10:35:00 | AAPL | Stock | 1.8282 | 1.8289 | 1.8225 | 1.8268 | 10722068.0 |
| 2005-10-11 10:40:00 | AAPL | Stock | 1.8271 | 1.8311 | 1.8254 | 1.8311 | 11410196.0 |
| 2005-10-11 10:45:00 | AAPL | Stock | 1.8311 | 1.8414 | 1.8307 | 1.8414 | 18126808.0 |
| 2005-10-11 10:50:00 | AAPL | Stock | 1.8411 | 1.8411 | 1.8325 | 1.8343 | 14816200.0 |
| 2005-10-11 10:55:00 | AAPL | Stock | 1.8343 | 1.8436 | 1.8332 | 1.8404 | 18487840.0 |
| 2005-10-11 11:00:00 | AAPL | Stock | 1.8404 | 1.8443 | 1.8378 | 1.8407 | 8737120.0 |
| 2005-10-11 11:05:00 | AAPL | Stock | 1.8404 | 1.8446 | 1.8382 | 1.8414 | 8887648.0 |
| 2005-10-11 11:10:00 | AAPL | Stock | 1.8414 | 1.8432 | 1.8357 | 1.8357 | 8447684.0 |
| 2005-10-11 11:15:00 | AAPL | Stock | 1.8357 | 1.84 | 1.8343 | 1.8386 | 8986404.0 |
| 2005-10-11 11:20:00 | AAPL | Stock | 1.8386 | 1.8475 | 1.8368 | 1.8468 | 13168876.0 |
| 2005-10-11 11:25:00 | AAPL | Stock | 1.8471 | 1.8482 | 1.8429 | 1.8461 | 10727472.0 |
| 2005-10-11 11:30:00 | AAPL | Stock | 1.8454 | 1.8507 | 1.8454 | 1.8496 | 14460040.0 |
| 2005-10-11 11:35:00 | AAPL | Stock | 1.8496 | 1.8496 | 1.8429 | 1.8439 | 12723732.0 |
| 2005-10-11 11:40:00 | AAPL | Stock | 1.8439 | 1.85 | 1.8439 | 1.8475 | 5533024.0 |
| 2005-10-11 11:45:00 | AAPL | Stock | 1.8475 | 1.8525 | 1.8471 | 1.85 | 11670400.0 |
| 2005-10-11 11:50:00 | AAPL | Stock | 1.8493 | 1.8518 | 1.8464 | 1.8482 | 5940284.0 |
| 2005-10-11 11:55:00 | AAPL | Stock | 1.8482 | 1.8486 | 1.8393 | 1.8411 | 13003256.0 |
> showing 50 of 204,284 rows — these rows as CSV