PREVIEW / stock_1hour / 2024-04-30
file: by_date/stock_1hour/2024/2024-04-30.parquet size: 1.3 MB rows: 58,590 symbols: 981
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-04-30 04:00:00 | AAPL | Stock | 173.22 | 174.06 | 173.12 | 173.97 | 11531.0 |
| 2024-04-30 05:00:00 | AAPL | Stock | 173.95 | 174.5 | 173.95 | 174.2 | 16787.0 |
| 2024-04-30 06:00:00 | AAPL | Stock | 174.36 | 174.4 | 174.23 | 174.23 | 11603.0 |
| 2024-04-30 07:00:00 | AAPL | Stock | 174.22 | 174.22 | 173.75 | 173.75 | 16299.0 |
| 2024-04-30 08:00:00 | AAPL | Stock | 173.95 | 174.5 | 172.79 | 173.28 | 177381.0 |
| 2024-04-30 09:00:00 | AAPL | Stock | 173.21 | 174.74 | 172.65 | 174.46 | 4659449.0 |
| 2024-04-30 10:00:00 | AAPL | Stock | 174.46 | 174.99 | 174.025 | 174.16 | 4957494.0 |
| 2024-04-30 11:00:00 | AAPL | Stock | 174.17 | 174.4 | 173.605 | 174.15 | 3708606.0 |
| 2024-04-30 12:00:00 | AAPL | Stock | 174.15 | 174.1999 | 173.245 | 173.865 | 2773230.0 |
| 2024-04-30 13:00:00 | AAPL | Stock | 173.86 | 173.93 | 173.1 | 173.68 | 2683340.0 |
| 2024-04-30 14:00:00 | AAPL | Stock | 173.68 | 173.8799 | 172.84 | 173.1223 | 2768503.0 |
| 2024-04-30 15:00:00 | AAPL | Stock | 173.1201 | 173.26 | 170.0 | 170.05 | 11763891.0 |
| 2024-04-30 16:00:00 | AAPL | Stock | 170.38 | 170.89 | 168.45 | 169.9 | 18439809.0 |
| 2024-04-30 17:00:00 | AAPL | Stock | 169.89 | 170.0 | 169.6093 | 169.76 | 66702.0 |
| 2024-04-30 18:00:00 | AAPL | Stock | 169.93 | 170.33 | 169.75 | 170.28 | 73163.0 |
| 2024-04-30 19:00:00 | AAPL | Stock | 170.23 | 170.31 | 169.96 | 169.96 | 30364.0 |
| 2024-04-30 04:00:00 | MSFT | Stock | 402.3 | 402.3 | 401.65 | 401.66 | 2071.0 |
| 2024-04-30 05:00:00 | MSFT | Stock | 401.2 | 401.2 | 401.2 | 401.2 | 200.0 |
| 2024-04-30 06:00:00 | MSFT | Stock | 400.85 | 400.98 | 400.85 | 400.95 | 905.0 |
| 2024-04-30 07:00:00 | MSFT | Stock | 401.55 | 401.68 | 401.35 | 401.41 | 4355.0 |
| 2024-04-30 08:00:00 | MSFT | Stock | 401.1736 | 402.34 | 399.65 | 400.5 | 27923.0 |
| 2024-04-30 09:00:00 | MSFT | Stock | 400.38 | 402.16 | 398.55 | 399.73 | 1613850.0 |
| 2024-04-30 10:00:00 | MSFT | Stock | 399.61 | 399.83 | 398.66 | 399.05 | 1673621.0 |
| 2024-04-30 11:00:00 | MSFT | Stock | 399.04 | 399.04 | 396.4004 | 397.34 | 2415530.0 |
| 2024-04-30 12:00:00 | MSFT | Stock | 397.365 | 397.55 | 394.8 | 395.37 | 1310273.0 |
| 2024-04-30 13:00:00 | MSFT | Stock | 395.38 | 396.0 | 395.06 | 395.75 | 839008.0 |
| 2024-04-30 14:00:00 | MSFT | Stock | 395.75 | 396.11 | 393.2 | 393.7599 | 1477182.0 |
| 2024-04-30 15:00:00 | MSFT | Stock | 393.72 | 394.34 | 389.17 | 389.2 | 3737762.0 |
| 2024-04-30 16:00:00 | MSFT | Stock | 389.21 | 391.36 | 389.21 | 389.76 | 6778169.0 |
| 2024-04-30 17:00:00 | MSFT | Stock | 389.79 | 390.1952 | 389.11 | 390.01 | 59728.0 |
| 2024-04-30 18:00:00 | MSFT | Stock | 390.02 | 390.86 | 389.33 | 390.3 | 30485.0 |
| 2024-04-30 19:00:00 | MSFT | Stock | 390.3 | 390.5 | 390.0 | 390.2 | 14064.0 |
| 2024-04-30 04:00:00 | NVDA | Stock | 87.7 | 87.888 | 87.2 | 87.367 | 82590.0 |
| 2024-04-30 05:00:00 | NVDA | Stock | 87.4 | 87.559 | 87.125 | 87.22 | 74910.0 |
| 2024-04-30 06:00:00 | NVDA | Stock | 87.2 | 87.5 | 87.0 | 87.5 | 114050.0 |
| 2024-04-30 07:00:00 | NVDA | Stock | 87.5 | 87.822 | 87.401 | 87.486 | 312610.0 |
| 2024-04-30 08:00:00 | NVDA | Stock | 87.6882 | 87.823 | 86.824 | 86.901 | 1827660.0 |
| 2024-04-30 09:00:00 | NVDA | Stock | 86.928 | 88.6 | 86.677 | 88.5456 | 44342520.0 |
| 2024-04-30 10:00:00 | NVDA | Stock | 88.546 | 88.819 | 87.35 | 87.9705 | 47041300.0 |
| 2024-04-30 11:00:00 | NVDA | Stock | 87.9728 | 88.19 | 86.7 | 87.151 | 35777700.0 |
| 2024-04-30 12:00:00 | NVDA | Stock | 87.1513 | 87.539 | 86.584 | 86.8415 | 24333030.0 |
| 2024-04-30 13:00:00 | NVDA | Stock | 86.8464 | 87.12 | 86.3 | 86.9572 | 23234880.0 |
| 2024-04-30 14:00:00 | NVDA | Stock | 86.975 | 87.18 | 86.652 | 86.7885 | 21205810.0 |
| 2024-04-30 15:00:00 | NVDA | Stock | 86.775 | 87.389 | 86.335 | 86.37 | 32671500.0 |
| 2024-04-30 16:00:00 | NVDA | Stock | 86.402 | 88.336 | 85.0225 | 85.0225 | 26220580.0 |
| 2024-04-30 17:00:00 | NVDA | Stock | 85.061 | 86.402 | 84.08 | 84.269 | 4154190.0 |
| 2024-04-30 18:00:00 | NVDA | Stock | 84.202 | 85.098 | 84.115 | 84.841 | 1445420.0 |
| 2024-04-30 19:00:00 | NVDA | Stock | 84.84 | 85.178 | 84.75 | 85.069 | 790330.0 |
| 2024-04-30 04:00:00 | AMZN | Stock | 182.49 | 182.5 | 181.79 | 182.0 | 34803.0 |
| 2024-04-30 05:00:00 | AMZN | Stock | 182.0 | 182.18 | 181.99 | 182.05 | 7019.0 |
> showing 50 of 58,590 rows — these rows as CSV