PREVIEW / stock_1hour / 2004-01-07
file: by_date/stock_1hour/2004/2004-01-07.parquet size: 505 KB rows: 23,258 symbols: 1,717
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 |
|---|---|---|---|---|---|---|---|
| 2004-01-07 08:00:00 | AAPL | Stock | 0.3938 | 0.3945 | 0.3893 | 0.3939 | 4281200.0 |
| 2004-01-07 09:00:00 | AAPL | Stock | 0.3934 | 0.3973 | 0.393 | 0.3948 | 65924880.0 |
| 2004-01-07 10:00:00 | AAPL | Stock | 0.3948 | 0.3954 | 0.3916 | 0.3934 | 97542144.0 |
| 2004-01-07 11:00:00 | AAPL | Stock | 0.3936 | 0.3971 | 0.3925 | 0.3964 | 48832000.0 |
| 2004-01-07 12:00:00 | AAPL | Stock | 0.3964 | 0.4077 | 0.3964 | 0.4065 | 156213400.0 |
| 2004-01-07 13:00:00 | AAPL | Stock | 0.4064 | 0.4071 | 0.4027 | 0.4043 | 58856672.0 |
| 2004-01-07 14:00:00 | AAPL | Stock | 0.4043 | 0.4048 | 0.4013 | 0.4046 | 42102984.0 |
| 2004-01-07 15:00:00 | AAPL | Stock | 0.4046 | 0.4052 | 0.402 | 0.4027 | 48713448.0 |
| 2004-01-07 16:00:00 | AAPL | Stock | 0.4034 | 0.4041 | 0.4025 | 0.4027 | 4972632.0 |
| 2004-01-07 17:00:00 | AAPL | Stock | 0.4034 | 0.4036 | 0.403 | 0.4036 | 520800.0 |
| 2004-01-07 18:00:00 | AAPL | Stock | 0.4038 | 0.4038 | 0.4038 | 0.4038 | 89600.0 |
| 2004-01-07 08:00:00 | MSFT | Stock | 28.23 | 28.29 | 27.5 | 28.16 | 29020.0 |
| 2004-01-07 09:00:00 | MSFT | Stock | 28.16 | 28.22 | 28.13 | 28.13 | 4905246.0 |
| 2004-01-07 10:00:00 | MSFT | Stock | 28.13 | 28.14 | 28.01 | 28.07 | 6809615.0 |
| 2004-01-07 11:00:00 | MSFT | Stock | 28.07 | 28.21 | 28.06 | 28.16 | 10635020.0 |
| 2004-01-07 12:00:00 | MSFT | Stock | 28.159 | 28.26 | 28.13 | 28.13 | 5437761.0 |
| 2004-01-07 13:00:00 | MSFT | Stock | 28.14 | 28.21 | 28.1 | 28.12 | 4412945.0 |
| 2004-01-07 14:00:00 | MSFT | Stock | 28.12 | 28.15 | 28.02 | 28.13 | 6741021.0 |
| 2004-01-07 15:00:00 | MSFT | Stock | 28.13 | 28.25 | 28.08 | 28.22 | 7982561.0 |
| 2004-01-07 16:00:00 | MSFT | Stock | 28.22 | 28.49 | 28.2 | 28.25 | 5068482.0 |
| 2004-01-07 17:00:00 | MSFT | Stock | 28.24 | 28.29 | 28.23 | 28.28 | 83007.0 |
| 2004-01-07 18:00:00 | MSFT | Stock | 28.29 | 28.32 | 28.29 | 28.32 | 25608.0 |
| 2004-01-07 08:00:00 | NVDA | Stock | 0.2067 | 0.2068 | 0.2063 | 0.2067 | 732000.0 |
| 2004-01-07 09:00:00 | NVDA | Stock | 0.2073 | 0.2077 | 0.2029 | 0.2042 | 122948640.0 |
| 2004-01-07 10:00:00 | NVDA | Stock | 0.2042 | 0.2072 | 0.2035 | 0.2057 | 122741520.0 |
| 2004-01-07 11:00:00 | NVDA | Stock | 0.2057 | 0.2095 | 0.2046 | 0.2076 | 114871800.0 |
| 2004-01-07 12:00:00 | NVDA | Stock | 0.2076 | 0.2094 | 0.2075 | 0.2079 | 87713880.0 |
| 2004-01-07 13:00:00 | NVDA | Stock | 0.2076 | 0.2085 | 0.2073 | 0.2077 | 40778400.0 |
| 2004-01-07 14:00:00 | NVDA | Stock | 0.2077 | 0.2087 | 0.2071 | 0.2086 | 63251760.0 |
| 2004-01-07 15:00:00 | NVDA | Stock | 0.2087 | 0.2095 | 0.2082 | 0.2088 | 103434720.0 |
| 2004-01-07 16:00:00 | NVDA | Stock | 0.2088 | 0.2094 | 0.2082 | 0.2087 | 4053360.0 |
| 2004-01-07 17:00:00 | NVDA | Stock | 0.2088 | 0.2107 | 0.2088 | 0.2107 | 1146000.0 |
| 2004-01-07 18:00:00 | NVDA | Stock | 0.21 | 0.2104 | 0.21 | 0.2104 | 228000.0 |
| 2004-01-07 08:00:00 | AMZN | Stock | 2.6455 | 2.6484 | 2.6375 | 2.6484 | 110900.0 |
| 2004-01-07 09:00:00 | AMZN | Stock | 2.6475 | 2.6475 | 2.568 | 2.5732 | 31704900.0 |
| 2004-01-07 10:00:00 | AMZN | Stock | 2.5735 | 2.5875 | 2.547 | 2.573 | 58488620.0 |
| 2004-01-07 11:00:00 | AMZN | Stock | 2.5731 | 2.5845 | 2.561 | 2.579 | 14670800.0 |
| 2004-01-07 12:00:00 | AMZN | Stock | 2.577 | 2.602 | 2.5765 | 2.5956 | 23365680.0 |
| 2004-01-07 13:00:00 | AMZN | Stock | 2.595 | 2.607 | 2.5815 | 2.5855 | 17304120.0 |
| 2004-01-07 14:00:00 | AMZN | Stock | 2.5854 | 2.597 | 2.5845 | 2.5945 | 11437480.0 |
| 2004-01-07 15:00:00 | AMZN | Stock | 2.5945 | 2.5965 | 2.586 | 2.592 | 22470260.0 |
| 2004-01-07 16:00:00 | AMZN | Stock | 2.594 | 2.5955 | 2.585 | 2.5914 | 1180960.0 |
| 2004-01-07 17:00:00 | AMZN | Stock | 2.5875 | 2.595 | 2.5875 | 2.591 | 235900.0 |
| 2004-01-07 18:00:00 | AMZN | Stock | 2.591 | 2.592 | 2.59 | 2.592 | 56000.0 |
| 2004-01-07 09:00:00 | CL | Stock | 25.25 | 25.34 | 25.24 | 25.26 | 1120400.0 |
| 2004-01-07 10:00:00 | CL | Stock | 25.26 | 25.32 | 25.21 | 25.32 | 1422400.0 |
| 2004-01-07 11:00:00 | CL | Stock | 25.315 | 25.385 | 25.275 | 25.335 | 1377600.0 |
| 2004-01-07 12:00:00 | CL | Stock | 25.33 | 25.355 | 25.255 | 25.295 | 576600.0 |
| 2004-01-07 13:00:00 | CL | Stock | 25.285 | 25.325 | 25.24 | 25.295 | 1069200.0 |
| 2004-01-07 14:00:00 | CL | Stock | 25.295 | 25.325 | 25.265 | 25.32 | 857800.0 |
> showing 50 of 23,258 rows — these rows as CSV