PREVIEW / stock_30min / 2021-01-21
file: by_date/stock_30min/2021/2021-01-21.parquet size: 2.3 MB rows: 114,555 symbols: 2,694
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-01-21 04:00:00 | AAPL | Stock | 133.2 | 133.41 | 133.0 | 133.25 | 18646.0 |
| 2021-01-21 04:30:00 | AAPL | Stock | 133.2 | 133.66 | 133.12 | 133.56 | 23046.0 |
| 2021-01-21 05:00:00 | AAPL | Stock | 133.56 | 133.65 | 133.24 | 133.49 | 20100.0 |
| 2021-01-21 05:30:00 | AAPL | Stock | 133.44 | 133.65 | 133.34 | 133.5 | 16501.0 |
| 2021-01-21 06:00:00 | AAPL | Stock | 133.51 | 133.89 | 133.51 | 133.6 | 16373.0 |
| 2021-01-21 06:30:00 | AAPL | Stock | 133.6 | 133.75 | 133.56 | 133.61 | 44427.0 |
| 2021-01-21 07:00:00 | AAPL | Stock | 133.68 | 134.0 | 133.57 | 133.75 | 235387.0 |
| 2021-01-21 07:30:00 | AAPL | Stock | 133.8 | 134.09 | 133.7 | 134.05 | 175662.0 |
| 2021-01-21 08:00:00 | AAPL | Stock | 133.95 | 134.14 | 133.66 | 134.14 | 350945.0 |
| 2021-01-21 08:30:00 | AAPL | Stock | 134.13 | 134.31 | 133.5 | 133.64 | 600289.0 |
| 2021-01-21 09:00:00 | AAPL | Stock | 133.63 | 134.0 | 133.55 | 133.84 | 458381.0 |
| 2021-01-21 09:30:00 | AAPL | Stock | 133.82 | 135.08 | 133.59 | 134.878 | 20218771.0 |
| 2021-01-21 10:00:00 | AAPL | Stock | 134.86 | 135.98 | 134.8 | 135.86 | 11740697.0 |
| 2021-01-21 10:30:00 | AAPL | Stock | 135.859 | 136.35 | 135.35 | 135.985 | 8675122.0 |
| 2021-01-21 11:00:00 | AAPL | Stock | 135.985 | 136.38 | 135.84 | 136.182 | 6584789.0 |
| 2021-01-21 11:30:00 | AAPL | Stock | 136.185 | 136.27 | 135.56 | 136.07 | 5304476.0 |
| 2021-01-21 12:00:00 | AAPL | Stock | 136.08 | 136.12 | 135.21 | 135.85 | 5027121.0 |
| 2021-01-21 12:30:00 | AAPL | Stock | 135.86 | 136.2 | 135.63 | 136.165 | 4211649.0 |
| 2021-01-21 13:00:00 | AAPL | Stock | 136.17 | 136.34 | 136.09 | 136.22 | 3092250.0 |
| 2021-01-21 13:30:00 | AAPL | Stock | 136.23 | 136.48 | 135.913 | 136.125 | 4103919.0 |
| 2021-01-21 14:00:00 | AAPL | Stock | 136.13 | 136.65 | 136.095 | 136.562 | 3969903.0 |
| 2021-01-21 14:30:00 | AAPL | Stock | 136.57 | 136.7 | 136.36 | 136.535 | 3552915.0 |
| 2021-01-21 15:00:00 | AAPL | Stock | 136.535 | 136.99 | 136.45 | 136.83 | 4989725.0 |
| 2021-01-21 15:30:00 | AAPL | Stock | 136.83 | 139.67 | 136.79 | 136.87 | 10963733.0 |
| 2021-01-21 16:00:00 | AAPL | Stock | 136.86 | 137.03 | 136.7 | 136.9 | 10017780.0 |
| 2021-01-21 16:30:00 | AAPL | Stock | 136.9 | 137.36 | 136.88 | 137.3 | 122772.0 |
| 2021-01-21 17:00:00 | AAPL | Stock | 137.3 | 137.48 | 137.15 | 137.45 | 128827.0 |
| 2021-01-21 17:30:00 | AAPL | Stock | 137.45 | 137.5 | 136.99 | 137.07 | 181296.0 |
| 2021-01-21 18:00:00 | AAPL | Stock | 137.1 | 137.15 | 136.51 | 136.84 | 171801.0 |
| 2021-01-21 18:30:00 | AAPL | Stock | 136.8 | 136.94 | 136.4 | 136.46 | 111703.0 |
| 2021-01-21 19:00:00 | AAPL | Stock | 136.49 | 136.78 | 136.45 | 136.6 | 67653.0 |
| 2021-01-21 19:30:00 | AAPL | Stock | 136.56 | 136.7 | 136.32 | 136.38 | 139387.0 |
| 2021-01-21 04:00:00 | MSFT | Stock | 224.88 | 224.88 | 223.92 | 223.92 | 16067.0 |
| 2021-01-21 04:30:00 | MSFT | Stock | 223.9 | 223.9 | 223.3 | 223.3 | 6115.0 |
| 2021-01-21 05:00:00 | MSFT | Stock | 223.3 | 223.41 | 223.3 | 223.4 | 8812.0 |
| 2021-01-21 05:30:00 | MSFT | Stock | 223.8 | 223.8 | 223.8 | 223.8 | 1311.0 |
| 2021-01-21 06:00:00 | MSFT | Stock | 223.8 | 224.0 | 223.51 | 223.97 | 4748.0 |
| 2021-01-21 06:30:00 | MSFT | Stock | 223.89 | 224.2 | 223.89 | 224.2 | 7098.0 |
| 2021-01-21 07:00:00 | MSFT | Stock | 224.2 | 224.63 | 224.02 | 224.63 | 25194.0 |
| 2021-01-21 07:30:00 | MSFT | Stock | 224.67 | 224.8 | 224.15 | 224.4 | 18470.0 |
| 2021-01-21 08:00:00 | MSFT | Stock | 224.67 | 224.75 | 223.78 | 224.54 | 35141.0 |
| 2021-01-21 08:30:00 | MSFT | Stock | 224.54 | 225.0 | 223.76 | 224.5 | 81652.0 |
| 2021-01-21 09:00:00 | MSFT | Stock | 224.5 | 225.0 | 224.25 | 224.76 | 53541.0 |
| 2021-01-21 09:30:00 | MSFT | Stock | 224.7 | 226.0 | 222.42 | 223.213 | 3814017.0 |
| 2021-01-21 10:00:00 | MSFT | Stock | 223.21 | 225.05 | 222.72 | 224.0 | 2254770.0 |
| 2021-01-21 10:30:00 | MSFT | Stock | 224.01 | 224.775 | 223.95 | 224.533 | 1315325.0 |
| 2021-01-21 11:00:00 | MSFT | Stock | 224.53 | 225.02 | 224.32 | 224.9 | 1185668.0 |
| 2021-01-21 11:30:00 | MSFT | Stock | 224.9 | 225.54 | 224.51 | 225.145 | 1070175.0 |
| 2021-01-21 12:00:00 | MSFT | Stock | 225.134 | 225.53 | 224.76 | 224.95 | 881294.0 |
| 2021-01-21 12:30:00 | MSFT | Stock | 224.94 | 226.25 | 224.92 | 226.21 | 1081931.0 |
> showing 50 of 114,555 rows — these rows as CSV