PREVIEW / stock_1hour / 2024-06-05
file: by_date/stock_1hour/2024/2024-06-05.parquet size: 1.3 MB rows: 59,274 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-06-05 04:00:00 | AAPL | Stock | 194.99 | 195.2 | 194.7 | 194.81 | 9742.0 |
| 2024-06-05 05:00:00 | AAPL | Stock | 194.85 | 194.95 | 194.58 | 194.79 | 15143.0 |
| 2024-06-05 06:00:00 | AAPL | Stock | 194.67 | 194.95 | 194.61 | 194.61 | 13264.0 |
| 2024-06-05 07:00:00 | AAPL | Stock | 194.82 | 194.93 | 194.7 | 194.83 | 30278.0 |
| 2024-06-05 08:00:00 | AAPL | Stock | 194.79 | 195.13 | 194.6678 | 195.12 | 91231.0 |
| 2024-06-05 09:00:00 | AAPL | Stock | 195.11 | 196.42 | 194.87 | 195.78 | 6185608.0 |
| 2024-06-05 10:00:00 | AAPL | Stock | 195.75 | 195.83 | 195.01 | 195.27 | 4993367.0 |
| 2024-06-05 11:00:00 | AAPL | Stock | 195.27 | 196.9 | 195.195 | 196.02 | 5651462.0 |
| 2024-06-05 12:00:00 | AAPL | Stock | 196.01 | 196.3 | 195.82 | 196.035 | 3077164.0 |
| 2024-06-05 13:00:00 | AAPL | Stock | 196.04 | 196.7 | 195.59 | 196.67 | 4146481.0 |
| 2024-06-05 14:00:00 | AAPL | Stock | 196.665 | 196.69 | 195.83 | 195.83 | 3409222.0 |
| 2024-06-05 15:00:00 | AAPL | Stock | 195.83 | 196.45 | 195.62 | 195.9 | 7369885.0 |
| 2024-06-05 16:00:00 | AAPL | Stock | 195.88 | 195.88 | 195.36 | 195.45 | 7140595.0 |
| 2024-06-05 17:00:00 | AAPL | Stock | 195.5 | 195.87 | 195.36 | 195.4365 | 792972.0 |
| 2024-06-05 18:00:00 | AAPL | Stock | 195.42 | 195.5999 | 195.34 | 195.59 | 37079.0 |
| 2024-06-05 19:00:00 | AAPL | Stock | 195.59 | 195.64 | 195.45 | 195.53 | 29914.0 |
| 2024-06-05 04:00:00 | MSFT | Stock | 416.85 | 417.7 | 416.82 | 417.7 | 2380.0 |
| 2024-06-05 05:00:00 | MSFT | Stock | 417.71 | 418.1 | 417.64 | 417.74 | 1413.0 |
| 2024-06-05 06:00:00 | MSFT | Stock | 417.81 | 417.95 | 417.22 | 417.22 | 6487.0 |
| 2024-06-05 07:00:00 | MSFT | Stock | 417.17 | 417.7 | 417.0 | 417.45 | 4312.0 |
| 2024-06-05 08:00:00 | MSFT | Stock | 417.25 | 417.87 | 416.95 | 417.4897 | 27852.0 |
| 2024-06-05 09:00:00 | MSFT | Stock | 417.42 | 418.7 | 416.3 | 418.3 | 1345533.0 |
| 2024-06-05 10:00:00 | MSFT | Stock | 418.31 | 419.908 | 416.73 | 419.62 | 1348070.0 |
| 2024-06-05 11:00:00 | MSFT | Stock | 419.66 | 421.11 | 419.63 | 420.66 | 968347.0 |
| 2024-06-05 12:00:00 | MSFT | Stock | 420.6 | 422.75 | 420.23 | 422.38 | 914855.0 |
| 2024-06-05 13:00:00 | MSFT | Stock | 422.3937 | 423.35 | 422.16 | 422.93 | 781336.0 |
| 2024-06-05 14:00:00 | MSFT | Stock | 422.925 | 423.61 | 422.42 | 423.4765 | 624890.0 |
| 2024-06-05 15:00:00 | MSFT | Stock | 423.47 | 424.08 | 422.12 | 424.04 | 1830757.0 |
| 2024-06-05 16:00:00 | MSFT | Stock | 424.01 | 424.01 | 422.88 | 423.49 | 3380613.0 |
| 2024-06-05 17:00:00 | MSFT | Stock | 423.31 | 424.01 | 423.23 | 423.33 | 647717.0 |
| 2024-06-05 18:00:00 | MSFT | Stock | 423.34 | 423.9 | 423.27 | 423.81 | 7025.0 |
| 2024-06-05 19:00:00 | MSFT | Stock | 423.78 | 423.94 | 423.47 | 423.47 | 2187.0 |
| 2024-06-05 04:00:00 | NVDA | Stock | 116.42 | 117.387 | 116.3 | 117.387 | 357480.0 |
| 2024-06-05 05:00:00 | NVDA | Stock | 117.311 | 118.45 | 117.3 | 118.25 | 818320.0 |
| 2024-06-05 06:00:00 | NVDA | Stock | 118.281 | 118.3 | 117.95 | 117.95 | 456340.0 |
| 2024-06-05 07:00:00 | NVDA | Stock | 117.94 | 118.23 | 117.413 | 118.0 | 1583980.0 |
| 2024-06-05 08:00:00 | NVDA | Stock | 117.821 | 118.233 | 116.325 | 118.09 | 3417570.0 |
| 2024-06-05 09:00:00 | NVDA | Stock | 118.08 | 119.381 | 117.468 | 119.31 | 54208280.0 |
| 2024-06-05 10:00:00 | NVDA | Stock | 119.311 | 119.95 | 118.985 | 119.869 | 51770250.0 |
| 2024-06-05 11:00:00 | NVDA | Stock | 119.865 | 119.993 | 119.581 | 119.927 | 27880980.0 |
| 2024-06-05 12:00:00 | NVDA | Stock | 119.91 | 120.492 | 119.7 | 120.489 | 30165420.0 |
| 2024-06-05 13:00:00 | NVDA | Stock | 120.487 | 121.45 | 120.414 | 121.436 | 44755670.0 |
| 2024-06-05 14:00:00 | NVDA | Stock | 121.418 | 121.85 | 120.957 | 121.84 | 30234830.0 |
| 2024-06-05 15:00:00 | NVDA | Stock | 121.814 | 122.4495 | 121.605 | 122.439 | 55579260.0 |
| 2024-06-05 16:00:00 | NVDA | Stock | 122.44 | 123.349 | 119.9782 | 123.14 | 20101520.0 |
| 2024-06-05 17:00:00 | NVDA | Stock | 123.131 | 123.7 | 122.44 | 123.3713 | 2492230.0 |
| 2024-06-05 18:00:00 | NVDA | Stock | 123.42 | 123.9 | 123.37 | 123.687 | 1245800.0 |
| 2024-06-05 19:00:00 | NVDA | Stock | 123.716 | 123.805 | 123.553 | 123.595 | 1154660.0 |
| 2024-06-05 04:00:00 | AMZN | Stock | 179.83 | 180.29 | 179.77 | 180.11 | 9707.0 |
| 2024-06-05 05:00:00 | AMZN | Stock | 180.22 | 180.23 | 180.0 | 180.07 | 6332.0 |
> showing 50 of 59,274 rows — these rows as CSV