PREVIEW / stock_30min / 2021-02-08
file: by_date/stock_30min/2021/2021-02-08.parquet size: 2.4 MB rows: 124,503 symbols: 2,782
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-08 04:00:00 | AAPL | Stock | 136.68 | 137.1 | 136.5 | 136.87 | 59392.0 |
| 2021-02-08 04:30:00 | AAPL | Stock | 136.8 | 136.98 | 136.74 | 136.94 | 9970.0 |
| 2021-02-08 05:00:00 | AAPL | Stock | 136.95 | 137.1 | 136.9 | 137.0 | 10945.0 |
| 2021-02-08 05:30:00 | AAPL | Stock | 136.99 | 136.99 | 136.8 | 136.8 | 6774.0 |
| 2021-02-08 06:00:00 | AAPL | Stock | 136.8 | 136.99 | 136.74 | 136.94 | 10091.0 |
| 2021-02-08 06:30:00 | AAPL | Stock | 136.92 | 136.95 | 136.83 | 136.89 | 3804.0 |
| 2021-02-08 07:00:00 | AAPL | Stock | 136.9 | 136.96 | 136.05 | 136.19 | 201586.0 |
| 2021-02-08 07:30:00 | AAPL | Stock | 136.2 | 136.48 | 136.16 | 136.2 | 90607.0 |
| 2021-02-08 08:00:00 | AAPL | Stock | 136.229 | 136.89 | 136.06 | 136.22 | 291705.0 |
| 2021-02-08 08:30:00 | AAPL | Stock | 136.21 | 136.25 | 136.01 | 136.17 | 151958.0 |
| 2021-02-08 09:00:00 | AAPL | Stock | 136.15 | 136.35 | 135.98 | 135.98 | 311194.0 |
| 2021-02-08 09:30:00 | AAPL | Stock | 136.03 | 136.25 | 134.92 | 135.69 | 11627319.0 |
| 2021-02-08 10:00:00 | AAPL | Stock | 135.68 | 136.31 | 135.6 | 135.91 | 5514758.0 |
| 2021-02-08 10:30:00 | AAPL | Stock | 135.909 | 136.68 | 135.88 | 136.61 | 4469266.0 |
| 2021-02-08 11:00:00 | AAPL | Stock | 136.62 | 136.9 | 136.42 | 136.445 | 3957539.0 |
| 2021-02-08 11:30:00 | AAPL | Stock | 136.445 | 136.52 | 135.84 | 136.231 | 4424740.0 |
| 2021-02-08 12:00:00 | AAPL | Stock | 136.235 | 136.54 | 136.01 | 136.08 | 3129565.0 |
| 2021-02-08 12:30:00 | AAPL | Stock | 136.072 | 136.38 | 135.84 | 135.979 | 2664804.0 |
| 2021-02-08 13:00:00 | AAPL | Stock | 135.975 | 136.13 | 135.9 | 136.071 | 1748755.0 |
| 2021-02-08 13:30:00 | AAPL | Stock | 136.07 | 136.3 | 135.8 | 135.933 | 2428375.0 |
| 2021-02-08 14:00:00 | AAPL | Stock | 135.938 | 136.09 | 135.91 | 136.03 | 1703838.0 |
| 2021-02-08 14:30:00 | AAPL | Stock | 136.025 | 136.32 | 135.89 | 136.32 | 2128180.0 |
| 2021-02-08 15:00:00 | AAPL | Stock | 136.32 | 136.43 | 136.14 | 136.321 | 2852817.0 |
| 2021-02-08 15:30:00 | AAPL | Stock | 136.325 | 136.96 | 136.25 | 136.901 | 6517620.0 |
| 2021-02-08 16:00:00 | AAPL | Stock | 136.905 | 136.91 | 136.6 | 136.73 | 6023381.0 |
| 2021-02-08 16:30:00 | AAPL | Stock | 136.71 | 136.78 | 136.66 | 136.72 | 64852.0 |
| 2021-02-08 17:00:00 | AAPL | Stock | 136.71 | 136.72 | 136.65 | 136.67 | 40110.0 |
| 2021-02-08 17:30:00 | AAPL | Stock | 136.68 | 136.74 | 136.66 | 136.68 | 36146.0 |
| 2021-02-08 18:00:00 | AAPL | Stock | 136.7 | 136.74 | 136.64 | 136.67 | 44905.0 |
| 2021-02-08 18:30:00 | AAPL | Stock | 136.67 | 136.72 | 136.64 | 136.67 | 24285.0 |
| 2021-02-08 19:00:00 | AAPL | Stock | 136.66 | 136.7 | 136.65 | 136.65 | 26568.0 |
| 2021-02-08 19:30:00 | AAPL | Stock | 136.64 | 136.67 | 136.51 | 136.6 | 55514.0 |
| 2021-02-08 04:00:00 | MSFT | Stock | 243.1 | 243.52 | 243.1 | 243.5 | 5049.0 |
| 2021-02-08 04:30:00 | MSFT | Stock | 243.45 | 243.7 | 243.45 | 243.7 | 1317.0 |
| 2021-02-08 05:00:00 | MSFT | Stock | 243.56 | 243.56 | 243.39 | 243.4 | 1054.0 |
| 2021-02-08 05:30:00 | MSFT | Stock | 243.33 | 243.77 | 243.3 | 243.51 | 2562.0 |
| 2021-02-08 06:00:00 | MSFT | Stock | 243.59 | 243.61 | 243.55 | 243.61 | 400.0 |
| 2021-02-08 07:00:00 | MSFT | Stock | 243.7 | 243.7 | 243.22 | 243.35 | 7520.0 |
| 2021-02-08 07:30:00 | MSFT | Stock | 243.25 | 243.32 | 243.09 | 243.24 | 4890.0 |
| 2021-02-08 08:00:00 | MSFT | Stock | 243.36 | 243.55 | 242.64 | 243.1 | 22434.0 |
| 2021-02-08 08:30:00 | MSFT | Stock | 243.1 | 243.51 | 242.97 | 243.4 | 38369.0 |
| 2021-02-08 09:00:00 | MSFT | Stock | 243.41 | 243.5 | 243.1 | 243.21 | 24322.0 |
| 2021-02-08 09:30:00 | MSFT | Stock | 243.15 | 243.68 | 241.76 | 243.21 | 2105456.0 |
| 2021-02-08 10:00:00 | MSFT | Stock | 243.18 | 243.285 | 242.28 | 242.35 | 956563.0 |
| 2021-02-08 10:30:00 | MSFT | Stock | 242.33 | 242.77 | 241.933 | 242.309 | 1000003.0 |
| 2021-02-08 11:00:00 | MSFT | Stock | 242.32 | 242.36 | 241.55 | 241.67 | 628844.0 |
| 2021-02-08 11:30:00 | MSFT | Stock | 241.66 | 241.66 | 240.81 | 241.47 | 897992.0 |
| 2021-02-08 12:00:00 | MSFT | Stock | 241.5 | 241.898 | 241.4 | 241.675 | 476287.0 |
| 2021-02-08 12:30:00 | MSFT | Stock | 241.666 | 241.95 | 241.342 | 241.51 | 491926.0 |
| 2021-02-08 13:00:00 | MSFT | Stock | 241.52 | 241.95 | 241.35 | 241.795 | 428571.0 |
> showing 50 of 124,503 rows — these rows as CSV