PREVIEW / stock_1hour / 2022-01-21
file: by_date/stock_1hour/2022/2022-01-21.parquet size: 1.5 MB rows: 67,439 symbols: 2,695
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 |
|---|---|---|---|---|---|---|---|
| 2022-01-21 04:00:00 | AAPL | Stock | 163.52 | 163.97 | 162.65 | 163.87 | 109619.0 |
| 2022-01-21 05:00:00 | AAPL | Stock | 163.89 | 164.5 | 163.79 | 164.28 | 52911.0 |
| 2022-01-21 06:00:00 | AAPL | Stock | 164.28 | 164.28 | 163.19 | 163.7 | 76345.0 |
| 2022-01-21 07:00:00 | AAPL | Stock | 163.67 | 163.9 | 162.83 | 163.03 | 210272.0 |
| 2022-01-21 08:00:00 | AAPL | Stock | 163.46 | 163.795 | 162.73 | 163.3 | 742520.0 |
| 2022-01-21 09:00:00 | AAPL | Stock | 163.32 | 166.0 | 162.85 | 163.53 | 15521867.0 |
| 2022-01-21 10:00:00 | AAPL | Stock | 163.54 | 165.84 | 162.96 | 165.16 | 17481535.0 |
| 2022-01-21 11:00:00 | AAPL | Stock | 165.17 | 166.33 | 164.02 | 164.44 | 11974262.0 |
| 2022-01-21 12:00:00 | AAPL | Stock | 164.42 | 164.67 | 163.25 | 163.96 | 8715438.0 |
| 2022-01-21 13:00:00 | AAPL | Stock | 163.95 | 164.78 | 163.35 | 163.765 | 8390615.0 |
| 2022-01-21 14:00:00 | AAPL | Stock | 163.765 | 164.3299 | 163.06 | 163.11 | 9183745.0 |
| 2022-01-21 15:00:00 | AAPL | Stock | 163.1195 | 163.885 | 162.3 | 162.41 | 20345515.0 |
| 2022-01-21 16:00:00 | AAPL | Stock | 162.41 | 162.69 | 162.33 | 162.45 | 11515701.0 |
| 2022-01-21 17:00:00 | AAPL | Stock | 162.48 | 162.5 | 161.81 | 162.14 | 153004.0 |
| 2022-01-21 18:00:00 | AAPL | Stock | 162.1 | 162.1001 | 161.62 | 161.77 | 81446.0 |
| 2022-01-21 19:00:00 | AAPL | Stock | 161.66 | 161.76 | 161.5 | 161.62 | 101919.0 |
| 2022-01-21 04:00:00 | MSFT | Stock | 302.46 | 304.0 | 301.26 | 303.7 | 23278.0 |
| 2022-01-21 05:00:00 | MSFT | Stock | 303.47 | 304.0 | 303.47 | 303.55 | 6013.0 |
| 2022-01-21 06:00:00 | MSFT | Stock | 303.24 | 303.24 | 301.83 | 303.0 | 18741.0 |
| 2022-01-21 07:00:00 | MSFT | Stock | 303.0 | 303.01 | 300.96 | 301.0 | 90330.0 |
| 2022-01-21 08:00:00 | MSFT | Stock | 301.7866 | 303.16 | 300.99 | 301.75 | 165027.0 |
| 2022-01-21 09:00:00 | MSFT | Stock | 301.75 | 303.2488 | 297.74 | 299.08 | 6468435.0 |
| 2022-01-21 10:00:00 | MSFT | Stock | 299.11 | 302.6 | 297.62 | 301.2 | 6234560.0 |
| 2022-01-21 11:00:00 | MSFT | Stock | 301.2 | 304.11 | 301.04 | 302.41 | 4621695.0 |
| 2022-01-21 12:00:00 | MSFT | Stock | 302.39 | 303.33 | 300.55 | 301.32 | 2655762.0 |
| 2022-01-21 13:00:00 | MSFT | Stock | 301.28 | 301.97 | 299.2 | 300.465 | 3040141.0 |
| 2022-01-21 14:00:00 | MSFT | Stock | 300.4301 | 301.45 | 298.71 | 298.81 | 2966217.0 |
| 2022-01-21 15:00:00 | MSFT | Stock | 298.85 | 299.65 | 295.61 | 295.76 | 7705184.0 |
| 2022-01-21 16:00:00 | MSFT | Stock | 295.82 | 297.55 | 295.43 | 295.9 | 7957157.0 |
| 2022-01-21 17:00:00 | MSFT | Stock | 295.82 | 296.03 | 294.6 | 295.29 | 69522.0 |
| 2022-01-21 18:00:00 | MSFT | Stock | 295.19 | 296.03 | 294.75 | 294.95 | 743636.0 |
| 2022-01-21 19:00:00 | MSFT | Stock | 294.9 | 296.31 | 294.65 | 296.3 | 102640.0 |
| 2022-01-21 04:00:00 | NVDA | Stock | 23.669 | 23.894 | 23.568 | 23.879 | 306420.0 |
| 2022-01-21 05:00:00 | NVDA | Stock | 23.87 | 23.94 | 23.834 | 23.847 | 59420.0 |
| 2022-01-21 06:00:00 | NVDA | Stock | 23.84 | 23.84 | 23.601 | 23.736 | 198850.0 |
| 2022-01-21 07:00:00 | NVDA | Stock | 23.74 | 23.761 | 23.532 | 23.594 | 1993150.0 |
| 2022-01-21 08:00:00 | NVDA | Stock | 23.685 | 23.763 | 23.5 | 23.7175 | 1916650.0 |
| 2022-01-21 09:00:00 | NVDA | Stock | 23.7215 | 24.104 | 23.398 | 23.6099 | 78252330.0 |
| 2022-01-21 10:00:00 | NVDA | Stock | 23.6051 | 24.2483 | 23.263 | 24.138 | 113344750.0 |
| 2022-01-21 11:00:00 | NVDA | Stock | 24.139 | 24.823 | 23.952 | 24.088 | 83318100.0 |
| 2022-01-21 12:00:00 | NVDA | Stock | 24.075 | 24.324 | 23.761 | 24.008 | 44622140.0 |
| 2022-01-21 13:00:00 | NVDA | Stock | 24.001 | 24.178 | 23.794 | 23.936 | 35962770.0 |
| 2022-01-21 14:00:00 | NVDA | Stock | 23.934 | 24.044 | 23.545 | 23.5661 | 38754400.0 |
| 2022-01-21 15:00:00 | NVDA | Stock | 23.571 | 23.752 | 23.265 | 23.351 | 90021600.0 |
| 2022-01-21 16:00:00 | NVDA | Stock | 23.351 | 23.39 | 23.23 | 23.24 | 26628120.0 |
| 2022-01-21 17:00:00 | NVDA | Stock | 23.24 | 23.374 | 23.12 | 23.135 | 835960.0 |
| 2022-01-21 18:00:00 | NVDA | Stock | 23.15 | 23.198 | 23.102 | 23.102 | 399300.0 |
| 2022-01-21 19:00:00 | NVDA | Stock | 23.115 | 23.15 | 23.051 | 23.125 | 561670.0 |
| 2022-01-21 04:00:00 | AMZN | Stock | 150.8 | 150.8 | 150.6 | 150.6 | 4000.0 |
| 2022-01-21 05:00:00 | AMZN | Stock | 150.8495 | 150.877 | 150.8495 | 150.877 | 5600.0 |
> showing 50 of 67,439 rows — these rows as CSV