PREVIEW / stock_1hour / 2000-02-28
file: by_date/stock_1hour/2000/2000-02-28.parquet size: 281 KB rows: 14,536 symbols: 1,138
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-02-28 09:00:00 | AAPL | Stock | 0.9833 | 0.9989 | 0.9821 | 0.99 | 44598400.0 |
| 2000-02-28 10:00:00 | AAPL | Stock | 0.9905 | 0.9916 | 0.9738 | 0.9844 | 45012800.0 |
| 2000-02-28 11:00:00 | AAPL | Stock | 0.9844 | 0.986 | 0.9676 | 0.9774 | 42100800.0 |
| 2000-02-28 12:00:00 | AAPL | Stock | 0.9777 | 0.9911 | 0.9732 | 0.9905 | 24472000.0 |
| 2000-02-28 13:00:00 | AAPL | Stock | 0.9911 | 1.0078 | 0.9888 | 1.0 | 46827200.0 |
| 2000-02-28 14:00:00 | AAPL | Stock | 1.0011 | 1.0268 | 1.0006 | 1.024 | 59147200.0 |
| 2000-02-28 15:00:00 | AAPL | Stock | 1.0246 | 1.0262 | 1.0067 | 1.0106 | 34092800.0 |
| 2000-02-28 16:00:00 | AAPL | Stock | 1.0106 | 1.0112 | 1.0106 | 1.0112 | 2385600.0 |
| 2000-02-28 09:00:00 | MSFT | Stock | 45.125 | 45.375 | 44.5938 | 44.8125 | 12222200.0 |
| 2000-02-28 10:00:00 | MSFT | Stock | 44.75 | 44.875 | 44.125 | 44.625 | 16356000.0 |
| 2000-02-28 11:00:00 | MSFT | Stock | 44.625 | 44.7188 | 44.0625 | 44.375 | 11649800.0 |
| 2000-02-28 12:00:00 | MSFT | Stock | 44.3438 | 44.625 | 44.0938 | 44.4688 | 6533600.0 |
| 2000-02-28 13:00:00 | MSFT | Stock | 44.4688 | 45.0 | 44.375 | 44.9375 | 5208200.0 |
| 2000-02-28 14:00:00 | MSFT | Stock | 44.9375 | 45.9375 | 44.9375 | 45.9062 | 9377800.0 |
| 2000-02-28 15:00:00 | MSFT | Stock | 45.9219 | 46.0625 | 45.375 | 45.8125 | 9507000.0 |
| 2000-02-28 16:00:00 | MSFT | Stock | 45.8125 | 45.8125 | 45.7188 | 45.7812 | 151800.0 |
| 2000-02-28 09:00:00 | NVDA | Stock | 0.1268 | 0.1281 | 0.1268 | 0.1276 | 20640000.0 |
| 2000-02-28 10:00:00 | NVDA | Stock | 0.1277 | 0.1281 | 0.1271 | 0.1275 | 62208000.0 |
| 2000-02-28 11:00:00 | NVDA | Stock | 0.1275 | 0.128 | 0.126 | 0.1263 | 72096000.0 |
| 2000-02-28 12:00:00 | NVDA | Stock | 0.1262 | 0.1264 | 0.1246 | 0.1255 | 50304000.0 |
| 2000-02-28 13:00:00 | NVDA | Stock | 0.1251 | 0.1258 | 0.1245 | 0.125 | 28752000.0 |
| 2000-02-28 14:00:00 | NVDA | Stock | 0.125 | 0.126 | 0.1246 | 0.1258 | 31344000.0 |
| 2000-02-28 15:00:00 | NVDA | Stock | 0.1255 | 0.1268 | 0.1251 | 0.1258 | 62976000.0 |
| 2000-02-28 16:00:00 | NVDA | Stock | 0.1266 | 0.1266 | 0.1266 | 0.1266 | 2544000.0 |
| 2000-02-28 09:00:00 | AMZN | Stock | 3.3281 | 3.3594 | 3.225 | 3.2312 | 14848000.0 |
| 2000-02-28 10:00:00 | AMZN | Stock | 3.2281 | 3.2875 | 3.2063 | 3.2469 | 22908000.0 |
| 2000-02-28 11:00:00 | AMZN | Stock | 3.2594 | 3.2688 | 3.2188 | 3.2375 | 11794000.0 |
| 2000-02-28 12:00:00 | AMZN | Stock | 3.2312 | 3.2812 | 3.225 | 3.2562 | 8544000.0 |
| 2000-02-28 13:00:00 | AMZN | Stock | 3.2656 | 3.2969 | 3.2562 | 3.2594 | 7040000.0 |
| 2000-02-28 14:00:00 | AMZN | Stock | 3.2594 | 3.3406 | 3.2594 | 3.3344 | 13156000.0 |
| 2000-02-28 15:00:00 | AMZN | Stock | 3.3344 | 3.3406 | 3.2812 | 3.2844 | 15412000.0 |
| 2000-02-28 16:00:00 | AMZN | Stock | 3.2875 | 3.2875 | 3.2844 | 3.2875 | 308000.0 |
| 2000-02-28 09:00:00 | CL | Stock | 24.4375 | 24.4375 | 24.0 | 24.1875 | 609200.0 |
| 2000-02-28 10:00:00 | CL | Stock | 24.3125 | 24.9375 | 24.0625 | 24.9062 | 1314400.0 |
| 2000-02-28 11:00:00 | CL | Stock | 24.9062 | 24.9062 | 24.5625 | 24.625 | 387000.0 |
| 2000-02-28 12:00:00 | CL | Stock | 24.625 | 24.8125 | 24.5 | 24.8125 | 240600.0 |
| 2000-02-28 13:00:00 | CL | Stock | 24.8125 | 25.3125 | 24.7812 | 25.1562 | 894000.0 |
| 2000-02-28 14:00:00 | CL | Stock | 25.1875 | 25.5 | 25.1875 | 25.375 | 676600.0 |
| 2000-02-28 15:00:00 | CL | Stock | 25.375 | 25.6562 | 25.25 | 25.5938 | 1095000.0 |
| 2000-02-28 16:00:00 | CL | Stock | 25.5625 | 25.5625 | 25.5 | 25.5 | 70800.0 |
> showing 40 of 14,536 rows — these rows as CSV