PREVIEW / stock_30min / 2022-04-11
file: by_date/stock_30min/2022/2022-04-11.parquet size: 2.2 MB rows: 108,428 symbols: 2,443
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-11 04:00:00 | AAPL | Stock | 168.99 | 169.81 | 168.01 | 168.18 | 22478.0 |
| 2022-04-11 04:30:00 | AAPL | Stock | 168.22 | 168.6 | 168.21 | 168.46 | 4389.0 |
| 2022-04-11 05:00:00 | AAPL | Stock | 168.23 | 168.47 | 168.19 | 168.47 | 12838.0 |
| 2022-04-11 05:30:00 | AAPL | Stock | 168.47 | 168.8 | 168.23 | 168.7 | 11280.0 |
| 2022-04-11 06:00:00 | AAPL | Stock | 168.75 | 169.08 | 168.75 | 169.0 | 2942.0 |
| 2022-04-11 06:30:00 | AAPL | Stock | 168.79 | 168.79 | 167.75 | 168.77 | 36065.0 |
| 2022-04-11 07:00:00 | AAPL | Stock | 168.79 | 168.85 | 168.0 | 168.29 | 65594.0 |
| 2022-04-11 07:30:00 | AAPL | Stock | 168.29 | 168.29 | 167.75 | 167.87 | 96991.0 |
| 2022-04-11 08:00:00 | AAPL | Stock | 168.49 | 169.665 | 167.65 | 167.79 | 534177.0 |
| 2022-04-11 08:30:00 | AAPL | Stock | 167.8 | 168.5 | 167.77 | 168.06 | 159095.0 |
| 2022-04-11 09:00:00 | AAPL | Stock | 168.09 | 168.98 | 167.76 | 168.73 | 287569.0 |
| 2022-04-11 09:30:00 | AAPL | Stock | 168.75 | 169.03 | 166.88 | 167.0 | 9128944.0 |
| 2022-04-11 10:00:00 | AAPL | Stock | 166.98 | 167.33 | 166.365 | 166.48 | 5919773.0 |
| 2022-04-11 10:30:00 | AAPL | Stock | 166.49 | 167.04 | 166.1 | 166.16 | 4205885.0 |
| 2022-04-11 11:00:00 | AAPL | Stock | 166.15 | 166.64 | 166.11 | 166.44 | 3230226.0 |
| 2022-04-11 11:30:00 | AAPL | Stock | 166.44 | 167.205 | 166.4 | 167.025 | 2979609.0 |
| 2022-04-11 12:00:00 | AAPL | Stock | 167.023 | 167.025 | 166.48 | 166.56 | 2497067.0 |
| 2022-04-11 12:30:00 | AAPL | Stock | 166.55 | 167.145 | 166.55 | 167.03 | 2529486.0 |
| 2022-04-11 13:00:00 | AAPL | Stock | 167.02 | 167.46 | 166.84 | 166.91 | 2908791.0 |
| 2022-04-11 13:30:00 | AAPL | Stock | 166.91 | 167.155 | 166.7716 | 166.995 | 2190536.0 |
| 2022-04-11 14:00:00 | AAPL | Stock | 166.995 | 167.25 | 166.49 | 166.665 | 2883045.0 |
| 2022-04-11 14:30:00 | AAPL | Stock | 166.66 | 167.13 | 166.49 | 166.83 | 2720879.0 |
| 2022-04-11 15:00:00 | AAPL | Stock | 166.83 | 167.1 | 166.05 | 166.13 | 4174556.0 |
| 2022-04-11 15:30:00 | AAPL | Stock | 166.12 | 166.27 | 165.5 | 165.78 | 9251279.0 |
| 2022-04-11 16:00:00 | AAPL | Stock | 165.79 | 165.81 | 165.4 | 165.55 | 6941776.0 |
| 2022-04-11 16:30:00 | AAPL | Stock | 165.55 | 165.75 | 165.5 | 165.55 | 73459.0 |
| 2022-04-11 17:00:00 | AAPL | Stock | 165.56 | 165.6255 | 165.38 | 165.45 | 45454.0 |
| 2022-04-11 17:30:00 | AAPL | Stock | 165.55 | 165.75 | 165.5 | 165.5 | 104182.0 |
| 2022-04-11 18:00:00 | AAPL | Stock | 165.52 | 165.8 | 165.52 | 165.6999 | 42508.0 |
| 2022-04-11 18:30:00 | AAPL | Stock | 165.67 | 165.83 | 165.66 | 165.74 | 14175.0 |
| 2022-04-11 19:00:00 | AAPL | Stock | 165.72 | 165.75 | 165.51 | 165.51 | 34311.0 |
| 2022-04-11 19:30:00 | AAPL | Stock | 165.5 | 165.56 | 165.25 | 165.26 | 49462.0 |
| 2022-04-11 04:00:00 | MSFT | Stock | 295.23 | 295.23 | 292.51 | 292.55 | 4337.0 |
| 2022-04-11 04:30:00 | MSFT | Stock | 292.6 | 293.29 | 292.6 | 292.8 | 2640.0 |
| 2022-04-11 05:00:00 | MSFT | Stock | 293.0 | 293.28 | 292.91 | 293.16 | 2319.0 |
| 2022-04-11 05:30:00 | MSFT | Stock | 293.06 | 293.92 | 293.04 | 293.79 | 1733.0 |
| 2022-04-11 06:00:00 | MSFT | Stock | 293.81 | 294.89 | 293.81 | 293.9 | 943.0 |
| 2022-04-11 06:30:00 | MSFT | Stock | 293.84 | 294.0 | 292.7 | 294.0 | 7778.0 |
| 2022-04-11 07:00:00 | MSFT | Stock | 294.0 | 294.58 | 293.55 | 294.2 | 7447.0 |
| 2022-04-11 07:30:00 | MSFT | Stock | 293.91 | 293.91 | 293.06 | 293.21 | 8562.0 |
| 2022-04-11 08:00:00 | MSFT | Stock | 293.5996 | 294.64 | 292.1747 | 292.2 | 54846.0 |
| 2022-04-11 08:30:00 | MSFT | Stock | 292.2 | 292.82 | 291.83 | 292.5 | 28882.0 |
| 2022-04-11 09:00:00 | MSFT | Stock | 292.45 | 292.51 | 291.16 | 291.66 | 49732.0 |
| 2022-04-11 09:30:00 | MSFT | Stock | 291.77 | 292.61 | 287.66 | 287.72 | 4158338.0 |
| 2022-04-11 10:00:00 | MSFT | Stock | 287.71 | 288.48 | 285.72 | 286.18 | 3347087.0 |
| 2022-04-11 10:30:00 | MSFT | Stock | 286.195 | 286.98 | 285.4 | 286.47 | 1763339.0 |
| 2022-04-11 11:00:00 | MSFT | Stock | 286.45 | 286.8 | 285.32 | 285.89 | 1524158.0 |
| 2022-04-11 11:30:00 | MSFT | Stock | 285.88 | 286.69 | 285.75 | 286.075 | 1179465.0 |
| 2022-04-11 12:00:00 | MSFT | Stock | 286.07 | 286.18 | 285.57 | 285.72 | 815080.0 |
| 2022-04-11 12:30:00 | MSFT | Stock | 285.71 | 286.91 | 285.56 | 286.9 | 847890.0 |
> showing 50 of 108,428 rows — these rows as CSV