PREVIEW / stock_1hour / 2003-01-31
file: by_date/stock_1hour/2003/2003-01-31.parquet size: 417 KB rows: 19,778 symbols: 1,542
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 |
|---|---|---|---|---|---|---|---|
| 2003-01-31 09:00:00 | AAPL | Stock | 0.2554 | 0.2588 | 0.2509 | 0.2563 | 54553968.0 |
| 2003-01-31 10:00:00 | AAPL | Stock | 0.2563 | 0.2598 | 0.2525 | 0.2548 | 44136736.0 |
| 2003-01-31 11:00:00 | AAPL | Stock | 0.2546 | 0.2563 | 0.2527 | 0.2555 | 19483968.0 |
| 2003-01-31 12:00:00 | AAPL | Stock | 0.2555 | 0.2561 | 0.2529 | 0.2554 | 53593456.0 |
| 2003-01-31 13:00:00 | AAPL | Stock | 0.2552 | 0.2593 | 0.2552 | 0.2577 | 40682880.0 |
| 2003-01-31 14:00:00 | AAPL | Stock | 0.2577 | 0.2598 | 0.2561 | 0.2566 | 41568408.0 |
| 2003-01-31 15:00:00 | AAPL | Stock | 0.2566 | 0.2577 | 0.2559 | 0.2566 | 36548176.0 |
| 2003-01-31 16:00:00 | AAPL | Stock | 0.2566 | 0.258 | 0.2538 | 0.2564 | 16223200.0 |
| 2003-01-31 18:00:00 | AAPL | Stock | 0.2598 | 0.2607 | 0.2598 | 0.2605 | 219800.0 |
| 2003-01-31 08:00:00 | MSFT | Stock | 24.2875 | 24.7 | 24.12 | 24.19 | 157252.0 |
| 2003-01-31 09:00:00 | MSFT | Stock | 24.19 | 24.3 | 23.7 | 24.0 | 14600860.0 |
| 2003-01-31 10:00:00 | MSFT | Stock | 23.99 | 24.04 | 23.515 | 23.895 | 20917516.0 |
| 2003-01-31 11:00:00 | MSFT | Stock | 23.895 | 24.08 | 23.68 | 23.9905 | 14059350.0 |
| 2003-01-31 12:00:00 | MSFT | Stock | 23.995 | 24.11 | 23.785 | 23.99 | 10345488.0 |
| 2003-01-31 13:00:00 | MSFT | Stock | 24.0 | 24.03 | 23.805 | 23.87 | 8589542.0 |
| 2003-01-31 14:00:00 | MSFT | Stock | 23.865 | 24.015 | 23.79 | 23.895 | 6989750.0 |
| 2003-01-31 15:00:00 | MSFT | Stock | 23.905 | 23.955 | 23.565 | 23.7345 | 15506338.0 |
| 2003-01-31 16:00:00 | MSFT | Stock | 23.73 | 23.85 | 23.7 | 23.81 | 4314464.0 |
| 2003-01-31 17:00:00 | MSFT | Stock | 23.81 | 23.8695 | 23.775 | 23.775 | 18948.0 |
| 2003-01-31 18:00:00 | MSFT | Stock | 23.775 | 23.8 | 23.75 | 23.75 | 15148.0 |
| 2003-01-31 08:00:00 | NVDA | Stock | 0.0855 | 0.0858 | 0.085 | 0.0854 | 1021200.0 |
| 2003-01-31 09:00:00 | NVDA | Stock | 0.0854 | 0.0855 | 0.0814 | 0.0839 | 155475120.0 |
| 2003-01-31 10:00:00 | NVDA | Stock | 0.0838 | 0.085 | 0.083 | 0.0847 | 146591040.0 |
| 2003-01-31 11:00:00 | NVDA | Stock | 0.0847 | 0.0883 | 0.0842 | 0.0871 | 174209640.0 |
| 2003-01-31 12:00:00 | NVDA | Stock | 0.0871 | 0.0878 | 0.0861 | 0.0868 | 74142480.0 |
| 2003-01-31 13:00:00 | NVDA | Stock | 0.0867 | 0.0875 | 0.0862 | 0.0867 | 53796480.0 |
| 2003-01-31 14:00:00 | NVDA | Stock | 0.0867 | 0.0867 | 0.0856 | 0.086 | 79795080.0 |
| 2003-01-31 15:00:00 | NVDA | Stock | 0.0861 | 0.0865 | 0.0848 | 0.0859 | 172633920.0 |
| 2003-01-31 16:00:00 | NVDA | Stock | 0.0858 | 0.0867 | 0.0858 | 0.0864 | 11699040.0 |
| 2003-01-31 17:00:00 | NVDA | Stock | 0.0867 | 0.0867 | 0.086 | 0.0861 | 1956000.0 |
| 2003-01-31 18:00:00 | NVDA | Stock | 0.086 | 0.086 | 0.085 | 0.085 | 1284000.0 |
| 2003-01-31 08:00:00 | AMZN | Stock | 1.087 | 1.095 | 1.087 | 1.094 | 76000.0 |
| 2003-01-31 09:00:00 | AMZN | Stock | 1.094 | 1.094 | 1.078 | 1.093 | 19251000.0 |
| 2003-01-31 10:00:00 | AMZN | Stock | 1.0925 | 1.1005 | 1.0825 | 1.0875 | 23938880.0 |
| 2003-01-31 11:00:00 | AMZN | Stock | 1.0875 | 1.0965 | 1.082 | 1.0935 | 13177840.0 |
| 2003-01-31 12:00:00 | AMZN | Stock | 1.094 | 1.1085 | 1.0855 | 1.101 | 11941320.0 |
| 2003-01-31 13:00:00 | AMZN | Stock | 1.102 | 1.1135 | 1.1015 | 1.105 | 12033220.0 |
| 2003-01-31 14:00:00 | AMZN | Stock | 1.105 | 1.1091 | 1.1005 | 1.103 | 7802540.0 |
| 2003-01-31 15:00:00 | AMZN | Stock | 1.1035 | 1.1045 | 1.083 | 1.0955 | 21828520.0 |
| 2003-01-31 16:00:00 | AMZN | Stock | 1.093 | 1.099 | 1.091 | 1.099 | 3056000.0 |
| 2003-01-31 17:00:00 | AMZN | Stock | 1.099 | 1.099 | 1.0925 | 1.0925 | 22000.0 |
| 2003-01-31 09:00:00 | CL | Stock | 24.775 | 25.05 | 24.775 | 24.92 | 459000.0 |
| 2003-01-31 10:00:00 | CL | Stock | 24.94 | 25.23 | 24.94 | 25.1 | 595200.0 |
| 2003-01-31 11:00:00 | CL | Stock | 25.1 | 25.11 | 24.89 | 25.025 | 516000.0 |
| 2003-01-31 12:00:00 | CL | Stock | 25.02 | 25.255 | 25.005 | 25.16 | 273000.0 |
| 2003-01-31 13:00:00 | CL | Stock | 25.165 | 25.465 | 25.16 | 25.4 | 355200.0 |
| 2003-01-31 14:00:00 | CL | Stock | 25.395 | 25.575 | 25.375 | 25.375 | 329400.0 |
| 2003-01-31 15:00:00 | CL | Stock | 25.38 | 25.43 | 25.17 | 25.43 | 519400.0 |
| 2003-01-31 16:00:00 | CL | Stock | 25.43 | 25.455 | 25.43 | 25.455 | 301800.0 |
> showing 49 of 19,778 rows — these rows as CSV