PREVIEW / stock_30min / 2009-06-19
file: by_date/stock_30min/2009/2009-06-19.parquet size: 1.3 MB rows: 70,976 symbols: 3,331
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-06-19 04:30:00 | AAPL | Stock | 4.8871 | 4.8871 | 4.8871 | 4.8871 | 2800.0 |
| 2009-06-19 07:00:00 | AAPL | Stock | 4.9207 | 4.9218 | 4.8843 | 4.9107 | 111300.0 |
| 2009-06-19 07:30:00 | AAPL | Stock | 4.9036 | 4.9193 | 4.9036 | 4.9132 | 530880.0 |
| 2009-06-19 08:00:00 | AAPL | Stock | 4.9132 | 4.935 | 4.9132 | 4.9321 | 2435636.0 |
| 2009-06-19 08:30:00 | AAPL | Stock | 4.9268 | 4.9429 | 4.9229 | 4.9375 | 1947232.0 |
| 2009-06-19 09:00:00 | AAPL | Stock | 4.9371 | 4.9429 | 4.9196 | 4.9293 | 2902424.0 |
| 2009-06-19 09:30:00 | AAPL | Stock | 4.9289 | 4.9575 | 4.9025 | 4.9518 | 110548536.0 |
| 2009-06-19 10:00:00 | AAPL | Stock | 4.9514 | 4.9693 | 4.9429 | 4.9504 | 62068608.0 |
| 2009-06-19 10:30:00 | AAPL | Stock | 4.9507 | 4.9643 | 4.9464 | 4.9552 | 29284640.0 |
| 2009-06-19 11:00:00 | AAPL | Stock | 4.9557 | 4.9564 | 4.9357 | 4.9386 | 31979444.0 |
| 2009-06-19 11:30:00 | AAPL | Stock | 4.9382 | 4.9474 | 4.9261 | 4.9386 | 23534532.0 |
| 2009-06-19 12:00:00 | AAPL | Stock | 4.9386 | 4.9411 | 4.91 | 4.9125 | 27519548.0 |
| 2009-06-19 12:30:00 | AAPL | Stock | 4.9121 | 4.9207 | 4.9039 | 4.9084 | 29382668.0 |
| 2009-06-19 13:00:00 | AAPL | Stock | 4.9089 | 4.9207 | 4.9046 | 4.9136 | 23118704.0 |
| 2009-06-19 13:30:00 | AAPL | Stock | 4.9132 | 4.9271 | 4.9132 | 4.9193 | 23424044.0 |
| 2009-06-19 14:00:00 | AAPL | Stock | 4.9193 | 4.9232 | 4.8893 | 4.8971 | 36723204.0 |
| 2009-06-19 14:30:00 | AAPL | Stock | 4.8971 | 4.9261 | 4.8961 | 4.9236 | 29251208.0 |
| 2009-06-19 15:00:00 | AAPL | Stock | 4.9236 | 4.9643 | 4.9218 | 4.9639 | 54691588.0 |
| 2009-06-19 15:30:00 | AAPL | Stock | 4.9639 | 4.9821 | 4.9568 | 4.9796 | 89821228.0 |
| 2009-06-19 16:00:00 | AAPL | Stock | 4.9804 | 4.9822 | 4.9379 | 4.9732 | 30288916.0 |
| 2009-06-19 16:30:00 | AAPL | Stock | 4.9814 | 4.9989 | 4.9732 | 4.9954 | 9306584.0 |
| 2009-06-19 17:00:00 | AAPL | Stock | 4.9946 | 4.9946 | 4.9814 | 4.9882 | 594664.0 |
| 2009-06-19 17:30:00 | AAPL | Stock | 4.9904 | 4.9911 | 4.9886 | 4.9893 | 76972.0 |
| 2009-06-19 18:00:00 | AAPL | Stock | 4.9893 | 4.9921 | 4.9814 | 4.9921 | 1233148.0 |
| 2009-06-19 18:30:00 | AAPL | Stock | 4.9918 | 4.9939 | 4.9875 | 4.9875 | 424732.0 |
| 2009-06-19 19:00:00 | AAPL | Stock | 4.9904 | 4.9921 | 4.9893 | 4.9921 | 30576.0 |
| 2009-06-19 19:30:00 | AAPL | Stock | 4.9929 | 4.995 | 4.9893 | 4.9939 | 140952.0 |
| 2009-06-19 05:30:00 | MSFT | Stock | 23.79 | 23.99 | 23.79 | 23.99 | 900.0 |
| 2009-06-19 06:00:00 | MSFT | Stock | 24.1 | 24.1 | 24.1 | 24.1 | 2500.0 |
| 2009-06-19 06:30:00 | MSFT | Stock | 24.08 | 24.15 | 24.02 | 24.05 | 25786.0 |
| 2009-06-19 07:00:00 | MSFT | Stock | 24.04 | 24.05 | 24.0 | 24.02 | 73100.0 |
| 2009-06-19 07:30:00 | MSFT | Stock | 24.02 | 24.05 | 23.96 | 23.99 | 179670.0 |
| 2009-06-19 08:00:00 | MSFT | Stock | 23.99 | 24.02 | 23.92 | 23.98 | 190653.0 |
| 2009-06-19 08:30:00 | MSFT | Stock | 23.97 | 24.1 | 23.97 | 24.05 | 264757.0 |
| 2009-06-19 09:00:00 | MSFT | Stock | 24.03 | 24.1 | 24.0 | 24.05 | 183242.0 |
| 2009-06-19 09:30:00 | MSFT | Stock | 24.04 | 24.34 | 23.75 | 24.19 | 36847219.0 |
| 2009-06-19 10:00:00 | MSFT | Stock | 24.19 | 24.27 | 24.13 | 24.25 | 8474886.0 |
| 2009-06-19 10:30:00 | MSFT | Stock | 24.25 | 24.31 | 24.2 | 24.298 | 8228532.0 |
| 2009-06-19 11:00:00 | MSFT | Stock | 24.29 | 24.32 | 24.17 | 24.17 | 6034614.0 |
| 2009-06-19 11:30:00 | MSFT | Stock | 24.18 | 24.19 | 24.13 | 24.15 | 4424090.0 |
| 2009-06-19 12:00:00 | MSFT | Stock | 24.15 | 24.19 | 24.02 | 24.049 | 4516378.0 |
| 2009-06-19 12:30:00 | MSFT | Stock | 24.05 | 24.11 | 24.0 | 24.09 | 4437333.0 |
| 2009-06-19 13:00:00 | MSFT | Stock | 24.1 | 24.16 | 24.03 | 24.04 | 3436252.0 |
| 2009-06-19 13:30:00 | MSFT | Stock | 24.04 | 24.21 | 23.95 | 24.15 | 3643420.0 |
| 2009-06-19 14:00:00 | MSFT | Stock | 24.15 | 24.18 | 24.07 | 24.1 | 4475712.0 |
| 2009-06-19 14:30:00 | MSFT | Stock | 24.11 | 24.19 | 24.07 | 24.12 | 3429789.0 |
| 2009-06-19 15:00:00 | MSFT | Stock | 24.112 | 24.25 | 24.1 | 24.25 | 4989167.0 |
| 2009-06-19 15:30:00 | MSFT | Stock | 24.24 | 24.28 | 24.06 | 24.09 | 11555949.0 |
| 2009-06-19 16:00:00 | MSFT | Stock | 24.08 | 24.148 | 24.05 | 24.07 | 4010719.0 |
| 2009-06-19 16:30:00 | MSFT | Stock | 24.07 | 24.108 | 24.06 | 24.06 | 696122.0 |
> showing 50 of 70,976 rows — these rows as CSV