PREVIEW / stock_30min / 2022-05-06
file: by_date/stock_30min/2022/2022-05-06.parquet size: 2.1 MB rows: 106,076 symbols: 2,396
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-05-06 04:00:00 | AAPL | Stock | 157.29 | 157.29 | 156.2 | 156.98 | 20629.0 |
| 2022-05-06 04:30:00 | AAPL | Stock | 157.13 | 157.3 | 156.5 | 156.5 | 22980.0 |
| 2022-05-06 05:00:00 | AAPL | Stock | 156.65 | 156.74 | 156.21 | 156.25 | 9400.0 |
| 2022-05-06 05:30:00 | AAPL | Stock | 156.3 | 156.82 | 156.3 | 156.82 | 2631.0 |
| 2022-05-06 06:00:00 | AAPL | Stock | 156.84 | 156.9 | 156.52 | 156.87 | 5670.0 |
| 2022-05-06 06:30:00 | AAPL | Stock | 156.96 | 157.06 | 156.21 | 156.3 | 37361.0 |
| 2022-05-06 07:00:00 | AAPL | Stock | 156.4 | 156.44 | 155.65 | 155.8 | 55872.0 |
| 2022-05-06 07:30:00 | AAPL | Stock | 155.76 | 156.27 | 155.51 | 156.19 | 40480.0 |
| 2022-05-06 08:00:00 | AAPL | Stock | 156.1402 | 157.62 | 155.6 | 156.64 | 430006.0 |
| 2022-05-06 08:30:00 | AAPL | Stock | 156.62 | 157.8 | 155.58 | 155.75 | 552954.0 |
| 2022-05-06 09:00:00 | AAPL | Stock | 155.7 | 156.1 | 155.51 | 155.95 | 305047.0 |
| 2022-05-06 09:30:00 | AAPL | Stock | 156.02 | 157.08 | 154.18 | 154.7 | 11032327.0 |
| 2022-05-06 10:00:00 | AAPL | Stock | 154.7 | 159.165 | 154.58 | 157.745 | 12573344.0 |
| 2022-05-06 10:30:00 | AAPL | Stock | 157.745 | 158.71 | 156.64 | 158.54 | 7604342.0 |
| 2022-05-06 11:00:00 | AAPL | Stock | 158.53 | 159.43 | 157.735 | 159.17 | 6985030.0 |
| 2022-05-06 11:30:00 | AAPL | Stock | 159.17 | 159.24 | 157.3 | 157.51 | 5615249.0 |
| 2022-05-06 12:00:00 | AAPL | Stock | 157.51 | 158.9 | 157.32 | 158.46 | 5180428.0 |
| 2022-05-06 12:30:00 | AAPL | Stock | 158.45 | 159.44 | 157.81 | 159.07 | 5111065.0 |
| 2022-05-06 13:00:00 | AAPL | Stock | 159.065 | 159.38 | 157.92 | 158.47 | 4127267.0 |
| 2022-05-06 13:30:00 | AAPL | Stock | 158.48 | 158.89 | 157.25 | 157.4 | 3839304.0 |
| 2022-05-06 14:00:00 | AAPL | Stock | 157.3969 | 157.85 | 156.5 | 156.895 | 4318508.0 |
| 2022-05-06 14:30:00 | AAPL | Stock | 156.895 | 157.5 | 156.23 | 156.6 | 4559675.0 |
| 2022-05-06 15:00:00 | AAPL | Stock | 156.58 | 156.86 | 155.8 | 156.48 | 5867089.0 |
| 2022-05-06 15:30:00 | AAPL | Stock | 156.4855 | 158.7 | 156.431 | 157.35 | 12325602.0 |
| 2022-05-06 16:00:00 | AAPL | Stock | 157.4 | 157.47 | 156.65 | 156.77 | 9195723.0 |
| 2022-05-06 16:30:00 | AAPL | Stock | 156.79 | 157.33 | 156.67 | 157.18 | 232500.0 |
| 2022-05-06 17:00:00 | AAPL | Stock | 157.2 | 157.26 | 157.1 | 157.2 | 42335.0 |
| 2022-05-06 17:30:00 | AAPL | Stock | 157.25 | 157.25 | 157.13 | 157.1301 | 16828.0 |
| 2022-05-06 18:00:00 | AAPL | Stock | 157.18 | 157.18 | 156.9001 | 156.97 | 21190.0 |
| 2022-05-06 18:30:00 | AAPL | Stock | 156.82 | 156.94 | 156.8 | 156.85 | 26291.0 |
| 2022-05-06 19:00:00 | AAPL | Stock | 156.8799 | 157.04 | 156.83 | 157.0 | 5353.0 |
| 2022-05-06 19:30:00 | AAPL | Stock | 156.95 | 157.21 | 156.94 | 157.15 | 17453.0 |
| 2022-05-06 04:00:00 | MSFT | Stock | 275.8 | 277.0 | 275.8 | 276.33 | 5790.0 |
| 2022-05-06 04:30:00 | MSFT | Stock | 276.8 | 277.0 | 275.75 | 275.75 | 1678.0 |
| 2022-05-06 05:00:00 | MSFT | Stock | 275.65 | 275.65 | 275.15 | 275.35 | 2054.0 |
| 2022-05-06 05:30:00 | MSFT | Stock | 275.39 | 276.06 | 275.39 | 276.06 | 1221.0 |
| 2022-05-06 06:00:00 | MSFT | Stock | 276.05 | 276.25 | 275.88 | 275.88 | 1496.0 |
| 2022-05-06 06:30:00 | MSFT | Stock | 276.0 | 276.0 | 276.0 | 276.0 | 100.0 |
| 2022-05-06 07:00:00 | MSFT | Stock | 275.93 | 276.09 | 274.7 | 274.73 | 12795.0 |
| 2022-05-06 07:30:00 | MSFT | Stock | 274.66 | 275.85 | 274.57 | 275.5 | 18654.0 |
| 2022-05-06 08:00:00 | MSFT | Stock | 275.8 | 276.5 | 274.5325 | 276.06 | 44720.0 |
| 2022-05-06 08:30:00 | MSFT | Stock | 276.87 | 278.88 | 274.67 | 274.84 | 76386.0 |
| 2022-05-06 09:00:00 | MSFT | Stock | 275.4 | 275.7 | 274.58 | 274.66 | 57906.0 |
| 2022-05-06 09:30:00 | MSFT | Stock | 274.82 | 276.1 | 271.3603 | 271.97 | 2590177.0 |
| 2022-05-06 10:00:00 | MSFT | Stock | 271.99 | 277.94 | 271.73 | 274.11 | 2404238.0 |
| 2022-05-06 10:30:00 | MSFT | Stock | 274.05 | 278.74 | 272.56 | 277.79 | 2077699.0 |
| 2022-05-06 11:00:00 | MSFT | Stock | 277.78 | 279.25 | 275.4 | 278.75 | 1807827.0 |
| 2022-05-06 11:30:00 | MSFT | Stock | 278.77 | 278.97 | 275.38 | 275.82 | 1254378.0 |
| 2022-05-06 12:00:00 | MSFT | Stock | 275.825 | 278.27 | 275.415 | 276.91 | 1062522.0 |
| 2022-05-06 12:30:00 | MSFT | Stock | 276.87 | 278.24 | 276.0801 | 278.115 | 1032847.0 |
> showing 50 of 106,076 rows — these rows as CSV