PREVIEW / stock_30min / 2021-02-09
file: by_date/stock_30min/2021/2021-02-09.parquet size: 2.4 MB rows: 122,877 symbols: 2,801
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-09 04:00:00 | AAPL | Stock | 136.4 | 136.67 | 136.1 | 136.33 | 18010.0 |
| 2021-02-09 04:30:00 | AAPL | Stock | 136.3 | 136.38 | 136.23 | 136.38 | 15811.0 |
| 2021-02-09 05:00:00 | AAPL | Stock | 136.36 | 136.54 | 136.36 | 136.51 | 6362.0 |
| 2021-02-09 05:30:00 | AAPL | Stock | 136.53 | 136.6 | 136.5 | 136.57 | 5425.0 |
| 2021-02-09 06:00:00 | AAPL | Stock | 136.56 | 136.71 | 136.45 | 136.71 | 14837.0 |
| 2021-02-09 06:30:00 | AAPL | Stock | 136.61 | 136.67 | 136.55 | 136.64 | 5757.0 |
| 2021-02-09 07:00:00 | AAPL | Stock | 136.62 | 136.68 | 136.31 | 136.55 | 52699.0 |
| 2021-02-09 07:30:00 | AAPL | Stock | 136.54 | 136.66 | 136.42 | 136.45 | 43360.0 |
| 2021-02-09 08:00:00 | AAPL | Stock | 136.5 | 136.66 | 136.25 | 136.5 | 246692.0 |
| 2021-02-09 08:30:00 | AAPL | Stock | 136.49 | 136.5 | 136.31 | 136.44 | 109313.0 |
| 2021-02-09 09:00:00 | AAPL | Stock | 136.42 | 136.79 | 136.14 | 136.71 | 427262.0 |
| 2021-02-09 09:30:00 | AAPL | Stock | 136.7 | 137.68 | 136.5 | 136.94 | 10809563.0 |
| 2021-02-09 10:00:00 | AAPL | Stock | 136.95 | 137.54 | 136.82 | 137.26 | 5102954.0 |
| 2021-02-09 10:30:00 | AAPL | Stock | 137.259 | 137.877 | 137.1 | 137.194 | 5235770.0 |
| 2021-02-09 11:00:00 | AAPL | Stock | 137.195 | 137.27 | 136.562 | 136.69 | 5131225.0 |
| 2021-02-09 11:30:00 | AAPL | Stock | 136.69 | 136.969 | 136.43 | 136.47 | 3181495.0 |
| 2021-02-09 12:00:00 | AAPL | Stock | 136.464 | 136.79 | 136.43 | 136.595 | 2311062.0 |
| 2021-02-09 12:30:00 | AAPL | Stock | 136.591 | 136.66 | 136.44 | 136.575 | 2039176.0 |
| 2021-02-09 13:00:00 | AAPL | Stock | 136.577 | 136.61 | 136.18 | 136.22 | 2473460.0 |
| 2021-02-09 13:30:00 | AAPL | Stock | 136.23 | 136.55 | 136.21 | 136.415 | 2510967.0 |
| 2021-02-09 14:00:00 | AAPL | Stock | 136.419 | 136.69 | 136.41 | 136.631 | 1705764.0 |
| 2021-02-09 14:30:00 | AAPL | Stock | 136.63 | 136.8 | 136.56 | 136.725 | 2062966.0 |
| 2021-02-09 15:00:00 | AAPL | Stock | 136.715 | 136.74 | 136.37 | 136.41 | 2385384.0 |
| 2021-02-09 15:30:00 | AAPL | Stock | 136.42 | 136.49 | 135.85 | 136.0 | 6452917.0 |
| 2021-02-09 16:00:00 | AAPL | Stock | 135.99 | 136.649 | 135.99 | 136.06 | 5207054.0 |
| 2021-02-09 16:30:00 | AAPL | Stock | 136.06 | 136.28 | 136.02 | 136.27 | 74264.0 |
| 2021-02-09 17:00:00 | AAPL | Stock | 136.25 | 136.26 | 136.05 | 136.13 | 48712.0 |
| 2021-02-09 17:30:00 | AAPL | Stock | 136.12 | 136.15 | 136.05 | 136.11 | 22510.0 |
| 2021-02-09 18:00:00 | AAPL | Stock | 136.11 | 136.24 | 136.0 | 136.0 | 73501.0 |
| 2021-02-09 18:30:00 | AAPL | Stock | 136.0 | 136.05 | 135.99 | 136.03 | 27257.0 |
| 2021-02-09 19:00:00 | AAPL | Stock | 136.02 | 136.02 | 135.9 | 135.91 | 52234.0 |
| 2021-02-09 19:30:00 | AAPL | Stock | 135.91 | 135.95 | 135.81 | 135.93 | 77179.0 |
| 2021-02-09 04:00:00 | MSFT | Stock | 242.01 | 242.3 | 242.01 | 242.3 | 601.0 |
| 2021-02-09 05:00:00 | MSFT | Stock | 241.74 | 241.93 | 241.74 | 241.91 | 752.0 |
| 2021-02-09 05:30:00 | MSFT | Stock | 241.76 | 241.76 | 241.76 | 241.76 | 200.0 |
| 2021-02-09 06:30:00 | MSFT | Stock | 241.97 | 242.7 | 241.97 | 242.33 | 2939.0 |
| 2021-02-09 07:00:00 | MSFT | Stock | 242.38 | 242.38 | 242.2 | 242.38 | 5068.0 |
| 2021-02-09 07:30:00 | MSFT | Stock | 242.05 | 242.18 | 241.95 | 241.95 | 2045.0 |
| 2021-02-09 08:00:00 | MSFT | Stock | 242.2 | 242.2 | 241.7 | 241.84 | 9334.0 |
| 2021-02-09 08:30:00 | MSFT | Stock | 241.83 | 241.84 | 241.68 | 241.771 | 5755.0 |
| 2021-02-09 09:00:00 | MSFT | Stock | 241.77 | 242.2 | 241.11 | 242.0 | 16514.0 |
| 2021-02-09 09:30:00 | MSFT | Stock | 242.0 | 244.16 | 241.38 | 243.76 | 2110001.0 |
| 2021-02-09 10:00:00 | MSFT | Stock | 243.845 | 244.76 | 243.678 | 244.015 | 1319024.0 |
| 2021-02-09 10:30:00 | MSFT | Stock | 244.01 | 244.5 | 243.81 | 244.33 | 857275.0 |
| 2021-02-09 11:00:00 | MSFT | Stock | 244.32 | 244.38 | 243.28 | 243.28 | 805058.0 |
| 2021-02-09 11:30:00 | MSFT | Stock | 243.27 | 243.597 | 243.03 | 243.22 | 505308.0 |
| 2021-02-09 12:00:00 | MSFT | Stock | 243.22 | 243.33 | 242.82 | 242.92 | 541265.0 |
| 2021-02-09 12:30:00 | MSFT | Stock | 242.94 | 243.15 | 242.56 | 242.99 | 521676.0 |
| 2021-02-09 13:00:00 | MSFT | Stock | 242.98 | 243.28 | 242.87 | 243.2 | 527004.0 |
| 2021-02-09 13:30:00 | MSFT | Stock | 243.2 | 243.49 | 243.0 | 243.31 | 470066.0 |
> showing 50 of 122,877 rows — these rows as CSV