PREVIEW / stock_30min / 2020-11-27
file: by_date/stock_30min/2020/2020-11-27.parquet size: 1.4 MB rows: 67,325 symbols: 2,578
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 |
|---|---|---|---|---|---|---|---|
| 2020-11-27 04:00:00 | AAPL | Stock | 116.8 | 116.95 | 116.51 | 116.89 | 10540.0 |
| 2020-11-27 04:30:00 | AAPL | Stock | 116.92 | 116.98 | 116.81 | 116.86 | 7280.0 |
| 2020-11-27 05:00:00 | AAPL | Stock | 116.8 | 116.83 | 116.77 | 116.77 | 2275.0 |
| 2020-11-27 05:30:00 | AAPL | Stock | 116.74 | 116.87 | 116.74 | 116.87 | 2106.0 |
| 2020-11-27 06:00:00 | AAPL | Stock | 116.9 | 116.98 | 116.83 | 116.94 | 4191.0 |
| 2020-11-27 06:30:00 | AAPL | Stock | 116.84 | 116.9 | 116.84 | 116.89 | 4701.0 |
| 2020-11-27 07:00:00 | AAPL | Stock | 116.86 | 116.96 | 116.74 | 116.78 | 49655.0 |
| 2020-11-27 07:30:00 | AAPL | Stock | 116.76 | 116.8 | 116.6 | 116.7 | 76938.0 |
| 2020-11-27 08:00:00 | AAPL | Stock | 116.74 | 116.96 | 116.6 | 116.75 | 164749.0 |
| 2020-11-27 08:30:00 | AAPL | Stock | 116.77 | 116.98 | 116.76 | 116.88 | 144420.0 |
| 2020-11-27 09:00:00 | AAPL | Stock | 116.88 | 116.96 | 116.3 | 116.56 | 216056.0 |
| 2020-11-27 09:30:00 | AAPL | Stock | 116.57 | 117.3 | 116.47 | 116.98 | 9932989.0 |
| 2020-11-27 10:00:00 | AAPL | Stock | 116.99 | 117.26 | 116.675 | 117.225 | 5647903.0 |
| 2020-11-27 10:30:00 | AAPL | Stock | 117.22 | 117.49 | 116.848 | 117.07 | 5697517.0 |
| 2020-11-27 11:00:00 | AAPL | Stock | 117.06 | 117.18 | 116.825 | 117.03 | 3858416.0 |
| 2020-11-27 11:30:00 | AAPL | Stock | 117.04 | 117.15 | 116.66 | 116.86 | 3670707.0 |
| 2020-11-27 12:00:00 | AAPL | Stock | 116.868 | 116.92 | 116.31 | 116.52 | 3826048.0 |
| 2020-11-27 12:30:00 | AAPL | Stock | 116.52 | 116.6 | 116.22 | 116.6 | 5540405.0 |
| 2020-11-27 13:00:00 | AAPL | Stock | 116.65 | 116.65 | 116.4 | 116.5 | 2426841.0 |
| 2020-11-27 13:30:00 | AAPL | Stock | 116.5 | 116.54 | 116.4 | 116.45 | 45524.0 |
| 2020-11-27 14:00:00 | AAPL | Stock | 116.42 | 116.52 | 116.42 | 116.49 | 34594.0 |
| 2020-11-27 14:30:00 | AAPL | Stock | 116.48 | 116.59 | 116.35 | 116.46 | 36363.0 |
| 2020-11-27 15:00:00 | AAPL | Stock | 116.43 | 116.55 | 116.41 | 116.44 | 27470.0 |
| 2020-11-27 15:30:00 | AAPL | Stock | 116.44 | 116.49 | 116.42 | 116.455 | 24045.0 |
| 2020-11-27 16:00:00 | AAPL | Stock | 116.46 | 116.53 | 116.44 | 116.5 | 20433.0 |
| 2020-11-27 16:30:00 | AAPL | Stock | 116.51 | 116.51 | 116.44 | 116.44 | 12303.0 |
| 2020-11-27 04:00:00 | MSFT | Stock | 214.61 | 214.75 | 214.61 | 214.75 | 2093.0 |
| 2020-11-27 05:00:00 | MSFT | Stock | 214.75 | 214.75 | 214.75 | 214.75 | 360.0 |
| 2020-11-27 05:30:00 | MSFT | Stock | 214.69 | 214.69 | 214.69 | 214.69 | 350.0 |
| 2020-11-27 07:00:00 | MSFT | Stock | 214.77 | 214.92 | 214.4 | 214.6 | 5503.0 |
| 2020-11-27 07:30:00 | MSFT | Stock | 214.5 | 214.65 | 214.45 | 214.65 | 6115.0 |
| 2020-11-27 08:00:00 | MSFT | Stock | 214.75 | 214.828 | 213.34 | 214.69 | 13964.0 |
| 2020-11-27 08:30:00 | MSFT | Stock | 214.7 | 215.2 | 214.69 | 214.95 | 19719.0 |
| 2020-11-27 09:00:00 | MSFT | Stock | 214.801 | 215.22 | 214.3 | 214.6 | 26627.0 |
| 2020-11-27 09:30:00 | MSFT | Stock | 214.85 | 215.2 | 214.04 | 214.42 | 1909515.0 |
| 2020-11-27 10:00:00 | MSFT | Stock | 214.42 | 215.97 | 214.41 | 215.62 | 1583946.0 |
| 2020-11-27 10:30:00 | MSFT | Stock | 215.63 | 216.27 | 215.59 | 215.82 | 1143596.0 |
| 2020-11-27 11:00:00 | MSFT | Stock | 215.82 | 216.19 | 215.77 | 216.03 | 1083130.0 |
| 2020-11-27 11:30:00 | MSFT | Stock | 216.04 | 216.15 | 214.93 | 215.08 | 976791.0 |
| 2020-11-27 12:00:00 | MSFT | Stock | 215.08 | 215.46 | 214.7 | 215.049 | 1031662.0 |
| 2020-11-27 12:30:00 | MSFT | Stock | 215.03 | 215.49 | 214.87 | 215.29 | 1431412.0 |
| 2020-11-27 13:00:00 | MSFT | Stock | 215.35 | 215.39 | 214.88 | 215.17 | 2293388.0 |
| 2020-11-27 13:30:00 | MSFT | Stock | 215.19 | 215.3 | 215.13 | 215.2 | 2866.0 |
| 2020-11-27 14:00:00 | MSFT | Stock | 215.012 | 215.15 | 215.0 | 215.05 | 990.0 |
| 2020-11-27 14:30:00 | MSFT | Stock | 215.17 | 215.18 | 215.12 | 215.12 | 3099.0 |
| 2020-11-27 15:00:00 | MSFT | Stock | 215.16 | 215.2 | 215.15 | 215.2 | 851.0 |
| 2020-11-27 15:30:00 | MSFT | Stock | 215.15 | 215.2 | 215.15 | 215.15 | 1409.0 |
| 2020-11-27 16:00:00 | MSFT | Stock | 215.12 | 215.23 | 215.12 | 215.23 | 1511.0 |
| 2020-11-27 16:30:00 | MSFT | Stock | 215.2 | 215.24 | 215.01 | 215.24 | 2913.0 |
| 2020-11-27 05:00:00 | NVDA | Stock | 13.265 | 13.265 | 13.265 | 13.265 | 8000.0 |
> showing 50 of 67,325 rows — these rows as CSV