PREVIEW / stock_30min / 2001-02-14
file: by_date/stock_30min/2001/2001-02-14.parquet size: 538 KB rows: 27,123 symbols: 1,267
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-02-14 08:00:00 | AAPL | Stock | 0.3382 | 0.3438 | 0.3371 | 0.3415 | 1500800.0 |
| 2001-02-14 08:30:00 | AAPL | Stock | 0.3415 | 0.3438 | 0.3415 | 0.3438 | 156800.0 |
| 2001-02-14 09:00:00 | AAPL | Stock | 0.3438 | 0.3438 | 0.3426 | 0.3426 | 224000.0 |
| 2001-02-14 09:30:00 | AAPL | Stock | 0.3426 | 0.3438 | 0.3393 | 0.3404 | 17012800.0 |
| 2001-02-14 10:00:00 | AAPL | Stock | 0.3415 | 0.3415 | 0.3326 | 0.3337 | 20031200.0 |
| 2001-02-14 10:30:00 | AAPL | Stock | 0.3331 | 0.3393 | 0.3304 | 0.3382 | 34378400.0 |
| 2001-02-14 11:00:00 | AAPL | Stock | 0.3371 | 0.3393 | 0.3337 | 0.3337 | 42425600.0 |
| 2001-02-14 11:30:00 | AAPL | Stock | 0.3348 | 0.3415 | 0.3337 | 0.3404 | 20350400.0 |
| 2001-02-14 12:00:00 | AAPL | Stock | 0.3404 | 0.3426 | 0.3393 | 0.3415 | 14722400.0 |
| 2001-02-14 12:30:00 | AAPL | Stock | 0.3404 | 0.3438 | 0.3371 | 0.3382 | 12941600.0 |
| 2001-02-14 13:00:00 | AAPL | Stock | 0.3382 | 0.3393 | 0.3337 | 0.3348 | 12504800.0 |
| 2001-02-14 13:30:00 | AAPL | Stock | 0.3348 | 0.3438 | 0.3337 | 0.3415 | 12096000.0 |
| 2001-02-14 14:00:00 | AAPL | Stock | 0.3415 | 0.3438 | 0.3404 | 0.3438 | 13703200.0 |
| 2001-02-14 14:30:00 | AAPL | Stock | 0.3438 | 0.3504 | 0.3426 | 0.3449 | 35464800.0 |
| 2001-02-14 15:00:00 | AAPL | Stock | 0.346 | 0.3504 | 0.3449 | 0.3482 | 19124000.0 |
| 2001-02-14 15:30:00 | AAPL | Stock | 0.3482 | 0.3504 | 0.3426 | 0.3493 | 27428800.0 |
| 2001-02-14 16:00:00 | AAPL | Stock | 0.3493 | 0.3504 | 0.3371 | 0.3482 | 9492000.0 |
| 2001-02-14 16:30:00 | AAPL | Stock | 0.3482 | 0.3516 | 0.3482 | 0.3516 | 2800000.0 |
| 2001-02-14 17:00:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3482 | 0.3482 | 565600.0 |
| 2001-02-14 17:30:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3482 | 0.3482 | 235200.0 |
| 2001-02-14 08:00:00 | MSFT | Stock | 28.8594 | 29.1094 | 28.5 | 28.8125 | 149800.0 |
| 2001-02-14 08:30:00 | MSFT | Stock | 28.7812 | 29.0 | 28.75 | 29.0 | 68400.0 |
| 2001-02-14 09:00:00 | MSFT | Stock | 29.0 | 29.0 | 28.375 | 28.8125 | 228400.0 |
| 2001-02-14 09:30:00 | MSFT | Stock | 28.8125 | 29.0 | 28.5625 | 28.875 | 8619000.0 |
| 2001-02-14 10:00:00 | MSFT | Stock | 28.875 | 28.9375 | 28.5938 | 28.625 | 5688600.0 |
| 2001-02-14 10:30:00 | MSFT | Stock | 28.6875 | 28.75 | 28.4062 | 28.625 | 4979000.0 |
| 2001-02-14 11:00:00 | MSFT | Stock | 28.6562 | 29.0 | 28.1875 | 28.8125 | 3745800.0 |
| 2001-02-14 11:30:00 | MSFT | Stock | 28.7812 | 29.25 | 28.6875 | 29.1562 | 4812200.0 |
| 2001-02-14 12:00:00 | MSFT | Stock | 29.1875 | 29.1875 | 28.6875 | 28.8125 | 2025000.0 |
| 2001-02-14 12:30:00 | MSFT | Stock | 28.7812 | 29.0 | 28.6562 | 28.6562 | 1582400.0 |
| 2001-02-14 13:00:00 | MSFT | Stock | 28.6562 | 28.75 | 28.4375 | 28.5312 | 3131400.0 |
| 2001-02-14 13:30:00 | MSFT | Stock | 28.5 | 28.875 | 28.4375 | 28.8438 | 3390800.0 |
| 2001-02-14 14:00:00 | MSFT | Stock | 28.875 | 29.2812 | 28.7812 | 29.25 | 4116800.0 |
| 2001-02-14 14:30:00 | MSFT | Stock | 29.2812 | 29.2812 | 28.9375 | 29.0 | 3237400.0 |
| 2001-02-14 15:00:00 | MSFT | Stock | 29.0 | 29.5 | 28.9688 | 29.4062 | 3970400.0 |
| 2001-02-14 15:30:00 | MSFT | Stock | 29.375 | 29.4375 | 28.8438 | 29.2188 | 6604000.0 |
| 2001-02-14 16:00:00 | MSFT | Stock | 29.2188 | 29.4531 | 28.875 | 29.1875 | 2747400.0 |
| 2001-02-14 16:30:00 | MSFT | Stock | 29.2812 | 29.375 | 29.0781 | 29.375 | 442000.0 |
| 2001-02-14 17:00:00 | MSFT | Stock | 29.1875 | 29.4062 | 29.1875 | 29.3125 | 85400.0 |
| 2001-02-14 17:30:00 | MSFT | Stock | 29.3125 | 29.3438 | 29.1875 | 29.3438 | 212800.0 |
| 2001-02-14 18:00:00 | MSFT | Stock | 29.3125 | 29.3125 | 29.3125 | 29.3125 | 400.0 |
| 2001-02-14 09:00:00 | NVDA | Stock | 0.1857 | 0.1857 | 0.1818 | 0.1818 | 1248000.0 |
| 2001-02-14 09:30:00 | NVDA | Stock | 0.1828 | 0.1833 | 0.1768 | 0.1802 | 92472000.0 |
| 2001-02-14 10:00:00 | NVDA | Stock | 0.1799 | 0.1802 | 0.1763 | 0.1768 | 49416000.0 |
| 2001-02-14 10:30:00 | NVDA | Stock | 0.1771 | 0.1779 | 0.175 | 0.1766 | 29808000.0 |
| 2001-02-14 11:00:00 | NVDA | Stock | 0.1766 | 0.1826 | 0.1763 | 0.1797 | 36264000.0 |
| 2001-02-14 11:30:00 | NVDA | Stock | 0.1794 | 0.1833 | 0.1792 | 0.1805 | 33480000.0 |
| 2001-02-14 12:00:00 | NVDA | Stock | 0.181 | 0.1818 | 0.1792 | 0.1813 | 63600000.0 |
| 2001-02-14 12:30:00 | NVDA | Stock | 0.1813 | 0.1831 | 0.1797 | 0.1802 | 59760000.0 |
| 2001-02-14 13:00:00 | NVDA | Stock | 0.1802 | 0.1807 | 0.1792 | 0.1792 | 20112000.0 |
> showing 50 of 27,123 rows — these rows as CSV