PREVIEW / stock_30min / 2021-01-15
file: by_date/stock_30min/2021/2021-01-15.parquet size: 2.3 MB rows: 114,738 symbols: 2,707
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-15 04:00:00 | AAPL | Stock | 129.22 | 129.22 | 128.83 | 129.0 | 13749.0 |
| 2021-01-15 04:30:00 | AAPL | Stock | 128.97 | 129.03 | 128.8 | 128.8 | 3200.0 |
| 2021-01-15 05:00:00 | AAPL | Stock | 128.72 | 128.99 | 128.72 | 128.79 | 8706.0 |
| 2021-01-15 05:30:00 | AAPL | Stock | 129.04 | 129.04 | 128.82 | 128.84 | 8528.0 |
| 2021-01-15 06:00:00 | AAPL | Stock | 128.82 | 129.0 | 128.7 | 128.8 | 13754.0 |
| 2021-01-15 06:30:00 | AAPL | Stock | 128.73 | 128.84 | 128.63 | 128.84 | 14832.0 |
| 2021-01-15 07:00:00 | AAPL | Stock | 128.86 | 129.17 | 128.77 | 129.12 | 68786.0 |
| 2021-01-15 07:30:00 | AAPL | Stock | 129.16 | 129.26 | 128.94 | 129.06 | 70040.0 |
| 2021-01-15 08:00:00 | AAPL | Stock | 129.12 | 129.25 | 128.75 | 129.04 | 199608.0 |
| 2021-01-15 08:30:00 | AAPL | Stock | 129.02 | 129.11 | 128.95 | 129.01 | 134240.0 |
| 2021-01-15 09:00:00 | AAPL | Stock | 129.01 | 129.5 | 128.65 | 128.68 | 504819.0 |
| 2021-01-15 09:30:00 | AAPL | Stock | 128.68 | 130.224 | 128.63 | 129.15 | 16416627.0 |
| 2021-01-15 10:00:00 | AAPL | Stock | 129.154 | 129.16 | 127.5 | 128.27 | 9437867.0 |
| 2021-01-15 10:30:00 | AAPL | Stock | 128.26 | 128.45 | 127.93 | 128.225 | 5069182.0 |
| 2021-01-15 11:00:00 | AAPL | Stock | 128.23 | 129.32 | 127.592 | 129.3 | 6535029.0 |
| 2021-01-15 11:30:00 | AAPL | Stock | 129.29 | 129.35 | 128.72 | 128.75 | 4992498.0 |
| 2021-01-15 12:00:00 | AAPL | Stock | 128.755 | 128.8 | 128.25 | 128.26 | 4243327.0 |
| 2021-01-15 12:30:00 | AAPL | Stock | 128.261 | 128.71 | 128.19 | 128.485 | 3294958.0 |
| 2021-01-15 13:00:00 | AAPL | Stock | 128.48 | 128.93 | 128.27 | 128.65 | 3170019.0 |
| 2021-01-15 13:30:00 | AAPL | Stock | 128.659 | 128.789 | 128.441 | 128.492 | 2376912.0 |
| 2021-01-15 14:00:00 | AAPL | Stock | 128.5 | 128.73 | 128.0 | 128.06 | 3030749.0 |
| 2021-01-15 14:30:00 | AAPL | Stock | 128.06 | 128.11 | 127.65 | 127.728 | 4185969.0 |
| 2021-01-15 15:00:00 | AAPL | Stock | 127.74 | 127.97 | 127.49 | 127.56 | 5067824.0 |
| 2021-01-15 15:30:00 | AAPL | Stock | 127.56 | 127.61 | 127.0 | 127.07 | 9760777.0 |
| 2021-01-15 16:00:00 | AAPL | Stock | 127.14 | 128.48 | 126.91 | 127.0 | 11964805.0 |
| 2021-01-15 16:30:00 | AAPL | Stock | 127.0 | 127.14 | 126.9 | 126.92 | 98538.0 |
| 2021-01-15 17:00:00 | AAPL | Stock | 126.92 | 127.06 | 126.9 | 127.06 | 48387.0 |
| 2021-01-15 17:30:00 | AAPL | Stock | 127.02 | 127.18 | 127.02 | 127.12 | 86464.0 |
| 2021-01-15 18:00:00 | AAPL | Stock | 127.12 | 127.15 | 127.09 | 127.12 | 50869.0 |
| 2021-01-15 18:30:00 | AAPL | Stock | 127.12 | 127.14 | 127.01 | 127.06 | 25813.0 |
| 2021-01-15 19:00:00 | AAPL | Stock | 127.06 | 127.14 | 127.0 | 127.09 | 26396.0 |
| 2021-01-15 19:30:00 | AAPL | Stock | 127.07 | 127.1 | 126.8 | 126.82 | 97034.0 |
| 2021-01-15 04:00:00 | MSFT | Stock | 213.52 | 213.52 | 213.25 | 213.5 | 10834.0 |
| 2021-01-15 04:30:00 | MSFT | Stock | 213.6 | 213.6 | 213.4 | 213.4 | 9202.0 |
| 2021-01-15 05:00:00 | MSFT | Stock | 213.4 | 213.4 | 213.11 | 213.4 | 3966.0 |
| 2021-01-15 05:30:00 | MSFT | Stock | 213.5 | 213.5 | 213.16 | 213.16 | 2189.0 |
| 2021-01-15 06:00:00 | MSFT | Stock | 213.16 | 213.78 | 212.9 | 213.29 | 6740.0 |
| 2021-01-15 06:30:00 | MSFT | Stock | 213.3 | 213.4 | 212.83 | 213.4 | 2691.0 |
| 2021-01-15 07:00:00 | MSFT | Stock | 213.11 | 213.71 | 213.11 | 213.71 | 7069.0 |
| 2021-01-15 07:30:00 | MSFT | Stock | 213.7 | 213.86 | 213.2 | 213.71 | 14488.0 |
| 2021-01-15 08:00:00 | MSFT | Stock | 213.677 | 213.88 | 212.49 | 213.41 | 15940.0 |
| 2021-01-15 08:30:00 | MSFT | Stock | 213.45 | 213.7 | 213.43 | 213.7 | 22587.0 |
| 2021-01-15 09:00:00 | MSFT | Stock | 213.71 | 214.25 | 213.2 | 213.52 | 116709.0 |
| 2021-01-15 09:30:00 | MSFT | Stock | 213.52 | 214.51 | 212.95 | 213.635 | 4905669.0 |
| 2021-01-15 10:00:00 | MSFT | Stock | 213.655 | 214.03 | 212.03 | 212.38 | 1914206.0 |
| 2021-01-15 10:30:00 | MSFT | Stock | 212.38 | 214.01 | 212.16 | 213.2 | 1433361.0 |
| 2021-01-15 11:00:00 | MSFT | Stock | 213.22 | 214.029 | 212.24 | 213.85 | 1175638.0 |
| 2021-01-15 11:30:00 | MSFT | Stock | 213.85 | 214.22 | 213.52 | 213.771 | 1051731.0 |
| 2021-01-15 12:00:00 | MSFT | Stock | 213.76 | 213.98 | 213.09 | 213.1 | 838857.0 |
| 2021-01-15 12:30:00 | MSFT | Stock | 213.09 | 213.39 | 212.94 | 213.15 | 772601.0 |
> showing 50 of 114,738 rows — these rows as CSV