PREVIEW / stock_30min / 2020-12-22
file: by_date/stock_30min/2020/2020-12-22.parquet size: 2.2 MB rows: 111,864 symbols: 2,683
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-22 04:00:00 | AAPL | Stock | 130.7 | 131.94 | 130.69 | 131.58 | 134973.0 |
| 2020-12-22 04:30:00 | AAPL | Stock | 131.5 | 131.94 | 131.24 | 131.81 | 37202.0 |
| 2020-12-22 05:00:00 | AAPL | Stock | 131.82 | 131.98 | 131.66 | 131.73 | 40666.0 |
| 2020-12-22 05:30:00 | AAPL | Stock | 131.66 | 131.69 | 131.14 | 131.39 | 26766.0 |
| 2020-12-22 06:00:00 | AAPL | Stock | 131.38 | 131.83 | 131.38 | 131.83 | 20313.0 |
| 2020-12-22 06:30:00 | AAPL | Stock | 131.81 | 131.9 | 131.25 | 131.55 | 46777.0 |
| 2020-12-22 07:00:00 | AAPL | Stock | 131.55 | 132.5 | 131.4 | 132.13 | 862820.0 |
| 2020-12-22 07:30:00 | AAPL | Stock | 132.13 | 132.19 | 131.75 | 131.85 | 383963.0 |
| 2020-12-22 08:00:00 | AAPL | Stock | 131.915 | 132.47 | 130.58 | 131.88 | 879797.0 |
| 2020-12-22 08:30:00 | AAPL | Stock | 131.89 | 132.36 | 131.86 | 132.16 | 755255.0 |
| 2020-12-22 09:00:00 | AAPL | Stock | 132.17 | 132.28 | 131.5 | 131.56 | 1241882.0 |
| 2020-12-22 09:30:00 | AAPL | Stock | 131.59 | 134.25 | 130.4 | 134.13 | 36705925.0 |
| 2020-12-22 10:00:00 | AAPL | Stock | 134.12 | 134.405 | 132.8 | 133.132 | 19032881.0 |
| 2020-12-22 10:30:00 | AAPL | Stock | 133.13 | 133.42 | 132.28 | 132.879 | 9555284.0 |
| 2020-12-22 11:00:00 | AAPL | Stock | 132.875 | 132.895 | 131.0 | 131.685 | 9981618.0 |
| 2020-12-22 11:30:00 | AAPL | Stock | 131.69 | 131.69 | 129.65 | 131.475 | 12064648.0 |
| 2020-12-22 12:00:00 | AAPL | Stock | 131.475 | 132.17 | 131.04 | 131.58 | 9093855.0 |
| 2020-12-22 12:30:00 | AAPL | Stock | 131.586 | 132.36 | 131.46 | 131.992 | 5896724.0 |
| 2020-12-22 13:00:00 | AAPL | Stock | 132.0 | 132.95 | 131.97 | 132.699 | 5869414.0 |
| 2020-12-22 13:30:00 | AAPL | Stock | 132.69 | 133.15 | 132.38 | 132.755 | 6024794.0 |
| 2020-12-22 14:00:00 | AAPL | Stock | 132.76 | 132.99 | 132.29 | 132.645 | 5340300.0 |
| 2020-12-22 14:30:00 | AAPL | Stock | 132.65 | 132.65 | 131.89 | 132.041 | 5211188.0 |
| 2020-12-22 15:00:00 | AAPL | Stock | 132.05 | 132.32 | 131.63 | 131.73 | 5025493.0 |
| 2020-12-22 15:30:00 | AAPL | Stock | 131.72 | 131.88 | 131.222 | 131.845 | 9639466.0 |
| 2020-12-22 16:00:00 | AAPL | Stock | 131.88 | 131.89 | 131.5 | 131.5 | 7146436.0 |
| 2020-12-22 16:30:00 | AAPL | Stock | 131.53 | 131.74 | 131.5 | 131.71 | 79850.0 |
| 2020-12-22 17:00:00 | AAPL | Stock | 131.71 | 131.74 | 131.52 | 131.55 | 66060.0 |
| 2020-12-22 17:30:00 | AAPL | Stock | 131.58 | 131.88 | 131.56 | 131.67 | 500620.0 |
| 2020-12-22 18:00:00 | AAPL | Stock | 131.68 | 131.88 | 131.66 | 131.76 | 575395.0 |
| 2020-12-22 18:30:00 | AAPL | Stock | 131.73 | 131.8 | 131.53 | 131.8 | 70971.0 |
| 2020-12-22 19:00:00 | AAPL | Stock | 131.73 | 131.8 | 131.5 | 131.51 | 80146.0 |
| 2020-12-22 19:30:00 | AAPL | Stock | 131.51 | 131.52 | 130.23 | 130.33 | 222155.0 |
| 2020-12-22 04:00:00 | MSFT | Stock | 222.4 | 223.22 | 222.4 | 223.03 | 2639.0 |
| 2020-12-22 04:30:00 | MSFT | Stock | 223.12 | 223.12 | 222.85 | 222.85 | 1426.0 |
| 2020-12-22 05:00:00 | MSFT | Stock | 222.8 | 222.86 | 222.8 | 222.86 | 452.0 |
| 2020-12-22 05:30:00 | MSFT | Stock | 222.7 | 222.7 | 222.7 | 222.7 | 100.0 |
| 2020-12-22 06:00:00 | MSFT | Stock | 222.72 | 223.35 | 222.7 | 223.1 | 1411.0 |
| 2020-12-22 06:30:00 | MSFT | Stock | 222.95 | 223.04 | 222.81 | 223.0 | 2190.0 |
| 2020-12-22 07:00:00 | MSFT | Stock | 223.04 | 223.25 | 222.94 | 223.25 | 6079.0 |
| 2020-12-22 07:30:00 | MSFT | Stock | 223.25 | 223.72 | 223.0 | 223.31 | 17641.0 |
| 2020-12-22 08:00:00 | MSFT | Stock | 223.512 | 223.75 | 222.36 | 222.85 | 24387.0 |
| 2020-12-22 08:30:00 | MSFT | Stock | 222.8 | 223.4 | 222.8 | 222.95 | 31846.0 |
| 2020-12-22 09:00:00 | MSFT | Stock | 222.86 | 223.11 | 222.33 | 222.55 | 33617.0 |
| 2020-12-22 09:30:00 | MSFT | Stock | 222.57 | 225.63 | 221.85 | 225.3 | 3760891.0 |
| 2020-12-22 10:00:00 | MSFT | Stock | 225.305 | 225.305 | 223.45 | 224.056 | 1648156.0 |
| 2020-12-22 10:30:00 | MSFT | Stock | 224.062 | 224.75 | 223.78 | 224.16 | 1086366.0 |
| 2020-12-22 11:00:00 | MSFT | Stock | 224.154 | 224.57 | 223.63 | 224.33 | 890188.0 |
| 2020-12-22 11:30:00 | MSFT | Stock | 224.36 | 224.36 | 223.12 | 223.72 | 1206410.0 |
| 2020-12-22 12:00:00 | MSFT | Stock | 223.74 | 224.43 | 223.66 | 224.11 | 604440.0 |
| 2020-12-22 12:30:00 | MSFT | Stock | 224.12 | 224.46 | 224.085 | 224.28 | 461977.0 |
> showing 50 of 111,864 rows — these rows as CSV