PREVIEW / stock_30min / 2021-02-10
file: by_date/stock_30min/2021/2021-02-10.parquet size: 2.4 MB rows: 123,402 symbols: 2,810
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-10 04:00:00 | AAPL | Stock | 136.7 | 136.85 | 136.5 | 136.58 | 22513.0 |
| 2021-02-10 04:30:00 | AAPL | Stock | 136.55 | 136.7 | 136.35 | 136.41 | 10412.0 |
| 2021-02-10 05:00:00 | AAPL | Stock | 136.36 | 136.68 | 136.35 | 136.5 | 6315.0 |
| 2021-02-10 05:30:00 | AAPL | Stock | 136.5 | 136.53 | 136.49 | 136.51 | 1686.0 |
| 2021-02-10 06:00:00 | AAPL | Stock | 136.5 | 136.6 | 136.5 | 136.55 | 4396.0 |
| 2021-02-10 06:30:00 | AAPL | Stock | 136.51 | 136.54 | 136.41 | 136.45 | 6989.0 |
| 2021-02-10 07:00:00 | AAPL | Stock | 136.41 | 136.5 | 136.38 | 136.43 | 83765.0 |
| 2021-02-10 07:30:00 | AAPL | Stock | 136.43 | 136.56 | 136.42 | 136.45 | 41286.0 |
| 2021-02-10 08:00:00 | AAPL | Stock | 136.446 | 136.57 | 136.05 | 136.23 | 214225.0 |
| 2021-02-10 08:30:00 | AAPL | Stock | 136.21 | 136.6 | 136.21 | 136.4 | 135044.0 |
| 2021-02-10 09:00:00 | AAPL | Stock | 136.4 | 136.5 | 136.0 | 136.47 | 195306.0 |
| 2021-02-10 09:30:00 | AAPL | Stock | 136.48 | 136.99 | 136.13 | 136.39 | 7271126.0 |
| 2021-02-10 10:00:00 | AAPL | Stock | 136.38 | 136.73 | 134.69 | 135.21 | 8632585.0 |
| 2021-02-10 10:30:00 | AAPL | Stock | 135.2 | 135.63 | 134.4 | 135.356 | 7012426.0 |
| 2021-02-10 11:00:00 | AAPL | Stock | 135.35 | 135.54 | 134.82 | 135.118 | 4018266.0 |
| 2021-02-10 11:30:00 | AAPL | Stock | 135.13 | 135.65 | 135.04 | 135.41 | 2860026.0 |
| 2021-02-10 12:00:00 | AAPL | Stock | 135.415 | 135.46 | 135.04 | 135.29 | 2759447.0 |
| 2021-02-10 12:30:00 | AAPL | Stock | 135.28 | 135.358 | 135.055 | 135.085 | 1923576.0 |
| 2021-02-10 13:00:00 | AAPL | Stock | 135.09 | 135.24 | 134.93 | 135.19 | 2146338.0 |
| 2021-02-10 13:30:00 | AAPL | Stock | 135.18 | 135.2 | 134.97 | 135.067 | 1496744.0 |
| 2021-02-10 14:00:00 | AAPL | Stock | 135.07 | 135.52 | 135.04 | 135.519 | 2485671.0 |
| 2021-02-10 14:30:00 | AAPL | Stock | 135.52 | 135.84 | 135.4 | 135.604 | 2870309.0 |
| 2021-02-10 15:00:00 | AAPL | Stock | 135.61 | 135.8 | 135.37 | 135.505 | 2632350.0 |
| 2021-02-10 15:30:00 | AAPL | Stock | 135.51 | 135.64 | 134.95 | 135.36 | 5669997.0 |
| 2021-02-10 16:00:00 | AAPL | Stock | 135.39 | 135.42 | 135.15 | 135.3 | 5751371.0 |
| 2021-02-10 16:30:00 | AAPL | Stock | 135.3 | 135.36 | 135.2 | 135.29 | 37773.0 |
| 2021-02-10 17:00:00 | AAPL | Stock | 135.32 | 135.32 | 135.24 | 135.24 | 20938.0 |
| 2021-02-10 17:30:00 | AAPL | Stock | 135.25 | 135.28 | 135.15 | 135.2 | 22264.0 |
| 2021-02-10 18:00:00 | AAPL | Stock | 135.2 | 135.29 | 135.16 | 135.25 | 20885.0 |
| 2021-02-10 18:30:00 | AAPL | Stock | 135.22 | 135.3 | 135.22 | 135.27 | 20513.0 |
| 2021-02-10 19:00:00 | AAPL | Stock | 135.25 | 135.27 | 135.1 | 135.11 | 51492.0 |
| 2021-02-10 19:30:00 | AAPL | Stock | 135.1 | 135.11 | 134.92 | 134.92 | 74037.0 |
| 2021-02-10 04:00:00 | MSFT | Stock | 244.99 | 245.0 | 244.68 | 244.75 | 2614.0 |
| 2021-02-10 04:30:00 | MSFT | Stock | 244.65 | 244.65 | 244.65 | 244.65 | 250.0 |
| 2021-02-10 05:00:00 | MSFT | Stock | 244.55 | 244.64 | 244.55 | 244.64 | 210.0 |
| 2021-02-10 05:30:00 | MSFT | Stock | 244.68 | 244.7 | 244.68 | 244.7 | 815.0 |
| 2021-02-10 06:00:00 | MSFT | Stock | 244.7 | 244.79 | 244.7 | 244.79 | 490.0 |
| 2021-02-10 06:30:00 | MSFT | Stock | 244.84 | 244.9 | 244.46 | 244.46 | 4962.0 |
| 2021-02-10 07:00:00 | MSFT | Stock | 244.3 | 244.72 | 244.15 | 244.35 | 3243.0 |
| 2021-02-10 07:30:00 | MSFT | Stock | 244.34 | 244.34 | 244.15 | 244.16 | 2480.0 |
| 2021-02-10 08:00:00 | MSFT | Stock | 244.486 | 244.525 | 244.12 | 244.27 | 6036.0 |
| 2021-02-10 08:30:00 | MSFT | Stock | 244.35 | 244.8 | 244.35 | 244.71 | 8974.0 |
| 2021-02-10 09:00:00 | MSFT | Stock | 244.8 | 245.5 | 243.882 | 244.98 | 23275.0 |
| 2021-02-10 09:30:00 | MSFT | Stock | 244.98 | 245.92 | 244.29 | 244.555 | 1895563.0 |
| 2021-02-10 10:00:00 | MSFT | Stock | 244.54 | 245.57 | 242.25 | 242.525 | 1466552.0 |
| 2021-02-10 10:30:00 | MSFT | Stock | 242.56 | 243.292 | 241.31 | 241.88 | 1818329.0 |
| 2021-02-10 11:00:00 | MSFT | Stock | 241.875 | 242.137 | 241.14 | 241.35 | 1415104.0 |
| 2021-02-10 11:30:00 | MSFT | Stock | 241.34 | 241.71 | 241.09 | 241.25 | 992939.0 |
| 2021-02-10 12:00:00 | MSFT | Stock | 241.275 | 241.54 | 240.89 | 241.38 | 791100.0 |
| 2021-02-10 12:30:00 | MSFT | Stock | 241.335 | 241.88 | 241.22 | 241.69 | 615470.0 |
> showing 50 of 123,402 rows — these rows as CSV