PREVIEW / stock_30min / 2020-11-24
file: by_date/stock_30min/2020/2020-11-24.parquet size: 2.2 MB rows: 109,044 symbols: 2,607
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 |
|---|---|---|---|---|---|---|---|
| 2020-11-24 04:00:00 | AAPL | Stock | 114.6 | 114.6 | 114.11 | 114.36 | 27509.0 |
| 2020-11-24 04:30:00 | AAPL | Stock | 114.39 | 114.65 | 114.39 | 114.43 | 12155.0 |
| 2020-11-24 05:00:00 | AAPL | Stock | 114.63 | 114.65 | 114.31 | 114.42 | 27639.0 |
| 2020-11-24 05:30:00 | AAPL | Stock | 114.41 | 114.41 | 114.12 | 114.24 | 39282.0 |
| 2020-11-24 06:00:00 | AAPL | Stock | 114.22 | 114.44 | 114.21 | 114.42 | 4248.0 |
| 2020-11-24 06:30:00 | AAPL | Stock | 114.4 | 114.45 | 114.0 | 114.19 | 33178.0 |
| 2020-11-24 07:00:00 | AAPL | Stock | 114.17 | 114.61 | 114.03 | 114.18 | 291839.0 |
| 2020-11-24 07:30:00 | AAPL | Stock | 114.15 | 114.29 | 114.08 | 114.25 | 75536.0 |
| 2020-11-24 08:00:00 | AAPL | Stock | 114.25 | 114.59 | 114.06 | 114.23 | 361925.0 |
| 2020-11-24 08:30:00 | AAPL | Stock | 114.23 | 114.44 | 114.2 | 114.3 | 189220.0 |
| 2020-11-24 09:00:00 | AAPL | Stock | 114.31 | 114.37 | 113.82 | 113.87 | 846655.0 |
| 2020-11-24 09:30:00 | AAPL | Stock | 113.91 | 114.04 | 112.59 | 113.01 | 18186417.0 |
| 2020-11-24 10:00:00 | AAPL | Stock | 113.02 | 113.82 | 113.015 | 113.405 | 9440441.0 |
| 2020-11-24 10:30:00 | AAPL | Stock | 113.4 | 114.905 | 113.34 | 114.903 | 8658265.0 |
| 2020-11-24 11:00:00 | AAPL | Stock | 114.903 | 115.12 | 114.66 | 114.92 | 7612983.0 |
| 2020-11-24 11:30:00 | AAPL | Stock | 114.92 | 115.37 | 114.735 | 114.81 | 6623556.0 |
| 2020-11-24 12:00:00 | AAPL | Stock | 114.81 | 114.87 | 114.23 | 114.66 | 4740726.0 |
| 2020-11-24 12:30:00 | AAPL | Stock | 114.67 | 115.012 | 114.551 | 114.8 | 3555855.0 |
| 2020-11-24 13:00:00 | AAPL | Stock | 114.79 | 115.31 | 114.62 | 115.04 | 4418515.0 |
| 2020-11-24 13:30:00 | AAPL | Stock | 115.045 | 115.7 | 115.04 | 115.69 | 5321447.0 |
| 2020-11-24 14:00:00 | AAPL | Stock | 115.694 | 115.85 | 114.97 | 115.075 | 5641761.0 |
| 2020-11-24 14:30:00 | AAPL | Stock | 115.08 | 115.38 | 115.0 | 115.36 | 3896506.0 |
| 2020-11-24 15:00:00 | AAPL | Stock | 115.36 | 115.72 | 115.165 | 115.675 | 4457760.0 |
| 2020-11-24 15:30:00 | AAPL | Stock | 115.67 | 115.73 | 114.97 | 115.17 | 8745206.0 |
| 2020-11-24 16:00:00 | AAPL | Stock | 115.17 | 115.24 | 115.05 | 115.1 | 8976499.0 |
| 2020-11-24 16:30:00 | AAPL | Stock | 115.09 | 115.2 | 115.0 | 115.14 | 81494.0 |
| 2020-11-24 17:00:00 | AAPL | Stock | 115.15 | 115.17 | 115.0 | 115.1 | 50768.0 |
| 2020-11-24 17:30:00 | AAPL | Stock | 115.1 | 115.14 | 115.05 | 115.12 | 26383.0 |
| 2020-11-24 18:00:00 | AAPL | Stock | 115.11 | 115.35 | 115.04 | 115.28 | 92999.0 |
| 2020-11-24 18:30:00 | AAPL | Stock | 115.26 | 115.33 | 115.15 | 115.33 | 44130.0 |
| 2020-11-24 19:00:00 | AAPL | Stock | 115.34 | 115.49 | 115.22 | 115.41 | 91594.0 |
| 2020-11-24 19:30:00 | AAPL | Stock | 115.43 | 115.61 | 115.31 | 115.58 | 91765.0 |
| 2020-11-24 04:00:00 | MSFT | Stock | 211.48 | 211.48 | 210.21 | 210.31 | 2976.0 |
| 2020-11-24 04:30:00 | MSFT | Stock | 210.4 | 210.97 | 210.4 | 210.9 | 1414.0 |
| 2020-11-24 05:00:00 | MSFT | Stock | 210.88 | 210.9 | 210.5 | 210.5 | 931.0 |
| 2020-11-24 05:30:00 | MSFT | Stock | 210.5 | 210.5 | 209.93 | 210.12 | 3072.0 |
| 2020-11-24 06:00:00 | MSFT | Stock | 210.38 | 210.42 | 210.3 | 210.42 | 1376.0 |
| 2020-11-24 06:30:00 | MSFT | Stock | 210.42 | 210.5 | 210.02 | 210.02 | 1597.0 |
| 2020-11-24 07:00:00 | MSFT | Stock | 210.59 | 210.59 | 209.66 | 209.99 | 17838.0 |
| 2020-11-24 07:30:00 | MSFT | Stock | 210.0 | 210.2 | 209.75 | 210.11 | 12424.0 |
| 2020-11-24 08:00:00 | MSFT | Stock | 210.15 | 210.637 | 209.717 | 210.37 | 33729.0 |
| 2020-11-24 08:30:00 | MSFT | Stock | 210.43 | 210.74 | 210.42 | 210.64 | 24345.0 |
| 2020-11-24 09:00:00 | MSFT | Stock | 210.612 | 210.98 | 209.45 | 209.49 | 129033.0 |
| 2020-11-24 09:30:00 | MSFT | Stock | 209.49 | 210.81 | 208.86 | 209.33 | 2930234.0 |
| 2020-11-24 10:00:00 | MSFT | Stock | 209.307 | 210.12 | 208.96 | 209.75 | 2136569.0 |
| 2020-11-24 10:30:00 | MSFT | Stock | 209.77 | 211.59 | 209.45 | 211.15 | 1844570.0 |
| 2020-11-24 11:00:00 | MSFT | Stock | 211.15 | 212.36 | 211.07 | 212.07 | 1531645.0 |
| 2020-11-24 11:30:00 | MSFT | Stock | 212.071 | 212.65 | 211.63 | 212.65 | 1492054.0 |
| 2020-11-24 12:00:00 | MSFT | Stock | 212.643 | 213.38 | 212.36 | 213.368 | 1192494.0 |
| 2020-11-24 12:30:00 | MSFT | Stock | 213.36 | 214.02 | 213.31 | 213.81 | 1417807.0 |
> showing 50 of 109,044 rows — these rows as CSV