PREVIEW / stock_30min / 2021-02-04
file: by_date/stock_30min/2021/2021-02-04.parquet size: 2.3 MB rows: 118,714 symbols: 2,769
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-04 04:00:00 | AAPL | Stock | 136.38 | 136.38 | 135.4 | 136.15 | 50290.0 |
| 2021-02-04 04:30:00 | AAPL | Stock | 136.08 | 136.25 | 135.93 | 135.94 | 31899.0 |
| 2021-02-04 05:00:00 | AAPL | Stock | 135.94 | 136.21 | 135.93 | 136.0 | 10095.0 |
| 2021-02-04 05:30:00 | AAPL | Stock | 136.09 | 136.39 | 136.05 | 136.25 | 10868.0 |
| 2021-02-04 06:00:00 | AAPL | Stock | 136.26 | 136.62 | 136.26 | 136.61 | 43472.0 |
| 2021-02-04 06:30:00 | AAPL | Stock | 136.61 | 136.65 | 135.8 | 136.1 | 31143.0 |
| 2021-02-04 07:00:00 | AAPL | Stock | 136.21 | 136.85 | 136.1 | 136.18 | 299240.0 |
| 2021-02-04 07:30:00 | AAPL | Stock | 136.18 | 136.49 | 136.05 | 136.25 | 123940.0 |
| 2021-02-04 08:00:00 | AAPL | Stock | 136.4 | 136.85 | 134.27 | 136.32 | 383667.0 |
| 2021-02-04 08:30:00 | AAPL | Stock | 136.29 | 136.4 | 136.0 | 136.15 | 275620.0 |
| 2021-02-04 09:00:00 | AAPL | Stock | 136.17 | 136.75 | 136.02 | 136.34 | 638465.0 |
| 2021-02-04 09:30:00 | AAPL | Stock | 136.3 | 136.48 | 135.06 | 135.28 | 12621614.0 |
| 2021-02-04 10:00:00 | AAPL | Stock | 135.275 | 135.74 | 134.59 | 135.26 | 7515523.0 |
| 2021-02-04 10:30:00 | AAPL | Stock | 135.25 | 135.58 | 134.99 | 135.015 | 4205550.0 |
| 2021-02-04 11:00:00 | AAPL | Stock | 135.01 | 135.578 | 134.99 | 135.52 | 3985894.0 |
| 2021-02-04 11:30:00 | AAPL | Stock | 135.528 | 136.34 | 135.42 | 136.03 | 4141624.0 |
| 2021-02-04 12:00:00 | AAPL | Stock | 136.03 | 136.27 | 135.87 | 135.93 | 3285418.0 |
| 2021-02-04 12:30:00 | AAPL | Stock | 135.93 | 136.06 | 135.75 | 135.83 | 2432413.0 |
| 2021-02-04 13:00:00 | AAPL | Stock | 135.84 | 136.1 | 135.75 | 135.971 | 2033010.0 |
| 2021-02-04 13:30:00 | AAPL | Stock | 135.98 | 136.27 | 135.97 | 136.21 | 2259807.0 |
| 2021-02-04 14:00:00 | AAPL | Stock | 136.22 | 136.85 | 136.22 | 136.74 | 4338800.0 |
| 2021-02-04 14:30:00 | AAPL | Stock | 136.741 | 136.79 | 136.47 | 136.74 | 2741557.0 |
| 2021-02-04 15:00:00 | AAPL | Stock | 136.75 | 136.98 | 136.68 | 136.87 | 3984203.0 |
| 2021-02-04 15:30:00 | AAPL | Stock | 136.87 | 137.4 | 136.73 | 137.4 | 7655476.0 |
| 2021-02-04 16:00:00 | AAPL | Stock | 137.39 | 137.5 | 135.893 | 137.27 | 7971031.0 |
| 2021-02-04 16:30:00 | AAPL | Stock | 137.27 | 137.39 | 137.19 | 137.21 | 125142.0 |
| 2021-02-04 17:00:00 | AAPL | Stock | 137.21 | 137.3 | 137.1 | 137.1 | 99953.0 |
| 2021-02-04 17:30:00 | AAPL | Stock | 137.09 | 137.26 | 137.05 | 137.13 | 68732.0 |
| 2021-02-04 18:00:00 | AAPL | Stock | 137.2 | 137.27 | 137.15 | 137.21 | 44785.0 |
| 2021-02-04 18:30:00 | AAPL | Stock | 137.17 | 137.2 | 137.0 | 137.17 | 53226.0 |
| 2021-02-04 19:00:00 | AAPL | Stock | 137.18 | 137.21 | 137.11 | 137.21 | 45954.0 |
| 2021-02-04 19:30:00 | AAPL | Stock | 137.2 | 137.21 | 136.91 | 136.99 | 84462.0 |
| 2021-02-04 04:00:00 | MSFT | Stock | 243.5 | 243.5 | 243.0 | 243.3 | 3130.0 |
| 2021-02-04 04:30:00 | MSFT | Stock | 243.31 | 243.31 | 243.23 | 243.23 | 316.0 |
| 2021-02-04 05:00:00 | MSFT | Stock | 243.6 | 243.69 | 243.6 | 243.69 | 2748.0 |
| 2021-02-04 05:30:00 | MSFT | Stock | 243.71 | 243.91 | 243.67 | 243.91 | 1741.0 |
| 2021-02-04 06:30:00 | MSFT | Stock | 243.62 | 243.62 | 243.06 | 243.36 | 3938.0 |
| 2021-02-04 07:00:00 | MSFT | Stock | 243.16 | 243.5 | 243.08 | 243.22 | 8155.0 |
| 2021-02-04 07:30:00 | MSFT | Stock | 243.17 | 243.47 | 243.05 | 243.3 | 4106.0 |
| 2021-02-04 08:00:00 | MSFT | Stock | 243.45 | 243.81 | 242.4 | 243.79 | 14267.0 |
| 2021-02-04 08:30:00 | MSFT | Stock | 243.78 | 243.87 | 243.59 | 243.81 | 24821.0 |
| 2021-02-04 09:00:00 | MSFT | Stock | 243.65 | 244.15 | 242.81 | 242.81 | 18965.0 |
| 2021-02-04 09:30:00 | MSFT | Stock | 242.75 | 243.24 | 241.08 | 242.28 | 2867802.0 |
| 2021-02-04 10:00:00 | MSFT | Stock | 242.315 | 242.63 | 240.935 | 241.05 | 1391298.0 |
| 2021-02-04 10:30:00 | MSFT | Stock | 241.041 | 241.59 | 240.53 | 240.97 | 1543662.0 |
| 2021-02-04 11:00:00 | MSFT | Stock | 240.96 | 241.45 | 240.45 | 240.64 | 1312149.0 |
| 2021-02-04 11:30:00 | MSFT | Stock | 240.665 | 241.13 | 240.37 | 240.95 | 797567.0 |
| 2021-02-04 12:00:00 | MSFT | Stock | 240.98 | 241.18 | 240.43 | 240.615 | 730563.0 |
| 2021-02-04 12:30:00 | MSFT | Stock | 240.62 | 240.86 | 240.45 | 240.59 | 813856.0 |
| 2021-02-04 13:00:00 | MSFT | Stock | 240.58 | 241.24 | 240.41 | 240.81 | 841056.0 |
> showing 50 of 118,714 rows — these rows as CSV