PREVIEW / stock_1hour / 2004-08-30
file: by_date/stock_1hour/2004/2004-08-30.parquet size: 484 KB rows: 23,082 symbols: 1,818
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-08-30 09:00:00 | AAPL | Stock | 0.6093 | 0.62 | 0.6064 | 0.6184 | 42418376.0 |
| 2004-08-30 10:00:00 | AAPL | Stock | 0.618 | 0.6189 | 0.6082 | 0.61 | 44442664.0 |
| 2004-08-30 11:00:00 | AAPL | Stock | 0.61 | 0.6186 | 0.6089 | 0.6145 | 21184744.0 |
| 2004-08-30 12:00:00 | AAPL | Stock | 0.6145 | 0.6159 | 0.6116 | 0.6157 | 19906376.0 |
| 2004-08-30 13:00:00 | AAPL | Stock | 0.6159 | 0.6182 | 0.6145 | 0.6155 | 22386728.0 |
| 2004-08-30 14:00:00 | AAPL | Stock | 0.6155 | 0.6161 | 0.6113 | 0.6118 | 17638712.0 |
| 2004-08-30 15:00:00 | AAPL | Stock | 0.6118 | 0.6121 | 0.6084 | 0.6091 | 34325592.0 |
| 2004-08-30 16:00:00 | AAPL | Stock | 0.6091 | 0.6104 | 0.6079 | 0.6093 | 2030168.0 |
| 2004-08-30 17:00:00 | AAPL | Stock | 0.608 | 0.6093 | 0.608 | 0.6093 | 48440.0 |
| 2004-08-30 08:00:00 | MSFT | Stock | 27.28 | 27.35 | 27.28 | 27.3 | 26797.0 |
| 2004-08-30 09:00:00 | MSFT | Stock | 27.3 | 27.34 | 27.22 | 27.29 | 5559332.0 |
| 2004-08-30 10:00:00 | MSFT | Stock | 27.26 | 27.3 | 27.16 | 27.19 | 7874352.0 |
| 2004-08-30 11:00:00 | MSFT | Stock | 27.18 | 27.26 | 27.17 | 27.248 | 3750753.0 |
| 2004-08-30 12:00:00 | MSFT | Stock | 27.25 | 27.29 | 27.23 | 27.28 | 2379963.0 |
| 2004-08-30 13:00:00 | MSFT | Stock | 27.28 | 27.3 | 27.24 | 27.28 | 2408138.0 |
| 2004-08-30 14:00:00 | MSFT | Stock | 27.27 | 27.36 | 27.26 | 27.32 | 4075540.0 |
| 2004-08-30 15:00:00 | MSFT | Stock | 27.33 | 27.39 | 27.21 | 27.31 | 9077259.0 |
| 2004-08-30 16:00:00 | MSFT | Stock | 27.31 | 27.33 | 27.27 | 27.28 | 543532.0 |
| 2004-08-30 17:00:00 | MSFT | Stock | 27.28 | 27.3 | 27.27 | 27.29 | 4322.0 |
| 2004-08-30 18:00:00 | MSFT | Stock | 27.29 | 27.29 | 27.27 | 27.27 | 200.0 |
| 2004-08-30 08:00:00 | NVDA | Stock | 0.1078 | 0.1078 | 0.1064 | 0.1071 | 192000.0 |
| 2004-08-30 09:00:00 | NVDA | Stock | 0.1075 | 0.108 | 0.1067 | 0.1072 | 81690120.0 |
| 2004-08-30 10:00:00 | NVDA | Stock | 0.1072 | 0.1075 | 0.1052 | 0.1053 | 114525000.0 |
| 2004-08-30 11:00:00 | NVDA | Stock | 0.1053 | 0.1053 | 0.1042 | 0.1044 | 116522400.0 |
| 2004-08-30 12:00:00 | NVDA | Stock | 0.1045 | 0.1046 | 0.1042 | 0.1043 | 36478200.0 |
| 2004-08-30 13:00:00 | NVDA | Stock | 0.1043 | 0.1046 | 0.1042 | 0.1045 | 43801320.0 |
| 2004-08-30 14:00:00 | NVDA | Stock | 0.1045 | 0.1046 | 0.1042 | 0.1042 | 50715480.0 |
| 2004-08-30 15:00:00 | NVDA | Stock | 0.1042 | 0.1047 | 0.1042 | 0.1043 | 119147280.0 |
| 2004-08-30 16:00:00 | NVDA | Stock | 0.1043 | 0.1043 | 0.1037 | 0.1042 | 7803840.0 |
| 2004-08-30 17:00:00 | NVDA | Stock | 0.1043 | 0.1043 | 0.1043 | 0.1043 | 289680.0 |
| 2004-08-30 08:00:00 | AMZN | Stock | 1.9948 | 1.9948 | 1.9948 | 1.9948 | 1000000.0 |
| 2004-08-30 09:00:00 | AMZN | Stock | 1.987 | 1.9975 | 1.954 | 1.96 | 18048440.0 |
| 2004-08-30 10:00:00 | AMZN | Stock | 1.9605 | 1.9605 | 1.9275 | 1.9325 | 31364720.0 |
| 2004-08-30 11:00:00 | AMZN | Stock | 1.934 | 1.937 | 1.9275 | 1.931 | 17527660.0 |
| 2004-08-30 12:00:00 | AMZN | Stock | 1.931 | 1.9325 | 1.92 | 1.9325 | 11989240.0 |
| 2004-08-30 13:00:00 | AMZN | Stock | 1.9325 | 1.939 | 1.925 | 1.936 | 14561820.0 |
| 2004-08-30 14:00:00 | AMZN | Stock | 1.9365 | 1.9375 | 1.923 | 1.9235 | 14000940.0 |
| 2004-08-30 15:00:00 | AMZN | Stock | 1.923 | 1.9275 | 1.9125 | 1.914 | 32569280.0 |
| 2004-08-30 16:00:00 | AMZN | Stock | 1.9125 | 1.9155 | 1.908 | 1.9105 | 2492060.0 |
| 2004-08-30 17:00:00 | AMZN | Stock | 1.9105 | 1.9105 | 1.906 | 1.9075 | 36000.0 |
| 2004-08-30 18:00:00 | AMZN | Stock | 1.9075 | 1.91 | 1.905 | 1.91 | 95000.0 |
| 2004-08-30 09:00:00 | CL | Stock | 26.89 | 26.925 | 26.855 | 26.86 | 133800.0 |
| 2004-08-30 10:00:00 | CL | Stock | 26.865 | 27.0 | 26.865 | 27.0 | 214200.0 |
| 2004-08-30 11:00:00 | CL | Stock | 27.005 | 27.025 | 26.9 | 26.905 | 179600.0 |
| 2004-08-30 12:00:00 | CL | Stock | 26.9 | 26.95 | 26.885 | 26.94 | 118000.0 |
| 2004-08-30 13:00:00 | CL | Stock | 26.94 | 26.975 | 26.91 | 26.955 | 93200.0 |
| 2004-08-30 14:00:00 | CL | Stock | 26.955 | 26.965 | 26.88 | 26.895 | 168800.0 |
| 2004-08-30 15:00:00 | CL | Stock | 26.885 | 26.915 | 26.855 | 26.875 | 437600.0 |
| 2004-08-30 16:00:00 | CL | Stock | 26.86 | 26.86 | 26.86 | 26.86 | 29000.0 |
> showing 49 of 23,082 rows — these rows as CSV