PREVIEW / stock_30min / 2004-09-01
file: by_date/stock_30min/2004/2004-09-01.parquet size: 738 KB rows: 40,324 symbols: 1,827
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 |
|---|---|---|---|---|---|---|---|
| 2004-09-01 08:00:00 | AAPL | Stock | 0.6149 | 0.6149 | 0.6149 | 0.6149 | 168448.0 |
| 2004-09-01 08:30:00 | AAPL | Stock | 0.6157 | 0.6157 | 0.6157 | 0.6157 | 5600.0 |
| 2004-09-01 09:00:00 | AAPL | Stock | 0.6141 | 0.615 | 0.6123 | 0.6127 | 264432.0 |
| 2004-09-01 09:30:00 | AAPL | Stock | 0.6125 | 0.6168 | 0.6107 | 0.6163 | 28422184.0 |
| 2004-09-01 10:00:00 | AAPL | Stock | 0.6161 | 0.6268 | 0.6157 | 0.6264 | 36843576.0 |
| 2004-09-01 10:30:00 | AAPL | Stock | 0.6266 | 0.6268 | 0.6216 | 0.6241 | 24110744.0 |
| 2004-09-01 11:00:00 | AAPL | Stock | 0.6241 | 0.6247 | 0.621 | 0.6223 | 11284896.0 |
| 2004-09-01 11:30:00 | AAPL | Stock | 0.622 | 0.6261 | 0.6193 | 0.6257 | 20913256.0 |
| 2004-09-01 12:00:00 | AAPL | Stock | 0.6257 | 0.6334 | 0.625 | 0.6332 | 39650016.0 |
| 2004-09-01 12:30:00 | AAPL | Stock | 0.6329 | 0.6416 | 0.6329 | 0.6371 | 89522272.0 |
| 2004-09-01 13:00:00 | AAPL | Stock | 0.6371 | 0.6411 | 0.6293 | 0.6393 | 69748952.0 |
| 2004-09-01 13:30:00 | AAPL | Stock | 0.6393 | 0.6427 | 0.6357 | 0.637 | 38748808.0 |
| 2004-09-01 14:00:00 | AAPL | Stock | 0.6368 | 0.6368 | 0.6336 | 0.6366 | 26124840.0 |
| 2004-09-01 14:30:00 | AAPL | Stock | 0.6364 | 0.64 | 0.6352 | 0.6398 | 22735328.0 |
| 2004-09-01 15:00:00 | AAPL | Stock | 0.64 | 0.6404 | 0.6338 | 0.6359 | 27754944.0 |
| 2004-09-01 15:30:00 | AAPL | Stock | 0.6359 | 0.6416 | 0.6359 | 0.6402 | 50219232.0 |
| 2004-09-01 16:00:00 | AAPL | Stock | 0.64 | 0.6425 | 0.6396 | 0.6411 | 3238424.0 |
| 2004-09-01 16:30:00 | AAPL | Stock | 0.642 | 0.6425 | 0.6407 | 0.6414 | 128800.0 |
| 2004-09-01 17:00:00 | AAPL | Stock | 0.6404 | 0.6443 | 0.6404 | 0.6443 | 1612800.0 |
| 2004-09-01 17:30:00 | AAPL | Stock | 0.6432 | 0.6432 | 0.6432 | 0.6432 | 8960.0 |
| 2004-09-01 18:00:00 | AAPL | Stock | 0.6432 | 0.6443 | 0.6432 | 0.6443 | 128800.0 |
| 2004-09-01 08:00:00 | MSFT | Stock | 27.295 | 27.295 | 27.295 | 27.295 | 1344.0 |
| 2004-09-01 08:30:00 | MSFT | Stock | 27.28 | 27.28 | 27.28 | 27.28 | 1100.0 |
| 2004-09-01 09:00:00 | MSFT | Stock | 27.28 | 27.28 | 27.23 | 27.24 | 40567.0 |
| 2004-09-01 09:30:00 | MSFT | Stock | 27.24 | 27.28 | 27.179 | 27.25 | 3180538.0 |
| 2004-09-01 10:00:00 | MSFT | Stock | 27.25 | 27.5 | 27.24 | 27.5 | 5136083.0 |
| 2004-09-01 10:30:00 | MSFT | Stock | 27.5 | 27.52 | 27.38 | 27.4 | 4031399.0 |
| 2004-09-01 11:00:00 | MSFT | Stock | 27.39 | 27.5 | 27.38 | 27.48 | 3203355.0 |
| 2004-09-01 11:30:00 | MSFT | Stock | 27.48 | 27.49 | 27.39 | 27.43 | 2863116.0 |
| 2004-09-01 12:00:00 | MSFT | Stock | 27.42 | 27.46 | 27.38 | 27.44 | 2406463.0 |
| 2004-09-01 12:30:00 | MSFT | Stock | 27.44 | 27.48 | 27.42 | 27.42 | 2111275.0 |
| 2004-09-01 13:00:00 | MSFT | Stock | 27.42 | 27.43 | 27.14 | 27.32 | 7459557.0 |
| 2004-09-01 13:30:00 | MSFT | Stock | 27.33 | 27.41 | 27.32 | 27.35 | 3026136.0 |
| 2004-09-01 14:00:00 | MSFT | Stock | 27.36 | 27.38 | 27.28 | 27.33 | 2763403.0 |
| 2004-09-01 14:30:00 | MSFT | Stock | 27.33 | 27.34 | 27.26 | 27.31 | 2580361.0 |
| 2004-09-01 15:00:00 | MSFT | Stock | 27.32 | 27.32 | 27.25 | 27.29 | 2682196.0 |
| 2004-09-01 15:30:00 | MSFT | Stock | 27.29 | 27.4 | 27.24 | 27.38 | 4496339.0 |
| 2004-09-01 16:00:00 | MSFT | Stock | 27.38 | 27.4 | 27.35 | 27.39 | 468431.0 |
| 2004-09-01 16:30:00 | MSFT | Stock | 27.39 | 27.4 | 27.37 | 27.39 | 7536.0 |
| 2004-09-01 17:00:00 | MSFT | Stock | 27.39 | 27.39 | 27.39 | 27.39 | 14369.0 |
| 2004-09-01 17:30:00 | MSFT | Stock | 27.39 | 27.39 | 27.39 | 27.39 | 626.0 |
| 2004-09-01 18:00:00 | MSFT | Stock | 27.4 | 27.4 | 27.4 | 27.4 | 2000.0 |
| 2004-09-01 08:00:00 | NVDA | Stock | 0.1029 | 0.1029 | 0.1029 | 0.1029 | 37200.0 |
| 2004-09-01 08:30:00 | NVDA | Stock | 0.1027 | 0.1038 | 0.1027 | 0.1038 | 564000.0 |
| 2004-09-01 09:00:00 | NVDA | Stock | 0.1037 | 0.1037 | 0.102 | 0.102 | 2858640.0 |
| 2004-09-01 09:30:00 | NVDA | Stock | 0.1025 | 0.1055 | 0.1013 | 0.105 | 68463600.0 |
| 2004-09-01 10:00:00 | NVDA | Stock | 0.1049 | 0.107 | 0.1044 | 0.107 | 45353160.0 |
| 2004-09-01 10:30:00 | NVDA | Stock | 0.107 | 0.1073 | 0.1059 | 0.1071 | 35252640.0 |
| 2004-09-01 11:00:00 | NVDA | Stock | 0.1071 | 0.1072 | 0.1067 | 0.1067 | 27658440.0 |
| 2004-09-01 11:30:00 | NVDA | Stock | 0.1066 | 0.1067 | 0.1051 | 0.1053 | 32108040.0 |
> showing 50 of 40,324 rows — these rows as CSV