PREVIEW / stock_30min / 2021-03-26
file: by_date/stock_30min/2021/2021-03-26.parquet size: 2.2 MB rows: 113,170 symbols: 2,928
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-03-26 04:00:00 | AAPL | Stock | 121.4 | 121.4 | 121.05 | 121.05 | 5800.0 |
| 2021-03-26 04:30:00 | AAPL | Stock | 121.08 | 121.15 | 120.86 | 120.86 | 5383.0 |
| 2021-03-26 05:00:00 | AAPL | Stock | 120.86 | 120.92 | 120.5 | 120.79 | 14117.0 |
| 2021-03-26 05:30:00 | AAPL | Stock | 120.95 | 120.95 | 120.78 | 120.95 | 2427.0 |
| 2021-03-26 06:00:00 | AAPL | Stock | 121.0 | 121.15 | 120.87 | 121.03 | 5510.0 |
| 2021-03-26 06:30:00 | AAPL | Stock | 120.92 | 120.92 | 120.44 | 120.46 | 16346.0 |
| 2021-03-26 07:00:00 | AAPL | Stock | 120.61 | 120.67 | 120.1 | 120.1 | 167188.0 |
| 2021-03-26 07:30:00 | AAPL | Stock | 120.09 | 120.49 | 120.05 | 120.42 | 127239.0 |
| 2021-03-26 08:00:00 | AAPL | Stock | 120.43 | 120.67 | 119.9 | 120.1 | 377005.0 |
| 2021-03-26 08:30:00 | AAPL | Stock | 120.1 | 120.41 | 120.06 | 120.3 | 132602.0 |
| 2021-03-26 09:00:00 | AAPL | Stock | 120.32 | 120.7 | 120.27 | 120.38 | 213162.0 |
| 2021-03-26 09:30:00 | AAPL | Stock | 120.39 | 121.08 | 120.01 | 120.14 | 8382801.0 |
| 2021-03-26 10:00:00 | AAPL | Stock | 120.15 | 120.76 | 119.81 | 120.26 | 6807990.0 |
| 2021-03-26 10:30:00 | AAPL | Stock | 120.265 | 120.64 | 119.91 | 120.14 | 5528594.0 |
| 2021-03-26 11:00:00 | AAPL | Stock | 120.15 | 120.25 | 119.55 | 119.71 | 5069482.0 |
| 2021-03-26 11:30:00 | AAPL | Stock | 119.705 | 120.45 | 119.48 | 120.44 | 4795449.0 |
| 2021-03-26 12:00:00 | AAPL | Stock | 120.45 | 120.51 | 120.03 | 120.225 | 3498094.0 |
| 2021-03-26 12:30:00 | AAPL | Stock | 120.23 | 120.73 | 120.165 | 120.45 | 3752065.0 |
| 2021-03-26 13:00:00 | AAPL | Stock | 120.45 | 120.68 | 120.3 | 120.58 | 2791124.0 |
| 2021-03-26 13:30:00 | AAPL | Stock | 120.58 | 120.63 | 119.82 | 119.9 | 3516922.0 |
| 2021-03-26 14:00:00 | AAPL | Stock | 119.9 | 120.14 | 119.09 | 119.4 | 6468882.0 |
| 2021-03-26 14:30:00 | AAPL | Stock | 119.395 | 119.68 | 118.92 | 119.587 | 6953617.0 |
| 2021-03-26 15:00:00 | AAPL | Stock | 119.59 | 120.1 | 119.58 | 120.065 | 4636889.0 |
| 2021-03-26 15:30:00 | AAPL | Stock | 120.07 | 121.48 | 120.07 | 121.21 | 11757272.0 |
| 2021-03-26 16:00:00 | AAPL | Stock | 121.21 | 121.5 | 121.06 | 121.15 | 8042073.0 |
| 2021-03-26 16:30:00 | AAPL | Stock | 121.15 | 121.25 | 121.0 | 121.24 | 166707.0 |
| 2021-03-26 17:00:00 | AAPL | Stock | 121.23 | 121.23 | 121.02 | 121.09 | 52583.0 |
| 2021-03-26 17:30:00 | AAPL | Stock | 121.06 | 121.09 | 121.01 | 121.06 | 26030.0 |
| 2021-03-26 18:00:00 | AAPL | Stock | 121.08 | 121.21 | 121.08 | 121.19 | 38487.0 |
| 2021-03-26 18:30:00 | AAPL | Stock | 121.17 | 121.17 | 121.05 | 121.1 | 22653.0 |
| 2021-03-26 19:00:00 | AAPL | Stock | 121.09 | 121.12 | 121.05 | 121.12 | 34639.0 |
| 2021-03-26 19:30:00 | AAPL | Stock | 121.12 | 121.18 | 121.08 | 121.1 | 26895.0 |
| 2021-03-26 04:00:00 | MSFT | Stock | 233.66 | 233.66 | 233.15 | 233.15 | 456.0 |
| 2021-03-26 04:30:00 | MSFT | Stock | 232.83 | 232.83 | 232.6 | 232.6 | 509.0 |
| 2021-03-26 05:00:00 | MSFT | Stock | 232.6 | 232.68 | 232.5 | 232.68 | 414.0 |
| 2021-03-26 05:30:00 | MSFT | Stock | 232.71 | 232.71 | 232.71 | 232.71 | 499.0 |
| 2021-03-26 06:00:00 | MSFT | Stock | 232.9 | 232.9 | 232.7 | 232.76 | 1231.0 |
| 2021-03-26 06:30:00 | MSFT | Stock | 232.7 | 232.7 | 232.2 | 232.2 | 4610.0 |
| 2021-03-26 07:00:00 | MSFT | Stock | 232.5 | 232.6 | 231.16 | 231.16 | 12467.0 |
| 2021-03-26 07:30:00 | MSFT | Stock | 231.4 | 231.95 | 231.33 | 231.95 | 4520.0 |
| 2021-03-26 08:00:00 | MSFT | Stock | 232.25 | 232.8 | 230.6 | 231.5 | 30494.0 |
| 2021-03-26 08:30:00 | MSFT | Stock | 231.3912 | 232.3 | 231.31 | 231.82 | 13138.0 |
| 2021-03-26 09:00:00 | MSFT | Stock | 232.25 | 232.89 | 231.35 | 231.58 | 40716.0 |
| 2021-03-26 09:30:00 | MSFT | Stock | 231.58 | 233.94 | 231.55 | 233.08 | 1740266.0 |
| 2021-03-26 10:00:00 | MSFT | Stock | 233.08 | 233.71 | 232.43 | 233.425 | 1096328.0 |
| 2021-03-26 10:30:00 | MSFT | Stock | 233.42 | 234.15 | 233.35 | 233.81 | 816118.0 |
| 2021-03-26 11:00:00 | MSFT | Stock | 233.81 | 234.0 | 232.77 | 233.11 | 800505.0 |
| 2021-03-26 11:30:00 | MSFT | Stock | 233.115 | 234.99 | 232.9 | 234.99 | 1068059.0 |
| 2021-03-26 12:00:00 | MSFT | Stock | 234.99 | 235.18 | 234.01 | 234.32 | 729476.0 |
| 2021-03-26 12:30:00 | MSFT | Stock | 234.335 | 235.11 | 234.07 | 234.8 | 637795.0 |
> showing 50 of 113,170 rows — these rows as CSV