PREVIEW / stock_30min / 2021-02-25
file: by_date/stock_30min/2021/2021-02-25.parquet size: 2.4 MB rows: 124,434 symbols: 2,842
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-25 04:00:00 | AAPL | Stock | 124.8 | 125.0 | 123.92 | 124.28 | 43163.0 |
| 2021-02-25 04:30:00 | AAPL | Stock | 124.4 | 124.4 | 124.0 | 124.35 | 12622.0 |
| 2021-02-25 05:00:00 | AAPL | Stock | 124.34 | 124.53 | 124.2 | 124.46 | 10550.0 |
| 2021-02-25 05:30:00 | AAPL | Stock | 124.43 | 124.78 | 124.43 | 124.78 | 7410.0 |
| 2021-02-25 06:00:00 | AAPL | Stock | 124.82 | 125.0 | 123.8 | 124.0 | 36621.0 |
| 2021-02-25 06:30:00 | AAPL | Stock | 124.02 | 124.29 | 123.62 | 124.22 | 31847.0 |
| 2021-02-25 07:00:00 | AAPL | Stock | 124.2 | 124.7 | 124.01 | 124.7 | 137706.0 |
| 2021-02-25 07:30:00 | AAPL | Stock | 124.64 | 124.78 | 124.15 | 124.34 | 312313.0 |
| 2021-02-25 08:00:00 | AAPL | Stock | 124.166 | 125.663 | 124.021 | 124.4 | 253334.0 |
| 2021-02-25 08:30:00 | AAPL | Stock | 124.36 | 124.95 | 124.2 | 124.88 | 283212.0 |
| 2021-02-25 09:00:00 | AAPL | Stock | 124.85 | 124.85 | 124.26 | 124.64 | 292325.0 |
| 2021-02-25 09:30:00 | AAPL | Stock | 124.64 | 126.458 | 124.21 | 124.63 | 12326682.0 |
| 2021-02-25 10:00:00 | AAPL | Stock | 124.63 | 124.66 | 123.61 | 124.021 | 8967124.0 |
| 2021-02-25 10:30:00 | AAPL | Stock | 124.03 | 124.05 | 123.13 | 124.0 | 8865879.0 |
| 2021-02-25 11:00:00 | AAPL | Stock | 123.99 | 124.23 | 123.49 | 123.695 | 5134137.0 |
| 2021-02-25 11:30:00 | AAPL | Stock | 123.695 | 123.715 | 122.45 | 122.59 | 8072198.0 |
| 2021-02-25 12:00:00 | AAPL | Stock | 122.59 | 122.89 | 122.12 | 122.26 | 7658293.0 |
| 2021-02-25 12:30:00 | AAPL | Stock | 122.25 | 122.56 | 121.26 | 121.28 | 9268858.0 |
| 2021-02-25 13:00:00 | AAPL | Stock | 121.28 | 122.625 | 120.75 | 122.12 | 10255071.0 |
| 2021-02-25 13:30:00 | AAPL | Stock | 122.12 | 122.65 | 121.76 | 122.185 | 6124115.0 |
| 2021-02-25 14:00:00 | AAPL | Stock | 122.175 | 123.43 | 122.05 | 123.155 | 6566323.0 |
| 2021-02-25 14:30:00 | AAPL | Stock | 123.155 | 123.23 | 121.99 | 122.06 | 5754957.0 |
| 2021-02-25 15:00:00 | AAPL | Stock | 122.05 | 122.29 | 121.24 | 121.32 | 8325455.0 |
| 2021-02-25 15:30:00 | AAPL | Stock | 121.32 | 122.063 | 120.54 | 121.0 | 16599793.0 |
| 2021-02-25 16:00:00 | AAPL | Stock | 120.99 | 121.4 | 120.8 | 120.97 | 9768182.0 |
| 2021-02-25 16:30:00 | AAPL | Stock | 120.97 | 125.35 | 120.56 | 120.67 | 246054.0 |
| 2021-02-25 17:00:00 | AAPL | Stock | 120.67 | 120.74 | 120.46 | 120.61 | 166481.0 |
| 2021-02-25 17:30:00 | AAPL | Stock | 120.6 | 120.65 | 120.4 | 120.45 | 91782.0 |
| 2021-02-25 18:00:00 | AAPL | Stock | 120.5 | 120.99 | 120.35 | 120.8 | 154969.0 |
| 2021-02-25 18:30:00 | AAPL | Stock | 120.77 | 120.99 | 120.42 | 120.42 | 147791.0 |
| 2021-02-25 19:00:00 | AAPL | Stock | 120.45 | 120.6 | 120.0 | 120.04 | 219139.0 |
| 2021-02-25 19:30:00 | AAPL | Stock | 120.01 | 121.0 | 119.82 | 120.8 | 340120.0 |
| 2021-02-25 04:00:00 | MSFT | Stock | 233.54 | 233.54 | 232.13 | 232.5 | 9225.0 |
| 2021-02-25 04:30:00 | MSFT | Stock | 232.02 | 232.58 | 231.97 | 232.5 | 6019.0 |
| 2021-02-25 05:30:00 | MSFT | Stock | 232.51 | 233.68 | 232.5 | 233.68 | 3305.0 |
| 2021-02-25 06:00:00 | MSFT | Stock | 233.59 | 233.61 | 232.02 | 232.02 | 4869.0 |
| 2021-02-25 06:30:00 | MSFT | Stock | 232.2 | 232.2 | 231.21 | 232.05 | 3092.0 |
| 2021-02-25 07:00:00 | MSFT | Stock | 232.05 | 232.85 | 232.01 | 232.6 | 16082.0 |
| 2021-02-25 07:30:00 | MSFT | Stock | 232.62 | 232.75 | 232.0 | 232.25 | 9300.0 |
| 2021-02-25 08:00:00 | MSFT | Stock | 232.329 | 233.964 | 231.65 | 231.95 | 21308.0 |
| 2021-02-25 08:30:00 | MSFT | Stock | 232.3 | 233.17 | 232.3 | 232.71 | 17986.0 |
| 2021-02-25 09:00:00 | MSFT | Stock | 232.7 | 232.72 | 231.71 | 232.09 | 57724.0 |
| 2021-02-25 09:30:00 | MSFT | Stock | 232.2 | 234.585 | 232.06 | 234.2 | 2022616.0 |
| 2021-02-25 10:00:00 | MSFT | Stock | 234.2 | 234.23 | 232.52 | 232.834 | 1622952.0 |
| 2021-02-25 10:30:00 | MSFT | Stock | 232.83 | 233.11 | 231.59 | 233.11 | 1810883.0 |
| 2021-02-25 11:00:00 | MSFT | Stock | 233.08 | 234.1 | 232.13 | 232.31 | 1267638.0 |
| 2021-02-25 11:30:00 | MSFT | Stock | 232.31 | 232.49 | 230.48 | 230.62 | 1739444.0 |
| 2021-02-25 12:00:00 | MSFT | Stock | 230.63 | 231.25 | 229.99 | 230.005 | 2241405.0 |
| 2021-02-25 12:30:00 | MSFT | Stock | 230.0 | 230.5 | 229.29 | 229.44 | 2278161.0 |
| 2021-02-25 13:00:00 | MSFT | Stock | 229.44 | 230.91 | 228.5 | 230.355 | 1654831.0 |
> showing 50 of 124,434 rows — these rows as CSV