PREVIEW / stock_1hour / 2002-06-05
file: by_date/stock_1hour/2002/2002-06-05.parquet size: 408 KB rows: 18,938 symbols: 1,431
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-06-05 08:00:00 | AAPL | Stock | 0.4063 | 0.4063 | 0.4063 | 0.4063 | 33600.0 |
| 2002-06-05 09:00:00 | AAPL | Stock | 0.4068 | 0.4088 | 0.4018 | 0.4054 | 20456800.0 |
| 2002-06-05 10:00:00 | AAPL | Stock | 0.4054 | 0.407 | 0.402 | 0.4027 | 37816800.0 |
| 2002-06-05 11:00:00 | AAPL | Stock | 0.4027 | 0.4045 | 0.3991 | 0.402 | 24550400.0 |
| 2002-06-05 12:00:00 | AAPL | Stock | 0.402 | 0.4061 | 0.4007 | 0.402 | 25827200.0 |
| 2002-06-05 13:00:00 | AAPL | Stock | 0.402 | 0.405 | 0.4004 | 0.4041 | 18211200.0 |
| 2002-06-05 14:00:00 | AAPL | Stock | 0.4038 | 0.4052 | 0.4009 | 0.4036 | 22702400.0 |
| 2002-06-05 15:00:00 | AAPL | Stock | 0.4036 | 0.4064 | 0.402 | 0.4059 | 93139200.0 |
| 2002-06-05 16:00:00 | AAPL | Stock | 0.4061 | 0.4068 | 0.4029 | 0.4068 | 14912800.0 |
| 2002-06-05 17:00:00 | AAPL | Stock | 0.4057 | 0.4057 | 0.4057 | 0.4057 | 1988000.0 |
| 2002-06-05 08:00:00 | MSFT | Stock | 25.125 | 25.25 | 24.962 | 25.0775 | 1064400.0 |
| 2002-06-05 09:00:00 | MSFT | Stock | 25.1025 | 25.55 | 25.075 | 25.415 | 9880400.0 |
| 2002-06-05 10:00:00 | MSFT | Stock | 25.415 | 25.6905 | 25.345 | 25.35 | 12383800.0 |
| 2002-06-05 11:00:00 | MSFT | Stock | 25.35 | 25.485 | 25.25 | 25.32 | 6141400.0 |
| 2002-06-05 12:00:00 | MSFT | Stock | 25.3155 | 25.43 | 25.185 | 25.405 | 5581600.0 |
| 2002-06-05 13:00:00 | MSFT | Stock | 25.41 | 25.565 | 25.34 | 25.42 | 4996600.0 |
| 2002-06-05 14:00:00 | MSFT | Stock | 25.4195 | 25.501 | 25.3155 | 25.45 | 6245600.0 |
| 2002-06-05 15:00:00 | MSFT | Stock | 25.45 | 25.865 | 25.4 | 25.825 | 14269800.0 |
| 2002-06-05 16:00:00 | MSFT | Stock | 25.83 | 25.895 | 25.449 | 25.895 | 1793200.0 |
| 2002-06-05 17:00:00 | MSFT | Stock | 25.875 | 25.95 | 25.83 | 25.95 | 338600.0 |
| 2002-06-05 08:00:00 | NVDA | Stock | 0.2763 | 0.2807 | 0.2662 | 0.275 | 1248000.0 |
| 2002-06-05 09:00:00 | NVDA | Stock | 0.2758 | 0.2763 | 0.2682 | 0.2732 | 160908000.0 |
| 2002-06-05 10:00:00 | NVDA | Stock | 0.2731 | 0.2762 | 0.2638 | 0.2652 | 277596000.0 |
| 2002-06-05 11:00:00 | NVDA | Stock | 0.2652 | 0.2667 | 0.2621 | 0.2638 | 108672000.0 |
| 2002-06-05 12:00:00 | NVDA | Stock | 0.2639 | 0.2673 | 0.2628 | 0.2666 | 102012000.0 |
| 2002-06-05 13:00:00 | NVDA | Stock | 0.2664 | 0.2707 | 0.2656 | 0.2683 | 157128000.0 |
| 2002-06-05 14:00:00 | NVDA | Stock | 0.2681 | 0.2708 | 0.2676 | 0.2702 | 84924000.0 |
| 2002-06-05 15:00:00 | NVDA | Stock | 0.2702 | 0.2741 | 0.2693 | 0.2716 | 138096000.0 |
| 2002-06-05 16:00:00 | NVDA | Stock | 0.2717 | 0.2737 | 0.268 | 0.2732 | 22236000.0 |
| 2002-06-05 17:00:00 | NVDA | Stock | 0.2735 | 0.2736 | 0.2717 | 0.273 | 3264000.0 |
| 2002-06-05 18:00:00 | NVDA | Stock | 0.2727 | 0.2727 | 0.2727 | 0.2727 | 576000.0 |
| 2002-06-05 08:00:00 | AMZN | Stock | 0.8816 | 0.9015 | 0.8815 | 0.8975 | 116000.0 |
| 2002-06-05 09:00:00 | AMZN | Stock | 0.8975 | 0.909 | 0.8935 | 0.9 | 14950000.0 |
| 2002-06-05 10:00:00 | AMZN | Stock | 0.8995 | 0.908 | 0.896 | 0.8965 | 12740000.0 |
| 2002-06-05 11:00:00 | AMZN | Stock | 0.8975 | 0.9 | 0.886 | 0.89 | 9474000.0 |
| 2002-06-05 12:00:00 | AMZN | Stock | 0.89 | 0.8925 | 0.8825 | 0.8875 | 6004000.0 |
| 2002-06-05 13:00:00 | AMZN | Stock | 0.8875 | 0.8885 | 0.8725 | 0.885 | 12414000.0 |
| 2002-06-05 14:00:00 | AMZN | Stock | 0.886 | 0.894 | 0.884 | 0.8926 | 10554000.0 |
| 2002-06-05 15:00:00 | AMZN | Stock | 0.893 | 0.9075 | 0.887 | 0.899 | 13116000.0 |
| 2002-06-05 16:00:00 | AMZN | Stock | 0.8995 | 0.904 | 0.8872 | 0.8975 | 1270000.0 |
| 2002-06-05 17:00:00 | AMZN | Stock | 0.8995 | 0.9 | 0.8995 | 0.9 | 426000.0 |
| 2002-06-05 18:00:00 | AMZN | Stock | 0.8985 | 0.8985 | 0.8985 | 0.8985 | 18000.0 |
| 2002-06-05 09:00:00 | CL | Stock | 26.875 | 27.14 | 26.75 | 27.12 | 326000.0 |
| 2002-06-05 10:00:00 | CL | Stock | 27.14 | 27.29 | 27.14 | 27.27 | 623800.0 |
| 2002-06-05 11:00:00 | CL | Stock | 27.265 | 27.27 | 27.05 | 27.15 | 591200.0 |
| 2002-06-05 12:00:00 | CL | Stock | 27.14 | 27.625 | 27.14 | 27.53 | 779600.0 |
| 2002-06-05 13:00:00 | CL | Stock | 27.525 | 27.7 | 27.505 | 27.66 | 596200.0 |
| 2002-06-05 14:00:00 | CL | Stock | 27.66 | 27.88 | 27.66 | 27.77 | 1241400.0 |
| 2002-06-05 15:00:00 | CL | Stock | 27.765 | 27.85 | 27.66 | 27.79 | 1515200.0 |
| 2002-06-05 16:00:00 | CL | Stock | 27.79 | 27.805 | 27.535 | 27.545 | 173200.0 |
> showing 50 of 18,938 rows — these rows as CSV