PREVIEW / stock_1hour / 2002-03-21
file: by_date/stock_1hour/2002/2002-03-21.parquet size: 395 KB rows: 18,513 symbols: 1,402
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-21 08:00:00 | AAPL | Stock | 0.4332 | 0.4439 | 0.4286 | 0.4286 | 15971200.0 |
| 2002-03-21 09:00:00 | AAPL | Stock | 0.4268 | 0.445 | 0.422 | 0.4279 | 144412800.0 |
| 2002-03-21 10:00:00 | AAPL | Stock | 0.4282 | 0.4291 | 0.4211 | 0.4264 | 126677600.0 |
| 2002-03-21 11:00:00 | AAPL | Stock | 0.4264 | 0.4296 | 0.4245 | 0.4263 | 44671200.0 |
| 2002-03-21 12:00:00 | AAPL | Stock | 0.4261 | 0.4263 | 0.4196 | 0.4234 | 51396800.0 |
| 2002-03-21 13:00:00 | AAPL | Stock | 0.4236 | 0.4246 | 0.4196 | 0.4205 | 42610400.0 |
| 2002-03-21 14:00:00 | AAPL | Stock | 0.4205 | 0.4268 | 0.4154 | 0.425 | 63750400.0 |
| 2002-03-21 15:00:00 | AAPL | Stock | 0.4254 | 0.4338 | 0.4254 | 0.4336 | 89594400.0 |
| 2002-03-21 16:00:00 | AAPL | Stock | 0.4334 | 0.4346 | 0.4275 | 0.4339 | 8327200.0 |
| 2002-03-21 17:00:00 | AAPL | Stock | 0.4339 | 0.4348 | 0.4334 | 0.4339 | 1192800.0 |
| 2002-03-21 08:00:00 | MSFT | Stock | 30.03 | 34.0 | 29.95 | 29.975 | 152200.0 |
| 2002-03-21 09:00:00 | MSFT | Stock | 30.1 | 30.21 | 30.055 | 30.069 | 5477800.0 |
| 2002-03-21 10:00:00 | MSFT | Stock | 30.07 | 30.28 | 29.925 | 30.165 | 9120600.0 |
| 2002-03-21 11:00:00 | MSFT | Stock | 30.165 | 30.2505 | 30.06 | 30.135 | 3452600.0 |
| 2002-03-21 12:00:00 | MSFT | Stock | 30.135 | 30.195 | 29.915 | 30.1445 | 6269600.0 |
| 2002-03-21 13:00:00 | MSFT | Stock | 30.13 | 30.21 | 30.08 | 30.14 | 3688600.0 |
| 2002-03-21 14:00:00 | MSFT | Stock | 30.135 | 30.525 | 30.055 | 30.51 | 5137000.0 |
| 2002-03-21 15:00:00 | MSFT | Stock | 30.515 | 30.7995 | 30.47 | 30.69 | 8730400.0 |
| 2002-03-21 16:00:00 | MSFT | Stock | 30.68 | 30.75 | 30.0769 | 30.68 | 1267200.0 |
| 2002-03-21 17:00:00 | MSFT | Stock | 30.575 | 30.68 | 30.53 | 30.585 | 174600.0 |
| 2002-03-21 18:00:00 | MSFT | Stock | 30.625 | 30.625 | 30.618 | 30.625 | 8000.0 |
| 2002-03-21 08:00:00 | NVDA | Stock | 0.3917 | 0.4 | 0.3877 | 0.3942 | 4296000.0 |
| 2002-03-21 09:00:00 | NVDA | Stock | 0.3937 | 0.3959 | 0.3838 | 0.3916 | 357396000.0 |
| 2002-03-21 10:00:00 | NVDA | Stock | 0.3916 | 0.4052 | 0.39 | 0.3997 | 425700000.0 |
| 2002-03-21 11:00:00 | NVDA | Stock | 0.3999 | 0.4025 | 0.3965 | 0.3984 | 106632000.0 |
| 2002-03-21 12:00:00 | NVDA | Stock | 0.3983 | 0.4016 | 0.3942 | 0.3999 | 136080000.0 |
| 2002-03-21 13:00:00 | NVDA | Stock | 0.3998 | 0.404 | 0.3979 | 0.4012 | 95688000.0 |
| 2002-03-21 14:00:00 | NVDA | Stock | 0.4012 | 0.4061 | 0.3987 | 0.4057 | 142356000.0 |
| 2002-03-21 15:00:00 | NVDA | Stock | 0.4056 | 0.4129 | 0.405 | 0.4081 | 321408000.0 |
| 2002-03-21 16:00:00 | NVDA | Stock | 0.4081 | 0.4104 | 0.4032 | 0.41 | 24948000.0 |
| 2002-03-21 17:00:00 | NVDA | Stock | 0.4097 | 0.4097 | 0.405 | 0.4067 | 2892000.0 |
| 2002-03-21 18:00:00 | NVDA | Stock | 0.4071 | 0.4071 | 0.4071 | 0.4071 | 192000.0 |
| 2002-03-21 08:00:00 | AMZN | Stock | 0.725 | 0.7325 | 0.725 | 0.73 | 178000.0 |
| 2002-03-21 09:00:00 | AMZN | Stock | 0.7315 | 0.739 | 0.73 | 0.733 | 13260000.0 |
| 2002-03-21 10:00:00 | AMZN | Stock | 0.7335 | 0.747 | 0.728 | 0.74 | 18240000.0 |
| 2002-03-21 11:00:00 | AMZN | Stock | 0.741 | 0.743 | 0.736 | 0.739 | 11026000.0 |
| 2002-03-21 12:00:00 | AMZN | Stock | 0.7385 | 0.7505 | 0.735 | 0.7475 | 16292000.0 |
| 2002-03-21 13:00:00 | AMZN | Stock | 0.7475 | 0.7585 | 0.747 | 0.7495 | 22832000.0 |
| 2002-03-21 14:00:00 | AMZN | Stock | 0.7505 | 0.761 | 0.75 | 0.7595 | 7940000.0 |
| 2002-03-21 15:00:00 | AMZN | Stock | 0.7595 | 0.762 | 0.755 | 0.7585 | 15286000.0 |
| 2002-03-21 16:00:00 | AMZN | Stock | 0.758 | 0.759 | 0.7575 | 0.7585 | 1360000.0 |
| 2002-03-21 17:00:00 | AMZN | Stock | 0.7585 | 0.7585 | 0.7575 | 0.7575 | 226000.0 |
| 2002-03-21 18:00:00 | AMZN | Stock | 0.7575 | 0.7585 | 0.7575 | 0.7585 | 10000.0 |
| 2002-03-21 09:00:00 | CL | Stock | 28.405 | 28.525 | 28.39 | 28.495 | 299200.0 |
| 2002-03-21 10:00:00 | CL | Stock | 28.5 | 28.535 | 28.3 | 28.45 | 472400.0 |
| 2002-03-21 11:00:00 | CL | Stock | 28.45 | 28.525 | 28.295 | 28.3 | 288600.0 |
| 2002-03-21 12:00:00 | CL | Stock | 28.3 | 28.3 | 28.1 | 28.185 | 424200.0 |
| 2002-03-21 13:00:00 | CL | Stock | 28.195 | 28.29 | 28.165 | 28.19 | 216800.0 |
| 2002-03-21 14:00:00 | CL | Stock | 28.21 | 28.34 | 28.15 | 28.3 | 207600.0 |
| 2002-03-21 15:00:00 | CL | Stock | 28.275 | 28.34 | 28.195 | 28.305 | 607800.0 |
> showing 50 of 18,513 rows — these rows as CSV