PREVIEW / stock_30min / 2021-05-03
file: by_date/stock_30min/2021/2021-05-03.parquet size: 2.2 MB rows: 112,921 symbols: 3,005
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-05-03 04:00:00 | AAPL | Stock | 131.9 | 132.3 | 131.84 | 132.06 | 39249.0 |
| 2021-05-03 04:30:00 | AAPL | Stock | 132.02 | 132.11 | 131.75 | 131.86 | 9570.0 |
| 2021-05-03 05:00:00 | AAPL | Stock | 131.85 | 131.97 | 131.71 | 131.71 | 7362.0 |
| 2021-05-03 05:30:00 | AAPL | Stock | 131.61 | 131.7 | 131.5 | 131.65 | 9820.0 |
| 2021-05-03 06:00:00 | AAPL | Stock | 131.68 | 131.85 | 131.68 | 131.83 | 2431.0 |
| 2021-05-03 06:30:00 | AAPL | Stock | 131.85 | 132.13 | 131.67 | 131.67 | 21761.0 |
| 2021-05-03 07:00:00 | AAPL | Stock | 131.74 | 132.16 | 131.66 | 132.1 | 98997.0 |
| 2021-05-03 07:30:00 | AAPL | Stock | 132.07 | 132.23 | 131.94 | 132.04 | 101949.0 |
| 2021-05-03 08:00:00 | AAPL | Stock | 131.85 | 132.11 | 131.82 | 132.0 | 291508.0 |
| 2021-05-03 08:30:00 | AAPL | Stock | 132.0 | 132.19 | 131.98 | 132.16 | 123642.0 |
| 2021-05-03 09:00:00 | AAPL | Stock | 132.16 | 132.18 | 131.97 | 132.01 | 146381.0 |
| 2021-05-03 09:30:00 | AAPL | Stock | 132.01 | 133.355 | 131.83 | 133.2054 | 9930324.0 |
| 2021-05-03 10:00:00 | AAPL | Stock | 133.2 | 134.07 | 132.99 | 133.835 | 8114871.0 |
| 2021-05-03 10:30:00 | AAPL | Stock | 133.84 | 134.05 | 132.63 | 132.77 | 7144961.0 |
| 2021-05-03 11:00:00 | AAPL | Stock | 132.775 | 132.9599 | 132.14 | 132.305 | 5347907.0 |
| 2021-05-03 11:30:00 | AAPL | Stock | 132.3 | 132.85 | 132.25 | 132.815 | 3682008.0 |
| 2021-05-03 12:00:00 | AAPL | Stock | 132.815 | 132.92 | 132.5201 | 132.5545 | 2941453.0 |
| 2021-05-03 12:30:00 | AAPL | Stock | 132.55 | 132.675 | 132.31 | 132.45 | 2666084.0 |
| 2021-05-03 13:00:00 | AAPL | Stock | 132.45 | 132.61 | 132.21 | 132.25 | 3100137.0 |
| 2021-05-03 13:30:00 | AAPL | Stock | 132.24 | 132.61 | 132.22 | 132.4612 | 2556502.0 |
| 2021-05-03 14:00:00 | AAPL | Stock | 132.46 | 132.887 | 132.4501 | 132.765 | 3257427.0 |
| 2021-05-03 14:30:00 | AAPL | Stock | 132.77 | 132.96 | 132.72 | 132.835 | 2540431.0 |
| 2021-05-03 15:00:00 | AAPL | Stock | 132.84 | 132.98 | 132.625 | 132.6399 | 2843517.0 |
| 2021-05-03 15:30:00 | AAPL | Stock | 132.635 | 132.79 | 132.3949 | 132.55 | 5720254.0 |
| 2021-05-03 16:00:00 | AAPL | Stock | 132.54 | 132.54 | 132.35 | 132.44 | 5386527.0 |
| 2021-05-03 16:30:00 | AAPL | Stock | 132.45 | 132.45 | 132.35 | 132.42 | 45804.0 |
| 2021-05-03 17:00:00 | AAPL | Stock | 132.42 | 132.43 | 132.33 | 132.35 | 39621.0 |
| 2021-05-03 17:30:00 | AAPL | Stock | 132.35 | 132.36 | 132.3 | 132.33 | 22029.0 |
| 2021-05-03 18:00:00 | AAPL | Stock | 132.35 | 132.4 | 132.35 | 132.39 | 18239.0 |
| 2021-05-03 18:30:00 | AAPL | Stock | 132.39 | 132.39 | 132.33 | 132.37 | 16300.0 |
| 2021-05-03 19:00:00 | AAPL | Stock | 132.32 | 132.3499 | 132.26 | 132.26 | 8353.0 |
| 2021-05-03 19:30:00 | AAPL | Stock | 132.2601 | 132.35 | 132.25 | 132.33 | 44851.0 |
| 2021-05-03 04:00:00 | MSFT | Stock | 253.02 | 253.1 | 252.7 | 252.7 | 1891.0 |
| 2021-05-03 04:30:00 | MSFT | Stock | 252.54 | 252.93 | 252.4 | 252.48 | 2172.0 |
| 2021-05-03 05:00:00 | MSFT | Stock | 252.44 | 252.6 | 252.2 | 252.2 | 2046.0 |
| 2021-05-03 06:00:00 | MSFT | Stock | 252.68 | 252.68 | 252.68 | 252.68 | 164.0 |
| 2021-05-03 06:30:00 | MSFT | Stock | 252.97 | 253.1 | 252.89 | 253.0 | 2914.0 |
| 2021-05-03 07:00:00 | MSFT | Stock | 252.97 | 253.01 | 252.53 | 252.9 | 7902.0 |
| 2021-05-03 07:30:00 | MSFT | Stock | 252.89 | 252.89 | 252.6 | 252.79 | 4760.0 |
| 2021-05-03 08:00:00 | MSFT | Stock | 252.75 | 253.0 | 252.5281 | 252.88 | 17044.0 |
| 2021-05-03 08:30:00 | MSFT | Stock | 252.9 | 253.06 | 252.7 | 252.81 | 17758.0 |
| 2021-05-03 09:00:00 | MSFT | Stock | 252.88 | 253.34 | 252.82 | 253.32 | 20206.0 |
| 2021-05-03 09:30:00 | MSFT | Stock | 253.39 | 253.69 | 251.8 | 253.18 | 1871192.0 |
| 2021-05-03 10:00:00 | MSFT | Stock | 253.18 | 254.25 | 252.67 | 253.7399 | 1691933.0 |
| 2021-05-03 10:30:00 | MSFT | Stock | 253.74 | 254.35 | 252.57 | 252.69 | 1188210.0 |
| 2021-05-03 11:00:00 | MSFT | Stock | 252.685 | 252.8922 | 251.8 | 252.15 | 1029508.0 |
| 2021-05-03 11:30:00 | MSFT | Stock | 252.13 | 252.81 | 252.0 | 252.69 | 644444.0 |
| 2021-05-03 12:00:00 | MSFT | Stock | 252.68 | 252.7 | 251.9 | 251.92 | 648013.0 |
| 2021-05-03 12:30:00 | MSFT | Stock | 251.91 | 252.14 | 251.83 | 252.04 | 463843.0 |
| 2021-05-03 13:00:00 | MSFT | Stock | 252.07 | 252.34 | 251.2037 | 251.2037 | 682582.0 |
> showing 50 of 112,921 rows — these rows as CSV