PREVIEW / stock_1hour / 2024-07-10
file: by_date/stock_1hour/2024/2024-07-10.parquet size: 1.3 MB rows: 58,950 symbols: 894
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 |
|---|---|---|---|---|---|---|---|
| 2024-07-10 04:00:00 | AAPL | Stock | 229.11 | 229.11 | 228.65 | 229.11 | 10245.0 |
| 2024-07-10 05:00:00 | AAPL | Stock | 229.21 | 229.35 | 229.08 | 229.12 | 5157.0 |
| 2024-07-10 06:00:00 | AAPL | Stock | 229.13 | 230.0 | 229.12 | 229.55 | 25461.0 |
| 2024-07-10 07:00:00 | AAPL | Stock | 229.42 | 229.9 | 229.4 | 229.7 | 18809.0 |
| 2024-07-10 08:00:00 | AAPL | Stock | 229.57 | 229.88 | 228.83 | 229.55 | 198548.0 |
| 2024-07-10 09:00:00 | AAPL | Stock | 229.56 | 231.38 | 229.0 | 231.3013 | 7613071.0 |
| 2024-07-10 10:00:00 | AAPL | Stock | 231.31 | 231.722 | 230.17 | 230.2872 | 7242388.0 |
| 2024-07-10 11:00:00 | AAPL | Stock | 230.29 | 231.395 | 230.105 | 231.28 | 3814013.0 |
| 2024-07-10 12:00:00 | AAPL | Stock | 231.29 | 232.74 | 230.93 | 231.324 | 9495414.0 |
| 2024-07-10 13:00:00 | AAPL | Stock | 231.32 | 232.15 | 230.71 | 231.96 | 4800806.0 |
| 2024-07-10 14:00:00 | AAPL | Stock | 231.965 | 232.19 | 231.6101 | 232.155 | 2946907.0 |
| 2024-07-10 15:00:00 | AAPL | Stock | 232.145 | 233.08 | 231.63 | 232.91 | 7961381.0 |
| 2024-07-10 16:00:00 | AAPL | Stock | 232.98 | 233.0 | 232.53 | 232.55 | 7653671.0 |
| 2024-07-10 17:00:00 | AAPL | Stock | 232.54 | 232.98 | 232.5 | 232.6742 | 88335.0 |
| 2024-07-10 18:00:00 | AAPL | Stock | 232.6802 | 232.83 | 232.32 | 232.5018 | 29296.0 |
| 2024-07-10 19:00:00 | AAPL | Stock | 232.5 | 232.55 | 232.31 | 232.37 | 25011.0 |
| 2024-07-10 04:00:00 | MSFT | Stock | 461.0 | 462.3 | 461.0 | 462.29 | 3337.0 |
| 2024-07-10 05:00:00 | MSFT | Stock | 462.31 | 462.31 | 461.8 | 461.8 | 3272.0 |
| 2024-07-10 06:00:00 | MSFT | Stock | 461.58 | 461.65 | 461.58 | 461.6 | 864.0 |
| 2024-07-10 07:00:00 | MSFT | Stock | 461.51 | 461.65 | 460.61 | 461.2 | 7843.0 |
| 2024-07-10 08:00:00 | MSFT | Stock | 461.6 | 462.21 | 460.7 | 461.24 | 29652.0 |
| 2024-07-10 09:00:00 | MSFT | Stock | 461.2 | 462.5 | 458.855 | 462.5 | 1300320.0 |
| 2024-07-10 10:00:00 | MSFT | Stock | 462.545 | 463.62 | 459.6 | 460.73 | 1625894.0 |
| 2024-07-10 11:00:00 | MSFT | Stock | 460.815 | 461.87 | 459.6701 | 460.6 | 893126.0 |
| 2024-07-10 12:00:00 | MSFT | Stock | 460.55 | 464.126 | 459.91 | 464.07 | 913725.0 |
| 2024-07-10 13:00:00 | MSFT | Stock | 464.03 | 465.1 | 462.68 | 463.98 | 942835.0 |
| 2024-07-10 14:00:00 | MSFT | Stock | 463.944 | 465.25 | 463.66 | 465.02 | 660410.0 |
| 2024-07-10 15:00:00 | MSFT | Stock | 464.95 | 466.46 | 463.75 | 466.38 | 1478592.0 |
| 2024-07-10 16:00:00 | MSFT | Stock | 466.05 | 466.4 | 462.6162 | 466.3 | 4552529.0 |
| 2024-07-10 17:00:00 | MSFT | Stock | 466.21 | 466.38 | 466.03 | 466.24 | 6114.0 |
| 2024-07-10 18:00:00 | MSFT | Stock | 466.25 | 466.39 | 465.8801 | 465.8801 | 4983.0 |
| 2024-07-10 19:00:00 | MSFT | Stock | 466.0 | 466.25 | 465.9614 | 466.02 | 9337.0 |
| 2024-07-10 04:00:00 | NVDA | Stock | 132.35 | 133.0 | 132.05 | 132.77 | 338874.0 |
| 2024-07-10 05:00:00 | NVDA | Stock | 132.78 | 132.92 | 132.51 | 132.73 | 155188.0 |
| 2024-07-10 06:00:00 | NVDA | Stock | 132.73 | 132.95 | 132.6 | 132.92 | 203375.0 |
| 2024-07-10 07:00:00 | NVDA | Stock | 132.87 | 133.59 | 132.15 | 133.43 | 1390577.0 |
| 2024-07-10 08:00:00 | NVDA | Stock | 133.42 | 134.38 | 132.01 | 133.92 | 4509913.0 |
| 2024-07-10 09:00:00 | NVDA | Stock | 133.92 | 134.23 | 132.42 | 133.24 | 35337276.0 |
| 2024-07-10 10:00:00 | NVDA | Stock | 133.24 | 134.78 | 132.66 | 134.0301 | 43681659.0 |
| 2024-07-10 11:00:00 | NVDA | Stock | 134.03 | 134.49 | 133.3997 | 134.3699 | 21154970.0 |
| 2024-07-10 12:00:00 | NVDA | Stock | 134.3795 | 135.09 | 134.13 | 134.88 | 23745383.0 |
| 2024-07-10 13:00:00 | NVDA | Stock | 134.875 | 134.94 | 134.1 | 134.59 | 16460623.0 |
| 2024-07-10 14:00:00 | NVDA | Stock | 134.59 | 134.69 | 133.83 | 134.3599 | 14973977.0 |
| 2024-07-10 15:00:00 | NVDA | Stock | 134.35 | 135.1 | 134.1 | 134.82 | 27007125.0 |
| 2024-07-10 16:00:00 | NVDA | Stock | 134.84 | 135.75 | 134.1945 | 135.7 | 20539827.0 |
| 2024-07-10 17:00:00 | NVDA | Stock | 135.7 | 135.75 | 134.91 | 135.66 | 6302634.0 |
| 2024-07-10 18:00:00 | NVDA | Stock | 135.65 | 135.68 | 135.36 | 135.53 | 425530.0 |
| 2024-07-10 19:00:00 | NVDA | Stock | 135.51 | 135.65 | 135.2 | 135.6 | 688492.0 |
| 2024-07-10 04:00:00 | AMZN | Stock | 199.69 | 199.96 | 199.55 | 199.96 | 8227.0 |
| 2024-07-10 05:00:00 | AMZN | Stock | 199.9 | 200.11 | 199.9 | 200.11 | 6057.0 |
> showing 50 of 58,950 rows — these rows as CSV