PREVIEW / stock_1hour / 2022-07-27
file: by_date/stock_1hour/2022/2022-07-27.parquet size: 1.3 MB rows: 61,200 symbols: 2,262
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 |
|---|---|---|---|---|---|---|---|
| 2022-07-27 04:00:00 | AAPL | Stock | 152.9 | 153.45 | 152.8 | 153.33 | 30163.0 |
| 2022-07-27 05:00:00 | AAPL | Stock | 153.35 | 153.4 | 153.03 | 153.15 | 28372.0 |
| 2022-07-27 06:00:00 | AAPL | Stock | 153.1 | 153.15 | 152.82 | 152.99 | 11980.0 |
| 2022-07-27 07:00:00 | AAPL | Stock | 152.99 | 152.99 | 152.67 | 152.72 | 41704.0 |
| 2022-07-27 08:00:00 | AAPL | Stock | 152.92 | 153.04 | 151.221 | 152.89 | 226595.0 |
| 2022-07-27 09:00:00 | AAPL | Stock | 152.89 | 154.8 | 152.16 | 154.37 | 8647957.0 |
| 2022-07-27 10:00:00 | AAPL | Stock | 154.37 | 154.77 | 154.1 | 154.395 | 7304807.0 |
| 2022-07-27 11:00:00 | AAPL | Stock | 154.399 | 154.58 | 153.575 | 154.1599 | 5236772.0 |
| 2022-07-27 12:00:00 | AAPL | Stock | 154.16 | 154.56 | 154.015 | 154.26 | 3743812.0 |
| 2022-07-27 13:00:00 | AAPL | Stock | 154.25 | 154.59 | 154.16 | 154.3943 | 3390291.0 |
| 2022-07-27 14:00:00 | AAPL | Stock | 154.402 | 156.23 | 153.91 | 155.91 | 9506836.0 |
| 2022-07-27 15:00:00 | AAPL | Stock | 155.92 | 157.33 | 155.72 | 156.71 | 15319676.0 |
| 2022-07-27 16:00:00 | AAPL | Stock | 156.71 | 156.79 | 155.71 | 155.8 | 12497691.0 |
| 2022-07-27 17:00:00 | AAPL | Stock | 155.9 | 156.79 | 155.81 | 156.2 | 139927.0 |
| 2022-07-27 18:00:00 | AAPL | Stock | 156.2 | 156.45 | 156.06 | 156.28 | 83708.0 |
| 2022-07-27 19:00:00 | AAPL | Stock | 156.3 | 156.5 | 156.3 | 156.5 | 70276.0 |
| 2022-07-27 04:00:00 | MSFT | Stock | 261.5 | 262.87 | 261.16 | 261.5 | 44821.0 |
| 2022-07-27 05:00:00 | MSFT | Stock | 261.51 | 261.55 | 260.76 | 261.01 | 18310.0 |
| 2022-07-27 06:00:00 | MSFT | Stock | 261.04 | 261.84 | 261.0 | 261.84 | 16203.0 |
| 2022-07-27 07:00:00 | MSFT | Stock | 261.82 | 261.88 | 259.37 | 260.4 | 142845.0 |
| 2022-07-27 08:00:00 | MSFT | Stock | 261.8398 | 263.33 | 258.9 | 261.15 | 319181.0 |
| 2022-07-27 09:00:00 | MSFT | Stock | 261.09 | 265.0 | 258.85 | 263.66 | 6925165.0 |
| 2022-07-27 10:00:00 | MSFT | Stock | 263.69 | 264.93 | 262.63 | 263.22 | 3986513.0 |
| 2022-07-27 11:00:00 | MSFT | Stock | 263.2 | 264.8704 | 262.95 | 264.34 | 2634937.0 |
| 2022-07-27 12:00:00 | MSFT | Stock | 264.34 | 265.55 | 263.56 | 263.86 | 2532491.0 |
| 2022-07-27 13:00:00 | MSFT | Stock | 263.85 | 264.48 | 263.72 | 264.18 | 1423941.0 |
| 2022-07-27 14:00:00 | MSFT | Stock | 264.22 | 269.13 | 263.9 | 267.93 | 4318469.0 |
| 2022-07-27 15:00:00 | MSFT | Stock | 267.9594 | 270.05 | 267.57 | 268.68 | 6662288.0 |
| 2022-07-27 16:00:00 | MSFT | Stock | 268.541 | 269.05 | 266.98 | 267.42 | 5870580.0 |
| 2022-07-27 17:00:00 | MSFT | Stock | 267.21 | 267.74 | 267.21 | 267.55 | 14417.0 |
| 2022-07-27 18:00:00 | MSFT | Stock | 267.55 | 267.95 | 267.5 | 267.93 | 6675.0 |
| 2022-07-27 19:00:00 | MSFT | Stock | 268.0 | 268.48 | 267.92 | 268.0 | 2678.0 |
| 2022-07-27 04:00:00 | NVDA | Stock | 17.094 | 17.094 | 16.937 | 17.01 | 160310.0 |
| 2022-07-27 05:00:00 | NVDA | Stock | 17.0 | 17.002 | 16.969 | 16.97 | 70040.0 |
| 2022-07-27 06:00:00 | NVDA | Stock | 16.97 | 16.97 | 16.93 | 16.97 | 84950.0 |
| 2022-07-27 07:00:00 | NVDA | Stock | 16.93 | 16.93 | 16.83 | 16.893 | 187450.0 |
| 2022-07-27 08:00:00 | NVDA | Stock | 16.9673 | 17.0 | 16.832 | 16.9499 | 850060.0 |
| 2022-07-27 09:00:00 | NVDA | Stock | 16.925 | 17.396 | 16.9 | 17.311 | 63467090.0 |
| 2022-07-27 10:00:00 | NVDA | Stock | 17.307 | 17.529 | 17.287 | 17.453 | 71898550.0 |
| 2022-07-27 11:00:00 | NVDA | Stock | 17.455 | 17.491 | 17.283 | 17.325 | 42211240.0 |
| 2022-07-27 12:00:00 | NVDA | Stock | 17.3261 | 17.394 | 17.2672 | 17.3 | 30633540.0 |
| 2022-07-27 13:00:00 | NVDA | Stock | 17.301 | 17.407 | 17.247 | 17.368 | 35500860.0 |
| 2022-07-27 14:00:00 | NVDA | Stock | 17.3847 | 17.779 | 17.312 | 17.701 | 78871010.0 |
| 2022-07-27 15:00:00 | NVDA | Stock | 17.702 | 17.936 | 17.641 | 17.79 | 91686640.0 |
| 2022-07-27 16:00:00 | NVDA | Stock | 17.79 | 17.849 | 17.558 | 17.76 | 45976090.0 |
| 2022-07-27 17:00:00 | NVDA | Stock | 17.76 | 17.816 | 17.72 | 17.805 | 514430.0 |
| 2022-07-27 18:00:00 | NVDA | Stock | 17.791 | 17.818 | 17.758 | 17.775 | 232940.0 |
| 2022-07-27 19:00:00 | NVDA | Stock | 17.767 | 17.8 | 17.7 | 17.735 | 486370.0 |
| 2022-07-27 04:00:00 | AMZN | Stock | 117.64 | 117.9 | 117.18 | 117.61 | 17656.0 |
| 2022-07-27 05:00:00 | AMZN | Stock | 117.61 | 117.68 | 117.0 | 117.12 | 10430.0 |
> showing 50 of 61,200 rows — these rows as CSV