PREVIEW / stock_30min / 2021-03-02
file: by_date/stock_30min/2021/2021-03-02.parquet size: 2.3 MB rows: 116,981 symbols: 2,841
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-02 04:00:00 | AAPL | Stock | 126.95 | 127.13 | 126.58 | 127.07 | 34640.0 |
| 2021-03-02 04:30:00 | AAPL | Stock | 127.17 | 127.46 | 127.17 | 127.35 | 24175.0 |
| 2021-03-02 05:00:00 | AAPL | Stock | 127.28 | 127.51 | 127.13 | 127.5 | 9924.0 |
| 2021-03-02 05:30:00 | AAPL | Stock | 127.5 | 127.92 | 127.4 | 127.55 | 19562.0 |
| 2021-03-02 06:00:00 | AAPL | Stock | 127.43 | 127.81 | 127.35 | 127.79 | 18408.0 |
| 2021-03-02 06:30:00 | AAPL | Stock | 127.74 | 127.75 | 127.3 | 127.7 | 11893.0 |
| 2021-03-02 07:00:00 | AAPL | Stock | 127.59 | 128.3 | 127.55 | 128.15 | 221192.0 |
| 2021-03-02 07:30:00 | AAPL | Stock | 128.17 | 128.31 | 128.01 | 128.22 | 75989.0 |
| 2021-03-02 08:00:00 | AAPL | Stock | 127.8501 | 128.4 | 127.61 | 127.97 | 356066.0 |
| 2021-03-02 08:30:00 | AAPL | Stock | 127.99 | 128.08 | 127.63 | 127.95 | 243340.0 |
| 2021-03-02 09:00:00 | AAPL | Stock | 127.97 | 128.6 | 127.8 | 128.4 | 306410.0 |
| 2021-03-02 09:30:00 | AAPL | Stock | 128.4 | 128.72 | 126.19 | 126.73 | 14626764.0 |
| 2021-03-02 10:00:00 | AAPL | Stock | 126.735 | 127.1984 | 125.98 | 126.0699 | 7835258.0 |
| 2021-03-02 10:30:00 | AAPL | Stock | 126.06 | 126.43 | 125.73 | 126.13 | 6420645.0 |
| 2021-03-02 11:00:00 | AAPL | Stock | 126.13 | 126.45 | 125.5 | 125.96 | 5843625.0 |
| 2021-03-02 11:30:00 | AAPL | Stock | 125.96 | 126.04 | 125.46 | 125.82 | 4982969.0 |
| 2021-03-02 12:00:00 | AAPL | Stock | 125.815 | 126.25 | 125.72 | 126.0897 | 4484727.0 |
| 2021-03-02 12:30:00 | AAPL | Stock | 126.09 | 126.68 | 126.07 | 126.17 | 3846383.0 |
| 2021-03-02 13:00:00 | AAPL | Stock | 126.17 | 126.42 | 125.995 | 126.13 | 3071124.0 |
| 2021-03-02 13:30:00 | AAPL | Stock | 126.13 | 126.38 | 125.95 | 125.98 | 3272625.0 |
| 2021-03-02 14:00:00 | AAPL | Stock | 125.98 | 126.17 | 125.58 | 125.65 | 4112482.0 |
| 2021-03-02 14:30:00 | AAPL | Stock | 125.65 | 126.2002 | 125.58 | 126.015 | 3534313.0 |
| 2021-03-02 15:00:00 | AAPL | Stock | 126.02 | 126.3144 | 125.48 | 125.59 | 4651420.0 |
| 2021-03-02 15:30:00 | AAPL | Stock | 125.5984 | 125.99 | 125.01 | 125.1601 | 10314292.0 |
| 2021-03-02 16:00:00 | AAPL | Stock | 125.165 | 125.29 | 125.01 | 125.17 | 7850635.0 |
| 2021-03-02 16:30:00 | AAPL | Stock | 125.16 | 125.26 | 125.1 | 125.12 | 87742.0 |
| 2021-03-02 17:00:00 | AAPL | Stock | 125.1001 | 125.13 | 125.0 | 125.05 | 86387.0 |
| 2021-03-02 17:30:00 | AAPL | Stock | 125.04 | 125.12 | 125.0 | 125.03 | 88512.0 |
| 2021-03-02 18:00:00 | AAPL | Stock | 125.01 | 125.24 | 125.0 | 125.23 | 73718.0 |
| 2021-03-02 18:30:00 | AAPL | Stock | 125.23 | 125.35 | 125.23 | 125.3 | 58286.0 |
| 2021-03-02 19:00:00 | AAPL | Stock | 125.27 | 125.45 | 125.22 | 125.45 | 46255.0 |
| 2021-03-02 19:30:00 | AAPL | Stock | 125.45 | 125.62 | 125.43 | 125.59 | 79021.0 |
| 2021-03-02 04:00:00 | MSFT | Stock | 235.75 | 235.75 | 235.06 | 235.31 | 2402.0 |
| 2021-03-02 04:30:00 | MSFT | Stock | 235.4 | 235.88 | 235.4 | 235.58 | 3510.0 |
| 2021-03-02 05:00:00 | MSFT | Stock | 235.52 | 235.88 | 235.52 | 235.88 | 242.0 |
| 2021-03-02 06:00:00 | MSFT | Stock | 236.25 | 236.4 | 236.22 | 236.22 | 2643.0 |
| 2021-03-02 06:30:00 | MSFT | Stock | 236.2 | 236.45 | 236.2 | 236.23 | 520.0 |
| 2021-03-02 07:00:00 | MSFT | Stock | 236.19 | 236.47 | 235.88 | 236.3 | 11483.0 |
| 2021-03-02 07:30:00 | MSFT | Stock | 236.12 | 236.87 | 236.05 | 236.53 | 8954.0 |
| 2021-03-02 08:00:00 | MSFT | Stock | 236.42 | 236.69 | 236.0 | 236.54 | 12208.0 |
| 2021-03-02 08:30:00 | MSFT | Stock | 236.42 | 236.5 | 236.0 | 236.25 | 6191.0 |
| 2021-03-02 09:00:00 | MSFT | Stock | 236.2643 | 237.48 | 236.2643 | 237.04 | 22128.0 |
| 2021-03-02 09:30:00 | MSFT | Stock | 236.99 | 237.3 | 234.14 | 234.875 | 2597029.0 |
| 2021-03-02 10:00:00 | MSFT | Stock | 234.89 | 235.9 | 233.9 | 233.99 | 1456407.0 |
| 2021-03-02 10:30:00 | MSFT | Stock | 233.98 | 234.65 | 233.6 | 234.36 | 934933.0 |
| 2021-03-02 11:00:00 | MSFT | Stock | 234.31 | 234.58 | 233.45 | 234.34 | 1059566.0 |
| 2021-03-02 11:30:00 | MSFT | Stock | 234.33 | 234.51 | 233.51 | 234.24 | 856877.0 |
| 2021-03-02 12:00:00 | MSFT | Stock | 234.18 | 234.76 | 233.97 | 234.66 | 665194.0 |
| 2021-03-02 12:30:00 | MSFT | Stock | 234.68 | 235.23 | 234.53 | 234.81 | 480490.0 |
| 2021-03-02 13:00:00 | MSFT | Stock | 234.82 | 235.49 | 234.7743 | 235.235 | 479278.0 |
> showing 50 of 116,981 rows — these rows as CSV