PREVIEW / stock_30min / 2021-03-30
file: by_date/stock_30min/2021/2021-03-30.parquet size: 2.2 MB rows: 112,022 symbols: 2,933
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-30 04:00:00 | AAPL | Stock | 120.78 | 120.88 | 120.02 | 120.3 | 18143.0 |
| 2021-03-30 04:30:00 | AAPL | Stock | 120.32 | 120.41 | 120.26 | 120.41 | 6311.0 |
| 2021-03-30 05:00:00 | AAPL | Stock | 120.44 | 120.69 | 120.43 | 120.69 | 2244.0 |
| 2021-03-30 05:30:00 | AAPL | Stock | 120.73 | 120.75 | 120.59 | 120.75 | 4433.0 |
| 2021-03-30 06:00:00 | AAPL | Stock | 120.74 | 120.81 | 120.55 | 120.55 | 10958.0 |
| 2021-03-30 06:30:00 | AAPL | Stock | 120.55 | 120.56 | 119.92 | 120.32 | 32366.0 |
| 2021-03-30 07:00:00 | AAPL | Stock | 120.32 | 120.49 | 120.08 | 120.32 | 118832.0 |
| 2021-03-30 07:30:00 | AAPL | Stock | 120.33 | 120.4 | 120.1 | 120.2 | 80189.0 |
| 2021-03-30 08:00:00 | AAPL | Stock | 120.2 | 121.693 | 120.04 | 120.3301 | 241005.0 |
| 2021-03-30 08:30:00 | AAPL | Stock | 120.32 | 120.35 | 120.1 | 120.27 | 123523.0 |
| 2021-03-30 09:00:00 | AAPL | Stock | 120.27 | 120.55 | 120.1 | 120.1 | 187257.0 |
| 2021-03-30 09:30:00 | AAPL | Stock | 120.11 | 120.4031 | 119.23 | 119.49 | 11032343.0 |
| 2021-03-30 10:00:00 | AAPL | Stock | 119.49 | 119.64 | 118.86 | 119.165 | 8385542.0 |
| 2021-03-30 10:30:00 | AAPL | Stock | 119.16 | 119.5899 | 119.0 | 119.5 | 6004523.0 |
| 2021-03-30 11:00:00 | AAPL | Stock | 119.505 | 120.01 | 119.35 | 119.9 | 4937871.0 |
| 2021-03-30 11:30:00 | AAPL | Stock | 119.9 | 120.36 | 119.825 | 119.87 | 4718079.0 |
| 2021-03-30 12:00:00 | AAPL | Stock | 119.87 | 119.965 | 119.58 | 119.88 | 3658192.0 |
| 2021-03-30 12:30:00 | AAPL | Stock | 119.87 | 119.93 | 119.58 | 119.7351 | 2963676.0 |
| 2021-03-30 13:00:00 | AAPL | Stock | 119.74 | 120.08 | 119.515 | 119.965 | 3174007.0 |
| 2021-03-30 13:30:00 | AAPL | Stock | 119.96 | 120.08 | 119.72 | 119.7401 | 2384589.0 |
| 2021-03-30 14:00:00 | AAPL | Stock | 119.74 | 119.8221 | 119.46 | 119.535 | 2900206.0 |
| 2021-03-30 14:30:00 | AAPL | Stock | 119.5311 | 119.81 | 119.48 | 119.7 | 3527195.0 |
| 2021-03-30 15:00:00 | AAPL | Stock | 119.708 | 120.18 | 119.63 | 120.025 | 4113526.0 |
| 2021-03-30 15:30:00 | AAPL | Stock | 120.03 | 120.2364 | 119.4 | 119.98 | 9674837.0 |
| 2021-03-30 16:00:00 | AAPL | Stock | 119.98 | 119.99 | 119.75 | 119.82 | 6215304.0 |
| 2021-03-30 16:30:00 | AAPL | Stock | 119.85 | 119.87 | 119.8 | 119.87 | 42453.0 |
| 2021-03-30 17:00:00 | AAPL | Stock | 119.86 | 119.9 | 119.82 | 119.86 | 30904.0 |
| 2021-03-30 17:30:00 | AAPL | Stock | 119.8499 | 119.9 | 119.82 | 119.89 | 43359.0 |
| 2021-03-30 18:00:00 | AAPL | Stock | 119.89 | 119.89 | 119.75 | 119.79 | 41039.0 |
| 2021-03-30 18:30:00 | AAPL | Stock | 119.7899 | 119.82 | 119.77 | 119.81 | 13317.0 |
| 2021-03-30 19:00:00 | AAPL | Stock | 119.82 | 119.88 | 119.75 | 119.86 | 41511.0 |
| 2021-03-30 19:30:00 | AAPL | Stock | 119.86 | 119.94 | 119.86 | 119.93 | 57755.0 |
| 2021-03-30 04:00:00 | MSFT | Stock | 234.32 | 234.5 | 233.04 | 233.04 | 4670.0 |
| 2021-03-30 04:30:00 | MSFT | Stock | 233.51 | 233.51 | 233.51 | 233.51 | 100.0 |
| 2021-03-30 05:00:00 | MSFT | Stock | 233.44 | 233.44 | 233.44 | 233.44 | 100.0 |
| 2021-03-30 05:30:00 | MSFT | Stock | 233.8 | 233.8 | 233.8 | 233.8 | 200.0 |
| 2021-03-30 06:00:00 | MSFT | Stock | 233.69 | 233.69 | 233.31 | 233.48 | 3333.0 |
| 2021-03-30 06:30:00 | MSFT | Stock | 233.48 | 233.48 | 232.65 | 233.17 | 5733.0 |
| 2021-03-30 07:00:00 | MSFT | Stock | 233.08 | 233.58 | 232.76 | 233.13 | 21886.0 |
| 2021-03-30 07:30:00 | MSFT | Stock | 233.26 | 233.51 | 233.02 | 233.12 | 8991.0 |
| 2021-03-30 08:00:00 | MSFT | Stock | 233.1 | 234.652 | 232.72 | 233.66 | 16459.0 |
| 2021-03-30 08:30:00 | MSFT | Stock | 233.45 | 233.48 | 233.05 | 233.11 | 7423.0 |
| 2021-03-30 09:00:00 | MSFT | Stock | 233.4 | 234.25 | 233.31 | 233.5 | 20861.0 |
| 2021-03-30 09:30:00 | MSFT | Stock | 233.44 | 233.85 | 231.54 | 232.25 | 2417958.0 |
| 2021-03-30 10:00:00 | MSFT | Stock | 232.23 | 232.9 | 231.1 | 231.83 | 1738679.0 |
| 2021-03-30 10:30:00 | MSFT | Stock | 231.83 | 232.69 | 231.635 | 231.95 | 1193407.0 |
| 2021-03-30 11:00:00 | MSFT | Stock | 231.96 | 232.3 | 231.61 | 231.92 | 1129271.0 |
| 2021-03-30 11:30:00 | MSFT | Stock | 231.92 | 232.685 | 231.85 | 231.985 | 1177770.0 |
| 2021-03-30 12:00:00 | MSFT | Stock | 231.98 | 232.2 | 231.58 | 231.845 | 861749.0 |
| 2021-03-30 12:30:00 | MSFT | Stock | 231.83 | 232.11 | 231.65 | 231.83 | 705997.0 |
> showing 50 of 112,022 rows — these rows as CSV