PREVIEW / stock_1hour / 2024-08-30
file: by_date/stock_1hour/2024/2024-08-30.parquet size: 1.3 MB rows: 57,494 symbols: 826
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-08-30 04:00:00 | AAPL | Stock | 230.55 | 231.09 | 230.55 | 230.64 | 11335.0 |
| 2024-08-30 05:00:00 | AAPL | Stock | 230.68 | 230.89 | 230.64 | 230.89 | 8869.0 |
| 2024-08-30 06:00:00 | AAPL | Stock | 230.85 | 231.29 | 230.8 | 231.27 | 16196.0 |
| 2024-08-30 07:00:00 | AAPL | Stock | 231.29 | 231.29 | 230.91 | 230.99 | 18147.0 |
| 2024-08-30 08:00:00 | AAPL | Stock | 231.3 | 231.75 | 229.88 | 230.6019 | 182807.0 |
| 2024-08-30 09:00:00 | AAPL | Stock | 230.67 | 230.84 | 228.81 | 229.07 | 4491019.0 |
| 2024-08-30 10:00:00 | AAPL | Stock | 229.1 | 230.01 | 228.5401 | 228.69 | 4264461.0 |
| 2024-08-30 11:00:00 | AAPL | Stock | 228.7 | 229.0 | 227.545 | 228.62 | 3208347.0 |
| 2024-08-30 12:00:00 | AAPL | Stock | 228.61 | 228.875 | 227.48 | 228.36 | 2338787.0 |
| 2024-08-30 13:00:00 | AAPL | Stock | 228.37 | 228.72 | 227.6793 | 227.76 | 1562704.0 |
| 2024-08-30 14:00:00 | AAPL | Stock | 227.77 | 228.69 | 227.66 | 228.56 | 2229074.0 |
| 2024-08-30 15:00:00 | AAPL | Stock | 228.56 | 229.85 | 228.24 | 228.86 | 7161874.0 |
| 2024-08-30 16:00:00 | AAPL | Stock | 229.04 | 229.23 | 228.65 | 228.9801 | 16920948.0 |
| 2024-08-30 17:00:00 | AAPL | Stock | 229.0 | 229.16 | 229.0 | 229.15 | 18946.0 |
| 2024-08-30 18:00:00 | AAPL | Stock | 229.09 | 229.15 | 229.0 | 229.15 | 13482.0 |
| 2024-08-30 19:00:00 | AAPL | Stock | 229.14 | 229.1991 | 229.0421 | 229.1114 | 10832.0 |
| 2024-08-30 04:00:00 | MSFT | Stock | 415.52 | 416.4 | 415.52 | 416.4 | 1545.0 |
| 2024-08-30 05:00:00 | MSFT | Stock | 416.59 | 416.62 | 416.25 | 416.35 | 2071.0 |
| 2024-08-30 06:00:00 | MSFT | Stock | 416.17 | 416.3 | 415.9 | 416.3 | 3032.0 |
| 2024-08-30 07:00:00 | MSFT | Stock | 416.72 | 416.73 | 415.83 | 415.88 | 5799.0 |
| 2024-08-30 08:00:00 | MSFT | Stock | 416.5 | 416.7 | 414.152 | 415.18 | 33645.0 |
| 2024-08-30 09:00:00 | MSFT | Stock | 415.07 | 417.02 | 414.19 | 416.625 | 1030325.0 |
| 2024-08-30 10:00:00 | MSFT | Stock | 416.69 | 417.39 | 414.43 | 414.43 | 734731.0 |
| 2024-08-30 11:00:00 | MSFT | Stock | 414.43 | 415.6 | 413.95 | 414.8 | 759902.0 |
| 2024-08-30 12:00:00 | MSFT | Stock | 414.8 | 414.845 | 412.13 | 413.92 | 709865.0 |
| 2024-08-30 13:00:00 | MSFT | Stock | 413.95 | 414.67 | 412.3212 | 412.4203 | 565430.0 |
| 2024-08-30 14:00:00 | MSFT | Stock | 412.46 | 413.825 | 412.19 | 413.79 | 556089.0 |
| 2024-08-30 15:00:00 | MSFT | Stock | 413.75 | 417.45 | 413.24 | 417.12 | 2355805.0 |
| 2024-08-30 16:00:00 | MSFT | Stock | 416.91 | 417.86 | 416.66 | 416.66 | 8925559.0 |
| 2024-08-30 17:00:00 | MSFT | Stock | 416.85 | 417.14 | 416.85 | 417.0 | 187123.0 |
| 2024-08-30 18:00:00 | MSFT | Stock | 416.83 | 417.12 | 416.8 | 416.902 | 1573.0 |
| 2024-08-30 19:00:00 | MSFT | Stock | 417.14 | 417.4 | 417.0 | 417.2 | 3618.0 |
| 2024-08-30 04:00:00 | NVDA | Stock | 119.46 | 119.65 | 118.94 | 119.4 | 379201.0 |
| 2024-08-30 05:00:00 | NVDA | Stock | 119.4 | 119.74 | 119.4 | 119.73 | 193245.0 |
| 2024-08-30 06:00:00 | NVDA | Stock | 119.71 | 119.75 | 119.0 | 119.42 | 291224.0 |
| 2024-08-30 07:00:00 | NVDA | Stock | 119.4 | 119.79 | 118.52 | 118.64 | 859170.0 |
| 2024-08-30 08:00:00 | NVDA | Stock | 119.45 | 119.58 | 118.39 | 118.6 | 3478359.0 |
| 2024-08-30 09:00:00 | NVDA | Stock | 118.6 | 121.16 | 118.45 | 120.9186 | 47516521.0 |
| 2024-08-30 10:00:00 | NVDA | Stock | 120.9171 | 121.75 | 118.29 | 118.4806 | 58519723.0 |
| 2024-08-30 11:00:00 | NVDA | Stock | 118.485 | 118.9587 | 117.22 | 118.2494 | 42093092.0 |
| 2024-08-30 12:00:00 | NVDA | Stock | 118.23 | 118.89 | 117.725 | 118.4701 | 26884091.0 |
| 2024-08-30 13:00:00 | NVDA | Stock | 118.47 | 118.71 | 118.0205 | 118.17 | 18496814.0 |
| 2024-08-30 14:00:00 | NVDA | Stock | 118.16 | 119.23 | 117.98 | 119.03 | 21007958.0 |
| 2024-08-30 15:00:00 | NVDA | Stock | 119.03 | 119.62 | 118.31 | 119.36 | 36066985.0 |
| 2024-08-30 16:00:00 | NVDA | Stock | 119.38 | 119.65 | 119.05 | 119.2398 | 31064269.0 |
| 2024-08-30 17:00:00 | NVDA | Stock | 119.24 | 119.2695 | 119.15 | 119.22 | 371229.0 |
| 2024-08-30 18:00:00 | NVDA | Stock | 119.2 | 119.21 | 119.05 | 119.15 | 245712.0 |
| 2024-08-30 19:00:00 | NVDA | Stock | 119.1507 | 119.29 | 119.15 | 119.23 | 319406.0 |
| 2024-08-30 04:00:00 | AMZN | Stock | 173.25 | 173.31 | 173.11 | 173.18 | 4582.0 |
| 2024-08-30 05:00:00 | AMZN | Stock | 173.25 | 173.56 | 173.18 | 173.55 | 7329.0 |
> showing 50 of 57,494 rows — these rows as CSV