PREVIEW / stock_1hour / 2022-04-25
file: by_date/stock_1hour/2022/2022-04-25.parquet size: 1.4 MB rows: 65,205 symbols: 2,487
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 |
|---|---|---|---|---|---|---|---|
| 2022-04-25 04:00:00 | AAPL | Stock | 160.99 | 161.39 | 160.11 | 160.37 | 63066.0 |
| 2022-04-25 05:00:00 | AAPL | Stock | 160.37 | 160.54 | 159.61 | 160.12 | 91549.0 |
| 2022-04-25 06:00:00 | AAPL | Stock | 160.2 | 160.5 | 159.84 | 160.19 | 30316.0 |
| 2022-04-25 07:00:00 | AAPL | Stock | 160.33 | 160.59 | 159.15 | 159.97 | 239138.0 |
| 2022-04-25 08:00:00 | AAPL | Stock | 159.97 | 161.49 | 159.21 | 161.41 | 1299967.0 |
| 2022-04-25 09:00:00 | AAPL | Stock | 161.33 | 161.45 | 159.07 | 159.36 | 13685048.0 |
| 2022-04-25 10:00:00 | AAPL | Stock | 159.37 | 161.78 | 159.0 | 159.759 | 12384912.0 |
| 2022-04-25 11:00:00 | AAPL | Stock | 159.76 | 160.63 | 158.46 | 158.88 | 9060778.0 |
| 2022-04-25 12:00:00 | AAPL | Stock | 158.87 | 160.56 | 158.6 | 159.69 | 8164498.0 |
| 2022-04-25 13:00:00 | AAPL | Stock | 159.68 | 160.64 | 159.27 | 159.875 | 6463858.0 |
| 2022-04-25 14:00:00 | AAPL | Stock | 159.86 | 161.947 | 159.41 | 161.43 | 8850440.0 |
| 2022-04-25 15:00:00 | AAPL | Stock | 161.42 | 163.17 | 160.4539 | 162.88 | 14265631.0 |
| 2022-04-25 16:00:00 | AAPL | Stock | 162.88 | 163.3 | 162.88 | 163.09 | 7930055.0 |
| 2022-04-25 17:00:00 | AAPL | Stock | 163.09 | 163.25 | 162.88 | 163.24 | 69875.0 |
| 2022-04-25 18:00:00 | AAPL | Stock | 163.13 | 163.13 | 162.85 | 163.0 | 33739.0 |
| 2022-04-25 19:00:00 | AAPL | Stock | 163.06 | 163.23 | 162.87 | 162.9 | 35710.0 |
| 2022-04-25 04:00:00 | MSFT | Stock | 271.4 | 272.99 | 271.4 | 271.5 | 11559.0 |
| 2022-04-25 05:00:00 | MSFT | Stock | 271.91 | 272.14 | 271.3 | 272.0 | 9097.0 |
| 2022-04-25 06:00:00 | MSFT | Stock | 271.91 | 272.0 | 271.4 | 271.62 | 3779.0 |
| 2022-04-25 07:00:00 | MSFT | Stock | 271.78 | 271.8 | 270.75 | 271.56 | 25986.0 |
| 2022-04-25 08:00:00 | MSFT | Stock | 271.7 | 273.43 | 270.0 | 273.31 | 200739.0 |
| 2022-04-25 09:00:00 | MSFT | Stock | 273.4 | 275.18 | 270.77 | 272.59 | 3644409.0 |
| 2022-04-25 10:00:00 | MSFT | Stock | 272.5837 | 278.02 | 272.47 | 275.5702 | 3798440.0 |
| 2022-04-25 11:00:00 | MSFT | Stock | 275.58 | 276.05 | 272.82 | 274.015 | 2465479.0 |
| 2022-04-25 12:00:00 | MSFT | Stock | 273.98 | 277.15 | 273.56 | 275.8 | 1960824.0 |
| 2022-04-25 13:00:00 | MSFT | Stock | 275.83 | 278.14 | 275.02 | 275.98 | 1793415.0 |
| 2022-04-25 14:00:00 | MSFT | Stock | 275.96 | 279.4181 | 275.36 | 278.21 | 2337927.0 |
| 2022-04-25 15:00:00 | MSFT | Stock | 278.14 | 281.11 | 276.571 | 280.76 | 4543802.0 |
| 2022-04-25 16:00:00 | MSFT | Stock | 280.72 | 281.25 | 280.4507 | 280.73 | 5034372.0 |
| 2022-04-25 17:00:00 | MSFT | Stock | 280.6999 | 280.9999 | 280.5 | 280.94 | 27402.0 |
| 2022-04-25 18:00:00 | MSFT | Stock | 280.8 | 280.95 | 280.17 | 280.9 | 39403.0 |
| 2022-04-25 19:00:00 | MSFT | Stock | 280.8 | 280.98 | 280.35 | 280.7299 | 12103.0 |
| 2022-04-25 04:00:00 | NVDA | Stock | 19.3 | 19.448 | 19.251 | 19.4 | 341170.0 |
| 2022-04-25 05:00:00 | NVDA | Stock | 19.374 | 19.43 | 19.274 | 19.316 | 220970.0 |
| 2022-04-25 06:00:00 | NVDA | Stock | 19.344 | 19.365 | 19.278 | 19.3 | 206820.0 |
| 2022-04-25 07:00:00 | NVDA | Stock | 19.302 | 19.302 | 19.011 | 19.16 | 1352850.0 |
| 2022-04-25 08:00:00 | NVDA | Stock | 19.161 | 19.5637 | 19.025 | 19.289 | 2514300.0 |
| 2022-04-25 09:00:00 | NVDA | Stock | 19.29 | 19.65 | 19.096 | 19.235 | 85583690.0 |
| 2022-04-25 10:00:00 | NVDA | Stock | 19.238 | 19.847 | 19.141 | 19.463 | 98671590.0 |
| 2022-04-25 11:00:00 | NVDA | Stock | 19.467 | 19.605 | 19.2564 | 19.272 | 68275830.0 |
| 2022-04-25 12:00:00 | NVDA | Stock | 19.275 | 19.626 | 19.2025 | 19.38 | 58810750.0 |
| 2022-04-25 13:00:00 | NVDA | Stock | 19.3869 | 19.585 | 19.312 | 19.452 | 47807210.0 |
| 2022-04-25 14:00:00 | NVDA | Stock | 19.451 | 19.755 | 19.373 | 19.597 | 51639510.0 |
| 2022-04-25 15:00:00 | NVDA | Stock | 19.592 | 19.945 | 19.39 | 19.91 | 73345520.0 |
| 2022-04-25 16:00:00 | NVDA | Stock | 19.902 | 19.99 | 19.2645 | 19.976 | 19993040.0 |
| 2022-04-25 17:00:00 | NVDA | Stock | 19.982 | 20.0 | 19.92 | 19.97 | 371090.0 |
| 2022-04-25 18:00:00 | NVDA | Stock | 19.966 | 19.985 | 19.905 | 19.98 | 338260.0 |
| 2022-04-25 19:00:00 | NVDA | Stock | 19.98 | 19.998 | 19.942 | 19.98 | 251070.0 |
| 2022-04-25 04:00:00 | AMZN | Stock | 143.4695 | 143.705 | 143.4695 | 143.705 | 4000.0 |
| 2022-04-25 05:00:00 | AMZN | Stock | 143.7345 | 143.7345 | 143.7345 | 143.7345 | 2040.0 |
> showing 50 of 65,205 rows — these rows as CSV