PREVIEW / stock_30min / 2008-11-04
file: by_date/stock_30min/2008/2008-11-04.parquet size: 1.2 MB rows: 70,216 symbols: 3,316
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 |
|---|---|---|---|---|---|---|---|
| 2008-11-04 05:00:00 | AAPL | Stock | 3.8904 | 3.8904 | 3.8904 | 3.8904 | 8400.0 |
| 2008-11-04 06:00:00 | AAPL | Stock | 3.8786 | 3.8786 | 3.8786 | 3.8786 | 2800.0 |
| 2008-11-04 06:30:00 | AAPL | Stock | 3.9239 | 3.9239 | 3.9239 | 3.9239 | 14000.0 |
| 2008-11-04 07:00:00 | AAPL | Stock | 3.9239 | 3.9261 | 3.9071 | 3.9232 | 137312.0 |
| 2008-11-04 07:30:00 | AAPL | Stock | 3.9268 | 3.9268 | 3.8911 | 3.8911 | 824768.0 |
| 2008-11-04 08:00:00 | AAPL | Stock | 3.8918 | 3.8964 | 3.8696 | 3.8875 | 2524200.0 |
| 2008-11-04 08:30:00 | AAPL | Stock | 3.8889 | 3.9029 | 3.8825 | 3.8982 | 2278528.0 |
| 2008-11-04 09:00:00 | AAPL | Stock | 3.8989 | 3.9279 | 3.8929 | 3.9279 | 4660068.0 |
| 2008-11-04 09:30:00 | AAPL | Stock | 3.9279 | 3.9282 | 3.8096 | 3.8321 | 168100520.0 |
| 2008-11-04 10:00:00 | AAPL | Stock | 3.8321 | 3.8729 | 3.8204 | 3.8639 | 93088352.0 |
| 2008-11-04 10:30:00 | AAPL | Stock | 3.8632 | 3.8814 | 3.8432 | 3.8536 | 109031384.0 |
| 2008-11-04 11:00:00 | AAPL | Stock | 3.8536 | 3.8732 | 3.8393 | 3.8404 | 96502952.0 |
| 2008-11-04 11:30:00 | AAPL | Stock | 3.8404 | 3.9264 | 3.8336 | 3.9157 | 127388100.0 |
| 2008-11-04 12:00:00 | AAPL | Stock | 3.9157 | 3.9554 | 3.9018 | 3.9254 | 108834068.0 |
| 2008-11-04 12:30:00 | AAPL | Stock | 3.9254 | 3.9411 | 3.9132 | 3.9268 | 62334496.0 |
| 2008-11-04 13:00:00 | AAPL | Stock | 3.9271 | 3.9704 | 3.9214 | 3.9671 | 65818004.0 |
| 2008-11-04 13:30:00 | AAPL | Stock | 3.9668 | 3.9925 | 3.9532 | 3.9732 | 82730060.0 |
| 2008-11-04 14:00:00 | AAPL | Stock | 3.9729 | 3.9743 | 3.9332 | 3.9614 | 79789136.0 |
| 2008-11-04 14:30:00 | AAPL | Stock | 3.9614 | 3.9661 | 3.9057 | 3.9129 | 80183684.0 |
| 2008-11-04 15:00:00 | AAPL | Stock | 3.9132 | 3.9343 | 3.88 | 3.9154 | 108934308.0 |
| 2008-11-04 15:30:00 | AAPL | Stock | 3.9164 | 3.9696 | 3.9164 | 3.9589 | 151739672.0 |
| 2008-11-04 16:00:00 | AAPL | Stock | 3.9589 | 3.9671 | 3.903 | 3.9614 | 21332332.0 |
| 2008-11-04 16:30:00 | AAPL | Stock | 3.9614 | 3.9614 | 3.9047 | 3.9546 | 672980.0 |
| 2008-11-04 17:00:00 | AAPL | Stock | 3.9568 | 3.9625 | 3.9568 | 3.9607 | 152880.0 |
| 2008-11-04 17:30:00 | AAPL | Stock | 3.9607 | 3.9625 | 3.9575 | 3.9604 | 101416.0 |
| 2008-11-04 18:00:00 | AAPL | Stock | 3.9604 | 3.9639 | 3.9279 | 3.9639 | 422492.0 |
| 2008-11-04 18:30:00 | AAPL | Stock | 3.9568 | 3.9643 | 3.9568 | 3.9632 | 414820.0 |
| 2008-11-04 19:00:00 | AAPL | Stock | 3.9632 | 3.9643 | 3.9632 | 3.9643 | 137340.0 |
| 2008-11-04 19:30:00 | AAPL | Stock | 3.9643 | 3.9729 | 3.9618 | 3.9714 | 337708.0 |
| 2008-11-04 20:00:00 | AAPL | Stock | 3.9696 | 3.9696 | 3.9696 | 3.9696 | 2800.0 |
| 2008-11-04 07:00:00 | MSFT | Stock | 23.0 | 23.0 | 23.0 | 23.0 | 900.0 |
| 2008-11-04 07:30:00 | MSFT | Stock | 23.02 | 23.05 | 23.02 | 23.05 | 1700.0 |
| 2008-11-04 08:00:00 | MSFT | Stock | 23.04 | 23.17 | 22.62 | 23.1 | 20215.0 |
| 2008-11-04 08:30:00 | MSFT | Stock | 23.1 | 23.19 | 23.1 | 23.16 | 48196.0 |
| 2008-11-04 09:00:00 | MSFT | Stock | 23.15 | 23.24 | 22.95 | 23.13 | 63730.0 |
| 2008-11-04 09:30:00 | MSFT | Stock | 23.14 | 23.18 | 22.9 | 22.97 | 6162971.0 |
| 2008-11-04 10:00:00 | MSFT | Stock | 22.97 | 23.15 | 22.87 | 23.142 | 5168954.0 |
| 2008-11-04 10:30:00 | MSFT | Stock | 23.13 | 23.36 | 23.02 | 23.34 | 5315926.0 |
| 2008-11-04 11:00:00 | MSFT | Stock | 23.34 | 23.55 | 23.0 | 23.48 | 5354070.0 |
| 2008-11-04 11:30:00 | MSFT | Stock | 23.47 | 23.66 | 23.4 | 23.6 | 4438208.0 |
| 2008-11-04 12:00:00 | MSFT | Stock | 23.6 | 23.63 | 23.39 | 23.4 | 2775399.0 |
| 2008-11-04 12:30:00 | MSFT | Stock | 23.41 | 23.475 | 23.35 | 23.39 | 2436574.0 |
| 2008-11-04 13:00:00 | MSFT | Stock | 23.39 | 23.48 | 23.31 | 23.34 | 3031175.0 |
| 2008-11-04 13:30:00 | MSFT | Stock | 23.33 | 23.5 | 23.15 | 23.4 | 3928665.0 |
| 2008-11-04 14:00:00 | MSFT | Stock | 23.4 | 23.46 | 23.18 | 23.289 | 4403121.0 |
| 2008-11-04 14:30:00 | MSFT | Stock | 23.29 | 23.332 | 23.06 | 23.14 | 3387504.0 |
| 2008-11-04 15:00:00 | MSFT | Stock | 23.13 | 23.32 | 23.0 | 23.15 | 5161195.0 |
| 2008-11-04 15:30:00 | MSFT | Stock | 23.14 | 23.62 | 23.14 | 23.54 | 14733121.0 |
| 2008-11-04 16:00:00 | MSFT | Stock | 23.53 | 23.554 | 23.225 | 23.53 | 3970064.0 |
| 2008-11-04 16:30:00 | MSFT | Stock | 23.53 | 23.53 | 23.43 | 23.5 | 3400.0 |
> showing 50 of 70,216 rows — these rows as CSV