PREVIEW / stock_30min / 2021-03-16
file: by_date/stock_30min/2021/2021-03-16.parquet size: 2.3 MB rows: 116,254 symbols: 2,901
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-03-16 04:00:00 | AAPL | Stock | 124.66 | 124.99 | 124.4 | 124.94 | 21762.0 |
| 2021-03-16 04:30:00 | AAPL | Stock | 124.88 | 124.9 | 124.67 | 124.67 | 11032.0 |
| 2021-03-16 05:00:00 | AAPL | Stock | 124.72 | 124.99 | 124.72 | 124.89 | 13425.0 |
| 2021-03-16 05:30:00 | AAPL | Stock | 124.98 | 125.2 | 124.98 | 125.05 | 30284.0 |
| 2021-03-16 06:00:00 | AAPL | Stock | 125.07 | 125.15 | 124.86 | 124.94 | 18902.0 |
| 2021-03-16 06:30:00 | AAPL | Stock | 124.98 | 125.28 | 124.98 | 125.18 | 21621.0 |
| 2021-03-16 07:00:00 | AAPL | Stock | 125.13 | 125.25 | 124.82 | 125.17 | 189475.0 |
| 2021-03-16 07:30:00 | AAPL | Stock | 125.17 | 125.24 | 125.02 | 125.21 | 95385.0 |
| 2021-03-16 08:00:00 | AAPL | Stock | 124.975 | 125.35 | 124.299 | 125.33 | 318755.0 |
| 2021-03-16 08:30:00 | AAPL | Stock | 125.33 | 125.75 | 125.01 | 125.53 | 389796.0 |
| 2021-03-16 09:00:00 | AAPL | Stock | 125.52 | 126.08 | 125.5 | 125.71 | 677040.0 |
| 2021-03-16 09:30:00 | AAPL | Stock | 125.71 | 126.64 | 125.08 | 126.52 | 16522339.0 |
| 2021-03-16 10:00:00 | AAPL | Stock | 126.5198 | 126.84 | 126.06 | 126.41 | 8969282.0 |
| 2021-03-16 10:30:00 | AAPL | Stock | 126.42 | 127.22 | 126.2501 | 126.935 | 8600357.0 |
| 2021-03-16 11:00:00 | AAPL | Stock | 126.93 | 127.055 | 126.49 | 126.755 | 6649190.0 |
| 2021-03-16 11:30:00 | AAPL | Stock | 126.76 | 126.9 | 126.16 | 126.225 | 5428124.0 |
| 2021-03-16 12:00:00 | AAPL | Stock | 126.23 | 126.33 | 125.33 | 125.46 | 7462471.0 |
| 2021-03-16 12:30:00 | AAPL | Stock | 125.46 | 126.14 | 125.4208 | 125.8501 | 5675225.0 |
| 2021-03-16 13:00:00 | AAPL | Stock | 125.857 | 126.28 | 125.8 | 125.8402 | 4510920.0 |
| 2021-03-16 13:30:00 | AAPL | Stock | 125.845 | 125.8584 | 125.33 | 125.635 | 4502743.0 |
| 2021-03-16 14:00:00 | AAPL | Stock | 125.63 | 125.835 | 124.91 | 125.011 | 6127697.0 |
| 2021-03-16 14:30:00 | AAPL | Stock | 125.02 | 125.39 | 124.715 | 125.33 | 6031027.0 |
| 2021-03-16 15:00:00 | AAPL | Stock | 125.335 | 125.74 | 125.235 | 125.6117 | 4774193.0 |
| 2021-03-16 15:30:00 | AAPL | Stock | 125.62 | 125.9284 | 125.39 | 125.57 | 7862095.0 |
| 2021-03-16 16:00:00 | AAPL | Stock | 125.57 | 125.7 | 125.5 | 125.62 | 5911457.0 |
| 2021-03-16 16:30:00 | AAPL | Stock | 125.6 | 125.62 | 125.48 | 125.5 | 51550.0 |
| 2021-03-16 17:00:00 | AAPL | Stock | 125.5 | 125.53 | 125.31 | 125.35 | 53943.0 |
| 2021-03-16 17:30:00 | AAPL | Stock | 125.36 | 125.57 | 125.32 | 125.55 | 54472.0 |
| 2021-03-16 18:00:00 | AAPL | Stock | 125.56 | 125.62 | 125.5 | 125.59 | 59140.0 |
| 2021-03-16 18:30:00 | AAPL | Stock | 125.6 | 125.6 | 125.5 | 125.51 | 28968.0 |
| 2021-03-16 19:00:00 | AAPL | Stock | 125.51 | 125.6 | 125.35 | 125.4 | 21069.0 |
| 2021-03-16 19:30:00 | AAPL | Stock | 125.36 | 125.38 | 125.1 | 125.23 | 86665.0 |
| 2021-03-16 04:30:00 | MSFT | Stock | 235.07 | 235.07 | 235.07 | 235.07 | 100.0 |
| 2021-03-16 05:00:00 | MSFT | Stock | 235.11 | 235.28 | 235.07 | 235.28 | 624.0 |
| 2021-03-16 06:00:00 | MSFT | Stock | 235.46 | 235.46 | 235.46 | 235.46 | 140.0 |
| 2021-03-16 06:30:00 | MSFT | Stock | 235.31 | 235.64 | 235.27 | 235.64 | 1322.0 |
| 2021-03-16 07:00:00 | MSFT | Stock | 235.51 | 235.6 | 235.26 | 235.6 | 5161.0 |
| 2021-03-16 07:30:00 | MSFT | Stock | 235.64 | 235.8 | 235.64 | 235.69 | 4476.0 |
| 2021-03-16 08:00:00 | MSFT | Stock | 235.43 | 235.82 | 234.223 | 235.8 | 8180.0 |
| 2021-03-16 08:30:00 | MSFT | Stock | 235.56 | 235.8 | 235.22 | 235.7 | 10292.0 |
| 2021-03-16 09:00:00 | MSFT | Stock | 235.57 | 236.48 | 234.81 | 236.38 | 70324.0 |
| 2021-03-16 09:30:00 | MSFT | Stock | 236.3 | 238.31 | 235.94 | 238.3079 | 2413223.0 |
| 2021-03-16 10:00:00 | MSFT | Stock | 238.3 | 239.24 | 238.15 | 239.13 | 1614404.0 |
| 2021-03-16 10:30:00 | MSFT | Stock | 239.14 | 239.85 | 238.91 | 239.56 | 1698392.0 |
| 2021-03-16 11:00:00 | MSFT | Stock | 239.56 | 239.91 | 239.28 | 239.77 | 1195725.0 |
| 2021-03-16 11:30:00 | MSFT | Stock | 239.775 | 240.055 | 239.32 | 239.57 | 1172229.0 |
| 2021-03-16 12:00:00 | MSFT | Stock | 239.59 | 239.845 | 238.57 | 238.9681 | 1144712.0 |
| 2021-03-16 12:30:00 | MSFT | Stock | 238.96 | 239.75 | 238.85 | 238.89 | 1292442.0 |
| 2021-03-16 13:00:00 | MSFT | Stock | 238.872 | 239.48 | 238.872 | 239.08 | 963702.0 |
| 2021-03-16 13:30:00 | MSFT | Stock | 239.08 | 239.13 | 237.73 | 238.019 | 805912.0 |
> showing 50 of 116,254 rows — these rows as CSV