PREVIEW / stock_30min / 2002-03-14
file: by_date/stock_30min/2002/2002-03-14.parquet size: 579 KB rows: 29,931 symbols: 1,395
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-14 08:00:00 | AAPL | Stock | 0.4373 | 0.4374 | 0.4361 | 0.4366 | 700000.0 |
| 2002-03-14 08:30:00 | AAPL | Stock | 0.4364 | 0.4364 | 0.4363 | 0.4364 | 162400.0 |
| 2002-03-14 09:00:00 | AAPL | Stock | 0.4366 | 0.4366 | 0.4339 | 0.4339 | 50400.0 |
| 2002-03-14 09:30:00 | AAPL | Stock | 0.4339 | 0.4393 | 0.4338 | 0.4359 | 29780800.0 |
| 2002-03-14 10:00:00 | AAPL | Stock | 0.4357 | 0.4359 | 0.4264 | 0.4298 | 46984000.0 |
| 2002-03-14 10:30:00 | AAPL | Stock | 0.4304 | 0.4331 | 0.4286 | 0.4321 | 11575200.0 |
| 2002-03-14 11:00:00 | AAPL | Stock | 0.4321 | 0.4341 | 0.4309 | 0.4339 | 5734400.0 |
| 2002-03-14 11:30:00 | AAPL | Stock | 0.4339 | 0.4361 | 0.4336 | 0.4354 | 10819200.0 |
| 2002-03-14 12:00:00 | AAPL | Stock | 0.4354 | 0.4364 | 0.433 | 0.4348 | 9447200.0 |
| 2002-03-14 12:30:00 | AAPL | Stock | 0.4348 | 0.4364 | 0.4323 | 0.4339 | 5656000.0 |
| 2002-03-14 13:00:00 | AAPL | Stock | 0.4336 | 0.4352 | 0.4336 | 0.4352 | 6512800.0 |
| 2002-03-14 13:30:00 | AAPL | Stock | 0.4339 | 0.4352 | 0.4339 | 0.4345 | 8372000.0 |
| 2002-03-14 14:00:00 | AAPL | Stock | 0.4345 | 0.4357 | 0.433 | 0.4341 | 11452000.0 |
| 2002-03-14 14:30:00 | AAPL | Stock | 0.4341 | 0.4366 | 0.433 | 0.4357 | 11424000.0 |
| 2002-03-14 15:00:00 | AAPL | Stock | 0.4359 | 0.4375 | 0.4339 | 0.4366 | 8808800.0 |
| 2002-03-14 15:30:00 | AAPL | Stock | 0.4366 | 0.4366 | 0.4338 | 0.4363 | 27753600.0 |
| 2002-03-14 16:00:00 | AAPL | Stock | 0.4364 | 0.4379 | 0.4357 | 0.4363 | 7190400.0 |
| 2002-03-14 16:30:00 | AAPL | Stock | 0.4377 | 0.4377 | 0.4377 | 0.4377 | 22400.0 |
| 2002-03-14 17:00:00 | AAPL | Stock | 0.4363 | 0.4424 | 0.4363 | 0.4424 | 168000.0 |
| 2002-03-14 08:00:00 | MSFT | Stock | 31.075 | 31.1505 | 31.025 | 31.15 | 17400.0 |
| 2002-03-14 08:30:00 | MSFT | Stock | 31.125 | 31.15 | 31.025 | 31.055 | 68000.0 |
| 2002-03-14 09:00:00 | MSFT | Stock | 31.08 | 31.1005 | 31.05 | 31.07 | 268800.0 |
| 2002-03-14 09:30:00 | MSFT | Stock | 31.07 | 31.12 | 30.865 | 30.9122 | 5231400.0 |
| 2002-03-14 10:00:00 | MSFT | Stock | 30.91 | 30.95 | 30.75 | 30.875 | 5050200.0 |
| 2002-03-14 10:30:00 | MSFT | Stock | 30.875 | 30.9595 | 30.765 | 30.8145 | 4695200.0 |
| 2002-03-14 11:00:00 | MSFT | Stock | 30.81 | 30.895 | 30.775 | 30.83 | 2710600.0 |
| 2002-03-14 11:30:00 | MSFT | Stock | 30.8595 | 30.895 | 30.765 | 30.815 | 2439400.0 |
| 2002-03-14 12:00:00 | MSFT | Stock | 30.815 | 30.835 | 30.605 | 30.625 | 2566600.0 |
| 2002-03-14 12:30:00 | MSFT | Stock | 30.62 | 30.735 | 30.6 | 30.7 | 2439200.0 |
| 2002-03-14 13:00:00 | MSFT | Stock | 30.7 | 30.74 | 30.61 | 30.685 | 2068800.0 |
| 2002-03-14 13:30:00 | MSFT | Stock | 30.68 | 30.73 | 30.555 | 30.61 | 1913200.0 |
| 2002-03-14 14:00:00 | MSFT | Stock | 30.615 | 30.675 | 30.54 | 30.57 | 3597800.0 |
| 2002-03-14 14:30:00 | MSFT | Stock | 30.57 | 30.725 | 30.545 | 30.7 | 3795000.0 |
| 2002-03-14 15:00:00 | MSFT | Stock | 30.705 | 30.745 | 30.555 | 30.645 | 3841000.0 |
| 2002-03-14 15:30:00 | MSFT | Stock | 30.65 | 30.7 | 30.565 | 30.605 | 5662400.0 |
| 2002-03-14 16:00:00 | MSFT | Stock | 30.6065 | 30.7461 | 30.5 | 30.5 | 2194800.0 |
| 2002-03-14 16:30:00 | MSFT | Stock | 30.59 | 30.6751 | 30.525 | 30.59 | 39600.0 |
| 2002-03-14 17:00:00 | MSFT | Stock | 30.59 | 31.0386 | 30.575 | 31.0386 | 67600.0 |
| 2002-03-14 17:30:00 | MSFT | Stock | 30.6 | 30.6 | 30.4 | 30.4 | 21200.0 |
| 2002-03-14 18:00:00 | MSFT | Stock | 30.4 | 30.5 | 30.4 | 30.49 | 3000.0 |
| 2002-03-14 08:00:00 | NVDA | Stock | 0.4459 | 0.4459 | 0.4434 | 0.4459 | 660000.0 |
| 2002-03-14 08:30:00 | NVDA | Stock | 0.4457 | 0.4457 | 0.4433 | 0.4433 | 540000.0 |
| 2002-03-14 09:00:00 | NVDA | Stock | 0.4426 | 0.4467 | 0.4426 | 0.4437 | 1392000.0 |
| 2002-03-14 09:30:00 | NVDA | Stock | 0.4437 | 0.4448 | 0.4318 | 0.4324 | 231036000.0 |
| 2002-03-14 10:00:00 | NVDA | Stock | 0.4324 | 0.436 | 0.4296 | 0.4324 | 148524000.0 |
| 2002-03-14 10:30:00 | NVDA | Stock | 0.4324 | 0.4373 | 0.4312 | 0.4343 | 98508000.0 |
| 2002-03-14 11:00:00 | NVDA | Stock | 0.4343 | 0.44 | 0.4334 | 0.4351 | 90168000.0 |
| 2002-03-14 11:30:00 | NVDA | Stock | 0.4351 | 0.4362 | 0.4329 | 0.4361 | 43860000.0 |
| 2002-03-14 12:00:00 | NVDA | Stock | 0.4361 | 0.4361 | 0.4322 | 0.434 | 24012000.0 |
| 2002-03-14 12:30:00 | NVDA | Stock | 0.434 | 0.4349 | 0.4309 | 0.4325 | 38508000.0 |
> showing 50 of 29,931 rows — these rows as CSV