PREVIEW / stock_30min / 2021-09-02
file: by_date/stock_30min/2021/2021-09-02.parquet size: 2.2 MB rows: 109,140 symbols: 2,734
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-09-02 04:00:00 | AAPL | Stock | 152.86 | 153.31 | 152.86 | 153.0 | 19208.0 |
| 2021-09-02 04:30:00 | AAPL | Stock | 153.07 | 153.44 | 153.07 | 153.15 | 13125.0 |
| 2021-09-02 05:00:00 | AAPL | Stock | 153.04 | 153.18 | 153.04 | 153.18 | 660.0 |
| 2021-09-02 05:30:00 | AAPL | Stock | 153.14 | 153.32 | 153.1 | 153.1 | 5397.0 |
| 2021-09-02 06:00:00 | AAPL | Stock | 153.15 | 153.22 | 153.13 | 153.2 | 4141.0 |
| 2021-09-02 06:30:00 | AAPL | Stock | 153.22 | 153.29 | 153.2 | 153.2 | 3341.0 |
| 2021-09-02 07:00:00 | AAPL | Stock | 153.2 | 153.49 | 153.19 | 153.4 | 58857.0 |
| 2021-09-02 07:30:00 | AAPL | Stock | 153.35 | 153.49 | 153.35 | 153.49 | 64556.0 |
| 2021-09-02 08:00:00 | AAPL | Stock | 153.49 | 153.75 | 152.129 | 153.64 | 217961.0 |
| 2021-09-02 08:30:00 | AAPL | Stock | 153.64 | 153.96 | 153.64 | 153.78 | 234379.0 |
| 2021-09-02 09:00:00 | AAPL | Stock | 153.76 | 153.99 | 153.59 | 153.86 | 273661.0 |
| 2021-09-02 09:30:00 | AAPL | Stock | 153.85 | 154.72 | 153.85 | 154.16 | 10746206.0 |
| 2021-09-02 10:00:00 | AAPL | Stock | 154.16 | 154.31 | 153.3609 | 153.665 | 5423182.0 |
| 2021-09-02 10:30:00 | AAPL | Stock | 153.66 | 154.33 | 153.58 | 154.053 | 4272754.0 |
| 2021-09-02 11:00:00 | AAPL | Stock | 154.06 | 154.14 | 153.62 | 153.91 | 3460112.0 |
| 2021-09-02 11:30:00 | AAPL | Stock | 153.9056 | 154.11 | 153.525 | 153.585 | 2907430.0 |
| 2021-09-02 12:00:00 | AAPL | Stock | 153.58 | 153.74 | 153.3 | 153.335 | 2616880.0 |
| 2021-09-02 12:30:00 | AAPL | Stock | 153.33 | 153.47 | 153.02 | 153.305 | 2692324.0 |
| 2021-09-02 13:00:00 | AAPL | Stock | 153.3007 | 153.4688 | 152.82 | 152.8286 | 2849802.0 |
| 2021-09-02 13:30:00 | AAPL | Stock | 152.8201 | 153.02 | 152.53 | 152.6 | 3116354.0 |
| 2021-09-02 14:00:00 | AAPL | Stock | 152.605 | 152.97 | 152.4 | 152.7178 | 3665198.0 |
| 2021-09-02 14:30:00 | AAPL | Stock | 152.72 | 153.54 | 152.67 | 153.47 | 4584754.0 |
| 2021-09-02 15:00:00 | AAPL | Stock | 153.4694 | 153.825 | 153.32 | 153.54 | 5235372.0 |
| 2021-09-02 15:30:00 | AAPL | Stock | 153.5499 | 153.71 | 153.315 | 153.71 | 5533452.0 |
| 2021-09-02 16:00:00 | AAPL | Stock | 153.65 | 153.72 | 153.5 | 153.7 | 5413484.0 |
| 2021-09-02 16:30:00 | AAPL | Stock | 153.7 | 153.77 | 153.6901 | 153.6937 | 22637.0 |
| 2021-09-02 17:00:00 | AAPL | Stock | 153.69 | 153.73 | 153.51 | 153.52 | 32935.0 |
| 2021-09-02 17:30:00 | AAPL | Stock | 153.52 | 153.6 | 153.52 | 153.572 | 11798.0 |
| 2021-09-02 18:00:00 | AAPL | Stock | 153.6 | 153.68 | 153.6 | 153.68 | 9411.0 |
| 2021-09-02 18:30:00 | AAPL | Stock | 153.67 | 153.73 | 153.6 | 153.7 | 17676.0 |
| 2021-09-02 19:00:00 | AAPL | Stock | 153.7 | 153.7 | 153.66 | 153.7 | 6757.0 |
| 2021-09-02 19:30:00 | AAPL | Stock | 153.67 | 153.68 | 153.55 | 153.59 | 19068.0 |
| 2021-09-02 04:00:00 | MSFT | Stock | 302.25 | 302.7 | 302.25 | 302.7 | 2949.0 |
| 2021-09-02 05:30:00 | MSFT | Stock | 302.5 | 302.6 | 302.4 | 302.51 | 1914.0 |
| 2021-09-02 06:00:00 | MSFT | Stock | 302.48 | 302.48 | 302.4 | 302.4 | 1265.0 |
| 2021-09-02 06:30:00 | MSFT | Stock | 302.48 | 302.5 | 302.48 | 302.5 | 750.0 |
| 2021-09-02 07:00:00 | MSFT | Stock | 302.16 | 302.26 | 302.16 | 302.26 | 1136.0 |
| 2021-09-02 07:30:00 | MSFT | Stock | 302.39 | 302.69 | 302.39 | 302.69 | 738.0 |
| 2021-09-02 08:00:00 | MSFT | Stock | 302.4998 | 302.74 | 302.16 | 302.48 | 8953.0 |
| 2021-09-02 08:30:00 | MSFT | Stock | 302.4 | 302.64 | 302.4 | 302.56 | 3890.0 |
| 2021-09-02 09:00:00 | MSFT | Stock | 302.64 | 302.7 | 301.83 | 302.06 | 56592.0 |
| 2021-09-02 09:30:00 | MSFT | Stock | 302.12 | 303.3602 | 302.05 | 302.855 | 1631642.0 |
| 2021-09-02 10:00:00 | MSFT | Stock | 302.81 | 302.98 | 301.86 | 302.2199 | 854903.0 |
| 2021-09-02 10:30:00 | MSFT | Stock | 302.205 | 302.45 | 301.7354 | 301.7401 | 561648.0 |
| 2021-09-02 11:00:00 | MSFT | Stock | 301.75 | 301.85 | 301.08 | 301.4068 | 630917.0 |
| 2021-09-02 11:30:00 | MSFT | Stock | 301.405 | 301.75 | 301.09 | 301.115 | 488641.0 |
| 2021-09-02 12:00:00 | MSFT | Stock | 301.1 | 301.125 | 300.56 | 300.7 | 552430.0 |
| 2021-09-02 12:30:00 | MSFT | Stock | 300.69 | 300.978 | 300.65 | 300.8 | 414067.0 |
| 2021-09-02 13:00:00 | MSFT | Stock | 300.805 | 301.04 | 300.4201 | 300.64 | 552209.0 |
| 2021-09-02 13:30:00 | MSFT | Stock | 300.6316 | 300.84 | 300.41 | 300.56 | 415388.0 |
> showing 50 of 109,140 rows — these rows as CSV