PREVIEW / stock_1hour / 2024-12-17
file: by_date/stock_1hour/2024/2024-12-17.parquet size: 1.4 MB rows: 64,156 symbols: 673
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-17 04:00:00 | AAPL | Stock | 250.29 | 250.53 | 250.06 | 250.47 | 6889.0 |
| 2024-12-17 05:00:00 | AAPL | Stock | 250.46 | 250.58 | 250.42 | 250.46 | 7473.0 |
| 2024-12-17 06:00:00 | AAPL | Stock | 250.42 | 250.52 | 250.14 | 250.14 | 3900.0 |
| 2024-12-17 07:00:00 | AAPL | Stock | 250.16 | 250.35 | 250.1 | 250.16 | 7811.0 |
| 2024-12-17 08:00:00 | AAPL | Stock | 250.28 | 251.13 | 250.04 | 250.4999 | 74933.0 |
| 2024-12-17 09:00:00 | AAPL | Stock | 250.5 | 252.98 | 249.65 | 252.04 | 4246286.0 |
| 2024-12-17 10:00:00 | AAPL | Stock | 252.04 | 252.68 | 251.77 | 252.36 | 3267969.0 |
| 2024-12-17 11:00:00 | AAPL | Stock | 252.365 | 253.35 | 252.24 | 253.075 | 3140294.0 |
| 2024-12-17 12:00:00 | AAPL | Stock | 253.08 | 253.3 | 252.585 | 252.915 | 2382566.0 |
| 2024-12-17 13:00:00 | AAPL | Stock | 252.9 | 253.635 | 252.6901 | 253.335 | 2228897.0 |
| 2024-12-17 14:00:00 | AAPL | Stock | 253.3301 | 253.4 | 252.92 | 253.24 | 1831695.0 |
| 2024-12-17 15:00:00 | AAPL | Stock | 253.24 | 253.83 | 252.65 | 253.48 | 6258874.0 |
| 2024-12-17 16:00:00 | AAPL | Stock | 253.45 | 253.62 | 253.22 | 253.36 | 16131992.0 |
| 2024-12-17 17:00:00 | AAPL | Stock | 253.36 | 253.36 | 253.2997 | 253.36 | 6880.0 |
| 2024-12-17 18:00:00 | AAPL | Stock | 253.3 | 253.3 | 252.15 | 253.1 | 24121.0 |
| 2024-12-17 19:00:00 | AAPL | Stock | 253.22 | 253.39 | 253.06 | 253.39 | 11776.0 |
| 2024-12-17 04:00:00 | MSFT | Stock | 450.32 | 450.33 | 449.85 | 450.0 | 2420.0 |
| 2024-12-17 05:00:00 | MSFT | Stock | 450.16 | 450.26 | 450.0 | 450.22 | 1215.0 |
| 2024-12-17 06:00:00 | MSFT | Stock | 450.04 | 450.54 | 450.0 | 450.01 | 5435.0 |
| 2024-12-17 07:00:00 | MSFT | Stock | 449.69 | 450.39 | 449.5 | 450.0 | 5727.0 |
| 2024-12-17 08:00:00 | MSFT | Stock | 449.99 | 451.29 | 449.6 | 450.36 | 26062.0 |
| 2024-12-17 09:00:00 | MSFT | Stock | 450.3 | 452.8 | 449.7 | 450.57 | 1262332.0 |
| 2024-12-17 10:00:00 | MSFT | Stock | 450.57 | 453.16 | 449.57 | 453.0 | 1385393.0 |
| 2024-12-17 11:00:00 | MSFT | Stock | 453.04 | 455.28 | 452.58 | 455.01 | 1271569.0 |
| 2024-12-17 12:00:00 | MSFT | Stock | 455.015 | 455.015 | 453.4201 | 453.66 | 576169.0 |
| 2024-12-17 13:00:00 | MSFT | Stock | 453.59 | 454.28 | 453.1506 | 453.9 | 527495.0 |
| 2024-12-17 14:00:00 | MSFT | Stock | 453.91 | 454.54 | 453.145 | 454.16 | 595505.0 |
| 2024-12-17 15:00:00 | MSFT | Stock | 454.13 | 455.29 | 453.34 | 454.48 | 1664302.0 |
| 2024-12-17 16:00:00 | MSFT | Stock | 454.46 | 454.59 | 452.8001 | 454.2018 | 6337423.0 |
| 2024-12-17 17:00:00 | MSFT | Stock | 454.47 | 455.5 | 454.46 | 455.5 | 14378.0 |
| 2024-12-17 18:00:00 | MSFT | Stock | 455.5 | 455.5 | 453.05 | 454.65 | 5386.0 |
| 2024-12-17 19:00:00 | MSFT | Stock | 454.6 | 454.9946 | 454.1221 | 454.61 | 837.0 |
| 2024-12-17 04:00:00 | NVDA | Stock | 130.72 | 131.15 | 128.88 | 129.37 | 1422431.0 |
| 2024-12-17 05:00:00 | NVDA | Stock | 129.35 | 129.8 | 129.0 | 129.73 | 492443.0 |
| 2024-12-17 06:00:00 | NVDA | Stock | 129.76 | 130.4 | 129.52 | 130.07 | 505706.0 |
| 2024-12-17 07:00:00 | NVDA | Stock | 130.07 | 130.3 | 129.55 | 129.81 | 1203985.0 |
| 2024-12-17 08:00:00 | NVDA | Stock | 130.11 | 131.23 | 129.0 | 129.58 | 2452067.0 |
| 2024-12-17 09:00:00 | NVDA | Stock | 129.6 | 129.7 | 127.22 | 127.45 | 43990666.0 |
| 2024-12-17 10:00:00 | NVDA | Stock | 127.44 | 129.3 | 126.86 | 128.9088 | 41344095.0 |
| 2024-12-17 11:00:00 | NVDA | Stock | 128.9099 | 130.62 | 128.27 | 129.74 | 25897109.0 |
| 2024-12-17 12:00:00 | NVDA | Stock | 129.76 | 131.59 | 129.51 | 130.91 | 19382586.0 |
| 2024-12-17 13:00:00 | NVDA | Stock | 130.91 | 131.19 | 129.25 | 129.7409 | 16195767.0 |
| 2024-12-17 14:00:00 | NVDA | Stock | 129.75 | 130.1999 | 129.42 | 129.84 | 12249909.0 |
| 2024-12-17 15:00:00 | NVDA | Stock | 129.845 | 130.41 | 128.82 | 130.35 | 24186538.0 |
| 2024-12-17 16:00:00 | NVDA | Stock | 130.39 | 131.59 | 129.0849 | 130.9 | 23698485.0 |
| 2024-12-17 17:00:00 | NVDA | Stock | 130.88 | 130.98 | 130.7 | 130.84 | 303904.0 |
| 2024-12-17 18:00:00 | NVDA | Stock | 130.81 | 131.2883 | 130.11 | 131.2 | 635451.0 |
| 2024-12-17 19:00:00 | NVDA | Stock | 131.2 | 131.5 | 131.02 | 131.08 | 633151.0 |
| 2024-12-17 04:00:00 | AMZN | Stock | 232.0 | 232.77 | 231.6 | 232.66 | 12592.0 |
| 2024-12-17 05:00:00 | AMZN | Stock | 232.65 | 232.65 | 232.1 | 232.4 | 5975.0 |
> showing 50 of 64,156 rows — these rows as CSV