PREVIEW / stock_30min / 2021-08-11
file: by_date/stock_30min/2021/2021-08-11.parquet size: 2.2 MB rows: 109,273 symbols: 2,819
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-11 04:00:00 | AAPL | Stock | 145.41 | 145.41 | 145.2 | 145.29 | 6999.0 |
| 2021-08-11 04:30:00 | AAPL | Stock | 145.21 | 145.25 | 145.2 | 145.25 | 415.0 |
| 2021-08-11 05:00:00 | AAPL | Stock | 145.22 | 145.24 | 144.8 | 145.0 | 7464.0 |
| 2021-08-11 05:30:00 | AAPL | Stock | 145.08 | 145.17 | 145.03 | 145.17 | 2914.0 |
| 2021-08-11 06:00:00 | AAPL | Stock | 145.13 | 145.2 | 145.12 | 145.2 | 5364.0 |
| 2021-08-11 06:30:00 | AAPL | Stock | 145.21 | 145.34 | 145.15 | 145.32 | 6009.0 |
| 2021-08-11 07:00:00 | AAPL | Stock | 145.36 | 145.48 | 145.25 | 145.28 | 31995.0 |
| 2021-08-11 07:30:00 | AAPL | Stock | 145.3 | 145.33 | 145.23 | 145.27 | 12421.0 |
| 2021-08-11 08:00:00 | AAPL | Stock | 145.349 | 145.48 | 145.236 | 145.32 | 87263.0 |
| 2021-08-11 08:30:00 | AAPL | Stock | 145.32 | 146.22 | 145.3 | 146.02 | 323614.0 |
| 2021-08-11 09:00:00 | AAPL | Stock | 146.05 | 146.18 | 145.92 | 146.04 | 140766.0 |
| 2021-08-11 09:30:00 | AAPL | Stock | 146.07 | 146.72 | 145.98 | 146.08 | 7366050.0 |
| 2021-08-11 10:00:00 | AAPL | Stock | 146.07 | 146.43 | 145.615 | 145.81 | 4400525.0 |
| 2021-08-11 10:30:00 | AAPL | Stock | 145.82 | 145.9778 | 145.57 | 145.62 | 3638208.0 |
| 2021-08-11 11:00:00 | AAPL | Stock | 145.62 | 146.01 | 145.53 | 145.99 | 3434579.0 |
| 2021-08-11 11:30:00 | AAPL | Stock | 145.99 | 146.07 | 145.7046 | 145.89 | 2723071.0 |
| 2021-08-11 12:00:00 | AAPL | Stock | 145.89 | 146.36 | 145.86 | 146.2526 | 2734259.0 |
| 2021-08-11 12:30:00 | AAPL | Stock | 146.255 | 146.46 | 146.19 | 146.3088 | 2075476.0 |
| 2021-08-11 13:00:00 | AAPL | Stock | 146.305 | 146.59 | 146.2194 | 146.3482 | 2797632.0 |
| 2021-08-11 13:30:00 | AAPL | Stock | 146.345 | 146.37 | 145.82 | 146.05 | 2086552.0 |
| 2021-08-11 14:00:00 | AAPL | Stock | 146.04 | 146.12 | 145.8 | 145.935 | 1498303.0 |
| 2021-08-11 14:30:00 | AAPL | Stock | 145.935 | 146.06 | 145.87 | 145.96 | 1501984.0 |
| 2021-08-11 15:00:00 | AAPL | Stock | 145.97 | 146.09 | 145.885 | 145.925 | 1829184.0 |
| 2021-08-11 15:30:00 | AAPL | Stock | 145.92 | 146.0 | 145.7799 | 145.91 | 3907420.0 |
| 2021-08-11 16:00:00 | AAPL | Stock | 145.86 | 145.92 | 145.66 | 145.68 | 3033817.0 |
| 2021-08-11 16:30:00 | AAPL | Stock | 145.68 | 145.8 | 145.68 | 145.7 | 12490.0 |
| 2021-08-11 17:00:00 | AAPL | Stock | 145.71 | 145.73 | 145.7 | 145.7 | 5523.0 |
| 2021-08-11 17:30:00 | AAPL | Stock | 145.7 | 145.72 | 145.66 | 145.72 | 12594.0 |
| 2021-08-11 18:00:00 | AAPL | Stock | 145.7199 | 145.7199 | 145.66 | 145.68 | 12497.0 |
| 2021-08-11 18:30:00 | AAPL | Stock | 145.68 | 145.7 | 145.67 | 145.68 | 13789.0 |
| 2021-08-11 19:00:00 | AAPL | Stock | 145.7 | 145.71 | 145.66 | 145.67 | 4467.0 |
| 2021-08-11 19:30:00 | AAPL | Stock | 145.67 | 145.69 | 145.6 | 145.67 | 19980.0 |
| 2021-08-11 04:00:00 | MSFT | Stock | 286.11 | 286.11 | 285.73 | 285.73 | 600.0 |
| 2021-08-11 04:30:00 | MSFT | Stock | 285.76 | 285.76 | 285.75 | 285.75 | 300.0 |
| 2021-08-11 05:00:00 | MSFT | Stock | 285.71 | 285.71 | 285.29 | 285.29 | 1350.0 |
| 2021-08-11 05:30:00 | MSFT | Stock | 285.29 | 285.29 | 285.29 | 285.29 | 378.0 |
| 2021-08-11 06:00:00 | MSFT | Stock | 285.3 | 285.73 | 285.3 | 285.64 | 1863.0 |
| 2021-08-11 06:30:00 | MSFT | Stock | 285.95 | 286.53 | 285.95 | 286.53 | 706.0 |
| 2021-08-11 07:00:00 | MSFT | Stock | 286.2 | 286.2 | 286.0 | 286.0 | 3477.0 |
| 2021-08-11 07:30:00 | MSFT | Stock | 286.08 | 286.08 | 285.95 | 285.95 | 526.0 |
| 2021-08-11 08:00:00 | MSFT | Stock | 286.04 | 287.156 | 285.96 | 286.05 | 1062.0 |
| 2021-08-11 08:30:00 | MSFT | Stock | 286.1 | 287.85 | 286.1 | 287.28 | 30073.0 |
| 2021-08-11 09:00:00 | MSFT | Stock | 287.29 | 287.4 | 286.44 | 287.18 | 15383.0 |
| 2021-08-11 09:30:00 | MSFT | Stock | 287.18 | 288.66 | 287.02 | 287.4599 | 1594087.0 |
| 2021-08-11 10:00:00 | MSFT | Stock | 287.47 | 288.05 | 286.74 | 286.94 | 921081.0 |
| 2021-08-11 10:30:00 | MSFT | Stock | 286.93 | 287.11 | 286.35 | 286.35 | 779658.0 |
| 2021-08-11 11:00:00 | MSFT | Stock | 286.36 | 286.4586 | 285.86 | 286.3 | 687644.0 |
| 2021-08-11 11:30:00 | MSFT | Stock | 286.32 | 286.47 | 285.98 | 286.31 | 546800.0 |
| 2021-08-11 12:00:00 | MSFT | Stock | 286.3 | 286.93 | 286.27 | 286.87 | 482013.0 |
| 2021-08-11 12:30:00 | MSFT | Stock | 286.89 | 287.17 | 286.73 | 286.86 | 347310.0 |
> showing 50 of 109,273 rows — these rows as CSV