PREVIEW / stock_30min / 2021-02-18
file: by_date/stock_30min/2021/2021-02-18.parquet size: 2.4 MB rows: 121,145 symbols: 2,827
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-18 04:00:00 | AAPL | Stock | 130.5 | 130.5 | 129.87 | 129.87 | 19045.0 |
| 2021-02-18 04:30:00 | AAPL | Stock | 129.88 | 129.94 | 129.84 | 129.9 | 10780.0 |
| 2021-02-18 05:00:00 | AAPL | Stock | 129.9 | 129.92 | 129.75 | 129.75 | 6473.0 |
| 2021-02-18 05:30:00 | AAPL | Stock | 129.75 | 130.02 | 129.72 | 129.72 | 25799.0 |
| 2021-02-18 06:00:00 | AAPL | Stock | 129.64 | 129.64 | 128.81 | 128.96 | 95956.0 |
| 2021-02-18 06:30:00 | AAPL | Stock | 129.0 | 129.47 | 128.9 | 129.26 | 43200.0 |
| 2021-02-18 07:00:00 | AAPL | Stock | 129.25 | 129.52 | 129.2 | 129.49 | 123377.0 |
| 2021-02-18 07:30:00 | AAPL | Stock | 129.48 | 129.6 | 129.3 | 129.38 | 70458.0 |
| 2021-02-18 08:00:00 | AAPL | Stock | 129.41 | 129.58 | 129.0 | 129.15 | 393521.0 |
| 2021-02-18 08:30:00 | AAPL | Stock | 129.07 | 129.18 | 128.68 | 128.7 | 418695.0 |
| 2021-02-18 09:00:00 | AAPL | Stock | 128.7 | 129.26 | 128.5 | 129.24 | 572439.0 |
| 2021-02-18 09:30:00 | AAPL | Stock | 129.24 | 129.68 | 128.5 | 129.53 | 12231789.0 |
| 2021-02-18 10:00:00 | AAPL | Stock | 129.52 | 129.58 | 127.41 | 128.12 | 11250776.0 |
| 2021-02-18 10:30:00 | AAPL | Stock | 128.1 | 128.72 | 127.83 | 128.545 | 5759292.0 |
| 2021-02-18 11:00:00 | AAPL | Stock | 128.555 | 129.105 | 128.392 | 128.676 | 5341016.0 |
| 2021-02-18 11:30:00 | AAPL | Stock | 128.67 | 128.71 | 128.12 | 128.34 | 5027058.0 |
| 2021-02-18 12:00:00 | AAPL | Stock | 128.335 | 128.64 | 127.9 | 128.62 | 5226646.0 |
| 2021-02-18 12:30:00 | AAPL | Stock | 128.625 | 128.83 | 128.45 | 128.7 | 3521292.0 |
| 2021-02-18 13:00:00 | AAPL | Stock | 128.7 | 129.07 | 128.51 | 129.0 | 3843505.0 |
| 2021-02-18 13:30:00 | AAPL | Stock | 128.995 | 129.05 | 128.45 | 128.56 | 3466694.0 |
| 2021-02-18 14:00:00 | AAPL | Stock | 128.56 | 128.92 | 128.462 | 128.71 | 4012232.0 |
| 2021-02-18 14:30:00 | AAPL | Stock | 128.7 | 129.13 | 128.65 | 129.075 | 2772395.0 |
| 2021-02-18 15:00:00 | AAPL | Stock | 129.075 | 129.85 | 129.03 | 129.77 | 4555306.0 |
| 2021-02-18 15:30:00 | AAPL | Stock | 129.77 | 129.995 | 129.5 | 129.713 | 8556405.0 |
| 2021-02-18 16:00:00 | AAPL | Stock | 129.71 | 129.79 | 129.52 | 129.52 | 4623316.0 |
| 2021-02-18 16:30:00 | AAPL | Stock | 129.52 | 129.53 | 129.29 | 129.35 | 96762.0 |
| 2021-02-18 17:00:00 | AAPL | Stock | 129.35 | 129.35 | 129.22 | 129.34 | 72198.0 |
| 2021-02-18 17:30:00 | AAPL | Stock | 129.3 | 129.4 | 129.28 | 129.3 | 27090.0 |
| 2021-02-18 18:00:00 | AAPL | Stock | 129.3 | 129.54 | 129.29 | 129.51 | 52767.0 |
| 2021-02-18 18:30:00 | AAPL | Stock | 129.5 | 129.5 | 129.15 | 129.24 | 45220.0 |
| 2021-02-18 19:00:00 | AAPL | Stock | 129.22 | 129.25 | 129.0 | 129.1 | 50347.0 |
| 2021-02-18 19:30:00 | AAPL | Stock | 129.1 | 129.2 | 129.0 | 129.0 | 48719.0 |
| 2021-02-18 04:00:00 | MSFT | Stock | 243.16 | 243.16 | 242.8 | 242.81 | 500.0 |
| 2021-02-18 04:30:00 | MSFT | Stock | 242.92 | 242.92 | 242.85 | 242.85 | 450.0 |
| 2021-02-18 05:00:00 | MSFT | Stock | 242.91 | 242.91 | 242.72 | 242.72 | 502.0 |
| 2021-02-18 05:30:00 | MSFT | Stock | 242.83 | 243.19 | 242.59 | 242.59 | 500.0 |
| 2021-02-18 06:00:00 | MSFT | Stock | 242.87 | 242.87 | 242.87 | 242.87 | 422.0 |
| 2021-02-18 06:30:00 | MSFT | Stock | 242.39 | 242.8 | 242.32 | 242.8 | 1402.0 |
| 2021-02-18 07:00:00 | MSFT | Stock | 242.81 | 242.95 | 242.53 | 242.61 | 8407.0 |
| 2021-02-18 07:30:00 | MSFT | Stock | 242.74 | 242.99 | 242.5 | 242.5 | 5741.0 |
| 2021-02-18 08:00:00 | MSFT | Stock | 242.69 | 243.59 | 242.26 | 242.3 | 7011.0 |
| 2021-02-18 08:30:00 | MSFT | Stock | 242.27 | 242.28 | 241.55 | 242.12 | 13218.0 |
| 2021-02-18 09:00:00 | MSFT | Stock | 242.0 | 242.0 | 241.44 | 241.75 | 24589.0 |
| 2021-02-18 09:30:00 | MSFT | Stock | 241.78 | 242.44 | 241.32 | 241.994 | 1891751.0 |
| 2021-02-18 10:00:00 | MSFT | Stock | 241.95 | 242.2 | 240.86 | 241.55 | 1223723.0 |
| 2021-02-18 10:30:00 | MSFT | Stock | 241.49 | 242.0 | 241.2 | 241.66 | 731590.0 |
| 2021-02-18 11:00:00 | MSFT | Stock | 241.62 | 242.34 | 241.21 | 241.9 | 685215.0 |
| 2021-02-18 11:30:00 | MSFT | Stock | 241.89 | 242.04 | 241.121 | 241.49 | 634913.0 |
| 2021-02-18 12:00:00 | MSFT | Stock | 241.48 | 241.88 | 240.995 | 241.86 | 802654.0 |
| 2021-02-18 12:30:00 | MSFT | Stock | 241.86 | 241.97 | 241.53 | 241.86 | 390934.0 |
> showing 50 of 121,145 rows — these rows as CSV