PREVIEW / stock_1hour / 2001-06-05
file: by_date/stock_1hour/2001/2001-06-05.parquet size: 363 KB rows: 17,446 symbols: 1,314
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 |
|---|---|---|---|---|---|---|---|
| 2001-06-05 08:00:00 | AAPL | Stock | 0.3705 | 0.3705 | 0.3705 | 0.3705 | 28000.0 |
| 2001-06-05 09:00:00 | AAPL | Stock | 0.3713 | 0.3732 | 0.3695 | 0.3705 | 14520800.0 |
| 2001-06-05 10:00:00 | AAPL | Stock | 0.37 | 0.3768 | 0.3634 | 0.375 | 111406400.0 |
| 2001-06-05 11:00:00 | AAPL | Stock | 0.375 | 0.375 | 0.3677 | 0.3705 | 47852000.0 |
| 2001-06-05 12:00:00 | AAPL | Stock | 0.3714 | 0.3714 | 0.3661 | 0.3688 | 44637600.0 |
| 2001-06-05 13:00:00 | AAPL | Stock | 0.3695 | 0.3707 | 0.3654 | 0.3675 | 72990400.0 |
| 2001-06-05 14:00:00 | AAPL | Stock | 0.3677 | 0.3723 | 0.3677 | 0.3723 | 33605600.0 |
| 2001-06-05 15:00:00 | AAPL | Stock | 0.3723 | 0.3768 | 0.3714 | 0.3739 | 99691200.0 |
| 2001-06-05 16:00:00 | AAPL | Stock | 0.3739 | 0.375 | 0.3705 | 0.3741 | 20305600.0 |
| 2001-06-05 17:00:00 | AAPL | Stock | 0.3739 | 0.3739 | 0.3729 | 0.3729 | 571200.0 |
| 2001-06-05 08:00:00 | MSFT | Stock | 35.515 | 35.625 | 35.45 | 35.45 | 104800.0 |
| 2001-06-05 09:00:00 | MSFT | Stock | 35.5 | 35.95 | 35.25 | 35.875 | 9715600.0 |
| 2001-06-05 10:00:00 | MSFT | Stock | 35.875 | 36.35 | 35.8 | 36.125 | 22431600.0 |
| 2001-06-05 11:00:00 | MSFT | Stock | 36.125 | 36.205 | 35.975 | 36.145 | 10224400.0 |
| 2001-06-05 12:00:00 | MSFT | Stock | 36.15 | 36.245 | 36.08 | 36.155 | 5039800.0 |
| 2001-06-05 13:00:00 | MSFT | Stock | 36.165 | 36.25 | 36.085 | 36.225 | 5090000.0 |
| 2001-06-05 14:00:00 | MSFT | Stock | 36.24 | 36.375 | 36.2 | 36.375 | 10110000.0 |
| 2001-06-05 15:00:00 | MSFT | Stock | 36.37 | 36.54 | 36.265 | 36.295 | 21610400.0 |
| 2001-06-05 16:00:00 | MSFT | Stock | 36.3 | 36.445 | 36.16 | 36.3 | 1516600.0 |
| 2001-06-05 17:00:00 | MSFT | Stock | 36.3 | 36.35 | 36.08 | 36.32 | 156400.0 |
| 2001-06-05 18:00:00 | MSFT | Stock | 36.31 | 36.31 | 36.31 | 36.31 | 2000.0 |
| 2001-06-05 08:00:00 | NVDA | Stock | 0.375 | 0.375 | 0.3717 | 0.3717 | 240000.0 |
| 2001-06-05 09:00:00 | NVDA | Stock | 0.3688 | 0.3801 | 0.3688 | 0.3795 | 77352000.0 |
| 2001-06-05 10:00:00 | NVDA | Stock | 0.3795 | 0.3879 | 0.3778 | 0.3863 | 216480000.0 |
| 2001-06-05 11:00:00 | NVDA | Stock | 0.3863 | 0.3902 | 0.3841 | 0.3858 | 186744000.0 |
| 2001-06-05 12:00:00 | NVDA | Stock | 0.386 | 0.3927 | 0.3854 | 0.3895 | 91608000.0 |
| 2001-06-05 13:00:00 | NVDA | Stock | 0.3894 | 0.394 | 0.389 | 0.3908 | 79728000.0 |
| 2001-06-05 14:00:00 | NVDA | Stock | 0.3908 | 0.392 | 0.3866 | 0.3917 | 129048000.0 |
| 2001-06-05 15:00:00 | NVDA | Stock | 0.3917 | 0.392 | 0.3888 | 0.3901 | 144408000.0 |
| 2001-06-05 16:00:00 | NVDA | Stock | 0.3901 | 0.3908 | 0.3888 | 0.3904 | 20736000.0 |
| 2001-06-05 17:00:00 | NVDA | Stock | 0.3904 | 0.3917 | 0.3901 | 0.3917 | 960000.0 |
| 2001-06-05 18:00:00 | NVDA | Stock | 0.391 | 0.3913 | 0.391 | 0.3913 | 72000.0 |
| 2001-06-05 08:00:00 | AMZN | Stock | 0.85 | 0.86 | 0.85 | 0.86 | 12000.0 |
| 2001-06-05 09:00:00 | AMZN | Stock | 0.8485 | 0.855 | 0.836 | 0.843 | 11956000.0 |
| 2001-06-05 10:00:00 | AMZN | Stock | 0.8425 | 0.8455 | 0.8235 | 0.8275 | 16066000.0 |
| 2001-06-05 11:00:00 | AMZN | Stock | 0.8275 | 0.875 | 0.8075 | 0.8175 | 95452000.0 |
| 2001-06-05 12:00:00 | AMZN | Stock | 0.818 | 0.8345 | 0.815 | 0.8245 | 44664000.0 |
| 2001-06-05 13:00:00 | AMZN | Stock | 0.8265 | 0.83 | 0.8135 | 0.815 | 25436000.0 |
| 2001-06-05 14:00:00 | AMZN | Stock | 0.814 | 0.83 | 0.8095 | 0.827 | 22586000.0 |
| 2001-06-05 15:00:00 | AMZN | Stock | 0.8275 | 0.8405 | 0.815 | 0.8215 | 23070000.0 |
| 2001-06-05 16:00:00 | AMZN | Stock | 0.8215 | 0.8625 | 0.815 | 0.822 | 2546000.0 |
| 2001-06-05 17:00:00 | AMZN | Stock | 0.8225 | 0.833 | 0.822 | 0.8275 | 580000.0 |
| 2001-06-05 18:00:00 | AMZN | Stock | 0.825 | 0.835 | 0.8245 | 0.8345 | 116000.0 |
| 2001-06-05 09:00:00 | CL | Stock | 28.825 | 28.875 | 28.675 | 28.8 | 395200.0 |
| 2001-06-05 10:00:00 | CL | Stock | 28.78 | 28.975 | 28.62 | 28.78 | 384600.0 |
| 2001-06-05 11:00:00 | CL | Stock | 28.8 | 29.075 | 28.77 | 29.0 | 223400.0 |
| 2001-06-05 12:00:00 | CL | Stock | 29.0 | 29.2 | 28.975 | 29.025 | 344600.0 |
| 2001-06-05 13:00:00 | CL | Stock | 29.04 | 29.05 | 28.9 | 28.925 | 213800.0 |
| 2001-06-05 14:00:00 | CL | Stock | 28.94 | 29.07 | 28.905 | 29.02 | 176000.0 |
| 2001-06-05 15:00:00 | CL | Stock | 29.02 | 29.15 | 28.97 | 29.075 | 309000.0 |
> showing 50 of 17,446 rows — these rows as CSV