PREVIEW / stock_30min / 2021-02-16
file: by_date/stock_30min/2021/2021-02-16.parquet size: 2.5 MB rows: 127,486 symbols: 2,827
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-02-16 04:00:00 | AAPL | Stock | 135.78 | 136.44 | 135.78 | 136.03 | 31554.0 |
| 2021-02-16 04:30:00 | AAPL | Stock | 136.01 | 136.1 | 135.9 | 136.05 | 13585.0 |
| 2021-02-16 05:00:00 | AAPL | Stock | 136.05 | 136.05 | 135.82 | 135.85 | 13025.0 |
| 2021-02-16 05:30:00 | AAPL | Stock | 135.98 | 136.14 | 135.98 | 136.09 | 3821.0 |
| 2021-02-16 06:00:00 | AAPL | Stock | 136.07 | 136.15 | 135.98 | 136.15 | 13162.0 |
| 2021-02-16 06:30:00 | AAPL | Stock | 136.16 | 136.35 | 136.16 | 136.31 | 14020.0 |
| 2021-02-16 07:00:00 | AAPL | Stock | 136.31 | 136.31 | 135.88 | 135.91 | 106111.0 |
| 2021-02-16 07:30:00 | AAPL | Stock | 135.93 | 135.98 | 135.87 | 135.93 | 50413.0 |
| 2021-02-16 08:00:00 | AAPL | Stock | 136.1 | 136.17 | 135.65 | 135.71 | 232329.0 |
| 2021-02-16 08:30:00 | AAPL | Stock | 135.74 | 135.88 | 135.58 | 135.6 | 152805.0 |
| 2021-02-16 09:00:00 | AAPL | Stock | 135.6 | 135.72 | 135.37 | 135.47 | 247029.0 |
| 2021-02-16 09:30:00 | AAPL | Stock | 135.47 | 136.01 | 134.69 | 135.045 | 9988157.0 |
| 2021-02-16 10:00:00 | AAPL | Stock | 135.045 | 135.098 | 134.6 | 134.99 | 4741422.0 |
| 2021-02-16 10:30:00 | AAPL | Stock | 134.985 | 135.15 | 134.15 | 134.32 | 5035417.0 |
| 2021-02-16 11:00:00 | AAPL | Stock | 134.305 | 134.325 | 133.68 | 133.72 | 5744231.0 |
| 2021-02-16 11:30:00 | AAPL | Stock | 133.725 | 133.75 | 132.95 | 133.105 | 7168729.0 |
| 2021-02-16 12:00:00 | AAPL | Stock | 133.11 | 133.73 | 132.91 | 133.61 | 4785979.0 |
| 2021-02-16 12:30:00 | AAPL | Stock | 133.61 | 133.67 | 133.31 | 133.475 | 2437504.0 |
| 2021-02-16 13:00:00 | AAPL | Stock | 133.48 | 133.56 | 133.15 | 133.288 | 2831144.0 |
| 2021-02-16 13:30:00 | AAPL | Stock | 133.28 | 133.35 | 132.79 | 132.921 | 3270122.0 |
| 2021-02-16 14:00:00 | AAPL | Stock | 132.928 | 133.64 | 132.92 | 133.529 | 2992544.0 |
| 2021-02-16 14:30:00 | AAPL | Stock | 133.521 | 133.575 | 133.12 | 133.165 | 2381079.0 |
| 2021-02-16 15:00:00 | AAPL | Stock | 133.17 | 133.46 | 133.05 | 133.365 | 2805996.0 |
| 2021-02-16 15:30:00 | AAPL | Stock | 133.37 | 133.38 | 133.02 | 133.16 | 6037393.0 |
| 2021-02-16 16:00:00 | AAPL | Stock | 133.19 | 133.25 | 132.88 | 132.92 | 6166894.0 |
| 2021-02-16 16:30:00 | AAPL | Stock | 132.91 | 133.05 | 132.9 | 132.97 | 105664.0 |
| 2021-02-16 17:00:00 | AAPL | Stock | 132.96 | 133.19 | 132.95 | 133.0 | 405360.0 |
| 2021-02-16 17:30:00 | AAPL | Stock | 133.01 | 133.1 | 132.99 | 133.02 | 51766.0 |
| 2021-02-16 18:00:00 | AAPL | Stock | 133.05 | 133.07 | 132.82 | 132.88 | 78119.0 |
| 2021-02-16 18:30:00 | AAPL | Stock | 132.88 | 132.89 | 132.771 | 132.78 | 79075.0 |
| 2021-02-16 19:00:00 | AAPL | Stock | 132.79 | 132.8 | 132.63 | 132.69 | 115462.0 |
| 2021-02-16 19:30:00 | AAPL | Stock | 132.661 | 132.73 | 132.61 | 132.65 | 68457.0 |
| 2021-02-16 04:00:00 | MSFT | Stock | 245.85 | 245.99 | 245.48 | 245.5 | 3613.0 |
| 2021-02-16 04:30:00 | MSFT | Stock | 245.54 | 245.54 | 245.41 | 245.41 | 1235.0 |
| 2021-02-16 05:00:00 | MSFT | Stock | 245.41 | 245.5 | 245.41 | 245.5 | 2729.0 |
| 2021-02-16 05:30:00 | MSFT | Stock | 245.46 | 245.55 | 245.46 | 245.55 | 1502.0 |
| 2021-02-16 06:00:00 | MSFT | Stock | 245.66 | 245.7 | 245.56 | 245.7 | 2263.0 |
| 2021-02-16 06:30:00 | MSFT | Stock | 245.8 | 245.99 | 245.79 | 245.81 | 968.0 |
| 2021-02-16 07:00:00 | MSFT | Stock | 245.75 | 245.75 | 245.36 | 245.43 | 24330.0 |
| 2021-02-16 07:30:00 | MSFT | Stock | 245.69 | 245.8 | 245.52 | 245.7 | 5694.0 |
| 2021-02-16 08:00:00 | MSFT | Stock | 245.6 | 245.9 | 244.378 | 245.85 | 24823.0 |
| 2021-02-16 08:30:00 | MSFT | Stock | 245.76 | 245.9 | 245.4 | 245.4 | 14231.0 |
| 2021-02-16 09:00:00 | MSFT | Stock | 245.45 | 245.88 | 245.0 | 245.07 | 28150.0 |
| 2021-02-16 09:30:00 | MSFT | Stock | 245.07 | 246.13 | 244.08 | 244.4 | 2319235.0 |
| 2021-02-16 10:00:00 | MSFT | Stock | 244.4 | 244.64 | 243.795 | 244.234 | 1357988.0 |
| 2021-02-16 10:30:00 | MSFT | Stock | 244.24 | 244.73 | 243.86 | 244.0 | 950869.0 |
| 2021-02-16 11:00:00 | MSFT | Stock | 244.025 | 244.45 | 243.602 | 243.81 | 886591.0 |
| 2021-02-16 11:30:00 | MSFT | Stock | 243.8 | 244.28 | 243.35 | 243.488 | 839150.0 |
| 2021-02-16 12:00:00 | MSFT | Stock | 243.43 | 243.93 | 242.92 | 243.88 | 999334.0 |
| 2021-02-16 12:30:00 | MSFT | Stock | 243.86 | 244.37 | 243.68 | 244.28 | 489628.0 |
> showing 50 of 127,486 rows — these rows as CSV