PREVIEW / stock_1hour / 2024-06-12
file: by_date/stock_1hour/2024/2024-06-12.parquet size: 1.3 MB rows: 59,578 symbols: 965
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-06-12 04:00:00 | AAPL | Stock | 206.54 | 206.69 | 206.1 | 206.33 | 39763.0 |
| 2024-06-12 05:00:00 | AAPL | Stock | 206.33 | 206.33 | 205.59 | 206.0 | 57534.0 |
| 2024-06-12 06:00:00 | AAPL | Stock | 206.0 | 206.49 | 205.81 | 206.2 | 40088.0 |
| 2024-06-12 07:00:00 | AAPL | Stock | 206.16 | 206.44 | 205.98 | 206.2 | 137552.0 |
| 2024-06-12 08:00:00 | AAPL | Stock | 206.19 | 207.61 | 205.5 | 206.4 | 1272374.0 |
| 2024-06-12 09:00:00 | AAPL | Stock | 206.4 | 215.0 | 205.85 | 214.255 | 29993050.0 |
| 2024-06-12 10:00:00 | AAPL | Stock | 214.26 | 216.62 | 214.21 | 216.6031 | 26477693.0 |
| 2024-06-12 11:00:00 | AAPL | Stock | 216.61 | 218.12 | 216.18 | 216.5075 | 19835700.0 |
| 2024-06-12 12:00:00 | AAPL | Stock | 216.51 | 217.49 | 214.861 | 215.8257 | 12836211.0 |
| 2024-06-12 13:00:00 | AAPL | Stock | 215.8399 | 217.655 | 215.51 | 217.49 | 10021146.0 |
| 2024-06-12 14:00:00 | AAPL | Stock | 217.49 | 220.15 | 216.55 | 219.78 | 21733209.0 |
| 2024-06-12 15:00:00 | AAPL | Stock | 219.78 | 220.2 | 212.83 | 213.08 | 32695281.0 |
| 2024-06-12 16:00:00 | AAPL | Stock | 213.08 | 213.95 | 212.5 | 213.92 | 9408380.0 |
| 2024-06-12 17:00:00 | AAPL | Stock | 213.96 | 214.43 | 213.07 | 213.7 | 499430.0 |
| 2024-06-12 18:00:00 | AAPL | Stock | 213.74 | 213.7514 | 212.8101 | 213.2 | 237755.0 |
| 2024-06-12 19:00:00 | AAPL | Stock | 213.2138 | 214.35 | 213.0505 | 214.2 | 347855.0 |
| 2024-06-12 04:00:00 | MSFT | Stock | 433.31 | 435.81 | 433.31 | 435.81 | 8529.0 |
| 2024-06-12 05:00:00 | MSFT | Stock | 435.55 | 435.63 | 435.04 | 435.05 | 7273.0 |
| 2024-06-12 06:00:00 | MSFT | Stock | 435.07 | 435.07 | 435.0 | 435.07 | 649.0 |
| 2024-06-12 07:00:00 | MSFT | Stock | 434.08 | 435.0 | 434.01 | 434.5 | 4878.0 |
| 2024-06-12 08:00:00 | MSFT | Stock | 435.0 | 439.0 | 432.8 | 436.74 | 131348.0 |
| 2024-06-12 09:00:00 | MSFT | Stock | 436.7399 | 438.55 | 433.25 | 438.01 | 2044680.0 |
| 2024-06-12 10:00:00 | MSFT | Stock | 438.07 | 438.4 | 436.17 | 438.0062 | 1341710.0 |
| 2024-06-12 11:00:00 | MSFT | Stock | 438.01 | 439.53 | 437.03 | 438.8001 | 1344105.0 |
| 2024-06-12 12:00:00 | MSFT | Stock | 438.79 | 439.3 | 438.06 | 439.28 | 755751.0 |
| 2024-06-12 13:00:00 | MSFT | Stock | 439.295 | 440.42 | 438.66 | 439.72 | 958669.0 |
| 2024-06-12 14:00:00 | MSFT | Stock | 439.645 | 440.73 | 437.86 | 440.685 | 1306543.0 |
| 2024-06-12 15:00:00 | MSFT | Stock | 440.67 | 443.4 | 439.64 | 441.0 | 3225253.0 |
| 2024-06-12 16:00:00 | MSFT | Stock | 441.045 | 441.85 | 439.02 | 441.2 | 3567159.0 |
| 2024-06-12 17:00:00 | MSFT | Stock | 441.48 | 442.0 | 441.01 | 441.51 | 76459.0 |
| 2024-06-12 18:00:00 | MSFT | Stock | 441.55 | 441.55 | 440.1604 | 440.25 | 21807.0 |
| 2024-06-12 19:00:00 | MSFT | Stock | 440.2017 | 440.4611 | 439.6501 | 439.78 | 14052.0 |
| 2024-06-12 04:00:00 | NVDA | Stock | 121.12 | 121.51 | 121.07 | 121.3 | 148398.0 |
| 2024-06-12 05:00:00 | NVDA | Stock | 121.3 | 121.34 | 121.11 | 121.12 | 95276.0 |
| 2024-06-12 06:00:00 | NVDA | Stock | 121.15 | 121.25 | 121.1 | 121.2 | 58436.0 |
| 2024-06-12 07:00:00 | NVDA | Stock | 121.18 | 121.63 | 121.18 | 121.49 | 590178.0 |
| 2024-06-12 08:00:00 | NVDA | Stock | 121.21 | 123.52 | 121.0 | 123.06 | 7489354.0 |
| 2024-06-12 09:00:00 | NVDA | Stock | 123.08 | 124.82 | 122.57 | 124.495 | 44968916.0 |
| 2024-06-12 10:00:00 | NVDA | Stock | 124.49 | 126.88 | 124.2364 | 125.69 | 59135515.0 |
| 2024-06-12 11:00:00 | NVDA | Stock | 125.6872 | 125.95 | 124.77 | 125.52 | 28693730.0 |
| 2024-06-12 12:00:00 | NVDA | Stock | 125.51 | 126.29 | 125.3 | 125.95 | 18021912.0 |
| 2024-06-12 13:00:00 | NVDA | Stock | 125.95 | 126.25 | 125.3 | 125.6 | 17096570.0 |
| 2024-06-12 14:00:00 | NVDA | Stock | 125.595 | 126.0799 | 124.54 | 125.365 | 27147191.0 |
| 2024-06-12 15:00:00 | NVDA | Stock | 125.35 | 126.16 | 124.17 | 125.27 | 35042413.0 |
| 2024-06-12 16:00:00 | NVDA | Stock | 125.25 | 126.56 | 124.94 | 126.41 | 20800791.0 |
| 2024-06-12 17:00:00 | NVDA | Stock | 126.41 | 126.44 | 125.2 | 126.1004 | 999258.0 |
| 2024-06-12 18:00:00 | NVDA | Stock | 126.1 | 126.7 | 125.2 | 126.55 | 1051711.0 |
| 2024-06-12 19:00:00 | NVDA | Stock | 126.58 | 126.59 | 126.13 | 126.49 | 713842.0 |
| 2024-06-12 04:00:00 | AMZN | Stock | 186.57 | 187.19 | 186.57 | 187.19 | 3923.0 |
| 2024-06-12 05:00:00 | AMZN | Stock | 187.08 | 187.37 | 187.08 | 187.19 | 1405.0 |
> showing 50 of 59,578 rows — these rows as CSV