PREVIEW / stock_1hour / 2001-03-15
file: by_date/stock_1hour/2001/2001-03-15.parquet size: 354 KB rows: 16,461 symbols: 1,271
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-15 08:00:00 | AAPL | Stock | 0.3683 | 0.375 | 0.3666 | 0.3728 | 1058400.0 |
| 2001-03-15 09:00:00 | AAPL | Stock | 0.3705 | 0.3817 | 0.3683 | 0.3761 | 81424000.0 |
| 2001-03-15 10:00:00 | AAPL | Stock | 0.3761 | 0.3772 | 0.3672 | 0.3672 | 89566400.0 |
| 2001-03-15 11:00:00 | AAPL | Stock | 0.3672 | 0.3694 | 0.3594 | 0.3638 | 83003200.0 |
| 2001-03-15 12:00:00 | AAPL | Stock | 0.3638 | 0.3672 | 0.3616 | 0.3627 | 18435200.0 |
| 2001-03-15 13:00:00 | AAPL | Stock | 0.3616 | 0.3627 | 0.356 | 0.3571 | 62680800.0 |
| 2001-03-15 14:00:00 | AAPL | Stock | 0.3583 | 0.365 | 0.3571 | 0.3583 | 51060800.0 |
| 2001-03-15 15:00:00 | AAPL | Stock | 0.3583 | 0.3605 | 0.3516 | 0.3527 | 94320800.0 |
| 2001-03-15 16:00:00 | AAPL | Stock | 0.3527 | 0.3594 | 0.3426 | 0.3594 | 19090400.0 |
| 2001-03-15 17:00:00 | AAPL | Stock | 0.3549 | 0.3583 | 0.3516 | 0.3571 | 856800.0 |
| 2001-03-15 18:00:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3549 | 0.3549 | 84000.0 |
| 2001-03-15 08:00:00 | MSFT | Stock | 27.5 | 27.75 | 27.3438 | 27.5625 | 208200.0 |
| 2001-03-15 09:00:00 | MSFT | Stock | 27.5938 | 27.8125 | 27.1562 | 27.6875 | 13638600.0 |
| 2001-03-15 10:00:00 | MSFT | Stock | 27.6875 | 28.0312 | 27.625 | 27.6562 | 12384200.0 |
| 2001-03-15 11:00:00 | MSFT | Stock | 27.6562 | 27.8125 | 27.4062 | 27.625 | 7517600.0 |
| 2001-03-15 12:00:00 | MSFT | Stock | 27.625 | 27.875 | 27.5938 | 27.6875 | 4613000.0 |
| 2001-03-15 13:00:00 | MSFT | Stock | 27.6875 | 27.7188 | 27.4062 | 27.5 | 6553800.0 |
| 2001-03-15 14:00:00 | MSFT | Stock | 27.5 | 27.6562 | 27.125 | 27.1562 | 8490000.0 |
| 2001-03-15 15:00:00 | MSFT | Stock | 27.1875 | 27.25 | 26.75 | 26.8438 | 12265400.0 |
| 2001-03-15 16:00:00 | MSFT | Stock | 26.8438 | 27.6719 | 26.5 | 26.875 | 2862200.0 |
| 2001-03-15 17:00:00 | MSFT | Stock | 26.8594 | 27.0625 | 26.8594 | 26.875 | 411200.0 |
| 2001-03-15 18:00:00 | MSFT | Stock | 26.875 | 26.9375 | 26.875 | 26.875 | 19000.0 |
| 2001-03-15 08:00:00 | NVDA | Stock | 0.2385 | 0.2594 | 0.2385 | 0.2583 | 21384000.0 |
| 2001-03-15 09:00:00 | NVDA | Stock | 0.2583 | 0.2655 | 0.2503 | 0.2603 | 430392000.0 |
| 2001-03-15 10:00:00 | NVDA | Stock | 0.2604 | 0.2615 | 0.2549 | 0.2557 | 356016000.0 |
| 2001-03-15 11:00:00 | NVDA | Stock | 0.2555 | 0.2576 | 0.2536 | 0.2557 | 232152000.0 |
| 2001-03-15 12:00:00 | NVDA | Stock | 0.2557 | 0.2576 | 0.2552 | 0.2563 | 102792000.0 |
| 2001-03-15 13:00:00 | NVDA | Stock | 0.2557 | 0.2563 | 0.2448 | 0.2448 | 167760000.0 |
| 2001-03-15 14:00:00 | NVDA | Stock | 0.2448 | 0.2505 | 0.2443 | 0.2474 | 171216000.0 |
| 2001-03-15 15:00:00 | NVDA | Stock | 0.2477 | 0.2521 | 0.2432 | 0.2495 | 274824000.0 |
| 2001-03-15 16:00:00 | NVDA | Stock | 0.2497 | 0.251 | 0.249 | 0.251 | 22056000.0 |
| 2001-03-15 17:00:00 | NVDA | Stock | 0.2495 | 0.2516 | 0.2495 | 0.2516 | 672000.0 |
| 2001-03-15 18:00:00 | NVDA | Stock | 0.2508 | 0.2508 | 0.2508 | 0.2508 | 144000.0 |
| 2001-03-15 08:00:00 | AMZN | Stock | 0.55 | 0.55 | 0.55 | 0.55 | 34000.0 |
| 2001-03-15 09:00:00 | AMZN | Stock | 0.55 | 0.5719 | 0.55 | 0.5531 | 16930000.0 |
| 2001-03-15 10:00:00 | AMZN | Stock | 0.5562 | 0.5578 | 0.5406 | 0.55 | 15140000.0 |
| 2001-03-15 11:00:00 | AMZN | Stock | 0.5516 | 0.5656 | 0.55 | 0.5594 | 12562000.0 |
| 2001-03-15 12:00:00 | AMZN | Stock | 0.5578 | 0.5656 | 0.5562 | 0.5625 | 7498000.0 |
| 2001-03-15 13:00:00 | AMZN | Stock | 0.5656 | 0.5656 | 0.5531 | 0.5594 | 8536000.0 |
| 2001-03-15 14:00:00 | AMZN | Stock | 0.5578 | 0.5625 | 0.5531 | 0.5562 | 20642000.0 |
| 2001-03-15 15:00:00 | AMZN | Stock | 0.5562 | 0.5562 | 0.5438 | 0.5469 | 28726000.0 |
| 2001-03-15 16:00:00 | AMZN | Stock | 0.5438 | 0.5516 | 0.5438 | 0.5438 | 2762000.0 |
| 2001-03-15 09:00:00 | CL | Stock | 27.735 | 27.735 | 27.28 | 27.355 | 520600.0 |
| 2001-03-15 10:00:00 | CL | Stock | 27.375 | 27.4 | 26.98 | 27.0 | 641600.0 |
| 2001-03-15 11:00:00 | CL | Stock | 27.0 | 27.035 | 26.625 | 26.725 | 633400.0 |
| 2001-03-15 12:00:00 | CL | Stock | 26.73 | 27.03 | 26.715 | 26.9 | 455800.0 |
| 2001-03-15 13:00:00 | CL | Stock | 26.925 | 27.0 | 26.865 | 26.995 | 256000.0 |
| 2001-03-15 14:00:00 | CL | Stock | 26.995 | 27.175 | 26.99 | 27.14 | 381000.0 |
| 2001-03-15 15:00:00 | CL | Stock | 27.14 | 27.5 | 27.04 | 27.495 | 866000.0 |
| 2001-03-15 16:00:00 | CL | Stock | 27.475 | 27.475 | 27.06 | 27.06 | 179400.0 |
> showing 50 of 16,461 rows — these rows as CSV