PREVIEW / stock_30min / 2021-01-22
file: by_date/stock_30min/2021/2021-01-22.parquet size: 2.3 MB rows: 114,698 symbols: 2,713
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-01-22 04:00:00 | AAPL | Stock | 135.84 | 135.87 | 135.34 | 135.7 | 39710.0 |
| 2021-01-22 04:30:00 | AAPL | Stock | 135.68 | 135.78 | 135.2 | 135.45 | 49792.0 |
| 2021-01-22 05:00:00 | AAPL | Stock | 135.45 | 136.08 | 135.35 | 136.06 | 36109.0 |
| 2021-01-22 05:30:00 | AAPL | Stock | 136.08 | 136.08 | 135.51 | 135.66 | 13625.0 |
| 2021-01-22 06:00:00 | AAPL | Stock | 135.73 | 135.98 | 135.52 | 135.62 | 20629.0 |
| 2021-01-22 06:30:00 | AAPL | Stock | 135.57 | 136.08 | 135.5 | 136.07 | 55586.0 |
| 2021-01-22 07:00:00 | AAPL | Stock | 136.0 | 136.3 | 135.8 | 135.98 | 231930.0 |
| 2021-01-22 07:30:00 | AAPL | Stock | 135.99 | 136.1 | 135.57 | 135.88 | 133071.0 |
| 2021-01-22 08:00:00 | AAPL | Stock | 136.2 | 136.3 | 135.53 | 135.64 | 350853.0 |
| 2021-01-22 08:30:00 | AAPL | Stock | 135.64 | 136.05 | 135.4 | 135.93 | 279968.0 |
| 2021-01-22 09:00:00 | AAPL | Stock | 135.96 | 136.48 | 135.91 | 136.32 | 371115.0 |
| 2021-01-22 09:30:00 | AAPL | Stock | 136.26 | 137.58 | 135.02 | 137.34 | 16608868.0 |
| 2021-01-22 10:00:00 | AAPL | Stock | 137.37 | 137.66 | 136.51 | 136.615 | 8269146.0 |
| 2021-01-22 10:30:00 | AAPL | Stock | 136.616 | 136.91 | 136.02 | 136.88 | 6618721.0 |
| 2021-01-22 11:00:00 | AAPL | Stock | 136.87 | 137.52 | 136.8 | 137.245 | 6559279.0 |
| 2021-01-22 11:30:00 | AAPL | Stock | 137.245 | 137.47 | 136.95 | 137.34 | 4328894.0 |
| 2021-01-22 12:00:00 | AAPL | Stock | 137.35 | 138.18 | 137.2 | 138.093 | 6205388.0 |
| 2021-01-22 12:30:00 | AAPL | Stock | 138.095 | 138.12 | 137.71 | 137.975 | 4563006.0 |
| 2021-01-22 13:00:00 | AAPL | Stock | 137.973 | 138.17 | 137.74 | 138.005 | 3652951.0 |
| 2021-01-22 13:30:00 | AAPL | Stock | 138.005 | 138.32 | 137.87 | 137.999 | 3815694.0 |
| 2021-01-22 14:00:00 | AAPL | Stock | 137.999 | 138.49 | 137.88 | 138.425 | 4137265.0 |
| 2021-01-22 14:30:00 | AAPL | Stock | 138.42 | 139.19 | 138.38 | 139.09 | 5862246.0 |
| 2021-01-22 15:00:00 | AAPL | Stock | 139.095 | 139.44 | 138.63 | 139.363 | 7389048.0 |
| 2021-01-22 15:30:00 | AAPL | Stock | 139.367 | 139.85 | 138.92 | 138.97 | 11832943.0 |
| 2021-01-22 16:00:00 | AAPL | Stock | 138.98 | 139.5 | 138.92 | 139.37 | 6838929.0 |
| 2021-01-22 16:30:00 | AAPL | Stock | 139.35 | 139.45 | 139.32 | 139.39 | 87304.0 |
| 2021-01-22 17:00:00 | AAPL | Stock | 139.38 | 139.44 | 139.11 | 139.3 | 291423.0 |
| 2021-01-22 17:30:00 | AAPL | Stock | 139.36 | 139.98 | 139.33 | 139.95 | 276988.0 |
| 2021-01-22 18:00:00 | AAPL | Stock | 139.95 | 140.0 | 139.91 | 139.96 | 158983.0 |
| 2021-01-22 18:30:00 | AAPL | Stock | 139.97 | 140.23 | 139.89 | 140.21 | 143691.0 |
| 2021-01-22 19:00:00 | AAPL | Stock | 140.23 | 140.25 | 140.17 | 140.23 | 111479.0 |
| 2021-01-22 19:30:00 | AAPL | Stock | 140.2 | 140.4 | 140.19 | 140.36 | 151101.0 |
| 2021-01-22 04:00:00 | MSFT | Stock | 224.87 | 224.9 | 224.6 | 224.8 | 3673.0 |
| 2021-01-22 04:30:00 | MSFT | Stock | 224.82 | 225.3 | 224.23 | 224.82 | 6547.0 |
| 2021-01-22 05:00:00 | MSFT | Stock | 224.53 | 224.93 | 224.5 | 224.93 | 4643.0 |
| 2021-01-22 05:30:00 | MSFT | Stock | 224.74 | 224.9 | 224.42 | 224.5 | 3393.0 |
| 2021-01-22 06:00:00 | MSFT | Stock | 224.5 | 224.88 | 224.5 | 224.6 | 2036.0 |
| 2021-01-22 06:30:00 | MSFT | Stock | 224.6 | 225.3 | 224.55 | 225.3 | 5498.0 |
| 2021-01-22 07:00:00 | MSFT | Stock | 225.02 | 225.81 | 224.99 | 225.3 | 11947.0 |
| 2021-01-22 07:30:00 | MSFT | Stock | 225.3 | 225.8 | 224.78 | 225.8 | 23235.0 |
| 2021-01-22 08:00:00 | MSFT | Stock | 224.9 | 226.26 | 224.41 | 226.1 | 36037.0 |
| 2021-01-22 08:30:00 | MSFT | Stock | 226.1 | 226.1 | 225.58 | 225.79 | 43481.0 |
| 2021-01-22 09:00:00 | MSFT | Stock | 225.72 | 227.69 | 225.65 | 227.44 | 118077.0 |
| 2021-01-22 09:30:00 | MSFT | Stock | 227.08 | 229.32 | 226.67 | 229.28 | 3934311.0 |
| 2021-01-22 10:00:00 | MSFT | Stock | 229.28 | 230.07 | 228.915 | 229.15 | 3175099.0 |
| 2021-01-22 10:30:00 | MSFT | Stock | 229.16 | 229.95 | 228.73 | 229.752 | 1715578.0 |
| 2021-01-22 11:00:00 | MSFT | Stock | 229.77 | 229.79 | 228.5 | 228.51 | 1484005.0 |
| 2021-01-22 11:30:00 | MSFT | Stock | 228.52 | 228.54 | 227.67 | 228.055 | 1586575.0 |
| 2021-01-22 12:00:00 | MSFT | Stock | 228.06 | 228.53 | 227.58 | 228.28 | 995128.0 |
| 2021-01-22 12:30:00 | MSFT | Stock | 228.29 | 228.31 | 227.45 | 227.459 | 977868.0 |
> showing 50 of 114,698 rows — these rows as CSV