PREVIEW / stock_30min / 2001-01-25
file: by_date/stock_30min/2001/2001-01-25.parquet size: 454 KB rows: 26,264 symbols: 1,253
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-25 08:00:00 | AAPL | Stock | 0.3672 | 0.3672 | 0.3661 | 0.3661 | 33600.0 |
| 2001-01-25 08:30:00 | AAPL | Stock | 0.3672 | 0.3672 | 0.3672 | 0.3672 | 78400.0 |
| 2001-01-25 09:00:00 | AAPL | Stock | 0.3672 | 0.3683 | 0.3583 | 0.3672 | 722400.0 |
| 2001-01-25 09:30:00 | AAPL | Stock | 0.3672 | 0.3672 | 0.3583 | 0.3605 | 23038400.0 |
| 2001-01-25 10:00:00 | AAPL | Stock | 0.3616 | 0.3627 | 0.3594 | 0.3611 | 27081600.0 |
| 2001-01-25 10:30:00 | AAPL | Stock | 0.3611 | 0.3627 | 0.3594 | 0.3616 | 36909600.0 |
| 2001-01-25 11:00:00 | AAPL | Stock | 0.3616 | 0.3616 | 0.3571 | 0.3594 | 48647200.0 |
| 2001-01-25 11:30:00 | AAPL | Stock | 0.3605 | 0.3638 | 0.3583 | 0.3616 | 26090400.0 |
| 2001-01-25 12:00:00 | AAPL | Stock | 0.3616 | 0.3616 | 0.3583 | 0.3583 | 10063200.0 |
| 2001-01-25 12:30:00 | AAPL | Stock | 0.3583 | 0.3594 | 0.356 | 0.3571 | 20384000.0 |
| 2001-01-25 13:00:00 | AAPL | Stock | 0.3571 | 0.3583 | 0.3549 | 0.3571 | 18681600.0 |
| 2001-01-25 13:30:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3538 | 0.356 | 24903200.0 |
| 2001-01-25 14:00:00 | AAPL | Stock | 0.3549 | 0.3571 | 0.3527 | 0.3549 | 27720000.0 |
| 2001-01-25 14:30:00 | AAPL | Stock | 0.3549 | 0.356 | 0.3538 | 0.356 | 58189600.0 |
| 2001-01-25 15:00:00 | AAPL | Stock | 0.3549 | 0.356 | 0.3538 | 0.3538 | 31701600.0 |
| 2001-01-25 15:30:00 | AAPL | Stock | 0.3527 | 0.356 | 0.3527 | 0.3549 | 26577600.0 |
| 2001-01-25 16:00:00 | AAPL | Stock | 0.356 | 0.3571 | 0.3549 | 0.356 | 13736800.0 |
| 2001-01-25 16:30:00 | AAPL | Stock | 0.356 | 0.3571 | 0.356 | 0.356 | 509600.0 |
| 2001-01-25 17:00:00 | AAPL | Stock | 0.356 | 0.356 | 0.356 | 0.356 | 599200.0 |
| 2001-01-25 17:30:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3549 | 0.3549 | 61600.0 |
| 2001-01-25 18:00:00 | AAPL | Stock | 0.3527 | 0.356 | 0.3527 | 0.3527 | 100800.0 |
| 2001-01-25 08:00:00 | MSFT | Stock | 31.5 | 31.6562 | 31.25 | 31.375 | 27600.0 |
| 2001-01-25 08:30:00 | MSFT | Stock | 31.5 | 31.6562 | 31.2812 | 31.4062 | 32200.0 |
| 2001-01-25 09:00:00 | MSFT | Stock | 31.4062 | 32.5 | 31.3125 | 31.375 | 182200.0 |
| 2001-01-25 09:30:00 | MSFT | Stock | 31.375 | 31.9375 | 31.3125 | 31.9062 | 9956600.0 |
| 2001-01-25 10:00:00 | MSFT | Stock | 31.9062 | 32.0 | 31.625 | 31.625 | 8127400.0 |
| 2001-01-25 10:30:00 | MSFT | Stock | 31.6562 | 31.7188 | 31.4062 | 31.5 | 7177600.0 |
| 2001-01-25 11:00:00 | MSFT | Stock | 31.4688 | 31.5625 | 31.4375 | 31.5312 | 5528800.0 |
| 2001-01-25 11:30:00 | MSFT | Stock | 31.5 | 31.875 | 31.3438 | 31.75 | 7002200.0 |
| 2001-01-25 12:00:00 | MSFT | Stock | 31.75 | 31.75 | 31.4062 | 31.625 | 4125000.0 |
| 2001-01-25 12:30:00 | MSFT | Stock | 31.625 | 31.6562 | 31.5 | 31.5 | 1310600.0 |
| 2001-01-25 13:00:00 | MSFT | Stock | 31.5 | 31.5938 | 31.4688 | 31.5312 | 2762000.0 |
| 2001-01-25 13:30:00 | MSFT | Stock | 31.5625 | 31.7812 | 31.4062 | 31.4688 | 4703400.0 |
| 2001-01-25 14:00:00 | MSFT | Stock | 31.5 | 31.5 | 31.0 | 31.0 | 6462600.0 |
| 2001-01-25 14:30:00 | MSFT | Stock | 31.0 | 31.0312 | 30.7812 | 30.9375 | 6202400.0 |
| 2001-01-25 15:00:00 | MSFT | Stock | 30.9375 | 31.0938 | 30.875 | 30.9375 | 3222600.0 |
| 2001-01-25 15:30:00 | MSFT | Stock | 30.9688 | 31.0625 | 30.8438 | 30.9688 | 6764200.0 |
| 2001-01-25 16:00:00 | MSFT | Stock | 30.9062 | 31.9688 | 30.7812 | 30.8438 | 2020000.0 |
| 2001-01-25 16:30:00 | MSFT | Stock | 30.9062 | 31.7344 | 30.75 | 30.9062 | 384800.0 |
| 2001-01-25 17:00:00 | MSFT | Stock | 30.8438 | 30.9062 | 30.6875 | 30.6875 | 53200.0 |
| 2001-01-25 17:30:00 | MSFT | Stock | 30.75 | 30.75 | 30.4375 | 30.4688 | 47600.0 |
| 2001-01-25 18:00:00 | MSFT | Stock | 30.5 | 30.5 | 29.9062 | 30.0 | 98400.0 |
| 2001-01-25 18:30:00 | MSFT | Stock | 30.0 | 30.0 | 30.0 | 30.0 | 1600.0 |
| 2001-01-25 09:00:00 | NVDA | Stock | 0.225 | 0.2263 | 0.2208 | 0.2208 | 480000.0 |
| 2001-01-25 09:30:00 | NVDA | Stock | 0.2203 | 0.2206 | 0.2151 | 0.2188 | 32400000.0 |
| 2001-01-25 10:00:00 | NVDA | Stock | 0.219 | 0.2208 | 0.2125 | 0.2141 | 36912000.0 |
| 2001-01-25 10:30:00 | NVDA | Stock | 0.2143 | 0.2167 | 0.2125 | 0.213 | 22968000.0 |
| 2001-01-25 11:00:00 | NVDA | Stock | 0.2128 | 0.2151 | 0.2104 | 0.2115 | 33816000.0 |
| 2001-01-25 11:30:00 | NVDA | Stock | 0.212 | 0.218 | 0.2107 | 0.2159 | 14040000.0 |
| 2001-01-25 12:00:00 | NVDA | Stock | 0.2156 | 0.2167 | 0.2126 | 0.2151 | 11808000.0 |
> showing 50 of 26,264 rows — these rows as CSV