PREVIEW / stock_1hour / 2024-11-05
file: by_date/stock_1hour/2024/2024-11-05.parquet size: 1.4 MB rows: 60,020 symbols: 732
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-05 04:00:00 | AAPL | Stock | 221.9 | 221.9 | 221.3 | 221.6 | 8763.0 |
| 2024-11-05 05:00:00 | AAPL | Stock | 221.6 | 221.66 | 221.13 | 221.55 | 6533.0 |
| 2024-11-05 06:00:00 | AAPL | Stock | 221.72 | 222.3 | 221.72 | 221.97 | 7175.0 |
| 2024-11-05 07:00:00 | AAPL | Stock | 221.98 | 222.15 | 221.35 | 221.52 | 11565.0 |
| 2024-11-05 08:00:00 | AAPL | Stock | 221.93 | 222.1 | 220.4 | 221.8887 | 68710.0 |
| 2024-11-05 09:00:00 | AAPL | Stock | 221.81 | 223.95 | 221.1 | 223.545 | 3260799.0 |
| 2024-11-05 10:00:00 | AAPL | Stock | 223.56 | 223.8452 | 222.06 | 222.195 | 3010093.0 |
| 2024-11-05 11:00:00 | AAPL | Stock | 222.19 | 223.33 | 221.93 | 223.23 | 1973558.0 |
| 2024-11-05 12:00:00 | AAPL | Stock | 223.25 | 223.78 | 223.15 | 223.49 | 1350080.0 |
| 2024-11-05 13:00:00 | AAPL | Stock | 223.495 | 223.51 | 222.4002 | 222.85 | 1710720.0 |
| 2024-11-05 14:00:00 | AAPL | Stock | 222.86 | 223.45 | 222.81 | 222.9399 | 1460691.0 |
| 2024-11-05 15:00:00 | AAPL | Stock | 222.93 | 223.53 | 222.71 | 223.46 | 3196716.0 |
| 2024-11-05 16:00:00 | AAPL | Stock | 223.44 | 223.59 | 223.01 | 223.1766 | 5056925.0 |
| 2024-11-05 17:00:00 | AAPL | Stock | 223.29 | 223.45 | 223.0201 | 223.06 | 41952.0 |
| 2024-11-05 18:00:00 | AAPL | Stock | 223.04 | 223.12 | 222.9105 | 222.96 | 16700.0 |
| 2024-11-05 19:00:00 | AAPL | Stock | 222.98 | 223.1642 | 222.24 | 223.15 | 36761.0 |
| 2024-11-05 04:00:00 | MSFT | Stock | 409.5 | 410.09 | 409.49 | 409.74 | 1606.0 |
| 2024-11-05 05:00:00 | MSFT | Stock | 409.5 | 409.71 | 409.5 | 409.71 | 256.0 |
| 2024-11-05 06:00:00 | MSFT | Stock | 409.8 | 410.0 | 409.7 | 409.95 | 2454.0 |
| 2024-11-05 07:00:00 | MSFT | Stock | 409.92 | 410.0 | 409.2 | 409.44 | 11056.0 |
| 2024-11-05 08:00:00 | MSFT | Stock | 409.93 | 409.9999 | 408.95 | 409.5 | 27617.0 |
| 2024-11-05 09:00:00 | MSFT | Stock | 409.31 | 412.92 | 408.05 | 412.875 | 1721327.0 |
| 2024-11-05 10:00:00 | MSFT | Stock | 412.82 | 413.53 | 411.52 | 411.74 | 1480384.0 |
| 2024-11-05 11:00:00 | MSFT | Stock | 411.74 | 414.55 | 411.3859 | 414.435 | 962419.0 |
| 2024-11-05 12:00:00 | MSFT | Stock | 414.4101 | 414.9 | 413.21 | 413.4433 | 659445.0 |
| 2024-11-05 13:00:00 | MSFT | Stock | 413.42 | 413.77 | 411.1 | 411.68 | 844968.0 |
| 2024-11-05 14:00:00 | MSFT | Stock | 411.67 | 412.36 | 410.96 | 411.31 | 687023.0 |
| 2024-11-05 15:00:00 | MSFT | Stock | 411.21 | 412.36 | 410.75 | 411.48 | 1357285.0 |
| 2024-11-05 16:00:00 | MSFT | Stock | 411.46 | 412.5 | 411.01 | 412.25 | 2705518.0 |
| 2024-11-05 17:00:00 | MSFT | Stock | 412.25 | 412.25 | 411.66 | 411.77 | 2977.0 |
| 2024-11-05 18:00:00 | MSFT | Stock | 411.65 | 412.0 | 411.55 | 411.7 | 6409.0 |
| 2024-11-05 19:00:00 | MSFT | Stock | 411.56 | 412.2 | 411.0 | 412.2 | 17065.0 |
| 2024-11-05 04:00:00 | NVDA | Stock | 136.24 | 137.37 | 136.17 | 137.1 | 282837.0 |
| 2024-11-05 05:00:00 | NVDA | Stock | 137.05 | 137.18 | 136.8 | 137.07 | 150120.0 |
| 2024-11-05 06:00:00 | NVDA | Stock | 137.07 | 137.68 | 137.04 | 137.23 | 162775.0 |
| 2024-11-05 07:00:00 | NVDA | Stock | 137.2 | 137.29 | 136.66 | 136.94 | 517113.0 |
| 2024-11-05 08:00:00 | NVDA | Stock | 137.23 | 137.26 | 135.92 | 136.9101 | 1384934.0 |
| 2024-11-05 09:00:00 | NVDA | Stock | 136.92 | 138.99 | 136.79 | 138.77 | 23681835.0 |
| 2024-11-05 10:00:00 | NVDA | Stock | 138.82 | 139.48 | 138.63 | 139.08 | 22834307.0 |
| 2024-11-05 11:00:00 | NVDA | Stock | 139.07 | 140.37 | 138.88 | 140.365 | 17916152.0 |
| 2024-11-05 12:00:00 | NVDA | Stock | 140.37 | 140.3701 | 139.35 | 139.665 | 14874368.0 |
| 2024-11-05 13:00:00 | NVDA | Stock | 139.67 | 139.97 | 139.08 | 139.275 | 12125912.0 |
| 2024-11-05 14:00:00 | NVDA | Stock | 139.275 | 140.0 | 139.275 | 139.425 | 11865884.0 |
| 2024-11-05 15:00:00 | NVDA | Stock | 139.4299 | 139.95 | 139.1293 | 139.91 | 18809555.0 |
| 2024-11-05 16:00:00 | NVDA | Stock | 139.91 | 140.07 | 139.42 | 139.73 | 14476993.0 |
| 2024-11-05 17:00:00 | NVDA | Stock | 139.73 | 139.75 | 139.48 | 139.65 | 371292.0 |
| 2024-11-05 18:00:00 | NVDA | Stock | 139.6301 | 139.77 | 139.52 | 139.69 | 194650.0 |
| 2024-11-05 19:00:00 | NVDA | Stock | 139.69 | 140.3 | 139.69 | 140.1601 | 727518.0 |
| 2024-11-05 04:00:00 | AMZN | Stock | 195.33 | 196.3 | 195.33 | 195.98 | 9472.0 |
| 2024-11-05 05:00:00 | AMZN | Stock | 195.9 | 196.0 | 195.78 | 195.91 | 6765.0 |
> showing 50 of 60,020 rows — these rows as CSV