PREVIEW / stock_30min / 2000-01-05
file: by_date/stock_30min/2000/2000-01-05.parquet size: 390 KB rows: 23,150 symbols: 1,123
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 |
|---|---|---|---|---|---|---|---|
| 2000-01-05 09:30:00 | AAPL | Stock | 0.9263 | 0.9431 | 0.9196 | 0.9219 | 76932800.0 |
| 2000-01-05 10:00:00 | AAPL | Stock | 0.9219 | 0.9554 | 0.9196 | 0.947 | 67121600.0 |
| 2000-01-05 10:30:00 | AAPL | Stock | 0.9475 | 0.9498 | 0.9241 | 0.9291 | 39166400.0 |
| 2000-01-05 11:00:00 | AAPL | Stock | 0.9288 | 0.9509 | 0.9258 | 0.9464 | 52920000.0 |
| 2000-01-05 11:30:00 | AAPL | Stock | 0.9453 | 0.9598 | 0.9408 | 0.9531 | 35291200.0 |
| 2000-01-05 12:00:00 | AAPL | Stock | 0.9542 | 0.9682 | 0.9453 | 0.9464 | 53872000.0 |
| 2000-01-05 12:30:00 | AAPL | Stock | 0.947 | 0.952 | 0.9252 | 0.9336 | 45203200.0 |
| 2000-01-05 13:00:00 | AAPL | Stock | 0.9325 | 0.9576 | 0.9308 | 0.9464 | 57400000.0 |
| 2000-01-05 13:30:00 | AAPL | Stock | 0.947 | 0.9554 | 0.9308 | 0.9386 | 34518400.0 |
| 2000-01-05 14:00:00 | AAPL | Stock | 0.9386 | 0.9665 | 0.9375 | 0.9537 | 66830400.0 |
| 2000-01-05 14:30:00 | AAPL | Stock | 0.9554 | 0.9872 | 0.9554 | 0.9612 | 114486400.0 |
| 2000-01-05 15:00:00 | AAPL | Stock | 0.9609 | 0.971 | 0.9475 | 0.9526 | 40051200.0 |
| 2000-01-05 15:30:00 | AAPL | Stock | 0.9545 | 0.9565 | 0.9286 | 0.9286 | 43220800.0 |
| 2000-01-05 16:00:00 | AAPL | Stock | 0.9291 | 0.9291 | 0.9286 | 0.9286 | 1131200.0 |
| 2000-01-05 09:30:00 | MSFT | Stock | 55.5625 | 56.125 | 55.0312 | 55.0625 | 8392400.0 |
| 2000-01-05 10:00:00 | MSFT | Stock | 55.0625 | 55.6875 | 54.6875 | 55.625 | 7594000.0 |
| 2000-01-05 10:30:00 | MSFT | Stock | 55.6875 | 55.9375 | 55.2188 | 55.3438 | 4575000.0 |
| 2000-01-05 11:00:00 | MSFT | Stock | 55.3125 | 56.3125 | 55.25 | 55.8125 | 4742600.0 |
| 2000-01-05 11:30:00 | MSFT | Stock | 55.8438 | 55.9688 | 55.5312 | 55.875 | 2391800.0 |
| 2000-01-05 12:00:00 | MSFT | Stock | 55.8438 | 55.875 | 55.3438 | 55.375 | 2370800.0 |
| 2000-01-05 12:30:00 | MSFT | Stock | 55.375 | 55.5625 | 55.2188 | 55.5625 | 1800000.0 |
| 2000-01-05 13:00:00 | MSFT | Stock | 55.5156 | 55.875 | 55.2812 | 55.75 | 1980600.0 |
| 2000-01-05 13:30:00 | MSFT | Stock | 55.75 | 56.6875 | 55.5938 | 56.6562 | 3181600.0 |
| 2000-01-05 14:00:00 | MSFT | Stock | 56.625 | 57.25 | 56.5 | 57.0625 | 5963000.0 |
| 2000-01-05 14:30:00 | MSFT | Stock | 57.0938 | 57.5938 | 57.0 | 57.3125 | 5910000.0 |
| 2000-01-05 15:00:00 | MSFT | Stock | 57.25 | 58.1875 | 57.2188 | 57.9688 | 5964800.0 |
| 2000-01-05 15:30:00 | MSFT | Stock | 57.9688 | 57.9688 | 56.875 | 56.875 | 4301400.0 |
| 2000-01-05 16:00:00 | MSFT | Stock | 56.875 | 57.2812 | 56.8438 | 56.9062 | 182400.0 |
| 2000-01-05 09:30:00 | NVDA | Stock | 0.0922 | 0.0937 | 0.0917 | 0.0922 | 29232000.0 |
| 2000-01-05 10:00:00 | NVDA | Stock | 0.0922 | 0.093 | 0.0911 | 0.0915 | 24096000.0 |
| 2000-01-05 10:30:00 | NVDA | Stock | 0.0914 | 0.0921 | 0.0914 | 0.0917 | 71616000.0 |
| 2000-01-05 11:00:00 | NVDA | Stock | 0.0927 | 0.0932 | 0.0921 | 0.0923 | 2304000.0 |
| 2000-01-05 11:30:00 | NVDA | Stock | 0.0923 | 0.0923 | 0.0919 | 0.0921 | 4464000.0 |
| 2000-01-05 12:00:00 | NVDA | Stock | 0.0919 | 0.0922 | 0.0917 | 0.0919 | 5904000.0 |
| 2000-01-05 12:30:00 | NVDA | Stock | 0.0921 | 0.0921 | 0.0914 | 0.0914 | 6864000.0 |
| 2000-01-05 13:00:00 | NVDA | Stock | 0.0914 | 0.0915 | 0.0914 | 0.0914 | 864000.0 |
| 2000-01-05 13:30:00 | NVDA | Stock | 0.0915 | 0.0917 | 0.0914 | 0.0915 | 2928000.0 |
| 2000-01-05 14:00:00 | NVDA | Stock | 0.0916 | 0.0932 | 0.0915 | 0.0924 | 6096000.0 |
| 2000-01-05 14:30:00 | NVDA | Stock | 0.0919 | 0.0924 | 0.0919 | 0.0921 | 4512000.0 |
| 2000-01-05 15:00:00 | NVDA | Stock | 0.0923 | 0.0924 | 0.0905 | 0.0914 | 8064000.0 |
| 2000-01-05 15:30:00 | NVDA | Stock | 0.0914 | 0.0917 | 0.0909 | 0.0917 | 5328000.0 |
| 2000-01-05 16:00:00 | NVDA | Stock | 0.0916 | 0.0918 | 0.0916 | 0.0918 | 3024000.0 |
| 2000-01-05 09:30:00 | AMZN | Stock | 3.525 | 3.6875 | 3.5 | 3.525 | 153140000.0 |
| 2000-01-05 10:00:00 | AMZN | Stock | 3.5 | 3.6125 | 3.4875 | 3.5875 | 71278000.0 |
| 2000-01-05 10:30:00 | AMZN | Stock | 3.5812 | 3.6375 | 3.5625 | 3.6062 | 37726000.0 |
| 2000-01-05 11:00:00 | AMZN | Stock | 3.6062 | 3.7562 | 3.6 | 3.6906 | 46916000.0 |
| 2000-01-05 11:30:00 | AMZN | Stock | 3.6906 | 3.7094 | 3.5844 | 3.5891 | 28716000.0 |
| 2000-01-05 12:00:00 | AMZN | Stock | 3.5844 | 3.6 | 3.5406 | 3.5406 | 28738000.0 |
| 2000-01-05 12:30:00 | AMZN | Stock | 3.5438 | 3.5812 | 3.5312 | 3.5656 | 25954000.0 |
| 2000-01-05 13:00:00 | AMZN | Stock | 3.5688 | 3.5938 | 3.5531 | 3.5812 | 17490000.0 |
> showing 50 of 23,150 rows — these rows as CSV