PREVIEW / stock_1hour / 2002-09-11
file: by_date/stock_1hour/2002/2002-09-11.parquet size: 288 KB rows: 12,600 symbols: 1,456
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-09-11 11:00:00 | AAPL | Stock | 0.2561 | 0.2607 | 0.2561 | 0.2584 | 36545992.0 |
| 2002-09-11 12:00:00 | AAPL | Stock | 0.2584 | 0.2586 | 0.2527 | 0.2543 | 54179552.0 |
| 2002-09-11 13:00:00 | AAPL | Stock | 0.2546 | 0.2554 | 0.2529 | 0.2543 | 18438672.0 |
| 2002-09-11 14:00:00 | AAPL | Stock | 0.2541 | 0.2589 | 0.2534 | 0.258 | 43149064.0 |
| 2002-09-11 15:00:00 | AAPL | Stock | 0.2577 | 0.258 | 0.2548 | 0.255 | 41979616.0 |
| 2002-09-11 16:00:00 | AAPL | Stock | 0.255 | 0.2571 | 0.2532 | 0.2545 | 3360000.0 |
| 2002-09-11 17:00:00 | AAPL | Stock | 0.2552 | 0.2552 | 0.2552 | 0.2552 | 5600.0 |
| 2002-09-11 18:00:00 | AAPL | Stock | 0.2546 | 0.2546 | 0.2546 | 0.2546 | 28000.0 |
| 2002-09-11 11:00:00 | MSFT | Stock | 25.14 | 25.55 | 25.055 | 25.49 | 15112262.0 |
| 2002-09-11 12:00:00 | MSFT | Stock | 25.49 | 25.525 | 24.88 | 25.0 | 19330082.0 |
| 2002-09-11 13:00:00 | MSFT | Stock | 25.0 | 25.02 | 24.68 | 24.8195 | 13414306.0 |
| 2002-09-11 14:00:00 | MSFT | Stock | 24.81 | 24.985 | 24.66 | 24.965 | 10374094.0 |
| 2002-09-11 15:00:00 | MSFT | Stock | 24.965 | 24.985 | 24.265 | 24.28 | 16945458.0 |
| 2002-09-11 16:00:00 | MSFT | Stock | 24.28 | 24.3 | 24.2414 | 24.275 | 1129322.0 |
| 2002-09-11 17:00:00 | MSFT | Stock | 24.26 | 24.7791 | 24.2505 | 24.7791 | 511682.0 |
| 2002-09-11 18:00:00 | MSFT | Stock | 24.3 | 24.7791 | 24.275 | 24.275 | 28700.0 |
| 2002-09-11 11:00:00 | NVDA | Stock | 0.0908 | 0.0992 | 0.0908 | 0.0977 | 619824480.0 |
| 2002-09-11 12:00:00 | NVDA | Stock | 0.0977 | 0.0977 | 0.0944 | 0.0949 | 378923520.0 |
| 2002-09-11 13:00:00 | NVDA | Stock | 0.0949 | 0.0956 | 0.0941 | 0.0951 | 167728800.0 |
| 2002-09-11 14:00:00 | NVDA | Stock | 0.0952 | 0.096 | 0.0948 | 0.0956 | 144251160.0 |
| 2002-09-11 15:00:00 | NVDA | Stock | 0.0956 | 0.0957 | 0.0912 | 0.0924 | 306019560.0 |
| 2002-09-11 16:00:00 | NVDA | Stock | 0.0925 | 0.0956 | 0.0917 | 0.0917 | 18916440.0 |
| 2002-09-11 17:00:00 | NVDA | Stock | 0.0917 | 0.0921 | 0.0912 | 0.0913 | 2840040.0 |
| 2002-09-11 18:00:00 | NVDA | Stock | 0.0917 | 0.0917 | 0.0912 | 0.0913 | 468000.0 |
| 2002-09-11 11:00:00 | AMZN | Stock | 0.8575 | 0.8902 | 0.8575 | 0.888 | 26126960.0 |
| 2002-09-11 12:00:00 | AMZN | Stock | 0.8885 | 0.8925 | 0.8635 | 0.8655 | 43234580.0 |
| 2002-09-11 13:00:00 | AMZN | Stock | 0.8655 | 0.8664 | 0.8565 | 0.86 | 22098920.0 |
| 2002-09-11 14:00:00 | AMZN | Stock | 0.86 | 0.882 | 0.858 | 0.871 | 12665620.0 |
| 2002-09-11 15:00:00 | AMZN | Stock | 0.8718 | 0.874 | 0.852 | 0.8555 | 18684140.0 |
| 2002-09-11 16:00:00 | AMZN | Stock | 0.8555 | 0.8635 | 0.85 | 0.8575 | 5067200.0 |
| 2002-09-11 17:00:00 | AMZN | Stock | 0.855 | 0.8555 | 0.8505 | 0.8505 | 90000.0 |
| 2002-09-11 18:00:00 | AMZN | Stock | 0.8505 | 0.8505 | 0.8505 | 0.8505 | 4000.0 |
| 2002-09-11 12:00:00 | CL | Stock | 28.075 | 28.1 | 27.905 | 28.1 | 732000.0 |
| 2002-09-11 13:00:00 | CL | Stock | 28.1 | 28.195 | 28.005 | 28.135 | 437200.0 |
| 2002-09-11 14:00:00 | CL | Stock | 28.135 | 28.14 | 28.025 | 28.12 | 394400.0 |
| 2002-09-11 15:00:00 | CL | Stock | 28.115 | 28.175 | 27.96 | 27.965 | 509200.0 |
| 2002-09-11 16:00:00 | CL | Stock | 27.965 | 27.965 | 27.95 | 27.955 | 47200.0 |
> showing 37 of 12,600 rows — these rows as CSV