PREVIEW / stock_30min / 2007-10-12
file: by_date/stock_30min/2007/2007-10-12.parquet size: 1.2 MB rows: 65,979 symbols: 3,140
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-10-12 05:30:00 | AAPL | Stock | 5.7857 | 5.7857 | 5.7857 | 5.7857 | 19600.0 |
| 2007-10-12 07:00:00 | AAPL | Stock | 5.7857 | 5.8279 | 5.7857 | 5.8214 | 343084.0 |
| 2007-10-12 07:30:00 | AAPL | Stock | 5.825 | 5.8357 | 5.8161 | 5.8161 | 277172.0 |
| 2007-10-12 08:00:00 | AAPL | Stock | 5.8146 | 5.8339 | 5.7929 | 5.8143 | 4623976.0 |
| 2007-10-12 08:30:00 | AAPL | Stock | 5.8143 | 5.8836 | 5.8143 | 5.8711 | 7693784.0 |
| 2007-10-12 09:00:00 | AAPL | Stock | 5.8714 | 5.8714 | 5.8204 | 5.8225 | 7545216.0 |
| 2007-10-12 09:30:00 | AAPL | Stock | 5.8221 | 5.8754 | 5.7786 | 5.8579 | 160264944.0 |
| 2007-10-12 10:00:00 | AAPL | Stock | 5.8586 | 5.9461 | 5.8414 | 5.9361 | 149574152.0 |
| 2007-10-12 10:30:00 | AAPL | Stock | 5.9354 | 5.9554 | 5.9107 | 5.9357 | 82561724.0 |
| 2007-10-12 11:00:00 | AAPL | Stock | 5.9357 | 5.9618 | 5.9232 | 5.9345 | 71716540.0 |
| 2007-10-12 11:30:00 | AAPL | Stock | 5.9344 | 5.9405 | 5.9164 | 5.9189 | 45289720.0 |
| 2007-10-12 12:00:00 | AAPL | Stock | 5.9196 | 5.9396 | 5.8946 | 5.9279 | 57168328.0 |
| 2007-10-12 12:30:00 | AAPL | Stock | 5.9286 | 5.9444 | 5.9161 | 5.9347 | 44201556.0 |
| 2007-10-12 13:00:00 | AAPL | Stock | 5.935 | 5.9361 | 5.885 | 5.9054 | 54605684.0 |
| 2007-10-12 13:30:00 | AAPL | Stock | 5.9043 | 5.9357 | 5.8971 | 5.9154 | 42224700.0 |
| 2007-10-12 14:00:00 | AAPL | Stock | 5.9157 | 5.9504 | 5.9129 | 5.9321 | 44817276.0 |
| 2007-10-12 14:30:00 | AAPL | Stock | 5.9321 | 5.9661 | 5.9321 | 5.9518 | 49645400.0 |
| 2007-10-12 15:00:00 | AAPL | Stock | 5.9518 | 5.9621 | 5.9168 | 5.9214 | 59984512.0 |
| 2007-10-12 15:30:00 | AAPL | Stock | 5.9218 | 5.9743 | 5.9204 | 5.9739 | 83635944.0 |
| 2007-10-12 16:00:00 | AAPL | Stock | 5.9721 | 5.9811 | 5.8252 | 5.9768 | 17888388.0 |
| 2007-10-12 16:30:00 | AAPL | Stock | 5.9814 | 5.9857 | 5.9143 | 5.9821 | 2323300.0 |
| 2007-10-12 17:00:00 | AAPL | Stock | 5.9804 | 5.9893 | 5.9804 | 5.9821 | 306124.0 |
| 2007-10-12 17:30:00 | AAPL | Stock | 5.9821 | 5.9911 | 5.9821 | 5.9889 | 327040.0 |
| 2007-10-12 18:00:00 | AAPL | Stock | 5.9889 | 5.9964 | 5.9732 | 5.9732 | 705656.0 |
| 2007-10-12 18:30:00 | AAPL | Stock | 5.9957 | 5.9986 | 5.9893 | 5.9982 | 66164.0 |
| 2007-10-12 19:00:00 | AAPL | Stock | 5.9982 | 6.0 | 5.9936 | 5.9936 | 216132.0 |
| 2007-10-12 19:30:00 | AAPL | Stock | 5.9982 | 6.0 | 5.9939 | 5.9964 | 198324.0 |
| 2007-10-12 07:30:00 | MSFT | Stock | 29.9 | 29.9 | 29.9 | 29.9 | 200.0 |
| 2007-10-12 08:00:00 | MSFT | Stock | 29.71 | 29.98 | 29.71 | 29.97 | 2515.0 |
| 2007-10-12 08:30:00 | MSFT | Stock | 29.95 | 30.02 | 29.9 | 30.0 | 19403.0 |
| 2007-10-12 09:00:00 | MSFT | Stock | 30.02 | 30.09 | 29.97 | 30.09 | 40508.0 |
| 2007-10-12 09:30:00 | MSFT | Stock | 30.04 | 30.29 | 29.95 | 30.28 | 3341170.0 |
| 2007-10-12 10:00:00 | MSFT | Stock | 30.29 | 30.34 | 30.26 | 30.31 | 3060368.0 |
| 2007-10-12 10:30:00 | MSFT | Stock | 30.32 | 30.33 | 30.22 | 30.27 | 1963922.0 |
| 2007-10-12 11:00:00 | MSFT | Stock | 30.27 | 30.38 | 30.24 | 30.38 | 2407904.0 |
| 2007-10-12 11:30:00 | MSFT | Stock | 30.385 | 30.4 | 30.34 | 30.36 | 1656147.0 |
| 2007-10-12 12:00:00 | MSFT | Stock | 30.36 | 30.36 | 30.26 | 30.32 | 1463212.0 |
| 2007-10-12 12:30:00 | MSFT | Stock | 30.32 | 30.34 | 30.27 | 30.32 | 1201800.0 |
| 2007-10-12 13:00:00 | MSFT | Stock | 30.31 | 30.37 | 30.25 | 30.29 | 1671173.0 |
| 2007-10-12 13:30:00 | MSFT | Stock | 30.28 | 30.32 | 30.26 | 30.29 | 1193027.0 |
| 2007-10-12 14:00:00 | MSFT | Stock | 30.29 | 30.38 | 30.28 | 30.32 | 1782003.0 |
| 2007-10-12 14:30:00 | MSFT | Stock | 30.33 | 30.33 | 30.19 | 30.19 | 2488030.0 |
| 2007-10-12 15:00:00 | MSFT | Stock | 30.19 | 30.22 | 30.1 | 30.11 | 2387946.0 |
| 2007-10-12 15:30:00 | MSFT | Stock | 30.11 | 30.19 | 30.1 | 30.17 | 4061509.0 |
| 2007-10-12 16:00:00 | MSFT | Stock | 30.16 | 30.263 | 30.15 | 30.17 | 1660187.0 |
| 2007-10-12 16:30:00 | MSFT | Stock | 30.17 | 30.325 | 30.17 | 30.17 | 692411.0 |
| 2007-10-12 17:00:00 | MSFT | Stock | 30.18 | 30.22 | 30.17 | 30.19 | 6400.0 |
| 2007-10-12 17:30:00 | MSFT | Stock | 30.22 | 30.22 | 30.22 | 30.22 | 300.0 |
| 2007-10-12 18:00:00 | MSFT | Stock | 30.22 | 30.22 | 30.17 | 30.17 | 22347.0 |
| 2007-10-12 18:30:00 | MSFT | Stock | 30.21 | 30.21 | 30.19 | 30.19 | 1500.0 |
> showing 50 of 65,979 rows — these rows as CSV