PREVIEW / stock_30min / 2021-10-05
file: by_date/stock_30min/2021/2021-10-05.parquet size: 2.2 MB rows: 107,510 symbols: 2,682
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-10-05 04:00:00 | AAPL | Stock | 139.43 | 139.63 | 139.01 | 139.53 | 13603.0 |
| 2021-10-05 04:30:00 | AAPL | Stock | 139.66 | 139.79 | 139.38 | 139.68 | 9864.0 |
| 2021-10-05 05:00:00 | AAPL | Stock | 139.67 | 139.97 | 139.62 | 139.8 | 18240.0 |
| 2021-10-05 05:30:00 | AAPL | Stock | 139.8 | 139.97 | 139.66 | 139.81 | 5945.0 |
| 2021-10-05 06:00:00 | AAPL | Stock | 139.96 | 139.97 | 139.63 | 139.66 | 14959.0 |
| 2021-10-05 06:30:00 | AAPL | Stock | 139.62 | 139.64 | 139.31 | 139.47 | 15599.0 |
| 2021-10-05 07:00:00 | AAPL | Stock | 139.52 | 139.69 | 139.33 | 139.67 | 132199.0 |
| 2021-10-05 07:30:00 | AAPL | Stock | 139.65 | 139.81 | 139.53 | 139.55 | 76225.0 |
| 2021-10-05 08:00:00 | AAPL | Stock | 139.56 | 139.8 | 139.4 | 139.61 | 216552.0 |
| 2021-10-05 08:30:00 | AAPL | Stock | 139.62 | 139.7 | 139.55 | 139.7 | 86732.0 |
| 2021-10-05 09:00:00 | AAPL | Stock | 139.71 | 139.8 | 139.4 | 139.48 | 224999.0 |
| 2021-10-05 09:30:00 | AAPL | Stock | 139.49 | 140.4 | 139.36 | 139.82 | 9359771.0 |
| 2021-10-05 10:00:00 | AAPL | Stock | 139.82 | 140.1 | 139.58 | 139.87 | 5454610.0 |
| 2021-10-05 10:30:00 | AAPL | Stock | 139.87 | 140.57 | 139.63 | 140.5402 | 6142997.0 |
| 2021-10-05 11:00:00 | AAPL | Stock | 140.54 | 141.28 | 140.49 | 141.1 | 5603576.0 |
| 2021-10-05 11:30:00 | AAPL | Stock | 141.09 | 141.5499 | 140.93 | 141.535 | 5586692.0 |
| 2021-10-05 12:00:00 | AAPL | Stock | 141.5301 | 141.89 | 141.33 | 141.785 | 4406607.0 |
| 2021-10-05 12:30:00 | AAPL | Stock | 141.79 | 142.01 | 141.73 | 141.941 | 3839999.0 |
| 2021-10-05 13:00:00 | AAPL | Stock | 141.95 | 142.0 | 141.59 | 141.765 | 2990431.0 |
| 2021-10-05 13:30:00 | AAPL | Stock | 141.76 | 142.12 | 141.755 | 141.995 | 2928191.0 |
| 2021-10-05 14:00:00 | AAPL | Stock | 141.99 | 142.19 | 141.87 | 142.0455 | 2764607.0 |
| 2021-10-05 14:30:00 | AAPL | Stock | 142.0401 | 142.24 | 141.98 | 141.995 | 2514387.0 |
| 2021-10-05 15:00:00 | AAPL | Stock | 141.995 | 142.12 | 141.61 | 141.65 | 2919929.0 |
| 2021-10-05 15:30:00 | AAPL | Stock | 141.64 | 141.73 | 140.91 | 141.1 | 7597299.0 |
| 2021-10-05 16:00:00 | AAPL | Stock | 141.1 | 141.25 | 140.75 | 141.06 | 6883265.0 |
| 2021-10-05 16:30:00 | AAPL | Stock | 141.07 | 141.12 | 140.82 | 141.0 | 50767.0 |
| 2021-10-05 17:00:00 | AAPL | Stock | 141.04 | 141.05 | 140.95 | 140.95 | 16178.0 |
| 2021-10-05 17:30:00 | AAPL | Stock | 140.95 | 141.08 | 140.95 | 141.01 | 10210.0 |
| 2021-10-05 18:00:00 | AAPL | Stock | 141.05 | 141.14 | 141.05 | 141.12 | 15728.0 |
| 2021-10-05 18:30:00 | AAPL | Stock | 141.11 | 141.14 | 141.09 | 141.14 | 9080.0 |
| 2021-10-05 19:00:00 | AAPL | Stock | 141.14 | 141.14 | 141.0 | 141.03 | 14437.0 |
| 2021-10-05 19:30:00 | AAPL | Stock | 141.03 | 141.1 | 140.81 | 140.85 | 44026.0 |
| 2021-10-05 04:00:00 | MSFT | Stock | 283.11 | 283.61 | 282.86 | 283.61 | 2731.0 |
| 2021-10-05 04:30:00 | MSFT | Stock | 283.62 | 283.96 | 283.45 | 283.96 | 2267.0 |
| 2021-10-05 05:00:00 | MSFT | Stock | 283.74 | 284.49 | 283.74 | 284.3 | 2490.0 |
| 2021-10-05 05:30:00 | MSFT | Stock | 284.02 | 284.49 | 284.02 | 284.49 | 767.0 |
| 2021-10-05 06:00:00 | MSFT | Stock | 283.95 | 284.0 | 283.85 | 283.85 | 1378.0 |
| 2021-10-05 06:30:00 | MSFT | Stock | 283.57 | 283.61 | 283.3 | 283.5 | 6097.0 |
| 2021-10-05 07:00:00 | MSFT | Stock | 283.85 | 283.9 | 283.22 | 283.9 | 8660.0 |
| 2021-10-05 07:30:00 | MSFT | Stock | 283.94 | 284.41 | 283.94 | 284.09 | 7202.0 |
| 2021-10-05 08:00:00 | MSFT | Stock | 283.11 | 284.41 | 283.11 | 283.99 | 22682.0 |
| 2021-10-05 08:30:00 | MSFT | Stock | 284.0 | 284.38 | 283.66 | 284.1 | 16054.0 |
| 2021-10-05 09:00:00 | MSFT | Stock | 284.166 | 284.58 | 283.73 | 284.0 | 57121.0 |
| 2021-10-05 09:30:00 | MSFT | Stock | 284.01 | 286.07 | 284.01 | 285.76 | 2473394.0 |
| 2021-10-05 10:00:00 | MSFT | Stock | 285.785 | 287.2199 | 285.6208 | 286.72 | 1368654.0 |
| 2021-10-05 10:30:00 | MSFT | Stock | 286.79 | 288.06 | 286.51 | 287.901 | 1177597.0 |
| 2021-10-05 11:00:00 | MSFT | Stock | 287.88 | 288.93 | 287.67 | 288.2401 | 1153310.0 |
| 2021-10-05 11:30:00 | MSFT | Stock | 288.29 | 289.2 | 288.14 | 289.19 | 998476.0 |
| 2021-10-05 12:00:00 | MSFT | Stock | 289.181 | 289.82 | 288.81 | 289.56 | 973765.0 |
| 2021-10-05 12:30:00 | MSFT | Stock | 289.57 | 289.98 | 289.43 | 289.79 | 675990.0 |
> showing 50 of 107,510 rows — these rows as CSV