PREVIEW / stock_30min / 2010-07-16
file: by_date/stock_30min/2010/2010-07-16.parquet size: 1.3 MB rows: 71,453 symbols: 3,439
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 |
|---|---|---|---|---|---|---|---|
| 2010-07-16 05:30:00 | AAPL | Stock | 9.0214 | 9.0214 | 9.0214 | 9.0214 | 2800.0 |
| 2010-07-16 06:30:00 | AAPL | Stock | 9.0286 | 9.0357 | 9.0286 | 9.0357 | 39200.0 |
| 2010-07-16 07:00:00 | AAPL | Stock | 9.0307 | 9.0589 | 9.0025 | 9.0443 | 160188.0 |
| 2010-07-16 07:30:00 | AAPL | Stock | 9.0314 | 9.0314 | 8.9929 | 9.0104 | 209160.0 |
| 2010-07-16 08:00:00 | AAPL | Stock | 9.0104 | 9.0307 | 8.9968 | 9.0179 | 840112.0 |
| 2010-07-16 08:30:00 | AAPL | Stock | 9.0125 | 9.0643 | 9.0093 | 9.0286 | 1769628.0 |
| 2010-07-16 09:00:00 | AAPL | Stock | 9.0321 | 9.0421 | 8.9804 | 9.0375 | 2924908.0 |
| 2010-07-16 09:30:00 | AAPL | Stock | 9.0375 | 9.0571 | 8.9646 | 8.9925 | 128942492.0 |
| 2010-07-16 10:00:00 | AAPL | Stock | 8.9914 | 9.0111 | 8.9475 | 8.9629 | 66395364.0 |
| 2010-07-16 10:30:00 | AAPL | Stock | 8.9625 | 8.9739 | 8.9143 | 8.9411 | 49539000.0 |
| 2010-07-16 11:00:00 | AAPL | Stock | 8.9393 | 8.9561 | 8.9039 | 8.935 | 36007412.0 |
| 2010-07-16 11:30:00 | AAPL | Stock | 8.935 | 8.9361 | 8.8946 | 8.8946 | 35012292.0 |
| 2010-07-16 12:00:00 | AAPL | Stock | 8.8946 | 8.9225 | 8.8718 | 8.91 | 37285080.0 |
| 2010-07-16 12:30:00 | AAPL | Stock | 8.9107 | 8.9464 | 8.9 | 8.9274 | 41164424.0 |
| 2010-07-16 13:00:00 | AAPL | Stock | 8.928 | 8.9982 | 8.8829 | 8.9764 | 132082580.0 |
| 2010-07-16 13:30:00 | AAPL | Stock | 8.9732 | 9.1061 | 8.9482 | 8.9857 | 212649220.0 |
| 2010-07-16 14:00:00 | AAPL | Stock | 8.9844 | 9.0293 | 8.965 | 9.0121 | 57625176.0 |
| 2010-07-16 14:30:00 | AAPL | Stock | 9.0136 | 9.0339 | 8.9911 | 9.0147 | 41254220.0 |
| 2010-07-16 15:00:00 | AAPL | Stock | 9.0164 | 9.0232 | 8.9471 | 8.9686 | 51696176.0 |
| 2010-07-16 15:30:00 | AAPL | Stock | 8.9675 | 8.9832 | 8.9236 | 8.9236 | 102493328.0 |
| 2010-07-16 16:00:00 | AAPL | Stock | 8.9264 | 8.9784 | 8.9232 | 8.9286 | 26858048.0 |
| 2010-07-16 16:30:00 | AAPL | Stock | 8.9286 | 8.9404 | 8.9254 | 8.9268 | 1019116.0 |
| 2010-07-16 17:00:00 | AAPL | Stock | 8.9268 | 8.9286 | 8.925 | 8.9268 | 1279488.0 |
| 2010-07-16 17:30:00 | AAPL | Stock | 8.9286 | 8.9286 | 8.925 | 8.9279 | 289828.0 |
| 2010-07-16 18:00:00 | AAPL | Stock | 8.9264 | 8.9264 | 8.9107 | 8.9196 | 448728.0 |
| 2010-07-16 18:30:00 | AAPL | Stock | 8.9232 | 8.9232 | 8.9107 | 8.9193 | 133420.0 |
| 2010-07-16 19:00:00 | AAPL | Stock | 8.9232 | 8.9264 | 8.9189 | 8.9189 | 81900.0 |
| 2010-07-16 19:30:00 | AAPL | Stock | 8.9175 | 8.9304 | 8.9143 | 8.9304 | 314524.0 |
| 2010-07-16 20:00:00 | AAPL | Stock | 8.9186 | 8.9889 | 8.9186 | 8.9889 | 427000.0 |
| 2010-07-16 07:00:00 | MSFT | Stock | 25.65 | 25.65 | 25.65 | 25.65 | 188.0 |
| 2010-07-16 07:30:00 | MSFT | Stock | 25.52 | 25.6 | 25.52 | 25.6 | 1788.0 |
| 2010-07-16 08:00:00 | MSFT | Stock | 25.52 | 25.52 | 25.46 | 25.48 | 4200.0 |
| 2010-07-16 08:30:00 | MSFT | Stock | 25.5 | 25.52 | 25.38 | 25.4 | 10800.0 |
| 2010-07-16 09:00:00 | MSFT | Stock | 25.41 | 25.55 | 25.36 | 25.55 | 54172.0 |
| 2010-07-16 09:30:00 | MSFT | Stock | 25.51 | 25.64 | 25.19 | 25.19 | 5977331.0 |
| 2010-07-16 10:00:00 | MSFT | Stock | 25.19 | 25.25 | 24.98 | 25.08 | 7264174.0 |
| 2010-07-16 10:30:00 | MSFT | Stock | 25.08 | 25.09 | 24.98 | 25.04 | 4407062.0 |
| 2010-07-16 11:00:00 | MSFT | Stock | 25.045 | 25.06 | 24.94 | 24.98 | 2881364.0 |
| 2010-07-16 11:30:00 | MSFT | Stock | 24.98 | 25.03 | 24.93 | 24.98 | 3293029.0 |
| 2010-07-16 12:00:00 | MSFT | Stock | 24.98 | 25.0 | 24.88 | 24.995 | 2473771.0 |
| 2010-07-16 12:30:00 | MSFT | Stock | 24.985 | 25.04 | 24.94 | 24.97 | 2001744.0 |
| 2010-07-16 13:00:00 | MSFT | Stock | 24.969 | 25.0 | 24.91 | 24.97 | 2305115.0 |
| 2010-07-16 13:30:00 | MSFT | Stock | 24.96 | 25.04 | 24.94 | 25.025 | 2880436.0 |
| 2010-07-16 14:00:00 | MSFT | Stock | 25.025 | 25.05 | 24.97 | 25.01 | 2496155.0 |
| 2010-07-16 14:30:00 | MSFT | Stock | 25.009 | 25.03 | 24.97 | 24.99 | 2016440.0 |
| 2010-07-16 15:00:00 | MSFT | Stock | 24.99 | 25.02 | 24.9 | 24.93 | 3610944.0 |
| 2010-07-16 15:30:00 | MSFT | Stock | 24.93 | 24.99 | 24.88 | 24.91 | 10881472.0 |
| 2010-07-16 16:00:00 | MSFT | Stock | 24.91 | 25.1 | 24.83 | 24.95 | 4410270.0 |
| 2010-07-16 16:30:00 | MSFT | Stock | 24.94 | 24.95 | 24.9 | 24.9 | 91600.0 |
| 2010-07-16 17:00:00 | MSFT | Stock | 25.51 | 25.51 | 24.9 | 24.9 | 1500.0 |
> showing 50 of 71,453 rows — these rows as CSV