PREVIEW / stock_30min / 2009-08-20
file: by_date/stock_30min/2009/2009-08-20.parquet size: 1.3 MB rows: 69,685 symbols: 3,367
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-20 07:00:00 | AAPL | Stock | 5.9107 | 5.9196 | 5.9071 | 5.9107 | 102060.0 |
| 2009-08-20 07:30:00 | AAPL | Stock | 5.8982 | 5.9046 | 5.8982 | 5.9046 | 28000.0 |
| 2009-08-20 08:00:00 | AAPL | Stock | 5.9046 | 5.9171 | 5.8968 | 5.9171 | 486444.0 |
| 2009-08-20 08:30:00 | AAPL | Stock | 5.9107 | 5.9179 | 5.8964 | 5.9125 | 2470636.0 |
| 2009-08-20 09:00:00 | AAPL | Stock | 5.9114 | 5.9114 | 5.8886 | 5.8921 | 1602664.0 |
| 2009-08-20 09:30:00 | AAPL | Stock | 5.8925 | 5.9286 | 5.8789 | 5.9286 | 52870384.0 |
| 2009-08-20 10:00:00 | AAPL | Stock | 5.9282 | 5.9357 | 5.9218 | 5.9286 | 40718216.0 |
| 2009-08-20 10:30:00 | AAPL | Stock | 5.9282 | 5.9421 | 5.9232 | 5.93 | 23884560.0 |
| 2009-08-20 11:00:00 | AAPL | Stock | 5.93 | 5.9332 | 5.925 | 5.9314 | 14967092.0 |
| 2009-08-20 11:30:00 | AAPL | Stock | 5.9314 | 5.9321 | 5.9179 | 5.9243 | 18633356.0 |
| 2009-08-20 12:00:00 | AAPL | Stock | 5.9239 | 5.9339 | 5.9232 | 5.9332 | 14421260.0 |
| 2009-08-20 12:30:00 | AAPL | Stock | 5.9332 | 5.9471 | 5.9332 | 5.9446 | 20675200.0 |
| 2009-08-20 13:00:00 | AAPL | Stock | 5.9446 | 5.9486 | 5.9396 | 5.9477 | 19334112.0 |
| 2009-08-20 13:30:00 | AAPL | Stock | 5.9479 | 5.95 | 5.9311 | 5.9316 | 17441564.0 |
| 2009-08-20 14:00:00 | AAPL | Stock | 5.9325 | 5.9364 | 5.9296 | 5.9332 | 14814324.0 |
| 2009-08-20 14:30:00 | AAPL | Stock | 5.9329 | 5.94 | 5.9293 | 5.9346 | 19189464.0 |
| 2009-08-20 15:00:00 | AAPL | Stock | 5.9343 | 5.9446 | 5.9314 | 5.9421 | 20717088.0 |
| 2009-08-20 15:30:00 | AAPL | Stock | 5.9421 | 5.9543 | 5.9411 | 5.9429 | 45249120.0 |
| 2009-08-20 16:00:00 | AAPL | Stock | 5.945 | 5.945 | 5.9305 | 5.9404 | 11948300.0 |
| 2009-08-20 16:30:00 | AAPL | Stock | 5.9418 | 5.9418 | 5.9379 | 5.9404 | 67200.0 |
| 2009-08-20 17:00:00 | AAPL | Stock | 5.9425 | 5.9429 | 5.9379 | 5.9379 | 85736.0 |
| 2009-08-20 17:30:00 | AAPL | Stock | 5.9382 | 5.9382 | 5.9382 | 5.9382 | 11200.0 |
| 2009-08-20 18:00:00 | AAPL | Stock | 5.9371 | 5.9404 | 5.9357 | 5.9375 | 477148.0 |
| 2009-08-20 18:30:00 | AAPL | Stock | 5.9389 | 5.9396 | 5.9357 | 5.9393 | 74200.0 |
| 2009-08-20 19:00:00 | AAPL | Stock | 5.9364 | 5.9364 | 5.9364 | 5.9364 | 8400.0 |
| 2009-08-20 19:30:00 | AAPL | Stock | 5.9343 | 5.9343 | 5.9286 | 5.9307 | 68740.0 |
| 2009-08-20 08:00:00 | MSFT | Stock | 23.72 | 23.75 | 23.7 | 23.7 | 7000.0 |
| 2009-08-20 08:30:00 | MSFT | Stock | 23.71 | 23.71 | 23.66 | 23.7 | 44000.0 |
| 2009-08-20 09:00:00 | MSFT | Stock | 23.7 | 23.7 | 23.6 | 23.61 | 19462.0 |
| 2009-08-20 09:30:00 | MSFT | Stock | 23.6 | 23.87 | 23.54 | 23.86 | 4176082.0 |
| 2009-08-20 10:00:00 | MSFT | Stock | 23.86 | 23.87 | 23.67 | 23.74 | 4033646.0 |
| 2009-08-20 10:30:00 | MSFT | Stock | 23.74 | 23.77 | 23.69 | 23.69 | 2632422.0 |
| 2009-08-20 11:00:00 | MSFT | Stock | 23.69 | 23.72 | 23.68 | 23.69 | 2232374.0 |
| 2009-08-20 11:30:00 | MSFT | Stock | 23.7 | 23.71 | 23.54 | 23.555 | 2535783.0 |
| 2009-08-20 12:00:00 | MSFT | Stock | 23.55 | 23.69 | 23.55 | 23.69 | 1861043.0 |
| 2009-08-20 12:30:00 | MSFT | Stock | 23.69 | 23.73 | 23.67 | 23.71 | 1515381.0 |
| 2009-08-20 13:00:00 | MSFT | Stock | 23.707 | 23.74 | 23.68 | 23.73 | 1224245.0 |
| 2009-08-20 13:30:00 | MSFT | Stock | 23.735 | 23.74 | 23.67 | 23.7 | 1544917.0 |
| 2009-08-20 14:00:00 | MSFT | Stock | 23.71 | 23.73 | 23.68 | 23.7 | 1144737.0 |
| 2009-08-20 14:30:00 | MSFT | Stock | 23.69 | 23.71 | 23.63 | 23.64 | 1858405.0 |
| 2009-08-20 15:00:00 | MSFT | Stock | 23.65 | 23.74 | 23.64 | 23.67 | 3166947.0 |
| 2009-08-20 15:30:00 | MSFT | Stock | 23.68 | 23.72 | 23.65 | 23.66 | 6313868.0 |
| 2009-08-20 16:00:00 | MSFT | Stock | 23.67 | 23.703 | 23.64 | 23.69 | 2686812.0 |
| 2009-08-20 16:30:00 | MSFT | Stock | 23.66 | 23.7 | 23.66 | 23.68 | 400.0 |
| 2009-08-20 17:00:00 | MSFT | Stock | 23.68 | 23.68 | 23.68 | 23.68 | 200.0 |
| 2009-08-20 17:30:00 | MSFT | Stock | 23.68 | 23.68 | 23.67 | 23.67 | 800.0 |
| 2009-08-20 18:00:00 | MSFT | Stock | 23.67 | 23.68 | 23.67 | 23.68 | 2646.0 |
| 2009-08-20 18:30:00 | MSFT | Stock | 23.68 | 23.7 | 23.68 | 23.7 | 1100.0 |
| 2009-08-20 19:00:00 | MSFT | Stock | 23.69 | 23.69 | 23.69 | 23.69 | 200.0 |
| 2009-08-20 19:30:00 | MSFT | Stock | 23.69 | 23.69 | 23.66 | 23.66 | 700.0 |
> showing 50 of 69,685 rows — these rows as CSV