PREVIEW / stock_30min / 2021-05-17
file: by_date/stock_30min/2021/2021-05-17.parquet size: 2.2 MB rows: 109,735 symbols: 2,979
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-17 04:00:00 | AAPL | Stock | 126.96 | 127.0 | 126.81 | 126.92 | 6120.0 |
| 2021-05-17 04:30:00 | AAPL | Stock | 127.0 | 127.23 | 127.0 | 127.16 | 3060.0 |
| 2021-05-17 05:00:00 | AAPL | Stock | 127.1 | 127.14 | 127.02 | 127.1 | 9053.0 |
| 2021-05-17 05:30:00 | AAPL | Stock | 127.11 | 127.11 | 126.95 | 127.0 | 5006.0 |
| 2021-05-17 06:00:00 | AAPL | Stock | 126.93 | 126.95 | 126.69 | 126.69 | 3568.0 |
| 2021-05-17 06:30:00 | AAPL | Stock | 126.8 | 126.83 | 126.75 | 126.75 | 2413.0 |
| 2021-05-17 07:00:00 | AAPL | Stock | 126.84 | 126.9 | 126.67 | 126.82 | 94928.0 |
| 2021-05-17 07:30:00 | AAPL | Stock | 126.82 | 126.84 | 126.65 | 126.73 | 83093.0 |
| 2021-05-17 08:00:00 | AAPL | Stock | 126.74 | 126.9 | 126.65 | 126.75 | 146653.0 |
| 2021-05-17 08:30:00 | AAPL | Stock | 126.73 | 127.45 | 126.73 | 126.91 | 1361728.0 |
| 2021-05-17 09:00:00 | AAPL | Stock | 126.89 | 127.25 | 126.69 | 126.85 | 223557.0 |
| 2021-05-17 09:30:00 | AAPL | Stock | 126.82 | 126.93 | 126.01 | 126.0301 | 9190070.0 |
| 2021-05-17 10:00:00 | AAPL | Stock | 126.04 | 126.26 | 125.46 | 125.9 | 6632292.0 |
| 2021-05-17 10:30:00 | AAPL | Stock | 125.9 | 126.41 | 125.71 | 125.99 | 4575346.0 |
| 2021-05-17 11:00:00 | AAPL | Stock | 125.98 | 126.13 | 125.635 | 125.89 | 3488278.0 |
| 2021-05-17 11:30:00 | AAPL | Stock | 125.89 | 125.98 | 125.61 | 125.695 | 2931444.0 |
| 2021-05-17 12:00:00 | AAPL | Stock | 125.6999 | 125.84 | 125.47 | 125.7386 | 3478804.0 |
| 2021-05-17 12:30:00 | AAPL | Stock | 125.7355 | 125.9 | 125.5801 | 125.59 | 2199756.0 |
| 2021-05-17 13:00:00 | AAPL | Stock | 125.59 | 125.705 | 125.31 | 125.3986 | 2933039.0 |
| 2021-05-17 13:30:00 | AAPL | Stock | 125.4 | 125.59 | 125.17 | 125.4001 | 2902102.0 |
| 2021-05-17 14:00:00 | AAPL | Stock | 125.4069 | 125.55 | 125.3301 | 125.43 | 2438974.0 |
| 2021-05-17 14:30:00 | AAPL | Stock | 125.42 | 125.6199 | 125.23 | 125.595 | 3047365.0 |
| 2021-05-17 15:00:00 | AAPL | Stock | 125.59 | 125.8199 | 125.4721 | 125.521 | 3160415.0 |
| 2021-05-17 15:30:00 | AAPL | Stock | 125.53 | 126.27 | 125.41 | 126.27 | 7318180.0 |
| 2021-05-17 16:00:00 | AAPL | Stock | 126.24 | 126.27 | 126.12 | 126.18 | 10683181.0 |
| 2021-05-17 16:30:00 | AAPL | Stock | 126.15 | 126.25 | 126.01 | 126.14 | 40953.0 |
| 2021-05-17 17:00:00 | AAPL | Stock | 126.18 | 126.2 | 126.07 | 126.1 | 17585.0 |
| 2021-05-17 17:30:00 | AAPL | Stock | 126.09 | 126.19 | 126.08 | 126.16 | 33456.0 |
| 2021-05-17 18:00:00 | AAPL | Stock | 126.19 | 126.2 | 126.11 | 126.12 | 19948.0 |
| 2021-05-17 18:30:00 | AAPL | Stock | 126.15 | 126.15 | 126.08 | 126.12 | 7559.0 |
| 2021-05-17 19:00:00 | AAPL | Stock | 126.09 | 126.18 | 126.07 | 126.18 | 11274.0 |
| 2021-05-17 19:30:00 | AAPL | Stock | 126.14 | 126.31 | 126.14 | 126.3 | 38805.0 |
| 2021-05-17 04:00:00 | MSFT | Stock | 248.0 | 248.39 | 248.0 | 248.3 | 1740.0 |
| 2021-05-17 05:00:00 | MSFT | Stock | 248.6 | 248.6 | 248.25 | 248.5 | 518.0 |
| 2021-05-17 05:30:00 | MSFT | Stock | 248.4 | 248.4 | 247.85 | 247.85 | 3535.0 |
| 2021-05-17 06:00:00 | MSFT | Stock | 247.72 | 247.72 | 247.5 | 247.5 | 1209.0 |
| 2021-05-17 06:30:00 | MSFT | Stock | 247.5 | 247.74 | 247.5 | 247.51 | 1812.0 |
| 2021-05-17 07:00:00 | MSFT | Stock | 247.67 | 247.74 | 247.2 | 247.4 | 9960.0 |
| 2021-05-17 07:30:00 | MSFT | Stock | 247.4 | 247.5 | 246.85 | 246.99 | 9670.0 |
| 2021-05-17 08:00:00 | MSFT | Stock | 247.5 | 247.89 | 246.6 | 246.91 | 16066.0 |
| 2021-05-17 08:30:00 | MSFT | Stock | 247.0 | 248.15 | 246.91 | 247.03 | 149612.0 |
| 2021-05-17 09:00:00 | MSFT | Stock | 247.01 | 247.3 | 246.42 | 246.52 | 11333.0 |
| 2021-05-17 09:30:00 | MSFT | Stock | 246.6 | 246.6 | 245.0 | 245.53 | 1940946.0 |
| 2021-05-17 10:00:00 | MSFT | Stock | 245.45 | 245.5599 | 244.04 | 245.12 | 1340685.0 |
| 2021-05-17 10:30:00 | MSFT | Stock | 245.11 | 245.66 | 244.65 | 245.14 | 1161336.0 |
| 2021-05-17 11:00:00 | MSFT | Stock | 245.13 | 245.5359 | 244.422 | 244.54 | 930315.0 |
| 2021-05-17 11:30:00 | MSFT | Stock | 244.56 | 244.6899 | 244.04 | 244.35 | 862966.0 |
| 2021-05-17 12:00:00 | MSFT | Stock | 244.35 | 244.72 | 244.16 | 244.3 | 673205.0 |
| 2021-05-17 12:30:00 | MSFT | Stock | 244.3 | 244.98 | 244.17 | 244.39 | 562646.0 |
| 2021-05-17 13:00:00 | MSFT | Stock | 244.37 | 244.52 | 243.68 | 244.0391 | 769808.0 |
> showing 50 of 109,735 rows — these rows as CSV