PREVIEW / stock_1hour / 2024-06-03
file: by_date/stock_1hour/2024/2024-06-03.parquet size: 1.3 MB rows: 60,245 symbols: 975
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-03 04:00:00 | AAPL | Stock | 192.45 | 193.3 | 192.45 | 193.1 | 50995.0 |
| 2024-06-03 05:00:00 | AAPL | Stock | 193.0 | 193.11 | 192.92 | 192.98 | 29384.0 |
| 2024-06-03 06:00:00 | AAPL | Stock | 193.0 | 193.08 | 192.79 | 192.8 | 15245.0 |
| 2024-06-03 07:00:00 | AAPL | Stock | 192.85 | 193.1 | 192.62 | 192.95 | 33062.0 |
| 2024-06-03 08:00:00 | AAPL | Stock | 192.8014 | 193.53 | 191.77 | 192.82 | 175769.0 |
| 2024-06-03 09:00:00 | AAPL | Stock | 192.8 | 194.56 | 192.48 | 194.11 | 7469115.0 |
| 2024-06-03 10:00:00 | AAPL | Stock | 194.13 | 194.99 | 193.91 | 193.95 | 7072044.0 |
| 2024-06-03 11:00:00 | AAPL | Stock | 193.94 | 194.43 | 193.58 | 193.93 | 3881165.0 |
| 2024-06-03 12:00:00 | AAPL | Stock | 193.9202 | 194.09 | 192.92 | 193.255 | 3658829.0 |
| 2024-06-03 13:00:00 | AAPL | Stock | 193.255 | 194.055 | 192.84 | 193.61 | 3294300.0 |
| 2024-06-03 14:00:00 | AAPL | Stock | 193.61 | 193.66 | 192.9101 | 193.0499 | 3032680.0 |
| 2024-06-03 15:00:00 | AAPL | Stock | 193.04 | 194.11 | 192.945 | 194.09 | 5715526.0 |
| 2024-06-03 16:00:00 | AAPL | Stock | 194.03 | 194.4 | 194.02 | 194.1 | 5833438.0 |
| 2024-06-03 17:00:00 | AAPL | Stock | 194.1 | 194.15 | 194.03 | 194.1 | 36580.0 |
| 2024-06-03 18:00:00 | AAPL | Stock | 194.1 | 194.29 | 194.03 | 194.03 | 25066.0 |
| 2024-06-03 19:00:00 | AAPL | Stock | 194.03 | 194.11 | 194.03 | 194.08 | 16373.0 |
| 2024-06-03 04:00:00 | MSFT | Stock | 416.5 | 416.5 | 415.7 | 416.34 | 8846.0 |
| 2024-06-03 05:00:00 | MSFT | Stock | 416.35 | 416.91 | 415.24 | 416.06 | 7658.0 |
| 2024-06-03 06:00:00 | MSFT | Stock | 416.01 | 416.38 | 415.68 | 415.98 | 3544.0 |
| 2024-06-03 07:00:00 | MSFT | Stock | 415.85 | 416.75 | 415.67 | 416.63 | 11744.0 |
| 2024-06-03 08:00:00 | MSFT | Stock | 416.3454 | 417.23 | 415.5416 | 416.259 | 59378.0 |
| 2024-06-03 09:00:00 | MSFT | Stock | 416.35 | 417.35 | 412.9492 | 413.18 | 1879031.0 |
| 2024-06-03 10:00:00 | MSFT | Stock | 413.48 | 415.04 | 412.22 | 412.57 | 1472891.0 |
| 2024-06-03 11:00:00 | MSFT | Stock | 412.555 | 413.0 | 411.25 | 412.1 | 1136102.0 |
| 2024-06-03 12:00:00 | MSFT | Stock | 412.13 | 412.4199 | 408.9234 | 409.94 | 1021758.0 |
| 2024-06-03 13:00:00 | MSFT | Stock | 409.88 | 412.4 | 409.2379 | 411.95 | 933153.0 |
| 2024-06-03 14:00:00 | MSFT | Stock | 411.9 | 412.23 | 410.64 | 410.97 | 796670.0 |
| 2024-06-03 15:00:00 | MSFT | Stock | 411.01 | 413.73 | 410.8401 | 413.65 | 1522593.0 |
| 2024-06-03 16:00:00 | MSFT | Stock | 413.65 | 413.75 | 413.0 | 413.25 | 1984410.0 |
| 2024-06-03 17:00:00 | MSFT | Stock | 413.08 | 413.48 | 412.66 | 412.66 | 3500.0 |
| 2024-06-03 18:00:00 | MSFT | Stock | 412.81 | 414.45 | 412.7178 | 414.28 | 13915.0 |
| 2024-06-03 19:00:00 | MSFT | Stock | 414.28 | 414.73 | 413.9 | 414.4 | 18674.0 |
| 2024-06-03 04:00:00 | NVDA | Stock | 112.448 | 113.0 | 111.81 | 112.97 | 825160.0 |
| 2024-06-03 05:00:00 | NVDA | Stock | 112.968 | 112.99 | 112.7 | 112.88 | 334800.0 |
| 2024-06-03 06:00:00 | NVDA | Stock | 112.888 | 112.9 | 112.499 | 112.53 | 186200.0 |
| 2024-06-03 07:00:00 | NVDA | Stock | 112.54 | 113.05 | 112.037 | 112.9 | 1662650.0 |
| 2024-06-03 08:00:00 | NVDA | Stock | 112.5301 | 113.54 | 109.907 | 113.13 | 4727270.0 |
| 2024-06-03 09:00:00 | NVDA | Stock | 113.149 | 114.384 | 113.046 | 113.449 | 52597370.0 |
| 2024-06-03 10:00:00 | NVDA | Stock | 113.492 | 114.167 | 112.0535 | 112.6 | 49015870.0 |
| 2024-06-03 11:00:00 | NVDA | Stock | 112.606 | 114.16 | 112.003 | 113.981 | 34887400.0 |
| 2024-06-03 12:00:00 | NVDA | Stock | 113.9705 | 114.142 | 112.718 | 113.15 | 30819280.0 |
| 2024-06-03 13:00:00 | NVDA | Stock | 113.104 | 114.092 | 112.504 | 113.686 | 28007430.0 |
| 2024-06-03 14:00:00 | NVDA | Stock | 113.686 | 113.993 | 113.351 | 113.666 | 19519110.0 |
| 2024-06-03 15:00:00 | NVDA | Stock | 113.66 | 115.0 | 113.611 | 114.9995 | 43753790.0 |
| 2024-06-03 16:00:00 | NVDA | Stock | 114.911 | 115.708 | 114.817 | 115.55 | 18394520.0 |
| 2024-06-03 17:00:00 | NVDA | Stock | 115.526 | 115.5719 | 115.0 | 115.485 | 633980.0 |
| 2024-06-03 18:00:00 | NVDA | Stock | 115.48 | 115.48 | 115.201 | 115.3 | 626480.0 |
| 2024-06-03 19:00:00 | NVDA | Stock | 115.265 | 115.547 | 115.252 | 115.4 | 824950.0 |
| 2024-06-03 04:00:00 | AMZN | Stock | 176.96 | 177.57 | 176.62 | 177.5 | 40583.0 |
| 2024-06-03 05:00:00 | AMZN | Stock | 177.34 | 177.34 | 176.9 | 176.9 | 16737.0 |
> showing 50 of 60,245 rows — these rows as CSV