PREVIEW / stock_30min / 2006-04-28
file: by_date/stock_30min/2006/2006-04-28.parquet size: 910 KB rows: 49,096 symbols: 2,243
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 |
|---|---|---|---|---|---|---|---|
| 2006-04-28 07:00:00 | AAPL | Stock | 2.4654 | 2.4654 | 2.4654 | 2.4654 | 14000.0 |
| 2006-04-28 08:00:00 | AAPL | Stock | 2.4643 | 2.4689 | 2.4193 | 2.4589 | 875000.0 |
| 2006-04-28 08:30:00 | AAPL | Stock | 2.46 | 2.4714 | 2.46 | 2.4689 | 1682156.0 |
| 2006-04-28 09:00:00 | AAPL | Stock | 2.4696 | 2.4779 | 2.4571 | 2.4775 | 1848588.0 |
| 2006-04-28 09:30:00 | AAPL | Stock | 2.4777 | 2.5171 | 2.4714 | 2.5082 | 132362216.0 |
| 2006-04-28 10:00:00 | AAPL | Stock | 2.5086 | 2.5464 | 2.5079 | 2.5421 | 121852276.0 |
| 2006-04-28 10:30:00 | AAPL | Stock | 2.5421 | 2.5436 | 2.5275 | 2.5346 | 71412096.0 |
| 2006-04-28 11:00:00 | AAPL | Stock | 2.5346 | 2.535 | 2.5225 | 2.5236 | 51445772.0 |
| 2006-04-28 11:30:00 | AAPL | Stock | 2.5239 | 2.5314 | 2.5218 | 2.528 | 38970988.0 |
| 2006-04-28 12:00:00 | AAPL | Stock | 2.5279 | 2.5296 | 2.52 | 2.5289 | 28072856.0 |
| 2006-04-28 12:30:00 | AAPL | Stock | 2.5289 | 2.53 | 2.5093 | 2.5154 | 44960496.0 |
| 2006-04-28 13:00:00 | AAPL | Stock | 2.5151 | 2.5257 | 2.515 | 2.5193 | 34288324.0 |
| 2006-04-28 13:30:00 | AAPL | Stock | 2.5189 | 2.5271 | 2.5182 | 2.5271 | 24066896.0 |
| 2006-04-28 14:00:00 | AAPL | Stock | 2.5271 | 2.5307 | 2.5204 | 2.5304 | 24310468.0 |
| 2006-04-28 14:30:00 | AAPL | Stock | 2.53 | 2.5371 | 2.5214 | 2.5236 | 45074764.0 |
| 2006-04-28 15:00:00 | AAPL | Stock | 2.5236 | 2.5275 | 2.5139 | 2.5232 | 54464676.0 |
| 2006-04-28 15:30:00 | AAPL | Stock | 2.5232 | 2.5264 | 2.5143 | 2.5161 | 60411484.0 |
| 2006-04-28 16:00:00 | AAPL | Stock | 2.5186 | 2.5221 | 2.5139 | 2.5196 | 2365664.0 |
| 2006-04-28 16:30:00 | AAPL | Stock | 2.5196 | 2.5196 | 2.5139 | 2.5139 | 925652.0 |
| 2006-04-28 17:00:00 | AAPL | Stock | 2.5171 | 2.5179 | 2.5161 | 2.5179 | 120120.0 |
| 2006-04-28 17:30:00 | AAPL | Stock | 2.5154 | 2.5161 | 2.515 | 2.5157 | 35000.0 |
| 2006-04-28 18:00:00 | AAPL | Stock | 2.5157 | 2.5161 | 2.5143 | 2.5146 | 218120.0 |
| 2006-04-28 04:00:00 | MSFT | Stock | 25.52 | 25.52 | 25.5 | 25.5 | 1200.0 |
| 2006-04-28 06:00:00 | MSFT | Stock | 25.43 | 25.43 | 25.43 | 25.43 | 100.0 |
| 2006-04-28 06:30:00 | MSFT | Stock | 25.33 | 25.37 | 25.33 | 25.37 | 2500.0 |
| 2006-04-28 07:00:00 | MSFT | Stock | 25.37 | 25.37 | 24.97 | 25.0 | 174058.0 |
| 2006-04-28 07:30:00 | MSFT | Stock | 25.0 | 25.05 | 24.84 | 24.9 | 519055.0 |
| 2006-04-28 08:00:00 | MSFT | Stock | 24.87 | 25.08 | 24.7 | 24.74 | 12526215.0 |
| 2006-04-28 08:30:00 | MSFT | Stock | 24.74 | 24.875 | 24.59 | 24.65 | 13458540.0 |
| 2006-04-28 09:00:00 | MSFT | Stock | 24.64 | 25.003 | 24.14 | 24.23 | 29488901.0 |
| 2006-04-28 09:30:00 | MSFT | Stock | 24.23 | 24.5 | 24.0 | 24.2 | 122321180.0 |
| 2006-04-28 10:00:00 | MSFT | Stock | 24.2 | 24.35 | 24.07 | 24.29 | 62598190.0 |
| 2006-04-28 10:30:00 | MSFT | Stock | 24.29 | 24.38 | 24.2 | 24.21 | 37737721.0 |
| 2006-04-28 11:00:00 | MSFT | Stock | 24.21 | 24.28 | 24.07 | 24.26 | 33823619.0 |
| 2006-04-28 11:30:00 | MSFT | Stock | 24.26 | 24.29 | 24.2 | 24.29 | 21261670.0 |
| 2006-04-28 12:00:00 | MSFT | Stock | 24.29 | 24.29 | 24.25 | 24.25 | 22888443.0 |
| 2006-04-28 12:30:00 | MSFT | Stock | 24.25 | 24.3 | 24.15 | 24.27 | 25971635.0 |
| 2006-04-28 13:00:00 | MSFT | Stock | 24.27 | 24.28 | 24.22 | 24.239 | 14101063.0 |
| 2006-04-28 13:30:00 | MSFT | Stock | 24.24 | 24.28 | 24.16 | 24.176 | 19098964.0 |
| 2006-04-28 14:00:00 | MSFT | Stock | 24.18 | 24.23 | 24.1 | 24.11 | 18735710.0 |
| 2006-04-28 14:30:00 | MSFT | Stock | 24.12 | 24.2 | 24.0 | 24.05 | 35163471.0 |
| 2006-04-28 15:00:00 | MSFT | Stock | 24.05 | 24.1 | 24.02 | 24.09 | 28070557.0 |
| 2006-04-28 15:30:00 | MSFT | Stock | 24.1 | 24.25 | 24.08 | 24.16 | 51811356.0 |
| 2006-04-28 16:00:00 | MSFT | Stock | 24.16 | 24.33 | 24.11 | 24.15 | 5209316.0 |
| 2006-04-28 16:30:00 | MSFT | Stock | 24.13 | 24.19 | 24.12 | 24.15 | 889865.0 |
| 2006-04-28 17:00:00 | MSFT | Stock | 24.15 | 24.16 | 24.13 | 24.13 | 653199.0 |
| 2006-04-28 17:30:00 | MSFT | Stock | 24.15 | 24.16 | 24.14 | 24.16 | 37792.0 |
| 2006-04-28 18:00:00 | MSFT | Stock | 24.15 | 24.17 | 24.14 | 24.16 | 29907.0 |
| 2006-04-28 08:00:00 | NVDA | Stock | 0.4847 | 0.4847 | 0.4812 | 0.4812 | 114000.0 |
| 2006-04-28 08:30:00 | NVDA | Stock | 0.4812 | 0.4832 | 0.4812 | 0.4832 | 294000.0 |
> showing 50 of 49,096 rows — these rows as CSV