PREVIEW / stock_30min / 2008-10-24
file: by_date/stock_30min/2008/2008-10-24.parquet size: 1.2 MB rows: 70,425 symbols: 3,322
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-10-24 04:00:00 | AAPL | Stock | 3.3964 | 3.3964 | 3.3929 | 3.3929 | 16800.0 |
| 2008-10-24 04:30:00 | AAPL | Stock | 3.2861 | 3.2861 | 3.2679 | 3.2679 | 21840.0 |
| 2008-10-24 05:30:00 | AAPL | Stock | 3.2521 | 3.2521 | 3.2321 | 3.2321 | 9240.0 |
| 2008-10-24 06:00:00 | AAPL | Stock | 3.2146 | 3.2146 | 3.2146 | 3.2146 | 3164.0 |
| 2008-10-24 07:00:00 | AAPL | Stock | 3.2143 | 3.2857 | 3.2111 | 3.2321 | 365288.0 |
| 2008-10-24 07:30:00 | AAPL | Stock | 3.2286 | 3.2675 | 3.2232 | 3.25 | 331100.0 |
| 2008-10-24 08:00:00 | AAPL | Stock | 3.2507 | 3.3214 | 3.2036 | 3.2093 | 4783072.0 |
| 2008-10-24 08:30:00 | AAPL | Stock | 3.2071 | 3.2393 | 3.1789 | 3.23 | 3319428.0 |
| 2008-10-24 09:00:00 | AAPL | Stock | 3.2304 | 3.2321 | 3.2007 | 3.2254 | 5718188.0 |
| 2008-10-24 09:30:00 | AAPL | Stock | 3.2243 | 3.4286 | 3.2182 | 3.3943 | 230758360.0 |
| 2008-10-24 10:00:00 | AAPL | Stock | 3.3943 | 3.4275 | 3.3393 | 3.3679 | 152400892.0 |
| 2008-10-24 10:30:00 | AAPL | Stock | 3.3679 | 3.4018 | 3.3471 | 3.3818 | 97643812.0 |
| 2008-10-24 11:00:00 | AAPL | Stock | 3.3814 | 3.4532 | 3.3625 | 3.4307 | 95458608.0 |
| 2008-10-24 11:30:00 | AAPL | Stock | 3.4368 | 3.4768 | 3.4179 | 3.4343 | 94376044.0 |
| 2008-10-24 12:00:00 | AAPL | Stock | 3.4343 | 3.4629 | 3.3971 | 3.3982 | 68792892.0 |
| 2008-10-24 12:30:00 | AAPL | Stock | 3.3982 | 3.4164 | 3.3661 | 3.3764 | 72884000.0 |
| 2008-10-24 13:00:00 | AAPL | Stock | 3.3761 | 3.4071 | 3.3664 | 3.3804 | 62773984.0 |
| 2008-10-24 13:30:00 | AAPL | Stock | 3.3818 | 3.3821 | 3.3125 | 3.3143 | 79721572.0 |
| 2008-10-24 14:00:00 | AAPL | Stock | 3.3132 | 3.3571 | 3.3036 | 3.3286 | 90620124.0 |
| 2008-10-24 14:30:00 | AAPL | Stock | 3.3296 | 3.4475 | 3.3296 | 3.435 | 125302184.0 |
| 2008-10-24 15:00:00 | AAPL | Stock | 3.435 | 3.4682 | 3.3757 | 3.4232 | 149185596.0 |
| 2008-10-24 15:30:00 | AAPL | Stock | 3.4236 | 3.4964 | 3.38 | 3.4418 | 180415256.0 |
| 2008-10-24 16:00:00 | AAPL | Stock | 3.4414 | 3.4586 | 3.386 | 3.4186 | 48932520.0 |
| 2008-10-24 16:30:00 | AAPL | Stock | 3.4211 | 3.4421 | 3.3964 | 3.42 | 5111260.0 |
| 2008-10-24 17:00:00 | AAPL | Stock | 3.42 | 3.4211 | 3.415 | 3.4182 | 141596.0 |
| 2008-10-24 17:30:00 | AAPL | Stock | 3.4196 | 3.4229 | 3.2929 | 3.4214 | 240072.0 |
| 2008-10-24 18:00:00 | AAPL | Stock | 3.425 | 3.425 | 3.4182 | 3.4239 | 61600.0 |
| 2008-10-24 18:30:00 | AAPL | Stock | 3.4232 | 3.4232 | 3.4186 | 3.4214 | 36988.0 |
| 2008-10-24 19:00:00 | AAPL | Stock | 3.4239 | 3.4286 | 3.4232 | 3.4232 | 342664.0 |
| 2008-10-24 19:30:00 | AAPL | Stock | 3.425 | 3.4339 | 3.425 | 3.4286 | 67984.0 |
| 2008-10-24 04:00:00 | MSFT | Stock | 22.01 | 22.01 | 21.44 | 21.44 | 2400.0 |
| 2008-10-24 04:30:00 | MSFT | Stock | 21.31 | 21.31 | 21.31 | 21.31 | 200.0 |
| 2008-10-24 06:00:00 | MSFT | Stock | 21.0 | 21.0 | 20.75 | 20.75 | 7280.0 |
| 2008-10-24 06:30:00 | MSFT | Stock | 20.75 | 20.75 | 20.75 | 20.75 | 400.0 |
| 2008-10-24 07:00:00 | MSFT | Stock | 21.0 | 21.17 | 20.75 | 21.0 | 82617.0 |
| 2008-10-24 07:30:00 | MSFT | Stock | 20.96 | 21.01 | 20.87 | 20.9 | 70683.0 |
| 2008-10-24 08:00:00 | MSFT | Stock | 20.9 | 21.39 | 20.72 | 20.75 | 607947.0 |
| 2008-10-24 08:30:00 | MSFT | Stock | 20.78 | 20.8 | 20.7 | 20.71 | 275168.0 |
| 2008-10-24 09:00:00 | MSFT | Stock | 20.71 | 21.13 | 20.7 | 21.06 | 631903.0 |
| 2008-10-24 09:30:00 | MSFT | Stock | 21.05 | 21.76 | 20.95 | 21.542 | 20031264.0 |
| 2008-10-24 10:00:00 | MSFT | Stock | 21.55 | 22.13 | 21.33 | 21.59 | 16035599.0 |
| 2008-10-24 10:30:00 | MSFT | Stock | 21.59 | 22.26 | 21.51 | 22.22 | 10448005.0 |
| 2008-10-24 11:00:00 | MSFT | Stock | 22.23 | 22.64 | 22.03 | 22.57 | 13697706.0 |
| 2008-10-24 11:30:00 | MSFT | Stock | 22.57 | 22.86 | 22.5 | 22.51 | 10949477.0 |
| 2008-10-24 12:00:00 | MSFT | Stock | 22.5 | 22.64 | 22.16 | 22.165 | 6529593.0 |
| 2008-10-24 12:30:00 | MSFT | Stock | 22.17 | 22.45 | 22.02 | 22.088 | 6398622.0 |
| 2008-10-24 13:00:00 | MSFT | Stock | 22.09 | 22.44 | 21.971 | 22.2 | 6122277.0 |
| 2008-10-24 13:30:00 | MSFT | Stock | 22.198 | 22.198 | 21.73 | 21.74 | 7091806.0 |
| 2008-10-24 14:00:00 | MSFT | Stock | 21.74 | 22.12 | 21.67 | 21.725 | 7294863.0 |
| 2008-10-24 14:30:00 | MSFT | Stock | 21.73 | 22.36 | 21.725 | 22.29 | 9764749.0 |
> showing 50 of 70,425 rows — these rows as CSV