PREVIEW / stock_30min / 2003-10-16
file: by_date/stock_30min/2003/2003-10-16.parquet size: 700 KB rows: 37,974 symbols: 1,647
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 |
|---|---|---|---|---|---|---|---|
| 2003-10-16 08:00:00 | AAPL | Stock | 0.4321 | 0.4321 | 0.425 | 0.4286 | 1320200.0 |
| 2003-10-16 08:30:00 | AAPL | Stock | 0.4286 | 0.4427 | 0.4262 | 0.4262 | 1215200.0 |
| 2003-10-16 09:00:00 | AAPL | Stock | 0.4263 | 0.4277 | 0.425 | 0.4252 | 2142168.0 |
| 2003-10-16 09:30:00 | AAPL | Stock | 0.425 | 0.4257 | 0.4077 | 0.4095 | 151100432.0 |
| 2003-10-16 10:00:00 | AAPL | Stock | 0.4093 | 0.4096 | 0.4038 | 0.4064 | 139364120.0 |
| 2003-10-16 10:30:00 | AAPL | Stock | 0.4066 | 0.4089 | 0.405 | 0.4059 | 85437576.0 |
| 2003-10-16 11:00:00 | AAPL | Stock | 0.4059 | 0.4064 | 0.4034 | 0.4038 | 28925120.0 |
| 2003-10-16 11:30:00 | AAPL | Stock | 0.4038 | 0.4038 | 0.4002 | 0.403 | 53380208.0 |
| 2003-10-16 12:00:00 | AAPL | Stock | 0.403 | 0.4081 | 0.4027 | 0.4075 | 55136704.0 |
| 2003-10-16 12:30:00 | AAPL | Stock | 0.4075 | 0.4116 | 0.4073 | 0.4107 | 58313360.0 |
| 2003-10-16 13:00:00 | AAPL | Stock | 0.4107 | 0.413 | 0.4088 | 0.4127 | 40335008.0 |
| 2003-10-16 13:30:00 | AAPL | Stock | 0.4116 | 0.4134 | 0.4079 | 0.4113 | 33597144.0 |
| 2003-10-16 14:00:00 | AAPL | Stock | 0.4109 | 0.4189 | 0.4107 | 0.417 | 66579688.0 |
| 2003-10-16 14:30:00 | AAPL | Stock | 0.417 | 0.4191 | 0.4148 | 0.4166 | 64293264.0 |
| 2003-10-16 15:00:00 | AAPL | Stock | 0.4166 | 0.4171 | 0.4148 | 0.4159 | 32088224.0 |
| 2003-10-16 15:30:00 | AAPL | Stock | 0.4157 | 0.4171 | 0.4139 | 0.4141 | 62875680.0 |
| 2003-10-16 16:00:00 | AAPL | Stock | 0.4155 | 0.4163 | 0.4139 | 0.4157 | 9215024.0 |
| 2003-10-16 16:30:00 | AAPL | Stock | 0.4143 | 0.4152 | 0.4143 | 0.4152 | 140000.0 |
| 2003-10-16 17:00:00 | AAPL | Stock | 0.4148 | 0.4152 | 0.4148 | 0.4152 | 47600.0 |
| 2003-10-16 17:30:00 | AAPL | Stock | 0.4152 | 0.4155 | 0.4148 | 0.4148 | 862400.0 |
| 2003-10-16 18:00:00 | AAPL | Stock | 0.4148 | 0.4161 | 0.4134 | 0.4134 | 358848.0 |
| 2003-10-16 08:00:00 | MSFT | Stock | 29.0 | 29.25 | 28.96 | 29.03 | 9100.0 |
| 2003-10-16 08:30:00 | MSFT | Stock | 29.0 | 29.0 | 29.0 | 29.0 | 3100.0 |
| 2003-10-16 09:00:00 | MSFT | Stock | 29.03 | 29.03 | 28.88 | 28.88 | 80659.0 |
| 2003-10-16 09:30:00 | MSFT | Stock | 28.91 | 29.0 | 28.8 | 28.95 | 3914325.0 |
| 2003-10-16 10:00:00 | MSFT | Stock | 28.96 | 29.2 | 28.94 | 29.13 | 2955841.0 |
| 2003-10-16 10:30:00 | MSFT | Stock | 29.13 | 29.13 | 28.999 | 29.08 | 2821321.0 |
| 2003-10-16 11:00:00 | MSFT | Stock | 29.08 | 29.12 | 29.01 | 29.04 | 2186226.0 |
| 2003-10-16 11:30:00 | MSFT | Stock | 29.04 | 29.098 | 29.01 | 29.09 | 1402617.0 |
| 2003-10-16 12:00:00 | MSFT | Stock | 29.09 | 29.17 | 29.07 | 29.14 | 2265624.0 |
| 2003-10-16 12:30:00 | MSFT | Stock | 29.15 | 29.25 | 29.14 | 29.24 | 2490974.0 |
| 2003-10-16 13:00:00 | MSFT | Stock | 29.24 | 29.26 | 29.1399 | 29.14 | 1466048.0 |
| 2003-10-16 13:30:00 | MSFT | Stock | 29.14 | 29.17 | 29.079 | 29.16 | 1130736.0 |
| 2003-10-16 14:00:00 | MSFT | Stock | 29.15 | 29.19 | 29.09 | 29.09 | 1282199.0 |
| 2003-10-16 14:30:00 | MSFT | Stock | 29.09 | 29.16 | 29.048 | 29.14 | 4723353.0 |
| 2003-10-16 15:00:00 | MSFT | Stock | 29.16 | 29.2 | 29.04 | 29.2 | 2941813.0 |
| 2003-10-16 15:30:00 | MSFT | Stock | 29.201 | 29.31 | 29.17 | 29.28 | 6209423.0 |
| 2003-10-16 16:00:00 | MSFT | Stock | 29.28 | 29.31 | 29.1 | 29.26 | 1604484.0 |
| 2003-10-16 16:30:00 | MSFT | Stock | 29.26 | 29.31 | 29.22 | 29.22 | 32950.0 |
| 2003-10-16 17:00:00 | MSFT | Stock | 29.22 | 29.24 | 29.21 | 29.222 | 107000.0 |
| 2003-10-16 17:30:00 | MSFT | Stock | 29.23 | 29.31 | 29.22 | 29.22 | 37500.0 |
| 2003-10-16 18:00:00 | MSFT | Stock | 29.22 | 29.22 | 29.22 | 29.22 | 700.0 |
| 2003-10-16 08:00:00 | NVDA | Stock | 0.1412 | 0.1417 | 0.1412 | 0.1417 | 60000.0 |
| 2003-10-16 08:30:00 | NVDA | Stock | 0.1418 | 0.1418 | 0.1418 | 0.1418 | 180000.0 |
| 2003-10-16 09:00:00 | NVDA | Stock | 0.1419 | 0.1419 | 0.1412 | 0.1417 | 660000.0 |
| 2003-10-16 09:30:00 | NVDA | Stock | 0.1417 | 0.1429 | 0.1396 | 0.1425 | 66978240.0 |
| 2003-10-16 10:00:00 | NVDA | Stock | 0.1424 | 0.1425 | 0.1413 | 0.1415 | 32532840.0 |
| 2003-10-16 10:30:00 | NVDA | Stock | 0.1417 | 0.1423 | 0.1406 | 0.1418 | 25128600.0 |
| 2003-10-16 11:00:00 | NVDA | Stock | 0.1418 | 0.1422 | 0.1414 | 0.1415 | 21977520.0 |
| 2003-10-16 11:30:00 | NVDA | Stock | 0.1415 | 0.1417 | 0.1413 | 0.1415 | 29638800.0 |
> showing 50 of 37,974 rows — these rows as CSV