PREVIEW / stock_30min / 2021-05-13
file: by_date/stock_30min/2021/2021-05-13.parquet size: 2.2 MB rows: 112,624 symbols: 2,993
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-13 04:00:00 | AAPL | Stock | 122.1 | 122.3 | 121.68 | 121.9 | 34112.0 |
| 2021-05-13 04:30:00 | AAPL | Stock | 121.95 | 122.28 | 121.82 | 122.05 | 21424.0 |
| 2021-05-13 05:00:00 | AAPL | Stock | 122.13 | 122.63 | 122.02 | 122.59 | 9151.0 |
| 2021-05-13 05:30:00 | AAPL | Stock | 122.54 | 122.54 | 122.06 | 122.1 | 11904.0 |
| 2021-05-13 06:00:00 | AAPL | Stock | 122.14 | 122.23 | 121.88 | 122.12 | 10185.0 |
| 2021-05-13 06:30:00 | AAPL | Stock | 122.29 | 122.47 | 122.09 | 122.25 | 19535.0 |
| 2021-05-13 07:00:00 | AAPL | Stock | 122.19 | 123.34 | 122.14 | 123.19 | 194828.0 |
| 2021-05-13 07:30:00 | AAPL | Stock | 123.19 | 123.56 | 123.11 | 123.25 | 234965.0 |
| 2021-05-13 08:00:00 | AAPL | Stock | 122.2001 | 123.6 | 122.12 | 123.37 | 419477.0 |
| 2021-05-13 08:30:00 | AAPL | Stock | 123.35 | 123.91 | 122.85 | 123.57 | 380648.0 |
| 2021-05-13 09:00:00 | AAPL | Stock | 123.6 | 124.77 | 123.57 | 124.59 | 563102.0 |
| 2021-05-13 09:30:00 | AAPL | Stock | 124.58 | 125.84 | 124.41 | 125.35 | 16580380.0 |
| 2021-05-13 10:00:00 | AAPL | Stock | 125.34 | 125.73 | 125.16 | 125.46 | 7736315.0 |
| 2021-05-13 10:30:00 | AAPL | Stock | 125.46 | 126.15 | 125.3 | 126.0101 | 7425661.0 |
| 2021-05-13 11:00:00 | AAPL | Stock | 126.015 | 126.11 | 124.9271 | 125.025 | 7033985.0 |
| 2021-05-13 11:30:00 | AAPL | Stock | 125.02 | 125.46 | 124.59 | 124.895 | 5415703.0 |
| 2021-05-13 12:00:00 | AAPL | Stock | 124.9 | 125.6 | 124.84 | 125.57 | 4385484.0 |
| 2021-05-13 12:30:00 | AAPL | Stock | 125.57 | 125.76 | 124.98 | 125.03 | 4693234.0 |
| 2021-05-13 13:00:00 | AAPL | Stock | 125.03 | 125.315 | 124.6 | 124.755 | 4810499.0 |
| 2021-05-13 13:30:00 | AAPL | Stock | 124.75 | 124.83 | 124.26 | 124.69 | 5379464.0 |
| 2021-05-13 14:00:00 | AAPL | Stock | 124.69 | 125.57 | 124.68 | 125.41 | 4829431.0 |
| 2021-05-13 14:30:00 | AAPL | Stock | 125.41 | 125.6701 | 125.24 | 125.39 | 3861144.0 |
| 2021-05-13 15:00:00 | AAPL | Stock | 125.4 | 125.66 | 125.1801 | 125.47 | 4240377.0 |
| 2021-05-13 15:30:00 | AAPL | Stock | 125.46 | 125.79 | 124.9 | 124.94 | 7804669.0 |
| 2021-05-13 16:00:00 | AAPL | Stock | 124.97 | 125.25 | 124.5 | 124.68 | 8073306.0 |
| 2021-05-13 16:30:00 | AAPL | Stock | 124.68 | 124.87 | 124.68 | 124.82 | 27171.0 |
| 2021-05-13 17:00:00 | AAPL | Stock | 124.8 | 124.86 | 124.75 | 124.76 | 35795.0 |
| 2021-05-13 17:30:00 | AAPL | Stock | 124.8499 | 124.85 | 124.71 | 124.84 | 11037.0 |
| 2021-05-13 18:00:00 | AAPL | Stock | 124.8399 | 124.97 | 124.76 | 124.77 | 30562.0 |
| 2021-05-13 18:30:00 | AAPL | Stock | 124.78 | 124.9 | 124.76 | 124.79 | 14949.0 |
| 2021-05-13 19:00:00 | AAPL | Stock | 124.78 | 124.98 | 124.77 | 124.85 | 22850.0 |
| 2021-05-13 19:30:00 | AAPL | Stock | 124.93 | 125.11 | 124.6 | 125.03 | 42373.0 |
| 2021-05-13 04:00:00 | MSFT | Stock | 238.52 | 238.88 | 238.2 | 238.75 | 5796.0 |
| 2021-05-13 04:30:00 | MSFT | Stock | 238.8 | 239.0 | 238.0 | 238.2 | 4904.0 |
| 2021-05-13 05:00:00 | MSFT | Stock | 238.2 | 238.58 | 238.2 | 238.58 | 1741.0 |
| 2021-05-13 05:30:00 | MSFT | Stock | 238.8 | 238.89 | 238.7 | 238.75 | 2068.0 |
| 2021-05-13 06:00:00 | MSFT | Stock | 238.4 | 238.54 | 238.18 | 238.46 | 2994.0 |
| 2021-05-13 06:30:00 | MSFT | Stock | 238.66 | 238.9 | 238.66 | 238.89 | 2298.0 |
| 2021-05-13 07:00:00 | MSFT | Stock | 238.73 | 240.72 | 238.73 | 240.45 | 34850.0 |
| 2021-05-13 07:30:00 | MSFT | Stock | 240.45 | 240.8 | 240.25 | 240.31 | 18596.0 |
| 2021-05-13 08:00:00 | MSFT | Stock | 240.38 | 240.9 | 238.8 | 240.5 | 26990.0 |
| 2021-05-13 08:30:00 | MSFT | Stock | 240.51 | 241.7 | 239.0 | 241.29 | 449361.0 |
| 2021-05-13 09:00:00 | MSFT | Stock | 241.15 | 242.05 | 241.0 | 241.86 | 55995.0 |
| 2021-05-13 09:30:00 | MSFT | Stock | 241.86 | 243.69 | 241.42 | 243.28 | 3304146.0 |
| 2021-05-13 10:00:00 | MSFT | Stock | 243.305 | 245.02 | 243.305 | 244.415 | 2046996.0 |
| 2021-05-13 10:30:00 | MSFT | Stock | 244.44 | 245.6 | 244.05 | 245.18 | 1466060.0 |
| 2021-05-13 11:00:00 | MSFT | Stock | 245.2 | 245.25 | 243.52 | 243.68 | 1357698.0 |
| 2021-05-13 11:30:00 | MSFT | Stock | 243.72 | 244.19 | 242.15 | 243.01 | 1526027.0 |
| 2021-05-13 12:00:00 | MSFT | Stock | 243.0 | 243.95 | 242.84 | 243.82 | 1030487.0 |
| 2021-05-13 12:30:00 | MSFT | Stock | 243.84 | 244.18 | 242.69 | 242.84 | 958041.0 |
> showing 50 of 112,624 rows — these rows as CSV