PREVIEW / stock_1hour / 2002-04-11
file: by_date/stock_1hour/2002/2002-04-11.parquet size: 414 KB rows: 19,224 symbols: 1,404
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-04-11 08:00:00 | AAPL | Stock | 0.4518 | 0.4563 | 0.4445 | 0.4496 | 7296800.0 |
| 2002-04-11 09:00:00 | AAPL | Stock | 0.4496 | 0.4509 | 0.4432 | 0.4445 | 96023200.0 |
| 2002-04-11 10:00:00 | AAPL | Stock | 0.4446 | 0.4489 | 0.4439 | 0.4473 | 62003200.0 |
| 2002-04-11 11:00:00 | AAPL | Stock | 0.4466 | 0.4491 | 0.4464 | 0.4471 | 47924800.0 |
| 2002-04-11 12:00:00 | AAPL | Stock | 0.4475 | 0.4479 | 0.442 | 0.4461 | 35028000.0 |
| 2002-04-11 13:00:00 | AAPL | Stock | 0.4459 | 0.4486 | 0.4441 | 0.4477 | 35033600.0 |
| 2002-04-11 14:00:00 | AAPL | Stock | 0.4477 | 0.4489 | 0.4455 | 0.447 | 47252800.0 |
| 2002-04-11 15:00:00 | AAPL | Stock | 0.4468 | 0.4482 | 0.4439 | 0.4446 | 48798400.0 |
| 2002-04-11 16:00:00 | AAPL | Stock | 0.4448 | 0.447 | 0.4439 | 0.4439 | 6692000.0 |
| 2002-04-11 17:00:00 | AAPL | Stock | 0.4464 | 0.4493 | 0.444 | 0.444 | 168000.0 |
| 2002-04-11 18:00:00 | AAPL | Stock | 0.4482 | 0.4482 | 0.4482 | 0.4482 | 11200.0 |
| 2002-04-11 08:00:00 | MSFT | Stock | 28.155 | 28.155 | 28.0 | 28.005 | 63400.0 |
| 2002-04-11 09:00:00 | MSFT | Stock | 28.005 | 28.225 | 27.575 | 27.905 | 6014200.0 |
| 2002-04-11 10:00:00 | MSFT | Stock | 27.91 | 28.11 | 27.72 | 27.805 | 7929400.0 |
| 2002-04-11 11:00:00 | MSFT | Stock | 27.805 | 28.015 | 27.7755 | 27.925 | 4565400.0 |
| 2002-04-11 12:00:00 | MSFT | Stock | 27.9255 | 27.96 | 27.5 | 27.65 | 6971200.0 |
| 2002-04-11 13:00:00 | MSFT | Stock | 27.66 | 27.68 | 27.48 | 27.621 | 7135400.0 |
| 2002-04-11 14:00:00 | MSFT | Stock | 27.62 | 27.6765 | 27.4405 | 27.55 | 7772800.0 |
| 2002-04-11 15:00:00 | MSFT | Stock | 27.55 | 27.56 | 27.265 | 27.395 | 12067600.0 |
| 2002-04-11 16:00:00 | MSFT | Stock | 27.39 | 27.945 | 27.35 | 27.43 | 2855200.0 |
| 2002-04-11 17:00:00 | MSFT | Stock | 27.43 | 27.9492 | 27.3978 | 27.3978 | 158800.0 |
| 2002-04-11 18:00:00 | MSFT | Stock | 27.675 | 27.745 | 27.675 | 27.695 | 5200.0 |
| 2002-04-11 08:00:00 | NVDA | Stock | 0.3218 | 0.3221 | 0.3167 | 0.3183 | 1512000.0 |
| 2002-04-11 09:00:00 | NVDA | Stock | 0.3208 | 0.3225 | 0.3154 | 0.3167 | 229056000.0 |
| 2002-04-11 10:00:00 | NVDA | Stock | 0.3167 | 0.3207 | 0.3087 | 0.3088 | 282540000.0 |
| 2002-04-11 11:00:00 | NVDA | Stock | 0.3087 | 0.3133 | 0.3067 | 0.311 | 181812000.0 |
| 2002-04-11 12:00:00 | NVDA | Stock | 0.311 | 0.3113 | 0.305 | 0.3079 | 135732000.0 |
| 2002-04-11 13:00:00 | NVDA | Stock | 0.3079 | 0.3137 | 0.3034 | 0.3121 | 144312000.0 |
| 2002-04-11 14:00:00 | NVDA | Stock | 0.3121 | 0.3155 | 0.3074 | 0.3097 | 138372000.0 |
| 2002-04-11 15:00:00 | NVDA | Stock | 0.3095 | 0.311 | 0.3042 | 0.3069 | 196668000.0 |
| 2002-04-11 16:00:00 | NVDA | Stock | 0.3069 | 0.3188 | 0.3036 | 0.3073 | 35616000.0 |
| 2002-04-11 17:00:00 | NVDA | Stock | 0.3073 | 0.3121 | 0.3069 | 0.3092 | 3372000.0 |
| 2002-04-11 18:00:00 | NVDA | Stock | 0.3092 | 0.3104 | 0.3092 | 0.3096 | 156000.0 |
| 2002-04-11 08:00:00 | AMZN | Stock | 0.663 | 0.663 | 0.655 | 0.6555 | 110000.0 |
| 2002-04-11 09:00:00 | AMZN | Stock | 0.6555 | 0.666 | 0.6515 | 0.6525 | 12006000.0 |
| 2002-04-11 10:00:00 | AMZN | Stock | 0.6525 | 0.66 | 0.6515 | 0.6525 | 14854000.0 |
| 2002-04-11 11:00:00 | AMZN | Stock | 0.653 | 0.656 | 0.6505 | 0.652 | 8098000.0 |
| 2002-04-11 12:00:00 | AMZN | Stock | 0.6515 | 0.652 | 0.6305 | 0.642 | 20124000.0 |
| 2002-04-11 13:00:00 | AMZN | Stock | 0.642 | 0.647 | 0.632 | 0.6455 | 13382000.0 |
| 2002-04-11 14:00:00 | AMZN | Stock | 0.6455 | 0.6505 | 0.639 | 0.6395 | 12912000.0 |
| 2002-04-11 15:00:00 | AMZN | Stock | 0.6395 | 0.6405 | 0.626 | 0.6375 | 29992000.0 |
| 2002-04-11 16:00:00 | AMZN | Stock | 0.6375 | 0.6495 | 0.637 | 0.6375 | 2716000.0 |
| 2002-04-11 17:00:00 | AMZN | Stock | 0.6375 | 0.65 | 0.637 | 0.637 | 282000.0 |
| 2002-04-11 18:00:00 | AMZN | Stock | 0.65 | 0.65 | 0.65 | 0.65 | 10000.0 |
| 2002-04-11 09:00:00 | CL | Stock | 29.08 | 29.19 | 29.045 | 29.045 | 341400.0 |
| 2002-04-11 10:00:00 | CL | Stock | 29.045 | 29.1 | 28.75 | 28.755 | 612400.0 |
| 2002-04-11 11:00:00 | CL | Stock | 28.77 | 28.835 | 28.705 | 28.77 | 543200.0 |
| 2002-04-11 12:00:00 | CL | Stock | 28.77 | 28.915 | 28.765 | 28.82 | 538400.0 |
| 2002-04-11 13:00:00 | CL | Stock | 28.79 | 28.825 | 28.705 | 28.75 | 358000.0 |
| 2002-04-11 14:00:00 | CL | Stock | 28.75 | 28.825 | 28.67 | 28.815 | 368000.0 |
> showing 50 of 19,224 rows — these rows as CSV