PREVIEW / stock_5min / 2008-04-23
file: by_date/stock_5min/2008/2008-04-23.parquet size: 4.3 MB rows: 310,221 symbols: 3,297
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-23 06:35:00 | AAPL | Stock | 5.79 | 5.79 | 5.7836 | 5.7836 | 49560.0 |
| 2008-04-23 07:00:00 | AAPL | Stock | 5.7739 | 5.7739 | 5.7739 | 5.7739 | 16800.0 |
| 2008-04-23 07:05:00 | AAPL | Stock | 5.7714 | 5.7714 | 5.7714 | 5.7714 | 2800.0 |
| 2008-04-23 07:10:00 | AAPL | Stock | 5.7675 | 5.7675 | 5.7675 | 5.7675 | 42000.0 |
| 2008-04-23 07:15:00 | AAPL | Stock | 5.7675 | 5.7729 | 5.7675 | 5.7729 | 42532.0 |
| 2008-04-23 07:20:00 | AAPL | Stock | 5.775 | 5.7821 | 5.7732 | 5.7821 | 31864.0 |
| 2008-04-23 07:30:00 | AAPL | Stock | 5.7679 | 5.7679 | 5.7643 | 5.7643 | 6580.0 |
| 2008-04-23 07:40:00 | AAPL | Stock | 5.7786 | 5.7971 | 5.7786 | 5.7946 | 201292.0 |
| 2008-04-23 07:45:00 | AAPL | Stock | 5.7946 | 5.8014 | 5.7786 | 5.7964 | 211372.0 |
| 2008-04-23 07:50:00 | AAPL | Stock | 5.8 | 5.8 | 5.7786 | 5.7786 | 102200.0 |
| 2008-04-23 07:55:00 | AAPL | Stock | 5.7854 | 5.7857 | 5.7821 | 5.7821 | 50064.0 |
| 2008-04-23 08:00:00 | AAPL | Stock | 5.7821 | 5.7861 | 5.7768 | 5.7793 | 914620.0 |
| 2008-04-23 08:05:00 | AAPL | Stock | 5.7793 | 5.7929 | 5.7793 | 5.7929 | 407232.0 |
| 2008-04-23 08:10:00 | AAPL | Stock | 5.7925 | 5.8168 | 5.7904 | 5.8125 | 567756.0 |
| 2008-04-23 08:15:00 | AAPL | Stock | 5.8125 | 5.8193 | 5.8071 | 5.8082 | 999012.0 |
| 2008-04-23 08:20:00 | AAPL | Stock | 5.8107 | 5.8121 | 5.8029 | 5.8064 | 727328.0 |
| 2008-04-23 08:25:00 | AAPL | Stock | 5.8071 | 5.8207 | 5.8061 | 5.8179 | 703780.0 |
| 2008-04-23 08:30:00 | AAPL | Stock | 5.8186 | 5.8243 | 5.8154 | 5.8154 | 1112384.0 |
| 2008-04-23 08:35:00 | AAPL | Stock | 5.8161 | 5.8311 | 5.8139 | 5.8304 | 963256.0 |
| 2008-04-23 08:40:00 | AAPL | Stock | 5.8307 | 5.8368 | 5.825 | 5.8357 | 1071448.0 |
| 2008-04-23 08:45:00 | AAPL | Stock | 5.8371 | 5.8371 | 5.8254 | 5.8314 | 826560.0 |
| 2008-04-23 08:50:00 | AAPL | Stock | 5.8311 | 5.8357 | 5.8304 | 5.8357 | 577920.0 |
| 2008-04-23 08:55:00 | AAPL | Stock | 5.8364 | 5.85 | 5.8354 | 5.8471 | 1224832.0 |
| 2008-04-23 09:00:00 | AAPL | Stock | 5.8482 | 5.8529 | 5.8429 | 5.8443 | 1359064.0 |
| 2008-04-23 09:05:00 | AAPL | Stock | 5.8443 | 5.8607 | 5.8436 | 5.8557 | 1138872.0 |
| 2008-04-23 09:10:00 | AAPL | Stock | 5.855 | 5.8604 | 5.8489 | 5.8514 | 1676416.0 |
| 2008-04-23 09:15:00 | AAPL | Stock | 5.855 | 5.8564 | 5.8482 | 5.8482 | 913640.0 |
| 2008-04-23 09:20:00 | AAPL | Stock | 5.8482 | 5.8521 | 5.8421 | 5.8489 | 684460.0 |
| 2008-04-23 09:25:00 | AAPL | Stock | 5.8471 | 5.8632 | 5.8393 | 5.8579 | 3026968.0 |
| 2008-04-23 09:30:00 | AAPL | Stock | 5.8571 | 5.8614 | 5.8075 | 5.8082 | 54677000.0 |
| 2008-04-23 09:35:00 | AAPL | Stock | 5.8086 | 5.8504 | 5.8054 | 5.8401 | 28921536.0 |
| 2008-04-23 09:40:00 | AAPL | Stock | 5.8407 | 5.8489 | 5.8214 | 5.8379 | 24667468.0 |
| 2008-04-23 09:45:00 | AAPL | Stock | 5.8379 | 5.8382 | 5.8139 | 5.8214 | 18869872.0 |
| 2008-04-23 09:50:00 | AAPL | Stock | 5.8214 | 5.8429 | 5.8082 | 5.8333 | 20363672.0 |
| 2008-04-23 09:55:00 | AAPL | Stock | 5.8336 | 5.8554 | 5.8286 | 5.8454 | 17082912.0 |
| 2008-04-23 10:00:00 | AAPL | Stock | 5.8454 | 5.8643 | 5.8361 | 5.8575 | 20508824.0 |
| 2008-04-23 10:05:00 | AAPL | Stock | 5.8575 | 5.875 | 5.8489 | 5.8693 | 25181800.0 |
| 2008-04-23 10:10:00 | AAPL | Stock | 5.8686 | 5.8696 | 5.8496 | 5.8621 | 20500116.0 |
| 2008-04-23 10:15:00 | AAPL | Stock | 5.8621 | 5.8725 | 5.8543 | 5.8621 | 14339164.0 |
| 2008-04-23 10:20:00 | AAPL | Stock | 5.8621 | 5.8736 | 5.8621 | 5.8653 | 13454280.0 |
| 2008-04-23 10:25:00 | AAPL | Stock | 5.865 | 5.8871 | 5.865 | 5.8741 | 22620192.0 |
| 2008-04-23 10:30:00 | AAPL | Stock | 5.8736 | 5.8782 | 5.8639 | 5.865 | 14367304.0 |
| 2008-04-23 10:35:00 | AAPL | Stock | 5.8657 | 5.8743 | 5.8571 | 5.8621 | 16636424.0 |
| 2008-04-23 10:40:00 | AAPL | Stock | 5.8618 | 5.8714 | 5.8425 | 5.8436 | 26150740.0 |
| 2008-04-23 10:45:00 | AAPL | Stock | 5.8429 | 5.8557 | 5.8382 | 5.8536 | 13652408.0 |
| 2008-04-23 10:50:00 | AAPL | Stock | 5.8536 | 5.8643 | 5.8504 | 5.8629 | 10072888.0 |
| 2008-04-23 10:55:00 | AAPL | Stock | 5.8629 | 5.8632 | 5.8482 | 5.8532 | 9690912.0 |
| 2008-04-23 11:00:00 | AAPL | Stock | 5.8529 | 5.8714 | 5.8507 | 5.8675 | 11534040.0 |
| 2008-04-23 11:05:00 | AAPL | Stock | 5.8682 | 5.8821 | 5.8679 | 5.8786 | 14331996.0 |
| 2008-04-23 11:10:00 | AAPL | Stock | 5.8786 | 5.8804 | 5.8646 | 5.8686 | 10118444.0 |
> showing 50 of 310,221 rows — these rows as CSV