PREVIEW / stock_30min / 2021-05-11
file: by_date/stock_30min/2021/2021-05-11.parquet size: 2.3 MB rows: 117,842 symbols: 3,009
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-05-11 04:00:00 | AAPL | Stock | 124.75 | 125.25 | 124.04 | 124.56 | 46757.0 |
| 2021-05-11 04:30:00 | AAPL | Stock | 124.47 | 125.08 | 124.4 | 124.77 | 34284.0 |
| 2021-05-11 05:00:00 | AAPL | Stock | 124.61 | 124.95 | 124.59 | 124.77 | 29710.0 |
| 2021-05-11 05:30:00 | AAPL | Stock | 124.77 | 125.0 | 124.55 | 124.74 | 33879.0 |
| 2021-05-11 06:00:00 | AAPL | Stock | 124.65 | 124.69 | 124.41 | 124.5 | 35024.0 |
| 2021-05-11 06:30:00 | AAPL | Stock | 124.45 | 124.67 | 124.12 | 124.53 | 49388.0 |
| 2021-05-11 07:00:00 | AAPL | Stock | 124.35 | 124.77 | 124.02 | 124.26 | 350143.0 |
| 2021-05-11 07:30:00 | AAPL | Stock | 124.26 | 124.32 | 123.7 | 123.7 | 261200.0 |
| 2021-05-11 08:00:00 | AAPL | Stock | 124.4 | 124.7696 | 123.29 | 123.33 | 649256.0 |
| 2021-05-11 08:30:00 | AAPL | Stock | 123.32 | 123.5 | 122.9 | 123.0 | 636472.0 |
| 2021-05-11 09:00:00 | AAPL | Stock | 123.0 | 126.85 | 122.88 | 123.49 | 3129886.0 |
| 2021-05-11 09:30:00 | AAPL | Stock | 123.5 | 124.8072 | 122.77 | 124.7085 | 18582014.0 |
| 2021-05-11 10:00:00 | AAPL | Stock | 124.71 | 124.72 | 123.38 | 123.46 | 9184271.0 |
| 2021-05-11 10:30:00 | AAPL | Stock | 123.45 | 124.37 | 123.26 | 124.24 | 8389342.0 |
| 2021-05-11 11:00:00 | AAPL | Stock | 124.24 | 125.2 | 123.9416 | 125.07 | 6995262.0 |
| 2021-05-11 11:30:00 | AAPL | Stock | 125.075 | 125.42 | 124.72 | 125.13 | 5586734.0 |
| 2021-05-11 12:00:00 | AAPL | Stock | 125.14 | 125.725 | 125.055 | 125.365 | 5451631.0 |
| 2021-05-11 12:30:00 | AAPL | Stock | 125.365 | 125.495 | 124.73 | 124.9595 | 4074336.0 |
| 2021-05-11 13:00:00 | AAPL | Stock | 124.95 | 125.87 | 124.885 | 125.7799 | 4056838.0 |
| 2021-05-11 13:30:00 | AAPL | Stock | 125.7764 | 126.1699 | 125.72 | 125.926 | 4599482.0 |
| 2021-05-11 14:00:00 | AAPL | Stock | 125.9299 | 126.27 | 125.5101 | 126.2201 | 4739483.0 |
| 2021-05-11 14:30:00 | AAPL | Stock | 126.22 | 126.22 | 125.605 | 125.735 | 4676661.0 |
| 2021-05-11 15:00:00 | AAPL | Stock | 125.73 | 126.22 | 125.54 | 125.965 | 4364952.0 |
| 2021-05-11 15:30:00 | AAPL | Stock | 125.9735 | 126.11 | 125.28 | 125.85 | 8823361.0 |
| 2021-05-11 16:00:00 | AAPL | Stock | 125.85 | 125.94 | 125.58 | 125.73 | 6568020.0 |
| 2021-05-11 16:30:00 | AAPL | Stock | 125.73 | 125.91 | 125.53 | 125.65 | 45637.0 |
| 2021-05-11 17:00:00 | AAPL | Stock | 125.65 | 126.85 | 125.5 | 125.64 | 35707.0 |
| 2021-05-11 17:30:00 | AAPL | Stock | 125.63 | 125.75 | 125.57 | 125.65 | 19676.0 |
| 2021-05-11 18:00:00 | AAPL | Stock | 125.65 | 125.88 | 125.62 | 125.7 | 22023.0 |
| 2021-05-11 18:30:00 | AAPL | Stock | 125.74 | 125.74 | 125.62 | 125.62 | 16788.0 |
| 2021-05-11 19:00:00 | AAPL | Stock | 125.64 | 125.65 | 125.45 | 125.56 | 17213.0 |
| 2021-05-11 19:30:00 | AAPL | Stock | 125.6 | 125.76 | 125.55 | 125.72 | 33032.0 |
| 2021-05-11 04:00:00 | MSFT | Stock | 243.66 | 243.9 | 243.21 | 243.26 | 13295.0 |
| 2021-05-11 04:30:00 | MSFT | Stock | 243.3 | 244.05 | 243.29 | 243.74 | 4153.0 |
| 2021-05-11 05:00:00 | MSFT | Stock | 244.18 | 244.47 | 244.0 | 244.32 | 8897.0 |
| 2021-05-11 05:30:00 | MSFT | Stock | 244.3 | 244.49 | 243.91 | 244.3 | 5289.0 |
| 2021-05-11 06:00:00 | MSFT | Stock | 243.89 | 244.28 | 243.81 | 244.27 | 3295.0 |
| 2021-05-11 06:30:00 | MSFT | Stock | 244.01 | 244.46 | 243.64 | 244.34 | 15524.0 |
| 2021-05-11 07:00:00 | MSFT | Stock | 244.34 | 244.97 | 243.65 | 244.86 | 54182.0 |
| 2021-05-11 07:30:00 | MSFT | Stock | 244.83 | 245.88 | 244.05 | 244.15 | 44909.0 |
| 2021-05-11 08:00:00 | MSFT | Stock | 244.24 | 245.44 | 243.7 | 244.39 | 77089.0 |
| 2021-05-11 08:30:00 | MSFT | Stock | 244.3 | 245.5 | 244.3 | 244.51 | 53809.0 |
| 2021-05-11 09:00:00 | MSFT | Stock | 244.51 | 247.18 | 244.1 | 244.2 | 139704.0 |
| 2021-05-11 09:30:00 | MSFT | Stock | 244.4 | 245.67 | 242.57 | 244.82 | 4000795.0 |
| 2021-05-11 10:00:00 | MSFT | Stock | 244.82 | 245.7797 | 244.12 | 244.595 | 2100648.0 |
| 2021-05-11 10:30:00 | MSFT | Stock | 244.59 | 245.27 | 243.87 | 245.19 | 1545311.0 |
| 2021-05-11 11:00:00 | MSFT | Stock | 245.16 | 246.38 | 244.18 | 246.38 | 1522579.0 |
| 2021-05-11 11:30:00 | MSFT | Stock | 246.39 | 246.6 | 245.3625 | 245.94 | 1031306.0 |
| 2021-05-11 12:00:00 | MSFT | Stock | 245.98 | 246.48 | 245.54 | 245.69 | 827385.0 |
| 2021-05-11 12:30:00 | MSFT | Stock | 245.7 | 245.78 | 244.66 | 245.05 | 934955.0 |
> showing 50 of 117,842 rows — these rows as CSV