PREVIEW / stock_30min / 2001-03-12
file: by_date/stock_30min/2001/2001-03-12.parquet size: 538 KB rows: 27,653 symbols: 1,282
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-12 08:00:00 | AAPL | Stock | 0.3611 | 0.3611 | 0.3527 | 0.3527 | 436800.0 |
| 2001-03-12 08:30:00 | AAPL | Stock | 0.3527 | 0.3527 | 0.3527 | 0.3527 | 67200.0 |
| 2001-03-12 09:00:00 | AAPL | Stock | 0.3549 | 0.356 | 0.3516 | 0.3527 | 1304800.0 |
| 2001-03-12 09:30:00 | AAPL | Stock | 0.3516 | 0.3549 | 0.3449 | 0.3538 | 40236000.0 |
| 2001-03-12 10:00:00 | AAPL | Stock | 0.3538 | 0.3538 | 0.3482 | 0.3493 | 8881600.0 |
| 2001-03-12 10:30:00 | AAPL | Stock | 0.3504 | 0.3504 | 0.3449 | 0.346 | 19202400.0 |
| 2001-03-12 11:00:00 | AAPL | Stock | 0.3449 | 0.3493 | 0.3315 | 0.3337 | 72072000.0 |
| 2001-03-12 11:30:00 | AAPL | Stock | 0.3337 | 0.3348 | 0.3281 | 0.3281 | 46037600.0 |
| 2001-03-12 12:00:00 | AAPL | Stock | 0.3292 | 0.3292 | 0.3237 | 0.3281 | 44492000.0 |
| 2001-03-12 12:30:00 | AAPL | Stock | 0.3281 | 0.3404 | 0.327 | 0.3404 | 31645600.0 |
| 2001-03-12 13:00:00 | AAPL | Stock | 0.3404 | 0.3438 | 0.3382 | 0.3426 | 21828800.0 |
| 2001-03-12 13:30:00 | AAPL | Stock | 0.3415 | 0.3426 | 0.3326 | 0.3326 | 16833600.0 |
| 2001-03-12 14:00:00 | AAPL | Stock | 0.3326 | 0.3415 | 0.3326 | 0.3415 | 10640000.0 |
| 2001-03-12 14:30:00 | AAPL | Stock | 0.3415 | 0.3426 | 0.3371 | 0.3393 | 11944800.0 |
| 2001-03-12 15:00:00 | AAPL | Stock | 0.3393 | 0.3415 | 0.3348 | 0.3371 | 8999200.0 |
| 2001-03-12 15:30:00 | AAPL | Stock | 0.3359 | 0.3371 | 0.327 | 0.3337 | 30144800.0 |
| 2001-03-12 16:00:00 | AAPL | Stock | 0.3326 | 0.3343 | 0.327 | 0.327 | 9234400.0 |
| 2001-03-12 16:30:00 | AAPL | Stock | 0.3304 | 0.3359 | 0.3304 | 0.3326 | 4149600.0 |
| 2001-03-12 17:30:00 | AAPL | Stock | 0.3326 | 0.3326 | 0.3326 | 0.3326 | 11200.0 |
| 2001-03-12 18:00:00 | AAPL | Stock | 0.3304 | 0.3304 | 0.3304 | 0.3304 | 28000.0 |
| 2001-03-12 08:00:00 | MSFT | Stock | 27.75 | 28.3281 | 27.6875 | 27.9062 | 185400.0 |
| 2001-03-12 08:30:00 | MSFT | Stock | 27.8438 | 28.3438 | 27.5625 | 27.75 | 136200.0 |
| 2001-03-12 09:00:00 | MSFT | Stock | 27.8125 | 28.0 | 27.3125 | 27.375 | 641800.0 |
| 2001-03-12 09:30:00 | MSFT | Stock | 27.3438 | 27.5 | 27.1562 | 27.375 | 14119200.0 |
| 2001-03-12 10:00:00 | MSFT | Stock | 27.375 | 27.375 | 26.75 | 26.9688 | 8145400.0 |
| 2001-03-12 10:30:00 | MSFT | Stock | 26.9688 | 27.1875 | 26.6875 | 26.7188 | 8833400.0 |
| 2001-03-12 11:00:00 | MSFT | Stock | 26.7188 | 26.75 | 26.0938 | 26.375 | 10123000.0 |
| 2001-03-12 11:30:00 | MSFT | Stock | 26.375 | 26.5625 | 26.3438 | 26.375 | 5565000.0 |
| 2001-03-12 12:00:00 | MSFT | Stock | 26.375 | 26.4375 | 26.1875 | 26.375 | 6036200.0 |
| 2001-03-12 12:30:00 | MSFT | Stock | 26.3594 | 26.8125 | 26.3438 | 26.7812 | 3336400.0 |
| 2001-03-12 13:00:00 | MSFT | Stock | 26.7812 | 27.1094 | 26.6875 | 26.8438 | 6758000.0 |
| 2001-03-12 13:30:00 | MSFT | Stock | 26.875 | 26.875 | 26.2812 | 26.2812 | 6150200.0 |
| 2001-03-12 14:00:00 | MSFT | Stock | 26.2969 | 26.75 | 26.25 | 26.5469 | 7008200.0 |
| 2001-03-12 14:30:00 | MSFT | Stock | 26.5625 | 26.5938 | 26.1562 | 26.3438 | 7028400.0 |
| 2001-03-12 15:00:00 | MSFT | Stock | 26.375 | 26.5312 | 26.0938 | 26.125 | 5313000.0 |
| 2001-03-12 15:30:00 | MSFT | Stock | 26.125 | 26.1562 | 25.8125 | 25.9688 | 16934200.0 |
| 2001-03-12 16:00:00 | MSFT | Stock | 25.9688 | 26.7188 | 25.8438 | 25.875 | 2495000.0 |
| 2001-03-12 16:30:00 | MSFT | Stock | 25.8125 | 26.8125 | 25.7812 | 25.9375 | 374200.0 |
| 2001-03-12 17:00:00 | MSFT | Stock | 25.9062 | 26.6094 | 25.8125 | 25.9375 | 77200.0 |
| 2001-03-12 17:30:00 | MSFT | Stock | 25.875 | 25.875 | 25.7812 | 25.7812 | 4000.0 |
| 2001-03-12 18:00:00 | MSFT | Stock | 25.875 | 26.4219 | 25.8438 | 25.8594 | 78600.0 |
| 2001-03-12 08:00:00 | NVDA | Stock | 0.2039 | 0.2039 | 0.1958 | 0.2021 | 528000.0 |
| 2001-03-12 08:30:00 | NVDA | Stock | 0.2021 | 0.2042 | 0.2016 | 0.2042 | 1392000.0 |
| 2001-03-12 09:00:00 | NVDA | Stock | 0.2042 | 0.2042 | 0.201 | 0.201 | 8976000.0 |
| 2001-03-12 09:30:00 | NVDA | Stock | 0.2016 | 0.2057 | 0.2005 | 0.2026 | 129240000.0 |
| 2001-03-12 10:00:00 | NVDA | Stock | 0.2029 | 0.2029 | 0.1965 | 0.1969 | 39192000.0 |
| 2001-03-12 10:30:00 | NVDA | Stock | 0.1966 | 0.1982 | 0.1924 | 0.1944 | 52608000.0 |
| 2001-03-12 11:00:00 | NVDA | Stock | 0.1945 | 0.1958 | 0.1927 | 0.1945 | 49056000.0 |
| 2001-03-12 11:30:00 | NVDA | Stock | 0.1945 | 0.199 | 0.1945 | 0.1958 | 20352000.0 |
| 2001-03-12 12:00:00 | NVDA | Stock | 0.1969 | 0.1979 | 0.1945 | 0.1961 | 15696000.0 |
> showing 50 of 27,653 rows — these rows as CSV