PREVIEW / stock_30min / 2006-09-19
file: by_date/stock_30min/2006/2006-09-19.parquet size: 904 KB rows: 49,273 symbols: 2,371
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 |
|---|---|---|---|---|---|---|---|
| 2006-09-19 07:00:00 | AAPL | Stock | 2.6261 | 2.6261 | 2.625 | 2.625 | 11200.0 |
| 2006-09-19 07:30:00 | AAPL | Stock | 2.6282 | 2.6282 | 2.6282 | 2.6282 | 2800.0 |
| 2006-09-19 08:00:00 | AAPL | Stock | 2.6393 | 2.6393 | 2.6254 | 2.6393 | 179200.0 |
| 2006-09-19 08:30:00 | AAPL | Stock | 2.6411 | 2.6464 | 2.6339 | 2.6393 | 985040.0 |
| 2006-09-19 09:00:00 | AAPL | Stock | 2.6418 | 2.6536 | 2.6396 | 2.6486 | 2149056.0 |
| 2006-09-19 09:30:00 | AAPL | Stock | 2.6486 | 2.6529 | 2.6196 | 2.6414 | 105206164.0 |
| 2006-09-19 10:00:00 | AAPL | Stock | 2.6418 | 2.65 | 2.6282 | 2.6364 | 58118956.0 |
| 2006-09-19 10:30:00 | AAPL | Stock | 2.6364 | 2.6429 | 2.6268 | 2.6404 | 41173188.0 |
| 2006-09-19 11:00:00 | AAPL | Stock | 2.64 | 2.6557 | 2.6396 | 2.6468 | 69525176.0 |
| 2006-09-19 11:30:00 | AAPL | Stock | 2.6471 | 2.6475 | 2.6132 | 2.6232 | 98163212.0 |
| 2006-09-19 12:00:00 | AAPL | Stock | 2.6232 | 2.6332 | 2.6021 | 2.6036 | 70898380.0 |
| 2006-09-19 12:30:00 | AAPL | Stock | 2.6036 | 2.6257 | 2.6 | 2.6193 | 41160896.0 |
| 2006-09-19 13:00:00 | AAPL | Stock | 2.6189 | 2.6286 | 2.6179 | 2.6193 | 26431020.0 |
| 2006-09-19 13:30:00 | AAPL | Stock | 2.6189 | 2.6271 | 2.6121 | 2.6225 | 25261096.0 |
| 2006-09-19 14:00:00 | AAPL | Stock | 2.6221 | 2.6354 | 2.6218 | 2.6304 | 31726604.0 |
| 2006-09-19 14:30:00 | AAPL | Stock | 2.6307 | 2.6332 | 2.6196 | 2.6293 | 28080164.0 |
| 2006-09-19 15:00:00 | AAPL | Stock | 2.6289 | 2.6357 | 2.6246 | 2.6296 | 33151076.0 |
| 2006-09-19 15:30:00 | AAPL | Stock | 2.6293 | 2.64 | 2.6293 | 2.6361 | 52386096.0 |
| 2006-09-19 16:00:00 | AAPL | Stock | 2.6368 | 2.6457 | 2.6346 | 2.64 | 851256.0 |
| 2006-09-19 16:30:00 | AAPL | Stock | 2.6393 | 2.6407 | 2.6382 | 2.6407 | 183400.0 |
| 2006-09-19 17:00:00 | AAPL | Stock | 2.6407 | 2.65 | 2.6404 | 2.6404 | 16961588.0 |
| 2006-09-19 17:30:00 | AAPL | Stock | 2.6404 | 2.6525 | 2.6404 | 2.6454 | 100324.0 |
| 2006-09-19 18:00:00 | AAPL | Stock | 2.6454 | 2.6454 | 2.6411 | 2.6429 | 47152.0 |
| 2006-09-19 06:30:00 | MSFT | Stock | 26.69 | 26.69 | 26.69 | 26.69 | 500.0 |
| 2006-09-19 07:00:00 | MSFT | Stock | 26.65 | 26.65 | 26.65 | 26.65 | 500.0 |
| 2006-09-19 07:30:00 | MSFT | Stock | 26.71 | 26.71 | 26.68 | 26.68 | 16800.0 |
| 2006-09-19 08:00:00 | MSFT | Stock | 26.68 | 26.7 | 26.66 | 26.68 | 29300.0 |
| 2006-09-19 08:30:00 | MSFT | Stock | 26.68 | 26.8 | 26.68 | 26.75 | 12000.0 |
| 2006-09-19 09:00:00 | MSFT | Stock | 26.76 | 26.78 | 26.7 | 26.75 | 59844.0 |
| 2006-09-19 09:30:00 | MSFT | Stock | 26.74 | 26.863 | 26.72 | 26.8 | 4085562.0 |
| 2006-09-19 10:00:00 | MSFT | Stock | 26.792 | 26.89 | 26.77 | 26.87 | 3040613.0 |
| 2006-09-19 10:30:00 | MSFT | Stock | 26.87 | 26.93 | 26.83 | 26.9 | 2807379.0 |
| 2006-09-19 11:00:00 | MSFT | Stock | 26.9 | 26.94 | 26.77 | 26.8 | 4196938.0 |
| 2006-09-19 11:30:00 | MSFT | Stock | 26.79 | 26.86 | 26.75 | 26.79 | 3960982.0 |
| 2006-09-19 12:00:00 | MSFT | Stock | 26.773 | 26.8 | 26.73 | 26.73 | 2609530.0 |
| 2006-09-19 12:30:00 | MSFT | Stock | 26.73 | 26.81 | 26.72 | 26.79 | 2555529.0 |
| 2006-09-19 13:00:00 | MSFT | Stock | 26.79 | 26.84 | 26.78 | 26.84 | 3023417.0 |
| 2006-09-19 13:30:00 | MSFT | Stock | 26.83 | 26.88 | 26.78 | 26.83 | 3051281.0 |
| 2006-09-19 14:00:00 | MSFT | Stock | 26.83 | 26.91 | 26.82 | 26.87 | 2208777.0 |
| 2006-09-19 14:30:00 | MSFT | Stock | 26.87 | 26.87 | 26.78 | 26.81 | 3178058.0 |
| 2006-09-19 15:00:00 | MSFT | Stock | 26.8 | 26.86 | 26.8 | 26.83 | 3128511.0 |
| 2006-09-19 15:30:00 | MSFT | Stock | 26.83 | 26.862 | 26.81 | 26.86 | 3195681.0 |
| 2006-09-19 16:00:00 | MSFT | Stock | 26.87 | 27.15 | 26.84 | 27.15 | 476687.0 |
| 2006-09-19 16:30:00 | MSFT | Stock | 27.15 | 27.15 | 27.06 | 27.06 | 38026.0 |
| 2006-09-19 17:00:00 | MSFT | Stock | 27.06 | 27.1 | 27.06 | 27.07 | 26350.0 |
| 2006-09-19 17:30:00 | MSFT | Stock | 27.08 | 27.09 | 27.07 | 27.07 | 4375.0 |
| 2006-09-19 18:00:00 | MSFT | Stock | 27.09 | 27.1 | 27.03 | 27.07 | 16190.0 |
| 2006-09-19 08:00:00 | NVDA | Stock | 0.5103 | 0.5103 | 0.505 | 0.505 | 2466000.0 |
| 2006-09-19 08:30:00 | NVDA | Stock | 0.5075 | 0.5083 | 0.5065 | 0.5065 | 634800.0 |
| 2006-09-19 09:00:00 | NVDA | Stock | 0.5075 | 0.5092 | 0.5075 | 0.508 | 553800.0 |
> showing 50 of 49,273 rows — these rows as CSV