PREVIEW / stock_5min / 2008-01-16
file: by_date/stock_5min/2008/2008-01-16.parquet size: 4.6 MB rows: 330,620 symbols: 3,260
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-01-16 04:25:00 | AAPL | Stock | 5.7893 | 5.7893 | 5.7893 | 5.7893 | 7000.0 |
| 2008-01-16 04:35:00 | AAPL | Stock | 5.8032 | 5.8032 | 5.7936 | 5.7936 | 5600.0 |
| 2008-01-16 05:20:00 | AAPL | Stock | 5.8036 | 5.8036 | 5.8036 | 5.8036 | 14000.0 |
| 2008-01-16 05:25:00 | AAPL | Stock | 5.8036 | 5.8036 | 5.7914 | 5.7914 | 8400.0 |
| 2008-01-16 05:50:00 | AAPL | Stock | 5.8161 | 5.8161 | 5.8161 | 5.8161 | 2800.0 |
| 2008-01-16 06:45:00 | AAPL | Stock | 5.815 | 5.815 | 5.815 | 5.815 | 53564.0 |
| 2008-01-16 06:50:00 | AAPL | Stock | 5.8107 | 5.8107 | 5.8071 | 5.8071 | 109564.0 |
| 2008-01-16 06:55:00 | AAPL | Stock | 5.8054 | 5.8071 | 5.8018 | 5.8071 | 28000.0 |
| 2008-01-16 07:00:00 | AAPL | Stock | 5.8125 | 5.8429 | 5.8 | 5.8393 | 184912.0 |
| 2008-01-16 07:05:00 | AAPL | Stock | 5.8325 | 5.8507 | 5.8325 | 5.8507 | 57876.0 |
| 2008-01-16 07:10:00 | AAPL | Stock | 5.8561 | 5.8571 | 5.8393 | 5.8464 | 203896.0 |
| 2008-01-16 07:20:00 | AAPL | Stock | 5.8489 | 5.8554 | 5.8489 | 5.8554 | 130200.0 |
| 2008-01-16 07:25:00 | AAPL | Stock | 5.8536 | 5.8782 | 5.8536 | 5.8782 | 113400.0 |
| 2008-01-16 07:30:00 | AAPL | Stock | 5.8711 | 5.88 | 5.8575 | 5.8575 | 149968.0 |
| 2008-01-16 07:35:00 | AAPL | Stock | 5.8596 | 5.875 | 5.8575 | 5.875 | 112644.0 |
| 2008-01-16 07:40:00 | AAPL | Stock | 5.875 | 5.8921 | 5.875 | 5.8921 | 107072.0 |
| 2008-01-16 07:45:00 | AAPL | Stock | 5.8921 | 5.9071 | 5.8907 | 5.9029 | 651420.0 |
| 2008-01-16 07:50:00 | AAPL | Stock | 5.9029 | 5.9029 | 5.8839 | 5.8839 | 374892.0 |
| 2008-01-16 07:55:00 | AAPL | Stock | 5.8839 | 5.8929 | 5.8839 | 5.8889 | 59808.0 |
| 2008-01-16 08:00:00 | AAPL | Stock | 5.8793 | 5.8925 | 5.8468 | 5.8568 | 1773660.0 |
| 2008-01-16 08:05:00 | AAPL | Stock | 5.8589 | 5.8875 | 5.8575 | 5.8768 | 592872.0 |
| 2008-01-16 08:10:00 | AAPL | Stock | 5.8768 | 5.8893 | 5.8689 | 5.8714 | 661584.0 |
| 2008-01-16 08:15:00 | AAPL | Stock | 5.8714 | 5.8839 | 5.8696 | 5.8746 | 250320.0 |
| 2008-01-16 08:20:00 | AAPL | Stock | 5.8729 | 5.8757 | 5.8575 | 5.8721 | 742588.0 |
| 2008-01-16 08:25:00 | AAPL | Stock | 5.8739 | 5.8889 | 5.8682 | 5.8768 | 483840.0 |
| 2008-01-16 08:30:00 | AAPL | Stock | 5.8771 | 5.8929 | 5.8593 | 5.8711 | 1568924.0 |
| 2008-01-16 08:35:00 | AAPL | Stock | 5.8714 | 5.8821 | 5.8679 | 5.8775 | 563724.0 |
| 2008-01-16 08:40:00 | AAPL | Stock | 5.8775 | 5.8829 | 5.87 | 5.8704 | 290276.0 |
| 2008-01-16 08:45:00 | AAPL | Stock | 5.8707 | 5.8829 | 5.8707 | 5.8807 | 680092.0 |
| 2008-01-16 08:50:00 | AAPL | Stock | 5.8793 | 5.8829 | 5.8646 | 5.8646 | 596932.0 |
| 2008-01-16 08:55:00 | AAPL | Stock | 5.8671 | 5.8804 | 5.8654 | 5.8786 | 508088.0 |
| 2008-01-16 09:00:00 | AAPL | Stock | 5.8757 | 5.8857 | 5.875 | 5.8764 | 1415288.0 |
| 2008-01-16 09:05:00 | AAPL | Stock | 5.8768 | 5.8886 | 5.8768 | 5.8789 | 1129520.0 |
| 2008-01-16 09:10:00 | AAPL | Stock | 5.8786 | 5.8907 | 5.8682 | 5.8893 | 1476496.0 |
| 2008-01-16 09:15:00 | AAPL | Stock | 5.8889 | 5.9068 | 5.8839 | 5.9068 | 1474788.0 |
| 2008-01-16 09:20:00 | AAPL | Stock | 5.9021 | 5.9214 | 5.8964 | 5.92 | 1432396.0 |
| 2008-01-16 09:25:00 | AAPL | Stock | 5.9171 | 5.9286 | 5.8875 | 5.8982 | 5963356.0 |
| 2008-01-16 09:30:00 | AAPL | Stock | 5.8964 | 5.9643 | 5.8732 | 5.9521 | 58540188.0 |
| 2008-01-16 09:35:00 | AAPL | Stock | 5.9521 | 5.9707 | 5.9107 | 5.9261 | 41983144.0 |
| 2008-01-16 09:40:00 | AAPL | Stock | 5.9264 | 6.0361 | 5.9264 | 6.0179 | 44660392.0 |
| 2008-01-16 09:45:00 | AAPL | Stock | 6.0182 | 6.0207 | 5.9825 | 6.0029 | 40078836.0 |
| 2008-01-16 09:50:00 | AAPL | Stock | 6.0036 | 6.0125 | 5.9561 | 5.9561 | 30775276.0 |
| 2008-01-16 09:55:00 | AAPL | Stock | 5.9557 | 5.9564 | 5.8821 | 5.8843 | 47067944.0 |
| 2008-01-16 10:00:00 | AAPL | Stock | 5.8836 | 5.9129 | 5.8514 | 5.8554 | 37906428.0 |
| 2008-01-16 10:05:00 | AAPL | Stock | 5.8546 | 5.8986 | 5.8471 | 5.8961 | 34914488.0 |
| 2008-01-16 10:10:00 | AAPL | Stock | 5.8982 | 5.9 | 5.8246 | 5.8254 | 30039968.0 |
| 2008-01-16 10:15:00 | AAPL | Stock | 5.8254 | 5.8557 | 5.81 | 5.8232 | 34901300.0 |
| 2008-01-16 10:20:00 | AAPL | Stock | 5.8225 | 5.8271 | 5.7621 | 5.8054 | 44143288.0 |
| 2008-01-16 10:25:00 | AAPL | Stock | 5.805 | 5.8171 | 5.7386 | 5.7436 | 34215944.0 |
| 2008-01-16 10:30:00 | AAPL | Stock | 5.7432 | 5.8036 | 5.7414 | 5.7918 | 31782408.0 |
> showing 50 of 330,620 rows — these rows as CSV