PREVIEW / stock_30min / 2002-03-18
file: by_date/stock_30min/2002/2002-03-18.parquet size: 594 KB rows: 30,746 symbols: 1,405
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-03-18 08:00:00 | AAPL | Stock | 0.4464 | 0.4473 | 0.4464 | 0.4466 | 95200.0 |
| 2002-03-18 08:30:00 | AAPL | Stock | 0.4468 | 0.4468 | 0.4468 | 0.4468 | 39200.0 |
| 2002-03-18 09:00:00 | AAPL | Stock | 0.4484 | 0.4484 | 0.4455 | 0.4455 | 347200.0 |
| 2002-03-18 09:30:00 | AAPL | Stock | 0.4455 | 0.4473 | 0.4425 | 0.4455 | 17763200.0 |
| 2002-03-18 10:00:00 | AAPL | Stock | 0.4454 | 0.4455 | 0.4421 | 0.4441 | 6904800.0 |
| 2002-03-18 10:30:00 | AAPL | Stock | 0.4438 | 0.4439 | 0.4402 | 0.4411 | 14067200.0 |
| 2002-03-18 11:00:00 | AAPL | Stock | 0.4414 | 0.4418 | 0.4357 | 0.4384 | 27260800.0 |
| 2002-03-18 11:30:00 | AAPL | Stock | 0.4384 | 0.4387 | 0.437 | 0.4373 | 13742400.0 |
| 2002-03-18 12:00:00 | AAPL | Stock | 0.4373 | 0.4389 | 0.4373 | 0.4389 | 12320000.0 |
| 2002-03-18 12:30:00 | AAPL | Stock | 0.4388 | 0.44 | 0.4382 | 0.4386 | 14845600.0 |
| 2002-03-18 13:00:00 | AAPL | Stock | 0.4386 | 0.4396 | 0.4375 | 0.4389 | 16044000.0 |
| 2002-03-18 13:30:00 | AAPL | Stock | 0.4395 | 0.4395 | 0.4361 | 0.4363 | 17981600.0 |
| 2002-03-18 14:00:00 | AAPL | Stock | 0.4364 | 0.4382 | 0.4343 | 0.4359 | 23968000.0 |
| 2002-03-18 14:30:00 | AAPL | Stock | 0.4363 | 0.4371 | 0.4354 | 0.4366 | 24785600.0 |
| 2002-03-18 15:00:00 | AAPL | Stock | 0.4366 | 0.4407 | 0.4364 | 0.4407 | 27025600.0 |
| 2002-03-18 15:30:00 | AAPL | Stock | 0.4405 | 0.4429 | 0.4388 | 0.4416 | 17920000.0 |
| 2002-03-18 16:00:00 | AAPL | Stock | 0.4418 | 0.4438 | 0.4395 | 0.4417 | 7985600.0 |
| 2002-03-18 17:30:00 | AAPL | Stock | 0.4402 | 0.4402 | 0.4402 | 0.4402 | 56000.0 |
| 2002-03-18 08:00:00 | MSFT | Stock | 31.475 | 31.75 | 31.24 | 31.45 | 188000.0 |
| 2002-03-18 08:30:00 | MSFT | Stock | 31.485 | 31.49 | 31.435 | 31.44 | 11200.0 |
| 2002-03-18 09:00:00 | MSFT | Stock | 31.45 | 31.5 | 31.26 | 31.35 | 153200.0 |
| 2002-03-18 09:30:00 | MSFT | Stock | 31.37 | 31.495 | 31.1485 | 31.165 | 6113400.0 |
| 2002-03-18 10:00:00 | MSFT | Stock | 31.165 | 31.245 | 31.075 | 31.21 | 2977800.0 |
| 2002-03-18 10:30:00 | MSFT | Stock | 31.205 | 31.26 | 31.031 | 31.16 | 4446200.0 |
| 2002-03-18 11:00:00 | MSFT | Stock | 31.17 | 31.175 | 30.8 | 30.93 | 4803400.0 |
| 2002-03-18 11:30:00 | MSFT | Stock | 30.93 | 30.97 | 30.8 | 30.86 | 2345600.0 |
| 2002-03-18 12:00:00 | MSFT | Stock | 30.86 | 30.945 | 30.84 | 30.905 | 1273600.0 |
| 2002-03-18 12:30:00 | MSFT | Stock | 30.915 | 30.92 | 30.8 | 30.825 | 1691000.0 |
| 2002-03-18 13:00:00 | MSFT | Stock | 30.82 | 30.925 | 30.7945 | 30.855 | 1506600.0 |
| 2002-03-18 13:30:00 | MSFT | Stock | 30.8545 | 30.87 | 30.6 | 30.665 | 3014200.0 |
| 2002-03-18 14:00:00 | MSFT | Stock | 30.66 | 30.795 | 30.61 | 30.795 | 1695400.0 |
| 2002-03-18 14:30:00 | MSFT | Stock | 30.79 | 30.845 | 30.715 | 30.82 | 2443400.0 |
| 2002-03-18 15:00:00 | MSFT | Stock | 30.825 | 30.985 | 30.8025 | 30.935 | 2673800.0 |
| 2002-03-18 15:30:00 | MSFT | Stock | 30.935 | 31.125 | 30.93 | 31.07 | 3806600.0 |
| 2002-03-18 16:00:00 | MSFT | Stock | 31.08 | 31.1 | 30.9474 | 31.07 | 996200.0 |
| 2002-03-18 16:30:00 | MSFT | Stock | 31.068 | 31.125 | 30.9402 | 31.05 | 1355800.0 |
| 2002-03-18 17:00:00 | MSFT | Stock | 31.05 | 31.05 | 30.7755 | 31.0055 | 5400.0 |
| 2002-03-18 17:30:00 | MSFT | Stock | 31.025 | 31.045 | 31.025 | 31.045 | 4600.0 |
| 2002-03-18 18:00:00 | MSFT | Stock | 31.035 | 31.035 | 31.01 | 31.01 | 1800.0 |
| 2002-03-18 08:00:00 | NVDA | Stock | 0.4417 | 0.4466 | 0.4396 | 0.4458 | 2424000.0 |
| 2002-03-18 08:30:00 | NVDA | Stock | 0.4459 | 0.4479 | 0.4392 | 0.445 | 1176000.0 |
| 2002-03-18 09:00:00 | NVDA | Stock | 0.445 | 0.4485 | 0.4425 | 0.4477 | 3240000.0 |
| 2002-03-18 09:30:00 | NVDA | Stock | 0.4477 | 0.4574 | 0.4473 | 0.4531 | 139668000.0 |
| 2002-03-18 10:00:00 | NVDA | Stock | 0.4529 | 0.455 | 0.4504 | 0.4505 | 97968000.0 |
| 2002-03-18 10:30:00 | NVDA | Stock | 0.4505 | 0.4511 | 0.4426 | 0.4449 | 115104000.0 |
| 2002-03-18 11:00:00 | NVDA | Stock | 0.4454 | 0.4471 | 0.44 | 0.4411 | 71340000.0 |
| 2002-03-18 11:30:00 | NVDA | Stock | 0.4412 | 0.4412 | 0.4377 | 0.4402 | 70092000.0 |
| 2002-03-18 12:00:00 | NVDA | Stock | 0.4402 | 0.4407 | 0.4384 | 0.4405 | 29676000.0 |
| 2002-03-18 12:30:00 | NVDA | Stock | 0.4405 | 0.4407 | 0.4347 | 0.4367 | 49716000.0 |
| 2002-03-18 13:00:00 | NVDA | Stock | 0.4367 | 0.4407 | 0.4348 | 0.4405 | 50784000.0 |
> showing 50 of 30,746 rows — these rows as CSV