PREVIEW / stock_30min / 2021-02-26
file: by_date/stock_30min/2021/2021-02-26.parquet size: 2.4 MB rows: 121,360 symbols: 2,844
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-02-26 04:00:00 | AAPL | Stock | 121.68 | 121.81 | 120.93 | 121.18 | 70622.0 |
| 2021-02-26 04:30:00 | AAPL | Stock | 121.14 | 121.95 | 121.14 | 121.7 | 17911.0 |
| 2021-02-26 05:00:00 | AAPL | Stock | 121.6 | 121.64 | 120.56 | 120.84 | 27833.0 |
| 2021-02-26 05:30:00 | AAPL | Stock | 121.0 | 121.39 | 120.68 | 120.77 | 27068.0 |
| 2021-02-26 06:00:00 | AAPL | Stock | 120.69 | 121.06 | 120.47 | 120.49 | 26561.0 |
| 2021-02-26 06:30:00 | AAPL | Stock | 120.4 | 120.6 | 119.75 | 120.28 | 51690.0 |
| 2021-02-26 07:00:00 | AAPL | Stock | 120.29 | 121.5 | 120.0 | 121.26 | 297035.0 |
| 2021-02-26 07:30:00 | AAPL | Stock | 121.22 | 121.83 | 121.05 | 121.13 | 241219.0 |
| 2021-02-26 08:00:00 | AAPL | Stock | 121.1 | 121.82 | 120.1 | 121.57 | 480382.0 |
| 2021-02-26 08:30:00 | AAPL | Stock | 121.56 | 122.54 | 121.55 | 122.54 | 634702.0 |
| 2021-02-26 09:00:00 | AAPL | Stock | 122.52 | 122.74 | 122.08 | 122.58 | 520311.0 |
| 2021-02-26 09:30:00 | AAPL | Stock | 122.59 | 123.95 | 122.0 | 122.315 | 15731106.0 |
| 2021-02-26 10:00:00 | AAPL | Stock | 122.32 | 122.87 | 121.29 | 121.5 | 12304861.0 |
| 2021-02-26 10:30:00 | AAPL | Stock | 121.47 | 124.12 | 121.4 | 123.847 | 11867448.0 |
| 2021-02-26 11:00:00 | AAPL | Stock | 123.847 | 124.21 | 123.0 | 123.495 | 8152777.0 |
| 2021-02-26 11:30:00 | AAPL | Stock | 123.51 | 124.48 | 123.42 | 124.36 | 6822899.0 |
| 2021-02-26 12:00:00 | AAPL | Stock | 124.35 | 124.76 | 123.73 | 124.2 | 6283073.0 |
| 2021-02-26 12:30:00 | AAPL | Stock | 124.2 | 124.41 | 123.585 | 123.68 | 4704450.0 |
| 2021-02-26 13:00:00 | AAPL | Stock | 123.685 | 124.32 | 123.255 | 124.28 | 4411793.0 |
| 2021-02-26 13:30:00 | AAPL | Stock | 124.29 | 124.35 | 122.76 | 123.07 | 5884068.0 |
| 2021-02-26 14:00:00 | AAPL | Stock | 123.07 | 123.42 | 122.78 | 123.05 | 5783857.0 |
| 2021-02-26 14:30:00 | AAPL | Stock | 123.04 | 123.685 | 122.9 | 123.59 | 5489400.0 |
| 2021-02-26 15:00:00 | AAPL | Stock | 123.59 | 124.36 | 123.57 | 123.64 | 6622853.0 |
| 2021-02-26 15:30:00 | AAPL | Stock | 123.63 | 124.85 | 121.2 | 121.2 | 19257542.0 |
| 2021-02-26 16:00:00 | AAPL | Stock | 121.28 | 122.19 | 120.85 | 121.51 | 22150462.0 |
| 2021-02-26 16:30:00 | AAPL | Stock | 121.48 | 121.98 | 121.251 | 121.89 | 396126.0 |
| 2021-02-26 17:00:00 | AAPL | Stock | 121.85 | 121.989 | 121.7 | 121.989 | 131759.0 |
| 2021-02-26 17:30:00 | AAPL | Stock | 121.98 | 122.1 | 121.9 | 122.03 | 134967.0 |
| 2021-02-26 18:00:00 | AAPL | Stock | 122.0 | 122.09 | 121.7 | 121.82 | 87416.0 |
| 2021-02-26 18:30:00 | AAPL | Stock | 121.8 | 121.95 | 121.75 | 121.85 | 56193.0 |
| 2021-02-26 19:00:00 | AAPL | Stock | 121.82 | 121.95 | 121.8 | 121.9 | 36825.0 |
| 2021-02-26 19:30:00 | AAPL | Stock | 121.9 | 121.94 | 121.69 | 121.76 | 101821.0 |
| 2021-02-26 04:00:00 | MSFT | Stock | 229.86 | 229.9 | 228.9 | 229.14 | 1425.0 |
| 2021-02-26 04:30:00 | MSFT | Stock | 229.47 | 230.0 | 229.47 | 229.8 | 1095.0 |
| 2021-02-26 05:00:00 | MSFT | Stock | 229.1 | 229.2 | 228.53 | 229.08 | 1466.0 |
| 2021-02-26 05:30:00 | MSFT | Stock | 229.08 | 229.37 | 228.61 | 228.83 | 3242.0 |
| 2021-02-26 06:00:00 | MSFT | Stock | 228.51 | 228.9 | 228.11 | 228.14 | 1516.0 |
| 2021-02-26 06:30:00 | MSFT | Stock | 227.38 | 227.89 | 227.13 | 227.41 | 3117.0 |
| 2021-02-26 07:00:00 | MSFT | Stock | 227.77 | 230.95 | 227.7 | 229.5 | 30300.0 |
| 2021-02-26 07:30:00 | MSFT | Stock | 229.98 | 230.6 | 229.15 | 229.2 | 14750.0 |
| 2021-02-26 08:00:00 | MSFT | Stock | 228.06 | 230.789 | 228.06 | 230.0 | 25307.0 |
| 2021-02-26 08:30:00 | MSFT | Stock | 229.99 | 231.98 | 229.99 | 231.27 | 36397.0 |
| 2021-02-26 09:00:00 | MSFT | Stock | 231.68 | 232.13 | 230.21 | 231.55 | 31614.0 |
| 2021-02-26 09:30:00 | MSFT | Stock | 231.55 | 233.16 | 230.1 | 231.175 | 3047146.0 |
| 2021-02-26 10:00:00 | MSFT | Stock | 231.21 | 232.02 | 229.77 | 229.935 | 1751734.0 |
| 2021-02-26 10:30:00 | MSFT | Stock | 229.93 | 233.31 | 229.54 | 232.94 | 1767786.0 |
| 2021-02-26 11:00:00 | MSFT | Stock | 232.95 | 233.51 | 231.41 | 231.77 | 1169492.0 |
| 2021-02-26 11:30:00 | MSFT | Stock | 231.76 | 233.81 | 231.6 | 233.36 | 1072943.0 |
| 2021-02-26 12:00:00 | MSFT | Stock | 233.45 | 235.183 | 232.63 | 234.67 | 1262196.0 |
| 2021-02-26 12:30:00 | MSFT | Stock | 234.73 | 235.06 | 233.78 | 233.97 | 911197.0 |
> showing 50 of 121,360 rows — these rows as CSV