PREVIEW / stock_1hour / 2024-09-11
file: by_date/stock_1hour/2024/2024-09-11.parquet size: 1.3 MB rows: 58,191 symbols: 874
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-09-11 04:00:00 | AAPL | Stock | 217.8 | 219.53 | 217.12 | 219.22 | 12696.0 |
| 2024-09-11 05:00:00 | AAPL | Stock | 219.47 | 219.54 | 219.39 | 219.39 | 1518.0 |
| 2024-09-11 06:00:00 | AAPL | Stock | 219.56 | 219.63 | 219.42 | 219.63 | 11846.0 |
| 2024-09-11 07:00:00 | AAPL | Stock | 219.6 | 220.0 | 219.58 | 219.88 | 12497.0 |
| 2024-09-11 08:00:00 | AAPL | Stock | 219.62 | 220.65 | 219.0 | 220.46 | 160668.0 |
| 2024-09-11 09:00:00 | AAPL | Stock | 220.6 | 223.09 | 220.15 | 220.505 | 4340159.0 |
| 2024-09-11 10:00:00 | AAPL | Stock | 220.55 | 221.01 | 217.89 | 218.59 | 4480861.0 |
| 2024-09-11 11:00:00 | AAPL | Stock | 218.55 | 220.35 | 218.04 | 219.68 | 2891813.0 |
| 2024-09-11 12:00:00 | AAPL | Stock | 219.6999 | 221.33 | 219.65 | 221.0728 | 2473738.0 |
| 2024-09-11 13:00:00 | AAPL | Stock | 221.07 | 221.85 | 220.84 | 221.08 | 2617841.0 |
| 2024-09-11 14:00:00 | AAPL | Stock | 221.08 | 221.79 | 220.86 | 221.45 | 2717852.0 |
| 2024-09-11 15:00:00 | AAPL | Stock | 221.44 | 223.0 | 221.105 | 222.86 | 6299173.0 |
| 2024-09-11 16:00:00 | AAPL | Stock | 222.55 | 222.6697 | 221.9 | 222.2 | 7044592.0 |
| 2024-09-11 17:00:00 | AAPL | Stock | 222.22 | 222.22 | 221.87 | 222.0 | 27055.0 |
| 2024-09-11 18:00:00 | AAPL | Stock | 222.09 | 222.32 | 221.93 | 222.32 | 36240.0 |
| 2024-09-11 19:00:00 | AAPL | Stock | 222.3 | 222.36 | 221.95 | 222.1445 | 21025.0 |
| 2024-09-11 04:00:00 | MSFT | Stock | 414.59 | 414.6 | 414.03 | 414.03 | 1684.0 |
| 2024-09-11 05:00:00 | MSFT | Stock | 414.04 | 414.18 | 414.01 | 414.01 | 526.0 |
| 2024-09-11 06:00:00 | MSFT | Stock | 414.39 | 414.39 | 414.17 | 414.2 | 769.0 |
| 2024-09-11 07:00:00 | MSFT | Stock | 414.2 | 414.4 | 413.89 | 414.4 | 6395.0 |
| 2024-09-11 08:00:00 | MSFT | Stock | 413.705 | 415.29 | 412.15 | 415.2 | 34433.0 |
| 2024-09-11 09:00:00 | MSFT | Stock | 415.2 | 417.32 | 414.25 | 415.27 | 1321436.0 |
| 2024-09-11 10:00:00 | MSFT | Stock | 415.31 | 415.35 | 409.745 | 410.38 | 1125073.0 |
| 2024-09-11 11:00:00 | MSFT | Stock | 410.31 | 414.0 | 409.58 | 413.79 | 839861.0 |
| 2024-09-11 12:00:00 | MSFT | Stock | 413.81 | 416.56 | 413.65 | 415.95 | 693559.0 |
| 2024-09-11 13:00:00 | MSFT | Stock | 416.005 | 419.49 | 415.85 | 418.42 | 1027113.0 |
| 2024-09-11 14:00:00 | MSFT | Stock | 418.415 | 421.01 | 418.17 | 420.6532 | 933738.0 |
| 2024-09-11 15:00:00 | MSFT | Stock | 420.62 | 423.99 | 420.17 | 422.94 | 2260168.0 |
| 2024-09-11 16:00:00 | MSFT | Stock | 422.93 | 423.88 | 422.55 | 422.56 | 4039763.0 |
| 2024-09-11 17:00:00 | MSFT | Stock | 422.572 | 423.0 | 421.99 | 422.1 | 19716.0 |
| 2024-09-11 18:00:00 | MSFT | Stock | 422.49 | 422.64 | 421.81 | 422.2 | 4289.0 |
| 2024-09-11 19:00:00 | MSFT | Stock | 422.12 | 423.713 | 422.12 | 422.9496 | 17136.0 |
| 2024-09-11 04:00:00 | NVDA | Stock | 107.9 | 108.49 | 107.15 | 107.35 | 277853.0 |
| 2024-09-11 05:00:00 | NVDA | Stock | 107.36 | 107.66 | 107.27 | 107.59 | 178898.0 |
| 2024-09-11 06:00:00 | NVDA | Stock | 107.6 | 107.79 | 107.53 | 107.71 | 92653.0 |
| 2024-09-11 07:00:00 | NVDA | Stock | 107.71 | 108.38 | 107.63 | 108.29 | 643941.0 |
| 2024-09-11 08:00:00 | NVDA | Stock | 107.93 | 109.4 | 106.35 | 109.25 | 5731040.0 |
| 2024-09-11 09:00:00 | NVDA | Stock | 109.25 | 111.93 | 109.16 | 110.24 | 55879808.0 |
| 2024-09-11 10:00:00 | NVDA | Stock | 110.27 | 110.48 | 107.42 | 108.575 | 56118494.0 |
| 2024-09-11 11:00:00 | NVDA | Stock | 108.56 | 111.26 | 108.2 | 111.17 | 43812036.0 |
| 2024-09-11 12:00:00 | NVDA | Stock | 111.17 | 112.88 | 111.01 | 112.075 | 50000626.0 |
| 2024-09-11 13:00:00 | NVDA | Stock | 112.08 | 114.4 | 112.04 | 114.2808 | 47794365.0 |
| 2024-09-11 14:00:00 | NVDA | Stock | 114.28 | 115.5 | 114.21 | 115.105 | 45336486.0 |
| 2024-09-11 15:00:00 | NVDA | Stock | 115.105 | 117.19 | 114.76 | 116.85 | 58582765.0 |
| 2024-09-11 16:00:00 | NVDA | Stock | 116.71 | 117.2 | 116.55 | 116.75 | 26183563.0 |
| 2024-09-11 17:00:00 | NVDA | Stock | 116.7503 | 116.91 | 116.08 | 116.2 | 2692239.0 |
| 2024-09-11 18:00:00 | NVDA | Stock | 116.18 | 116.35 | 116.1 | 116.28 | 568970.0 |
| 2024-09-11 19:00:00 | NVDA | Stock | 116.29 | 116.73 | 116.25 | 116.64 | 799692.0 |
| 2024-09-11 04:00:00 | AMZN | Stock | 179.09 | 179.36 | 179.02 | 179.02 | 4992.0 |
| 2024-09-11 05:00:00 | AMZN | Stock | 179.17 | 179.54 | 179.17 | 179.41 | 1832.0 |
> showing 50 of 58,191 rows — these rows as CSV