PREVIEW / stock_1hour / 2002-05-28
file: by_date/stock_1hour/2002/2002-05-28.parquet size: 407 KB rows: 19,045 symbols: 1,426
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 |
|---|---|---|---|---|---|---|---|
| 2002-05-28 08:00:00 | AAPL | Stock | 0.4313 | 0.4313 | 0.4295 | 0.4295 | 179200.0 |
| 2002-05-28 09:00:00 | AAPL | Stock | 0.4289 | 0.4298 | 0.4214 | 0.4286 | 48546400.0 |
| 2002-05-28 10:00:00 | AAPL | Stock | 0.4286 | 0.4321 | 0.4196 | 0.42 | 33331200.0 |
| 2002-05-28 11:00:00 | AAPL | Stock | 0.4198 | 0.4232 | 0.4184 | 0.4218 | 14285600.0 |
| 2002-05-28 12:00:00 | AAPL | Stock | 0.4218 | 0.4257 | 0.4196 | 0.4257 | 5936000.0 |
| 2002-05-28 13:00:00 | AAPL | Stock | 0.4255 | 0.4261 | 0.4232 | 0.4241 | 7190400.0 |
| 2002-05-28 14:00:00 | AAPL | Stock | 0.4246 | 0.4286 | 0.4232 | 0.4239 | 15276800.0 |
| 2002-05-28 15:00:00 | AAPL | Stock | 0.4245 | 0.4309 | 0.4236 | 0.4284 | 20792800.0 |
| 2002-05-28 16:00:00 | AAPL | Stock | 0.4284 | 0.4314 | 0.4232 | 0.4304 | 3735200.0 |
| 2002-05-28 17:00:00 | AAPL | Stock | 0.4291 | 0.4295 | 0.4291 | 0.4295 | 50400.0 |
| 2002-05-28 08:00:00 | MSFT | Stock | 26.625 | 26.7325 | 26.4 | 26.725 | 24000.0 |
| 2002-05-28 09:00:00 | MSFT | Stock | 26.7 | 26.845 | 26.53 | 26.584 | 5263400.0 |
| 2002-05-28 10:00:00 | MSFT | Stock | 26.575 | 26.715 | 25.88 | 25.94 | 13778400.0 |
| 2002-05-28 11:00:00 | MSFT | Stock | 25.925 | 26.055 | 25.875 | 26.0 | 6554000.0 |
| 2002-05-28 12:00:00 | MSFT | Stock | 26.0 | 26.05 | 25.945 | 26.025 | 3300200.0 |
| 2002-05-28 13:00:00 | MSFT | Stock | 26.015 | 26.24 | 26.015 | 26.185 | 4423600.0 |
| 2002-05-28 14:00:00 | MSFT | Stock | 26.19 | 26.33 | 25.995 | 26.0375 | 6735200.0 |
| 2002-05-28 15:00:00 | MSFT | Stock | 26.035 | 26.24 | 26.01 | 26.165 | 7473600.0 |
| 2002-05-28 16:00:00 | MSFT | Stock | 26.165 | 26.25 | 26.0895 | 26.1 | 1510000.0 |
| 2002-05-28 17:00:00 | MSFT | Stock | 26.09 | 26.09 | 26.02 | 26.04 | 17200.0 |
| 2002-05-28 18:00:00 | MSFT | Stock | 26.09 | 26.09 | 26.09 | 26.09 | 400.0 |
| 2002-05-28 08:00:00 | NVDA | Stock | 0.2925 | 0.2988 | 0.2921 | 0.2945 | 576000.0 |
| 2002-05-28 09:00:00 | NVDA | Stock | 0.2967 | 0.2967 | 0.2829 | 0.2846 | 167088000.0 |
| 2002-05-28 10:00:00 | NVDA | Stock | 0.2843 | 0.2874 | 0.2759 | 0.2763 | 276720000.0 |
| 2002-05-28 11:00:00 | NVDA | Stock | 0.2763 | 0.2765 | 0.2745 | 0.2756 | 229800000.0 |
| 2002-05-28 12:00:00 | NVDA | Stock | 0.2755 | 0.2792 | 0.2746 | 0.2792 | 94464000.0 |
| 2002-05-28 13:00:00 | NVDA | Stock | 0.2792 | 0.2803 | 0.2746 | 0.2774 | 163932000.0 |
| 2002-05-28 14:00:00 | NVDA | Stock | 0.2777 | 0.2817 | 0.2762 | 0.2777 | 141024000.0 |
| 2002-05-28 15:00:00 | NVDA | Stock | 0.2777 | 0.2817 | 0.2767 | 0.2806 | 176784000.0 |
| 2002-05-28 16:00:00 | NVDA | Stock | 0.2806 | 0.2808 | 0.2792 | 0.2792 | 58164000.0 |
| 2002-05-28 17:00:00 | NVDA | Stock | 0.2792 | 0.2796 | 0.2781 | 0.2781 | 1248000.0 |
| 2002-05-28 18:00:00 | NVDA | Stock | 0.2781 | 0.2786 | 0.2781 | 0.2784 | 504000.0 |
| 2002-05-28 08:00:00 | AMZN | Stock | 0.99 | 0.99 | 0.975 | 0.98 | 114000.0 |
| 2002-05-28 09:00:00 | AMZN | Stock | 0.978 | 0.9805 | 0.9455 | 0.949 | 18216000.0 |
| 2002-05-28 10:00:00 | AMZN | Stock | 0.949 | 0.9565 | 0.9385 | 0.9441 | 17784000.0 |
| 2002-05-28 11:00:00 | AMZN | Stock | 0.9445 | 0.9525 | 0.941 | 0.9485 | 9640000.0 |
| 2002-05-28 12:00:00 | AMZN | Stock | 0.9485 | 0.953 | 0.944 | 0.9495 | 5370000.0 |
| 2002-05-28 13:00:00 | AMZN | Stock | 0.95 | 0.9565 | 0.949 | 0.951 | 5926000.0 |
| 2002-05-28 14:00:00 | AMZN | Stock | 0.9505 | 0.958 | 0.9475 | 0.9485 | 7750000.0 |
| 2002-05-28 15:00:00 | AMZN | Stock | 0.949 | 0.955 | 0.948 | 0.9535 | 12336000.0 |
| 2002-05-28 16:00:00 | AMZN | Stock | 0.953 | 0.9579 | 0.952 | 0.953 | 1424000.0 |
| 2002-05-28 17:00:00 | AMZN | Stock | 0.953 | 0.955 | 0.95 | 0.953 | 68000.0 |
| 2002-05-28 09:00:00 | CL | Stock | 26.605 | 26.725 | 26.59 | 26.66 | 231800.0 |
| 2002-05-28 10:00:00 | CL | Stock | 26.65 | 26.685 | 26.45 | 26.49 | 749600.0 |
| 2002-05-28 11:00:00 | CL | Stock | 26.49 | 26.52 | 26.35 | 26.39 | 395200.0 |
| 2002-05-28 12:00:00 | CL | Stock | 26.385 | 26.385 | 26.215 | 26.3 | 391400.0 |
| 2002-05-28 13:00:00 | CL | Stock | 26.305 | 26.31 | 26.07 | 26.11 | 602800.0 |
| 2002-05-28 14:00:00 | CL | Stock | 26.11 | 26.2 | 26.0 | 26.175 | 528200.0 |
| 2002-05-28 15:00:00 | CL | Stock | 26.17 | 26.205 | 26.1 | 26.15 | 1315800.0 |
| 2002-05-28 16:00:00 | CL | Stock | 26.14 | 26.255 | 26.11 | 26.255 | 658800.0 |
> showing 50 of 19,045 rows — these rows as CSV