PREVIEW / stock_30min / 2010-12-29
file: by_date/stock_30min/2010/2010-12-29.parquet size: 1.4 MB rows: 74,543 symbols: 3,539
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-29 04:00:00 | AAPL | Stock | 11.6421 | 11.6421 | 11.6421 | 11.6421 | 5600.0 |
| 2010-12-29 05:30:00 | AAPL | Stock | 11.6107 | 11.6107 | 11.6107 | 11.6107 | 2800.0 |
| 2010-12-29 07:00:00 | AAPL | Stock | 11.6425 | 11.6429 | 11.6425 | 11.6429 | 8400.0 |
| 2010-12-29 07:30:00 | AAPL | Stock | 11.6393 | 11.6393 | 11.6393 | 11.6393 | 5600.0 |
| 2010-12-29 08:00:00 | AAPL | Stock | 11.6389 | 11.6425 | 11.6296 | 11.6339 | 436940.0 |
| 2010-12-29 08:30:00 | AAPL | Stock | 11.6318 | 11.6425 | 11.6304 | 11.6382 | 372316.0 |
| 2010-12-29 09:00:00 | AAPL | Stock | 11.6404 | 11.6493 | 11.6364 | 11.6486 | 786212.0 |
| 2010-12-29 09:30:00 | AAPL | Stock | 11.6454 | 11.6589 | 11.6332 | 11.6421 | 25812556.0 |
| 2010-12-29 10:00:00 | AAPL | Stock | 11.6421 | 11.6479 | 11.6357 | 11.6425 | 15834112.0 |
| 2010-12-29 10:30:00 | AAPL | Stock | 11.6421 | 11.6536 | 11.6239 | 11.6404 | 12354720.0 |
| 2010-12-29 11:00:00 | AAPL | Stock | 11.6411 | 11.6439 | 11.6161 | 11.625 | 17828748.0 |
| 2010-12-29 11:30:00 | AAPL | Stock | 11.625 | 11.6304 | 11.6211 | 11.6239 | 6038340.0 |
| 2010-12-29 12:00:00 | AAPL | Stock | 11.6243 | 11.6311 | 11.6232 | 11.6286 | 5189604.0 |
| 2010-12-29 12:30:00 | AAPL | Stock | 11.6281 | 11.6429 | 11.6268 | 11.6393 | 6803272.0 |
| 2010-12-29 13:00:00 | AAPL | Stock | 11.6386 | 11.6429 | 11.6339 | 11.6391 | 5444880.0 |
| 2010-12-29 13:30:00 | AAPL | Stock | 11.6379 | 11.6407 | 11.625 | 11.625 | 4868864.0 |
| 2010-12-29 14:00:00 | AAPL | Stock | 11.6257 | 11.6321 | 11.6236 | 11.6282 | 6064212.0 |
| 2010-12-29 14:30:00 | AAPL | Stock | 11.628 | 11.6318 | 11.6175 | 11.6221 | 6860588.0 |
| 2010-12-29 15:00:00 | AAPL | Stock | 11.6215 | 11.6336 | 11.6211 | 11.6264 | 8034852.0 |
| 2010-12-29 15:30:00 | AAPL | Stock | 11.6264 | 11.6264 | 11.6107 | 11.6179 | 25768316.0 |
| 2010-12-29 16:00:00 | AAPL | Stock | 11.6175 | 11.6331 | 11.6118 | 11.6146 | 12137496.0 |
| 2010-12-29 16:30:00 | AAPL | Stock | 11.6175 | 11.6254 | 11.6154 | 11.6193 | 144956.0 |
| 2010-12-29 17:00:00 | AAPL | Stock | 11.6164 | 11.6629 | 11.6164 | 11.6164 | 171388.0 |
| 2010-12-29 17:30:00 | AAPL | Stock | 11.6164 | 11.6193 | 11.6164 | 11.6193 | 24500.0 |
| 2010-12-29 18:00:00 | AAPL | Stock | 11.6179 | 11.6193 | 11.6175 | 11.6179 | 28952.0 |
| 2010-12-29 18:30:00 | AAPL | Stock | 11.6179 | 11.6193 | 11.6164 | 11.6164 | 31640.0 |
| 2010-12-29 19:00:00 | AAPL | Stock | 11.6179 | 11.6179 | 11.6164 | 11.6179 | 51240.0 |
| 2010-12-29 19:30:00 | AAPL | Stock | 11.6182 | 11.6193 | 11.6179 | 11.6193 | 28980.0 |
| 2010-12-29 04:30:00 | MSFT | Stock | 27.9 | 27.9 | 27.9 | 27.9 | 400.0 |
| 2010-12-29 06:00:00 | MSFT | Stock | 28.05 | 28.05 | 28.05 | 28.05 | 300.0 |
| 2010-12-29 06:30:00 | MSFT | Stock | 27.91 | 27.91 | 27.91 | 27.91 | 500.0 |
| 2010-12-29 07:30:00 | MSFT | Stock | 28.09 | 28.09 | 28.09 | 28.09 | 400.0 |
| 2010-12-29 08:00:00 | MSFT | Stock | 28.09 | 28.09 | 28.05 | 28.08 | 3100.0 |
| 2010-12-29 08:30:00 | MSFT | Stock | 28.09 | 28.09 | 28.04 | 28.04 | 2300.0 |
| 2010-12-29 09:00:00 | MSFT | Stock | 28.08 | 28.09 | 27.91 | 27.92 | 80724.0 |
| 2010-12-29 09:30:00 | MSFT | Stock | 27.92 | 28.04 | 27.88 | 28.0 | 2715367.0 |
| 2010-12-29 10:00:00 | MSFT | Stock | 27.995 | 28.1 | 27.99 | 28.1 | 1449899.0 |
| 2010-12-29 10:30:00 | MSFT | Stock | 28.1 | 28.12 | 28.01 | 28.073 | 1299492.0 |
| 2010-12-29 11:00:00 | MSFT | Stock | 28.072 | 28.1 | 28.05 | 28.08 | 854317.0 |
| 2010-12-29 11:30:00 | MSFT | Stock | 28.08 | 28.08 | 28.025 | 28.03 | 745670.0 |
| 2010-12-29 12:00:00 | MSFT | Stock | 28.04 | 28.08 | 28.03 | 28.05 | 734246.0 |
| 2010-12-29 12:30:00 | MSFT | Stock | 28.05 | 28.08 | 28.04 | 28.079 | 636111.0 |
| 2010-12-29 13:00:00 | MSFT | Stock | 28.08 | 28.1 | 28.06 | 28.09 | 687854.0 |
| 2010-12-29 13:30:00 | MSFT | Stock | 28.08 | 28.1 | 28.06 | 28.06 | 589120.0 |
| 2010-12-29 14:00:00 | MSFT | Stock | 28.07 | 28.08 | 28.03 | 28.04 | 876336.0 |
| 2010-12-29 14:30:00 | MSFT | Stock | 28.04 | 28.1 | 28.03 | 28.095 | 1776618.0 |
| 2010-12-29 15:00:00 | MSFT | Stock | 28.1 | 28.1 | 28.04 | 28.07 | 1331374.0 |
| 2010-12-29 15:30:00 | MSFT | Stock | 28.07 | 28.08 | 27.97 | 27.97 | 2907373.0 |
| 2010-12-29 16:00:00 | MSFT | Stock | 27.98 | 28.039 | 27.93 | 27.97 | 1848045.0 |
| 2010-12-29 16:30:00 | MSFT | Stock | 27.97 | 28.07 | 27.97 | 28.07 | 4785.0 |
> showing 50 of 74,543 rows — these rows as CSV