PREVIEW / stock_1hour / 2024-04-23
file: by_date/stock_1hour/2024/2024-04-23.parquet size: 1.3 MB rows: 57,877 symbols: 979
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-04-23 04:00:00 | AAPL | Stock | 165.8 | 165.8 | 165.0 | 165.05 | 41408.0 |
| 2024-04-23 05:00:00 | AAPL | Stock | 165.03 | 165.67 | 165.03 | 165.29 | 32652.0 |
| 2024-04-23 06:00:00 | AAPL | Stock | 165.31 | 165.6 | 165.1 | 165.5 | 25214.0 |
| 2024-04-23 07:00:00 | AAPL | Stock | 165.55 | 166.25 | 165.18 | 165.6 | 70929.0 |
| 2024-04-23 08:00:00 | AAPL | Stock | 165.7 | 166.14 | 164.81 | 166.1 | 141520.0 |
| 2024-04-23 09:00:00 | AAPL | Stock | 166.02 | 166.58 | 164.92 | 166.16 | 4686526.0 |
| 2024-04-23 10:00:00 | AAPL | Stock | 166.12 | 166.71 | 165.62 | 166.54 | 6239056.0 |
| 2024-04-23 11:00:00 | AAPL | Stock | 166.55 | 166.98 | 166.245 | 166.359 | 3668961.0 |
| 2024-04-23 12:00:00 | AAPL | Stock | 166.36 | 166.64 | 166.0574 | 166.453 | 3290237.0 |
| 2024-04-23 13:00:00 | AAPL | Stock | 166.4599 | 166.77 | 166.17 | 166.75 | 2289197.0 |
| 2024-04-23 14:00:00 | AAPL | Stock | 166.76 | 166.8668 | 166.66 | 166.78 | 2521256.0 |
| 2024-04-23 15:00:00 | AAPL | Stock | 166.78 | 167.05 | 166.5 | 166.91 | 6567326.0 |
| 2024-04-23 16:00:00 | AAPL | Stock | 166.9 | 167.11 | 166.75 | 167.05 | 6760654.0 |
| 2024-04-23 17:00:00 | AAPL | Stock | 167.03 | 167.26 | 166.85 | 167.18 | 99768.0 |
| 2024-04-23 18:00:00 | AAPL | Stock | 167.01 | 167.01 | 166.55 | 166.8 | 90768.0 |
| 2024-04-23 19:00:00 | AAPL | Stock | 166.76 | 167.16 | 166.49 | 166.94 | 64172.0 |
| 2024-04-23 04:00:00 | MSFT | Stock | 401.35 | 402.92 | 401.35 | 402.51 | 1256.0 |
| 2024-04-23 05:00:00 | MSFT | Stock | 402.26 | 402.52 | 402.13 | 402.13 | 425.0 |
| 2024-04-23 06:00:00 | MSFT | Stock | 402.31 | 402.61 | 402.1 | 402.61 | 2952.0 |
| 2024-04-23 07:00:00 | MSFT | Stock | 402.75 | 403.13 | 402.58 | 402.7 | 13885.0 |
| 2024-04-23 08:00:00 | MSFT | Stock | 402.9799 | 403.7 | 401.71 | 403.56 | 37249.0 |
| 2024-04-23 09:00:00 | MSFT | Stock | 403.7 | 406.16 | 400.96 | 405.945 | 1319620.0 |
| 2024-04-23 10:00:00 | MSFT | Stock | 406.01 | 408.2 | 405.6 | 407.45 | 1446116.0 |
| 2024-04-23 11:00:00 | MSFT | Stock | 407.46 | 407.71 | 405.81 | 406.61 | 831126.0 |
| 2024-04-23 12:00:00 | MSFT | Stock | 406.64 | 407.69 | 406.195 | 407.185 | 635552.0 |
| 2024-04-23 13:00:00 | MSFT | Stock | 407.16 | 407.8 | 406.18 | 407.77 | 536705.0 |
| 2024-04-23 14:00:00 | MSFT | Stock | 407.76 | 407.892 | 407.0 | 407.495 | 510673.0 |
| 2024-04-23 15:00:00 | MSFT | Stock | 407.475 | 407.72 | 406.57 | 407.481 | 1282947.0 |
| 2024-04-23 16:00:00 | MSFT | Stock | 407.45 | 407.77 | 406.56 | 407.56 | 2559907.0 |
| 2024-04-23 17:00:00 | MSFT | Stock | 407.6 | 408.85 | 407.46 | 408.49 | 22363.0 |
| 2024-04-23 18:00:00 | MSFT | Stock | 408.14 | 408.15 | 407.1 | 407.53 | 30106.0 |
| 2024-04-23 19:00:00 | MSFT | Stock | 407.4 | 408.67 | 407.21 | 407.8 | 26729.0 |
| 2024-04-23 04:00:00 | NVDA | Stock | 79.552 | 80.8 | 79.552 | 80.8 | 571440.0 |
| 2024-04-23 05:00:00 | NVDA | Stock | 80.811 | 81.023 | 80.32 | 80.425 | 473800.0 |
| 2024-04-23 06:00:00 | NVDA | Stock | 80.525 | 80.85 | 80.435 | 80.6 | 135640.0 |
| 2024-04-23 07:00:00 | NVDA | Stock | 80.631 | 80.878 | 80.421 | 80.8 | 1070150.0 |
| 2024-04-23 08:00:00 | NVDA | Stock | 80.699 | 80.8756 | 79.44 | 80.54 | 3297430.0 |
| 2024-04-23 09:00:00 | NVDA | Stock | 80.586 | 81.389 | 79.518 | 81.0565 | 55466820.0 |
| 2024-04-23 10:00:00 | NVDA | Stock | 81.074 | 82.757 | 80.775 | 82.357 | 74534480.0 |
| 2024-04-23 11:00:00 | NVDA | Stock | 82.374 | 82.695 | 81.83 | 81.9259 | 40569090.0 |
| 2024-04-23 12:00:00 | NVDA | Stock | 81.943 | 82.496 | 81.461 | 81.78 | 29524930.0 |
| 2024-04-23 13:00:00 | NVDA | Stock | 81.775 | 82.497 | 81.5029 | 82.495 | 26747170.0 |
| 2024-04-23 14:00:00 | NVDA | Stock | 82.4875 | 82.699 | 82.1587 | 82.3841 | 26293100.0 |
| 2024-04-23 15:00:00 | NVDA | Stock | 82.3765 | 82.769 | 82.045 | 82.4769 | 35653690.0 |
| 2024-04-23 16:00:00 | NVDA | Stock | 82.423 | 83.141 | 82.258 | 82.95 | 15786830.0 |
| 2024-04-23 17:00:00 | NVDA | Stock | 82.996 | 83.73 | 82.974 | 83.425 | 1724590.0 |
| 2024-04-23 18:00:00 | NVDA | Stock | 83.42 | 83.8 | 83.323 | 83.79 | 927200.0 |
| 2024-04-23 19:00:00 | NVDA | Stock | 83.782 | 83.88 | 83.702 | 83.851 | 701350.0 |
| 2024-04-23 04:00:00 | AMZN | Stock | 177.6 | 177.65 | 177.33 | 177.51 | 8063.0 |
| 2024-04-23 05:00:00 | AMZN | Stock | 177.47 | 177.86 | 177.39 | 177.53 | 6202.0 |
> showing 50 of 57,877 rows — these rows as CSV