PREVIEW / stock_30min / 2001-03-09
file: by_date/stock_30min/2001/2001-03-09.parquet size: 512 KB rows: 26,534 symbols: 1,268
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-03-09 08:00:00 | AAPL | Stock | 0.3661 | 0.3683 | 0.3661 | 0.3683 | 246400.0 |
| 2001-03-09 08:30:00 | AAPL | Stock | 0.3661 | 0.3683 | 0.3661 | 0.3683 | 588000.0 |
| 2001-03-09 09:00:00 | AAPL | Stock | 0.3644 | 0.3694 | 0.3644 | 0.3672 | 2480800.0 |
| 2001-03-09 09:30:00 | AAPL | Stock | 0.3683 | 0.3694 | 0.3616 | 0.3627 | 46922400.0 |
| 2001-03-09 10:00:00 | AAPL | Stock | 0.3616 | 0.3627 | 0.3571 | 0.3605 | 35756000.0 |
| 2001-03-09 10:30:00 | AAPL | Stock | 0.3605 | 0.3638 | 0.3571 | 0.3638 | 31248000.0 |
| 2001-03-09 11:00:00 | AAPL | Stock | 0.3627 | 0.365 | 0.3583 | 0.3616 | 28280000.0 |
| 2001-03-09 11:30:00 | AAPL | Stock | 0.3611 | 0.365 | 0.3605 | 0.3616 | 18054400.0 |
| 2001-03-09 12:00:00 | AAPL | Stock | 0.3627 | 0.365 | 0.3616 | 0.3616 | 9766400.0 |
| 2001-03-09 12:30:00 | AAPL | Stock | 0.3638 | 0.3638 | 0.3583 | 0.3605 | 15136800.0 |
| 2001-03-09 13:00:00 | AAPL | Stock | 0.3605 | 0.3616 | 0.3583 | 0.3594 | 12566400.0 |
| 2001-03-09 13:30:00 | AAPL | Stock | 0.3605 | 0.3616 | 0.3594 | 0.3616 | 9548000.0 |
| 2001-03-09 14:00:00 | AAPL | Stock | 0.3605 | 0.3616 | 0.3594 | 0.3605 | 7873600.0 |
| 2001-03-09 14:30:00 | AAPL | Stock | 0.3605 | 0.3616 | 0.3594 | 0.3594 | 9380000.0 |
| 2001-03-09 15:00:00 | AAPL | Stock | 0.3605 | 0.3627 | 0.3583 | 0.3605 | 26852000.0 |
| 2001-03-09 15:30:00 | AAPL | Stock | 0.3616 | 0.3616 | 0.3594 | 0.3605 | 23133600.0 |
| 2001-03-09 16:00:00 | AAPL | Stock | 0.3605 | 0.3616 | 0.3583 | 0.3616 | 11312000.0 |
| 2001-03-09 16:30:00 | AAPL | Stock | 0.3616 | 0.3638 | 0.3616 | 0.3616 | 291200.0 |
| 2001-03-09 17:00:00 | AAPL | Stock | 0.3616 | 0.3616 | 0.3616 | 0.3616 | 543200.0 |
| 2001-03-09 08:00:00 | MSFT | Stock | 28.8125 | 29.1875 | 28.8125 | 29.1875 | 273400.0 |
| 2001-03-09 08:30:00 | MSFT | Stock | 29.0312 | 29.1875 | 28.875 | 29.0 | 518600.0 |
| 2001-03-09 09:00:00 | MSFT | Stock | 29.0 | 29.0938 | 28.875 | 28.9688 | 1106000.0 |
| 2001-03-09 09:30:00 | MSFT | Stock | 28.9688 | 29.0938 | 28.7812 | 28.875 | 9760000.0 |
| 2001-03-09 10:00:00 | MSFT | Stock | 28.875 | 28.9062 | 28.4375 | 28.5938 | 12959000.0 |
| 2001-03-09 10:30:00 | MSFT | Stock | 28.5938 | 28.625 | 28.4688 | 28.5625 | 4916800.0 |
| 2001-03-09 11:00:00 | MSFT | Stock | 28.5 | 28.5312 | 28.25 | 28.4062 | 4662200.0 |
| 2001-03-09 11:30:00 | MSFT | Stock | 28.4062 | 28.4062 | 28.1562 | 28.2812 | 4587800.0 |
| 2001-03-09 12:00:00 | MSFT | Stock | 28.2812 | 28.375 | 28.2188 | 28.25 | 2354400.0 |
| 2001-03-09 12:30:00 | MSFT | Stock | 28.25 | 28.2812 | 28.0312 | 28.0625 | 4133200.0 |
| 2001-03-09 13:00:00 | MSFT | Stock | 28.0938 | 28.3438 | 28.0625 | 28.0625 | 1945800.0 |
| 2001-03-09 13:30:00 | MSFT | Stock | 28.0625 | 28.3438 | 28.0625 | 28.3125 | 1757400.0 |
| 2001-03-09 14:00:00 | MSFT | Stock | 28.3438 | 28.375 | 28.0312 | 28.0625 | 2942200.0 |
| 2001-03-09 14:30:00 | MSFT | Stock | 28.0312 | 28.0625 | 27.5 | 27.5938 | 13956000.0 |
| 2001-03-09 15:00:00 | MSFT | Stock | 27.5938 | 28.5625 | 27.4375 | 28.1562 | 18770600.0 |
| 2001-03-09 15:30:00 | MSFT | Stock | 28.1406 | 28.4375 | 27.875 | 28.3125 | 11258600.0 |
| 2001-03-09 16:00:00 | MSFT | Stock | 28.3125 | 28.5938 | 28.0 | 28.3438 | 2776000.0 |
| 2001-03-09 16:30:00 | MSFT | Stock | 28.1875 | 28.3438 | 27.9375 | 28.0 | 123600.0 |
| 2001-03-09 17:00:00 | MSFT | Stock | 28.3438 | 28.3438 | 28.0625 | 28.125 | 70800.0 |
| 2001-03-09 17:30:00 | MSFT | Stock | 28.125 | 28.125 | 28.0625 | 28.0625 | 3800.0 |
| 2001-03-09 18:00:00 | MSFT | Stock | 28.125 | 28.125 | 28.0 | 28.0625 | 10800.0 |
| 2001-03-09 08:00:00 | NVDA | Stock | 0.2146 | 0.2146 | 0.2125 | 0.2146 | 192000.0 |
| 2001-03-09 08:30:00 | NVDA | Stock | 0.2146 | 0.2146 | 0.213 | 0.2146 | 576000.0 |
| 2001-03-09 09:00:00 | NVDA | Stock | 0.2167 | 0.2188 | 0.2128 | 0.2128 | 2784000.0 |
| 2001-03-09 09:30:00 | NVDA | Stock | 0.2128 | 0.2138 | 0.2052 | 0.2096 | 174840000.0 |
| 2001-03-09 10:00:00 | NVDA | Stock | 0.2107 | 0.2107 | 0.2063 | 0.2073 | 68184000.0 |
| 2001-03-09 10:30:00 | NVDA | Stock | 0.2076 | 0.2094 | 0.2052 | 0.207 | 65616000.0 |
| 2001-03-09 11:00:00 | NVDA | Stock | 0.2073 | 0.2078 | 0.2052 | 0.2078 | 35616000.0 |
| 2001-03-09 11:30:00 | NVDA | Stock | 0.2076 | 0.2083 | 0.2068 | 0.2083 | 46512000.0 |
| 2001-03-09 12:00:00 | NVDA | Stock | 0.2083 | 0.2096 | 0.2076 | 0.2076 | 47640000.0 |
| 2001-03-09 12:30:00 | NVDA | Stock | 0.2073 | 0.2091 | 0.2073 | 0.2089 | 18912000.0 |
> showing 50 of 26,534 rows — these rows as CSV