PREVIEW / stock_5min / 2006-07-19
file: by_date/stock_5min/2006/2006-07-19.parquet size: 3.1 MB rows: 227,943 symbols: 2,316
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 |
|---|---|---|---|---|---|---|---|
| 2006-07-19 08:00:00 | AAPL | Stock | 1.8979 | 1.9 | 1.8929 | 1.8964 | 253120.0 |
| 2006-07-19 08:05:00 | AAPL | Stock | 1.8982 | 1.8989 | 1.8968 | 1.8982 | 251860.0 |
| 2006-07-19 08:10:00 | AAPL | Stock | 1.8979 | 1.8989 | 1.8968 | 1.8989 | 202244.0 |
| 2006-07-19 08:15:00 | AAPL | Stock | 1.8989 | 1.9064 | 1.8968 | 1.9064 | 882224.0 |
| 2006-07-19 08:20:00 | AAPL | Stock | 1.9075 | 1.9107 | 1.9054 | 1.9071 | 323036.0 |
| 2006-07-19 08:25:00 | AAPL | Stock | 1.9071 | 1.9104 | 1.9054 | 1.91 | 220836.0 |
| 2006-07-19 08:30:00 | AAPL | Stock | 1.9075 | 1.9089 | 1.8968 | 1.8968 | 326648.0 |
| 2006-07-19 08:35:00 | AAPL | Stock | 1.8975 | 1.9018 | 1.8964 | 1.8968 | 166992.0 |
| 2006-07-19 08:40:00 | AAPL | Stock | 1.8968 | 1.9018 | 1.8964 | 1.9018 | 815080.0 |
| 2006-07-19 08:45:00 | AAPL | Stock | 1.8982 | 1.9036 | 1.8982 | 1.9 | 120428.0 |
| 2006-07-19 08:50:00 | AAPL | Stock | 1.9018 | 1.9036 | 1.8996 | 1.9 | 504700.0 |
| 2006-07-19 08:55:00 | AAPL | Stock | 1.9 | 1.9 | 1.8971 | 1.9 | 433328.0 |
| 2006-07-19 09:00:00 | AAPL | Stock | 1.8989 | 1.8989 | 1.8946 | 1.8964 | 317380.0 |
| 2006-07-19 09:05:00 | AAPL | Stock | 1.8968 | 1.8968 | 1.8968 | 1.8968 | 28000.0 |
| 2006-07-19 09:10:00 | AAPL | Stock | 1.9 | 1.9 | 1.8982 | 1.8986 | 159404.0 |
| 2006-07-19 09:15:00 | AAPL | Stock | 1.8964 | 1.8971 | 1.8964 | 1.8964 | 266000.0 |
| 2006-07-19 09:20:00 | AAPL | Stock | 1.8946 | 1.8946 | 1.8929 | 1.8929 | 42000.0 |
| 2006-07-19 09:25:00 | AAPL | Stock | 1.8946 | 1.8964 | 1.89 | 1.89 | 1547672.0 |
| 2006-07-19 09:30:00 | AAPL | Stock | 1.8914 | 1.9086 | 1.8896 | 1.8961 | 22005396.0 |
| 2006-07-19 09:35:00 | AAPL | Stock | 1.8957 | 1.8957 | 1.8818 | 1.8896 | 15265628.0 |
| 2006-07-19 09:40:00 | AAPL | Stock | 1.89 | 1.9018 | 1.8739 | 1.8764 | 18884712.0 |
| 2006-07-19 09:45:00 | AAPL | Stock | 1.8764 | 1.8864 | 1.87 | 1.8846 | 16884700.0 |
| 2006-07-19 09:50:00 | AAPL | Stock | 1.8846 | 1.8893 | 1.8779 | 1.885 | 10894100.0 |
| 2006-07-19 09:55:00 | AAPL | Stock | 1.8854 | 1.8982 | 1.8804 | 1.8982 | 16938852.0 |
| 2006-07-19 10:00:00 | AAPL | Stock | 1.8979 | 1.9125 | 1.8961 | 1.9025 | 33233844.0 |
| 2006-07-19 10:05:00 | AAPL | Stock | 1.9025 | 1.9096 | 1.8943 | 1.8943 | 21128800.0 |
| 2006-07-19 10:10:00 | AAPL | Stock | 1.8946 | 1.9 | 1.8929 | 1.8986 | 16509248.0 |
| 2006-07-19 10:15:00 | AAPL | Stock | 1.8987 | 1.8996 | 1.8804 | 1.8911 | 18437888.0 |
| 2006-07-19 10:20:00 | AAPL | Stock | 1.8911 | 1.9061 | 1.8829 | 1.8857 | 14752808.0 |
| 2006-07-19 10:25:00 | AAPL | Stock | 1.8857 | 1.9089 | 1.8836 | 1.8911 | 10075268.0 |
| 2006-07-19 10:30:00 | AAPL | Stock | 1.8911 | 1.8964 | 1.8879 | 1.8882 | 7772632.0 |
| 2006-07-19 10:35:00 | AAPL | Stock | 1.8875 | 1.8911 | 1.8804 | 1.8814 | 16933364.0 |
| 2006-07-19 10:40:00 | AAPL | Stock | 1.8814 | 1.8946 | 1.8796 | 1.8943 | 17017672.0 |
| 2006-07-19 10:45:00 | AAPL | Stock | 1.8943 | 1.8957 | 1.8886 | 1.8893 | 11344368.0 |
| 2006-07-19 10:50:00 | AAPL | Stock | 1.8893 | 1.8925 | 1.8868 | 1.8882 | 12239192.0 |
| 2006-07-19 10:55:00 | AAPL | Stock | 1.8882 | 1.8929 | 1.885 | 1.8918 | 8953868.0 |
| 2006-07-19 11:00:00 | AAPL | Stock | 1.8914 | 1.8925 | 1.885 | 1.8857 | 6786192.0 |
| 2006-07-19 11:05:00 | AAPL | Stock | 1.8857 | 1.8929 | 1.8857 | 1.8921 | 8339380.0 |
| 2006-07-19 11:10:00 | AAPL | Stock | 1.8921 | 1.905 | 1.8914 | 1.8925 | 11568844.0 |
| 2006-07-19 11:15:00 | AAPL | Stock | 1.8929 | 1.8946 | 1.8886 | 1.8932 | 9023224.0 |
| 2006-07-19 11:20:00 | AAPL | Stock | 1.8932 | 1.8936 | 1.8871 | 1.8921 | 8635480.0 |
| 2006-07-19 11:25:00 | AAPL | Stock | 1.8882 | 1.8896 | 1.885 | 1.8857 | 10250408.0 |
| 2006-07-19 11:30:00 | AAPL | Stock | 1.8857 | 1.8879 | 1.8836 | 1.8861 | 5712112.0 |
| 2006-07-19 11:35:00 | AAPL | Stock | 1.8861 | 1.8875 | 1.8807 | 1.8875 | 7912576.0 |
| 2006-07-19 11:40:00 | AAPL | Stock | 1.8875 | 1.8882 | 1.8846 | 1.8864 | 4957792.0 |
| 2006-07-19 11:45:00 | AAPL | Stock | 1.8864 | 1.8946 | 1.8864 | 1.8946 | 9330272.0 |
| 2006-07-19 11:50:00 | AAPL | Stock | 1.8943 | 1.8993 | 1.8936 | 1.8968 | 10652096.0 |
| 2006-07-19 11:55:00 | AAPL | Stock | 1.8971 | 1.8971 | 1.8939 | 1.8971 | 7195496.0 |
| 2006-07-19 12:00:00 | AAPL | Stock | 1.8971 | 1.8979 | 1.8921 | 1.8921 | 5751648.0 |
| 2006-07-19 12:05:00 | AAPL | Stock | 1.8918 | 1.895 | 1.8911 | 1.8925 | 6280008.0 |
> showing 50 of 227,943 rows — these rows as CSV