PREVIEW / stock_30min / 2007-12-11
file: by_date/stock_30min/2007/2007-12-11.parquet size: 1.2 MB rows: 70,008 symbols: 3,230
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-12-11 06:30:00 | AAPL | Stock | 6.9071 | 6.9071 | 6.9043 | 6.9043 | 5600.0 |
| 2007-12-11 07:00:00 | AAPL | Stock | 6.9286 | 6.9286 | 6.9286 | 6.9286 | 9100.0 |
| 2007-12-11 07:30:00 | AAPL | Stock | 6.9318 | 6.9625 | 6.9318 | 6.9571 | 276164.0 |
| 2007-12-11 08:00:00 | AAPL | Stock | 6.9589 | 6.9589 | 6.9464 | 6.9504 | 999768.0 |
| 2007-12-11 08:30:00 | AAPL | Stock | 6.95 | 6.9564 | 6.9414 | 6.955 | 578956.0 |
| 2007-12-11 09:00:00 | AAPL | Stock | 6.9564 | 6.9643 | 6.9464 | 6.9568 | 1818488.0 |
| 2007-12-11 09:30:00 | AAPL | Stock | 6.9568 | 6.9836 | 6.9446 | 6.9629 | 85701224.0 |
| 2007-12-11 10:00:00 | AAPL | Stock | 6.9621 | 6.9904 | 6.9532 | 6.9791 | 56659568.0 |
| 2007-12-11 10:30:00 | AAPL | Stock | 6.9789 | 6.9961 | 6.9714 | 6.9936 | 55684608.0 |
| 2007-12-11 11:00:00 | AAPL | Stock | 6.9936 | 7.0296 | 6.9918 | 7.0261 | 77031304.0 |
| 2007-12-11 11:30:00 | AAPL | Stock | 7.0257 | 7.0271 | 6.9871 | 7.0146 | 48156080.0 |
| 2007-12-11 12:00:00 | AAPL | Stock | 7.015 | 7.0154 | 6.9964 | 7.0018 | 21724528.0 |
| 2007-12-11 12:30:00 | AAPL | Stock | 7.0025 | 7.0171 | 6.9982 | 7.0121 | 24232936.0 |
| 2007-12-11 13:00:00 | AAPL | Stock | 7.0121 | 7.0179 | 7.0018 | 7.0032 | 25603536.0 |
| 2007-12-11 13:30:00 | AAPL | Stock | 7.0021 | 7.0066 | 6.9821 | 7.0021 | 48264888.0 |
| 2007-12-11 14:00:00 | AAPL | Stock | 7.0029 | 7.0068 | 6.7896 | 6.905 | 178354680.0 |
| 2007-12-11 14:30:00 | AAPL | Stock | 6.9046 | 6.9204 | 6.7343 | 6.835 | 199990224.0 |
| 2007-12-11 15:00:00 | AAPL | Stock | 6.8361 | 6.8821 | 6.7429 | 6.7879 | 120164716.0 |
| 2007-12-11 15:30:00 | AAPL | Stock | 6.7882 | 6.805 | 6.6925 | 6.7271 | 146151572.0 |
| 2007-12-11 16:00:00 | AAPL | Stock | 6.7364 | 6.8889 | 6.7096 | 6.7186 | 13153840.0 |
| 2007-12-11 16:30:00 | AAPL | Stock | 6.7207 | 6.9339 | 6.7143 | 6.7179 | 891324.0 |
| 2007-12-11 17:00:00 | AAPL | Stock | 6.7143 | 6.9339 | 6.7143 | 6.7164 | 2309496.0 |
| 2007-12-11 17:30:00 | AAPL | Stock | 6.9339 | 6.9339 | 6.7104 | 6.7179 | 894180.0 |
| 2007-12-11 18:00:00 | AAPL | Stock | 6.7154 | 6.7268 | 6.7143 | 6.7232 | 899612.0 |
| 2007-12-11 18:30:00 | AAPL | Stock | 6.725 | 6.7304 | 6.7196 | 6.7243 | 431228.0 |
| 2007-12-11 19:00:00 | AAPL | Stock | 6.7286 | 6.7389 | 6.7286 | 6.7379 | 635348.0 |
| 2007-12-11 19:30:00 | AAPL | Stock | 6.7357 | 6.7464 | 6.7321 | 6.7393 | 451080.0 |
| 2007-12-11 07:00:00 | MSFT | Stock | 34.9 | 34.9 | 34.9 | 34.9 | 700.0 |
| 2007-12-11 08:00:00 | MSFT | Stock | 34.92 | 34.93 | 34.82 | 34.91 | 800.0 |
| 2007-12-11 08:30:00 | MSFT | Stock | 34.86 | 34.86 | 34.84 | 34.86 | 600.0 |
| 2007-12-11 09:00:00 | MSFT | Stock | 34.87 | 34.87 | 34.73 | 34.75 | 17933.0 |
| 2007-12-11 09:30:00 | MSFT | Stock | 34.73 | 34.89 | 34.6 | 34.65 | 3904941.0 |
| 2007-12-11 10:00:00 | MSFT | Stock | 34.65 | 34.75 | 34.61 | 34.68 | 2384163.0 |
| 2007-12-11 10:30:00 | MSFT | Stock | 34.69 | 34.72 | 34.61 | 34.66 | 2492583.0 |
| 2007-12-11 11:00:00 | MSFT | Stock | 34.66 | 34.82 | 34.65 | 34.81 | 2521032.0 |
| 2007-12-11 11:30:00 | MSFT | Stock | 34.82 | 34.93 | 34.72 | 34.91 | 2606440.0 |
| 2007-12-11 12:00:00 | MSFT | Stock | 34.91 | 34.99 | 34.86 | 34.98 | 1915231.0 |
| 2007-12-11 12:30:00 | MSFT | Stock | 34.99 | 34.99 | 34.92 | 34.94 | 1280313.0 |
| 2007-12-11 13:00:00 | MSFT | Stock | 34.95 | 34.98 | 34.89 | 34.92 | 1579443.0 |
| 2007-12-11 13:30:00 | MSFT | Stock | 34.925 | 34.98 | 34.88 | 34.98 | 1741999.0 |
| 2007-12-11 14:00:00 | MSFT | Stock | 34.972 | 34.99 | 34.17 | 34.39 | 8272190.0 |
| 2007-12-11 14:30:00 | MSFT | Stock | 34.38 | 34.46 | 34.09 | 34.3 | 5328535.0 |
| 2007-12-11 15:00:00 | MSFT | Stock | 34.3 | 34.32 | 33.97 | 34.14 | 6372815.0 |
| 2007-12-11 15:30:00 | MSFT | Stock | 34.145 | 34.22 | 33.93 | 34.15 | 9460031.0 |
| 2007-12-11 16:00:00 | MSFT | Stock | 34.16 | 34.472 | 34.08 | 34.16 | 4599006.0 |
| 2007-12-11 16:30:00 | MSFT | Stock | 34.183 | 34.76 | 34.04 | 34.76 | 198139.0 |
| 2007-12-11 17:00:00 | MSFT | Stock | 34.1 | 34.85 | 34.1 | 34.76 | 329471.0 |
| 2007-12-11 17:30:00 | MSFT | Stock | 34.1 | 34.12 | 34.1 | 34.12 | 120200.0 |
| 2007-12-11 18:00:00 | MSFT | Stock | 34.12 | 34.12 | 34.1 | 34.1 | 2100.0 |
| 2007-12-11 18:30:00 | MSFT | Stock | 34.12 | 34.12 | 34.1 | 34.1 | 400.0 |
> showing 50 of 70,008 rows — these rows as CSV