PREVIEW / stock_5min / 2007-11-07
file: by_date/stock_5min/2007/2007-11-07.parquet size: 4.5 MB rows: 322,431 symbols: 3,210
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-11-07 04:40:00 | AAPL | Stock | 6.8132 | 6.8132 | 6.8079 | 6.8079 | 18200.0 |
| 2007-11-07 04:50:00 | AAPL | Stock | 6.795 | 6.795 | 6.795 | 6.795 | 3080.0 |
| 2007-11-07 05:30:00 | AAPL | Stock | 6.7957 | 6.7957 | 6.7957 | 6.7957 | 2800.0 |
| 2007-11-07 05:35:00 | AAPL | Stock | 6.7861 | 6.7861 | 6.7857 | 6.7857 | 16800.0 |
| 2007-11-07 06:05:00 | AAPL | Stock | 6.7929 | 6.7929 | 6.7929 | 6.7929 | 2800.0 |
| 2007-11-07 06:30:00 | AAPL | Stock | 6.7929 | 6.7929 | 6.7929 | 6.7929 | 2800.0 |
| 2007-11-07 06:45:00 | AAPL | Stock | 6.7857 | 6.7857 | 6.7857 | 6.7857 | 14000.0 |
| 2007-11-07 06:55:00 | AAPL | Stock | 6.7857 | 6.7857 | 6.7857 | 6.7857 | 2800.0 |
| 2007-11-07 07:00:00 | AAPL | Stock | 6.7857 | 6.7857 | 6.7746 | 6.775 | 57120.0 |
| 2007-11-07 07:05:00 | AAPL | Stock | 6.7679 | 6.7679 | 6.7571 | 6.7571 | 44800.0 |
| 2007-11-07 07:10:00 | AAPL | Stock | 6.75 | 6.75 | 6.7493 | 6.7493 | 16800.0 |
| 2007-11-07 07:15:00 | AAPL | Stock | 6.7454 | 6.7661 | 6.7454 | 6.7661 | 106848.0 |
| 2007-11-07 07:20:00 | AAPL | Stock | 6.75 | 6.7661 | 6.75 | 6.7661 | 50344.0 |
| 2007-11-07 07:25:00 | AAPL | Stock | 6.7661 | 6.7661 | 6.7571 | 6.7661 | 39200.0 |
| 2007-11-07 07:30:00 | AAPL | Stock | 6.7661 | 6.7761 | 6.7661 | 6.7761 | 63000.0 |
| 2007-11-07 07:35:00 | AAPL | Stock | 6.7761 | 6.8032 | 6.7761 | 6.785 | 160664.0 |
| 2007-11-07 07:40:00 | AAPL | Stock | 6.7857 | 6.7893 | 6.7836 | 6.7857 | 105616.0 |
| 2007-11-07 07:45:00 | AAPL | Stock | 6.78 | 6.78 | 6.7732 | 6.7786 | 24640.0 |
| 2007-11-07 07:50:00 | AAPL | Stock | 6.7786 | 6.7857 | 6.7786 | 6.7807 | 128800.0 |
| 2007-11-07 07:55:00 | AAPL | Stock | 6.7807 | 6.7893 | 6.7732 | 6.7857 | 242340.0 |
| 2007-11-07 08:00:00 | AAPL | Stock | 6.7807 | 6.7929 | 6.7732 | 6.7875 | 1377236.0 |
| 2007-11-07 08:05:00 | AAPL | Stock | 6.7786 | 6.7921 | 6.7664 | 6.7711 | 1277164.0 |
| 2007-11-07 08:10:00 | AAPL | Stock | 6.7729 | 6.7771 | 6.7664 | 6.7771 | 435876.0 |
| 2007-11-07 08:15:00 | AAPL | Stock | 6.7764 | 6.7889 | 6.7764 | 6.7875 | 377944.0 |
| 2007-11-07 08:20:00 | AAPL | Stock | 6.7882 | 6.8014 | 6.7882 | 6.7993 | 782320.0 |
| 2007-11-07 08:25:00 | AAPL | Stock | 6.7996 | 6.8 | 6.7929 | 6.7964 | 613508.0 |
| 2007-11-07 08:30:00 | AAPL | Stock | 6.7979 | 6.8018 | 6.7929 | 6.7946 | 188132.0 |
| 2007-11-07 08:35:00 | AAPL | Stock | 6.7932 | 6.7961 | 6.7889 | 6.7889 | 425600.0 |
| 2007-11-07 08:40:00 | AAPL | Stock | 6.7946 | 6.8036 | 6.7868 | 6.8036 | 850136.0 |
| 2007-11-07 08:45:00 | AAPL | Stock | 6.8036 | 6.8104 | 6.8 | 6.8061 | 802984.0 |
| 2007-11-07 08:50:00 | AAPL | Stock | 6.805 | 6.8071 | 6.8036 | 6.8057 | 295960.0 |
| 2007-11-07 08:55:00 | AAPL | Stock | 6.8054 | 6.8082 | 6.8036 | 6.8054 | 142604.0 |
| 2007-11-07 09:00:00 | AAPL | Stock | 6.8054 | 6.8107 | 6.8021 | 6.8021 | 650636.0 |
| 2007-11-07 09:05:00 | AAPL | Stock | 6.8004 | 6.8057 | 6.8004 | 6.8039 | 373520.0 |
| 2007-11-07 09:10:00 | AAPL | Stock | 6.8039 | 6.8107 | 6.8036 | 6.8104 | 270760.0 |
| 2007-11-07 09:15:00 | AAPL | Stock | 6.8071 | 6.8071 | 6.8021 | 6.8036 | 358008.0 |
| 2007-11-07 09:20:00 | AAPL | Stock | 6.8036 | 6.805 | 6.7907 | 6.8036 | 687036.0 |
| 2007-11-07 09:25:00 | AAPL | Stock | 6.8039 | 6.8125 | 6.8036 | 6.8054 | 453600.0 |
| 2007-11-07 09:30:00 | AAPL | Stock | 6.8068 | 6.8214 | 6.7782 | 6.7868 | 30518264.0 |
| 2007-11-07 09:35:00 | AAPL | Stock | 6.7857 | 6.8061 | 6.775 | 6.7879 | 22050532.0 |
| 2007-11-07 09:40:00 | AAPL | Stock | 6.7868 | 6.8304 | 6.7857 | 6.8211 | 21874860.0 |
| 2007-11-07 09:45:00 | AAPL | Stock | 6.8182 | 6.8393 | 6.7921 | 6.8321 | 24591560.0 |
| 2007-11-07 09:50:00 | AAPL | Stock | 6.8318 | 6.8404 | 6.8104 | 6.815 | 20542396.0 |
| 2007-11-07 09:55:00 | AAPL | Stock | 6.8154 | 6.8286 | 6.8018 | 6.8286 | 14469672.0 |
| 2007-11-07 10:00:00 | AAPL | Stock | 6.8286 | 6.8564 | 6.8071 | 6.8557 | 25119444.0 |
| 2007-11-07 10:05:00 | AAPL | Stock | 6.8557 | 6.8696 | 6.8496 | 6.8586 | 29225224.0 |
| 2007-11-07 10:10:00 | AAPL | Stock | 6.8589 | 6.8814 | 6.8504 | 6.8671 | 20030780.0 |
| 2007-11-07 10:15:00 | AAPL | Stock | 6.8679 | 6.8743 | 6.8521 | 6.8629 | 17477712.0 |
| 2007-11-07 10:20:00 | AAPL | Stock | 6.8636 | 6.8649 | 6.8361 | 6.8521 | 14626136.0 |
| 2007-11-07 10:25:00 | AAPL | Stock | 6.8525 | 6.855 | 6.8404 | 6.8518 | 10947832.0 |
> showing 50 of 322,431 rows — these rows as CSV