PREVIEW / stock_1hour / 2002-02-21
file: by_date/stock_1hour/2002/2002-02-21.parquet size: 391 KB rows: 19,002 symbols: 1,393
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-02-21 08:00:00 | AAPL | Stock | 0.4132 | 0.4143 | 0.4116 | 0.4116 | 3287200.0 |
| 2002-02-21 09:00:00 | AAPL | Stock | 0.4116 | 0.4116 | 0.4027 | 0.405 | 32580800.0 |
| 2002-02-21 10:00:00 | AAPL | Stock | 0.405 | 0.408 | 0.3898 | 0.3936 | 72066400.0 |
| 2002-02-21 11:00:00 | AAPL | Stock | 0.3936 | 0.4034 | 0.3929 | 0.4029 | 37256800.0 |
| 2002-02-21 12:00:00 | AAPL | Stock | 0.4032 | 0.4055 | 0.3982 | 0.4023 | 34221600.0 |
| 2002-02-21 13:00:00 | AAPL | Stock | 0.4025 | 0.4077 | 0.3955 | 0.3964 | 54465600.0 |
| 2002-02-21 14:00:00 | AAPL | Stock | 0.3964 | 0.3982 | 0.3925 | 0.3934 | 54583200.0 |
| 2002-02-21 15:00:00 | AAPL | Stock | 0.3934 | 0.3936 | 0.383 | 0.383 | 118524000.0 |
| 2002-02-21 16:00:00 | AAPL | Stock | 0.3841 | 0.4196 | 0.383 | 0.3839 | 23279200.0 |
| 2002-02-21 17:00:00 | AAPL | Stock | 0.3839 | 0.3982 | 0.3839 | 0.3839 | 1691200.0 |
| 2002-02-21 18:00:00 | AAPL | Stock | 0.3839 | 0.3839 | 0.3839 | 0.3839 | 100800.0 |
| 2002-02-21 08:00:00 | MSFT | Stock | 29.8 | 30.06 | 29.745 | 29.87 | 114400.0 |
| 2002-02-21 09:00:00 | MSFT | Stock | 29.865 | 30.135 | 29.705 | 29.8105 | 7205000.0 |
| 2002-02-21 10:00:00 | MSFT | Stock | 29.8245 | 29.98 | 29.52 | 29.61 | 9688200.0 |
| 2002-02-21 11:00:00 | MSFT | Stock | 29.61 | 29.76 | 29.4 | 29.585 | 5824200.0 |
| 2002-02-21 12:00:00 | MSFT | Stock | 29.59 | 29.9 | 29.57 | 29.835 | 7101400.0 |
| 2002-02-21 13:00:00 | MSFT | Stock | 29.835 | 29.93 | 29.63 | 29.64 | 5842800.0 |
| 2002-02-21 14:00:00 | MSFT | Stock | 29.64 | 29.69 | 29.435 | 29.44 | 4920200.0 |
| 2002-02-21 15:00:00 | MSFT | Stock | 29.44 | 29.475 | 29.005 | 29.03 | 13410000.0 |
| 2002-02-21 16:00:00 | MSFT | Stock | 29.03 | 29.7851 | 29.0 | 29.025 | 2951200.0 |
| 2002-02-21 17:00:00 | MSFT | Stock | 29.025 | 29.6091 | 29.01 | 29.07 | 889800.0 |
| 2002-02-21 18:00:00 | MSFT | Stock | 29.025 | 29.075 | 29.025 | 29.04 | 51000.0 |
| 2002-02-21 08:00:00 | NVDA | Stock | 0.4652 | 0.4708 | 0.4625 | 0.4641 | 3132000.0 |
| 2002-02-21 09:00:00 | NVDA | Stock | 0.4648 | 0.4697 | 0.4521 | 0.4538 | 257304000.0 |
| 2002-02-21 10:00:00 | NVDA | Stock | 0.4537 | 0.4596 | 0.4457 | 0.4489 | 249720000.0 |
| 2002-02-21 11:00:00 | NVDA | Stock | 0.4494 | 0.4562 | 0.447 | 0.453 | 169992000.0 |
| 2002-02-21 12:00:00 | NVDA | Stock | 0.4528 | 0.46 | 0.4517 | 0.4565 | 150048000.0 |
| 2002-02-21 13:00:00 | NVDA | Stock | 0.4563 | 0.4608 | 0.4472 | 0.4484 | 131412000.0 |
| 2002-02-21 14:00:00 | NVDA | Stock | 0.4483 | 0.4521 | 0.446 | 0.4472 | 132924000.0 |
| 2002-02-21 15:00:00 | NVDA | Stock | 0.4472 | 0.4479 | 0.4371 | 0.4377 | 335112000.0 |
| 2002-02-21 16:00:00 | NVDA | Stock | 0.4376 | 0.4516 | 0.4347 | 0.4357 | 64128000.0 |
| 2002-02-21 17:00:00 | NVDA | Stock | 0.4375 | 0.4376 | 0.4342 | 0.4375 | 2616000.0 |
| 2002-02-21 18:00:00 | NVDA | Stock | 0.4375 | 0.4387 | 0.4375 | 0.4387 | 924000.0 |
| 2002-02-21 08:00:00 | AMZN | Stock | 0.6475 | 0.65 | 0.6475 | 0.65 | 286000.0 |
| 2002-02-21 09:00:00 | AMZN | Stock | 0.65 | 0.6615 | 0.6445 | 0.6565 | 22336000.0 |
| 2002-02-21 10:00:00 | AMZN | Stock | 0.6565 | 0.663 | 0.652 | 0.6565 | 17274000.0 |
| 2002-02-21 11:00:00 | AMZN | Stock | 0.6565 | 0.665 | 0.6545 | 0.6585 | 13608000.0 |
| 2002-02-21 12:00:00 | AMZN | Stock | 0.66 | 0.675 | 0.657 | 0.672 | 18404000.0 |
| 2002-02-21 13:00:00 | AMZN | Stock | 0.6711 | 0.6825 | 0.6675 | 0.6685 | 28756000.0 |
| 2002-02-21 14:00:00 | AMZN | Stock | 0.6685 | 0.673 | 0.66 | 0.662 | 30782000.0 |
| 2002-02-21 15:00:00 | AMZN | Stock | 0.662 | 0.666 | 0.65 | 0.661 | 28144000.0 |
| 2002-02-21 16:00:00 | AMZN | Stock | 0.6645 | 0.6665 | 0.66 | 0.6665 | 2534000.0 |
| 2002-02-21 17:00:00 | AMZN | Stock | 0.6655 | 0.666 | 0.6635 | 0.6635 | 64000.0 |
| 2002-02-21 18:00:00 | AMZN | Stock | 0.661 | 0.661 | 0.661 | 0.661 | 6000.0 |
| 2002-02-21 09:00:00 | CL | Stock | 28.175 | 28.325 | 28.11 | 28.275 | 215400.0 |
| 2002-02-21 10:00:00 | CL | Stock | 28.295 | 28.425 | 28.175 | 28.275 | 686600.0 |
| 2002-02-21 11:00:00 | CL | Stock | 28.245 | 28.275 | 28.14 | 28.245 | 231400.0 |
| 2002-02-21 12:00:00 | CL | Stock | 28.225 | 28.31 | 28.14 | 28.19 | 212000.0 |
| 2002-02-21 13:00:00 | CL | Stock | 28.19 | 28.225 | 28.025 | 28.07 | 460800.0 |
| 2002-02-21 14:00:00 | CL | Stock | 28.065 | 28.225 | 28.05 | 28.13 | 281800.0 |
> showing 50 of 19,002 rows — these rows as CSV