PREVIEW / stock_30min / 2022-02-08
file: by_date/stock_30min/2022/2022-02-08.parquet size: 2.1 MB rows: 106,450 symbols: 2,563
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 |
|---|---|---|---|---|---|---|---|
| 2022-02-08 04:00:00 | AAPL | Stock | 172.16 | 172.35 | 171.98 | 172.32 | 3286.0 |
| 2022-02-08 04:30:00 | AAPL | Stock | 172.1 | 172.23 | 171.82 | 171.85 | 3303.0 |
| 2022-02-08 05:00:00 | AAPL | Stock | 171.82 | 171.95 | 171.66 | 171.95 | 8068.0 |
| 2022-02-08 05:30:00 | AAPL | Stock | 172.2 | 172.4 | 172.16 | 172.2 | 2096.0 |
| 2022-02-08 06:00:00 | AAPL | Stock | 172.1 | 172.2 | 171.7 | 171.81 | 2962.0 |
| 2022-02-08 06:30:00 | AAPL | Stock | 171.89 | 172.05 | 171.44 | 171.69 | 16802.0 |
| 2022-02-08 07:00:00 | AAPL | Stock | 171.7 | 171.85 | 171.37 | 171.55 | 60989.0 |
| 2022-02-08 07:30:00 | AAPL | Stock | 171.62 | 171.85 | 171.5 | 171.8 | 23148.0 |
| 2022-02-08 08:00:00 | AAPL | Stock | 171.7999 | 172.32 | 171.4 | 171.85 | 202346.0 |
| 2022-02-08 08:30:00 | AAPL | Stock | 171.85 | 171.93 | 171.51 | 171.8 | 112313.0 |
| 2022-02-08 09:00:00 | AAPL | Stock | 171.79 | 171.8699 | 171.5 | 171.66 | 116495.0 |
| 2022-02-08 09:30:00 | AAPL | Stock | 171.75 | 172.42 | 171.5 | 172.06 | 6557055.0 |
| 2022-02-08 10:00:00 | AAPL | Stock | 172.06 | 172.41 | 171.43 | 171.9999 | 4270598.0 |
| 2022-02-08 10:30:00 | AAPL | Stock | 172.01 | 172.86 | 171.63 | 172.67 | 3563358.0 |
| 2022-02-08 11:00:00 | AAPL | Stock | 172.675 | 173.68 | 172.67 | 173.66 | 3882901.0 |
| 2022-02-08 11:30:00 | AAPL | Stock | 173.6688 | 174.2 | 173.6524 | 173.875 | 4200615.0 |
| 2022-02-08 12:00:00 | AAPL | Stock | 173.88 | 174.81 | 173.69 | 174.8 | 4655741.0 |
| 2022-02-08 12:30:00 | AAPL | Stock | 174.81 | 175.2779 | 174.58 | 174.65 | 4204775.0 |
| 2022-02-08 13:00:00 | AAPL | Stock | 174.65 | 174.795 | 174.22 | 174.3299 | 2942916.0 |
| 2022-02-08 13:30:00 | AAPL | Stock | 174.3299 | 174.67 | 174.121 | 174.5852 | 3050084.0 |
| 2022-02-08 14:00:00 | AAPL | Stock | 174.585 | 174.81 | 173.965 | 174.06 | 3005896.0 |
| 2022-02-08 14:30:00 | AAPL | Stock | 174.07 | 174.347 | 173.73 | 173.94 | 2962909.0 |
| 2022-02-08 15:00:00 | AAPL | Stock | 173.9416 | 175.0 | 173.635 | 174.35 | 4069137.0 |
| 2022-02-08 15:30:00 | AAPL | Stock | 174.34 | 175.35 | 174.21 | 174.82 | 8230145.0 |
| 2022-02-08 16:00:00 | AAPL | Stock | 174.82 | 175.09 | 174.48 | 174.77 | 6788235.0 |
| 2022-02-08 16:30:00 | AAPL | Stock | 174.8 | 174.83 | 174.7 | 174.75 | 65623.0 |
| 2022-02-08 17:00:00 | AAPL | Stock | 174.75 | 174.89 | 174.73 | 174.73 | 50466.0 |
| 2022-02-08 17:30:00 | AAPL | Stock | 174.76 | 174.86 | 174.74 | 174.76 | 15140.0 |
| 2022-02-08 18:00:00 | AAPL | Stock | 174.8 | 175.34 | 174.78 | 175.34 | 25232.0 |
| 2022-02-08 18:30:00 | AAPL | Stock | 175.28 | 175.35 | 175.12 | 175.22 | 10836.0 |
| 2022-02-08 19:00:00 | AAPL | Stock | 175.25 | 175.25 | 174.8 | 174.9 | 14024.0 |
| 2022-02-08 19:30:00 | AAPL | Stock | 174.9 | 175.17 | 174.9 | 175.17 | 16795.0 |
| 2022-02-08 04:00:00 | MSFT | Stock | 302.78 | 302.78 | 301.99 | 302.21 | 6426.0 |
| 2022-02-08 04:30:00 | MSFT | Stock | 302.21 | 302.62 | 301.03 | 301.37 | 3182.0 |
| 2022-02-08 05:00:00 | MSFT | Stock | 301.03 | 301.51 | 301.03 | 301.2 | 6047.0 |
| 2022-02-08 05:30:00 | MSFT | Stock | 301.8 | 302.36 | 301.72 | 302.15 | 2279.0 |
| 2022-02-08 06:00:00 | MSFT | Stock | 301.92 | 302.09 | 301.05 | 301.11 | 1408.0 |
| 2022-02-08 06:30:00 | MSFT | Stock | 301.64 | 301.75 | 300.74 | 301.01 | 8556.0 |
| 2022-02-08 07:00:00 | MSFT | Stock | 301.4 | 301.4 | 300.05 | 300.55 | 15389.0 |
| 2022-02-08 07:30:00 | MSFT | Stock | 300.61 | 301.39 | 300.4 | 301.39 | 6519.0 |
| 2022-02-08 08:00:00 | MSFT | Stock | 300.2794 | 302.09 | 300.18 | 301.49 | 33205.0 |
| 2022-02-08 08:30:00 | MSFT | Stock | 301.4704 | 301.73 | 300.43 | 301.7 | 25104.0 |
| 2022-02-08 09:00:00 | MSFT | Stock | 301.62 | 301.85 | 301.12 | 301.3 | 28267.0 |
| 2022-02-08 09:30:00 | MSFT | Stock | 301.31 | 303.14 | 300.1 | 300.36 | 2265834.0 |
| 2022-02-08 10:00:00 | MSFT | Stock | 300.38 | 302.4 | 299.95 | 301.21 | 1602794.0 |
| 2022-02-08 10:30:00 | MSFT | Stock | 301.22 | 303.08 | 300.42 | 302.34 | 1235479.0 |
| 2022-02-08 11:00:00 | MSFT | Stock | 302.32 | 304.82 | 302.28 | 304.21 | 1297360.0 |
| 2022-02-08 11:30:00 | MSFT | Stock | 304.23 | 305.1242 | 304.14 | 304.395 | 1160990.0 |
| 2022-02-08 12:00:00 | MSFT | Stock | 304.4 | 304.7 | 303.64 | 304.45 | 799845.0 |
| 2022-02-08 12:30:00 | MSFT | Stock | 304.455 | 305.53 | 304.43 | 304.63 | 701256.0 |
> showing 50 of 106,450 rows — these rows as CSV