PREVIEW / stock_1min / 2007-08-02
file: by_date/stock_1min/2007/2007-08-02.parquet size: 12.5 MB rows: 1,022,790 symbols: 2,516
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.8607 | 4.8621 | 15977836.0 |
| 2007-08-02 09:31:00 | AAPL | Stock | 4.8625 | 4.8886 | 4.8432 | 4.8564 | 8305892.0 |
| 2007-08-02 09:32:00 | AAPL | Stock | 4.8571 | 4.875 | 4.8461 | 4.8711 | 6673604.0 |
| 2007-08-02 09:33:00 | AAPL | Stock | 4.8711 | 4.8832 | 4.8657 | 4.8818 | 5050976.0 |
| 2007-08-02 09:34:00 | AAPL | Stock | 4.8807 | 4.8814 | 4.8571 | 4.8572 | 6513528.0 |
| 2007-08-02 09:35:00 | AAPL | Stock | 4.8579 | 4.8732 | 4.8475 | 4.8707 | 6276480.0 |
| 2007-08-02 09:36:00 | AAPL | Stock | 4.8707 | 4.8732 | 4.8607 | 4.8629 | 4426436.0 |
| 2007-08-02 09:37:00 | AAPL | Stock | 4.8659 | 4.8659 | 4.8507 | 4.8507 | 5288668.0 |
| 2007-08-02 09:38:00 | AAPL | Stock | 4.85 | 4.8543 | 4.8457 | 4.8514 | 4195296.0 |
| 2007-08-02 09:39:00 | AAPL | Stock | 4.8514 | 4.8554 | 4.835 | 4.8554 | 6215776.0 |
| 2007-08-02 09:40:00 | AAPL | Stock | 4.8557 | 4.8736 | 4.85 | 4.8611 | 5944624.0 |
| 2007-08-02 09:41:00 | AAPL | Stock | 4.8611 | 4.8679 | 4.8536 | 4.8561 | 4401852.0 |
| 2007-08-02 09:42:00 | AAPL | Stock | 4.8557 | 4.8611 | 4.8396 | 4.8611 | 6697656.0 |
| 2007-08-02 09:43:00 | AAPL | Stock | 4.8607 | 4.8625 | 4.8404 | 4.8468 | 4749192.0 |
| 2007-08-02 09:44:00 | AAPL | Stock | 4.8482 | 4.855 | 4.8304 | 4.8354 | 7458976.0 |
| 2007-08-02 09:45:00 | AAPL | Stock | 4.8361 | 4.8479 | 4.8304 | 4.8329 | 5212004.0 |
| 2007-08-02 09:46:00 | AAPL | Stock | 4.8339 | 4.8339 | 4.8221 | 4.8325 | 5147744.0 |
| 2007-08-02 09:47:00 | AAPL | Stock | 4.8329 | 4.8443 | 4.8232 | 4.8346 | 6327580.0 |
| 2007-08-02 09:48:00 | AAPL | Stock | 4.8346 | 4.8432 | 4.8339 | 4.8361 | 3099712.0 |
| 2007-08-02 09:49:00 | AAPL | Stock | 4.836 | 4.8482 | 4.8346 | 4.8482 | 3340092.0 |
| 2007-08-02 09:50:00 | AAPL | Stock | 4.8479 | 4.8607 | 4.8454 | 4.8589 | 5576788.0 |
| 2007-08-02 09:51:00 | AAPL | Stock | 4.8593 | 4.8679 | 4.8529 | 4.8636 | 5966548.0 |
| 2007-08-02 09:52:00 | AAPL | Stock | 4.8632 | 4.8646 | 4.8507 | 4.8564 | 5611060.0 |
| 2007-08-02 09:53:00 | AAPL | Stock | 4.855 | 4.8604 | 4.8529 | 4.8586 | 3003252.0 |
| 2007-08-02 09:54:00 | AAPL | Stock | 4.8571 | 4.8643 | 4.8496 | 4.8543 | 6103300.0 |
| 2007-08-02 09:55:00 | AAPL | Stock | 4.8543 | 4.8575 | 4.8429 | 4.8457 | 4000024.0 |
| 2007-08-02 09:56:00 | AAPL | Stock | 4.8461 | 4.8511 | 4.8411 | 4.85 | 2933028.0 |
| 2007-08-02 09:57:00 | AAPL | Stock | 4.8496 | 4.8571 | 4.8472 | 4.8511 | 2216676.0 |
| 2007-08-02 09:58:00 | AAPL | Stock | 4.8511 | 4.8607 | 4.8482 | 4.8607 | 3163020.0 |
| 2007-08-02 09:59:00 | AAPL | Stock | 4.8604 | 4.8643 | 4.8582 | 4.8607 | 2014824.0 |
| 2007-08-02 10:00:00 | AAPL | Stock | 4.8607 | 4.8607 | 4.8546 | 4.8579 | 1939392.0 |
| 2007-08-02 10:01:00 | AAPL | Stock | 4.8579 | 4.8589 | 4.8543 | 4.8543 | 1583176.0 |
| 2007-08-02 10:02:00 | AAPL | Stock | 4.8546 | 4.8589 | 4.8504 | 4.8561 | 1333528.0 |
| 2007-08-02 10:03:00 | AAPL | Stock | 4.8557 | 4.8571 | 4.8468 | 4.8473 | 2865408.0 |
| 2007-08-02 10:04:00 | AAPL | Stock | 4.8482 | 4.8489 | 4.8429 | 4.8443 | 3357620.0 |
| 2007-08-02 10:05:00 | AAPL | Stock | 4.8436 | 4.8536 | 4.8429 | 4.8507 | 3732876.0 |
| 2007-08-02 10:06:00 | AAPL | Stock | 4.85 | 4.8504 | 4.8393 | 4.845 | 5603864.0 |
| 2007-08-02 10:07:00 | AAPL | Stock | 4.845 | 4.845 | 4.8314 | 4.8318 | 4994304.0 |
| 2007-08-02 10:08:00 | AAPL | Stock | 4.8329 | 4.8386 | 4.825 | 4.8371 | 5003824.0 |
| 2007-08-02 10:09:00 | AAPL | Stock | 4.8371 | 4.8411 | 4.8329 | 4.8375 | 2568384.0 |
| 2007-08-02 10:10:00 | AAPL | Stock | 4.8379 | 4.8382 | 4.8304 | 4.8379 | 2977212.0 |
| 2007-08-02 10:11:00 | AAPL | Stock | 4.8386 | 4.84 | 4.8279 | 4.8304 | 3492104.0 |
| 2007-08-02 10:12:00 | AAPL | Stock | 4.8307 | 4.8389 | 4.83 | 4.8325 | 2903376.0 |
| 2007-08-02 10:13:00 | AAPL | Stock | 4.8321 | 4.8371 | 4.8286 | 4.8286 | 3343452.0 |
| 2007-08-02 10:14:00 | AAPL | Stock | 4.8325 | 4.8325 | 4.8196 | 4.8196 | 5666192.0 |
| 2007-08-02 10:15:00 | AAPL | Stock | 4.8214 | 4.8271 | 4.8129 | 4.8193 | 7628348.0 |
| 2007-08-02 10:16:00 | AAPL | Stock | 4.8193 | 4.8311 | 4.8164 | 4.8257 | 4257876.0 |
| 2007-08-02 10:17:00 | AAPL | Stock | 4.8261 | 4.8346 | 4.825 | 4.8296 | 3133592.0 |
| 2007-08-02 10:18:00 | AAPL | Stock | 4.8293 | 4.8339 | 4.8221 | 4.8232 | 3288376.0 |
| 2007-08-02 10:19:00 | AAPL | Stock | 4.8236 | 4.8239 | 4.8036 | 4.8093 | 6092212.0 |
> showing 50 of 1,022,790 rows — these rows as CSV