PREVIEW / stock_30min / 2008-12-12
file: by_date/stock_30min/2008/2008-12-12.parquet size: 1.2 MB rows: 69,133 symbols: 3,345
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-12-12 06:00:00 | AAPL | Stock | 3.3139 | 3.3139 | 3.3139 | 3.3139 | 3780.0 |
| 2008-12-12 07:30:00 | AAPL | Stock | 3.3054 | 3.3054 | 3.3054 | 3.3054 | 2800.0 |
| 2008-12-12 08:00:00 | AAPL | Stock | 3.3036 | 3.3386 | 3.2882 | 3.3186 | 1849988.0 |
| 2008-12-12 08:30:00 | AAPL | Stock | 3.3214 | 3.3357 | 3.3143 | 3.3214 | 943124.0 |
| 2008-12-12 09:00:00 | AAPL | Stock | 3.3214 | 3.3475 | 3.3125 | 3.3164 | 1594320.0 |
| 2008-12-12 09:30:00 | AAPL | Stock | 3.3143 | 3.4186 | 3.3046 | 3.41 | 120015000.0 |
| 2008-12-12 10:00:00 | AAPL | Stock | 3.4111 | 3.46 | 3.4093 | 3.4411 | 93304652.0 |
| 2008-12-12 10:30:00 | AAPL | Stock | 3.4418 | 3.4796 | 3.4107 | 3.4675 | 73882816.0 |
| 2008-12-12 11:00:00 | AAPL | Stock | 3.4671 | 3.4904 | 3.4389 | 3.4511 | 69298096.0 |
| 2008-12-12 11:30:00 | AAPL | Stock | 3.4511 | 3.4579 | 3.4268 | 3.4464 | 44895032.0 |
| 2008-12-12 12:00:00 | AAPL | Stock | 3.4475 | 3.465 | 3.4279 | 3.4429 | 43710324.0 |
| 2008-12-12 12:30:00 | AAPL | Stock | 3.4429 | 3.5147 | 3.4379 | 3.5071 | 68879944.0 |
| 2008-12-12 13:00:00 | AAPL | Stock | 3.5064 | 3.5196 | 3.4821 | 3.4925 | 76558776.0 |
| 2008-12-12 13:30:00 | AAPL | Stock | 3.4943 | 3.4957 | 3.4664 | 3.4899 | 57387596.0 |
| 2008-12-12 14:00:00 | AAPL | Stock | 3.4896 | 3.5186 | 3.4771 | 3.4918 | 79517228.0 |
| 2008-12-12 14:30:00 | AAPL | Stock | 3.4921 | 3.5286 | 3.4646 | 3.5121 | 96043556.0 |
| 2008-12-12 15:00:00 | AAPL | Stock | 3.5121 | 3.5357 | 3.4879 | 3.5079 | 90348496.0 |
| 2008-12-12 15:30:00 | AAPL | Stock | 3.5071 | 3.5221 | 3.4871 | 3.5132 | 98121884.0 |
| 2008-12-12 16:00:00 | AAPL | Stock | 3.5131 | 3.5271 | 3.4091 | 3.5139 | 13846420.0 |
| 2008-12-12 16:30:00 | AAPL | Stock | 3.5143 | 3.5236 | 3.5107 | 3.5143 | 308728.0 |
| 2008-12-12 17:00:00 | AAPL | Stock | 3.5143 | 3.5196 | 3.5143 | 3.5196 | 150920.0 |
| 2008-12-12 17:30:00 | AAPL | Stock | 3.5196 | 3.5196 | 3.515 | 3.5179 | 88060.0 |
| 2008-12-12 18:00:00 | AAPL | Stock | 3.5179 | 3.5196 | 3.5096 | 3.5196 | 1283268.0 |
| 2008-12-12 18:30:00 | AAPL | Stock | 3.5196 | 3.5196 | 3.5179 | 3.5196 | 181776.0 |
| 2008-12-12 19:00:00 | AAPL | Stock | 3.5214 | 3.5243 | 3.5204 | 3.5204 | 88704.0 |
| 2008-12-12 19:30:00 | AAPL | Stock | 3.5189 | 3.5239 | 3.5179 | 3.5239 | 87584.0 |
| 2008-12-12 07:00:00 | MSFT | Stock | 18.79 | 19.1 | 18.79 | 19.0 | 6060.0 |
| 2008-12-12 07:30:00 | MSFT | Stock | 18.85 | 18.87 | 18.85 | 18.85 | 598.0 |
| 2008-12-12 08:00:00 | MSFT | Stock | 18.86 | 19.05 | 18.85 | 18.9 | 47859.0 |
| 2008-12-12 08:30:00 | MSFT | Stock | 18.9 | 19.0 | 18.9 | 19.0 | 32010.0 |
| 2008-12-12 09:00:00 | MSFT | Stock | 18.95 | 19.19 | 18.95 | 19.16 | 47416.0 |
| 2008-12-12 09:30:00 | MSFT | Stock | 19.15 | 19.85 | 19.04 | 19.12 | 8322092.0 |
| 2008-12-12 10:00:00 | MSFT | Stock | 19.11 | 19.26 | 18.72 | 18.861 | 10815762.0 |
| 2008-12-12 10:30:00 | MSFT | Stock | 18.87 | 19.36 | 18.7 | 19.319 | 9572416.0 |
| 2008-12-12 11:00:00 | MSFT | Stock | 19.312 | 19.4 | 19.17 | 19.195 | 4077118.0 |
| 2008-12-12 11:30:00 | MSFT | Stock | 19.193 | 19.35 | 19.05 | 19.27 | 3853694.0 |
| 2008-12-12 12:00:00 | MSFT | Stock | 19.27 | 19.46 | 19.24 | 19.41 | 3244137.0 |
| 2008-12-12 12:30:00 | MSFT | Stock | 19.41 | 19.59 | 19.36 | 19.522 | 2980763.0 |
| 2008-12-12 13:00:00 | MSFT | Stock | 19.53 | 19.57 | 19.31 | 19.382 | 3268817.0 |
| 2008-12-12 13:30:00 | MSFT | Stock | 19.38 | 19.38 | 19.1 | 19.182 | 3200205.0 |
| 2008-12-12 14:00:00 | MSFT | Stock | 19.18 | 19.34 | 19.17 | 19.282 | 3821567.0 |
| 2008-12-12 14:30:00 | MSFT | Stock | 19.28 | 19.5 | 19.15 | 19.44 | 4888539.0 |
| 2008-12-12 15:00:00 | MSFT | Stock | 19.44 | 19.53 | 19.18 | 19.3 | 5739011.0 |
| 2008-12-12 15:30:00 | MSFT | Stock | 19.3 | 19.35 | 19.1 | 19.34 | 10699896.0 |
| 2008-12-12 16:00:00 | MSFT | Stock | 19.35 | 19.54 | 19.19 | 19.38 | 2881630.0 |
| 2008-12-12 16:30:00 | MSFT | Stock | 19.38 | 19.41 | 19.36 | 19.4 | 11806.0 |
| 2008-12-12 17:00:00 | MSFT | Stock | 19.4 | 19.48 | 19.4 | 19.48 | 6040.0 |
| 2008-12-12 17:30:00 | MSFT | Stock | 19.47 | 19.48 | 19.47 | 19.48 | 8100.0 |
| 2008-12-12 18:00:00 | MSFT | Stock | 19.43 | 19.45 | 19.4 | 19.42 | 12960.0 |
| 2008-12-12 18:30:00 | MSFT | Stock | 19.47 | 19.47 | 19.41 | 19.41 | 700.0 |
> showing 50 of 69,133 rows — these rows as CSV