PREVIEW / stock_30min / 2020-10-12
file: by_date/stock_30min/2020/2020-10-12.parquet size: 2.0 MB rows: 98,144 symbols: 2,506
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-10-12 04:00:00 | AAPL | Stock | 118.55 | 120.74 | 118.55 | 120.6 | 236181.0 |
| 2020-10-12 04:30:00 | AAPL | Stock | 120.61 | 120.95 | 120.05 | 120.2 | 126755.0 |
| 2020-10-12 05:00:00 | AAPL | Stock | 120.15 | 120.34 | 119.8 | 119.85 | 59958.0 |
| 2020-10-12 05:30:00 | AAPL | Stock | 119.9 | 120.0 | 119.74 | 119.75 | 34257.0 |
| 2020-10-12 06:00:00 | AAPL | Stock | 119.82 | 120.22 | 119.78 | 120.07 | 29137.0 |
| 2020-10-12 06:30:00 | AAPL | Stock | 120.0 | 120.59 | 120.0 | 120.5 | 74028.0 |
| 2020-10-12 07:00:00 | AAPL | Stock | 120.41 | 120.59 | 120.03 | 120.4 | 401100.0 |
| 2020-10-12 07:30:00 | AAPL | Stock | 120.4 | 120.84 | 120.21 | 120.77 | 308936.0 |
| 2020-10-12 08:00:00 | AAPL | Stock | 120.36 | 121.0 | 117.26 | 120.9 | 1192469.0 |
| 2020-10-12 08:30:00 | AAPL | Stock | 120.9 | 121.0 | 120.56 | 120.58 | 614402.0 |
| 2020-10-12 09:00:00 | AAPL | Stock | 120.57 | 120.8 | 120.01 | 120.06 | 1060628.0 |
| 2020-10-12 09:30:00 | AAPL | Stock | 120.06 | 121.49 | 119.284 | 120.45 | 28563949.0 |
| 2020-10-12 10:00:00 | AAPL | Stock | 120.445 | 121.15 | 120.19 | 120.92 | 11028962.0 |
| 2020-10-12 10:30:00 | AAPL | Stock | 120.92 | 121.82 | 120.77 | 121.78 | 10801889.0 |
| 2020-10-12 11:00:00 | AAPL | Stock | 121.78 | 122.64 | 121.78 | 122.53 | 13972160.0 |
| 2020-10-12 11:30:00 | AAPL | Stock | 122.525 | 123.63 | 122.29 | 122.71 | 20380076.0 |
| 2020-10-12 12:00:00 | AAPL | Stock | 122.72 | 123.34 | 122.57 | 123.261 | 12771487.0 |
| 2020-10-12 12:30:00 | AAPL | Stock | 123.26 | 123.75 | 123.04 | 123.55 | 10754111.0 |
| 2020-10-12 13:00:00 | AAPL | Stock | 123.555 | 124.0 | 123.35 | 123.985 | 10873186.0 |
| 2020-10-12 13:30:00 | AAPL | Stock | 123.984 | 124.48 | 123.91 | 124.3 | 12249788.0 |
| 2020-10-12 14:00:00 | AAPL | Stock | 124.3 | 125.18 | 124.3 | 125.055 | 16441463.0 |
| 2020-10-12 14:30:00 | AAPL | Stock | 125.054 | 125.09 | 124.16 | 124.29 | 15284683.0 |
| 2020-10-12 15:00:00 | AAPL | Stock | 124.296 | 124.589 | 123.62 | 124.314 | 14964445.0 |
| 2020-10-12 15:30:00 | AAPL | Stock | 124.32 | 124.66 | 123.96 | 124.42 | 19094816.0 |
| 2020-10-12 16:00:00 | AAPL | Stock | 124.4 | 124.75 | 124.3 | 124.39 | 16666518.0 |
| 2020-10-12 16:30:00 | AAPL | Stock | 124.4 | 124.75 | 124.38 | 124.54 | 386447.0 |
| 2020-10-12 17:00:00 | AAPL | Stock | 124.54 | 124.71 | 124.53 | 124.68 | 158199.0 |
| 2020-10-12 17:30:00 | AAPL | Stock | 124.68 | 124.95 | 124.62 | 124.95 | 267140.0 |
| 2020-10-12 18:00:00 | AAPL | Stock | 124.94 | 124.98 | 124.81 | 124.81 | 271304.0 |
| 2020-10-12 18:30:00 | AAPL | Stock | 124.83 | 124.84 | 124.63 | 124.67 | 184450.0 |
| 2020-10-12 19:00:00 | AAPL | Stock | 124.7 | 124.89 | 124.67 | 124.88 | 138178.0 |
| 2020-10-12 19:30:00 | AAPL | Stock | 124.88 | 124.98 | 124.83 | 124.92 | 295724.0 |
| 2020-10-12 04:00:00 | MSFT | Stock | 216.21 | 217.5 | 216.21 | 217.5 | 3169.0 |
| 2020-10-12 04:30:00 | MSFT | Stock | 217.53 | 217.86 | 217.39 | 217.39 | 3815.0 |
| 2020-10-12 05:00:00 | MSFT | Stock | 217.61 | 217.68 | 217.61 | 217.68 | 1189.0 |
| 2020-10-12 05:30:00 | MSFT | Stock | 217.41 | 217.76 | 217.39 | 217.39 | 3733.0 |
| 2020-10-12 06:00:00 | MSFT | Stock | 217.39 | 217.7 | 217.3 | 217.65 | 8839.0 |
| 2020-10-12 06:30:00 | MSFT | Stock | 217.69 | 219.5 | 217.69 | 218.89 | 9397.0 |
| 2020-10-12 07:00:00 | MSFT | Stock | 217.5 | 219.11 | 217.5 | 219.1 | 71578.0 |
| 2020-10-12 07:30:00 | MSFT | Stock | 219.0 | 219.64 | 218.5 | 219.59 | 49741.0 |
| 2020-10-12 08:00:00 | MSFT | Stock | 218.37 | 219.89 | 215.28 | 219.53 | 84799.0 |
| 2020-10-12 08:30:00 | MSFT | Stock | 219.6 | 220.0 | 219.0 | 219.05 | 76202.0 |
| 2020-10-12 09:00:00 | MSFT | Stock | 219.0 | 219.7 | 218.52 | 218.68 | 84979.0 |
| 2020-10-12 09:30:00 | MSFT | Stock | 218.68 | 220.25 | 217.1 | 217.4 | 4285295.0 |
| 2020-10-12 10:00:00 | MSFT | Stock | 217.41 | 218.48 | 216.81 | 218.22 | 1983550.0 |
| 2020-10-12 10:30:00 | MSFT | Stock | 218.21 | 219.6 | 218.05 | 219.55 | 1514692.0 |
| 2020-10-12 11:00:00 | MSFT | Stock | 219.55 | 220.26 | 219.41 | 219.96 | 1628527.0 |
| 2020-10-12 11:30:00 | MSFT | Stock | 219.965 | 220.571 | 219.7 | 220.164 | 1500235.0 |
| 2020-10-12 12:00:00 | MSFT | Stock | 220.16 | 222.38 | 220.12 | 222.21 | 2443584.0 |
| 2020-10-12 12:30:00 | MSFT | Stock | 222.2 | 223.49 | 222.02 | 222.645 | 2471425.0 |
> showing 50 of 98,144 rows — these rows as CSV