PREVIEW / stock_30min / 2002-01-31
file: by_date/stock_30min/2002/2002-01-31.parquet size: 608 KB rows: 31,638 symbols: 1,352
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-31 08:00:00 | AAPL | Stock | 0.4352 | 0.4352 | 0.4296 | 0.4307 | 347200.0 |
| 2002-01-31 08:30:00 | AAPL | Stock | 0.4304 | 0.4311 | 0.4295 | 0.4304 | 302400.0 |
| 2002-01-31 09:00:00 | AAPL | Stock | 0.4304 | 0.4321 | 0.4304 | 0.4313 | 3690400.0 |
| 2002-01-31 09:30:00 | AAPL | Stock | 0.4314 | 0.435 | 0.4305 | 0.4339 | 81289600.0 |
| 2002-01-31 10:00:00 | AAPL | Stock | 0.4343 | 0.4354 | 0.4321 | 0.4336 | 53715200.0 |
| 2002-01-31 10:30:00 | AAPL | Stock | 0.4336 | 0.435 | 0.4307 | 0.4329 | 18233600.0 |
| 2002-01-31 11:00:00 | AAPL | Stock | 0.4327 | 0.4339 | 0.4314 | 0.4336 | 14974400.0 |
| 2002-01-31 11:30:00 | AAPL | Stock | 0.4336 | 0.4371 | 0.4332 | 0.4348 | 52578400.0 |
| 2002-01-31 12:00:00 | AAPL | Stock | 0.4348 | 0.4363 | 0.4336 | 0.4338 | 17684800.0 |
| 2002-01-31 12:30:00 | AAPL | Stock | 0.4338 | 0.4355 | 0.4336 | 0.4339 | 18121600.0 |
| 2002-01-31 13:00:00 | AAPL | Stock | 0.4341 | 0.4357 | 0.4341 | 0.435 | 18233600.0 |
| 2002-01-31 13:30:00 | AAPL | Stock | 0.4348 | 0.4364 | 0.4346 | 0.4364 | 28067200.0 |
| 2002-01-31 14:00:00 | AAPL | Stock | 0.4364 | 0.4373 | 0.4346 | 0.4357 | 15853600.0 |
| 2002-01-31 14:30:00 | AAPL | Stock | 0.4357 | 0.4359 | 0.4327 | 0.4341 | 26527200.0 |
| 2002-01-31 15:00:00 | AAPL | Stock | 0.4339 | 0.4357 | 0.4339 | 0.4341 | 18642400.0 |
| 2002-01-31 15:30:00 | AAPL | Stock | 0.4343 | 0.4414 | 0.4339 | 0.4413 | 43153600.0 |
| 2002-01-31 16:00:00 | AAPL | Stock | 0.4413 | 0.442 | 0.4386 | 0.4409 | 32877600.0 |
| 2002-01-31 16:30:00 | AAPL | Stock | 0.4411 | 0.4414 | 0.4345 | 0.4411 | 4222400.0 |
| 2002-01-31 17:00:00 | AAPL | Stock | 0.4409 | 0.4414 | 0.4409 | 0.4414 | 1260000.0 |
| 2002-01-31 18:00:00 | AAPL | Stock | 0.4409 | 0.4409 | 0.4409 | 0.4409 | 22400.0 |
| 2002-01-31 08:00:00 | MSFT | Stock | 31.4275 | 31.5545 | 31.4275 | 31.525 | 78000.0 |
| 2002-01-31 08:30:00 | MSFT | Stock | 31.54 | 31.5555 | 31.525 | 31.53 | 23400.0 |
| 2002-01-31 09:00:00 | MSFT | Stock | 31.525 | 31.6 | 31.505 | 31.525 | 159400.0 |
| 2002-01-31 09:30:00 | MSFT | Stock | 31.53 | 31.785 | 31.52 | 31.755 | 7388600.0 |
| 2002-01-31 10:00:00 | MSFT | Stock | 31.76 | 31.905 | 31.535 | 31.6235 | 7280800.0 |
| 2002-01-31 10:30:00 | MSFT | Stock | 31.635 | 31.65 | 31.25 | 31.285 | 5117000.0 |
| 2002-01-31 11:00:00 | MSFT | Stock | 31.285 | 31.37 | 31.145 | 31.145 | 4913400.0 |
| 2002-01-31 11:30:00 | MSFT | Stock | 31.15 | 31.31 | 31.06 | 31.305 | 5299200.0 |
| 2002-01-31 12:00:00 | MSFT | Stock | 31.31 | 31.57 | 31.25 | 31.4055 | 4104200.0 |
| 2002-01-31 12:30:00 | MSFT | Stock | 31.405 | 31.53 | 31.29 | 31.5 | 2353000.0 |
| 2002-01-31 13:00:00 | MSFT | Stock | 31.52 | 31.7 | 31.4445 | 31.64 | 3313200.0 |
| 2002-01-31 13:30:00 | MSFT | Stock | 31.6305 | 31.665 | 31.4455 | 31.55 | 2411800.0 |
| 2002-01-31 14:00:00 | MSFT | Stock | 31.55 | 31.7 | 31.38 | 31.605 | 2529400.0 |
| 2002-01-31 14:30:00 | MSFT | Stock | 31.605 | 31.625 | 31.4 | 31.57 | 3277200.0 |
| 2002-01-31 15:00:00 | MSFT | Stock | 31.565 | 31.695 | 31.515 | 31.675 | 3658000.0 |
| 2002-01-31 15:30:00 | MSFT | Stock | 31.685 | 31.875 | 31.645 | 31.855 | 7858600.0 |
| 2002-01-31 16:00:00 | MSFT | Stock | 31.85 | 31.95 | 31.5156 | 31.865 | 5051200.0 |
| 2002-01-31 16:30:00 | MSFT | Stock | 31.855 | 31.9 | 31.5518 | 31.855 | 2884200.0 |
| 2002-01-31 17:00:00 | MSFT | Stock | 31.855 | 31.8725 | 31.855 | 31.8725 | 851600.0 |
| 2002-01-31 17:30:00 | MSFT | Stock | 31.8 | 31.8 | 31.775 | 31.8 | 3200.0 |
| 2002-01-31 18:00:00 | MSFT | Stock | 31.8 | 31.855 | 31.775 | 31.85 | 4600.0 |
| 2002-01-31 08:00:00 | NVDA | Stock | 0.5479 | 0.5541 | 0.5479 | 0.5512 | 564000.0 |
| 2002-01-31 08:30:00 | NVDA | Stock | 0.55 | 0.5514 | 0.55 | 0.55 | 288000.0 |
| 2002-01-31 09:00:00 | NVDA | Stock | 0.5519 | 0.5525 | 0.55 | 0.5524 | 2196000.0 |
| 2002-01-31 09:30:00 | NVDA | Stock | 0.5524 | 0.5567 | 0.5482 | 0.5516 | 122892000.0 |
| 2002-01-31 10:00:00 | NVDA | Stock | 0.5514 | 0.5535 | 0.5328 | 0.536 | 119580000.0 |
| 2002-01-31 10:30:00 | NVDA | Stock | 0.535 | 0.5399 | 0.5296 | 0.533 | 98712000.0 |
| 2002-01-31 11:00:00 | NVDA | Stock | 0.5329 | 0.54 | 0.5329 | 0.5356 | 63060000.0 |
| 2002-01-31 11:30:00 | NVDA | Stock | 0.5357 | 0.5391 | 0.5333 | 0.5373 | 50268000.0 |
| 2002-01-31 12:00:00 | NVDA | Stock | 0.5371 | 0.5456 | 0.5367 | 0.5402 | 57888000.0 |
> showing 50 of 31,638 rows — these rows as CSV