PREVIEW / stock_5min / 2009-11-04
file: by_date/stock_5min/2009/2009-11-04.parquet size: 4.8 MB rows: 326,376 symbols: 3,399
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-04 06:30:00 | AAPL | Stock | 6.7857 | 6.7857 | 6.7857 | 6.7857 | 28000.0 |
| 2009-11-04 07:00:00 | AAPL | Stock | 6.7911 | 6.7911 | 6.7911 | 6.7911 | 28000.0 |
| 2009-11-04 07:05:00 | AAPL | Stock | 6.7982 | 6.7982 | 6.7982 | 6.7982 | 11200.0 |
| 2009-11-04 07:15:00 | AAPL | Stock | 6.7936 | 6.7936 | 6.7911 | 6.7911 | 39200.0 |
| 2009-11-04 07:25:00 | AAPL | Stock | 6.7857 | 6.7857 | 6.7857 | 6.7857 | 2800.0 |
| 2009-11-04 07:30:00 | AAPL | Stock | 6.7839 | 6.7839 | 6.7839 | 6.7839 | 12600.0 |
| 2009-11-04 07:40:00 | AAPL | Stock | 6.7761 | 6.7821 | 6.7761 | 6.7821 | 25088.0 |
| 2009-11-04 07:45:00 | AAPL | Stock | 6.775 | 6.7893 | 6.775 | 6.7889 | 84000.0 |
| 2009-11-04 07:50:00 | AAPL | Stock | 6.7768 | 6.7864 | 6.7768 | 6.7804 | 30800.0 |
| 2009-11-04 07:55:00 | AAPL | Stock | 6.7804 | 6.7889 | 6.7804 | 6.7807 | 19600.0 |
| 2009-11-04 08:00:00 | AAPL | Stock | 6.7839 | 6.7918 | 6.7804 | 6.7918 | 268072.0 |
| 2009-11-04 08:05:00 | AAPL | Stock | 6.7946 | 6.7964 | 6.7946 | 6.7946 | 105224.0 |
| 2009-11-04 08:10:00 | AAPL | Stock | 6.7946 | 6.8032 | 6.7946 | 6.8032 | 117628.0 |
| 2009-11-04 08:15:00 | AAPL | Stock | 6.7982 | 6.8005 | 6.7893 | 6.7964 | 211316.0 |
| 2009-11-04 08:20:00 | AAPL | Stock | 6.7964 | 6.8118 | 6.7946 | 6.8036 | 314132.0 |
| 2009-11-04 08:25:00 | AAPL | Stock | 6.8096 | 6.8212 | 6.8036 | 6.8036 | 286720.0 |
| 2009-11-04 08:30:00 | AAPL | Stock | 6.805 | 6.8207 | 6.805 | 6.8121 | 215964.0 |
| 2009-11-04 08:35:00 | AAPL | Stock | 6.8075 | 6.8161 | 6.8075 | 6.8121 | 213640.0 |
| 2009-11-04 08:40:00 | AAPL | Stock | 6.8046 | 6.8204 | 6.8043 | 6.82 | 197176.0 |
| 2009-11-04 08:45:00 | AAPL | Stock | 6.8204 | 6.8211 | 6.8107 | 6.8155 | 265076.0 |
| 2009-11-04 08:50:00 | AAPL | Stock | 6.8154 | 6.8179 | 6.8107 | 6.8125 | 197400.0 |
| 2009-11-04 08:55:00 | AAPL | Stock | 6.8125 | 6.8161 | 6.8064 | 6.8125 | 95732.0 |
| 2009-11-04 09:00:00 | AAPL | Stock | 6.8082 | 6.8175 | 6.8082 | 6.8146 | 159712.0 |
| 2009-11-04 09:05:00 | AAPL | Stock | 6.8175 | 6.8186 | 6.8057 | 6.8057 | 230720.0 |
| 2009-11-04 09:10:00 | AAPL | Stock | 6.8057 | 6.8123 | 6.8057 | 6.8118 | 199892.0 |
| 2009-11-04 09:15:00 | AAPL | Stock | 6.8089 | 6.8125 | 6.8082 | 6.8082 | 67200.0 |
| 2009-11-04 09:20:00 | AAPL | Stock | 6.8107 | 6.8211 | 6.8096 | 6.8179 | 207816.0 |
| 2009-11-04 09:25:00 | AAPL | Stock | 6.8179 | 6.8204 | 6.8107 | 6.8107 | 398272.0 |
| 2009-11-04 09:30:00 | AAPL | Stock | 6.8114 | 6.8368 | 6.8036 | 6.8295 | 21030856.0 |
| 2009-11-04 09:35:00 | AAPL | Stock | 6.8296 | 6.8321 | 6.8125 | 6.8243 | 10307416.0 |
| 2009-11-04 09:40:00 | AAPL | Stock | 6.8214 | 6.825 | 6.7954 | 6.8012 | 13218352.0 |
| 2009-11-04 09:45:00 | AAPL | Stock | 6.8005 | 6.8132 | 6.7939 | 6.8004 | 9344048.0 |
| 2009-11-04 09:50:00 | AAPL | Stock | 6.8004 | 6.8189 | 6.7982 | 6.8121 | 7049504.0 |
| 2009-11-04 09:55:00 | AAPL | Stock | 6.8136 | 6.8339 | 6.8107 | 6.8332 | 9279340.0 |
| 2009-11-04 10:00:00 | AAPL | Stock | 6.8339 | 6.8464 | 6.8146 | 6.8357 | 12952296.0 |
| 2009-11-04 10:05:00 | AAPL | Stock | 6.835 | 6.8446 | 6.8229 | 6.8389 | 9483208.0 |
| 2009-11-04 10:10:00 | AAPL | Stock | 6.84 | 6.8464 | 6.8329 | 6.8411 | 8284920.0 |
| 2009-11-04 10:15:00 | AAPL | Stock | 6.8407 | 6.8446 | 6.8339 | 6.8389 | 5744284.0 |
| 2009-11-04 10:20:00 | AAPL | Stock | 6.8393 | 6.85 | 6.8393 | 6.8451 | 6307728.0 |
| 2009-11-04 10:25:00 | AAPL | Stock | 6.845 | 6.8561 | 6.8429 | 6.8561 | 6011152.0 |
| 2009-11-04 10:30:00 | AAPL | Stock | 6.8561 | 6.8689 | 6.8559 | 6.8671 | 8712704.0 |
| 2009-11-04 10:35:00 | AAPL | Stock | 6.8668 | 6.8739 | 6.8554 | 6.8657 | 6925548.0 |
| 2009-11-04 10:40:00 | AAPL | Stock | 6.8668 | 6.8714 | 6.8625 | 6.8707 | 4889920.0 |
| 2009-11-04 10:45:00 | AAPL | Stock | 6.8704 | 6.8839 | 6.87 | 6.8821 | 7588140.0 |
| 2009-11-04 10:50:00 | AAPL | Stock | 6.8829 | 6.9089 | 6.8821 | 6.905 | 10522540.0 |
| 2009-11-04 10:55:00 | AAPL | Stock | 6.9039 | 6.9232 | 6.8654 | 6.9218 | 9054920.0 |
| 2009-11-04 11:00:00 | AAPL | Stock | 6.9218 | 6.9221 | 6.8964 | 6.9052 | 10628856.0 |
| 2009-11-04 11:05:00 | AAPL | Stock | 6.9039 | 6.9161 | 6.8982 | 6.8996 | 6968332.0 |
| 2009-11-04 11:10:00 | AAPL | Stock | 6.8989 | 6.9057 | 6.895 | 6.8955 | 3810240.0 |
| 2009-11-04 11:15:00 | AAPL | Stock | 6.895 | 6.9096 | 6.895 | 6.9089 | 4020408.0 |
> showing 50 of 326,376 rows — these rows as CSV