PREVIEW / stock_30min / 2020-12-11
file: by_date/stock_30min/2020/2020-12-11.parquet size: 2.1 MB rows: 107,955 symbols: 2,679
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-12-11 04:00:00 | AAPL | Stock | 122.92 | 122.99 | 122.84 | 122.85 | 13093.0 |
| 2020-12-11 04:30:00 | AAPL | Stock | 122.87 | 122.92 | 122.8 | 122.8 | 9151.0 |
| 2020-12-11 05:00:00 | AAPL | Stock | 122.6 | 122.84 | 122.6 | 122.8 | 3184.0 |
| 2020-12-11 05:30:00 | AAPL | Stock | 122.76 | 122.76 | 122.07 | 122.07 | 13196.0 |
| 2020-12-11 06:00:00 | AAPL | Stock | 122.07 | 122.32 | 121.5 | 121.75 | 29793.0 |
| 2020-12-11 06:30:00 | AAPL | Stock | 121.8 | 122.18 | 121.8 | 122.04 | 11843.0 |
| 2020-12-11 07:00:00 | AAPL | Stock | 122.13 | 122.37 | 122.0 | 122.28 | 97928.0 |
| 2020-12-11 07:30:00 | AAPL | Stock | 122.34 | 122.52 | 122.12 | 122.48 | 60791.0 |
| 2020-12-11 08:00:00 | AAPL | Stock | 122.48 | 122.94 | 122.01 | 122.35 | 176503.0 |
| 2020-12-11 08:30:00 | AAPL | Stock | 122.35 | 122.73 | 122.35 | 122.65 | 141713.0 |
| 2020-12-11 09:00:00 | AAPL | Stock | 122.64 | 122.75 | 122.42 | 122.48 | 154361.0 |
| 2020-12-11 09:30:00 | AAPL | Stock | 122.44 | 122.76 | 120.88 | 121.25 | 13523520.0 |
| 2020-12-11 10:00:00 | AAPL | Stock | 121.25 | 122.011 | 121.22 | 121.58 | 5897875.0 |
| 2020-12-11 10:30:00 | AAPL | Stock | 121.59 | 121.69 | 121.17 | 121.33 | 3973644.0 |
| 2020-12-11 11:00:00 | AAPL | Stock | 121.325 | 121.715 | 121.06 | 121.08 | 3793362.0 |
| 2020-12-11 11:30:00 | AAPL | Stock | 121.08 | 121.33 | 120.8 | 120.99 | 4067725.0 |
| 2020-12-11 12:00:00 | AAPL | Stock | 120.995 | 121.28 | 120.55 | 120.78 | 3725480.0 |
| 2020-12-11 12:30:00 | AAPL | Stock | 120.776 | 121.45 | 120.6 | 121.4 | 3720751.0 |
| 2020-12-11 13:00:00 | AAPL | Stock | 121.4 | 121.68 | 121.22 | 121.391 | 3065243.0 |
| 2020-12-11 13:30:00 | AAPL | Stock | 121.4 | 121.835 | 121.33 | 121.72 | 3458684.0 |
| 2020-12-11 14:00:00 | AAPL | Stock | 121.73 | 121.99 | 121.62 | 121.774 | 3652234.0 |
| 2020-12-11 14:30:00 | AAPL | Stock | 121.776 | 122.16 | 121.77 | 121.972 | 3757280.0 |
| 2020-12-11 15:00:00 | AAPL | Stock | 121.97 | 122.4 | 121.73 | 122.165 | 4288763.0 |
| 2020-12-11 15:30:00 | AAPL | Stock | 122.165 | 122.5 | 121.835 | 122.49 | 7940697.0 |
| 2020-12-11 16:00:00 | AAPL | Stock | 122.48 | 122.49 | 121.726 | 122.32 | 11565129.0 |
| 2020-12-11 16:30:00 | AAPL | Stock | 122.35 | 122.481 | 122.22 | 122.3 | 29272.0 |
| 2020-12-11 17:00:00 | AAPL | Stock | 122.28 | 122.32 | 122.22 | 122.25 | 28815.0 |
| 2020-12-11 17:30:00 | AAPL | Stock | 122.22 | 122.41 | 122.2 | 122.21 | 21846.0 |
| 2020-12-11 18:00:00 | AAPL | Stock | 122.19 | 122.2 | 122.15 | 122.19 | 10618.0 |
| 2020-12-11 18:30:00 | AAPL | Stock | 122.19 | 122.29 | 122.15 | 122.15 | 16534.0 |
| 2020-12-11 19:00:00 | AAPL | Stock | 122.17 | 122.21 | 122.15 | 122.17 | 9255.0 |
| 2020-12-11 19:30:00 | AAPL | Stock | 122.19 | 122.28 | 122.15 | 122.28 | 36601.0 |
| 2020-12-11 04:00:00 | MSFT | Stock | 210.45 | 210.45 | 210.07 | 210.25 | 2143.0 |
| 2020-12-11 04:30:00 | MSFT | Stock | 210.54 | 210.82 | 210.25 | 210.25 | 4486.0 |
| 2020-12-11 05:00:00 | MSFT | Stock | 210.09 | 210.25 | 210.08 | 210.08 | 1239.0 |
| 2020-12-11 05:30:00 | MSFT | Stock | 210.08 | 210.08 | 209.51 | 209.51 | 15904.0 |
| 2020-12-11 06:00:00 | MSFT | Stock | 209.85 | 209.85 | 209.03 | 209.1 | 6125.0 |
| 2020-12-11 06:30:00 | MSFT | Stock | 209.1 | 209.89 | 209.01 | 209.6 | 3260.0 |
| 2020-12-11 07:00:00 | MSFT | Stock | 209.77 | 209.97 | 209.65 | 209.68 | 11106.0 |
| 2020-12-11 07:30:00 | MSFT | Stock | 209.5 | 210.0 | 209.4 | 209.77 | 3135.0 |
| 2020-12-11 08:00:00 | MSFT | Stock | 209.785 | 210.0 | 209.516 | 209.9 | 34880.0 |
| 2020-12-11 08:30:00 | MSFT | Stock | 209.96 | 210.1 | 209.75 | 210.1 | 21846.0 |
| 2020-12-11 09:00:00 | MSFT | Stock | 210.1 | 210.35 | 209.9 | 210.17 | 24895.0 |
| 2020-12-11 09:30:00 | MSFT | Stock | 210.05 | 210.78 | 209.11 | 210.55 | 2976633.0 |
| 2020-12-11 10:00:00 | MSFT | Stock | 210.58 | 212.11 | 210.04 | 211.981 | 2563148.0 |
| 2020-12-11 10:30:00 | MSFT | Stock | 212.0 | 212.0 | 210.71 | 211.05 | 1291885.0 |
| 2020-12-11 11:00:00 | MSFT | Stock | 211.07 | 211.77 | 210.69 | 210.71 | 956972.0 |
| 2020-12-11 11:30:00 | MSFT | Stock | 210.71 | 210.89 | 210.23 | 210.87 | 1123080.0 |
| 2020-12-11 12:00:00 | MSFT | Stock | 210.87 | 211.76 | 210.84 | 211.255 | 1257138.0 |
| 2020-12-11 12:30:00 | MSFT | Stock | 211.25 | 211.578 | 210.92 | 211.545 | 860387.0 |
> showing 50 of 107,955 rows — these rows as CSV