PREVIEW / stock_30min / 2000-07-24
file: by_date/stock_30min/2000/2000-07-24.parquet size: 423 KB rows: 25,156 symbols: 1,197
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 |
|---|---|---|---|---|---|---|---|
| 2000-07-24 08:00:00 | AAPL | Stock | 0.9565 | 0.9565 | 0.9554 | 0.9554 | 50400.0 |
| 2000-07-24 08:30:00 | AAPL | Stock | 0.9554 | 0.9554 | 0.9554 | 0.9554 | 89600.0 |
| 2000-07-24 09:00:00 | AAPL | Stock | 0.9576 | 0.9587 | 0.933 | 0.9386 | 582400.0 |
| 2000-07-24 09:30:00 | AAPL | Stock | 0.9386 | 0.9442 | 0.9275 | 0.933 | 30760800.0 |
| 2000-07-24 10:00:00 | AAPL | Stock | 0.9308 | 0.9375 | 0.9275 | 0.9358 | 27916000.0 |
| 2000-07-24 10:30:00 | AAPL | Stock | 0.9358 | 0.942 | 0.9297 | 0.9308 | 18883200.0 |
| 2000-07-24 11:00:00 | AAPL | Stock | 0.9308 | 0.9308 | 0.9063 | 0.9085 | 21106400.0 |
| 2000-07-24 11:30:00 | AAPL | Stock | 0.9063 | 0.9085 | 0.8996 | 0.9018 | 33415200.0 |
| 2000-07-24 12:00:00 | AAPL | Stock | 0.9018 | 0.9018 | 0.8917 | 0.8973 | 39177600.0 |
| 2000-07-24 12:30:00 | AAPL | Stock | 0.8973 | 0.9007 | 0.885 | 0.8973 | 28896000.0 |
| 2000-07-24 13:00:00 | AAPL | Stock | 0.8984 | 0.904 | 0.8929 | 0.9007 | 12941600.0 |
| 2000-07-24 13:30:00 | AAPL | Stock | 0.9001 | 0.9029 | 0.8895 | 0.8895 | 14296800.0 |
| 2000-07-24 14:00:00 | AAPL | Stock | 0.8895 | 0.8906 | 0.8594 | 0.8638 | 53076800.0 |
| 2000-07-24 14:30:00 | AAPL | Stock | 0.8638 | 0.8705 | 0.8571 | 0.8661 | 30951200.0 |
| 2000-07-24 15:00:00 | AAPL | Stock | 0.8661 | 0.8817 | 0.8504 | 0.8717 | 31298400.0 |
| 2000-07-24 15:30:00 | AAPL | Stock | 0.8728 | 0.8828 | 0.8661 | 0.8683 | 38108000.0 |
| 2000-07-24 16:00:00 | AAPL | Stock | 0.8694 | 0.8828 | 0.8683 | 0.8683 | 8002400.0 |
| 2000-07-24 16:30:00 | AAPL | Stock | 0.8694 | 0.8828 | 0.8694 | 0.8694 | 2716000.0 |
| 2000-07-24 17:00:00 | AAPL | Stock | 0.8694 | 0.8817 | 0.8694 | 0.8795 | 324800.0 |
| 2000-07-24 17:30:00 | AAPL | Stock | 0.8795 | 0.8795 | 0.8795 | 0.8795 | 28000.0 |
| 2000-07-24 18:00:00 | AAPL | Stock | 0.8795 | 0.8817 | 0.8795 | 0.8795 | 67200.0 |
| 2000-07-24 08:30:00 | MSFT | Stock | 36.0625 | 36.2812 | 36.0625 | 36.0938 | 31600.0 |
| 2000-07-24 09:00:00 | MSFT | Stock | 36.0625 | 36.125 | 35.9375 | 36.0625 | 145400.0 |
| 2000-07-24 09:30:00 | MSFT | Stock | 36.0312 | 36.0625 | 35.625 | 35.7812 | 6277200.0 |
| 2000-07-24 10:00:00 | MSFT | Stock | 35.7812 | 35.8438 | 35.5625 | 35.6875 | 6258400.0 |
| 2000-07-24 10:30:00 | MSFT | Stock | 35.6875 | 35.7188 | 35.4688 | 35.5312 | 3669200.0 |
| 2000-07-24 11:00:00 | MSFT | Stock | 35.5312 | 35.5625 | 35.375 | 35.4062 | 3237000.0 |
| 2000-07-24 11:30:00 | MSFT | Stock | 35.4062 | 35.5312 | 35.3438 | 35.4375 | 2305400.0 |
| 2000-07-24 12:00:00 | MSFT | Stock | 35.4688 | 35.4688 | 35.25 | 35.3125 | 3628400.0 |
| 2000-07-24 12:30:00 | MSFT | Stock | 35.3438 | 35.3438 | 35.0625 | 35.1875 | 3888400.0 |
| 2000-07-24 13:00:00 | MSFT | Stock | 35.2188 | 35.2188 | 35.0312 | 35.0625 | 3435400.0 |
| 2000-07-24 13:30:00 | MSFT | Stock | 35.0312 | 35.125 | 35.0 | 35.125 | 3237400.0 |
| 2000-07-24 14:00:00 | MSFT | Stock | 35.125 | 35.4375 | 35.0625 | 35.2812 | 3418000.0 |
| 2000-07-24 14:30:00 | MSFT | Stock | 35.25 | 35.2812 | 35.0312 | 35.1562 | 3928600.0 |
| 2000-07-24 15:00:00 | MSFT | Stock | 35.1562 | 35.3438 | 35.0938 | 35.2812 | 4008200.0 |
| 2000-07-24 15:30:00 | MSFT | Stock | 35.3125 | 35.5625 | 35.0625 | 35.3125 | 6708200.0 |
| 2000-07-24 16:00:00 | MSFT | Stock | 35.3125 | 35.5 | 35.0938 | 35.5 | 1269800.0 |
| 2000-07-24 16:30:00 | MSFT | Stock | 35.4375 | 35.4375 | 35.2812 | 35.375 | 38400.0 |
| 2000-07-24 17:00:00 | MSFT | Stock | 35.375 | 35.5 | 35.2812 | 35.5 | 171800.0 |
| 2000-07-24 17:30:00 | MSFT | Stock | 35.3125 | 35.375 | 35.3125 | 35.375 | 3200.0 |
| 2000-07-24 18:00:00 | MSFT | Stock | 35.375 | 35.375 | 35.3125 | 35.3125 | 600.0 |
| 2000-07-24 09:00:00 | NVDA | Stock | 0.2904 | 0.2917 | 0.2904 | 0.2906 | 480000.0 |
| 2000-07-24 09:30:00 | NVDA | Stock | 0.2906 | 0.2927 | 0.2865 | 0.2896 | 23472000.0 |
| 2000-07-24 10:00:00 | NVDA | Stock | 0.2891 | 0.2906 | 0.2891 | 0.2896 | 11664000.0 |
| 2000-07-24 10:30:00 | NVDA | Stock | 0.2896 | 0.2898 | 0.2854 | 0.2854 | 8808000.0 |
| 2000-07-24 11:00:00 | NVDA | Stock | 0.2854 | 0.2854 | 0.2802 | 0.2813 | 10368000.0 |
| 2000-07-24 11:30:00 | NVDA | Stock | 0.2813 | 0.2833 | 0.2807 | 0.281 | 3696000.0 |
| 2000-07-24 12:00:00 | NVDA | Stock | 0.2807 | 0.2823 | 0.275 | 0.2758 | 11688000.0 |
| 2000-07-24 12:30:00 | NVDA | Stock | 0.2768 | 0.2768 | 0.2594 | 0.2633 | 36384000.0 |
| 2000-07-24 13:00:00 | NVDA | Stock | 0.2625 | 0.2708 | 0.2596 | 0.2641 | 22872000.0 |
> showing 50 of 25,156 rows — these rows as CSV