PREVIEW / stock_30min / 2001-01-23
file: by_date/stock_30min/2001/2001-01-23.parquet size: 463 KB rows: 27,399 symbols: 1,265
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 |
|---|---|---|---|---|---|---|---|
| 2001-01-23 08:00:00 | AAPL | Stock | 0.3432 | 0.3493 | 0.3398 | 0.3398 | 873600.0 |
| 2001-01-23 08:30:00 | AAPL | Stock | 0.3449 | 0.3482 | 0.3438 | 0.3438 | 151200.0 |
| 2001-01-23 09:00:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3415 | 0.3438 | 2755200.0 |
| 2001-01-23 09:30:00 | AAPL | Stock | 0.3449 | 0.3471 | 0.3404 | 0.3415 | 40717600.0 |
| 2001-01-23 10:00:00 | AAPL | Stock | 0.3404 | 0.3516 | 0.3404 | 0.3493 | 81715200.0 |
| 2001-01-23 10:30:00 | AAPL | Stock | 0.3493 | 0.3538 | 0.3493 | 0.3516 | 33885600.0 |
| 2001-01-23 11:00:00 | AAPL | Stock | 0.3516 | 0.3527 | 0.3482 | 0.3499 | 26756800.0 |
| 2001-01-23 11:30:00 | AAPL | Stock | 0.3504 | 0.3571 | 0.3493 | 0.3549 | 34092800.0 |
| 2001-01-23 12:00:00 | AAPL | Stock | 0.3549 | 0.3594 | 0.3538 | 0.3583 | 47034400.0 |
| 2001-01-23 12:30:00 | AAPL | Stock | 0.3594 | 0.3661 | 0.356 | 0.3627 | 67384800.0 |
| 2001-01-23 13:00:00 | AAPL | Stock | 0.3616 | 0.3661 | 0.3616 | 0.3627 | 26051200.0 |
| 2001-01-23 13:30:00 | AAPL | Stock | 0.3627 | 0.365 | 0.3616 | 0.3638 | 14252000.0 |
| 2001-01-23 14:00:00 | AAPL | Stock | 0.3627 | 0.3672 | 0.3627 | 0.365 | 41400800.0 |
| 2001-01-23 14:30:00 | AAPL | Stock | 0.3661 | 0.3683 | 0.3627 | 0.3672 | 92092000.0 |
| 2001-01-23 15:00:00 | AAPL | Stock | 0.3683 | 0.3739 | 0.365 | 0.3683 | 119442400.0 |
| 2001-01-23 15:30:00 | AAPL | Stock | 0.3683 | 0.3705 | 0.3638 | 0.3672 | 109429600.0 |
| 2001-01-23 16:00:00 | AAPL | Stock | 0.3672 | 0.3683 | 0.3571 | 0.3661 | 37436000.0 |
| 2001-01-23 16:30:00 | AAPL | Stock | 0.3638 | 0.3739 | 0.3638 | 0.3728 | 2536800.0 |
| 2001-01-23 17:00:00 | AAPL | Stock | 0.3733 | 0.3733 | 0.3661 | 0.3705 | 1534400.0 |
| 2001-01-23 17:30:00 | AAPL | Stock | 0.3717 | 0.375 | 0.3717 | 0.375 | 448000.0 |
| 2001-01-23 18:00:00 | AAPL | Stock | 0.375 | 0.3761 | 0.375 | 0.3761 | 218400.0 |
| 2001-01-23 08:00:00 | MSFT | Stock | 30.0 | 30.1875 | 29.875 | 30.0 | 92200.0 |
| 2001-01-23 08:30:00 | MSFT | Stock | 30.0625 | 30.125 | 30.0 | 30.0625 | 25000.0 |
| 2001-01-23 09:00:00 | MSFT | Stock | 30.0625 | 30.1562 | 29.8438 | 29.8438 | 241200.0 |
| 2001-01-23 09:30:00 | MSFT | Stock | 29.875 | 30.0 | 29.625 | 29.6875 | 7131400.0 |
| 2001-01-23 10:00:00 | MSFT | Stock | 29.7031 | 29.7188 | 29.4688 | 29.625 | 6109200.0 |
| 2001-01-23 10:30:00 | MSFT | Stock | 29.625 | 29.8125 | 29.5 | 29.75 | 4864800.0 |
| 2001-01-23 11:00:00 | MSFT | Stock | 29.75 | 29.7812 | 29.625 | 29.7188 | 3070200.0 |
| 2001-01-23 11:30:00 | MSFT | Stock | 29.6875 | 29.9688 | 29.6875 | 29.8438 | 3415000.0 |
| 2001-01-23 12:00:00 | MSFT | Stock | 29.8125 | 30.0 | 29.8125 | 29.9375 | 3623000.0 |
| 2001-01-23 12:30:00 | MSFT | Stock | 29.9688 | 29.9688 | 29.7812 | 29.8125 | 1924000.0 |
| 2001-01-23 13:00:00 | MSFT | Stock | 29.8438 | 29.9375 | 29.6875 | 29.9375 | 3140600.0 |
| 2001-01-23 13:30:00 | MSFT | Stock | 29.9375 | 30.125 | 29.9062 | 30.0312 | 5567000.0 |
| 2001-01-23 14:00:00 | MSFT | Stock | 30.0312 | 30.3125 | 29.9688 | 30.2812 | 5499800.0 |
| 2001-01-23 14:30:00 | MSFT | Stock | 30.2812 | 30.4062 | 30.1719 | 30.3281 | 6189400.0 |
| 2001-01-23 15:00:00 | MSFT | Stock | 30.3281 | 30.4688 | 30.25 | 30.2812 | 5178200.0 |
| 2001-01-23 15:30:00 | MSFT | Stock | 30.2812 | 30.4375 | 30.125 | 30.2812 | 5827400.0 |
| 2001-01-23 16:00:00 | MSFT | Stock | 30.2812 | 30.4375 | 29.6562 | 30.0938 | 2037000.0 |
| 2001-01-23 16:30:00 | MSFT | Stock | 30.4375 | 30.625 | 29.625 | 30.5625 | 183600.0 |
| 2001-01-23 17:00:00 | MSFT | Stock | 30.5312 | 30.9375 | 30.2812 | 30.8125 | 146800.0 |
| 2001-01-23 17:30:00 | MSFT | Stock | 30.9375 | 31.0625 | 29.875 | 30.6875 | 46200.0 |
| 2001-01-23 18:00:00 | MSFT | Stock | 30.8125 | 30.9375 | 30.8125 | 30.9375 | 7200.0 |
| 2001-01-23 18:30:00 | MSFT | Stock | 30.9375 | 30.9375 | 30.9375 | 30.9375 | 400.0 |
| 2001-01-23 09:00:00 | NVDA | Stock | 0.2078 | 0.2078 | 0.2052 | 0.2057 | 600000.0 |
| 2001-01-23 09:30:00 | NVDA | Stock | 0.2057 | 0.2125 | 0.2049 | 0.2078 | 31104000.0 |
| 2001-01-23 10:00:00 | NVDA | Stock | 0.2073 | 0.2081 | 0.2047 | 0.2068 | 15264000.0 |
| 2001-01-23 10:30:00 | NVDA | Stock | 0.2063 | 0.21 | 0.2049 | 0.21 | 28248000.0 |
| 2001-01-23 11:00:00 | NVDA | Stock | 0.2096 | 0.2096 | 0.2055 | 0.2068 | 13152000.0 |
| 2001-01-23 11:30:00 | NVDA | Stock | 0.2057 | 0.2091 | 0.2055 | 0.2076 | 11880000.0 |
| 2001-01-23 12:00:00 | NVDA | Stock | 0.2078 | 0.2156 | 0.2073 | 0.2146 | 33552000.0 |
> showing 50 of 27,399 rows — these rows as CSV