PREVIEW / stock_5min / 2010-06-23
file: by_date/stock_5min/2010/2010-06-23.parquet size: 4.7 MB rows: 332,923 symbols: 3,437
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-23 04:15:00 | AAPL | Stock | 9.8393 | 9.8393 | 9.8393 | 9.8393 | 2800.0 |
| 2010-06-23 05:00:00 | AAPL | Stock | 9.8393 | 9.8393 | 9.8393 | 9.8393 | 21000.0 |
| 2010-06-23 05:20:00 | AAPL | Stock | 9.8571 | 9.8571 | 9.8571 | 9.8571 | 2800.0 |
| 2010-06-23 05:35:00 | AAPL | Stock | 9.8571 | 9.8571 | 9.8571 | 9.8571 | 2800.0 |
| 2010-06-23 05:50:00 | AAPL | Stock | 9.8911 | 9.8911 | 9.8911 | 9.8911 | 14000.0 |
| 2010-06-23 05:55:00 | AAPL | Stock | 9.8929 | 9.8929 | 9.8929 | 9.8929 | 16968.0 |
| 2010-06-23 06:15:00 | AAPL | Stock | 9.8929 | 9.8929 | 9.8929 | 9.8929 | 8400.0 |
| 2010-06-23 06:35:00 | AAPL | Stock | 9.8857 | 9.8929 | 9.8857 | 9.8929 | 14000.0 |
| 2010-06-23 07:00:00 | AAPL | Stock | 9.8575 | 9.8575 | 9.8271 | 9.8425 | 282436.0 |
| 2010-06-23 07:05:00 | AAPL | Stock | 9.8425 | 9.8429 | 9.8132 | 9.8132 | 149632.0 |
| 2010-06-23 07:10:00 | AAPL | Stock | 9.8143 | 9.825 | 9.8143 | 9.8214 | 94024.0 |
| 2010-06-23 07:15:00 | AAPL | Stock | 9.8218 | 9.8218 | 9.8 | 9.8125 | 119224.0 |
| 2010-06-23 07:20:00 | AAPL | Stock | 9.8193 | 9.8193 | 9.8132 | 9.8132 | 5600.0 |
| 2010-06-23 07:25:00 | AAPL | Stock | 9.8179 | 9.8304 | 9.8179 | 9.8304 | 233520.0 |
| 2010-06-23 07:30:00 | AAPL | Stock | 9.8243 | 9.8286 | 9.8129 | 9.8286 | 53200.0 |
| 2010-06-23 07:35:00 | AAPL | Stock | 9.8286 | 9.8354 | 9.8286 | 9.8354 | 128100.0 |
| 2010-06-23 07:40:00 | AAPL | Stock | 9.8296 | 9.8296 | 9.8214 | 9.8214 | 63000.0 |
| 2010-06-23 07:45:00 | AAPL | Stock | 9.835 | 9.8357 | 9.8257 | 9.8261 | 163800.0 |
| 2010-06-23 07:50:00 | AAPL | Stock | 9.8286 | 9.8296 | 9.8214 | 9.8214 | 60200.0 |
| 2010-06-23 07:55:00 | AAPL | Stock | 9.8282 | 9.8389 | 9.8282 | 9.8354 | 169820.0 |
| 2010-06-23 08:00:00 | AAPL | Stock | 9.8357 | 9.8429 | 9.8207 | 9.8207 | 1229172.0 |
| 2010-06-23 08:05:00 | AAPL | Stock | 9.8146 | 9.8329 | 9.8146 | 9.8282 | 353808.0 |
| 2010-06-23 08:10:00 | AAPL | Stock | 9.8282 | 9.8411 | 9.8282 | 9.8379 | 209468.0 |
| 2010-06-23 08:15:00 | AAPL | Stock | 9.8379 | 9.8482 | 9.8357 | 9.84 | 517412.0 |
| 2010-06-23 08:20:00 | AAPL | Stock | 9.8418 | 9.8429 | 9.8357 | 9.8371 | 275128.0 |
| 2010-06-23 08:25:00 | AAPL | Stock | 9.8393 | 9.8393 | 9.8268 | 9.8282 | 258132.0 |
| 2010-06-23 08:30:00 | AAPL | Stock | 9.8304 | 9.8321 | 9.825 | 9.83 | 373324.0 |
| 2010-06-23 08:35:00 | AAPL | Stock | 9.8293 | 9.8296 | 9.8221 | 9.8282 | 289436.0 |
| 2010-06-23 08:40:00 | AAPL | Stock | 9.8293 | 9.83 | 9.825 | 9.8293 | 292320.0 |
| 2010-06-23 08:45:00 | AAPL | Stock | 9.8293 | 9.8296 | 9.8254 | 9.8286 | 276052.0 |
| 2010-06-23 08:50:00 | AAPL | Stock | 9.8329 | 9.8411 | 9.8329 | 9.8371 | 431760.0 |
| 2010-06-23 08:55:00 | AAPL | Stock | 9.8357 | 9.8357 | 9.8261 | 9.8261 | 241976.0 |
| 2010-06-23 09:00:00 | AAPL | Stock | 9.8264 | 9.8307 | 9.825 | 9.8271 | 278768.0 |
| 2010-06-23 09:05:00 | AAPL | Stock | 9.8282 | 9.8282 | 9.8214 | 9.8232 | 387968.0 |
| 2010-06-23 09:10:00 | AAPL | Stock | 9.8227 | 9.8243 | 9.8118 | 9.8186 | 662480.0 |
| 2010-06-23 09:15:00 | AAPL | Stock | 9.8171 | 9.8171 | 9.8039 | 9.8043 | 480648.0 |
| 2010-06-23 09:20:00 | AAPL | Stock | 9.8068 | 9.8168 | 9.8068 | 9.815 | 426860.0 |
| 2010-06-23 09:25:00 | AAPL | Stock | 9.8146 | 9.8146 | 9.7975 | 9.805 | 478800.0 |
| 2010-06-23 09:30:00 | AAPL | Stock | 9.8064 | 9.8093 | 9.7054 | 9.714 | 26285504.0 |
| 2010-06-23 09:35:00 | AAPL | Stock | 9.7152 | 9.7286 | 9.6625 | 9.6864 | 30600836.0 |
| 2010-06-23 09:40:00 | AAPL | Stock | 9.6854 | 9.7411 | 9.6468 | 9.6541 | 24616256.0 |
| 2010-06-23 09:45:00 | AAPL | Stock | 9.6511 | 9.6714 | 9.6475 | 9.6482 | 19678792.0 |
| 2010-06-23 09:50:00 | AAPL | Stock | 9.648 | 9.6976 | 9.6336 | 9.6432 | 24383800.0 |
| 2010-06-23 09:55:00 | AAPL | Stock | 9.6414 | 9.6542 | 9.625 | 9.6474 | 18774364.0 |
| 2010-06-23 10:00:00 | AAPL | Stock | 9.6475 | 9.6475 | 9.5982 | 9.6091 | 29888292.0 |
| 2010-06-23 10:05:00 | AAPL | Stock | 9.6112 | 9.6143 | 9.5679 | 9.5804 | 30415896.0 |
| 2010-06-23 10:10:00 | AAPL | Stock | 9.5804 | 9.6268 | 9.5725 | 9.6179 | 19657988.0 |
| 2010-06-23 10:15:00 | AAPL | Stock | 9.6175 | 9.6201 | 9.6 | 9.6125 | 13462120.0 |
| 2010-06-23 10:20:00 | AAPL | Stock | 9.6121 | 9.6125 | 9.5882 | 9.5946 | 7712012.0 |
| 2010-06-23 10:25:00 | AAPL | Stock | 9.5964 | 9.5982 | 9.5754 | 9.58 | 8552040.0 |
> showing 50 of 332,923 rows — these rows as CSV