PREVIEW / stock_1hour / 2024-06-04
file: by_date/stock_1hour/2024/2024-06-04.parquet size: 1.3 MB rows: 59,116 symbols: 974
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-04 04:00:00 | AAPL | Stock | 194.03 | 194.03 | 193.31 | 193.31 | 11698.0 |
| 2024-06-04 05:00:00 | AAPL | Stock | 193.25 | 193.4 | 193.02 | 193.2 | 9568.0 |
| 2024-06-04 06:00:00 | AAPL | Stock | 193.21 | 193.43 | 193.03 | 193.3 | 2899.0 |
| 2024-06-04 07:00:00 | AAPL | Stock | 193.46 | 193.88 | 193.4 | 193.68 | 17488.0 |
| 2024-06-04 08:00:00 | AAPL | Stock | 193.41 | 194.42 | 193.3001 | 193.88 | 80128.0 |
| 2024-06-04 09:00:00 | AAPL | Stock | 193.99 | 195.0 | 193.0342 | 193.18 | 5162640.0 |
| 2024-06-04 10:00:00 | AAPL | Stock | 193.18 | 194.4 | 193.08 | 194.1801 | 5690860.0 |
| 2024-06-04 11:00:00 | AAPL | Stock | 194.19 | 194.28 | 193.715 | 193.8499 | 2858945.0 |
| 2024-06-04 12:00:00 | AAPL | Stock | 193.845 | 194.82 | 193.845 | 194.525 | 2813206.0 |
| 2024-06-04 13:00:00 | AAPL | Stock | 194.525 | 194.86 | 194.38 | 194.57 | 2285925.0 |
| 2024-06-04 14:00:00 | AAPL | Stock | 194.57 | 195.32 | 194.5386 | 194.67 | 4353965.0 |
| 2024-06-04 15:00:00 | AAPL | Stock | 194.66 | 194.87 | 193.93 | 194.365 | 5878727.0 |
| 2024-06-04 16:00:00 | AAPL | Stock | 194.35 | 194.4695 | 194.08 | 194.4 | 8623927.0 |
| 2024-06-04 17:00:00 | AAPL | Stock | 194.4 | 194.42 | 194.26 | 194.3994 | 140038.0 |
| 2024-06-04 18:00:00 | AAPL | Stock | 194.4 | 194.52 | 194.37 | 194.5 | 13243.0 |
| 2024-06-04 19:00:00 | AAPL | Stock | 194.51 | 194.99 | 194.5 | 194.64 | 17051.0 |
| 2024-06-04 04:00:00 | MSFT | Stock | 413.8 | 413.8 | 412.27 | 412.45 | 6938.0 |
| 2024-06-04 05:00:00 | MSFT | Stock | 412.31 | 412.31 | 412.0 | 412.0 | 400.0 |
| 2024-06-04 06:00:00 | MSFT | Stock | 411.6 | 412.05 | 410.93 | 411.08 | 6951.0 |
| 2024-06-04 07:00:00 | MSFT | Stock | 411.28 | 412.26 | 411.28 | 412.06 | 2333.0 |
| 2024-06-04 08:00:00 | MSFT | Stock | 411.31 | 417.77 | 411.18 | 412.5 | 20081.0 |
| 2024-06-04 09:00:00 | MSFT | Stock | 412.59 | 413.25 | 409.675 | 411.39 | 1358929.0 |
| 2024-06-04 10:00:00 | MSFT | Stock | 411.39 | 413.43 | 410.95 | 412.28 | 1248178.0 |
| 2024-06-04 11:00:00 | MSFT | Stock | 412.28 | 413.049 | 411.5 | 412.16 | 582222.0 |
| 2024-06-04 12:00:00 | MSFT | Stock | 412.2 | 413.37 | 412.0 | 412.91 | 592709.0 |
| 2024-06-04 13:00:00 | MSFT | Stock | 412.905 | 413.81 | 412.26 | 413.46 | 453652.0 |
| 2024-06-04 14:00:00 | MSFT | Stock | 413.41 | 415.37 | 412.916 | 414.53 | 682642.0 |
| 2024-06-04 15:00:00 | MSFT | Stock | 414.5 | 416.44 | 412.95 | 416.07 | 1240642.0 |
| 2024-06-04 16:00:00 | MSFT | Stock | 416.07 | 416.46 | 412.1953 | 416.31 | 2700460.0 |
| 2024-06-04 17:00:00 | MSFT | Stock | 416.41 | 416.43 | 416.07 | 416.2052 | 29268.0 |
| 2024-06-04 18:00:00 | MSFT | Stock | 416.3 | 416.43 | 416.2 | 416.3106 | 2895.0 |
| 2024-06-04 19:00:00 | MSFT | Stock | 416.38 | 416.7499 | 416.38 | 416.56 | 4690.0 |
| 2024-06-04 04:00:00 | NVDA | Stock | 115.0 | 115.59 | 113.48 | 113.69 | 362780.0 |
| 2024-06-04 05:00:00 | NVDA | Stock | 113.655 | 114.338 | 113.107 | 114.16 | 401310.0 |
| 2024-06-04 06:00:00 | NVDA | Stock | 114.12 | 114.529 | 114.04 | 114.4 | 221950.0 |
| 2024-06-04 07:00:00 | NVDA | Stock | 114.487 | 115.044 | 114.375 | 114.875 | 1238930.0 |
| 2024-06-04 08:00:00 | NVDA | Stock | 114.599 | 115.8 | 113.7207 | 114.732 | 2337810.0 |
| 2024-06-04 09:00:00 | NVDA | Stock | 114.7294 | 116.123 | 114.2 | 114.719 | 50305730.0 |
| 2024-06-04 10:00:00 | NVDA | Stock | 114.72 | 115.296 | 114.1 | 114.517 | 43620320.0 |
| 2024-06-04 11:00:00 | NVDA | Stock | 114.541 | 114.773 | 114.045 | 114.379 | 23535820.0 |
| 2024-06-04 12:00:00 | NVDA | Stock | 114.379 | 115.52 | 114.2 | 115.418 | 23375070.0 |
| 2024-06-04 13:00:00 | NVDA | Stock | 115.425 | 115.445 | 114.677 | 114.9105 | 20859910.0 |
| 2024-06-04 14:00:00 | NVDA | Stock | 114.9105 | 116.6 | 114.854 | 116.268 | 37617080.0 |
| 2024-06-04 15:00:00 | NVDA | Stock | 116.252 | 116.5262 | 115.532 | 116.444 | 42835840.0 |
| 2024-06-04 16:00:00 | NVDA | Stock | 116.437 | 116.55 | 115.1662 | 116.1816 | 13486220.0 |
| 2024-06-04 17:00:00 | NVDA | Stock | 116.2 | 116.437 | 116.2 | 116.35 | 866870.0 |
| 2024-06-04 18:00:00 | NVDA | Stock | 116.3149 | 116.3149 | 116.201 | 116.231 | 249760.0 |
| 2024-06-04 19:00:00 | NVDA | Stock | 116.23 | 116.384 | 116.204 | 116.335 | 409100.0 |
| 2024-06-04 04:00:00 | AMZN | Stock | 178.33 | 178.33 | 177.48 | 177.48 | 6830.0 |
| 2024-06-04 05:00:00 | AMZN | Stock | 177.5 | 177.73 | 177.2 | 177.5 | 10822.0 |
> showing 50 of 59,116 rows — these rows as CSV