PREVIEW / stock_30min / 2021-03-31
file: by_date/stock_30min/2021/2021-03-31.parquet size: 2.2 MB rows: 113,705 symbols: 2,956
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-31 04:00:00 | AAPL | Stock | 121.66 | 121.99 | 121.2 | 121.64 | 53725.0 |
| 2021-03-31 04:30:00 | AAPL | Stock | 121.6 | 121.75 | 121.34 | 121.75 | 17504.0 |
| 2021-03-31 05:00:00 | AAPL | Stock | 121.74 | 121.74 | 121.45 | 121.56 | 12939.0 |
| 2021-03-31 05:30:00 | AAPL | Stock | 121.56 | 121.87 | 121.54 | 121.76 | 12803.0 |
| 2021-03-31 06:00:00 | AAPL | Stock | 121.75 | 121.99 | 121.65 | 121.85 | 17843.0 |
| 2021-03-31 06:30:00 | AAPL | Stock | 121.83 | 122.25 | 121.83 | 121.87 | 33597.0 |
| 2021-03-31 07:00:00 | AAPL | Stock | 121.83 | 122.0 | 121.61 | 121.69 | 218937.0 |
| 2021-03-31 07:30:00 | AAPL | Stock | 121.7 | 121.85 | 121.62 | 121.66 | 111843.0 |
| 2021-03-31 08:00:00 | AAPL | Stock | 121.69 | 122.0 | 121.58 | 121.84 | 386332.0 |
| 2021-03-31 08:30:00 | AAPL | Stock | 121.84 | 121.9 | 121.57 | 121.71 | 255931.0 |
| 2021-03-31 09:00:00 | AAPL | Stock | 121.73 | 121.75 | 121.27 | 121.63 | 425334.0 |
| 2021-03-31 09:30:00 | AAPL | Stock | 121.65 | 123.05 | 121.15 | 122.969 | 16919142.0 |
| 2021-03-31 10:00:00 | AAPL | Stock | 122.96 | 123.25 | 122.53 | 122.755 | 8827127.0 |
| 2021-03-31 10:30:00 | AAPL | Stock | 122.76 | 123.235 | 122.72 | 122.8155 | 6557306.0 |
| 2021-03-31 11:00:00 | AAPL | Stock | 122.81 | 123.06 | 122.647 | 122.865 | 4660532.0 |
| 2021-03-31 11:30:00 | AAPL | Stock | 122.86 | 123.31 | 122.85 | 123.28 | 5257848.0 |
| 2021-03-31 12:00:00 | AAPL | Stock | 123.2813 | 123.46 | 123.2 | 123.275 | 4707884.0 |
| 2021-03-31 12:30:00 | AAPL | Stock | 123.28 | 123.52 | 123.07 | 123.0799 | 4293268.0 |
| 2021-03-31 13:00:00 | AAPL | Stock | 123.075 | 123.38 | 123.04 | 123.1601 | 3527723.0 |
| 2021-03-31 13:30:00 | AAPL | Stock | 123.16 | 123.185 | 122.78 | 122.83 | 3088646.0 |
| 2021-03-31 14:00:00 | AAPL | Stock | 122.83 | 122.88 | 122.58 | 122.735 | 3429266.0 |
| 2021-03-31 14:30:00 | AAPL | Stock | 122.74 | 122.9199 | 122.43 | 122.78 | 4472962.0 |
| 2021-03-31 15:00:00 | AAPL | Stock | 122.78 | 122.88 | 122.62 | 122.68 | 4462302.0 |
| 2021-03-31 15:30:00 | AAPL | Stock | 122.67 | 122.75 | 122.0 | 122.17 | 14145966.0 |
| 2021-03-31 16:00:00 | AAPL | Stock | 122.17 | 122.8808 | 121.9 | 121.95 | 16173640.0 |
| 2021-03-31 16:30:00 | AAPL | Stock | 121.96 | 122.15 | 121.9 | 122.0 | 73211.0 |
| 2021-03-31 17:00:00 | AAPL | Stock | 122.01 | 122.1 | 122.0 | 122.05 | 28679.0 |
| 2021-03-31 17:30:00 | AAPL | Stock | 122.03 | 122.1 | 122.01 | 122.09 | 28288.0 |
| 2021-03-31 18:00:00 | AAPL | Stock | 122.08 | 122.2 | 122.07 | 122.2 | 41840.0 |
| 2021-03-31 18:30:00 | AAPL | Stock | 122.19 | 122.25 | 122.16 | 122.24 | 22144.0 |
| 2021-03-31 19:00:00 | AAPL | Stock | 122.2499 | 122.25 | 122.14 | 122.23 | 28537.0 |
| 2021-03-31 19:30:00 | AAPL | Stock | 122.24 | 122.45 | 122.23 | 122.45 | 62321.0 |
| 2021-03-31 04:00:00 | MSFT | Stock | 232.0 | 232.6 | 231.66 | 232.06 | 915.0 |
| 2021-03-31 04:30:00 | MSFT | Stock | 232.07 | 232.27 | 232.06 | 232.27 | 1182.0 |
| 2021-03-31 05:00:00 | MSFT | Stock | 232.1 | 232.1 | 231.94 | 231.96 | 1714.0 |
| 2021-03-31 05:30:00 | MSFT | Stock | 231.96 | 232.49 | 231.94 | 232.49 | 1402.0 |
| 2021-03-31 06:00:00 | MSFT | Stock | 232.51 | 232.64 | 232.51 | 232.64 | 258.0 |
| 2021-03-31 06:30:00 | MSFT | Stock | 232.7 | 233.01 | 232.7 | 232.96 | 2221.0 |
| 2021-03-31 07:00:00 | MSFT | Stock | 232.87 | 232.97 | 232.71 | 232.75 | 6463.0 |
| 2021-03-31 07:30:00 | MSFT | Stock | 232.98 | 233.02 | 232.81 | 232.98 | 5319.0 |
| 2021-03-31 08:00:00 | MSFT | Stock | 233.0094 | 233.0094 | 231.271 | 232.85 | 25497.0 |
| 2021-03-31 08:30:00 | MSFT | Stock | 232.83 | 233.05 | 232.8 | 232.86 | 16519.0 |
| 2021-03-31 09:00:00 | MSFT | Stock | 232.85 | 232.99 | 232.72 | 232.74 | 16007.0 |
| 2021-03-31 09:30:00 | MSFT | Stock | 232.91 | 233.85 | 232.39 | 233.8 | 2524534.0 |
| 2021-03-31 10:00:00 | MSFT | Stock | 233.79 | 235.195 | 233.79 | 234.82 | 1721092.0 |
| 2021-03-31 10:30:00 | MSFT | Stock | 234.86 | 236.07 | 234.8 | 235.56 | 1325587.0 |
| 2021-03-31 11:00:00 | MSFT | Stock | 235.54 | 235.87 | 235.06 | 235.58 | 932338.0 |
| 2021-03-31 11:30:00 | MSFT | Stock | 235.56 | 236.265 | 235.5317 | 236.245 | 879473.0 |
| 2021-03-31 12:00:00 | MSFT | Stock | 236.245 | 236.756 | 236.22 | 236.65 | 1072492.0 |
| 2021-03-31 12:30:00 | MSFT | Stock | 236.66 | 236.85 | 236.21 | 236.24 | 611176.0 |
> showing 50 of 113,705 rows — these rows as CSV