PREVIEW / stock_30min / 2020-11-12
file: by_date/stock_30min/2020/2020-11-12.parquet size: 2.0 MB rows: 99,092 symbols: 2,509
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 |
|---|---|---|---|---|---|---|---|
| 2020-11-12 04:00:00 | AAPL | Stock | 119.22 | 119.29 | 118.7 | 119.2 | 37860.0 |
| 2020-11-12 04:30:00 | AAPL | Stock | 119.26 | 119.97 | 119.26 | 119.83 | 18852.0 |
| 2020-11-12 05:00:00 | AAPL | Stock | 119.94 | 120.16 | 119.76 | 119.8 | 52620.0 |
| 2020-11-12 05:30:00 | AAPL | Stock | 119.76 | 120.0 | 119.61 | 119.95 | 16891.0 |
| 2020-11-12 06:00:00 | AAPL | Stock | 119.98 | 120.0 | 119.68 | 119.88 | 10494.0 |
| 2020-11-12 06:30:00 | AAPL | Stock | 119.93 | 119.99 | 119.8 | 119.8 | 8006.0 |
| 2020-11-12 07:00:00 | AAPL | Stock | 119.89 | 119.89 | 119.19 | 119.74 | 145218.0 |
| 2020-11-12 07:30:00 | AAPL | Stock | 119.7 | 119.7 | 119.3 | 119.35 | 78463.0 |
| 2020-11-12 08:00:00 | AAPL | Stock | 119.55 | 119.89 | 119.15 | 119.42 | 323984.0 |
| 2020-11-12 08:30:00 | AAPL | Stock | 119.45 | 119.8 | 119.4 | 119.65 | 260727.0 |
| 2020-11-12 09:00:00 | AAPL | Stock | 119.66 | 119.73 | 119.41 | 119.71 | 293041.0 |
| 2020-11-12 09:30:00 | AAPL | Stock | 119.7 | 120.05 | 118.81 | 119.72 | 14240441.0 |
| 2020-11-12 10:00:00 | AAPL | Stock | 119.73 | 120.17 | 119.5 | 119.99 | 8083294.0 |
| 2020-11-12 10:30:00 | AAPL | Stock | 119.985 | 120.53 | 119.95 | 120.21 | 7160444.0 |
| 2020-11-12 11:00:00 | AAPL | Stock | 120.22 | 120.52 | 119.65 | 119.86 | 6131442.0 |
| 2020-11-12 11:30:00 | AAPL | Stock | 119.865 | 119.88 | 119.03 | 119.595 | 6154487.0 |
| 2020-11-12 12:00:00 | AAPL | Stock | 119.6 | 120.205 | 119.51 | 119.655 | 7913620.0 |
| 2020-11-12 12:30:00 | AAPL | Stock | 119.651 | 120.07 | 118.97 | 119.49 | 5798562.0 |
| 2020-11-12 13:00:00 | AAPL | Stock | 119.48 | 119.495 | 118.88 | 118.945 | 4827121.0 |
| 2020-11-12 13:30:00 | AAPL | Stock | 118.94 | 119.19 | 118.57 | 119.135 | 5259060.0 |
| 2020-11-12 14:00:00 | AAPL | Stock | 119.13 | 119.29 | 118.7 | 118.883 | 4338780.0 |
| 2020-11-12 14:30:00 | AAPL | Stock | 118.88 | 119.18 | 118.58 | 119.07 | 4951303.0 |
| 2020-11-12 15:00:00 | AAPL | Stock | 119.065 | 119.47 | 118.91 | 119.03 | 5535828.0 |
| 2020-11-12 15:30:00 | AAPL | Stock | 119.03 | 119.3 | 118.8 | 119.235 | 6901436.0 |
| 2020-11-12 16:00:00 | AAPL | Stock | 119.21 | 119.776 | 119.13 | 119.26 | 5101156.0 |
| 2020-11-12 16:30:00 | AAPL | Stock | 119.26 | 119.35 | 119.25 | 119.28 | 45716.0 |
| 2020-11-12 17:00:00 | AAPL | Stock | 119.29 | 119.3 | 119.1 | 119.15 | 34640.0 |
| 2020-11-12 17:30:00 | AAPL | Stock | 119.15 | 119.2 | 119.07 | 119.15 | 39986.0 |
| 2020-11-12 18:00:00 | AAPL | Stock | 119.22 | 119.29 | 119.06 | 119.16 | 36715.0 |
| 2020-11-12 18:30:00 | AAPL | Stock | 119.15 | 119.19 | 119.05 | 119.1 | 32106.0 |
| 2020-11-12 19:00:00 | AAPL | Stock | 119.06 | 119.15 | 119.05 | 119.07 | 33023.0 |
| 2020-11-12 19:30:00 | AAPL | Stock | 119.06 | 119.15 | 118.9 | 119.0 | 84567.0 |
| 2020-11-12 04:00:00 | MSFT | Stock | 216.0 | 216.02 | 215.98 | 216.0 | 1756.0 |
| 2020-11-12 04:30:00 | MSFT | Stock | 216.48 | 217.96 | 216.48 | 217.95 | 2094.0 |
| 2020-11-12 05:00:00 | MSFT | Stock | 218.2 | 218.48 | 218.0 | 218.31 | 1845.0 |
| 2020-11-12 05:30:00 | MSFT | Stock | 218.31 | 218.36 | 217.59 | 217.7 | 2412.0 |
| 2020-11-12 06:00:00 | MSFT | Stock | 217.5 | 217.7 | 217.06 | 217.7 | 1686.0 |
| 2020-11-12 06:30:00 | MSFT | Stock | 217.43 | 217.88 | 217.43 | 217.88 | 1197.0 |
| 2020-11-12 07:00:00 | MSFT | Stock | 217.78 | 217.78 | 215.98 | 216.6 | 22505.0 |
| 2020-11-12 07:30:00 | MSFT | Stock | 216.82 | 217.25 | 216.5 | 216.55 | 17942.0 |
| 2020-11-12 08:00:00 | MSFT | Stock | 216.36 | 217.41 | 216.002 | 216.9 | 31194.0 |
| 2020-11-12 08:30:00 | MSFT | Stock | 216.9 | 217.6 | 216.82 | 217.15 | 15708.0 |
| 2020-11-12 09:00:00 | MSFT | Stock | 217.0 | 217.286 | 216.55 | 217.24 | 33495.0 |
| 2020-11-12 09:30:00 | MSFT | Stock | 217.27 | 219.04 | 216.1 | 218.575 | 2648498.0 |
| 2020-11-12 10:00:00 | MSFT | Stock | 218.56 | 219.11 | 217.77 | 217.885 | 1328705.0 |
| 2020-11-12 10:30:00 | MSFT | Stock | 217.9 | 218.9 | 217.67 | 217.78 | 1106034.0 |
| 2020-11-12 11:00:00 | MSFT | Stock | 217.79 | 218.29 | 217.05 | 217.33 | 787344.0 |
| 2020-11-12 11:30:00 | MSFT | Stock | 217.32 | 217.322 | 216.2 | 217.0 | 807033.0 |
| 2020-11-12 12:00:00 | MSFT | Stock | 217.0 | 217.4 | 216.3 | 216.36 | 698204.0 |
| 2020-11-12 12:30:00 | MSFT | Stock | 216.37 | 216.91 | 215.27 | 215.72 | 965538.0 |
> showing 50 of 99,092 rows — these rows as CSV