PREVIEW / stock_1hour / 2024-11-19
file: by_date/stock_1hour/2024/2024-11-19.parquet size: 1.4 MB rows: 61,866 symbols: 707
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-11-19 04:00:00 | AAPL | Stock | 228.08 | 228.19 | 226.73 | 227.05 | 25022.0 |
| 2024-11-19 05:00:00 | AAPL | Stock | 227.01 | 227.7 | 226.95 | 227.69 | 8500.0 |
| 2024-11-19 06:00:00 | AAPL | Stock | 227.62 | 227.76 | 227.5 | 227.73 | 3690.0 |
| 2024-11-19 07:00:00 | AAPL | Stock | 227.79 | 228.22 | 227.0 | 227.84 | 34496.0 |
| 2024-11-19 08:00:00 | AAPL | Stock | 227.99 | 228.87 | 225.87 | 225.87 | 71959.0 |
| 2024-11-19 09:00:00 | AAPL | Stock | 225.89 | 228.55 | 225.38 | 228.435 | 3217100.0 |
| 2024-11-19 10:00:00 | AAPL | Stock | 228.43 | 229.45 | 228.03 | 229.05 | 2313977.0 |
| 2024-11-19 11:00:00 | AAPL | Stock | 229.06 | 229.6799 | 229.05 | 229.34 | 1775313.0 |
| 2024-11-19 12:00:00 | AAPL | Stock | 229.34 | 230.16 | 229.19 | 229.4 | 2549091.0 |
| 2024-11-19 13:00:00 | AAPL | Stock | 229.39 | 229.965 | 229.24 | 229.935 | 1462240.0 |
| 2024-11-19 14:00:00 | AAPL | Stock | 229.94 | 229.99 | 228.6527 | 228.79 | 1937133.0 |
| 2024-11-19 15:00:00 | AAPL | Stock | 228.78 | 228.88 | 227.72 | 228.3 | 4089397.0 |
| 2024-11-19 16:00:00 | AAPL | Stock | 228.28 | 228.4 | 227.99 | 228.2 | 7470853.0 |
| 2024-11-19 17:00:00 | AAPL | Stock | 228.18 | 228.27 | 228.0 | 228.05 | 13732.0 |
| 2024-11-19 18:00:00 | AAPL | Stock | 228.05 | 228.28 | 228.0 | 228.0 | 10054.0 |
| 2024-11-19 19:00:00 | AAPL | Stock | 228.1 | 228.74 | 228.08 | 228.5 | 15296.0 |
| 2024-11-19 04:00:00 | MSFT | Stock | 414.95 | 415.95 | 413.0 | 414.96 | 8545.0 |
| 2024-11-19 05:00:00 | MSFT | Stock | 414.3 | 414.83 | 414.12 | 414.81 | 2092.0 |
| 2024-11-19 06:00:00 | MSFT | Stock | 414.69 | 414.87 | 414.45 | 414.87 | 911.0 |
| 2024-11-19 07:00:00 | MSFT | Stock | 414.85 | 415.12 | 414.5 | 414.98 | 6340.0 |
| 2024-11-19 08:00:00 | MSFT | Stock | 414.55 | 416.43 | 412.11 | 412.3 | 39747.0 |
| 2024-11-19 09:00:00 | MSFT | Stock | 412.18 | 414.26 | 411.37 | 412.79 | 1450749.0 |
| 2024-11-19 10:00:00 | MSFT | Stock | 412.84 | 413.92 | 411.64 | 413.2285 | 1152341.0 |
| 2024-11-19 11:00:00 | MSFT | Stock | 413.215 | 415.39 | 412.68 | 414.775 | 1076703.0 |
| 2024-11-19 12:00:00 | MSFT | Stock | 414.755 | 415.84 | 414.14 | 415.68 | 563121.0 |
| 2024-11-19 13:00:00 | MSFT | Stock | 415.665 | 417.94 | 415.39 | 417.6794 | 693653.0 |
| 2024-11-19 14:00:00 | MSFT | Stock | 417.7 | 417.86 | 415.46 | 415.98 | 644543.0 |
| 2024-11-19 15:00:00 | MSFT | Stock | 415.96 | 417.81 | 415.65 | 417.63 | 1254158.0 |
| 2024-11-19 16:00:00 | MSFT | Stock | 417.79 | 418.0 | 416.6 | 417.0073 | 3189824.0 |
| 2024-11-19 17:00:00 | MSFT | Stock | 417.02 | 417.2799 | 416.9 | 416.9828 | 4351.0 |
| 2024-11-19 18:00:00 | MSFT | Stock | 417.32 | 417.89 | 417.32 | 417.73 | 3010.0 |
| 2024-11-19 19:00:00 | MSFT | Stock | 417.7 | 418.02 | 417.31 | 418.0 | 8997.0 |
| 2024-11-19 04:00:00 | NVDA | Stock | 141.01 | 142.59 | 140.7 | 141.31 | 872059.0 |
| 2024-11-19 05:00:00 | NVDA | Stock | 141.26 | 141.83 | 141.2 | 141.48 | 199823.0 |
| 2024-11-19 06:00:00 | NVDA | Stock | 141.51 | 142.07 | 141.25 | 141.7 | 270047.0 |
| 2024-11-19 07:00:00 | NVDA | Stock | 141.69 | 142.57 | 141.55 | 142.18 | 862490.0 |
| 2024-11-19 08:00:00 | NVDA | Stock | 142.16 | 142.58 | 140.01 | 140.24 | 3106879.0 |
| 2024-11-19 09:00:00 | NVDA | Stock | 140.23 | 143.55 | 140.14 | 142.33 | 30588695.0 |
| 2024-11-19 10:00:00 | NVDA | Stock | 142.33 | 144.4 | 141.705 | 144.2999 | 26206671.0 |
| 2024-11-19 11:00:00 | NVDA | Stock | 144.3 | 144.55 | 143.36 | 143.4 | 18562017.0 |
| 2024-11-19 12:00:00 | NVDA | Stock | 143.41 | 143.97 | 143.16 | 143.9601 | 13140420.0 |
| 2024-11-19 13:00:00 | NVDA | Stock | 143.96 | 145.525 | 143.83 | 145.415 | 19175918.0 |
| 2024-11-19 14:00:00 | NVDA | Stock | 145.415 | 146.92 | 145.33 | 146.5501 | 22958847.0 |
| 2024-11-19 15:00:00 | NVDA | Stock | 146.5409 | 147.13 | 146.13 | 147.0 | 30294963.0 |
| 2024-11-19 16:00:00 | NVDA | Stock | 147.01 | 147.66 | 141.9251 | 147.12 | 24768794.0 |
| 2024-11-19 17:00:00 | NVDA | Stock | 147.16 | 147.18 | 146.75 | 146.97 | 654603.0 |
| 2024-11-19 18:00:00 | NVDA | Stock | 146.97 | 147.6 | 146.89 | 147.48 | 619850.0 |
| 2024-11-19 19:00:00 | NVDA | Stock | 147.48 | 147.84 | 147.42 | 147.69 | 749013.0 |
| 2024-11-19 04:00:00 | AMZN | Stock | 201.66 | 202.32 | 200.54 | 200.9 | 13627.0 |
| 2024-11-19 05:00:00 | AMZN | Stock | 200.84 | 201.58 | 200.84 | 201.58 | 8298.0 |
> showing 50 of 61,866 rows — these rows as CSV