PREVIEW / stock_30min / 2021-05-12
file: by_date/stock_30min/2021/2021-05-12.parquet size: 2.3 MB rows: 113,676 symbols: 2,981
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-05-12 04:00:00 | AAPL | Stock | 125.71 | 125.71 | 125.05 | 125.05 | 8590.0 |
| 2021-05-12 04:30:00 | AAPL | Stock | 125.3 | 125.34 | 125.06 | 125.2 | 3473.0 |
| 2021-05-12 05:00:00 | AAPL | Stock | 125.23 | 125.4 | 125.23 | 125.33 | 7190.0 |
| 2021-05-12 05:30:00 | AAPL | Stock | 125.34 | 125.34 | 124.83 | 125.13 | 21299.0 |
| 2021-05-12 06:00:00 | AAPL | Stock | 125.13 | 125.38 | 125.08 | 125.12 | 4405.0 |
| 2021-05-12 06:30:00 | AAPL | Stock | 125.29 | 125.39 | 124.71 | 125.0 | 16426.0 |
| 2021-05-12 07:00:00 | AAPL | Stock | 124.92 | 125.21 | 124.89 | 125.13 | 63297.0 |
| 2021-05-12 07:30:00 | AAPL | Stock | 125.13 | 125.25 | 125.0 | 125.19 | 45066.0 |
| 2021-05-12 08:00:00 | AAPL | Stock | 125.035 | 125.5 | 124.92 | 125.04 | 141447.0 |
| 2021-05-12 08:30:00 | AAPL | Stock | 125.04 | 125.8429 | 123.7 | 124.09 | 460285.0 |
| 2021-05-12 09:00:00 | AAPL | Stock | 124.03 | 124.55 | 123.09 | 123.55 | 451524.0 |
| 2021-05-12 09:30:00 | AAPL | Stock | 123.52 | 124.64 | 123.31 | 123.975 | 10944317.0 |
| 2021-05-12 10:00:00 | AAPL | Stock | 123.975 | 124.24 | 123.55 | 123.55 | 6921244.0 |
| 2021-05-12 10:30:00 | AAPL | Stock | 123.56 | 123.73 | 122.83 | 123.1301 | 8458600.0 |
| 2021-05-12 11:00:00 | AAPL | Stock | 123.13 | 123.58 | 123.01 | 123.17 | 5249349.0 |
| 2021-05-12 11:30:00 | AAPL | Stock | 123.17 | 123.38 | 122.71 | 122.812 | 5627071.0 |
| 2021-05-12 12:00:00 | AAPL | Stock | 122.81 | 123.025 | 122.32 | 122.83 | 6518926.0 |
| 2021-05-12 12:30:00 | AAPL | Stock | 122.82 | 123.1499 | 122.59 | 123.1 | 4756579.0 |
| 2021-05-12 13:00:00 | AAPL | Stock | 123.09 | 123.445 | 122.78 | 122.8663 | 4108477.0 |
| 2021-05-12 13:30:00 | AAPL | Stock | 122.86 | 123.09 | 122.61 | 122.71 | 3950279.0 |
| 2021-05-12 14:00:00 | AAPL | Stock | 122.7015 | 122.8 | 122.25 | 122.51 | 4730249.0 |
| 2021-05-12 14:30:00 | AAPL | Stock | 122.51 | 122.96 | 122.335 | 122.77 | 4634694.0 |
| 2021-05-12 15:00:00 | AAPL | Stock | 122.76 | 122.82 | 122.26 | 122.47 | 5031391.0 |
| 2021-05-12 15:30:00 | AAPL | Stock | 122.475 | 123.06 | 122.3 | 122.82 | 13175631.0 |
| 2021-05-12 16:00:00 | AAPL | Stock | 122.82 | 123.09 | 122.49 | 122.67 | 13123244.0 |
| 2021-05-12 16:30:00 | AAPL | Stock | 122.66 | 122.68 | 122.32 | 122.3999 | 164492.0 |
| 2021-05-12 17:00:00 | AAPL | Stock | 122.4 | 122.841 | 122.2801 | 122.4 | 89873.0 |
| 2021-05-12 17:30:00 | AAPL | Stock | 122.38 | 122.48 | 122.33 | 122.44 | 45937.0 |
| 2021-05-12 18:00:00 | AAPL | Stock | 122.45 | 122.77 | 122.35 | 122.54 | 95010.0 |
| 2021-05-12 18:30:00 | AAPL | Stock | 122.53 | 122.94 | 122.53 | 122.75 | 52640.0 |
| 2021-05-12 19:00:00 | AAPL | Stock | 122.75 | 123.0 | 122.67 | 122.84 | 62283.0 |
| 2021-05-12 19:30:00 | AAPL | Stock | 122.82 | 122.83 | 122.6401 | 122.79 | 80903.0 |
| 2021-05-12 04:00:00 | MSFT | Stock | 245.3 | 245.48 | 245.24 | 245.24 | 776.0 |
| 2021-05-12 04:30:00 | MSFT | Stock | 245.06 | 245.06 | 244.86 | 244.86 | 400.0 |
| 2021-05-12 05:00:00 | MSFT | Stock | 244.85 | 244.85 | 244.85 | 244.85 | 110.0 |
| 2021-05-12 05:30:00 | MSFT | Stock | 244.93 | 245.03 | 244.57 | 244.57 | 1074.0 |
| 2021-05-12 06:00:00 | MSFT | Stock | 244.95 | 244.95 | 244.59 | 244.59 | 426.0 |
| 2021-05-12 06:30:00 | MSFT | Stock | 245.2 | 245.2 | 244.05 | 244.23 | 2529.0 |
| 2021-05-12 07:00:00 | MSFT | Stock | 244.51 | 244.98 | 244.32 | 244.79 | 10258.0 |
| 2021-05-12 07:30:00 | MSFT | Stock | 244.8 | 244.92 | 244.5 | 244.85 | 4832.0 |
| 2021-05-12 08:00:00 | MSFT | Stock | 244.4101 | 245.9 | 244.4101 | 245.05 | 10588.0 |
| 2021-05-12 08:30:00 | MSFT | Stock | 245.01 | 246.0988 | 242.03 | 242.9 | 83246.0 |
| 2021-05-12 09:00:00 | MSFT | Stock | 243.1 | 244.45 | 242.02 | 242.17 | 102735.0 |
| 2021-05-12 09:30:00 | MSFT | Stock | 242.19 | 244.38 | 242.14 | 242.348 | 2874061.0 |
| 2021-05-12 10:00:00 | MSFT | Stock | 242.335 | 242.34 | 241.22 | 241.239 | 2128187.0 |
| 2021-05-12 10:30:00 | MSFT | Stock | 241.2498 | 241.51 | 239.67 | 240.0358 | 2490103.0 |
| 2021-05-12 11:00:00 | MSFT | Stock | 240.02 | 240.9 | 239.84 | 240.288 | 1556549.0 |
| 2021-05-12 11:30:00 | MSFT | Stock | 240.28 | 240.57 | 239.39 | 239.5 | 1602369.0 |
| 2021-05-12 12:00:00 | MSFT | Stock | 239.5 | 239.88 | 238.77 | 239.405 | 1834840.0 |
| 2021-05-12 12:30:00 | MSFT | Stock | 239.39 | 239.88 | 239.01 | 239.79 | 1089908.0 |
> showing 50 of 113,676 rows — these rows as CSV