PREVIEW / stock_1hour / 2024-05-29
file: by_date/stock_1hour/2024/2024-05-29.parquet size: 1.3 MB rows: 59,097 symbols: 964
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-05-29 04:00:00 | AAPL | Stock | 189.88 | 189.95 | 189.0 | 189.39 | 20500.0 |
| 2024-05-29 05:00:00 | AAPL | Stock | 189.4 | 189.52 | 189.3 | 189.45 | 5434.0 |
| 2024-05-29 06:00:00 | AAPL | Stock | 189.54 | 189.88 | 189.54 | 189.71 | 9349.0 |
| 2024-05-29 07:00:00 | AAPL | Stock | 189.82 | 189.99 | 189.5 | 189.99 | 35413.0 |
| 2024-05-29 08:00:00 | AAPL | Stock | 189.8 | 190.7 | 189.5 | 190.3 | 230477.0 |
| 2024-05-29 09:00:00 | AAPL | Stock | 190.27 | 192.247 | 189.3 | 191.785 | 7283753.0 |
| 2024-05-29 10:00:00 | AAPL | Stock | 191.8 | 192.24 | 191.35 | 192.1796 | 5972914.0 |
| 2024-05-29 11:00:00 | AAPL | Stock | 192.17 | 192.175 | 191.08 | 191.4465 | 3883641.0 |
| 2024-05-29 12:00:00 | AAPL | Stock | 191.45 | 192.03 | 191.26 | 191.8938 | 3000910.0 |
| 2024-05-29 13:00:00 | AAPL | Stock | 191.895 | 192.015 | 191.47 | 191.78 | 2891960.0 |
| 2024-05-29 14:00:00 | AAPL | Stock | 191.775 | 191.775 | 191.12 | 191.22 | 2841723.0 |
| 2024-05-29 15:00:00 | AAPL | Stock | 191.2114 | 191.265 | 189.95 | 190.37 | 7718659.0 |
| 2024-05-29 16:00:00 | AAPL | Stock | 190.42 | 190.42 | 189.5 | 189.8 | 7973767.0 |
| 2024-05-29 17:00:00 | AAPL | Stock | 190.29 | 190.55 | 189.8 | 190.5 | 209778.0 |
| 2024-05-29 18:00:00 | AAPL | Stock | 190.36 | 190.6 | 189.93 | 190.01 | 33202.0 |
| 2024-05-29 19:00:00 | AAPL | Stock | 189.99 | 190.25 | 189.99 | 190.25 | 17272.0 |
| 2024-05-29 04:00:00 | MSFT | Stock | 427.64 | 427.64 | 427.5 | 427.5 | 1360.0 |
| 2024-05-29 05:00:00 | MSFT | Stock | 427.5 | 427.5 | 427.5 | 427.5 | 200.0 |
| 2024-05-29 06:00:00 | MSFT | Stock | 427.53 | 427.74 | 427.5 | 427.5 | 1838.0 |
| 2024-05-29 07:00:00 | MSFT | Stock | 427.59 | 428.05 | 426.72 | 427.07 | 7039.0 |
| 2024-05-29 08:00:00 | MSFT | Stock | 427.71 | 428.51 | 426.67 | 427.1 | 22817.0 |
| 2024-05-29 09:00:00 | MSFT | Stock | 427.2 | 430.41 | 425.43 | 429.445 | 1477190.0 |
| 2024-05-29 10:00:00 | MSFT | Stock | 429.455 | 430.7 | 428.63 | 429.8825 | 1302242.0 |
| 2024-05-29 11:00:00 | MSFT | Stock | 429.89 | 430.23 | 428.68 | 430.15 | 787037.0 |
| 2024-05-29 12:00:00 | MSFT | Stock | 430.155 | 430.94 | 429.9 | 430.76 | 599290.0 |
| 2024-05-29 13:00:00 | MSFT | Stock | 430.74 | 430.82 | 429.54 | 430.52 | 666360.0 |
| 2024-05-29 14:00:00 | MSFT | Stock | 430.52 | 430.55 | 429.32 | 429.49 | 601457.0 |
| 2024-05-29 15:00:00 | MSFT | Stock | 429.5 | 430.39 | 428.58 | 429.51 | 1367560.0 |
| 2024-05-29 16:00:00 | MSFT | Stock | 429.17 | 429.21 | 425.26 | 425.5 | 3108123.0 |
| 2024-05-29 17:00:00 | MSFT | Stock | 425.5 | 425.55 | 425.42 | 425.5 | 18204.0 |
| 2024-05-29 18:00:00 | MSFT | Stock | 425.45 | 429.17 | 425.01 | 425.39 | 14243.0 |
| 2024-05-29 19:00:00 | MSFT | Stock | 425.35 | 425.48 | 425.0 | 425.48 | 16932.0 |
| 2024-05-29 04:00:00 | NVDA | Stock | 115.03 | 115.27 | 112.103 | 113.302 | 942290.0 |
| 2024-05-29 05:00:00 | NVDA | Stock | 113.19 | 113.601 | 112.225 | 113.5 | 677700.0 |
| 2024-05-29 06:00:00 | NVDA | Stock | 113.56 | 113.985 | 113.38 | 113.38 | 549980.0 |
| 2024-05-29 07:00:00 | NVDA | Stock | 113.45 | 114.93 | 113.372 | 114.815 | 2273530.0 |
| 2024-05-29 08:00:00 | NVDA | Stock | 113.69 | 116.167 | 113.4506 | 113.848 | 4999710.0 |
| 2024-05-29 09:00:00 | NVDA | Stock | 113.83 | 113.83 | 110.901 | 112.4895 | 72059120.0 |
| 2024-05-29 10:00:00 | NVDA | Stock | 112.4943 | 114.871 | 112.001 | 114.3925 | 73142230.0 |
| 2024-05-29 11:00:00 | NVDA | Stock | 114.375 | 114.477 | 113.302 | 113.8539 | 35796300.0 |
| 2024-05-29 12:00:00 | NVDA | Stock | 113.864 | 114.947 | 113.57 | 114.7349 | 34105040.0 |
| 2024-05-29 13:00:00 | NVDA | Stock | 114.785 | 115.151 | 114.111 | 114.8169 | 35885310.0 |
| 2024-05-29 14:00:00 | NVDA | Stock | 114.849 | 115.492 | 114.601 | 114.901 | 39840340.0 |
| 2024-05-29 15:00:00 | NVDA | Stock | 114.901 | 115.35 | 114.227 | 114.756 | 41043940.0 |
| 2024-05-29 16:00:00 | NVDA | Stock | 114.825 | 114.825 | 113.6 | 113.7 | 20686560.0 |
| 2024-05-29 17:00:00 | NVDA | Stock | 113.74 | 114.825 | 113.7 | 114.16 | 3066200.0 |
| 2024-05-29 18:00:00 | NVDA | Stock | 114.165 | 114.825 | 113.93 | 113.954 | 404800.0 |
| 2024-05-29 19:00:00 | NVDA | Stock | 113.95 | 113.95 | 113.503 | 113.6 | 655160.0 |
| 2024-05-29 04:00:00 | AMZN | Stock | 181.87 | 181.92 | 180.75 | 181.06 | 10421.0 |
| 2024-05-29 05:00:00 | AMZN | Stock | 181.21 | 181.24 | 181.1 | 181.24 | 400.0 |
> showing 50 of 59,097 rows — these rows as CSV