PREVIEW / stock_30min / 2021-09-07
file: by_date/stock_30min/2021/2021-09-07.parquet size: 2.2 MB rows: 111,410 symbols: 2,729
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-09-07 04:00:00 | AAPL | Stock | 154.6 | 154.72 | 154.27 | 154.71 | 25283.0 |
| 2021-09-07 04:30:00 | AAPL | Stock | 154.7 | 154.77 | 154.69 | 154.69 | 15772.0 |
| 2021-09-07 05:00:00 | AAPL | Stock | 154.66 | 154.71 | 154.4 | 154.56 | 12461.0 |
| 2021-09-07 05:30:00 | AAPL | Stock | 154.57 | 154.57 | 154.21 | 154.21 | 13290.0 |
| 2021-09-07 06:00:00 | AAPL | Stock | 154.41 | 154.58 | 154.21 | 154.22 | 4540.0 |
| 2021-09-07 06:30:00 | AAPL | Stock | 154.37 | 154.44 | 154.19 | 154.31 | 12620.0 |
| 2021-09-07 07:00:00 | AAPL | Stock | 154.29 | 154.6 | 154.25 | 154.6 | 63127.0 |
| 2021-09-07 07:30:00 | AAPL | Stock | 154.59 | 154.77 | 154.56 | 154.68 | 97937.0 |
| 2021-09-07 08:00:00 | AAPL | Stock | 154.6 | 155.2 | 153.915 | 155.07 | 414382.0 |
| 2021-09-07 08:30:00 | AAPL | Stock | 155.05 | 155.14 | 154.85 | 154.95 | 218070.0 |
| 2021-09-07 09:00:00 | AAPL | Stock | 154.95 | 155.11 | 154.7 | 154.97 | 299732.0 |
| 2021-09-07 09:30:00 | AAPL | Stock | 155.0 | 155.72 | 154.39 | 155.715 | 12192291.0 |
| 2021-09-07 10:00:00 | AAPL | Stock | 155.695 | 155.955 | 155.31 | 155.6501 | 7282468.0 |
| 2021-09-07 10:30:00 | AAPL | Stock | 155.65 | 156.24 | 155.6 | 156.03 | 5691308.0 |
| 2021-09-07 11:00:00 | AAPL | Stock | 156.02 | 156.075 | 155.25 | 155.47 | 4412971.0 |
| 2021-09-07 11:30:00 | AAPL | Stock | 155.48 | 155.849 | 155.38 | 155.82 | 3144603.0 |
| 2021-09-07 12:00:00 | AAPL | Stock | 155.81 | 156.9699 | 155.7301 | 156.85 | 7222700.0 |
| 2021-09-07 12:30:00 | AAPL | Stock | 156.8526 | 157.26 | 156.6521 | 157.095 | 5099185.0 |
| 2021-09-07 13:00:00 | AAPL | Stock | 157.0999 | 157.1299 | 156.8 | 156.88 | 3188488.0 |
| 2021-09-07 13:30:00 | AAPL | Stock | 156.8831 | 157.1 | 156.75 | 156.8369 | 2192682.0 |
| 2021-09-07 14:00:00 | AAPL | Stock | 156.84 | 157.05 | 156.62 | 156.97 | 3212907.0 |
| 2021-09-07 14:30:00 | AAPL | Stock | 156.96 | 157.1 | 156.56 | 156.905 | 3537055.0 |
| 2021-09-07 15:00:00 | AAPL | Stock | 156.9099 | 157.0 | 156.81 | 156.851 | 2735592.0 |
| 2021-09-07 15:30:00 | AAPL | Stock | 156.855 | 157.08 | 156.65 | 156.7 | 6874753.0 |
| 2021-09-07 16:00:00 | AAPL | Stock | 156.69 | 156.75 | 156.3 | 156.51 | 5703074.0 |
| 2021-09-07 16:30:00 | AAPL | Stock | 156.5 | 156.66 | 156.5 | 156.65 | 20818.0 |
| 2021-09-07 17:00:00 | AAPL | Stock | 156.69 | 156.69 | 156.5 | 156.67 | 121399.0 |
| 2021-09-07 17:30:00 | AAPL | Stock | 156.68 | 156.69 | 156.61 | 156.63 | 23234.0 |
| 2021-09-07 18:00:00 | AAPL | Stock | 156.66 | 156.69 | 156.6 | 156.63 | 29075.0 |
| 2021-09-07 18:30:00 | AAPL | Stock | 156.65 | 156.78 | 156.65 | 156.78 | 31759.0 |
| 2021-09-07 19:00:00 | AAPL | Stock | 156.78 | 156.89 | 156.75 | 156.77 | 36382.0 |
| 2021-09-07 19:30:00 | AAPL | Stock | 156.75 | 156.91 | 156.74 | 156.76 | 27678.0 |
| 2021-09-07 04:00:00 | MSFT | Stock | 301.4 | 302.29 | 301.3 | 301.8 | 13949.0 |
| 2021-09-07 04:30:00 | MSFT | Stock | 302.01 | 302.01 | 301.47 | 301.47 | 345.0 |
| 2021-09-07 05:00:00 | MSFT | Stock | 301.51 | 301.65 | 300.52 | 301.07 | 2332.0 |
| 2021-09-07 05:30:00 | MSFT | Stock | 300.55 | 300.62 | 300.05 | 300.56 | 3899.0 |
| 2021-09-07 06:00:00 | MSFT | Stock | 300.62 | 300.85 | 300.6 | 300.6 | 2011.0 |
| 2021-09-07 06:30:00 | MSFT | Stock | 300.65 | 300.66 | 300.59 | 300.66 | 5714.0 |
| 2021-09-07 07:00:00 | MSFT | Stock | 300.67 | 300.81 | 300.35 | 300.81 | 10697.0 |
| 2021-09-07 07:30:00 | MSFT | Stock | 300.64 | 300.72 | 300.61 | 300.65 | 3034.0 |
| 2021-09-07 08:00:00 | MSFT | Stock | 300.6545 | 300.9 | 300.39 | 300.84 | 12141.0 |
| 2021-09-07 08:30:00 | MSFT | Stock | 301.0 | 301.0 | 300.35 | 300.51 | 15419.0 |
| 2021-09-07 09:00:00 | MSFT | Stock | 300.7 | 301.49 | 300.35 | 301.02 | 29129.0 |
| 2021-09-07 09:30:00 | MSFT | Stock | 301.07 | 301.09 | 298.33 | 299.34 | 2373071.0 |
| 2021-09-07 10:00:00 | MSFT | Stock | 299.32 | 299.355 | 298.2 | 299.0 | 1155126.0 |
| 2021-09-07 10:30:00 | MSFT | Stock | 299.0166 | 300.4 | 298.97 | 300.27 | 907269.0 |
| 2021-09-07 11:00:00 | MSFT | Stock | 300.26 | 300.2901 | 299.58 | 299.78 | 686595.0 |
| 2021-09-07 11:30:00 | MSFT | Stock | 299.79 | 300.62 | 299.705 | 300.4 | 500944.0 |
| 2021-09-07 12:00:00 | MSFT | Stock | 300.3741 | 300.69 | 300.215 | 300.45 | 622876.0 |
| 2021-09-07 12:30:00 | MSFT | Stock | 300.45 | 300.6 | 300.32 | 300.435 | 380363.0 |
> showing 50 of 111,410 rows — these rows as CSV