PREVIEW / stock_30min / 2007-09-13
file: by_date/stock_30min/2007/2007-09-13.parquet size: 1.1 MB rows: 62,922 symbols: 3,092
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-09-13 09:30:00 | AAPL | Stock | 4.9582 | 4.9643 | 4.9189 | 4.9504 | 103432840.0 |
| 2007-09-13 10:00:00 | AAPL | Stock | 4.9511 | 4.9543 | 4.92 | 4.9304 | 72172324.0 |
| 2007-09-13 10:30:00 | AAPL | Stock | 4.93 | 4.9329 | 4.9043 | 4.9167 | 54835060.0 |
| 2007-09-13 11:00:00 | AAPL | Stock | 4.9168 | 4.9384 | 4.9136 | 4.9318 | 37295496.0 |
| 2007-09-13 11:30:00 | AAPL | Stock | 4.9318 | 4.9329 | 4.9129 | 4.9193 | 26906516.0 |
| 2007-09-13 12:00:00 | AAPL | Stock | 4.9193 | 4.9268 | 4.9118 | 4.9204 | 23312016.0 |
| 2007-09-13 12:30:00 | AAPL | Stock | 4.92 | 4.9239 | 4.9054 | 4.9132 | 20281716.0 |
| 2007-09-13 13:00:00 | AAPL | Stock | 4.9129 | 4.9246 | 4.9057 | 4.9071 | 30762424.0 |
| 2007-09-13 13:30:00 | AAPL | Stock | 4.9071 | 4.9129 | 4.8893 | 4.8956 | 38159016.0 |
| 2007-09-13 14:00:00 | AAPL | Stock | 4.8954 | 4.9014 | 4.8825 | 4.8907 | 34722044.0 |
| 2007-09-13 14:30:00 | AAPL | Stock | 4.8889 | 4.91 | 4.8864 | 4.8996 | 36811768.0 |
| 2007-09-13 15:00:00 | AAPL | Stock | 4.8996 | 4.9054 | 4.8804 | 4.8921 | 39961348.0 |
| 2007-09-13 15:30:00 | AAPL | Stock | 4.8925 | 4.9076 | 4.8821 | 4.9007 | 52998848.0 |
| 2007-09-13 16:00:00 | AAPL | Stock | 4.904 | 4.904 | 4.8996 | 4.9 | 9367960.0 |
| 2007-09-13 09:30:00 | MSFT | Stock | 29.12 | 29.12 | 28.98 | 29.01 | 3007806.0 |
| 2007-09-13 10:00:00 | MSFT | Stock | 29.01 | 29.09 | 28.96 | 29.07 | 1736717.0 |
| 2007-09-13 10:30:00 | MSFT | Stock | 29.08 | 29.1 | 29.05 | 29.09 | 1410098.0 |
| 2007-09-13 11:00:00 | MSFT | Stock | 29.097 | 29.14 | 29.07 | 29.14 | 1392479.0 |
| 2007-09-13 11:30:00 | MSFT | Stock | 29.13 | 29.14 | 29.03 | 29.08 | 1447796.0 |
| 2007-09-13 12:00:00 | MSFT | Stock | 29.09 | 29.14 | 29.06 | 29.11 | 1190292.0 |
| 2007-09-13 12:30:00 | MSFT | Stock | 29.11 | 29.12 | 29.07 | 29.09 | 813118.0 |
| 2007-09-13 13:00:00 | MSFT | Stock | 29.09 | 29.13 | 29.05 | 29.09 | 1838363.0 |
| 2007-09-13 13:30:00 | MSFT | Stock | 29.08 | 29.1 | 29.08 | 29.08 | 945793.0 |
| 2007-09-13 14:00:00 | MSFT | Stock | 29.09 | 29.12 | 29.08 | 29.09 | 1198407.0 |
| 2007-09-13 14:30:00 | MSFT | Stock | 29.09 | 29.18 | 29.09 | 29.15 | 2122439.0 |
| 2007-09-13 15:00:00 | MSFT | Stock | 29.16 | 29.19 | 29.11 | 29.19 | 2837737.0 |
| 2007-09-13 15:30:00 | MSFT | Stock | 29.19 | 29.26 | 29.14 | 29.15 | 5736403.0 |
| 2007-09-13 16:00:00 | MSFT | Stock | 29.16 | 29.16 | 29.16 | 29.16 | 1586607.0 |
| 2007-09-13 08:00:00 | NVDA | Stock | 0.8358 | 0.8358 | 0.8358 | 0.8358 | 7000.0 |
| 2007-09-13 08:30:00 | NVDA | Stock | 0.8363 | 0.8425 | 0.8363 | 0.8425 | 125600.0 |
| 2007-09-13 09:00:00 | NVDA | Stock | 0.8425 | 0.8908 | 0.8368 | 0.848 | 1412680.0 |
| 2007-09-13 09:30:00 | NVDA | Stock | 0.8462 | 0.8472 | 0.826 | 0.836 | 68823160.0 |
| 2007-09-13 10:00:00 | NVDA | Stock | 0.8358 | 0.8385 | 0.827 | 0.8308 | 40374200.0 |
| 2007-09-13 10:30:00 | NVDA | Stock | 0.831 | 0.8332 | 0.8283 | 0.83 | 21409360.0 |
| 2007-09-13 11:00:00 | NVDA | Stock | 0.8302 | 0.8322 | 0.828 | 0.8308 | 28120840.0 |
| 2007-09-13 11:30:00 | NVDA | Stock | 0.8308 | 0.832 | 0.8262 | 0.8317 | 25236680.0 |
| 2007-09-13 12:00:00 | NVDA | Stock | 0.8315 | 0.8322 | 0.8285 | 0.8298 | 16324840.0 |
| 2007-09-13 12:30:00 | NVDA | Stock | 0.83 | 0.832 | 0.829 | 0.8305 | 25012000.0 |
| 2007-09-13 13:00:00 | NVDA | Stock | 0.8305 | 0.8338 | 0.8298 | 0.832 | 23905440.0 |
| 2007-09-13 13:30:00 | NVDA | Stock | 0.832 | 0.8338 | 0.832 | 0.8335 | 14284440.0 |
| 2007-09-13 14:00:00 | NVDA | Stock | 0.8335 | 0.835 | 0.831 | 0.831 | 22899320.0 |
| 2007-09-13 14:30:00 | NVDA | Stock | 0.8312 | 0.8368 | 0.8308 | 0.8349 | 20005160.0 |
| 2007-09-13 15:00:00 | NVDA | Stock | 0.8348 | 0.836 | 0.8298 | 0.8315 | 26777840.0 |
| 2007-09-13 15:30:00 | NVDA | Stock | 0.8315 | 0.8325 | 0.8248 | 0.8305 | 50098520.0 |
| 2007-09-13 16:00:00 | NVDA | Stock | 0.8305 | 0.8308 | 0.8275 | 0.8275 | 18918040.0 |
| 2007-09-13 16:30:00 | NVDA | Stock | 0.8298 | 0.8298 | 0.8298 | 0.8298 | 20000.0 |
| 2007-09-13 17:00:00 | NVDA | Stock | 0.8278 | 0.8285 | 0.8275 | 0.8285 | 88000.0 |
| 2007-09-13 17:30:00 | NVDA | Stock | 0.8285 | 0.8298 | 0.8285 | 0.8298 | 48000.0 |
| 2007-09-13 18:00:00 | NVDA | Stock | 0.83 | 0.83 | 0.83 | 0.83 | 24000.0 |
| 2007-09-13 19:30:00 | NVDA | Stock | 0.8298 | 0.8298 | 0.8298 | 0.8298 | 4000.0 |
> showing 50 of 62,922 rows — these rows as CSV