PREVIEW / stock_30min / 2022-04-08
file: by_date/stock_30min/2022/2022-04-08.parquet size: 2.1 MB rows: 105,343 symbols: 2,468
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-04-08 04:00:00 | AAPL | Stock | 173.17 | 173.18 | 172.94 | 173.08 | 4587.0 |
| 2022-04-08 04:30:00 | AAPL | Stock | 173.06 | 173.06 | 172.5 | 172.69 | 4635.0 |
| 2022-04-08 05:00:00 | AAPL | Stock | 172.37 | 172.55 | 172.33 | 172.45 | 6974.0 |
| 2022-04-08 05:30:00 | AAPL | Stock | 172.41 | 172.42 | 172.25 | 172.4 | 2949.0 |
| 2022-04-08 06:00:00 | AAPL | Stock | 172.36 | 172.39 | 172.13 | 172.19 | 2982.0 |
| 2022-04-08 06:30:00 | AAPL | Stock | 172.14 | 172.51 | 172.13 | 172.51 | 6961.0 |
| 2022-04-08 07:00:00 | AAPL | Stock | 172.5 | 172.51 | 172.22 | 172.4 | 34908.0 |
| 2022-04-08 07:30:00 | AAPL | Stock | 172.4 | 172.69 | 172.35 | 172.57 | 50825.0 |
| 2022-04-08 08:00:00 | AAPL | Stock | 172.47 | 173.46 | 172.22 | 172.48 | 218967.0 |
| 2022-04-08 08:30:00 | AAPL | Stock | 172.4701 | 172.5 | 172.21 | 172.4 | 298171.0 |
| 2022-04-08 09:00:00 | AAPL | Stock | 172.4 | 172.45 | 171.61 | 171.75 | 293813.0 |
| 2022-04-08 09:30:00 | AAPL | Stock | 171.78 | 171.78 | 169.2 | 169.245 | 10194353.0 |
| 2022-04-08 10:00:00 | AAPL | Stock | 169.25 | 170.43 | 169.25 | 170.285 | 5635734.0 |
| 2022-04-08 10:30:00 | AAPL | Stock | 170.2812 | 170.96 | 169.62 | 170.94 | 5399099.0 |
| 2022-04-08 11:00:00 | AAPL | Stock | 170.94 | 171.36 | 170.5 | 170.9 | 4727437.0 |
| 2022-04-08 11:30:00 | AAPL | Stock | 170.92 | 171.37 | 170.336 | 171.32 | 3792615.0 |
| 2022-04-08 12:00:00 | AAPL | Stock | 171.31 | 171.77 | 171.0 | 171.655 | 3409909.0 |
| 2022-04-08 12:30:00 | AAPL | Stock | 171.65 | 171.7299 | 171.0 | 171.6206 | 2397012.0 |
| 2022-04-08 13:00:00 | AAPL | Stock | 171.63 | 171.64 | 170.755 | 170.82 | 2166057.0 |
| 2022-04-08 13:30:00 | AAPL | Stock | 170.8201 | 170.8697 | 170.115 | 170.17 | 2767003.0 |
| 2022-04-08 14:00:00 | AAPL | Stock | 170.1698 | 170.6 | 169.83 | 169.9501 | 3154367.0 |
| 2022-04-08 14:30:00 | AAPL | Stock | 169.96 | 170.755 | 169.78 | 170.49 | 3303763.0 |
| 2022-04-08 15:00:00 | AAPL | Stock | 170.49 | 170.97 | 170.21 | 170.74 | 4013009.0 |
| 2022-04-08 15:30:00 | AAPL | Stock | 170.75 | 170.86 | 169.82 | 170.14 | 7507910.0 |
| 2022-04-08 16:00:00 | AAPL | Stock | 170.14 | 170.25 | 169.93 | 169.98 | 7666881.0 |
| 2022-04-08 16:30:00 | AAPL | Stock | 169.97 | 170.09 | 169.96 | 169.99 | 127305.0 |
| 2022-04-08 17:00:00 | AAPL | Stock | 169.98 | 170.02 | 169.98 | 169.98 | 39977.0 |
| 2022-04-08 17:30:00 | AAPL | Stock | 169.98 | 170.01 | 169.9 | 169.9109 | 10621.0 |
| 2022-04-08 18:00:00 | AAPL | Stock | 169.93 | 169.9399 | 169.82 | 169.83 | 7538.0 |
| 2022-04-08 18:30:00 | AAPL | Stock | 169.83 | 169.85 | 169.71 | 169.76 | 20097.0 |
| 2022-04-08 19:00:00 | AAPL | Stock | 169.74 | 169.8 | 169.74 | 169.78 | 8864.0 |
| 2022-04-08 19:30:00 | AAPL | Stock | 169.76 | 169.79 | 169.75 | 169.76 | 13941.0 |
| 2022-04-08 04:00:00 | MSFT | Stock | 302.62 | 303.03 | 302.62 | 303.03 | 1786.0 |
| 2022-04-08 04:30:00 | MSFT | Stock | 302.95 | 303.02 | 302.48 | 302.48 | 1465.0 |
| 2022-04-08 05:00:00 | MSFT | Stock | 301.51 | 302.28 | 301.37 | 302.28 | 1670.0 |
| 2022-04-08 05:30:00 | MSFT | Stock | 301.72 | 301.72 | 301.72 | 301.72 | 100.0 |
| 2022-04-08 06:00:00 | MSFT | Stock | 301.55 | 301.61 | 301.41 | 301.41 | 1597.0 |
| 2022-04-08 06:30:00 | MSFT | Stock | 301.99 | 302.27 | 301.99 | 302.27 | 589.0 |
| 2022-04-08 07:00:00 | MSFT | Stock | 302.3 | 302.6 | 301.97 | 301.99 | 8134.0 |
| 2022-04-08 07:30:00 | MSFT | Stock | 301.82 | 302.7 | 301.63 | 302.2 | 6613.0 |
| 2022-04-08 08:00:00 | MSFT | Stock | 302.4 | 302.6 | 301.7266 | 301.9 | 11389.0 |
| 2022-04-08 08:30:00 | MSFT | Stock | 301.38 | 301.38 | 300.5342 | 300.5342 | 4393.0 |
| 2022-04-08 09:00:00 | MSFT | Stock | 300.17 | 300.79 | 299.7 | 300.45 | 10789.0 |
| 2022-04-08 09:30:00 | MSFT | Stock | 300.44 | 300.6349 | 296.76 | 296.8601 | 2089376.0 |
| 2022-04-08 10:00:00 | MSFT | Stock | 296.86 | 298.6794 | 296.78 | 298.55 | 1031362.0 |
| 2022-04-08 10:30:00 | MSFT | Stock | 298.55 | 300.19 | 297.7 | 300.164 | 1087802.0 |
| 2022-04-08 11:00:00 | MSFT | Stock | 300.13 | 300.642 | 299.17 | 299.58 | 937931.0 |
| 2022-04-08 11:30:00 | MSFT | Stock | 299.585 | 300.7 | 299.11 | 300.35 | 643655.0 |
| 2022-04-08 12:00:00 | MSFT | Stock | 300.35 | 301.12 | 299.8 | 301.025 | 733928.0 |
| 2022-04-08 12:30:00 | MSFT | Stock | 301.01 | 301.0755 | 299.76 | 300.57 | 792169.0 |
> showing 50 of 105,343 rows — these rows as CSV