PREVIEW / stock_1hour / 2024-12-19
file: by_date/stock_1hour/2024/2024-12-19.parquet size: 1.5 MB rows: 65,098 symbols: 651
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-12-19 04:00:00 | AAPL | Stock | 247.89 | 247.99 | 247.09 | 247.62 | 39052.0 |
| 2024-12-19 05:00:00 | AAPL | Stock | 247.62 | 247.98 | 247.4 | 247.73 | 26416.0 |
| 2024-12-19 06:00:00 | AAPL | Stock | 247.84 | 247.94 | 247.52 | 247.59 | 11823.0 |
| 2024-12-19 07:00:00 | AAPL | Stock | 247.59 | 248.33 | 247.59 | 247.99 | 44099.0 |
| 2024-12-19 08:00:00 | AAPL | Stock | 247.8 | 248.6 | 246.47 | 247.37 | 154633.0 |
| 2024-12-19 09:00:00 | AAPL | Stock | 247.35 | 249.17 | 247.0 | 248.69 | 5251797.0 |
| 2024-12-19 10:00:00 | AAPL | Stock | 248.69 | 251.02 | 248.65 | 250.46 | 6216873.0 |
| 2024-12-19 11:00:00 | AAPL | Stock | 250.46 | 251.85 | 249.495 | 251.13 | 3503639.0 |
| 2024-12-19 12:00:00 | AAPL | Stock | 251.13 | 251.69 | 249.72 | 250.655 | 2842655.0 |
| 2024-12-19 13:00:00 | AAPL | Stock | 250.645 | 251.35 | 249.81 | 251.32 | 1792497.0 |
| 2024-12-19 14:00:00 | AAPL | Stock | 251.33 | 251.45 | 250.031 | 250.06 | 1724932.0 |
| 2024-12-19 15:00:00 | AAPL | Stock | 250.06 | 252.0 | 249.4093 | 249.85 | 4519255.0 |
| 2024-12-19 16:00:00 | AAPL | Stock | 249.85 | 250.11 | 249.29 | 250.0686 | 15056802.0 |
| 2024-12-19 17:00:00 | AAPL | Stock | 249.79 | 250.02 | 249.79 | 249.82 | 26495.0 |
| 2024-12-19 18:00:00 | AAPL | Stock | 249.93 | 249.96 | 249.29 | 249.3501 | 13244.0 |
| 2024-12-19 19:00:00 | AAPL | Stock | 249.45 | 249.6 | 248.66 | 248.79 | 31738.0 |
| 2024-12-19 04:00:00 | MSFT | Stock | 440.79 | 441.75 | 439.55 | 440.01 | 13468.0 |
| 2024-12-19 05:00:00 | MSFT | Stock | 440.1 | 440.6 | 439.64 | 440.2 | 5810.0 |
| 2024-12-19 06:00:00 | MSFT | Stock | 440.22 | 441.0 | 439.53 | 440.29 | 8905.0 |
| 2024-12-19 07:00:00 | MSFT | Stock | 440.46 | 442.38 | 440.46 | 442.38 | 7635.0 |
| 2024-12-19 08:00:00 | MSFT | Stock | 441.0 | 442.75 | 439.48 | 441.0 | 40507.0 |
| 2024-12-19 09:00:00 | MSFT | Stock | 440.82 | 442.9693 | 438.34 | 439.54 | 1614647.0 |
| 2024-12-19 10:00:00 | MSFT | Stock | 439.36 | 442.3799 | 438.33 | 441.76 | 1373488.0 |
| 2024-12-19 11:00:00 | MSFT | Stock | 441.79 | 443.1834 | 439.85 | 442.085 | 940698.0 |
| 2024-12-19 12:00:00 | MSFT | Stock | 442.075 | 442.13 | 439.52 | 440.355 | 774573.0 |
| 2024-12-19 13:00:00 | MSFT | Stock | 440.355 | 440.69 | 438.92 | 440.63 | 534796.0 |
| 2024-12-19 14:00:00 | MSFT | Stock | 440.63 | 440.74 | 438.9001 | 439.025 | 640517.0 |
| 2024-12-19 15:00:00 | MSFT | Stock | 439.01 | 439.25 | 436.32 | 437.1 | 2144913.0 |
| 2024-12-19 16:00:00 | MSFT | Stock | 437.02 | 437.99 | 436.15 | 437.55 | 4880996.0 |
| 2024-12-19 17:00:00 | MSFT | Stock | 437.03 | 437.9 | 437.03 | 437.26 | 3477.0 |
| 2024-12-19 18:00:00 | MSFT | Stock | 437.5 | 438.22 | 437.23 | 437.55 | 9306.0 |
| 2024-12-19 19:00:00 | MSFT | Stock | 437.6 | 437.84 | 435.98 | 435.99 | 6394.0 |
| 2024-12-19 04:00:00 | NVDA | Stock | 132.1 | 133.0 | 131.6 | 132.03 | 709694.0 |
| 2024-12-19 05:00:00 | NVDA | Stock | 132.03 | 132.3 | 131.03 | 131.33 | 338803.0 |
| 2024-12-19 06:00:00 | NVDA | Stock | 131.31 | 131.8 | 131.05 | 131.38 | 378314.0 |
| 2024-12-19 07:00:00 | NVDA | Stock | 131.38 | 132.7 | 131.36 | 132.49 | 882366.0 |
| 2024-12-19 08:00:00 | NVDA | Stock | 131.66 | 132.7741 | 131.04 | 131.9 | 2618772.0 |
| 2024-12-19 09:00:00 | NVDA | Stock | 131.86 | 132.24 | 129.8217 | 130.94 | 26136138.0 |
| 2024-12-19 10:00:00 | NVDA | Stock | 130.93 | 132.06 | 129.55 | 131.62 | 30039750.0 |
| 2024-12-19 11:00:00 | NVDA | Stock | 131.6 | 134.03 | 130.8014 | 133.05 | 25175425.0 |
| 2024-12-19 12:00:00 | NVDA | Stock | 133.05 | 133.18 | 131.45 | 132.396 | 16870362.0 |
| 2024-12-19 13:00:00 | NVDA | Stock | 132.38 | 132.95 | 131.52 | 132.89 | 13163153.0 |
| 2024-12-19 14:00:00 | NVDA | Stock | 132.87 | 132.87 | 131.31 | 131.54 | 11870892.0 |
| 2024-12-19 15:00:00 | NVDA | Stock | 131.535 | 132.09 | 130.3 | 130.65 | 20628692.0 |
| 2024-12-19 16:00:00 | NVDA | Stock | 130.65 | 131.32 | 130.2 | 131.03 | 20135656.0 |
| 2024-12-19 17:00:00 | NVDA | Stock | 131.01 | 131.13 | 130.68 | 130.98 | 226130.0 |
| 2024-12-19 18:00:00 | NVDA | Stock | 131.0 | 131.25 | 130.87 | 131.04 | 248180.0 |
| 2024-12-19 19:00:00 | NVDA | Stock | 131.04 | 131.09 | 130.0 | 130.02 | 492024.0 |
| 2024-12-19 04:00:00 | AMZN | Stock | 222.0 | 222.3 | 221.41 | 221.84 | 31492.0 |
| 2024-12-19 05:00:00 | AMZN | Stock | 221.93 | 222.58 | 221.77 | 221.84 | 16623.0 |
> showing 50 of 65,098 rows — these rows as CSV