PREVIEW / stock_1hour / 2024-12-30
file: by_date/stock_1hour/2024/2024-12-30.parquet size: 1.5 MB rows: 66,428 symbols: 613
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-12-30 04:00:00 | AAPL | Stock | 255.02 | 255.02 | 254.31 | 254.4 | 12884.0 |
| 2024-12-30 05:00:00 | AAPL | Stock | 254.5 | 254.75 | 254.45 | 254.49 | 4773.0 |
| 2024-12-30 06:00:00 | AAPL | Stock | 254.43 | 254.64 | 254.38 | 254.53 | 3440.0 |
| 2024-12-30 07:00:00 | AAPL | Stock | 254.61 | 254.61 | 252.88 | 252.9 | 34859.0 |
| 2024-12-30 08:00:00 | AAPL | Stock | 252.87 | 255.24 | 252.01 | 252.29 | 138343.0 |
| 2024-12-30 09:00:00 | AAPL | Stock | 252.23 | 253.0 | 250.89 | 251.27 | 3891549.0 |
| 2024-12-30 10:00:00 | AAPL | Stock | 251.2613 | 252.17 | 250.75 | 251.69 | 3670094.0 |
| 2024-12-30 11:00:00 | AAPL | Stock | 251.685 | 252.6488 | 251.06 | 252.54 | 2303028.0 |
| 2024-12-30 12:00:00 | AAPL | Stock | 252.5 | 253.47 | 252.35 | 253.41 | 1761754.0 |
| 2024-12-30 13:00:00 | AAPL | Stock | 253.4 | 253.41 | 252.5 | 253.14 | 1469160.0 |
| 2024-12-30 14:00:00 | AAPL | Stock | 253.1201 | 253.5 | 252.59 | 253.34 | 1607398.0 |
| 2024-12-30 15:00:00 | AAPL | Stock | 253.348 | 253.48 | 252.04 | 252.06 | 3782538.0 |
| 2024-12-30 16:00:00 | AAPL | Stock | 252.2 | 252.32 | 251.615 | 251.83 | 6160210.0 |
| 2024-12-30 17:00:00 | AAPL | Stock | 251.83 | 252.36 | 251.83 | 252.22 | 30337.0 |
| 2024-12-30 18:00:00 | AAPL | Stock | 252.24 | 252.24 | 251.68 | 251.8679 | 79830.0 |
| 2024-12-30 19:00:00 | AAPL | Stock | 251.865 | 251.87 | 251.8 | 251.87 | 18601.0 |
| 2024-12-30 04:00:00 | MSFT | Stock | 430.7 | 430.7 | 429.57 | 429.8 | 4495.0 |
| 2024-12-30 05:00:00 | MSFT | Stock | 429.71 | 430.29 | 429.71 | 430.09 | 3573.0 |
| 2024-12-30 06:00:00 | MSFT | Stock | 430.13 | 430.29 | 429.65 | 429.65 | 1408.0 |
| 2024-12-30 07:00:00 | MSFT | Stock | 429.66 | 429.68 | 426.74 | 426.91 | 10638.0 |
| 2024-12-30 08:00:00 | MSFT | Stock | 429.94 | 430.0 | 425.5795 | 425.75 | 35095.0 |
| 2024-12-30 09:00:00 | MSFT | Stock | 426.0 | 427.3216 | 422.2 | 422.665 | 1245646.0 |
| 2024-12-30 10:00:00 | MSFT | Stock | 422.66 | 425.295 | 421.9 | 424.44 | 1007559.0 |
| 2024-12-30 11:00:00 | MSFT | Stock | 424.36 | 426.0499 | 423.99 | 425.44 | 662636.0 |
| 2024-12-30 12:00:00 | MSFT | Stock | 425.42 | 427.55 | 425.0801 | 427.03 | 538209.0 |
| 2024-12-30 13:00:00 | MSFT | Stock | 426.99 | 427.2 | 425.5001 | 426.8301 | 529309.0 |
| 2024-12-30 14:00:00 | MSFT | Stock | 426.9133 | 427.3 | 425.88 | 426.99 | 464584.0 |
| 2024-12-30 15:00:00 | MSFT | Stock | 426.93 | 427.43 | 424.76 | 424.82 | 1190747.0 |
| 2024-12-30 16:00:00 | MSFT | Stock | 424.83 | 425.33 | 424.27 | 425.0 | 2554010.0 |
| 2024-12-30 17:00:00 | MSFT | Stock | 424.99 | 425.6 | 424.35 | 424.35 | 7516.0 |
| 2024-12-30 18:00:00 | MSFT | Stock | 424.3 | 424.79 | 424.02 | 424.45 | 7992.0 |
| 2024-12-30 19:00:00 | MSFT | Stock | 424.51 | 424.51 | 424.1 | 424.1 | 7140.0 |
| 2024-12-30 04:00:00 | NVDA | Stock | 136.49 | 137.0 | 135.23 | 135.88 | 287296.0 |
| 2024-12-30 05:00:00 | NVDA | Stock | 135.87 | 136.19 | 135.77 | 136.17 | 116062.0 |
| 2024-12-30 06:00:00 | NVDA | Stock | 136.15 | 136.4 | 136.0 | 136.14 | 116616.0 |
| 2024-12-30 07:00:00 | NVDA | Stock | 136.22 | 136.75 | 135.02 | 135.31 | 617444.0 |
| 2024-12-30 08:00:00 | NVDA | Stock | 135.31 | 136.79 | 133.93 | 134.26 | 2090987.0 |
| 2024-12-30 09:00:00 | NVDA | Stock | 134.27 | 138.2 | 134.02 | 136.8999 | 24991236.0 |
| 2024-12-30 10:00:00 | NVDA | Stock | 136.9 | 138.67 | 136.32 | 138.19 | 27634566.0 |
| 2024-12-30 11:00:00 | NVDA | Stock | 138.18 | 138.4 | 137.27 | 138.2999 | 12670184.0 |
| 2024-12-30 12:00:00 | NVDA | Stock | 138.2937 | 139.99 | 138.21 | 139.8524 | 17859950.0 |
| 2024-12-30 13:00:00 | NVDA | Stock | 139.86 | 140.27 | 139.16 | 139.4809 | 15744049.0 |
| 2024-12-30 14:00:00 | NVDA | Stock | 139.49 | 139.59 | 138.84 | 139.37 | 11215216.0 |
| 2024-12-30 15:00:00 | NVDA | Stock | 139.37 | 139.47 | 137.38 | 137.39 | 18724471.0 |
| 2024-12-30 16:00:00 | NVDA | Stock | 137.38 | 137.5493 | 136.79 | 137.08 | 11247658.0 |
| 2024-12-30 17:00:00 | NVDA | Stock | 137.1242 | 137.49 | 136.71 | 136.79 | 374888.0 |
| 2024-12-30 18:00:00 | NVDA | Stock | 136.8 | 136.85 | 136.63 | 136.74 | 258054.0 |
| 2024-12-30 19:00:00 | NVDA | Stock | 136.7399 | 136.95 | 136.5 | 136.5001 | 271898.0 |
| 2024-12-30 04:00:00 | AMZN | Stock | 223.71 | 223.71 | 223.0 | 223.69 | 11646.0 |
| 2024-12-30 05:00:00 | AMZN | Stock | 223.68 | 223.68 | 223.4 | 223.5 | 3169.0 |
> showing 50 of 66,428 rows — these rows as CSV