PREVIEW / stock_1hour / 2024-06-28
file: by_date/stock_1hour/2024/2024-06-28.parquet size: 1.3 MB rows: 58,587 symbols: 908
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-06-28 04:00:00 | AAPL | Stock | 214.12 | 214.93 | 214.12 | 214.69 | 6712.0 |
| 2024-06-28 05:00:00 | AAPL | Stock | 214.68 | 216.37 | 214.68 | 216.32 | 48038.0 |
| 2024-06-28 06:00:00 | AAPL | Stock | 216.3 | 216.3 | 215.96 | 216.15 | 19595.0 |
| 2024-06-28 07:00:00 | AAPL | Stock | 216.11 | 216.259 | 215.5 | 215.92 | 68429.0 |
| 2024-06-28 08:00:00 | AAPL | Stock | 215.8 | 216.26 | 214.69 | 215.839 | 296904.0 |
| 2024-06-28 09:00:00 | AAPL | Stock | 215.8 | 216.0873 | 213.5703 | 214.325 | 6637806.0 |
| 2024-06-28 10:00:00 | AAPL | Stock | 214.34 | 215.51 | 213.93 | 214.37 | 6992209.0 |
| 2024-06-28 11:00:00 | AAPL | Stock | 214.36 | 214.73 | 213.77 | 214.19 | 4937191.0 |
| 2024-06-28 12:00:00 | AAPL | Stock | 214.185 | 214.37 | 213.27 | 213.955 | 4447720.0 |
| 2024-06-28 13:00:00 | AAPL | Stock | 213.95 | 214.53 | 213.62 | 213.92 | 3199632.0 |
| 2024-06-28 14:00:00 | AAPL | Stock | 213.92 | 214.08 | 213.08 | 213.145 | 3561685.0 |
| 2024-06-28 15:00:00 | AAPL | Stock | 213.15 | 213.61 | 210.3 | 210.61 | 13272222.0 |
| 2024-06-28 16:00:00 | AAPL | Stock | 210.63 | 211.45 | 210.55 | 211.23 | 25289876.0 |
| 2024-06-28 17:00:00 | AAPL | Stock | 211.2107 | 211.3524 | 210.62 | 211.18 | 119171.0 |
| 2024-06-28 18:00:00 | AAPL | Stock | 211.2 | 211.23 | 211.1301 | 211.19 | 9244.0 |
| 2024-06-28 19:00:00 | AAPL | Stock | 211.19 | 211.7 | 211.0996 | 211.66 | 40939.0 |
| 2024-06-28 04:00:00 | MSFT | Stock | 453.7 | 453.7 | 453.7 | 453.7 | 884.0 |
| 2024-06-28 05:00:00 | MSFT | Stock | 454.34 | 455.0 | 454.33 | 454.95 | 1245.0 |
| 2024-06-28 06:00:00 | MSFT | Stock | 454.47 | 454.47 | 454.25 | 454.3 | 622.0 |
| 2024-06-28 07:00:00 | MSFT | Stock | 454.26 | 454.33 | 453.97 | 454.17 | 2813.0 |
| 2024-06-28 08:00:00 | MSFT | Stock | 454.38 | 454.9 | 452.0 | 452.28 | 43628.0 |
| 2024-06-28 09:00:00 | MSFT | Stock | 452.17 | 453.9 | 451.605 | 453.88 | 1174149.0 |
| 2024-06-28 10:00:00 | MSFT | Stock | 453.9 | 455.38 | 453.35 | 454.055 | 1402174.0 |
| 2024-06-28 11:00:00 | MSFT | Stock | 454.01 | 454.11 | 452.5 | 453.49 | 991549.0 |
| 2024-06-28 12:00:00 | MSFT | Stock | 453.48 | 453.6999 | 452.14 | 453.56 | 938628.0 |
| 2024-06-28 13:00:00 | MSFT | Stock | 453.54 | 454.19 | 452.86 | 453.06 | 556958.0 |
| 2024-06-28 14:00:00 | MSFT | Stock | 453.03 | 454.1297 | 452.8 | 452.95 | 672792.0 |
| 2024-06-28 15:00:00 | MSFT | Stock | 452.9699 | 453.145 | 446.41 | 446.82 | 4581010.0 |
| 2024-06-28 16:00:00 | MSFT | Stock | 446.79 | 448.84 | 446.75 | 448.69 | 10611279.0 |
| 2024-06-28 17:00:00 | MSFT | Stock | 448.7 | 448.85 | 447.91 | 448.0 | 20441.0 |
| 2024-06-28 18:00:00 | MSFT | Stock | 448.25 | 448.34 | 447.61 | 447.61 | 5880.0 |
| 2024-06-28 19:00:00 | MSFT | Stock | 447.75 | 447.8485 | 447.01 | 447.35 | 13335.0 |
| 2024-06-28 04:00:00 | NVDA | Stock | 124.68 | 124.98 | 124.46 | 124.81 | 193958.0 |
| 2024-06-28 05:00:00 | NVDA | Stock | 124.83 | 125.0 | 124.6 | 124.7 | 145602.0 |
| 2024-06-28 06:00:00 | NVDA | Stock | 124.68 | 124.88 | 124.55 | 124.76 | 105375.0 |
| 2024-06-28 07:00:00 | NVDA | Stock | 124.71 | 125.16 | 124.61 | 125.04 | 739878.0 |
| 2024-06-28 08:00:00 | NVDA | Stock | 124.9 | 125.49 | 124.5 | 124.5999 | 3200133.0 |
| 2024-06-28 09:00:00 | NVDA | Stock | 124.58 | 126.2 | 123.42 | 126.165 | 35748213.0 |
| 2024-06-28 10:00:00 | NVDA | Stock | 126.18 | 127.71 | 125.55 | 126.01 | 52493693.0 |
| 2024-06-28 11:00:00 | NVDA | Stock | 126.0 | 126.49 | 125.11 | 126.1085 | 29501496.0 |
| 2024-06-28 12:00:00 | NVDA | Stock | 126.12 | 126.16 | 122.89 | 123.6599 | 36108840.0 |
| 2024-06-28 13:00:00 | NVDA | Stock | 123.6542 | 124.51 | 123.19 | 124.205 | 21343254.0 |
| 2024-06-28 14:00:00 | NVDA | Stock | 124.2 | 124.59 | 123.82 | 124.26 | 17760202.0 |
| 2024-06-28 15:00:00 | NVDA | Stock | 124.26 | 124.69 | 122.75 | 123.41 | 37408360.0 |
| 2024-06-28 16:00:00 | NVDA | Stock | 123.8 | 123.89 | 123.35 | 123.7802 | 41405481.0 |
| 2024-06-28 17:00:00 | NVDA | Stock | 123.78 | 123.9 | 123.54 | 123.7801 | 325594.0 |
| 2024-06-28 18:00:00 | NVDA | Stock | 123.78 | 123.84 | 123.67 | 123.67 | 217872.0 |
| 2024-06-28 19:00:00 | NVDA | Stock | 123.69 | 123.83 | 123.67 | 123.7501 | 315923.0 |
| 2024-06-28 04:00:00 | AMZN | Stock | 198.65 | 198.87 | 198.59 | 198.62 | 20159.0 |
| 2024-06-28 05:00:00 | AMZN | Stock | 198.7 | 198.76 | 198.36 | 198.65 | 23735.0 |
> showing 50 of 58,587 rows — these rows as CSV