PREVIEW / stock_30min / 2009-07-06
file: by_date/stock_30min/2009/2009-07-06.parquet size: 1.3 MB rows: 70,152 symbols: 3,341
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-07-06 08:00:00 | AAPL | Stock | 4.9679 | 4.9814 | 4.9375 | 4.9429 | 1106364.0 |
| 2009-07-06 08:30:00 | AAPL | Stock | 4.9425 | 4.955 | 4.9418 | 4.9536 | 246372.0 |
| 2009-07-06 09:00:00 | AAPL | Stock | 4.9536 | 4.9739 | 4.9529 | 4.9529 | 885192.0 |
| 2009-07-06 09:30:00 | AAPL | Stock | 4.9546 | 4.9639 | 4.875 | 4.8771 | 110586112.0 |
| 2009-07-06 10:00:00 | AAPL | Stock | 4.8775 | 4.8982 | 4.8661 | 4.8882 | 78752604.0 |
| 2009-07-06 10:30:00 | AAPL | Stock | 4.8886 | 4.9064 | 4.8843 | 4.9057 | 39245612.0 |
| 2009-07-06 11:00:00 | AAPL | Stock | 4.9057 | 4.9143 | 4.9018 | 4.9043 | 23454228.0 |
| 2009-07-06 11:30:00 | AAPL | Stock | 4.9039 | 4.9107 | 4.8864 | 4.8889 | 21796432.0 |
| 2009-07-06 12:00:00 | AAPL | Stock | 4.8886 | 4.9032 | 4.8814 | 4.8954 | 19002536.0 |
| 2009-07-06 12:30:00 | AAPL | Stock | 4.8961 | 4.8964 | 4.8718 | 4.8782 | 20199648.0 |
| 2009-07-06 13:00:00 | AAPL | Stock | 4.8778 | 4.9064 | 4.8736 | 4.895 | 26599580.0 |
| 2009-07-06 13:30:00 | AAPL | Stock | 4.895 | 4.8961 | 4.8857 | 4.895 | 13523636.0 |
| 2009-07-06 14:00:00 | AAPL | Stock | 4.8954 | 4.9186 | 4.8914 | 4.9186 | 26645024.0 |
| 2009-07-06 14:30:00 | AAPL | Stock | 4.9182 | 4.9307 | 4.9111 | 4.9243 | 23067520.0 |
| 2009-07-06 15:00:00 | AAPL | Stock | 4.9243 | 4.9386 | 4.9232 | 4.9325 | 29065120.0 |
| 2009-07-06 15:30:00 | AAPL | Stock | 4.9318 | 4.9593 | 4.9154 | 4.9504 | 50927268.0 |
| 2009-07-06 16:00:00 | AAPL | Stock | 4.9504 | 4.9564 | 4.9007 | 4.9546 | 7592900.0 |
| 2009-07-06 16:30:00 | AAPL | Stock | 4.9504 | 4.9821 | 4.9504 | 4.9679 | 2038008.0 |
| 2009-07-06 17:00:00 | AAPL | Stock | 4.9504 | 4.9786 | 4.9504 | 4.9661 | 176652.0 |
| 2009-07-06 17:30:00 | AAPL | Stock | 4.9661 | 4.9729 | 4.9661 | 4.9729 | 18200.0 |
| 2009-07-06 18:00:00 | AAPL | Stock | 4.9732 | 4.9764 | 4.9504 | 4.9707 | 572628.0 |
| 2009-07-06 18:30:00 | AAPL | Stock | 4.975 | 4.9764 | 4.9718 | 4.9764 | 58240.0 |
| 2009-07-06 19:00:00 | AAPL | Stock | 4.9721 | 4.9721 | 4.9721 | 4.9721 | 2800.0 |
| 2009-07-06 19:30:00 | AAPL | Stock | 4.9704 | 4.9704 | 4.965 | 4.9689 | 84028.0 |
| 2009-07-06 20:00:00 | AAPL | Stock | 4.8939 | 4.8939 | 4.8939 | 4.8939 | 162400.0 |
| 2009-07-06 07:00:00 | MSFT | Stock | 23.11 | 23.11 | 23.11 | 23.11 | 400.0 |
| 2009-07-06 07:30:00 | MSFT | Stock | 23.24 | 23.24 | 23.24 | 23.24 | 252.0 |
| 2009-07-06 08:00:00 | MSFT | Stock | 23.22 | 23.25 | 23.11 | 23.17 | 14955.0 |
| 2009-07-06 08:30:00 | MSFT | Stock | 23.17 | 23.28 | 23.16 | 23.23 | 10132.0 |
| 2009-07-06 09:00:00 | MSFT | Stock | 23.23 | 23.24 | 23.15 | 23.21 | 13904.0 |
| 2009-07-06 09:30:00 | MSFT | Stock | 23.21 | 23.28 | 23.0 | 23.15 | 6573526.0 |
| 2009-07-06 10:00:00 | MSFT | Stock | 23.155 | 23.23 | 22.87 | 22.93 | 6630754.0 |
| 2009-07-06 10:30:00 | MSFT | Stock | 22.94 | 23.06 | 22.9 | 23.03 | 3098558.0 |
| 2009-07-06 11:00:00 | MSFT | Stock | 23.02 | 23.07 | 23.01 | 23.02 | 2208370.0 |
| 2009-07-06 11:30:00 | MSFT | Stock | 23.01 | 23.025 | 22.95 | 22.97 | 2702200.0 |
| 2009-07-06 12:00:00 | MSFT | Stock | 22.96 | 23.0 | 22.96 | 22.97 | 1767311.0 |
| 2009-07-06 12:30:00 | MSFT | Stock | 22.96 | 23.05 | 22.92 | 23.01 | 2917427.0 |
| 2009-07-06 13:00:00 | MSFT | Stock | 23.01 | 23.11 | 23.01 | 23.05 | 2927144.0 |
| 2009-07-06 13:30:00 | MSFT | Stock | 23.05 | 23.1 | 23.03 | 23.07 | 1982131.0 |
| 2009-07-06 14:00:00 | MSFT | Stock | 23.07 | 23.2 | 23.06 | 23.14 | 3193501.0 |
| 2009-07-06 14:30:00 | MSFT | Stock | 23.15 | 23.2 | 23.07 | 23.2 | 2490294.0 |
| 2009-07-06 15:00:00 | MSFT | Stock | 23.2 | 23.25 | 23.14 | 23.14 | 2866485.0 |
| 2009-07-06 15:30:00 | MSFT | Stock | 23.14 | 23.25 | 23.05 | 23.2 | 6885188.0 |
| 2009-07-06 16:00:00 | MSFT | Stock | 23.2 | 23.23 | 23.078 | 23.21 | 1379627.0 |
| 2009-07-06 16:30:00 | MSFT | Stock | 23.2 | 23.2 | 23.17 | 23.17 | 217823.0 |
| 2009-07-06 17:00:00 | MSFT | Stock | 23.2 | 23.22 | 23.18 | 23.21 | 12185.0 |
| 2009-07-06 17:30:00 | MSFT | Stock | 23.22 | 23.22 | 23.22 | 23.22 | 200.0 |
| 2009-07-06 18:00:00 | MSFT | Stock | 23.22 | 23.22 | 23.18 | 23.18 | 4475.0 |
| 2009-07-06 18:30:00 | MSFT | Stock | 23.18 | 23.2 | 23.18 | 23.2 | 1750.0 |
| 2009-07-06 19:00:00 | MSFT | Stock | 23.2 | 23.2 | 23.2 | 23.2 | 200.0 |
> showing 50 of 70,152 rows — these rows as CSV