PREVIEW / stock_1hour / 2024-11-21
file: by_date/stock_1hour/2024/2024-11-21.parquet size: 1.4 MB rows: 61,590 symbols: 704
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-21 04:00:00 | AAPL | Stock | 228.2 | 229.01 | 228.11 | 228.6 | 17854.0 |
| 2024-11-21 05:00:00 | AAPL | Stock | 228.52 | 229.0 | 228.5 | 228.88 | 10807.0 |
| 2024-11-21 06:00:00 | AAPL | Stock | 228.8 | 229.96 | 228.8 | 229.66 | 26371.0 |
| 2024-11-21 07:00:00 | AAPL | Stock | 229.43 | 229.97 | 229.09 | 229.35 | 27970.0 |
| 2024-11-21 08:00:00 | AAPL | Stock | 229.95 | 229.95 | 228.02 | 229.63 | 124956.0 |
| 2024-11-21 09:00:00 | AAPL | Stock | 229.6 | 229.93 | 226.83 | 227.0 | 4315417.0 |
| 2024-11-21 10:00:00 | AAPL | Stock | 227.0 | 228.35 | 225.7103 | 228.34 | 4655339.0 |
| 2024-11-21 11:00:00 | AAPL | Stock | 228.34 | 229.12 | 228.07 | 228.8612 | 2915361.0 |
| 2024-11-21 12:00:00 | AAPL | Stock | 228.86 | 230.155 | 228.6 | 229.7833 | 2791603.0 |
| 2024-11-21 13:00:00 | AAPL | Stock | 229.78 | 230.0499 | 229.215 | 229.47 | 1839853.0 |
| 2024-11-21 14:00:00 | AAPL | Stock | 229.47 | 229.67 | 228.99 | 229.38 | 1913345.0 |
| 2024-11-21 15:00:00 | AAPL | Stock | 229.38 | 229.58 | 228.27 | 228.51 | 3927346.0 |
| 2024-11-21 16:00:00 | AAPL | Stock | 228.52 | 228.91 | 228.25 | 228.36 | 6784189.0 |
| 2024-11-21 17:00:00 | AAPL | Stock | 228.37 | 228.75 | 228.25 | 228.35 | 15222.0 |
| 2024-11-21 18:00:00 | AAPL | Stock | 228.32 | 228.56 | 228.11 | 228.2301 | 24304.0 |
| 2024-11-21 19:00:00 | AAPL | Stock | 228.25 | 228.56 | 228.1 | 228.56 | 6874.0 |
| 2024-11-21 04:00:00 | MSFT | Stock | 414.5 | 414.54 | 412.7 | 413.6 | 3573.0 |
| 2024-11-21 05:00:00 | MSFT | Stock | 413.99 | 414.18 | 413.92 | 414.18 | 450.0 |
| 2024-11-21 06:00:00 | MSFT | Stock | 414.18 | 415.25 | 414.18 | 414.96 | 1547.0 |
| 2024-11-21 07:00:00 | MSFT | Stock | 414.98 | 416.44 | 414.98 | 415.63 | 6024.0 |
| 2024-11-21 08:00:00 | MSFT | Stock | 415.52 | 417.52 | 414.7 | 417.01 | 45882.0 |
| 2024-11-21 09:00:00 | MSFT | Stock | 417.15 | 419.97 | 413.64 | 414.045 | 1741522.0 |
| 2024-11-21 10:00:00 | MSFT | Stock | 413.97 | 414.3 | 410.2887 | 413.78 | 1961576.0 |
| 2024-11-21 11:00:00 | MSFT | Stock | 413.84 | 415.6 | 412.67 | 412.925 | 1202548.0 |
| 2024-11-21 12:00:00 | MSFT | Stock | 412.91 | 415.94 | 411.78 | 415.04 | 835127.0 |
| 2024-11-21 13:00:00 | MSFT | Stock | 415.04 | 415.98 | 413.11 | 413.715 | 907846.0 |
| 2024-11-21 14:00:00 | MSFT | Stock | 413.7 | 414.48 | 412.35 | 412.87 | 1028697.0 |
| 2024-11-21 15:00:00 | MSFT | Stock | 412.85 | 414.48 | 412.795 | 412.8 | 1541711.0 |
| 2024-11-21 16:00:00 | MSFT | Stock | 412.87 | 413.69 | 412.4 | 413.1 | 3458354.0 |
| 2024-11-21 17:00:00 | MSFT | Stock | 413.2 | 413.2 | 412.61 | 413.0 | 2317.0 |
| 2024-11-21 18:00:00 | MSFT | Stock | 413.0 | 413.0 | 412.23 | 412.23 | 10450.0 |
| 2024-11-21 19:00:00 | MSFT | Stock | 412.87 | 413.0 | 412.5 | 412.9499 | 2048.0 |
| 2024-11-21 04:00:00 | NVDA | Stock | 142.5 | 143.84 | 139.8 | 141.3 | 1582069.0 |
| 2024-11-21 05:00:00 | NVDA | Stock | 141.32 | 141.83 | 141.04 | 141.83 | 360162.0 |
| 2024-11-21 06:00:00 | NVDA | Stock | 141.76 | 143.67 | 141.76 | 143.63 | 693360.0 |
| 2024-11-21 07:00:00 | NVDA | Stock | 143.6 | 145.0 | 143.3 | 144.43 | 2338382.0 |
| 2024-11-21 08:00:00 | NVDA | Stock | 143.32 | 149.4 | 139.8559 | 147.92 | 12780191.0 |
| 2024-11-21 09:00:00 | NVDA | Stock | 147.91 | 152.89 | 144.34 | 145.68 | 83728959.0 |
| 2024-11-21 10:00:00 | NVDA | Stock | 145.68 | 145.9399 | 140.7 | 144.352 | 66901509.0 |
| 2024-11-21 11:00:00 | NVDA | Stock | 144.36 | 145.455 | 142.89 | 143.6177 | 35104198.0 |
| 2024-11-21 12:00:00 | NVDA | Stock | 143.616 | 145.0 | 143.15 | 144.085 | 24344515.0 |
| 2024-11-21 13:00:00 | NVDA | Stock | 144.09 | 147.5 | 143.87 | 147.345 | 31091869.0 |
| 2024-11-21 14:00:00 | NVDA | Stock | 147.345 | 148.0 | 145.87 | 147.755 | 30408106.0 |
| 2024-11-21 15:00:00 | NVDA | Stock | 147.75 | 148.55 | 146.3 | 146.62 | 36839262.0 |
| 2024-11-21 16:00:00 | NVDA | Stock | 146.62 | 147.0 | 145.9 | 146.12 | 17415312.0 |
| 2024-11-21 17:00:00 | NVDA | Stock | 146.1 | 146.34 | 146.05 | 146.18 | 390557.0 |
| 2024-11-21 18:00:00 | NVDA | Stock | 146.2 | 146.5 | 146.09 | 146.1 | 368964.0 |
| 2024-11-21 19:00:00 | NVDA | Stock | 146.09 | 146.2 | 145.8 | 145.8999 | 417637.0 |
| 2024-11-21 04:00:00 | AMZN | Stock | 202.66 | 202.66 | 202.11 | 202.54 | 3562.0 |
| 2024-11-21 05:00:00 | AMZN | Stock | 202.72 | 203.29 | 202.72 | 203.0 | 14944.0 |
> showing 50 of 61,590 rows — these rows as CSV