PREVIEW / stock_30min / 2006-01-05
file: by_date/stock_30min/2006/2006-01-05.parquet size: 887 KB rows: 48,190 symbols: 2,169
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-01-05 07:30:00 | AAPL | Stock | 2.6775 | 2.6775 | 2.6775 | 2.6775 | 2800.0 |
| 2006-01-05 08:00:00 | AAPL | Stock | 2.6775 | 2.6775 | 2.6679 | 2.6732 | 432796.0 |
| 2006-01-05 08:30:00 | AAPL | Stock | 2.6704 | 2.6704 | 2.6621 | 2.6625 | 537768.0 |
| 2006-01-05 09:00:00 | AAPL | Stock | 2.6654 | 2.675 | 2.6607 | 2.675 | 3581956.0 |
| 2006-01-05 09:30:00 | AAPL | Stock | 2.6725 | 2.675 | 2.6427 | 2.6489 | 64961932.0 |
| 2006-01-05 10:00:00 | AAPL | Stock | 2.6429 | 2.675 | 2.6428 | 2.65 | 57105440.0 |
| 2006-01-05 10:30:00 | AAPL | Stock | 2.6504 | 2.6596 | 2.6486 | 2.6536 | 38166800.0 |
| 2006-01-05 11:00:00 | AAPL | Stock | 2.6536 | 2.6629 | 2.6536 | 2.6557 | 25777024.0 |
| 2006-01-05 11:30:00 | AAPL | Stock | 2.6561 | 2.6607 | 2.6518 | 2.6579 | 21165032.0 |
| 2006-01-05 12:00:00 | AAPL | Stock | 2.6579 | 2.66 | 2.6546 | 2.6554 | 17383380.0 |
| 2006-01-05 12:30:00 | AAPL | Stock | 2.6557 | 2.6568 | 2.6339 | 2.6346 | 41405588.0 |
| 2006-01-05 13:00:00 | AAPL | Stock | 2.6339 | 2.6571 | 2.6339 | 2.6443 | 29104152.0 |
| 2006-01-05 13:30:00 | AAPL | Stock | 2.6443 | 2.6529 | 2.6421 | 2.6486 | 21864332.0 |
| 2006-01-05 14:00:00 | AAPL | Stock | 2.6486 | 2.6496 | 2.6407 | 2.6425 | 22875580.0 |
| 2006-01-05 14:30:00 | AAPL | Stock | 2.6425 | 2.65 | 2.6382 | 2.6493 | 23541644.0 |
| 2006-01-05 15:00:00 | AAPL | Stock | 2.65 | 2.6564 | 2.6479 | 2.655 | 25120592.0 |
| 2006-01-05 15:30:00 | AAPL | Stock | 2.655 | 2.66 | 2.6464 | 2.6564 | 43345820.0 |
| 2006-01-05 16:00:00 | AAPL | Stock | 2.6532 | 2.6571 | 2.6504 | 2.6568 | 1631896.0 |
| 2006-01-05 16:30:00 | AAPL | Stock | 2.6554 | 2.6554 | 2.6539 | 2.6543 | 74032.0 |
| 2006-01-05 17:00:00 | AAPL | Stock | 2.655 | 2.6554 | 2.6525 | 2.6554 | 53200.0 |
| 2006-01-05 17:30:00 | AAPL | Stock | 2.655 | 2.655 | 2.6529 | 2.6536 | 21868.0 |
| 2006-01-05 18:00:00 | AAPL | Stock | 2.6532 | 2.655 | 2.6525 | 2.655 | 152936.0 |
| 2006-01-05 07:30:00 | MSFT | Stock | 27.04 | 27.04 | 26.87 | 26.87 | 270.0 |
| 2006-01-05 08:00:00 | MSFT | Stock | 27.0 | 27.03 | 26.99 | 27.0 | 6000.0 |
| 2006-01-05 08:30:00 | MSFT | Stock | 26.99 | 26.99 | 26.95 | 26.95 | 1668.0 |
| 2006-01-05 09:00:00 | MSFT | Stock | 26.95 | 26.98 | 26.9 | 26.94 | 18115.0 |
| 2006-01-05 09:30:00 | MSFT | Stock | 26.96 | 27.12 | 26.91 | 27.02 | 5018095.0 |
| 2006-01-05 10:00:00 | MSFT | Stock | 27.02 | 27.13 | 27.01 | 27.04 | 4178497.0 |
| 2006-01-05 10:30:00 | MSFT | Stock | 27.04 | 27.1 | 27.01 | 27.04 | 3180396.0 |
| 2006-01-05 11:00:00 | MSFT | Stock | 27.03 | 27.066 | 27.02 | 27.04 | 2138210.0 |
| 2006-01-05 11:30:00 | MSFT | Stock | 27.03 | 27.09 | 27.03 | 27.06 | 3027198.0 |
| 2006-01-05 12:00:00 | MSFT | Stock | 27.06 | 27.1 | 27.01 | 27.03 | 3910819.0 |
| 2006-01-05 12:30:00 | MSFT | Stock | 27.03 | 27.05 | 26.96 | 27.002 | 4335454.0 |
| 2006-01-05 13:00:00 | MSFT | Stock | 27.0 | 27.04 | 26.95 | 27.03 | 3431985.0 |
| 2006-01-05 13:30:00 | MSFT | Stock | 27.03 | 27.07 | 27.0 | 27.02 | 2607144.0 |
| 2006-01-05 14:00:00 | MSFT | Stock | 27.01 | 27.05 | 26.99 | 27.0 | 2590271.0 |
| 2006-01-05 14:30:00 | MSFT | Stock | 27.0 | 27.07 | 27.0 | 27.04 | 2333212.0 |
| 2006-01-05 15:00:00 | MSFT | Stock | 27.03 | 27.04 | 26.99 | 27.01 | 3703413.0 |
| 2006-01-05 15:30:00 | MSFT | Stock | 27.01 | 27.05 | 26.94 | 27.0 | 5993084.0 |
| 2006-01-05 16:00:00 | MSFT | Stock | 26.99 | 27.04 | 26.97 | 26.99 | 162569.0 |
| 2006-01-05 16:30:00 | MSFT | Stock | 27.0 | 27.02 | 26.99 | 27.01 | 1934.0 |
| 2006-01-05 17:30:00 | MSFT | Stock | 27.01 | 27.01 | 27.01 | 27.01 | 500.0 |
| 2006-01-05 18:00:00 | MSFT | Stock | 27.01 | 27.01 | 26.99 | 27.0 | 2061.0 |
| 2006-01-05 08:00:00 | NVDA | Stock | 0.3274 | 0.3274 | 0.3274 | 0.3274 | 24000.0 |
| 2006-01-05 08:30:00 | NVDA | Stock | 0.3257 | 0.3257 | 0.3257 | 0.3257 | 24000.0 |
| 2006-01-05 09:00:00 | NVDA | Stock | 0.3271 | 0.3274 | 0.3271 | 0.3274 | 368640.0 |
| 2006-01-05 09:30:00 | NVDA | Stock | 0.3275 | 0.3346 | 0.3269 | 0.3314 | 111189840.0 |
| 2006-01-05 10:00:00 | NVDA | Stock | 0.3316 | 0.3342 | 0.3312 | 0.3322 | 106422120.0 |
| 2006-01-05 10:30:00 | NVDA | Stock | 0.3322 | 0.3332 | 0.3298 | 0.3324 | 37525920.0 |
| 2006-01-05 11:00:00 | NVDA | Stock | 0.3324 | 0.3342 | 0.3323 | 0.3332 | 33501360.0 |
> showing 50 of 48,190 rows — these rows as CSV