PREVIEW / stock_30min / 2002-01-18
file: by_date/stock_30min/2002/2002-01-18.parquet size: 574 KB rows: 29,824 symbols: 1,350
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-18 08:00:00 | AAPL | Stock | 0.392 | 0.393 | 0.3884 | 0.3884 | 145600.0 |
| 2002-01-18 08:30:00 | AAPL | Stock | 0.3914 | 0.3929 | 0.3911 | 0.3929 | 246400.0 |
| 2002-01-18 09:00:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.392 | 0.3929 | 3057600.0 |
| 2002-01-18 09:30:00 | AAPL | Stock | 0.3929 | 0.3998 | 0.3923 | 0.3948 | 52959200.0 |
| 2002-01-18 10:00:00 | AAPL | Stock | 0.3946 | 0.3963 | 0.3932 | 0.3948 | 25860800.0 |
| 2002-01-18 10:30:00 | AAPL | Stock | 0.3954 | 0.4036 | 0.3943 | 0.3961 | 35845600.0 |
| 2002-01-18 11:00:00 | AAPL | Stock | 0.3961 | 0.3964 | 0.3921 | 0.3936 | 24690400.0 |
| 2002-01-18 11:30:00 | AAPL | Stock | 0.3932 | 0.3941 | 0.3923 | 0.3929 | 10511200.0 |
| 2002-01-18 12:00:00 | AAPL | Stock | 0.3929 | 0.3943 | 0.3927 | 0.3938 | 8624000.0 |
| 2002-01-18 12:30:00 | AAPL | Stock | 0.3938 | 0.3952 | 0.3936 | 0.395 | 8321600.0 |
| 2002-01-18 13:00:00 | AAPL | Stock | 0.3952 | 0.3986 | 0.395 | 0.398 | 13787200.0 |
| 2002-01-18 13:30:00 | AAPL | Stock | 0.3973 | 0.3998 | 0.397 | 0.3987 | 16077600.0 |
| 2002-01-18 14:00:00 | AAPL | Stock | 0.3988 | 0.3988 | 0.3946 | 0.3975 | 11838400.0 |
| 2002-01-18 14:30:00 | AAPL | Stock | 0.3975 | 0.3977 | 0.3941 | 0.395 | 18631200.0 |
| 2002-01-18 15:00:00 | AAPL | Stock | 0.395 | 0.3959 | 0.3936 | 0.3954 | 28588000.0 |
| 2002-01-18 15:30:00 | AAPL | Stock | 0.3954 | 0.4 | 0.3952 | 0.3959 | 50797600.0 |
| 2002-01-18 16:00:00 | AAPL | Stock | 0.3957 | 0.3964 | 0.3957 | 0.3959 | 4698400.0 |
| 2002-01-18 16:30:00 | AAPL | Stock | 0.3959 | 0.3959 | 0.3959 | 0.3959 | 72800.0 |
| 2002-01-18 17:00:00 | AAPL | Stock | 0.3959 | 0.3964 | 0.3959 | 0.3964 | 72800.0 |
| 2002-01-18 17:30:00 | AAPL | Stock | 0.3959 | 0.3959 | 0.3959 | 0.3959 | 1069600.0 |
| 2002-01-18 18:00:00 | AAPL | Stock | 0.3959 | 0.3959 | 0.3959 | 0.3959 | 907200.0 |
| 2002-01-18 08:00:00 | MSFT | Stock | 33.75 | 33.925 | 33.5 | 33.575 | 1010800.0 |
| 2002-01-18 08:30:00 | MSFT | Stock | 33.6 | 34.935 | 33.355 | 33.55 | 975000.0 |
| 2002-01-18 09:00:00 | MSFT | Stock | 33.525 | 34.935 | 33.5 | 33.575 | 1888600.0 |
| 2002-01-18 09:30:00 | MSFT | Stock | 33.55 | 33.555 | 33.175 | 33.48 | 24023000.0 |
| 2002-01-18 10:00:00 | MSFT | Stock | 33.475 | 33.64 | 33.2685 | 33.625 | 8638400.0 |
| 2002-01-18 10:30:00 | MSFT | Stock | 33.64 | 33.925 | 33.56 | 33.67 | 12832800.0 |
| 2002-01-18 11:00:00 | MSFT | Stock | 33.66 | 33.75 | 33.415 | 33.5 | 6726200.0 |
| 2002-01-18 11:30:00 | MSFT | Stock | 33.49 | 33.5255 | 33.335 | 33.415 | 4345000.0 |
| 2002-01-18 12:00:00 | MSFT | Stock | 33.42 | 33.53 | 33.3 | 33.355 | 4116800.0 |
| 2002-01-18 12:30:00 | MSFT | Stock | 33.36 | 33.415 | 33.31 | 33.3345 | 2050200.0 |
| 2002-01-18 13:00:00 | MSFT | Stock | 33.335 | 33.37 | 33.205 | 33.205 | 2957600.0 |
| 2002-01-18 13:30:00 | MSFT | Stock | 33.205 | 33.415 | 33.175 | 33.325 | 3160600.0 |
| 2002-01-18 14:00:00 | MSFT | Stock | 33.33 | 33.34 | 33.1 | 33.21 | 3150400.0 |
| 2002-01-18 14:30:00 | MSFT | Stock | 33.21 | 33.215 | 32.85 | 32.895 | 7621000.0 |
| 2002-01-18 15:00:00 | MSFT | Stock | 32.885 | 33.0 | 32.725 | 32.9145 | 7301000.0 |
| 2002-01-18 15:30:00 | MSFT | Stock | 32.91 | 33.245 | 32.7905 | 33.05 | 9326400.0 |
| 2002-01-18 16:00:00 | MSFT | Stock | 33.065 | 33.625 | 33.03 | 33.175 | 2843000.0 |
| 2002-01-18 16:30:00 | MSFT | Stock | 33.175 | 33.3024 | 33.05 | 33.175 | 79200.0 |
| 2002-01-18 17:00:00 | MSFT | Stock | 33.175 | 33.3349 | 33.065 | 33.15 | 125000.0 |
| 2002-01-18 17:30:00 | MSFT | Stock | 33.15 | 33.165 | 33.05 | 33.165 | 162000.0 |
| 2002-01-18 18:00:00 | MSFT | Stock | 33.165 | 33.195 | 33.05 | 33.185 | 129200.0 |
| 2002-01-18 08:00:00 | NVDA | Stock | 0.5242 | 0.5266 | 0.523 | 0.5243 | 540000.0 |
| 2002-01-18 08:30:00 | NVDA | Stock | 0.5243 | 0.525 | 0.5243 | 0.525 | 756000.0 |
| 2002-01-18 09:00:00 | NVDA | Stock | 0.525 | 0.5392 | 0.521 | 0.521 | 4080000.0 |
| 2002-01-18 09:30:00 | NVDA | Stock | 0.5212 | 0.5308 | 0.5208 | 0.5261 | 153948000.0 |
| 2002-01-18 10:00:00 | NVDA | Stock | 0.5258 | 0.5322 | 0.5239 | 0.53 | 79092000.0 |
| 2002-01-18 10:30:00 | NVDA | Stock | 0.5298 | 0.5333 | 0.5256 | 0.5294 | 74712000.0 |
| 2002-01-18 11:00:00 | NVDA | Stock | 0.5287 | 0.5302 | 0.5254 | 0.5302 | 44400000.0 |
| 2002-01-18 11:30:00 | NVDA | Stock | 0.5288 | 0.5332 | 0.5277 | 0.5297 | 44100000.0 |
> showing 50 of 29,824 rows — these rows as CSV