PREVIEW / stock_1hour / 2024-07-17
file: by_date/stock_1hour/2024/2024-07-17.parquet size: 1.4 MB rows: 60,238 symbols: 899
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-07-17 04:00:00 | AAPL | Stock | 233.41 | 233.41 | 230.28 | 231.14 | 70819.0 |
| 2024-07-17 05:00:00 | AAPL | Stock | 231.0 | 231.6 | 230.92 | 231.0 | 24139.0 |
| 2024-07-17 06:00:00 | AAPL | Stock | 230.94 | 231.01 | 230.02 | 230.15 | 48231.0 |
| 2024-07-17 07:00:00 | AAPL | Stock | 230.49 | 230.8 | 229.5 | 229.8 | 168139.0 |
| 2024-07-17 08:00:00 | AAPL | Stock | 230.5469 | 234.27 | 229.4121 | 230.1002 | 410521.0 |
| 2024-07-17 09:00:00 | AAPL | Stock | 230.1001 | 231.4599 | 227.9 | 229.01 | 8341974.0 |
| 2024-07-17 10:00:00 | AAPL | Stock | 229.0 | 229.065 | 226.64 | 227.77 | 7137867.0 |
| 2024-07-17 11:00:00 | AAPL | Stock | 227.765 | 229.01 | 227.74 | 228.71 | 4032996.0 |
| 2024-07-17 12:00:00 | AAPL | Stock | 228.72 | 229.01 | 228.27 | 228.71 | 3015410.0 |
| 2024-07-17 13:00:00 | AAPL | Stock | 228.72 | 228.92 | 228.15 | 228.631 | 2670568.0 |
| 2024-07-17 14:00:00 | AAPL | Stock | 228.64 | 229.8 | 228.5075 | 229.2 | 3716165.0 |
| 2024-07-17 15:00:00 | AAPL | Stock | 229.195 | 229.82 | 228.57 | 228.88 | 6458759.0 |
| 2024-07-17 16:00:00 | AAPL | Stock | 228.88 | 229.34 | 228.59 | 229.05 | 7683476.0 |
| 2024-07-17 17:00:00 | AAPL | Stock | 229.05 | 229.17 | 228.86 | 228.93 | 17396.0 |
| 2024-07-17 18:00:00 | AAPL | Stock | 228.97 | 229.35 | 228.97 | 229.1859 | 31912.0 |
| 2024-07-17 19:00:00 | AAPL | Stock | 229.1 | 229.3438 | 229.05 | 229.13 | 26642.0 |
| 2024-07-17 04:00:00 | MSFT | Stock | 446.0 | 446.0 | 442.51 | 443.2 | 8918.0 |
| 2024-07-17 05:00:00 | MSFT | Stock | 443.29 | 444.2 | 442.62 | 444.2 | 3967.0 |
| 2024-07-17 06:00:00 | MSFT | Stock | 444.42 | 445.49 | 443.65 | 444.77 | 8920.0 |
| 2024-07-17 07:00:00 | MSFT | Stock | 444.99 | 445.33 | 442.8 | 443.55 | 22885.0 |
| 2024-07-17 08:00:00 | MSFT | Stock | 445.09 | 447.33 | 442.7425 | 444.17 | 35302.0 |
| 2024-07-17 09:00:00 | MSFT | Stock | 444.2 | 444.35 | 441.0 | 443.83 | 2153816.0 |
| 2024-07-17 10:00:00 | MSFT | Stock | 443.775 | 443.8818 | 439.66 | 440.0 | 1998940.0 |
| 2024-07-17 11:00:00 | MSFT | Stock | 440.02 | 441.56 | 439.18 | 440.75 | 1294858.0 |
| 2024-07-17 12:00:00 | MSFT | Stock | 440.8 | 441.52 | 439.94 | 440.8901 | 1131128.0 |
| 2024-07-17 13:00:00 | MSFT | Stock | 440.88 | 443.05 | 440.67 | 443.03 | 884875.0 |
| 2024-07-17 14:00:00 | MSFT | Stock | 443.06 | 444.67 | 442.6113 | 443.295 | 1066848.0 |
| 2024-07-17 15:00:00 | MSFT | Stock | 443.32 | 444.85 | 442.64 | 443.55 | 2091008.0 |
| 2024-07-17 16:00:00 | MSFT | Stock | 443.5 | 444.67 | 443.5 | 443.93 | 3987066.0 |
| 2024-07-17 17:00:00 | MSFT | Stock | 443.9 | 444.0 | 443.52 | 443.87 | 25355.0 |
| 2024-07-17 18:00:00 | MSFT | Stock | 444.28 | 444.53 | 444.0 | 444.3 | 5514.0 |
| 2024-07-17 19:00:00 | MSFT | Stock | 444.45 | 444.64 | 444.15 | 444.3001 | 2424.0 |
| 2024-07-17 04:00:00 | NVDA | Stock | 122.4 | 125.28 | 121.5 | 122.42 | 1491139.0 |
| 2024-07-17 05:00:00 | NVDA | Stock | 122.43 | 122.76 | 122.18 | 122.34 | 407102.0 |
| 2024-07-17 06:00:00 | NVDA | Stock | 122.34 | 122.4 | 121.58 | 121.92 | 585469.0 |
| 2024-07-17 07:00:00 | NVDA | Stock | 121.95 | 122.47 | 120.5 | 121.18 | 2711153.0 |
| 2024-07-17 08:00:00 | NVDA | Stock | 122.09 | 125.78 | 120.5 | 121.17 | 5413099.0 |
| 2024-07-17 09:00:00 | NVDA | Stock | 121.2 | 121.85 | 119.856 | 119.8799 | 47903590.0 |
| 2024-07-17 10:00:00 | NVDA | Stock | 119.88 | 120.34 | 118.12 | 119.558 | 66950168.0 |
| 2024-07-17 11:00:00 | NVDA | Stock | 119.56 | 120.0 | 118.6 | 119.195 | 35211097.0 |
| 2024-07-17 12:00:00 | NVDA | Stock | 119.2 | 119.28 | 116.72 | 118.02 | 48323349.0 |
| 2024-07-17 13:00:00 | NVDA | Stock | 118.02 | 119.02 | 117.7106 | 118.0299 | 30131074.0 |
| 2024-07-17 14:00:00 | NVDA | Stock | 118.04 | 118.81 | 117.59 | 118.0213 | 25139450.0 |
| 2024-07-17 15:00:00 | NVDA | Stock | 118.025 | 119.1 | 117.8 | 117.85 | 40860012.0 |
| 2024-07-17 16:00:00 | NVDA | Stock | 117.825 | 121.35 | 117.4 | 117.8 | 27063962.0 |
| 2024-07-17 17:00:00 | NVDA | Stock | 117.8 | 118.43 | 117.79 | 118.31 | 1022125.0 |
| 2024-07-17 18:00:00 | NVDA | Stock | 118.35 | 121.65 | 117.99 | 119.45 | 2140805.0 |
| 2024-07-17 19:00:00 | NVDA | Stock | 119.4403 | 119.64 | 119.03 | 119.16 | 1093967.0 |
| 2024-07-17 04:00:00 | AMZN | Stock | 192.08 | 192.08 | 190.21 | 191.35 | 26012.0 |
| 2024-07-17 05:00:00 | AMZN | Stock | 191.31 | 191.62 | 191.19 | 191.46 | 3511.0 |
> showing 50 of 60,238 rows — these rows as CSV