PREVIEW / stock_1hour / 2024-09-20
file: by_date/stock_1hour/2024/2024-09-20.parquet size: 1.4 MB rows: 59,008 symbols: 791
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-09-20 04:00:00 | AAPL | Stock | 228.15 | 228.42 | 227.74 | 227.84 | 31439.0 |
| 2024-09-20 05:00:00 | AAPL | Stock | 227.9 | 227.92 | 227.4 | 227.63 | 23660.0 |
| 2024-09-20 06:00:00 | AAPL | Stock | 227.5 | 227.6 | 227.11 | 227.2 | 16706.0 |
| 2024-09-20 07:00:00 | AAPL | Stock | 227.47 | 227.98 | 227.37 | 227.9 | 59367.0 |
| 2024-09-20 08:00:00 | AAPL | Stock | 227.4573 | 229.99 | 227.4201 | 229.442 | 380151.0 |
| 2024-09-20 09:00:00 | AAPL | Stock | 229.48 | 231.16 | 228.74 | 230.0 | 17634922.0 |
| 2024-09-20 10:00:00 | AAPL | Stock | 230.0 | 230.58 | 229.37 | 230.305 | 7172470.0 |
| 2024-09-20 11:00:00 | AAPL | Stock | 230.305 | 230.9499 | 229.2 | 230.8 | 6359897.0 |
| 2024-09-20 12:00:00 | AAPL | Stock | 230.8 | 231.93 | 230.75 | 231.845 | 5044270.0 |
| 2024-09-20 13:00:00 | AAPL | Stock | 231.845 | 231.9 | 230.61 | 230.665 | 5158811.0 |
| 2024-09-20 14:00:00 | AAPL | Stock | 230.665 | 231.61 | 229.5 | 231.48 | 7676088.0 |
| 2024-09-20 15:00:00 | AAPL | Stock | 231.478 | 233.09 | 227.62 | 228.53 | 26199162.0 |
| 2024-09-20 16:00:00 | AAPL | Stock | 228.53 | 228.7 | 227.75 | 228.05 | 118427487.0 |
| 2024-09-20 17:00:00 | AAPL | Stock | 228.05 | 228.23 | 227.8 | 227.8704 | 136525.0 |
| 2024-09-20 18:00:00 | AAPL | Stock | 227.8732 | 228.0 | 227.77 | 227.85 | 49606.0 |
| 2024-09-20 19:00:00 | AAPL | Stock | 227.86 | 227.94 | 227.72 | 227.76 | 35561.0 |
| 2024-09-20 04:00:00 | MSFT | Stock | 438.14 | 438.79 | 438.0 | 438.19 | 2194.0 |
| 2024-09-20 05:00:00 | MSFT | Stock | 438.11 | 438.19 | 437.85 | 437.91 | 903.0 |
| 2024-09-20 06:00:00 | MSFT | Stock | 437.75 | 437.75 | 436.69 | 436.89 | 3129.0 |
| 2024-09-20 07:00:00 | MSFT | Stock | 437.0 | 438.0 | 437.0 | 438.0 | 3239.0 |
| 2024-09-20 08:00:00 | MSFT | Stock | 437.55 | 439.39 | 437.0 | 439.39 | 15201.0 |
| 2024-09-20 09:00:00 | MSFT | Stock | 439.4999 | 439.4999 | 436.49 | 436.785 | 6268568.0 |
| 2024-09-20 10:00:00 | MSFT | Stock | 436.785 | 437.4 | 434.9 | 434.99 | 1029600.0 |
| 2024-09-20 11:00:00 | MSFT | Stock | 435.02 | 436.43 | 434.22 | 435.86 | 724707.0 |
| 2024-09-20 12:00:00 | MSFT | Stock | 435.88 | 437.96 | 435.72 | 437.255 | 681921.0 |
| 2024-09-20 13:00:00 | MSFT | Stock | 437.23 | 437.5968 | 436.65 | 436.87 | 579320.0 |
| 2024-09-20 14:00:00 | MSFT | Stock | 436.84 | 437.05 | 435.53 | 436.0651 | 834030.0 |
| 2024-09-20 15:00:00 | MSFT | Stock | 436.06 | 437.92 | 435.15 | 435.23 | 2647115.0 |
| 2024-09-20 16:00:00 | MSFT | Stock | 435.27 | 436.42 | 435.26 | 435.52 | 23652106.0 |
| 2024-09-20 17:00:00 | MSFT | Stock | 435.5 | 435.77 | 435.27 | 435.27 | 100078.0 |
| 2024-09-20 18:00:00 | MSFT | Stock | 435.62 | 435.7557 | 435.6 | 435.61 | 1773.0 |
| 2024-09-20 19:00:00 | MSFT | Stock | 435.6 | 436.05 | 435.6 | 436.028 | 4437.0 |
| 2024-09-20 04:00:00 | NVDA | Stock | 118.15 | 118.15 | 116.61 | 117.16 | 672541.0 |
| 2024-09-20 05:00:00 | NVDA | Stock | 117.16 | 117.39 | 116.8 | 116.87 | 226538.0 |
| 2024-09-20 06:00:00 | NVDA | Stock | 116.86 | 117.2 | 116.65 | 116.8 | 170570.0 |
| 2024-09-20 07:00:00 | NVDA | Stock | 116.8 | 117.06 | 116.74 | 117.02 | 560756.0 |
| 2024-09-20 08:00:00 | NVDA | Stock | 116.93 | 118.38 | 116.66 | 117.48 | 2404076.0 |
| 2024-09-20 09:00:00 | NVDA | Stock | 117.48 | 118.6181 | 116.86 | 117.59 | 45035920.0 |
| 2024-09-20 10:00:00 | NVDA | Stock | 117.585 | 117.95 | 116.18 | 116.51 | 37923169.0 |
| 2024-09-20 11:00:00 | NVDA | Stock | 116.515 | 116.63 | 115.3901 | 116.295 | 33335252.0 |
| 2024-09-20 12:00:00 | NVDA | Stock | 116.295 | 116.82 | 116.05 | 116.28 | 18878870.0 |
| 2024-09-20 13:00:00 | NVDA | Stock | 116.27 | 116.56 | 115.95 | 116.0 | 15914336.0 |
| 2024-09-20 14:00:00 | NVDA | Stock | 116.0093 | 116.15 | 115.5 | 116.0701 | 19213182.0 |
| 2024-09-20 15:00:00 | NVDA | Stock | 116.075 | 116.89 | 115.7 | 116.07 | 35255389.0 |
| 2024-09-20 16:00:00 | NVDA | Stock | 116.1 | 116.6 | 115.99 | 116.02 | 90049833.0 |
| 2024-09-20 17:00:00 | NVDA | Stock | 116.02 | 116.0997 | 116.0 | 116.07 | 1668776.0 |
| 2024-09-20 18:00:00 | NVDA | Stock | 116.08 | 116.1799 | 116.05 | 116.14 | 192806.0 |
| 2024-09-20 19:00:00 | NVDA | Stock | 116.1301 | 116.14 | 116.042 | 116.07 | 225525.0 |
| 2024-09-20 04:00:00 | AMZN | Stock | 189.4 | 189.71 | 189.01 | 189.3 | 8771.0 |
| 2024-09-20 05:00:00 | AMZN | Stock | 189.4 | 189.41 | 189.13 | 189.28 | 3270.0 |
> showing 50 of 59,008 rows — these rows as CSV