PREVIEW / stock_30min / 2021-08-31
file: by_date/stock_30min/2021/2021-08-31.parquet size: 2.2 MB rows: 110,181 symbols: 2,773
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-08-31 04:00:00 | AAPL | Stock | 153.28 | 153.64 | 153.15 | 153.6 | 16019.0 |
| 2021-08-31 04:30:00 | AAPL | Stock | 153.61 | 153.7 | 153.4 | 153.44 | 21472.0 |
| 2021-08-31 05:00:00 | AAPL | Stock | 153.5 | 153.52 | 153.13 | 153.37 | 9619.0 |
| 2021-08-31 05:30:00 | AAPL | Stock | 153.35 | 153.35 | 153.07 | 153.07 | 12555.0 |
| 2021-08-31 06:00:00 | AAPL | Stock | 153.06 | 153.14 | 152.68 | 152.78 | 22738.0 |
| 2021-08-31 06:30:00 | AAPL | Stock | 152.78 | 152.9 | 152.57 | 152.65 | 24792.0 |
| 2021-08-31 07:00:00 | AAPL | Stock | 152.71 | 152.9 | 152.56 | 152.8 | 150221.0 |
| 2021-08-31 07:30:00 | AAPL | Stock | 152.79 | 152.82 | 152.62 | 152.71 | 85148.0 |
| 2021-08-31 08:00:00 | AAPL | Stock | 152.8 | 152.89 | 152.38 | 152.43 | 224343.0 |
| 2021-08-31 08:30:00 | AAPL | Stock | 152.42 | 152.64 | 152.25 | 152.64 | 138377.0 |
| 2021-08-31 09:00:00 | AAPL | Stock | 152.63 | 152.93 | 152.36 | 152.69 | 238759.0 |
| 2021-08-31 09:30:00 | AAPL | Stock | 152.68 | 152.73 | 151.492 | 151.525 | 11437473.0 |
| 2021-08-31 10:00:00 | AAPL | Stock | 151.52 | 152.0 | 151.29 | 151.4611 | 6151805.0 |
| 2021-08-31 10:30:00 | AAPL | Stock | 151.46 | 152.01 | 151.4 | 151.58 | 4610025.0 |
| 2021-08-31 11:00:00 | AAPL | Stock | 151.59 | 152.1 | 151.56 | 151.8799 | 3402791.0 |
| 2021-08-31 11:30:00 | AAPL | Stock | 151.87 | 152.31 | 151.76 | 152.115 | 3876024.0 |
| 2021-08-31 12:00:00 | AAPL | Stock | 152.12 | 152.71 | 151.9824 | 152.675 | 3923078.0 |
| 2021-08-31 12:30:00 | AAPL | Stock | 152.67 | 152.8 | 152.5 | 152.665 | 2782287.0 |
| 2021-08-31 13:00:00 | AAPL | Stock | 152.6684 | 152.74 | 152.06 | 152.11 | 2783516.0 |
| 2021-08-31 13:30:00 | AAPL | Stock | 152.12 | 152.415 | 152.1001 | 152.355 | 1919420.0 |
| 2021-08-31 14:00:00 | AAPL | Stock | 152.36 | 152.5 | 152.19 | 152.4664 | 1841766.0 |
| 2021-08-31 14:30:00 | AAPL | Stock | 152.47 | 152.57 | 152.2 | 152.365 | 2521563.0 |
| 2021-08-31 15:00:00 | AAPL | Stock | 152.365 | 152.41 | 151.95 | 151.955 | 3256722.0 |
| 2021-08-31 15:30:00 | AAPL | Stock | 151.96 | 152.46 | 151.55 | 151.83 | 9235678.0 |
| 2021-08-31 16:00:00 | AAPL | Stock | 152.02 | 152.02 | 151.76 | 151.89 | 16044812.0 |
| 2021-08-31 16:30:00 | AAPL | Stock | 151.95 | 151.95 | 151.811 | 151.86 | 123749.0 |
| 2021-08-31 17:00:00 | AAPL | Stock | 151.85 | 151.87 | 151.85 | 151.85 | 9654.0 |
| 2021-08-31 17:30:00 | AAPL | Stock | 151.85 | 151.92 | 151.85 | 151.92 | 24275.0 |
| 2021-08-31 18:00:00 | AAPL | Stock | 151.92 | 151.92 | 151.89 | 151.89 | 8954.0 |
| 2021-08-31 18:30:00 | AAPL | Stock | 151.9 | 151.91 | 151.86 | 151.87 | 19279.0 |
| 2021-08-31 19:00:00 | AAPL | Stock | 151.87 | 151.87 | 151.82 | 151.82 | 13371.0 |
| 2021-08-31 19:30:00 | AAPL | Stock | 151.82 | 151.91 | 151.8 | 151.91 | 38233.0 |
| 2021-08-31 04:00:00 | MSFT | Stock | 304.72 | 305.2 | 304.72 | 305.06 | 4023.0 |
| 2021-08-31 04:30:00 | MSFT | Stock | 304.98 | 305.0 | 304.9 | 304.9 | 2872.0 |
| 2021-08-31 05:00:00 | MSFT | Stock | 304.89 | 304.89 | 304.8 | 304.8 | 507.0 |
| 2021-08-31 05:30:00 | MSFT | Stock | 304.7 | 304.8 | 304.39 | 304.39 | 3037.0 |
| 2021-08-31 06:00:00 | MSFT | Stock | 304.34 | 304.43 | 304.22 | 304.35 | 2497.0 |
| 2021-08-31 06:30:00 | MSFT | Stock | 304.32 | 304.34 | 303.2 | 303.59 | 8989.0 |
| 2021-08-31 07:00:00 | MSFT | Stock | 303.55 | 304.4 | 303.45 | 304.06 | 14445.0 |
| 2021-08-31 07:30:00 | MSFT | Stock | 304.1 | 304.22 | 303.8 | 303.82 | 6648.0 |
| 2021-08-31 08:00:00 | MSFT | Stock | 304.0 | 304.348 | 303.19 | 303.33 | 15832.0 |
| 2021-08-31 08:30:00 | MSFT | Stock | 303.207 | 303.8 | 303.1 | 303.8 | 5523.0 |
| 2021-08-31 09:00:00 | MSFT | Stock | 303.8 | 304.94 | 303.65 | 304.5 | 40070.0 |
| 2021-08-31 09:30:00 | MSFT | Stock | 304.34 | 304.5 | 302.3345 | 302.73 | 1825930.0 |
| 2021-08-31 10:00:00 | MSFT | Stock | 302.705 | 303.7668 | 302.445 | 303.03 | 907277.0 |
| 2021-08-31 10:30:00 | MSFT | Stock | 303.035 | 303.31 | 302.49 | 303.06 | 531917.0 |
| 2021-08-31 11:00:00 | MSFT | Stock | 303.07 | 303.99 | 302.76 | 303.833 | 670778.0 |
| 2021-08-31 11:30:00 | MSFT | Stock | 303.85 | 304.37 | 303.7 | 303.77 | 517073.0 |
| 2021-08-31 12:00:00 | MSFT | Stock | 303.77 | 303.85 | 303.46 | 303.78 | 425121.0 |
| 2021-08-31 12:30:00 | MSFT | Stock | 303.79 | 304.05 | 303.485 | 303.61 | 481473.0 |
> showing 50 of 110,181 rows — these rows as CSV