PREVIEW / stock_1hour / 2000-03-03
file: by_date/stock_1hour/2000/2000-03-03.parquet size: 286 KB rows: 14,584 symbols: 1,141
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 |
|---|---|---|---|---|---|---|---|
| 2000-03-03 09:00:00 | AAPL | Stock | 1.115 | 1.1155 | 1.0826 | 1.0876 | 31718400.0 |
| 2000-03-03 10:00:00 | AAPL | Stock | 1.0859 | 1.1038 | 1.0714 | 1.1021 | 56089600.0 |
| 2000-03-03 11:00:00 | AAPL | Stock | 1.1016 | 1.125 | 1.0993 | 1.1155 | 62540800.0 |
| 2000-03-03 12:00:00 | AAPL | Stock | 1.1158 | 1.1183 | 1.1049 | 1.1071 | 16587200.0 |
| 2000-03-03 13:00:00 | AAPL | Stock | 1.111 | 1.1183 | 1.1055 | 1.1183 | 15243200.0 |
| 2000-03-03 14:00:00 | AAPL | Stock | 1.1189 | 1.1317 | 1.1189 | 1.1283 | 40062400.0 |
| 2000-03-03 15:00:00 | AAPL | Stock | 1.1283 | 1.1448 | 1.1278 | 1.1429 | 70134400.0 |
| 2000-03-03 16:00:00 | AAPL | Stock | 1.1426 | 1.1426 | 1.1426 | 1.1426 | 44800.0 |
| 2000-03-03 09:00:00 | MSFT | Stock | 47.375 | 47.4062 | 46.9375 | 47.1875 | 10431000.0 |
| 2000-03-03 10:00:00 | MSFT | Stock | 47.125 | 49.0 | 47.0312 | 48.9688 | 17529400.0 |
| 2000-03-03 11:00:00 | MSFT | Stock | 48.9688 | 49.4375 | 48.6875 | 49.1562 | 11486600.0 |
| 2000-03-03 12:00:00 | MSFT | Stock | 49.1875 | 49.25 | 48.3125 | 48.4688 | 12576400.0 |
| 2000-03-03 13:00:00 | MSFT | Stock | 48.4688 | 48.9688 | 48.1875 | 48.5938 | 8016000.0 |
| 2000-03-03 14:00:00 | MSFT | Stock | 48.5625 | 48.9688 | 48.25 | 48.4375 | 9374000.0 |
| 2000-03-03 15:00:00 | MSFT | Stock | 48.4375 | 49.25 | 47.2812 | 48.0625 | 24573200.0 |
| 2000-03-03 16:00:00 | MSFT | Stock | 48.0625 | 48.0625 | 48.0312 | 48.0625 | 78400.0 |
| 2000-03-03 09:00:00 | NVDA | Stock | 0.1208 | 0.124 | 0.1208 | 0.1219 | 29136000.0 |
| 2000-03-03 10:00:00 | NVDA | Stock | 0.1233 | 0.1233 | 0.1216 | 0.1229 | 35568000.0 |
| 2000-03-03 11:00:00 | NVDA | Stock | 0.1229 | 0.1234 | 0.1219 | 0.1224 | 66384000.0 |
| 2000-03-03 12:00:00 | NVDA | Stock | 0.1229 | 0.1233 | 0.1198 | 0.1199 | 54528000.0 |
| 2000-03-03 13:00:00 | NVDA | Stock | 0.1199 | 0.1214 | 0.1199 | 0.1214 | 14976000.0 |
| 2000-03-03 14:00:00 | NVDA | Stock | 0.1214 | 0.1219 | 0.1206 | 0.1219 | 35376000.0 |
| 2000-03-03 15:00:00 | NVDA | Stock | 0.1219 | 0.1228 | 0.1208 | 0.1227 | 27792000.0 |
| 2000-03-03 09:00:00 | AMZN | Stock | 3.1625 | 3.2375 | 3.1562 | 3.1719 | 14666000.0 |
| 2000-03-03 10:00:00 | AMZN | Stock | 3.175 | 3.1875 | 3.1031 | 3.1625 | 25340000.0 |
| 2000-03-03 11:00:00 | AMZN | Stock | 3.1594 | 3.1938 | 3.15 | 3.1688 | 9136000.0 |
| 2000-03-03 12:00:00 | AMZN | Stock | 3.1656 | 3.225 | 3.1594 | 3.1906 | 15004000.0 |
| 2000-03-03 13:00:00 | AMZN | Stock | 3.1906 | 3.2 | 3.1625 | 3.1859 | 7676000.0 |
| 2000-03-03 14:00:00 | AMZN | Stock | 3.1844 | 3.1906 | 3.1375 | 3.1531 | 9300000.0 |
| 2000-03-03 15:00:00 | AMZN | Stock | 3.1531 | 3.1625 | 3.125 | 3.125 | 31602000.0 |
| 2000-03-03 16:00:00 | AMZN | Stock | 3.125 | 3.1312 | 3.125 | 3.125 | 166000.0 |
| 2000-03-03 09:00:00 | CL | Stock | 26.3125 | 26.6562 | 26.2812 | 26.3125 | 291400.0 |
| 2000-03-03 10:00:00 | CL | Stock | 26.3438 | 26.625 | 26.2812 | 26.3438 | 374600.0 |
| 2000-03-03 11:00:00 | CL | Stock | 26.3438 | 26.9062 | 26.3125 | 26.7812 | 407800.0 |
| 2000-03-03 12:00:00 | CL | Stock | 26.8125 | 27.5625 | 26.75 | 27.2812 | 480000.0 |
| 2000-03-03 13:00:00 | CL | Stock | 27.3438 | 27.5 | 27.3125 | 27.3438 | 348800.0 |
| 2000-03-03 14:00:00 | CL | Stock | 27.375 | 27.4375 | 27.0625 | 27.0625 | 236000.0 |
| 2000-03-03 15:00:00 | CL | Stock | 27.0938 | 27.0938 | 26.8438 | 26.9375 | 593600.0 |
| 2000-03-03 16:00:00 | CL | Stock | 26.9688 | 27.4375 | 26.9375 | 27.4375 | 113000.0 |
> showing 39 of 14,584 rows — these rows as CSV