PREVIEW / stock_1hour / 2021-06-24
file: by_date/stock_1hour/2021/2021-06-24.parquet size: 1.4 MB rows: 65,569 symbols: 2,927
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 |
|---|---|---|---|---|---|---|---|
| 2021-06-24 04:00:00 | AAPL | Stock | 133.83 | 134.28 | 133.83 | 134.21 | 9619.0 |
| 2021-06-24 05:00:00 | AAPL | Stock | 134.29 | 134.35 | 134.22 | 134.23 | 8857.0 |
| 2021-06-24 06:00:00 | AAPL | Stock | 134.21 | 134.45 | 134.17 | 134.35 | 10554.0 |
| 2021-06-24 07:00:00 | AAPL | Stock | 134.26 | 134.5 | 134.16 | 134.44 | 120943.0 |
| 2021-06-24 08:00:00 | AAPL | Stock | 134.25 | 134.7 | 133.366 | 134.65 | 487401.0 |
| 2021-06-24 09:00:00 | AAPL | Stock | 134.65 | 134.68 | 133.7 | 134.29 | 9060787.0 |
| 2021-06-24 10:00:00 | AAPL | Stock | 134.295 | 134.5 | 134.07 | 134.075 | 8884873.0 |
| 2021-06-24 11:00:00 | AAPL | Stock | 134.08 | 134.18 | 133.73 | 133.995 | 7128130.0 |
| 2021-06-24 12:00:00 | AAPL | Stock | 134.0 | 134.08 | 133.42 | 133.4387 | 6774721.0 |
| 2021-06-24 13:00:00 | AAPL | Stock | 133.435 | 133.7 | 133.16 | 133.69 | 5678630.0 |
| 2021-06-24 14:00:00 | AAPL | Stock | 133.6995 | 133.76 | 133.36 | 133.465 | 4669063.0 |
| 2021-06-24 15:00:00 | AAPL | Stock | 133.46 | 133.49 | 132.93 | 133.4 | 10441622.0 |
| 2021-06-24 16:00:00 | AAPL | Stock | 133.41 | 133.45 | 133.29 | 133.41 | 8521914.0 |
| 2021-06-24 17:00:00 | AAPL | Stock | 133.41 | 133.46 | 133.32 | 133.4 | 30921.0 |
| 2021-06-24 18:00:00 | AAPL | Stock | 133.4 | 133.47 | 133.33 | 133.37 | 50217.0 |
| 2021-06-24 19:00:00 | AAPL | Stock | 133.39 | 133.43 | 133.33 | 133.34 | 46410.0 |
| 2021-06-24 04:00:00 | MSFT | Stock | 265.87 | 266.6 | 265.87 | 266.42 | 2162.0 |
| 2021-06-24 05:00:00 | MSFT | Stock | 266.88 | 267.0 | 266.79 | 266.79 | 5841.0 |
| 2021-06-24 06:00:00 | MSFT | Stock | 267.0 | 267.0 | 266.8 | 266.8 | 1191.0 |
| 2021-06-24 07:00:00 | MSFT | Stock | 266.75 | 266.79 | 266.4 | 266.62 | 4878.0 |
| 2021-06-24 08:00:00 | MSFT | Stock | 266.6001 | 266.9 | 266.42 | 266.53 | 19828.0 |
| 2021-06-24 09:00:00 | MSFT | Stock | 266.5 | 267.44 | 265.47 | 266.81 | 2109272.0 |
| 2021-06-24 10:00:00 | MSFT | Stock | 266.79 | 267.55 | 266.4 | 266.8419 | 2529334.0 |
| 2021-06-24 11:00:00 | MSFT | Stock | 266.85 | 267.34 | 266.7 | 267.1518 | 1509933.0 |
| 2021-06-24 12:00:00 | MSFT | Stock | 267.14 | 267.85 | 266.35 | 266.425 | 1640218.0 |
| 2021-06-24 13:00:00 | MSFT | Stock | 266.435 | 266.7657 | 266.2 | 266.42 | 1439240.0 |
| 2021-06-24 14:00:00 | MSFT | Stock | 266.425 | 266.605 | 266.24 | 266.46 | 924113.0 |
| 2021-06-24 15:00:00 | MSFT | Stock | 266.45 | 266.98 | 266.085 | 266.64 | 2342513.0 |
| 2021-06-24 16:00:00 | MSFT | Stock | 266.69 | 267.22 | 266.5 | 267.0 | 3130148.0 |
| 2021-06-24 17:00:00 | MSFT | Stock | 267.1 | 267.18 | 266.76 | 267.18 | 4634.0 |
| 2021-06-24 18:00:00 | MSFT | Stock | 266.97 | 267.14 | 266.75 | 267.14 | 5589.0 |
| 2021-06-24 19:00:00 | MSFT | Stock | 267.12 | 267.14 | 266.86 | 266.98 | 3271.0 |
| 2021-06-24 04:00:00 | NVDA | Stock | 19.113 | 19.2188 | 19.113 | 19.2188 | 44720.0 |
| 2021-06-24 05:00:00 | NVDA | Stock | 19.178 | 19.2 | 19.178 | 19.1873 | 61880.0 |
| 2021-06-24 06:00:00 | NVDA | Stock | 19.1748 | 19.1748 | 19.1738 | 19.1738 | 8080.0 |
| 2021-06-24 07:00:00 | NVDA | Stock | 19.15 | 19.2125 | 19.15 | 19.2125 | 659360.0 |
| 2021-06-24 08:00:00 | NVDA | Stock | 19.1626 | 19.245 | 19.1625 | 19.2125 | 1113520.0 |
| 2021-06-24 09:00:00 | NVDA | Stock | 19.22 | 19.42 | 19.1898 | 19.3121 | 55617280.0 |
| 2021-06-24 10:00:00 | NVDA | Stock | 19.3095 | 19.3548 | 19.2202 | 19.2534 | 28558480.0 |
| 2021-06-24 11:00:00 | NVDA | Stock | 19.251 | 19.3575 | 19.25 | 19.3098 | 19097200.0 |
| 2021-06-24 12:00:00 | NVDA | Stock | 19.3131 | 19.3875 | 19.2445 | 19.2533 | 16593200.0 |
| 2021-06-24 13:00:00 | NVDA | Stock | 19.2566 | 19.3012 | 19.0882 | 19.1634 | 22667720.0 |
| 2021-06-24 14:00:00 | NVDA | Stock | 19.1664 | 19.2565 | 19.1664 | 19.2368 | 15775200.0 |
| 2021-06-24 15:00:00 | NVDA | Stock | 19.234 | 19.2455 | 19.1638 | 19.2055 | 25709560.0 |
| 2021-06-24 16:00:00 | NVDA | Stock | 19.2055 | 19.2242 | 19.1878 | 19.205 | 19380400.0 |
| 2021-06-24 17:00:00 | NVDA | Stock | 19.211 | 19.225 | 19.21 | 19.2208 | 201680.0 |
| 2021-06-24 18:00:00 | NVDA | Stock | 19.215 | 19.2163 | 19.2065 | 19.215 | 157960.0 |
| 2021-06-24 19:00:00 | NVDA | Stock | 19.2118 | 19.2125 | 19.2025 | 19.2025 | 94880.0 |
| 2021-06-24 05:00:00 | AMZN | Stock | 175.9995 | 175.9995 | 175.9995 | 175.9995 | 2000.0 |
| 2021-06-24 07:00:00 | AMZN | Stock | 175.76 | 175.76 | 175.7395 | 175.7395 | 24740.0 |
> showing 50 of 65,569 rows — these rows as CSV