PREVIEW / stock_30min / 2000-07-18
file: by_date/stock_30min/2000/2000-07-18.parquet size: 434 KB rows: 25,159 symbols: 1,199
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-07-18 08:00:00 | AAPL | Stock | 1.0458 | 1.0458 | 1.0424 | 1.0424 | 22400.0 |
| 2000-07-18 08:30:00 | AAPL | Stock | 1.0536 | 1.0536 | 1.0357 | 1.0424 | 184800.0 |
| 2000-07-18 09:00:00 | AAPL | Stock | 1.0446 | 1.0513 | 1.0402 | 1.0446 | 1948800.0 |
| 2000-07-18 09:30:00 | AAPL | Stock | 1.0446 | 1.0513 | 1.0357 | 1.0458 | 42397600.0 |
| 2000-07-18 10:00:00 | AAPL | Stock | 1.0458 | 1.0469 | 1.0391 | 1.0402 | 31057600.0 |
| 2000-07-18 10:30:00 | AAPL | Stock | 1.0402 | 1.0402 | 1.0156 | 1.0223 | 31102400.0 |
| 2000-07-18 11:00:00 | AAPL | Stock | 1.0223 | 1.0324 | 1.0179 | 1.0268 | 8562400.0 |
| 2000-07-18 11:30:00 | AAPL | Stock | 1.0246 | 1.0413 | 1.0201 | 1.0313 | 13619200.0 |
| 2000-07-18 12:00:00 | AAPL | Stock | 1.0335 | 1.0402 | 1.0335 | 1.0357 | 16172800.0 |
| 2000-07-18 12:30:00 | AAPL | Stock | 1.0357 | 1.0379 | 1.0324 | 1.0357 | 7095200.0 |
| 2000-07-18 13:00:00 | AAPL | Stock | 1.0357 | 1.0357 | 1.0179 | 1.0246 | 11446400.0 |
| 2000-07-18 13:30:00 | AAPL | Stock | 1.0201 | 1.0313 | 1.0179 | 1.029 | 14196000.0 |
| 2000-07-18 14:00:00 | AAPL | Stock | 1.029 | 1.0301 | 1.0179 | 1.0234 | 17505600.0 |
| 2000-07-18 14:30:00 | AAPL | Stock | 1.0234 | 1.0335 | 1.0212 | 1.0268 | 18452000.0 |
| 2000-07-18 15:00:00 | AAPL | Stock | 1.0279 | 1.0313 | 1.019 | 1.0313 | 21576800.0 |
| 2000-07-18 15:30:00 | AAPL | Stock | 1.0313 | 1.0491 | 1.0201 | 1.0201 | 40107200.0 |
| 2000-07-18 16:00:00 | AAPL | Stock | 1.0234 | 1.0368 | 1.0045 | 1.0212 | 13020000.0 |
| 2000-07-18 16:30:00 | AAPL | Stock | 1.0212 | 1.1038 | 0.9464 | 0.9542 | 17320800.0 |
| 2000-07-18 17:00:00 | AAPL | Stock | 0.9542 | 0.9598 | 0.9464 | 0.9554 | 3259200.0 |
| 2000-07-18 17:30:00 | AAPL | Stock | 0.9554 | 0.9643 | 0.9464 | 0.9598 | 929600.0 |
| 2000-07-18 18:00:00 | AAPL | Stock | 0.9598 | 0.9671 | 0.9598 | 0.9643 | 700000.0 |
| 2000-07-18 08:00:00 | MSFT | Stock | 39.1875 | 39.1875 | 39.0938 | 39.125 | 39600.0 |
| 2000-07-18 08:30:00 | MSFT | Stock | 39.125 | 39.1875 | 38.9688 | 39.0 | 26000.0 |
| 2000-07-18 09:00:00 | MSFT | Stock | 39.0625 | 39.125 | 38.7812 | 38.8125 | 200600.0 |
| 2000-07-18 09:30:00 | MSFT | Stock | 38.8125 | 39.125 | 38.7188 | 39.0938 | 6098400.0 |
| 2000-07-18 10:00:00 | MSFT | Stock | 39.125 | 39.3438 | 39.0 | 39.125 | 6416400.0 |
| 2000-07-18 10:30:00 | MSFT | Stock | 39.0938 | 39.2812 | 38.875 | 38.9688 | 6160200.0 |
| 2000-07-18 11:00:00 | MSFT | Stock | 38.9375 | 39.0469 | 38.8125 | 38.8438 | 3727400.0 |
| 2000-07-18 11:30:00 | MSFT | Stock | 38.875 | 39.0625 | 38.75 | 39.0 | 3679600.0 |
| 2000-07-18 12:00:00 | MSFT | Stock | 39.0 | 39.375 | 38.9688 | 39.1875 | 4267000.0 |
| 2000-07-18 12:30:00 | MSFT | Stock | 39.1875 | 39.3125 | 39.0625 | 39.25 | 2626400.0 |
| 2000-07-18 13:00:00 | MSFT | Stock | 39.2812 | 39.5 | 39.2188 | 39.4688 | 3905400.0 |
| 2000-07-18 13:30:00 | MSFT | Stock | 39.4375 | 39.5938 | 39.3125 | 39.5312 | 4120000.0 |
| 2000-07-18 14:00:00 | MSFT | Stock | 39.5312 | 39.5625 | 39.25 | 39.3125 | 3798200.0 |
| 2000-07-18 14:30:00 | MSFT | Stock | 39.2812 | 39.625 | 39.2188 | 39.5312 | 5490200.0 |
| 2000-07-18 15:00:00 | MSFT | Stock | 39.5312 | 39.5625 | 39.0938 | 39.2812 | 4657000.0 |
| 2000-07-18 15:30:00 | MSFT | Stock | 39.2812 | 39.5312 | 39.0 | 39.25 | 8437400.0 |
| 2000-07-18 16:00:00 | MSFT | Stock | 39.3125 | 40.0 | 39.0156 | 39.75 | 3644600.0 |
| 2000-07-18 16:30:00 | MSFT | Stock | 39.7812 | 40.125 | 38.8281 | 40.0 | 1329200.0 |
| 2000-07-18 17:00:00 | MSFT | Stock | 40.0625 | 40.1875 | 39.9375 | 40.0 | 347800.0 |
| 2000-07-18 17:30:00 | MSFT | Stock | 40.0 | 40.125 | 39.0938 | 40.0312 | 169200.0 |
| 2000-07-18 18:00:00 | MSFT | Stock | 40.0625 | 40.125 | 39.25 | 39.4375 | 309800.0 |
| 2000-07-18 08:30:00 | NVDA | Stock | 0.3042 | 0.3042 | 0.3042 | 0.3042 | 288000.0 |
| 2000-07-18 09:00:00 | NVDA | Stock | 0.2938 | 0.2938 | 0.2854 | 0.2872 | 1176000.0 |
| 2000-07-18 09:30:00 | NVDA | Stock | 0.2875 | 0.3 | 0.2875 | 0.2974 | 37608000.0 |
| 2000-07-18 10:00:00 | NVDA | Stock | 0.298 | 0.299 | 0.2918 | 0.2938 | 20496000.0 |
| 2000-07-18 10:30:00 | NVDA | Stock | 0.2927 | 0.2943 | 0.2911 | 0.2938 | 7608000.0 |
| 2000-07-18 11:00:00 | NVDA | Stock | 0.2932 | 0.2938 | 0.2901 | 0.2906 | 14232000.0 |
| 2000-07-18 11:30:00 | NVDA | Stock | 0.2906 | 0.2938 | 0.2906 | 0.2917 | 4488000.0 |
| 2000-07-18 12:00:00 | NVDA | Stock | 0.2911 | 0.293 | 0.2891 | 0.2901 | 6288000.0 |
> showing 50 of 25,159 rows — these rows as CSV