PREVIEW / stock_5min / 2007-08-08
file: by_date/stock_5min/2007/2007-08-08.parquet size: 4.6 MB rows: 322,497 symbols: 3,122
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-08 09:30:00 | AAPL | Stock | 4.8843 | 4.8879 | 4.8421 | 4.8489 | 24894744.0 |
| 2007-08-08 09:35:00 | AAPL | Stock | 4.8561 | 4.8661 | 4.8329 | 4.8389 | 17456292.0 |
| 2007-08-08 09:40:00 | AAPL | Stock | 4.8411 | 4.8488 | 4.8132 | 4.8215 | 16428524.0 |
| 2007-08-08 09:45:00 | AAPL | Stock | 4.8218 | 4.8375 | 4.8207 | 4.8293 | 13360984.0 |
| 2007-08-08 09:50:00 | AAPL | Stock | 4.8286 | 4.84 | 4.8036 | 4.8104 | 18727800.0 |
| 2007-08-08 09:55:00 | AAPL | Stock | 4.8107 | 4.8193 | 4.7989 | 4.8157 | 14708988.0 |
| 2007-08-08 10:00:00 | AAPL | Stock | 4.8157 | 4.8325 | 4.8125 | 4.8282 | 15161384.0 |
| 2007-08-08 10:05:00 | AAPL | Stock | 4.8279 | 4.8314 | 4.8071 | 4.8075 | 10792516.0 |
| 2007-08-08 10:10:00 | AAPL | Stock | 4.8079 | 4.8232 | 4.8075 | 4.8207 | 10236996.0 |
| 2007-08-08 10:15:00 | AAPL | Stock | 4.8204 | 4.8286 | 4.8171 | 4.8186 | 11809532.0 |
| 2007-08-08 10:20:00 | AAPL | Stock | 4.8196 | 4.8207 | 4.8 | 4.8086 | 15050868.0 |
| 2007-08-08 10:25:00 | AAPL | Stock | 4.8093 | 4.8094 | 4.7911 | 4.7982 | 14232960.0 |
| 2007-08-08 10:30:00 | AAPL | Stock | 4.7975 | 4.8054 | 4.7911 | 4.7954 | 11209548.0 |
| 2007-08-08 10:35:00 | AAPL | Stock | 4.7964 | 4.7971 | 4.7804 | 4.7911 | 16824136.0 |
| 2007-08-08 10:40:00 | AAPL | Stock | 4.7911 | 4.8275 | 4.7889 | 4.8232 | 15042048.0 |
| 2007-08-08 10:45:00 | AAPL | Stock | 4.8234 | 4.8257 | 4.8075 | 4.8107 | 11472832.0 |
| 2007-08-08 10:50:00 | AAPL | Stock | 4.8118 | 4.8118 | 4.7946 | 4.8007 | 10298904.0 |
| 2007-08-08 10:55:00 | AAPL | Stock | 4.8 | 4.8057 | 4.7904 | 4.7925 | 10037244.0 |
| 2007-08-08 11:00:00 | AAPL | Stock | 4.7929 | 4.7929 | 4.7786 | 4.7786 | 16824220.0 |
| 2007-08-08 11:05:00 | AAPL | Stock | 4.7786 | 4.7921 | 4.7768 | 4.7911 | 12565700.0 |
| 2007-08-08 11:10:00 | AAPL | Stock | 4.7918 | 4.8036 | 4.7914 | 4.7993 | 9076116.0 |
| 2007-08-08 11:15:00 | AAPL | Stock | 4.7993 | 4.7993 | 4.7868 | 4.7868 | 6439188.0 |
| 2007-08-08 11:20:00 | AAPL | Stock | 4.7876 | 4.7993 | 4.7857 | 4.7961 | 5910744.0 |
| 2007-08-08 11:25:00 | AAPL | Stock | 4.7957 | 4.8114 | 4.795 | 4.7964 | 10186148.0 |
| 2007-08-08 11:30:00 | AAPL | Stock | 4.7964 | 4.8143 | 4.7896 | 4.8089 | 8233876.0 |
| 2007-08-08 11:35:00 | AAPL | Stock | 4.8089 | 4.825 | 4.8061 | 4.8232 | 10755892.0 |
| 2007-08-08 11:40:00 | AAPL | Stock | 4.8214 | 4.8232 | 4.8061 | 4.8071 | 6992664.0 |
| 2007-08-08 11:45:00 | AAPL | Stock | 4.8075 | 4.8093 | 4.8021 | 4.8064 | 5396132.0 |
| 2007-08-08 11:50:00 | AAPL | Stock | 4.8068 | 4.8093 | 4.7982 | 4.8 | 6142136.0 |
| 2007-08-08 11:55:00 | AAPL | Stock | 4.8004 | 4.8075 | 4.7982 | 4.8064 | 3852352.0 |
| 2007-08-08 12:00:00 | AAPL | Stock | 4.8057 | 4.8064 | 4.7936 | 4.795 | 5015192.0 |
| 2007-08-08 12:05:00 | AAPL | Stock | 4.7946 | 4.8 | 4.7946 | 4.7989 | 2965144.0 |
| 2007-08-08 12:10:00 | AAPL | Stock | 4.7993 | 4.8 | 4.7889 | 4.7939 | 6263320.0 |
| 2007-08-08 12:15:00 | AAPL | Stock | 4.7932 | 4.8012 | 4.7904 | 4.8 | 4831120.0 |
| 2007-08-08 12:20:00 | AAPL | Stock | 4.8 | 4.8018 | 4.7932 | 4.7932 | 4510716.0 |
| 2007-08-08 12:25:00 | AAPL | Stock | 4.7932 | 4.7982 | 4.7896 | 4.7961 | 7134176.0 |
| 2007-08-08 12:30:00 | AAPL | Stock | 4.7957 | 4.8018 | 4.7957 | 4.8 | 5272428.0 |
| 2007-08-08 12:35:00 | AAPL | Stock | 4.8004 | 4.8068 | 4.7993 | 4.8064 | 4280640.0 |
| 2007-08-08 12:40:00 | AAPL | Stock | 4.8068 | 4.8068 | 4.7982 | 4.8 | 4613924.0 |
| 2007-08-08 12:45:00 | AAPL | Stock | 4.7989 | 4.8018 | 4.7929 | 4.8011 | 4037404.0 |
| 2007-08-08 12:50:00 | AAPL | Stock | 4.8007 | 4.8011 | 4.7918 | 4.7918 | 4663288.0 |
| 2007-08-08 12:55:00 | AAPL | Stock | 4.7929 | 4.7964 | 4.7907 | 4.7929 | 3656044.0 |
| 2007-08-08 13:00:00 | AAPL | Stock | 4.7921 | 4.7996 | 4.7904 | 4.7986 | 3498684.0 |
| 2007-08-08 13:05:00 | AAPL | Stock | 4.7982 | 4.8 | 4.7929 | 4.795 | 3366132.0 |
| 2007-08-08 13:10:00 | AAPL | Stock | 4.7943 | 4.8107 | 4.794 | 4.8071 | 5060776.0 |
| 2007-08-08 13:15:00 | AAPL | Stock | 4.8075 | 4.8171 | 4.8011 | 4.8118 | 6208468.0 |
| 2007-08-08 13:20:00 | AAPL | Stock | 4.8121 | 4.8132 | 4.7986 | 4.8 | 4312728.0 |
| 2007-08-08 13:25:00 | AAPL | Stock | 4.8 | 4.8139 | 4.7982 | 4.8107 | 4679556.0 |
| 2007-08-08 13:30:00 | AAPL | Stock | 4.8107 | 4.8196 | 4.8011 | 4.8168 | 7662396.0 |
| 2007-08-08 13:35:00 | AAPL | Stock | 4.8164 | 4.8221 | 4.8004 | 4.8071 | 10462732.0 |
> showing 50 of 322,497 rows — these rows as CSV