PREVIEW / stock_5min / 2007-08-02
file: by_date/stock_5min/2007/2007-08-02.parquet size: 4.3 MB rows: 310,680 symbols: 3,074
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 |
|---|---|---|---|---|---|---|---|
| 2007-08-02 09:30:00 | AAPL | Stock | 4.8804 | 4.8914 | 4.8432 | 4.8572 | 42521836.0 |
| 2007-08-02 09:35:00 | AAPL | Stock | 4.8579 | 4.8732 | 4.835 | 4.8554 | 26402656.0 |
| 2007-08-02 09:40:00 | AAPL | Stock | 4.8557 | 4.8736 | 4.8304 | 4.8354 | 29252300.0 |
| 2007-08-02 09:45:00 | AAPL | Stock | 4.8361 | 4.8482 | 4.8221 | 4.8482 | 23127132.0 |
| 2007-08-02 09:50:00 | AAPL | Stock | 4.8479 | 4.8679 | 4.8454 | 4.8543 | 26260948.0 |
| 2007-08-02 09:55:00 | AAPL | Stock | 4.8543 | 4.8643 | 4.8411 | 4.8607 | 14327572.0 |
| 2007-08-02 10:00:00 | AAPL | Stock | 4.8607 | 4.8607 | 4.8429 | 4.8443 | 11079124.0 |
| 2007-08-02 10:05:00 | AAPL | Stock | 4.8436 | 4.8536 | 4.825 | 4.8375 | 21903252.0 |
| 2007-08-02 10:10:00 | AAPL | Stock | 4.8379 | 4.84 | 4.8196 | 4.8196 | 18382336.0 |
| 2007-08-02 10:15:00 | AAPL | Stock | 4.8214 | 4.8346 | 4.8036 | 4.8093 | 24400404.0 |
| 2007-08-02 10:20:00 | AAPL | Stock | 4.8104 | 4.8232 | 4.7979 | 4.8025 | 23046800.0 |
| 2007-08-02 10:25:00 | AAPL | Stock | 4.8032 | 4.8114 | 4.7911 | 4.8032 | 14578760.0 |
| 2007-08-02 10:30:00 | AAPL | Stock | 4.8036 | 4.8336 | 4.7936 | 4.8268 | 15621648.0 |
| 2007-08-02 10:35:00 | AAPL | Stock | 4.8275 | 4.8393 | 4.8157 | 4.8354 | 15492932.0 |
| 2007-08-02 10:40:00 | AAPL | Stock | 4.8343 | 4.8393 | 4.8243 | 4.8371 | 10511480.0 |
| 2007-08-02 10:45:00 | AAPL | Stock | 4.8371 | 4.8421 | 4.8107 | 4.8161 | 11154584.0 |
| 2007-08-02 10:50:00 | AAPL | Stock | 4.8161 | 4.82 | 4.8036 | 4.8079 | 8719088.0 |
| 2007-08-02 10:55:00 | AAPL | Stock | 4.8075 | 4.8382 | 4.7993 | 4.8175 | 14432936.0 |
| 2007-08-02 11:00:00 | AAPL | Stock | 4.8175 | 4.8214 | 4.8011 | 4.8111 | 10209332.0 |
| 2007-08-02 11:05:00 | AAPL | Stock | 4.8107 | 4.8207 | 4.8029 | 4.8036 | 8984864.0 |
| 2007-08-02 11:10:00 | AAPL | Stock | 4.8036 | 4.8125 | 4.8 | 4.8057 | 7906024.0 |
| 2007-08-02 11:15:00 | AAPL | Stock | 4.8064 | 4.8161 | 4.7982 | 4.8079 | 5965736.0 |
| 2007-08-02 11:20:00 | AAPL | Stock | 4.8079 | 4.8204 | 4.8014 | 4.815 | 6612116.0 |
| 2007-08-02 11:25:00 | AAPL | Stock | 4.815 | 4.8325 | 4.8143 | 4.8311 | 9430008.0 |
| 2007-08-02 11:30:00 | AAPL | Stock | 4.8311 | 4.8382 | 4.825 | 4.8318 | 7154868.0 |
| 2007-08-02 11:35:00 | AAPL | Stock | 4.8325 | 4.8364 | 4.8196 | 4.8211 | 5027624.0 |
| 2007-08-02 11:40:00 | AAPL | Stock | 4.8204 | 4.8236 | 4.8139 | 4.8214 | 4386256.0 |
| 2007-08-02 11:45:00 | AAPL | Stock | 4.822 | 4.8307 | 4.8204 | 4.8243 | 4387796.0 |
| 2007-08-02 11:50:00 | AAPL | Stock | 4.8243 | 4.8425 | 4.8243 | 4.8407 | 9043832.0 |
| 2007-08-02 11:55:00 | AAPL | Stock | 4.8407 | 4.8639 | 4.8407 | 4.8621 | 16273516.0 |
| 2007-08-02 12:00:00 | AAPL | Stock | 4.8607 | 4.8621 | 4.8439 | 4.8446 | 8442504.0 |
| 2007-08-02 12:05:00 | AAPL | Stock | 4.845 | 4.8561 | 4.8429 | 4.8545 | 6222356.0 |
| 2007-08-02 12:10:00 | AAPL | Stock | 4.8553 | 4.8607 | 4.8486 | 4.855 | 7206052.0 |
| 2007-08-02 12:15:00 | AAPL | Stock | 4.855 | 4.8568 | 4.8429 | 4.8432 | 7400932.0 |
| 2007-08-02 12:20:00 | AAPL | Stock | 4.8436 | 4.8464 | 4.8393 | 4.8461 | 4559912.0 |
| 2007-08-02 12:25:00 | AAPL | Stock | 4.8446 | 4.8479 | 4.835 | 4.8389 | 3949512.0 |
| 2007-08-02 12:30:00 | AAPL | Stock | 4.8387 | 4.8393 | 4.8257 | 4.8346 | 8068060.0 |
| 2007-08-02 12:35:00 | AAPL | Stock | 4.8343 | 4.845 | 4.8311 | 4.8436 | 6300224.0 |
| 2007-08-02 12:40:00 | AAPL | Stock | 4.8443 | 4.8475 | 4.8411 | 4.8421 | 3232012.0 |
| 2007-08-02 12:45:00 | AAPL | Stock | 4.8411 | 4.8504 | 4.8375 | 4.8473 | 3820796.0 |
| 2007-08-02 12:50:00 | AAPL | Stock | 4.8476 | 4.85 | 4.8379 | 4.8432 | 3086356.0 |
| 2007-08-02 12:55:00 | AAPL | Stock | 4.8436 | 4.8475 | 4.8286 | 4.8289 | 4096428.0 |
| 2007-08-02 13:00:00 | AAPL | Stock | 4.8296 | 4.835 | 4.8214 | 4.8229 | 9010988.0 |
| 2007-08-02 13:05:00 | AAPL | Stock | 4.8232 | 4.8264 | 4.8129 | 4.825 | 7677684.0 |
| 2007-08-02 13:10:00 | AAPL | Stock | 4.8254 | 4.8271 | 4.8186 | 4.8218 | 7034888.0 |
| 2007-08-02 13:15:00 | AAPL | Stock | 4.8214 | 4.8389 | 4.82 | 4.8371 | 7640080.0 |
| 2007-08-02 13:20:00 | AAPL | Stock | 4.8371 | 4.8371 | 4.825 | 4.825 | 4888100.0 |
| 2007-08-02 13:25:00 | AAPL | Stock | 4.825 | 4.8286 | 4.8143 | 4.8261 | 7743176.0 |
| 2007-08-02 13:30:00 | AAPL | Stock | 4.8261 | 4.8464 | 4.8261 | 4.8434 | 8547840.0 |
| 2007-08-02 13:35:00 | AAPL | Stock | 4.8436 | 4.8454 | 4.835 | 4.8396 | 5288248.0 |
> showing 50 of 310,680 rows — these rows as CSV