PREVIEW / stock_1hour / 2002-01-30
file: by_date/stock_1hour/2002/2002-01-30.parquet size: 394 KB rows: 18,428 symbols: 1,338
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-01-30 08:00:00 | AAPL | Stock | 0.4122 | 0.4163 | 0.4105 | 0.4143 | 789600.0 |
| 2002-01-30 09:00:00 | AAPL | Stock | 0.4138 | 0.4159 | 0.4059 | 0.4152 | 38992800.0 |
| 2002-01-30 10:00:00 | AAPL | Stock | 0.4146 | 0.417 | 0.4096 | 0.4154 | 51727200.0 |
| 2002-01-30 11:00:00 | AAPL | Stock | 0.415 | 0.4191 | 0.4138 | 0.4143 | 32323200.0 |
| 2002-01-30 12:00:00 | AAPL | Stock | 0.4143 | 0.4207 | 0.4136 | 0.4202 | 56940800.0 |
| 2002-01-30 13:00:00 | AAPL | Stock | 0.4204 | 0.4255 | 0.4196 | 0.4207 | 81340000.0 |
| 2002-01-30 14:00:00 | AAPL | Stock | 0.4213 | 0.4259 | 0.4179 | 0.422 | 45869600.0 |
| 2002-01-30 15:00:00 | AAPL | Stock | 0.422 | 0.4311 | 0.4218 | 0.4311 | 127467200.0 |
| 2002-01-30 16:00:00 | AAPL | Stock | 0.4309 | 0.4321 | 0.4196 | 0.4313 | 8176000.0 |
| 2002-01-30 17:00:00 | AAPL | Stock | 0.4313 | 0.4345 | 0.4304 | 0.4345 | 218400.0 |
| 2002-01-30 18:00:00 | AAPL | Stock | 0.4305 | 0.4305 | 0.4305 | 0.4305 | 22400.0 |
| 2002-01-30 08:00:00 | MSFT | Stock | 31.225 | 31.41 | 31.125 | 31.25 | 155200.0 |
| 2002-01-30 09:00:00 | MSFT | Stock | 31.3 | 31.34 | 30.975 | 31.255 | 9194600.0 |
| 2002-01-30 10:00:00 | MSFT | Stock | 31.255 | 31.255 | 30.7995 | 30.835 | 12253400.0 |
| 2002-01-30 11:00:00 | MSFT | Stock | 30.83 | 31.035 | 30.7 | 30.71 | 6899000.0 |
| 2002-01-30 12:00:00 | MSFT | Stock | 30.705 | 30.97 | 30.665 | 30.85 | 5442000.0 |
| 2002-01-30 13:00:00 | MSFT | Stock | 30.84 | 31.125 | 30.825 | 31.05 | 6100000.0 |
| 2002-01-30 14:00:00 | MSFT | Stock | 31.0495 | 31.245 | 30.78 | 30.99 | 10733600.0 |
| 2002-01-30 15:00:00 | MSFT | Stock | 31.01 | 31.45 | 30.91 | 31.42 | 12242600.0 |
| 2002-01-30 16:00:00 | MSFT | Stock | 31.425 | 31.455 | 31.0194 | 31.405 | 1963600.0 |
| 2002-01-30 17:00:00 | MSFT | Stock | 31.45 | 31.475 | 31.425 | 31.475 | 12400.0 |
| 2002-01-30 18:00:00 | MSFT | Stock | 31.475 | 31.475 | 31.455 | 31.455 | 3200.0 |
| 2002-01-30 08:00:00 | NVDA | Stock | 0.5387 | 0.5457 | 0.5387 | 0.5426 | 2256000.0 |
| 2002-01-30 09:00:00 | NVDA | Stock | 0.5426 | 0.5444 | 0.5343 | 0.5399 | 134616000.0 |
| 2002-01-30 10:00:00 | NVDA | Stock | 0.5397 | 0.5419 | 0.5287 | 0.5357 | 246252000.0 |
| 2002-01-30 11:00:00 | NVDA | Stock | 0.5358 | 0.545 | 0.5293 | 0.5297 | 149196000.0 |
| 2002-01-30 12:00:00 | NVDA | Stock | 0.5304 | 0.5355 | 0.5293 | 0.5339 | 73308000.0 |
| 2002-01-30 13:00:00 | NVDA | Stock | 0.5339 | 0.5432 | 0.5338 | 0.5404 | 105804000.0 |
| 2002-01-30 14:00:00 | NVDA | Stock | 0.5407 | 0.5447 | 0.5289 | 0.5349 | 182352000.0 |
| 2002-01-30 15:00:00 | NVDA | Stock | 0.5352 | 0.5457 | 0.5333 | 0.5452 | 207516000.0 |
| 2002-01-30 16:00:00 | NVDA | Stock | 0.5452 | 0.549 | 0.5376 | 0.5451 | 81732000.0 |
| 2002-01-30 17:00:00 | NVDA | Stock | 0.5474 | 0.5489 | 0.5464 | 0.5487 | 432000.0 |
| 2002-01-30 18:00:00 | NVDA | Stock | 0.5487 | 0.5487 | 0.5483 | 0.5483 | 72000.0 |
| 2002-01-30 08:00:00 | AMZN | Stock | 0.709 | 0.7315 | 0.703 | 0.7125 | 1632000.0 |
| 2002-01-30 09:00:00 | AMZN | Stock | 0.71 | 0.714 | 0.695 | 0.71 | 39856000.0 |
| 2002-01-30 10:00:00 | AMZN | Stock | 0.7105 | 0.7125 | 0.672 | 0.6825 | 56580000.0 |
| 2002-01-30 11:00:00 | AMZN | Stock | 0.6809 | 0.698 | 0.6735 | 0.6735 | 24954000.0 |
| 2002-01-30 12:00:00 | AMZN | Stock | 0.6735 | 0.6745 | 0.66 | 0.673 | 48194000.0 |
| 2002-01-30 13:00:00 | AMZN | Stock | 0.673 | 0.68 | 0.6715 | 0.675 | 25350000.0 |
| 2002-01-30 14:00:00 | AMZN | Stock | 0.6755 | 0.687 | 0.673 | 0.683 | 40914000.0 |
| 2002-01-30 15:00:00 | AMZN | Stock | 0.683 | 0.709 | 0.6825 | 0.695 | 38372000.0 |
| 2002-01-30 16:00:00 | AMZN | Stock | 0.696 | 0.7025 | 0.6733 | 0.6733 | 4864000.0 |
| 2002-01-30 17:00:00 | AMZN | Stock | 0.695 | 0.7075 | 0.69 | 0.7 | 180000.0 |
| 2002-01-30 18:00:00 | AMZN | Stock | 0.6975 | 0.6995 | 0.6975 | 0.6995 | 70000.0 |
| 2002-01-30 09:00:00 | CL | Stock | 27.635 | 28.05 | 27.6 | 28.05 | 397400.0 |
| 2002-01-30 10:00:00 | CL | Stock | 28.025 | 28.2 | 27.93 | 28.075 | 619800.0 |
| 2002-01-30 11:00:00 | CL | Stock | 28.075 | 28.245 | 28.07 | 28.1 | 599200.0 |
| 2002-01-30 12:00:00 | CL | Stock | 28.1 | 28.22 | 28.0 | 28.02 | 371000.0 |
| 2002-01-30 13:00:00 | CL | Stock | 28.025 | 28.175 | 27.975 | 27.99 | 354000.0 |
| 2002-01-30 14:00:00 | CL | Stock | 27.995 | 28.15 | 27.85 | 28.0 | 485200.0 |
> showing 50 of 18,428 rows — these rows as CSV