PREVIEW / stock_1hour / 2024-05-21
file: by_date/stock_1hour/2024/2024-05-21.parquet size: 1.3 MB rows: 58,757 symbols: 972
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-05-21 04:00:00 | AAPL | Stock | 191.18 | 191.18 | 190.79 | 190.81 | 8856.0 |
| 2024-05-21 05:00:00 | AAPL | Stock | 190.8 | 190.8 | 190.74 | 190.77 | 2653.0 |
| 2024-05-21 06:00:00 | AAPL | Stock | 190.8 | 191.33 | 190.8 | 191.22 | 11205.0 |
| 2024-05-21 07:00:00 | AAPL | Stock | 191.21 | 191.67 | 191.2 | 191.52 | 15863.0 |
| 2024-05-21 08:00:00 | AAPL | Stock | 191.29 | 191.66 | 191.04 | 191.39 | 54734.0 |
| 2024-05-21 09:00:00 | AAPL | Stock | 191.33 | 192.24 | 190.9201 | 192.2 | 4828739.0 |
| 2024-05-21 10:00:00 | AAPL | Stock | 192.2 | 192.6 | 191.86 | 192.2899 | 4933109.0 |
| 2024-05-21 11:00:00 | AAPL | Stock | 192.2899 | 192.65 | 192.02 | 192.105 | 3055649.0 |
| 2024-05-21 12:00:00 | AAPL | Stock | 192.11 | 192.2188 | 191.78 | 192.1299 | 1952310.0 |
| 2024-05-21 13:00:00 | AAPL | Stock | 192.1271 | 192.53 | 192.0482 | 192.4988 | 2987403.0 |
| 2024-05-21 14:00:00 | AAPL | Stock | 192.5 | 192.63 | 192.33 | 192.605 | 2562254.0 |
| 2024-05-21 15:00:00 | AAPL | Stock | 192.6 | 192.73 | 192.275 | 192.36 | 6245015.0 |
| 2024-05-21 16:00:00 | AAPL | Stock | 192.47 | 192.47 | 192.33 | 192.35 | 6556524.0 |
| 2024-05-21 17:00:00 | AAPL | Stock | 192.36 | 192.44 | 192.34 | 192.4 | 8020.0 |
| 2024-05-21 18:00:00 | AAPL | Stock | 192.4 | 192.62 | 192.39 | 192.59 | 9225.0 |
| 2024-05-21 19:00:00 | AAPL | Stock | 192.62 | 192.68 | 192.35 | 192.48 | 22248.0 |
| 2024-05-21 04:00:00 | MSFT | Stock | 425.67 | 426.25 | 425.66 | 426.02 | 1608.0 |
| 2024-05-21 05:00:00 | MSFT | Stock | 426.2 | 426.35 | 426.2 | 426.35 | 779.0 |
| 2024-05-21 06:00:00 | MSFT | Stock | 426.77 | 427.48 | 426.77 | 427.4 | 2812.0 |
| 2024-05-21 07:00:00 | MSFT | Stock | 427.32 | 427.32 | 426.0 | 426.75 | 14718.0 |
| 2024-05-21 08:00:00 | MSFT | Stock | 426.24 | 427.35 | 424.66 | 426.53 | 31852.0 |
| 2024-05-21 09:00:00 | MSFT | Stock | 426.4 | 428.15 | 424.85 | 427.0345 | 1801932.0 |
| 2024-05-21 10:00:00 | MSFT | Stock | 427.005 | 430.5 | 427.005 | 429.015 | 1969539.0 |
| 2024-05-21 11:00:00 | MSFT | Stock | 429.01 | 432.97 | 428.88 | 431.8702 | 2119369.0 |
| 2024-05-21 12:00:00 | MSFT | Stock | 431.8401 | 431.87 | 429.37 | 429.62 | 1268574.0 |
| 2024-05-21 13:00:00 | MSFT | Stock | 429.59 | 430.81 | 429.3501 | 430.7378 | 960211.0 |
| 2024-05-21 14:00:00 | MSFT | Stock | 430.72 | 430.9145 | 428.93 | 429.17 | 753291.0 |
| 2024-05-21 15:00:00 | MSFT | Stock | 429.14 | 430.13 | 428.7 | 429.07 | 1684455.0 |
| 2024-05-21 16:00:00 | MSFT | Stock | 429.04 | 429.9912 | 428.7 | 429.9 | 3150531.0 |
| 2024-05-21 17:00:00 | MSFT | Stock | 429.69 | 429.9 | 429.59 | 429.6 | 3350.0 |
| 2024-05-21 18:00:00 | MSFT | Stock | 429.4512 | 429.9 | 429.45 | 429.9 | 6477.0 |
| 2024-05-21 19:00:00 | MSFT | Stock | 429.77 | 430.35 | 429.2 | 430.03 | 6660.0 |
| 2024-05-21 04:00:00 | NVDA | Stock | 95.5 | 95.5 | 95.0 | 95.215 | 151660.0 |
| 2024-05-21 05:00:00 | NVDA | Stock | 95.151 | 95.161 | 94.96 | 95.125 | 80070.0 |
| 2024-05-21 06:00:00 | NVDA | Stock | 95.1 | 95.245 | 95.1 | 95.235 | 34720.0 |
| 2024-05-21 07:00:00 | NVDA | Stock | 95.2 | 95.5 | 95.19 | 95.361 | 730660.0 |
| 2024-05-21 08:00:00 | NVDA | Stock | 95.23 | 95.67 | 94.739 | 94.8 | 2318200.0 |
| 2024-05-21 09:00:00 | NVDA | Stock | 94.803 | 94.84 | 93.1572 | 93.5526 | 48248210.0 |
| 2024-05-21 10:00:00 | NVDA | Stock | 93.618 | 94.822 | 93.3035 | 94.784 | 45264980.0 |
| 2024-05-21 11:00:00 | NVDA | Stock | 94.783 | 94.996 | 94.584 | 94.6822 | 25004870.0 |
| 2024-05-21 12:00:00 | NVDA | Stock | 94.685 | 95.287 | 94.644 | 94.718 | 24894060.0 |
| 2024-05-21 13:00:00 | NVDA | Stock | 94.7194 | 94.962 | 94.5673 | 94.95 | 15511970.0 |
| 2024-05-21 14:00:00 | NVDA | Stock | 94.9486 | 95.05 | 94.6028 | 94.697 | 14889790.0 |
| 2024-05-21 15:00:00 | NVDA | Stock | 94.689 | 95.4 | 94.677 | 95.351 | 34037980.0 |
| 2024-05-21 16:00:00 | NVDA | Stock | 95.386 | 95.581 | 95.21 | 95.25 | 17297710.0 |
| 2024-05-21 17:00:00 | NVDA | Stock | 95.249 | 95.327 | 95.215 | 95.25 | 475570.0 |
| 2024-05-21 18:00:00 | NVDA | Stock | 95.246 | 95.35 | 95.23 | 95.3 | 296700.0 |
| 2024-05-21 19:00:00 | NVDA | Stock | 95.3 | 95.396 | 95.272 | 95.335 | 507460.0 |
| 2024-05-21 04:00:00 | AMZN | Stock | 183.84 | 183.84 | 183.57 | 183.63 | 5985.0 |
| 2024-05-21 05:00:00 | AMZN | Stock | 183.59 | 183.65 | 183.53 | 183.59 | 3142.0 |
> showing 50 of 58,757 rows — these rows as CSV