PREVIEW / stock_30min / 2020-12-31
file: by_date/stock_30min/2020/2020-12-31.parquet size: 2.1 MB rows: 107,808 symbols: 2,685
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-12-31 04:00:00 | AAPL | Stock | 133.81 | 133.81 | 133.38 | 133.38 | 3672.0 |
| 2020-12-31 04:30:00 | AAPL | Stock | 133.38 | 133.43 | 133.38 | 133.43 | 632.0 |
| 2020-12-31 05:00:00 | AAPL | Stock | 133.61 | 133.72 | 133.53 | 133.53 | 1731.0 |
| 2020-12-31 05:30:00 | AAPL | Stock | 133.53 | 133.72 | 133.53 | 133.72 | 1331.0 |
| 2020-12-31 06:00:00 | AAPL | Stock | 133.71 | 133.8 | 133.71 | 133.8 | 2063.0 |
| 2020-12-31 06:30:00 | AAPL | Stock | 133.81 | 133.99 | 133.8 | 133.97 | 2953.0 |
| 2020-12-31 07:00:00 | AAPL | Stock | 133.82 | 134.65 | 133.82 | 134.38 | 178892.0 |
| 2020-12-31 07:30:00 | AAPL | Stock | 134.401 | 134.58 | 134.25 | 134.38 | 85894.0 |
| 2020-12-31 08:00:00 | AAPL | Stock | 134.298 | 134.65 | 133.9 | 134.35 | 377909.0 |
| 2020-12-31 08:30:00 | AAPL | Stock | 134.32 | 134.45 | 134.3 | 134.35 | 122889.0 |
| 2020-12-31 09:00:00 | AAPL | Stock | 134.35 | 134.39 | 133.91 | 134.04 | 239282.0 |
| 2020-12-31 09:30:00 | AAPL | Stock | 134.08 | 134.74 | 133.19 | 133.435 | 11269949.0 |
| 2020-12-31 10:00:00 | AAPL | Stock | 133.44 | 133.6 | 132.65 | 132.885 | 7912459.0 |
| 2020-12-31 10:30:00 | AAPL | Stock | 132.881 | 133.3 | 132.79 | 133.127 | 4896101.0 |
| 2020-12-31 11:00:00 | AAPL | Stock | 133.13 | 133.14 | 132.45 | 132.53 | 4870062.0 |
| 2020-12-31 11:30:00 | AAPL | Stock | 132.53 | 132.76 | 131.892 | 131.95 | 5573875.0 |
| 2020-12-31 12:00:00 | AAPL | Stock | 131.96 | 132.8 | 131.72 | 132.62 | 6252401.0 |
| 2020-12-31 12:30:00 | AAPL | Stock | 132.62 | 132.718 | 132.37 | 132.425 | 3473145.0 |
| 2020-12-31 13:00:00 | AAPL | Stock | 132.43 | 132.63 | 132.31 | 132.561 | 2873015.0 |
| 2020-12-31 13:30:00 | AAPL | Stock | 132.565 | 132.585 | 132.09 | 132.1 | 3180938.0 |
| 2020-12-31 14:00:00 | AAPL | Stock | 132.101 | 132.89 | 132.01 | 132.765 | 5192421.0 |
| 2020-12-31 14:30:00 | AAPL | Stock | 132.77 | 133.1 | 132.65 | 132.991 | 4675905.0 |
| 2020-12-31 15:00:00 | AAPL | Stock | 132.995 | 133.18 | 132.566 | 132.8 | 4363098.0 |
| 2020-12-31 15:30:00 | AAPL | Stock | 132.795 | 133.33 | 132.45 | 132.58 | 10793950.0 |
| 2020-12-31 16:00:00 | AAPL | Stock | 132.69 | 132.99 | 132.65 | 132.74 | 11028025.0 |
| 2020-12-31 16:30:00 | AAPL | Stock | 132.73 | 132.73 | 132.57 | 132.62 | 90016.0 |
| 2020-12-31 17:00:00 | AAPL | Stock | 132.63 | 132.68 | 132.57 | 132.57 | 53873.0 |
| 2020-12-31 17:30:00 | AAPL | Stock | 132.57 | 132.63 | 132.55 | 132.6 | 48991.0 |
| 2020-12-31 18:00:00 | AAPL | Stock | 132.6 | 132.62 | 132.57 | 132.59 | 17139.0 |
| 2020-12-31 18:30:00 | AAPL | Stock | 132.58 | 132.69 | 132.58 | 132.68 | 18161.0 |
| 2020-12-31 19:00:00 | AAPL | Stock | 132.69 | 132.74 | 132.65 | 132.74 | 31613.0 |
| 2020-12-31 19:30:00 | AAPL | Stock | 132.72 | 132.8 | 132.7 | 132.71 | 45845.0 |
| 2020-12-31 04:00:00 | MSFT | Stock | 221.9 | 221.9 | 221.85 | 221.85 | 600.0 |
| 2020-12-31 04:30:00 | MSFT | Stock | 222.45 | 222.45 | 222.45 | 222.45 | 108.0 |
| 2020-12-31 05:00:00 | MSFT | Stock | 222.54 | 222.68 | 222.54 | 222.68 | 252.0 |
| 2020-12-31 06:30:00 | MSFT | Stock | 222.35 | 222.35 | 222.35 | 222.35 | 111.0 |
| 2020-12-31 07:00:00 | MSFT | Stock | 222.05 | 222.11 | 221.86 | 221.86 | 3209.0 |
| 2020-12-31 07:30:00 | MSFT | Stock | 221.86 | 221.88 | 221.69 | 221.88 | 2746.0 |
| 2020-12-31 08:00:00 | MSFT | Stock | 222.262 | 222.28 | 221.48 | 221.65 | 17204.0 |
| 2020-12-31 08:30:00 | MSFT | Stock | 221.65 | 221.8 | 221.65 | 221.67 | 5405.0 |
| 2020-12-31 09:00:00 | MSFT | Stock | 221.67 | 221.8 | 220.97 | 221.8 | 46890.0 |
| 2020-12-31 09:30:00 | MSFT | Stock | 221.65 | 222.5 | 221.45 | 221.493 | 1826502.0 |
| 2020-12-31 10:00:00 | MSFT | Stock | 221.5 | 221.83 | 221.28 | 221.5 | 903494.0 |
| 2020-12-31 10:30:00 | MSFT | Stock | 221.505 | 221.615 | 220.63 | 220.652 | 664096.0 |
| 2020-12-31 11:00:00 | MSFT | Stock | 220.65 | 220.88 | 220.23 | 220.28 | 694865.0 |
| 2020-12-31 11:30:00 | MSFT | Stock | 220.275 | 220.46 | 219.68 | 219.74 | 852514.0 |
| 2020-12-31 12:00:00 | MSFT | Stock | 219.75 | 220.0 | 219.75 | 219.91 | 610150.0 |
| 2020-12-31 12:30:00 | MSFT | Stock | 219.915 | 220.34 | 219.8 | 220.18 | 480644.0 |
| 2020-12-31 13:00:00 | MSFT | Stock | 220.18 | 220.406 | 219.972 | 220.285 | 455928.0 |
| 2020-12-31 13:30:00 | MSFT | Stock | 220.287 | 220.287 | 219.94 | 220.04 | 462282.0 |
> showing 50 of 107,808 rows — these rows as CSV