PREVIEW / stock_30min / 2021-05-21
file: by_date/stock_30min/2021/2021-05-21.parquet size: 2.1 MB rows: 107,832 symbols: 2,968
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-21 04:00:00 | AAPL | Stock | 127.56 | 127.56 | 127.31 | 127.31 | 6009.0 |
| 2021-05-21 04:30:00 | AAPL | Stock | 127.27 | 127.35 | 127.17 | 127.35 | 11043.0 |
| 2021-05-21 05:00:00 | AAPL | Stock | 127.4 | 127.5 | 127.4 | 127.41 | 3894.0 |
| 2021-05-21 05:30:00 | AAPL | Stock | 127.37 | 127.7 | 127.31 | 127.62 | 4730.0 |
| 2021-05-21 06:00:00 | AAPL | Stock | 127.51 | 127.62 | 127.48 | 127.62 | 3863.0 |
| 2021-05-21 06:30:00 | AAPL | Stock | 127.57 | 127.57 | 127.41 | 127.49 | 2692.0 |
| 2021-05-21 07:00:00 | AAPL | Stock | 127.47 | 127.79 | 127.44 | 127.79 | 43531.0 |
| 2021-05-21 07:30:00 | AAPL | Stock | 127.77 | 127.97 | 127.72 | 127.95 | 76317.0 |
| 2021-05-21 08:00:00 | AAPL | Stock | 127.61 | 127.98 | 127.5 | 127.87 | 207172.0 |
| 2021-05-21 08:30:00 | AAPL | Stock | 127.87 | 127.94 | 127.75 | 127.88 | 124081.0 |
| 2021-05-21 09:00:00 | AAPL | Stock | 127.87 | 128.24 | 127.71 | 127.85 | 444558.0 |
| 2021-05-21 09:30:00 | AAPL | Stock | 127.85 | 128.0 | 126.59 | 127.04 | 12273009.0 |
| 2021-05-21 10:00:00 | AAPL | Stock | 127.045 | 127.25 | 126.5173 | 126.53 | 5775961.0 |
| 2021-05-21 10:30:00 | AAPL | Stock | 126.52 | 126.7554 | 126.16 | 126.3791 | 4682203.0 |
| 2021-05-21 11:00:00 | AAPL | Stock | 126.3706 | 126.475 | 125.86 | 125.89 | 4581314.0 |
| 2021-05-21 11:30:00 | AAPL | Stock | 125.89 | 126.09 | 125.7 | 125.755 | 4313731.0 |
| 2021-05-21 12:00:00 | AAPL | Stock | 125.75 | 126.0 | 125.49 | 125.705 | 4150687.0 |
| 2021-05-21 12:30:00 | AAPL | Stock | 125.7 | 125.83 | 125.4 | 125.585 | 3369998.0 |
| 2021-05-21 13:00:00 | AAPL | Stock | 125.58 | 125.695 | 125.395 | 125.67 | 2937355.0 |
| 2021-05-21 13:30:00 | AAPL | Stock | 125.67 | 125.925 | 125.64 | 125.88 | 2594173.0 |
| 2021-05-21 14:00:00 | AAPL | Stock | 125.88 | 126.09 | 125.655 | 125.685 | 2981099.0 |
| 2021-05-21 14:30:00 | AAPL | Stock | 125.685 | 125.97 | 125.52 | 125.9576 | 2636757.0 |
| 2021-05-21 15:00:00 | AAPL | Stock | 125.96 | 126.08 | 125.71 | 125.945 | 3477477.0 |
| 2021-05-21 15:30:00 | AAPL | Stock | 125.9499 | 125.9499 | 125.21 | 125.43 | 8703340.0 |
| 2021-05-21 16:00:00 | AAPL | Stock | 125.45 | 125.45 | 125.32 | 125.38 | 6726989.0 |
| 2021-05-21 16:30:00 | AAPL | Stock | 125.36 | 125.4 | 125.33 | 125.35 | 38758.0 |
| 2021-05-21 17:00:00 | AAPL | Stock | 125.36 | 125.41 | 125.35 | 125.38 | 23409.0 |
| 2021-05-21 17:30:00 | AAPL | Stock | 125.3999 | 125.41 | 125.37 | 125.38 | 15530.0 |
| 2021-05-21 18:00:00 | AAPL | Stock | 125.4 | 125.4 | 125.37 | 125.39 | 7739.0 |
| 2021-05-21 18:30:00 | AAPL | Stock | 125.37 | 125.4 | 125.37 | 125.37 | 18841.0 |
| 2021-05-21 19:00:00 | AAPL | Stock | 125.37 | 125.42 | 125.35 | 125.35 | 16812.0 |
| 2021-05-21 19:30:00 | AAPL | Stock | 125.37 | 125.37 | 125.2 | 125.31 | 31801.0 |
| 2021-05-21 04:00:00 | MSFT | Stock | 247.25 | 247.25 | 247.25 | 247.25 | 238.0 |
| 2021-05-21 04:30:00 | MSFT | Stock | 246.9 | 246.9 | 246.9 | 246.9 | 200.0 |
| 2021-05-21 05:00:00 | MSFT | Stock | 247.0 | 247.4 | 247.0 | 247.4 | 880.0 |
| 2021-05-21 05:30:00 | MSFT | Stock | 247.2 | 247.39 | 247.2 | 247.2 | 700.0 |
| 2021-05-21 06:00:00 | MSFT | Stock | 247.3 | 247.3 | 247.29 | 247.3 | 2634.0 |
| 2021-05-21 06:30:00 | MSFT | Stock | 247.24 | 247.24 | 247.24 | 247.24 | 100.0 |
| 2021-05-21 07:00:00 | MSFT | Stock | 247.12 | 247.2 | 247.0 | 247.0 | 1809.0 |
| 2021-05-21 07:30:00 | MSFT | Stock | 247.22 | 247.35 | 247.12 | 247.3 | 4153.0 |
| 2021-05-21 08:00:00 | MSFT | Stock | 247.1899 | 247.37 | 247.01 | 247.33 | 6412.0 |
| 2021-05-21 08:30:00 | MSFT | Stock | 247.4 | 247.44 | 246.48 | 247.0 | 45854.0 |
| 2021-05-21 09:00:00 | MSFT | Stock | 247.02 | 248.4 | 246.65 | 247.56 | 128465.0 |
| 2021-05-21 09:30:00 | MSFT | Stock | 247.56 | 248.33 | 246.5368 | 247.5794 | 2833789.0 |
| 2021-05-21 10:00:00 | MSFT | Stock | 247.57 | 247.79 | 246.36 | 246.43 | 1351355.0 |
| 2021-05-21 10:30:00 | MSFT | Stock | 246.44 | 246.9399 | 245.9 | 246.3835 | 1038416.0 |
| 2021-05-21 11:00:00 | MSFT | Stock | 246.37 | 246.58 | 245.76 | 245.85 | 918012.0 |
| 2021-05-21 11:30:00 | MSFT | Stock | 245.8597 | 246.45 | 245.47 | 245.49 | 795995.0 |
| 2021-05-21 12:00:00 | MSFT | Stock | 245.46 | 245.74 | 244.99 | 245.56 | 759725.0 |
| 2021-05-21 12:30:00 | MSFT | Stock | 245.54 | 245.775 | 244.96 | 245.26 | 800616.0 |
> showing 50 of 107,832 rows — these rows as CSV