PREVIEW / stock_1hour / 2001-03-14
file: by_date/stock_1hour/2001/2001-03-14.parquet size: 354 KB rows: 16,552 symbols: 1,274
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 |
|---|---|---|---|---|---|---|---|
| 2001-03-14 08:00:00 | AAPL | Stock | 0.3393 | 0.3488 | 0.3214 | 0.3281 | 2497600.0 |
| 2001-03-14 09:00:00 | AAPL | Stock | 0.3292 | 0.3438 | 0.3292 | 0.3404 | 52959200.0 |
| 2001-03-14 10:00:00 | AAPL | Stock | 0.3404 | 0.3661 | 0.3404 | 0.3605 | 104568800.0 |
| 2001-03-14 11:00:00 | AAPL | Stock | 0.3605 | 0.3605 | 0.3504 | 0.3516 | 33577600.0 |
| 2001-03-14 12:00:00 | AAPL | Stock | 0.3516 | 0.3527 | 0.3438 | 0.3482 | 41406400.0 |
| 2001-03-14 13:00:00 | AAPL | Stock | 0.3482 | 0.3549 | 0.3438 | 0.3516 | 60524800.0 |
| 2001-03-14 14:00:00 | AAPL | Stock | 0.3516 | 0.365 | 0.3516 | 0.3571 | 70179200.0 |
| 2001-03-14 15:00:00 | AAPL | Stock | 0.3583 | 0.3661 | 0.3549 | 0.3627 | 78411200.0 |
| 2001-03-14 16:00:00 | AAPL | Stock | 0.3638 | 0.365 | 0.3605 | 0.3605 | 12762400.0 |
| 2001-03-14 17:00:00 | AAPL | Stock | 0.3627 | 0.3638 | 0.3605 | 0.3616 | 84000.0 |
| 2001-03-14 18:00:00 | AAPL | Stock | 0.3605 | 0.3605 | 0.3605 | 0.3605 | 11200.0 |
| 2001-03-14 08:00:00 | MSFT | Stock | 26.0938 | 26.5312 | 25.75 | 26.0938 | 565400.0 |
| 2001-03-14 09:00:00 | MSFT | Stock | 26.25 | 27.25 | 26.0938 | 26.7188 | 13086200.0 |
| 2001-03-14 10:00:00 | MSFT | Stock | 26.6875 | 27.625 | 26.6562 | 27.4688 | 20731800.0 |
| 2001-03-14 11:00:00 | MSFT | Stock | 27.5 | 27.5 | 26.8438 | 26.8438 | 8118200.0 |
| 2001-03-14 12:00:00 | MSFT | Stock | 26.8438 | 26.9375 | 26.375 | 26.875 | 9519800.0 |
| 2001-03-14 13:00:00 | MSFT | Stock | 26.875 | 27.0312 | 26.375 | 27.0 | 8928600.0 |
| 2001-03-14 14:00:00 | MSFT | Stock | 27.0 | 27.2188 | 26.5625 | 26.7188 | 6602400.0 |
| 2001-03-14 15:00:00 | MSFT | Stock | 26.6875 | 27.375 | 26.5625 | 27.1562 | 16505200.0 |
| 2001-03-14 16:00:00 | MSFT | Stock | 26.9688 | 27.25 | 26.5938 | 27.0625 | 2194200.0 |
| 2001-03-14 17:00:00 | MSFT | Stock | 27.125 | 27.125 | 27.0 | 27.125 | 5000.0 |
| 2001-03-14 18:00:00 | MSFT | Stock | 27.1719 | 27.1719 | 27.0625 | 27.0625 | 600.0 |
| 2001-03-14 08:00:00 | NVDA | Stock | 0.2208 | 0.2208 | 0.2083 | 0.2143 | 4128000.0 |
| 2001-03-14 09:00:00 | NVDA | Stock | 0.2135 | 0.2292 | 0.212 | 0.2271 | 216648000.0 |
| 2001-03-14 10:00:00 | NVDA | Stock | 0.2263 | 0.2344 | 0.2232 | 0.2307 | 222480000.0 |
| 2001-03-14 11:00:00 | NVDA | Stock | 0.2307 | 0.2326 | 0.226 | 0.2268 | 130656000.0 |
| 2001-03-14 12:00:00 | NVDA | Stock | 0.2266 | 0.2307 | 0.2258 | 0.2297 | 92544000.0 |
| 2001-03-14 13:00:00 | NVDA | Stock | 0.2297 | 0.2305 | 0.225 | 0.2292 | 108552000.0 |
| 2001-03-14 14:00:00 | NVDA | Stock | 0.2286 | 0.2375 | 0.2284 | 0.2299 | 255168000.0 |
| 2001-03-14 15:00:00 | NVDA | Stock | 0.2299 | 0.2385 | 0.2271 | 0.2375 | 239136000.0 |
| 2001-03-14 16:00:00 | NVDA | Stock | 0.2375 | 0.2378 | 0.2339 | 0.2378 | 20760000.0 |
| 2001-03-14 08:00:00 | AMZN | Stock | 0.5125 | 0.5312 | 0.5125 | 0.5125 | 312000.0 |
| 2001-03-14 09:00:00 | AMZN | Stock | 0.5125 | 0.5344 | 0.5031 | 0.525 | 10038000.0 |
| 2001-03-14 10:00:00 | AMZN | Stock | 0.5281 | 0.5469 | 0.525 | 0.5375 | 11210000.0 |
| 2001-03-14 11:00:00 | AMZN | Stock | 0.5375 | 0.5406 | 0.5219 | 0.5219 | 7632000.0 |
| 2001-03-14 12:00:00 | AMZN | Stock | 0.5203 | 0.525 | 0.5156 | 0.5188 | 5510000.0 |
| 2001-03-14 13:00:00 | AMZN | Stock | 0.5188 | 0.5312 | 0.5188 | 0.525 | 7440000.0 |
| 2001-03-14 14:00:00 | AMZN | Stock | 0.5281 | 0.5344 | 0.525 | 0.5281 | 5194000.0 |
| 2001-03-14 15:00:00 | AMZN | Stock | 0.5297 | 0.5375 | 0.5219 | 0.5312 | 8978000.0 |
| 2001-03-14 16:00:00 | AMZN | Stock | 0.5312 | 0.5344 | 0.525 | 0.5312 | 1814000.0 |
| 2001-03-14 17:00:00 | AMZN | Stock | 0.5312 | 0.5312 | 0.525 | 0.525 | 66000.0 |
| 2001-03-14 18:00:00 | AMZN | Stock | 0.5344 | 0.5344 | 0.5344 | 0.5344 | 14000.0 |
| 2001-03-14 09:00:00 | CL | Stock | 28.075 | 28.075 | 27.65 | 27.85 | 303400.0 |
| 2001-03-14 10:00:00 | CL | Stock | 27.855 | 28.09 | 27.525 | 27.88 | 493200.0 |
| 2001-03-14 11:00:00 | CL | Stock | 27.88 | 28.1 | 27.875 | 27.95 | 384000.0 |
| 2001-03-14 12:00:00 | CL | Stock | 27.95 | 28.2 | 27.935 | 27.975 | 232400.0 |
| 2001-03-14 13:00:00 | CL | Stock | 27.975 | 27.975 | 27.675 | 27.76 | 365200.0 |
| 2001-03-14 14:00:00 | CL | Stock | 27.725 | 27.85 | 27.7 | 27.72 | 581000.0 |
| 2001-03-14 15:00:00 | CL | Stock | 27.72 | 27.765 | 27.65 | 27.75 | 415200.0 |
| 2001-03-14 16:00:00 | CL | Stock | 27.75 | 27.75 | 27.715 | 27.735 | 74400.0 |
> showing 50 of 16,552 rows — these rows as CSV