PREVIEW / stock_30min / 2001-01-05
file: by_date/stock_30min/2001/2001-01-05.parquet size: 470 KB rows: 26,900 symbols: 1,256
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-05 08:00:00 | AAPL | Stock | 0.3058 | 0.3125 | 0.3036 | 0.3058 | 252000.0 |
| 2001-01-05 08:30:00 | AAPL | Stock | 0.3058 | 0.3125 | 0.3036 | 0.3036 | 593600.0 |
| 2001-01-05 09:00:00 | AAPL | Stock | 0.2991 | 0.3025 | 0.2946 | 0.3002 | 6815200.0 |
| 2001-01-05 09:30:00 | AAPL | Stock | 0.3025 | 0.3036 | 0.2958 | 0.2969 | 37508800.0 |
| 2001-01-05 10:00:00 | AAPL | Stock | 0.2969 | 0.3002 | 0.2958 | 0.3002 | 30626400.0 |
| 2001-01-05 10:30:00 | AAPL | Stock | 0.3002 | 0.3103 | 0.298 | 0.298 | 48316800.0 |
| 2001-01-05 11:00:00 | AAPL | Stock | 0.298 | 0.2991 | 0.2891 | 0.2891 | 60552800.0 |
| 2001-01-05 11:30:00 | AAPL | Stock | 0.2891 | 0.2935 | 0.2868 | 0.2919 | 53312000.0 |
| 2001-01-05 12:00:00 | AAPL | Stock | 0.2913 | 0.2969 | 0.2902 | 0.2924 | 17780000.0 |
| 2001-01-05 12:30:00 | AAPL | Stock | 0.2913 | 0.3002 | 0.2913 | 0.2969 | 21660800.0 |
| 2001-01-05 13:00:00 | AAPL | Stock | 0.2958 | 0.298 | 0.2958 | 0.2958 | 5040000.0 |
| 2001-01-05 13:30:00 | AAPL | Stock | 0.2958 | 0.2969 | 0.2946 | 0.2958 | 8400000.0 |
| 2001-01-05 14:00:00 | AAPL | Stock | 0.2958 | 0.2969 | 0.2924 | 0.2958 | 10869600.0 |
| 2001-01-05 14:30:00 | AAPL | Stock | 0.2958 | 0.2958 | 0.2891 | 0.2924 | 15859200.0 |
| 2001-01-05 15:00:00 | AAPL | Stock | 0.2924 | 0.2958 | 0.2891 | 0.2924 | 21677600.0 |
| 2001-01-05 15:30:00 | AAPL | Stock | 0.2913 | 0.2946 | 0.2879 | 0.2924 | 33706400.0 |
| 2001-01-05 16:00:00 | AAPL | Stock | 0.2924 | 0.2946 | 0.2891 | 0.2924 | 7604800.0 |
| 2001-01-05 16:30:00 | AAPL | Stock | 0.2924 | 0.2924 | 0.2924 | 0.2924 | 229600.0 |
| 2001-01-05 17:00:00 | AAPL | Stock | 0.2935 | 0.2935 | 0.2935 | 0.2935 | 16800.0 |
| 2001-01-05 17:30:00 | AAPL | Stock | 0.2902 | 0.2902 | 0.2902 | 0.2902 | 22400.0 |
| 2001-01-05 18:00:00 | AAPL | Stock | 0.2924 | 0.2946 | 0.2924 | 0.2946 | 16800.0 |
| 2001-01-05 08:00:00 | MSFT | Stock | 24.5312 | 24.5625 | 24.25 | 24.375 | 25600.0 |
| 2001-01-05 08:30:00 | MSFT | Stock | 24.3125 | 24.5312 | 23.75 | 23.75 | 129600.0 |
| 2001-01-05 09:00:00 | MSFT | Stock | 23.7812 | 24.4375 | 23.75 | 24.2812 | 450400.0 |
| 2001-01-05 09:30:00 | MSFT | Stock | 24.25 | 24.6562 | 23.7812 | 24.2188 | 13050400.0 |
| 2001-01-05 10:00:00 | MSFT | Stock | 24.2188 | 24.75 | 24.1875 | 24.5938 | 9938800.0 |
| 2001-01-05 10:30:00 | MSFT | Stock | 24.5938 | 24.75 | 24.4688 | 24.625 | 5176200.0 |
| 2001-01-05 11:00:00 | MSFT | Stock | 24.5938 | 24.6562 | 24.2812 | 24.375 | 7893400.0 |
| 2001-01-05 11:30:00 | MSFT | Stock | 24.3906 | 24.5625 | 24.3125 | 24.5312 | 6657600.0 |
| 2001-01-05 12:00:00 | MSFT | Stock | 24.5 | 24.8438 | 24.4062 | 24.8125 | 4281400.0 |
| 2001-01-05 12:30:00 | MSFT | Stock | 24.8125 | 24.9375 | 24.625 | 24.6875 | 3928200.0 |
| 2001-01-05 13:00:00 | MSFT | Stock | 24.6562 | 24.8125 | 24.6562 | 24.7188 | 3115600.0 |
| 2001-01-05 13:30:00 | MSFT | Stock | 24.7188 | 24.75 | 24.625 | 24.6562 | 2439800.0 |
| 2001-01-05 14:00:00 | MSFT | Stock | 24.6562 | 24.75 | 24.4062 | 24.5625 | 3519600.0 |
| 2001-01-05 14:30:00 | MSFT | Stock | 24.5781 | 24.5938 | 24.3125 | 24.3438 | 4740400.0 |
| 2001-01-05 15:00:00 | MSFT | Stock | 24.3438 | 24.4688 | 23.9688 | 24.375 | 7614800.0 |
| 2001-01-05 15:30:00 | MSFT | Stock | 24.375 | 24.6875 | 24.2188 | 24.5 | 9318200.0 |
| 2001-01-05 16:00:00 | MSFT | Stock | 24.5156 | 24.5938 | 24.2812 | 24.5625 | 4757200.0 |
| 2001-01-05 16:30:00 | MSFT | Stock | 24.5625 | 24.5625 | 24.375 | 24.5312 | 366200.0 |
| 2001-01-05 17:00:00 | MSFT | Stock | 24.5312 | 24.5625 | 24.375 | 24.375 | 34600.0 |
| 2001-01-05 17:30:00 | MSFT | Stock | 24.5 | 24.5625 | 24.5 | 24.5625 | 5200.0 |
| 2001-01-05 18:00:00 | MSFT | Stock | 24.5312 | 24.625 | 24.5 | 24.5938 | 8000.0 |
| 2001-01-05 08:00:00 | NVDA | Stock | 0.1875 | 0.1875 | 0.1875 | 0.1875 | 24000.0 |
| 2001-01-05 08:30:00 | NVDA | Stock | 0.1833 | 0.1833 | 0.1802 | 0.1833 | 552000.0 |
| 2001-01-05 09:00:00 | NVDA | Stock | 0.1802 | 0.1813 | 0.1792 | 0.1809 | 960000.0 |
| 2001-01-05 09:30:00 | NVDA | Stock | 0.1802 | 0.181 | 0.1656 | 0.1711 | 38112000.0 |
| 2001-01-05 10:00:00 | NVDA | Stock | 0.1719 | 0.1783 | 0.1688 | 0.176 | 41712000.0 |
| 2001-01-05 10:30:00 | NVDA | Stock | 0.1771 | 0.1807 | 0.1719 | 0.1719 | 46584000.0 |
| 2001-01-05 11:00:00 | NVDA | Stock | 0.1729 | 0.1729 | 0.163 | 0.1638 | 43416000.0 |
| 2001-01-05 11:30:00 | NVDA | Stock | 0.1638 | 0.1656 | 0.1604 | 0.1651 | 48192000.0 |
> showing 50 of 26,900 rows — these rows as CSV