PREVIEW / stock_1hour / 2024-08-05
file: by_date/stock_1hour/2024/2024-08-05.parquet size: 1.4 MB rows: 66,221 symbols: 897
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-08-05 04:00:00 | AAPL | Stock | 206.94 | 207.9 | 202.0 | 202.3 | 326476.0 |
| 2024-08-05 05:00:00 | AAPL | Stock | 202.4 | 203.06 | 200.48 | 202.4 | 234256.0 |
| 2024-08-05 06:00:00 | AAPL | Stock | 202.39 | 203.5 | 200.05 | 203.25 | 217125.0 |
| 2024-08-05 07:00:00 | AAPL | Stock | 203.44 | 206.12 | 202.5 | 203.07 | 706858.0 |
| 2024-08-05 08:00:00 | AAPL | Stock | 203.0 | 206.1294 | 196.51 | 197.65 | 2195496.0 |
| 2024-08-05 09:00:00 | AAPL | Stock | 197.65 | 211.12 | 196.0 | 207.63 | 21821142.0 |
| 2024-08-05 10:00:00 | AAPL | Stock | 207.83 | 211.01 | 207.7 | 209.5599 | 11290439.0 |
| 2024-08-05 11:00:00 | AAPL | Stock | 209.57 | 213.5 | 208.74 | 210.335 | 9331479.0 |
| 2024-08-05 12:00:00 | AAPL | Stock | 210.335 | 213.0 | 209.72 | 210.38 | 5197234.0 |
| 2024-08-05 13:00:00 | AAPL | Stock | 210.36 | 211.89 | 209.91 | 210.76 | 4147515.0 |
| 2024-08-05 14:00:00 | AAPL | Stock | 210.77 | 210.95 | 203.91 | 204.7596 | 9684341.0 |
| 2024-08-05 15:00:00 | AAPL | Stock | 204.79 | 209.38 | 204.06 | 209.2 | 13765137.0 |
| 2024-08-05 16:00:00 | AAPL | Stock | 209.27 | 211.47 | 208.7 | 210.7996 | 12609407.0 |
| 2024-08-05 17:00:00 | AAPL | Stock | 210.64 | 210.8 | 209.27 | 210.34 | 101688.0 |
| 2024-08-05 18:00:00 | AAPL | Stock | 210.33 | 211.38 | 210.26 | 210.45 | 67935.0 |
| 2024-08-05 19:00:00 | AAPL | Stock | 210.5 | 212.0 | 210.45 | 211.85 | 84272.0 |
| 2024-08-05 04:00:00 | MSFT | Stock | 389.8 | 395.76 | 385.36 | 388.96 | 53926.0 |
| 2024-08-05 05:00:00 | MSFT | Stock | 389.0 | 393.0 | 387.08 | 391.22 | 55290.0 |
| 2024-08-05 06:00:00 | MSFT | Stock | 391.6 | 392.28 | 386.0 | 391.79 | 25125.0 |
| 2024-08-05 07:00:00 | MSFT | Stock | 392.0 | 393.89 | 388.87 | 391.2 | 135078.0 |
| 2024-08-05 08:00:00 | MSFT | Stock | 392.0 | 409.511 | 368.95 | 387.86 | 284189.0 |
| 2024-08-05 09:00:00 | MSFT | Stock | 388.3336 | 397.0 | 385.3 | 393.57 | 5945631.0 |
| 2024-08-05 10:00:00 | MSFT | Stock | 393.53 | 399.48 | 392.87 | 396.725 | 3691295.0 |
| 2024-08-05 11:00:00 | MSFT | Stock | 396.6 | 400.7 | 395.0 | 398.79 | 2095670.0 |
| 2024-08-05 12:00:00 | MSFT | Stock | 398.76 | 401.04 | 396.457 | 396.99 | 1303170.0 |
| 2024-08-05 13:00:00 | MSFT | Stock | 396.99 | 398.66 | 396.32 | 396.53 | 1179159.0 |
| 2024-08-05 14:00:00 | MSFT | Stock | 396.49 | 396.74 | 393.165 | 393.76 | 1709367.0 |
| 2024-08-05 15:00:00 | MSFT | Stock | 393.77 | 396.08 | 393.26 | 395.23 | 2927769.0 |
| 2024-08-05 16:00:00 | MSFT | Stock | 395.15 | 399.75 | 395.1026 | 398.59 | 6374325.0 |
| 2024-08-05 17:00:00 | MSFT | Stock | 398.75 | 400.59 | 395.15 | 399.1 | 81004.0 |
| 2024-08-05 18:00:00 | MSFT | Stock | 399.47 | 400.46 | 399.01 | 399.465 | 8828.0 |
| 2024-08-05 19:00:00 | MSFT | Stock | 400.0 | 401.9 | 399.5751 | 401.8 | 16046.0 |
| 2024-08-05 04:00:00 | NVDA | Stock | 99.97 | 101.7 | 96.92 | 97.49 | 3930829.0 |
| 2024-08-05 05:00:00 | NVDA | Stock | 97.4 | 98.19 | 96.02 | 97.74 | 2232912.0 |
| 2024-08-05 06:00:00 | NVDA | Stock | 97.74 | 97.74 | 96.5 | 97.65 | 1787316.0 |
| 2024-08-05 07:00:00 | NVDA | Stock | 97.64 | 98.35 | 92.61 | 93.39 | 8865500.0 |
| 2024-08-05 08:00:00 | NVDA | Stock | 93.38 | 101.4907 | 91.35 | 93.18 | 17483484.0 |
| 2024-08-05 09:00:00 | NVDA | Stock | 93.25 | 100.3 | 90.69 | 99.47 | 102108594.0 |
| 2024-08-05 10:00:00 | NVDA | Stock | 99.48 | 102.37 | 97.22 | 99.6099 | 77239901.0 |
| 2024-08-05 11:00:00 | NVDA | Stock | 99.57 | 102.2089 | 99.09 | 100.8984 | 50904893.0 |
| 2024-08-05 12:00:00 | NVDA | Stock | 100.88 | 103.41 | 100.04 | 100.16 | 46563777.0 |
| 2024-08-05 13:00:00 | NVDA | Stock | 100.16 | 102.1 | 100.06 | 101.01 | 35073307.0 |
| 2024-08-05 14:00:00 | NVDA | Stock | 101.01 | 101.13 | 99.22 | 99.3893 | 36053400.0 |
| 2024-08-05 15:00:00 | NVDA | Stock | 99.39 | 100.76 | 98.56 | 100.6 | 57022305.0 |
| 2024-08-05 16:00:00 | NVDA | Stock | 100.45 | 102.15 | 100.4379 | 102.12 | 30383700.0 |
| 2024-08-05 17:00:00 | NVDA | Stock | 102.1295 | 102.1686 | 100.45 | 102.14 | 1272135.0 |
| 2024-08-05 18:00:00 | NVDA | Stock | 102.15 | 103.27 | 102.07 | 102.65 | 1940764.0 |
| 2024-08-05 19:00:00 | NVDA | Stock | 102.65 | 103.59 | 102.51 | 103.565 | 1261331.0 |
| 2024-08-05 04:00:00 | AMZN | Stock | 158.0 | 164.26 | 158.0 | 162.78 | 285112.0 |
| 2024-08-05 05:00:00 | AMZN | Stock | 162.74 | 163.25 | 159.5 | 160.49 | 106667.0 |
> showing 50 of 66,221 rows — these rows as CSV