PREVIEW / stock_1hour / 2024-11-18
file: by_date/stock_1hour/2024/2024-11-18.parquet size: 1.4 MB rows: 62,263 symbols: 725
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-18 04:00:00 | AAPL | Stock | 226.0 | 226.0 | 224.84 | 225.21 | 5135.0 |
| 2024-11-18 05:00:00 | AAPL | Stock | 225.26 | 225.38 | 225.0 | 225.38 | 6790.0 |
| 2024-11-18 06:00:00 | AAPL | Stock | 225.35 | 225.55 | 225.21 | 225.55 | 1778.0 |
| 2024-11-18 07:00:00 | AAPL | Stock | 225.62 | 226.0 | 225.52 | 225.7 | 23331.0 |
| 2024-11-18 08:00:00 | AAPL | Stock | 225.9 | 226.31 | 224.438 | 225.69 | 73658.0 |
| 2024-11-18 09:00:00 | AAPL | Stock | 225.629 | 227.2 | 225.01 | 226.82 | 3863121.0 |
| 2024-11-18 10:00:00 | AAPL | Stock | 226.85 | 228.921 | 226.73 | 228.43 | 3911369.0 |
| 2024-11-18 11:00:00 | AAPL | Stock | 228.41 | 229.21 | 228.36 | 228.54 | 2367205.0 |
| 2024-11-18 12:00:00 | AAPL | Stock | 228.53 | 229.6188 | 228.36 | 229.602 | 1724037.0 |
| 2024-11-18 13:00:00 | AAPL | Stock | 229.605 | 229.74 | 228.67 | 229.446 | 1772562.0 |
| 2024-11-18 14:00:00 | AAPL | Stock | 229.44 | 229.44 | 228.6961 | 228.855 | 1334408.0 |
| 2024-11-18 15:00:00 | AAPL | Stock | 228.85 | 228.92 | 227.3 | 227.99 | 3691947.0 |
| 2024-11-18 16:00:00 | AAPL | Stock | 228.02 | 228.6 | 227.9 | 228.4 | 12134808.0 |
| 2024-11-18 17:00:00 | AAPL | Stock | 228.37 | 228.85 | 228.02 | 228.2412 | 51845.0 |
| 2024-11-18 18:00:00 | AAPL | Stock | 228.2 | 228.2 | 227.42 | 227.85 | 20737.0 |
| 2024-11-18 19:00:00 | AAPL | Stock | 227.85 | 228.31 | 227.6862 | 228.06 | 9247.0 |
| 2024-11-18 04:00:00 | MSFT | Stock | 416.7 | 416.7 | 415.01 | 415.42 | 3759.0 |
| 2024-11-18 05:00:00 | MSFT | Stock | 415.56 | 416.41 | 415.55 | 416.41 | 2422.0 |
| 2024-11-18 06:00:00 | MSFT | Stock | 416.39 | 416.4 | 415.71 | 416.29 | 2334.0 |
| 2024-11-18 07:00:00 | MSFT | Stock | 416.06 | 416.6 | 415.66 | 415.66 | 9417.0 |
| 2024-11-18 08:00:00 | MSFT | Stock | 416.19 | 417.31 | 414.07 | 415.9051 | 43526.0 |
| 2024-11-18 09:00:00 | MSFT | Stock | 415.66 | 416.3773 | 412.1 | 415.4 | 1683379.0 |
| 2024-11-18 10:00:00 | MSFT | Stock | 415.47 | 418.4037 | 415.02 | 417.56 | 1319591.0 |
| 2024-11-18 11:00:00 | MSFT | Stock | 417.58 | 417.795 | 415.68 | 416.0532 | 646092.0 |
| 2024-11-18 12:00:00 | MSFT | Stock | 416.085 | 416.15 | 414.7 | 415.68 | 634085.0 |
| 2024-11-18 13:00:00 | MSFT | Stock | 415.64 | 416.33 | 414.84 | 415.98 | 673856.0 |
| 2024-11-18 14:00:00 | MSFT | Stock | 416.02 | 416.745 | 415.52 | 416.52 | 578701.0 |
| 2024-11-18 15:00:00 | MSFT | Stock | 416.49 | 416.66 | 415.18 | 415.75 | 1135451.0 |
| 2024-11-18 16:00:00 | MSFT | Stock | 415.76 | 415.93 | 415.3 | 415.5 | 9976724.0 |
| 2024-11-18 17:00:00 | MSFT | Stock | 415.5 | 415.91 | 415.5 | 415.6 | 10972.0 |
| 2024-11-18 18:00:00 | MSFT | Stock | 415.58 | 415.65 | 415.0 | 415.65 | 2607.0 |
| 2024-11-18 19:00:00 | MSFT | Stock | 415.36 | 415.6975 | 415.02 | 415.02 | 3375.0 |
| 2024-11-18 04:00:00 | NVDA | Stock | 142.8 | 143.5 | 137.21 | 138.64 | 2252246.0 |
| 2024-11-18 05:00:00 | NVDA | Stock | 138.65 | 139.2 | 138.07 | 139.2 | 838158.0 |
| 2024-11-18 06:00:00 | NVDA | Stock | 139.2 | 139.48 | 138.5 | 139.0 | 574771.0 |
| 2024-11-18 07:00:00 | NVDA | Stock | 139.0 | 139.8 | 138.12 | 138.499 | 1935921.0 |
| 2024-11-18 08:00:00 | NVDA | Stock | 138.91 | 143.31 | 137.12 | 138.86 | 4405801.0 |
| 2024-11-18 09:00:00 | NVDA | Stock | 138.87 | 140.18 | 137.15 | 138.14 | 34451611.0 |
| 2024-11-18 10:00:00 | NVDA | Stock | 138.16 | 140.56 | 138.0201 | 140.2399 | 28683286.0 |
| 2024-11-18 11:00:00 | NVDA | Stock | 140.235 | 141.28 | 139.72 | 140.0 | 20989563.0 |
| 2024-11-18 12:00:00 | NVDA | Stock | 139.9971 | 140.07 | 138.88 | 139.4999 | 15869245.0 |
| 2024-11-18 13:00:00 | NVDA | Stock | 139.49 | 140.39 | 139.353 | 140.355 | 12890559.0 |
| 2024-11-18 14:00:00 | NVDA | Stock | 140.35 | 140.4 | 139.45 | 140.21 | 10295182.0 |
| 2024-11-18 15:00:00 | NVDA | Stock | 140.2 | 141.55 | 139.5 | 140.2 | 23453396.0 |
| 2024-11-18 16:00:00 | NVDA | Stock | 140.2 | 140.58 | 140.0 | 140.27 | 22552705.0 |
| 2024-11-18 17:00:00 | NVDA | Stock | 140.27 | 140.8 | 140.27 | 140.65 | 450509.0 |
| 2024-11-18 18:00:00 | NVDA | Stock | 140.65 | 140.69 | 140.34 | 140.52 | 276877.0 |
| 2024-11-18 19:00:00 | NVDA | Stock | 140.5099 | 140.69 | 140.45 | 140.61 | 363771.0 |
| 2024-11-18 04:00:00 | AMZN | Stock | 204.3 | 204.4 | 202.94 | 203.33 | 35206.0 |
| 2024-11-18 05:00:00 | AMZN | Stock | 203.43 | 204.45 | 203.43 | 204.0 | 20279.0 |
> showing 50 of 62,263 rows — these rows as CSV