PREVIEW / stock_1hour / 2024-11-01
file: by_date/stock_1hour/2024/2024-11-01.parquet size: 1.3 MB rows: 58,741 symbols: 726
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-11-01 04:00:00 | AAPL | Stock | 222.27 | 223.86 | 222.27 | 223.35 | 55351.0 |
| 2024-11-01 05:00:00 | AAPL | Stock | 223.36 | 223.8 | 223.19 | 223.23 | 18128.0 |
| 2024-11-01 06:00:00 | AAPL | Stock | 223.2 | 223.71 | 223.1 | 223.31 | 32567.0 |
| 2024-11-01 07:00:00 | AAPL | Stock | 223.31 | 223.4 | 221.59 | 222.02 | 189760.0 |
| 2024-11-01 08:00:00 | AAPL | Stock | 222.74 | 225.91 | 220.88 | 221.88 | 605944.0 |
| 2024-11-01 09:00:00 | AAPL | Stock | 221.88 | 223.901 | 220.27 | 223.8499 | 9201088.0 |
| 2024-11-01 10:00:00 | AAPL | Stock | 223.85 | 225.35 | 221.6 | 222.435 | 9901259.0 |
| 2024-11-01 11:00:00 | AAPL | Stock | 222.4205 | 223.26 | 221.88 | 222.08 | 4678826.0 |
| 2024-11-01 12:00:00 | AAPL | Stock | 222.07 | 222.69 | 221.77 | 222.6 | 2738070.0 |
| 2024-11-01 13:00:00 | AAPL | Stock | 222.5911 | 223.3999 | 222.07 | 222.2 | 2601686.0 |
| 2024-11-01 14:00:00 | AAPL | Stock | 222.19 | 222.68 | 222.07 | 222.6 | 2576391.0 |
| 2024-11-01 15:00:00 | AAPL | Stock | 222.59 | 223.25 | 222.25 | 222.85 | 5505555.0 |
| 2024-11-01 16:00:00 | AAPL | Stock | 222.91 | 223.29 | 222.76 | 222.87 | 7289090.0 |
| 2024-11-01 17:00:00 | AAPL | Stock | 222.87 | 223.0 | 222.83 | 223.0 | 34784.0 |
| 2024-11-01 18:00:00 | AAPL | Stock | 222.9646 | 223.0 | 222.81 | 222.93 | 16142.0 |
| 2024-11-01 19:00:00 | AAPL | Stock | 222.84 | 222.89 | 222.55 | 222.68 | 11715.0 |
| 2024-11-01 04:00:00 | MSFT | Stock | 409.53 | 411.36 | 409.53 | 410.89 | 20696.0 |
| 2024-11-01 05:00:00 | MSFT | Stock | 411.0 | 411.47 | 410.19 | 410.5 | 16198.0 |
| 2024-11-01 06:00:00 | MSFT | Stock | 410.51 | 412.0 | 410.51 | 411.79 | 12374.0 |
| 2024-11-01 07:00:00 | MSFT | Stock | 411.68 | 411.8 | 410.24 | 410.89 | 28891.0 |
| 2024-11-01 08:00:00 | MSFT | Stock | 410.72 | 411.77 | 406.35 | 409.66 | 168661.0 |
| 2024-11-01 09:00:00 | MSFT | Stock | 409.77 | 411.69 | 407.5 | 410.37 | 3120771.0 |
| 2024-11-01 10:00:00 | MSFT | Stock | 410.47 | 413.43 | 409.5515 | 413.385 | 2239475.0 |
| 2024-11-01 11:00:00 | MSFT | Stock | 413.375 | 415.5 | 413.32 | 414.07 | 1943602.0 |
| 2024-11-01 12:00:00 | MSFT | Stock | 414.0 | 414.95 | 413.11 | 413.6999 | 849257.0 |
| 2024-11-01 13:00:00 | MSFT | Stock | 413.71 | 414.5599 | 412.14 | 412.68 | 872335.0 |
| 2024-11-01 14:00:00 | MSFT | Stock | 412.67 | 413.07 | 411.36 | 412.14 | 734570.0 |
| 2024-11-01 15:00:00 | MSFT | Stock | 412.135 | 412.85 | 409.84 | 410.01 | 1625656.0 |
| 2024-11-01 16:00:00 | MSFT | Stock | 410.37 | 410.91 | 409.75 | 410.65 | 3266662.0 |
| 2024-11-01 17:00:00 | MSFT | Stock | 410.7 | 410.88 | 410.42 | 410.55 | 18848.0 |
| 2024-11-01 18:00:00 | MSFT | Stock | 410.4411 | 410.6891 | 410.3 | 410.3 | 8285.0 |
| 2024-11-01 19:00:00 | MSFT | Stock | 410.3732 | 410.5 | 410.0371 | 410.3 | 4211.0 |
| 2024-11-01 04:00:00 | NVDA | Stock | 134.94 | 135.51 | 134.57 | 135.27 | 453731.0 |
| 2024-11-01 05:00:00 | NVDA | Stock | 135.29 | 135.59 | 135.16 | 135.25 | 227653.0 |
| 2024-11-01 06:00:00 | NVDA | Stock | 135.24 | 135.74 | 135.22 | 135.38 | 210425.0 |
| 2024-11-01 07:00:00 | NVDA | Stock | 135.37 | 135.39 | 134.61 | 134.91 | 669358.0 |
| 2024-11-01 08:00:00 | NVDA | Stock | 134.93 | 135.6996 | 132.429 | 134.31 | 2721598.0 |
| 2024-11-01 09:00:00 | NVDA | Stock | 134.32 | 136.585 | 134.06 | 136.1622 | 28428096.0 |
| 2024-11-01 10:00:00 | NVDA | Stock | 136.19 | 137.31 | 135.4601 | 136.65 | 32253823.0 |
| 2024-11-01 11:00:00 | NVDA | Stock | 136.65 | 137.13 | 135.9005 | 136.52 | 19757594.0 |
| 2024-11-01 12:00:00 | NVDA | Stock | 136.51 | 136.8 | 135.63 | 135.7999 | 13482097.0 |
| 2024-11-01 13:00:00 | NVDA | Stock | 135.8 | 136.4 | 135.31 | 135.3709 | 15061666.0 |
| 2024-11-01 14:00:00 | NVDA | Stock | 135.37 | 135.85 | 134.95 | 135.5697 | 14313520.0 |
| 2024-11-01 15:00:00 | NVDA | Stock | 135.56 | 136.08 | 135.03 | 135.43 | 20117390.0 |
| 2024-11-01 16:00:00 | NVDA | Stock | 135.4 | 135.5301 | 135.25 | 135.42 | 13332221.0 |
| 2024-11-01 17:00:00 | NVDA | Stock | 135.4 | 138.92 | 135.15 | 138.92 | 4455039.0 |
| 2024-11-01 18:00:00 | NVDA | Stock | 138.91 | 139.83 | 138.81 | 139.15 | 3457005.0 |
| 2024-11-01 19:00:00 | NVDA | Stock | 139.15 | 139.45 | 138.93 | 139.31 | 1598198.0 |
| 2024-11-01 04:00:00 | AMZN | Stock | 197.3 | 197.84 | 196.52 | 196.71 | 116922.0 |
| 2024-11-01 05:00:00 | AMZN | Stock | 196.73 | 198.2 | 196.73 | 197.88 | 88451.0 |
> showing 50 of 58,741 rows — these rows as CSV