PREVIEW / stock_30min / 2008-07-09
file: by_date/stock_30min/2008/2008-07-09.parquet size: 1.2 MB rows: 68,606 symbols: 3,318
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-07-09 05:30:00 | AAPL | Stock | 6.4357 | 6.4357 | 6.4357 | 6.4357 | 2800.0 |
| 2008-07-09 06:30:00 | AAPL | Stock | 6.4564 | 6.4739 | 6.4286 | 6.4286 | 14000.0 |
| 2008-07-09 07:00:00 | AAPL | Stock | 6.4161 | 6.4196 | 6.375 | 6.4196 | 291508.0 |
| 2008-07-09 07:30:00 | AAPL | Stock | 6.4196 | 6.4479 | 6.4196 | 6.4464 | 463680.0 |
| 2008-07-09 08:00:00 | AAPL | Stock | 6.4429 | 6.4707 | 6.4282 | 6.4643 | 5620608.0 |
| 2008-07-09 08:30:00 | AAPL | Stock | 6.4643 | 6.4661 | 6.4471 | 6.4536 | 2163364.0 |
| 2008-07-09 09:00:00 | AAPL | Stock | 6.4536 | 6.4607 | 6.4175 | 6.4375 | 3138688.0 |
| 2008-07-09 09:30:00 | AAPL | Stock | 6.4357 | 6.4544 | 6.3932 | 6.4321 | 119385952.0 |
| 2008-07-09 10:00:00 | AAPL | Stock | 6.4321 | 6.4611 | 6.3979 | 6.4471 | 79949380.0 |
| 2008-07-09 10:30:00 | AAPL | Stock | 6.4471 | 6.4479 | 6.4018 | 6.4232 | 65350096.0 |
| 2008-07-09 11:00:00 | AAPL | Stock | 6.4236 | 6.4532 | 6.4161 | 6.4507 | 53342464.0 |
| 2008-07-09 11:30:00 | AAPL | Stock | 6.4511 | 6.4554 | 6.4129 | 6.4218 | 41282416.0 |
| 2008-07-09 12:00:00 | AAPL | Stock | 6.4225 | 6.4254 | 6.38 | 6.4143 | 53774336.0 |
| 2008-07-09 12:30:00 | AAPL | Stock | 6.4146 | 6.4164 | 6.3857 | 6.4064 | 34837544.0 |
| 2008-07-09 13:00:00 | AAPL | Stock | 6.4061 | 6.4175 | 6.3768 | 6.4147 | 39106368.0 |
| 2008-07-09 13:30:00 | AAPL | Stock | 6.4157 | 6.4239 | 6.4007 | 6.41 | 36522584.0 |
| 2008-07-09 14:00:00 | AAPL | Stock | 6.4104 | 6.4318 | 6.3936 | 6.4107 | 49079100.0 |
| 2008-07-09 14:30:00 | AAPL | Stock | 6.4104 | 6.4189 | 6.3154 | 6.3411 | 67691204.0 |
| 2008-07-09 15:00:00 | AAPL | Stock | 6.3404 | 6.3411 | 6.2607 | 6.2939 | 96957196.0 |
| 2008-07-09 15:30:00 | AAPL | Stock | 6.2936 | 6.3086 | 6.2193 | 6.2236 | 110602912.0 |
| 2008-07-09 16:00:00 | AAPL | Stock | 6.2239 | 6.4357 | 6.2225 | 6.2461 | 16445408.0 |
| 2008-07-09 16:30:00 | AAPL | Stock | 6.2443 | 6.3727 | 6.2232 | 6.2364 | 6374116.0 |
| 2008-07-09 17:00:00 | AAPL | Stock | 6.2357 | 6.2407 | 6.2336 | 6.2343 | 91392.0 |
| 2008-07-09 17:30:00 | AAPL | Stock | 6.4175 | 6.4175 | 6.2375 | 6.2446 | 232260.0 |
| 2008-07-09 18:00:00 | AAPL | Stock | 6.2429 | 6.2479 | 6.2232 | 6.2475 | 734216.0 |
| 2008-07-09 18:30:00 | AAPL | Stock | 6.2471 | 6.2471 | 6.2411 | 6.245 | 95340.0 |
| 2008-07-09 19:00:00 | AAPL | Stock | 6.2446 | 6.2446 | 6.2346 | 6.2346 | 142044.0 |
| 2008-07-09 19:30:00 | AAPL | Stock | 6.2446 | 6.2446 | 6.235 | 6.2446 | 142380.0 |
| 2008-07-09 08:00:00 | MSFT | Stock | 25.85 | 25.9 | 25.78 | 25.9 | 4475.0 |
| 2008-07-09 08:30:00 | MSFT | Stock | 25.86 | 25.92 | 25.85 | 25.88 | 7200.0 |
| 2008-07-09 09:00:00 | MSFT | Stock | 25.88 | 25.88 | 25.75 | 25.76 | 28731.0 |
| 2008-07-09 09:30:00 | MSFT | Stock | 25.79 | 25.85 | 25.51 | 25.52 | 4281733.0 |
| 2008-07-09 10:00:00 | MSFT | Stock | 25.52 | 25.67 | 25.46 | 25.65 | 6549408.0 |
| 2008-07-09 10:30:00 | MSFT | Stock | 25.65 | 25.66 | 25.54 | 25.62 | 3531448.0 |
| 2008-07-09 11:00:00 | MSFT | Stock | 25.61 | 25.76 | 25.53 | 25.73 | 4207010.0 |
| 2008-07-09 11:30:00 | MSFT | Stock | 25.728 | 25.74 | 25.6 | 25.66 | 1990137.0 |
| 2008-07-09 12:00:00 | MSFT | Stock | 25.65 | 25.7 | 25.55 | 25.67 | 2091573.0 |
| 2008-07-09 12:30:00 | MSFT | Stock | 25.66 | 25.67 | 25.55 | 25.61 | 1797842.0 |
| 2008-07-09 13:00:00 | MSFT | Stock | 25.618 | 25.63 | 25.51 | 25.6 | 2081242.0 |
| 2008-07-09 13:30:00 | MSFT | Stock | 25.6 | 25.67 | 25.55 | 25.61 | 1730117.0 |
| 2008-07-09 14:00:00 | MSFT | Stock | 25.61 | 25.72 | 25.52 | 25.64 | 2566557.0 |
| 2008-07-09 14:30:00 | MSFT | Stock | 25.63 | 25.695 | 25.51 | 25.58 | 3490614.0 |
| 2008-07-09 15:00:00 | MSFT | Stock | 25.58 | 25.58 | 25.49 | 25.52 | 4538619.0 |
| 2008-07-09 15:30:00 | MSFT | Stock | 25.51 | 25.53 | 25.19 | 25.2 | 11150442.0 |
| 2008-07-09 16:00:00 | MSFT | Stock | 25.19 | 25.85 | 25.18 | 25.23 | 2451414.0 |
| 2008-07-09 16:30:00 | MSFT | Stock | 25.25 | 25.524 | 25.23 | 25.23 | 584557.0 |
| 2008-07-09 17:00:00 | MSFT | Stock | 25.25 | 25.524 | 25.25 | 25.28 | 30275.0 |
| 2008-07-09 17:30:00 | MSFT | Stock | 25.85 | 25.85 | 25.26 | 25.28 | 25505.0 |
| 2008-07-09 18:00:00 | MSFT | Stock | 25.27 | 25.27 | 25.23 | 25.23 | 57700.0 |
| 2008-07-09 18:30:00 | MSFT | Stock | 25.25 | 25.25 | 25.25 | 25.25 | 1472.0 |
> showing 50 of 68,606 rows — these rows as CSV