PREVIEW / stock_1hour / 2000-10-10
file: by_date/stock_1hour/2000/2000-10-10.parquet size: 305 KB rows: 15,652 symbols: 1,232
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-10-10 08:00:00 | AAPL | Stock | 0.3895 | 0.4074 | 0.3878 | 0.3895 | 3589600.0 |
| 2000-10-10 09:00:00 | AAPL | Stock | 0.3895 | 0.4007 | 0.3862 | 0.394 | 96129600.0 |
| 2000-10-10 10:00:00 | AAPL | Stock | 0.3951 | 0.3951 | 0.375 | 0.3783 | 96846400.0 |
| 2000-10-10 11:00:00 | AAPL | Stock | 0.3783 | 0.3828 | 0.375 | 0.3761 | 61958400.0 |
| 2000-10-10 12:00:00 | AAPL | Stock | 0.3761 | 0.3817 | 0.375 | 0.3761 | 54560800.0 |
| 2000-10-10 13:00:00 | AAPL | Stock | 0.3761 | 0.3817 | 0.3761 | 0.3811 | 60513600.0 |
| 2000-10-10 14:00:00 | AAPL | Stock | 0.3817 | 0.3817 | 0.3728 | 0.3728 | 93917600.0 |
| 2000-10-10 15:00:00 | AAPL | Stock | 0.3728 | 0.375 | 0.3661 | 0.3739 | 177816800.0 |
| 2000-10-10 16:00:00 | AAPL | Stock | 0.3744 | 0.3806 | 0.3638 | 0.3661 | 16324000.0 |
| 2000-10-10 17:00:00 | AAPL | Stock | 0.365 | 0.3661 | 0.3638 | 0.3661 | 179200.0 |
| 2000-10-10 18:00:00 | AAPL | Stock | 0.3683 | 0.3728 | 0.3638 | 0.3638 | 268800.0 |
| 2000-10-10 08:00:00 | MSFT | Stock | 27.0 | 27.0625 | 26.625 | 26.625 | 8600.0 |
| 2000-10-10 09:00:00 | MSFT | Stock | 26.5 | 27.6875 | 26.5 | 27.6562 | 10003600.0 |
| 2000-10-10 10:00:00 | MSFT | Stock | 27.6875 | 27.6875 | 27.125 | 27.3438 | 9821200.0 |
| 2000-10-10 11:00:00 | MSFT | Stock | 27.3438 | 27.5938 | 27.2188 | 27.3438 | 7543400.0 |
| 2000-10-10 12:00:00 | MSFT | Stock | 27.3438 | 27.4062 | 27.1875 | 27.375 | 4912000.0 |
| 2000-10-10 13:00:00 | MSFT | Stock | 27.375 | 27.7812 | 27.3438 | 27.75 | 7620600.0 |
| 2000-10-10 14:00:00 | MSFT | Stock | 27.75 | 27.75 | 27.375 | 27.4688 | 6670200.0 |
| 2000-10-10 15:00:00 | MSFT | Stock | 27.4688 | 27.5938 | 27.1875 | 27.25 | 10915800.0 |
| 2000-10-10 16:00:00 | MSFT | Stock | 27.25 | 27.75 | 26.8125 | 27.125 | 2095800.0 |
| 2000-10-10 17:00:00 | MSFT | Stock | 27.125 | 27.1562 | 27.0 | 27.0 | 60400.0 |
| 2000-10-10 18:00:00 | MSFT | Stock | 27.0 | 27.0625 | 26.9375 | 27.0625 | 3800.0 |
| 2000-10-10 08:00:00 | NVDA | Stock | 0.2911 | 0.2911 | 0.2911 | 0.2911 | 24000.0 |
| 2000-10-10 09:00:00 | NVDA | Stock | 0.2917 | 0.2917 | 0.2758 | 0.2891 | 32328000.0 |
| 2000-10-10 10:00:00 | NVDA | Stock | 0.2891 | 0.2932 | 0.2857 | 0.2857 | 63792000.0 |
| 2000-10-10 11:00:00 | NVDA | Stock | 0.2857 | 0.2857 | 0.2755 | 0.2755 | 44064000.0 |
| 2000-10-10 12:00:00 | NVDA | Stock | 0.2755 | 0.2757 | 0.2674 | 0.2737 | 63528000.0 |
| 2000-10-10 13:00:00 | NVDA | Stock | 0.2734 | 0.2802 | 0.2701 | 0.2776 | 35592000.0 |
| 2000-10-10 14:00:00 | NVDA | Stock | 0.2779 | 0.2784 | 0.2667 | 0.2672 | 60864000.0 |
| 2000-10-10 15:00:00 | NVDA | Stock | 0.2698 | 0.275 | 0.2667 | 0.2693 | 91488000.0 |
| 2000-10-10 16:00:00 | NVDA | Stock | 0.2698 | 0.2703 | 0.2625 | 0.2625 | 1896000.0 |
| 2000-10-10 08:00:00 | AMZN | Stock | 1.5 | 1.525 | 1.5 | 1.5062 | 226000.0 |
| 2000-10-10 09:00:00 | AMZN | Stock | 1.5125 | 1.6 | 1.4438 | 1.6 | 22490000.0 |
| 2000-10-10 10:00:00 | AMZN | Stock | 1.5984 | 1.6359 | 1.5781 | 1.5875 | 30514000.0 |
| 2000-10-10 11:00:00 | AMZN | Stock | 1.5875 | 1.6 | 1.5062 | 1.5219 | 16486000.0 |
| 2000-10-10 12:00:00 | AMZN | Stock | 1.5219 | 1.5594 | 1.5219 | 1.5438 | 9788000.0 |
| 2000-10-10 13:00:00 | AMZN | Stock | 1.5469 | 1.575 | 1.5375 | 1.55 | 14106000.0 |
| 2000-10-10 14:00:00 | AMZN | Stock | 1.55 | 1.55 | 1.5062 | 1.5156 | 17986000.0 |
| 2000-10-10 15:00:00 | AMZN | Stock | 1.5125 | 1.5594 | 1.5094 | 1.5219 | 21642000.0 |
| 2000-10-10 16:00:00 | AMZN | Stock | 1.5219 | 1.5547 | 1.475 | 1.525 | 2124000.0 |
| 2000-10-10 17:00:00 | AMZN | Stock | 1.5312 | 1.5312 | 1.5125 | 1.525 | 300000.0 |
| 2000-10-10 18:00:00 | AMZN | Stock | 1.5188 | 1.5188 | 1.475 | 1.475 | 72000.0 |
| 2000-10-10 09:00:00 | CL | Stock | 24.93 | 25.025 | 24.925 | 24.99 | 317400.0 |
| 2000-10-10 10:00:00 | CL | Stock | 25.025 | 25.47 | 24.95 | 25.18 | 684800.0 |
| 2000-10-10 11:00:00 | CL | Stock | 25.205 | 25.345 | 25.175 | 25.29 | 248800.0 |
| 2000-10-10 12:00:00 | CL | Stock | 25.275 | 25.32 | 25.15 | 25.15 | 263000.0 |
| 2000-10-10 13:00:00 | CL | Stock | 25.15 | 25.245 | 25.065 | 25.11 | 277600.0 |
| 2000-10-10 14:00:00 | CL | Stock | 25.11 | 25.175 | 25.06 | 25.1 | 248800.0 |
| 2000-10-10 15:00:00 | CL | Stock | 25.1 | 25.2 | 25.06 | 25.095 | 451800.0 |
| 2000-10-10 16:00:00 | CL | Stock | 25.095 | 25.12 | 25.095 | 25.12 | 190000.0 |
> showing 50 of 15,652 rows — these rows as CSV