PREVIEW / stock_30min / 2021-04-22
file: by_date/stock_30min/2021/2021-04-22.parquet size: 2.2 MB rows: 109,533 symbols: 2,957
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-04-22 04:00:00 | AAPL | Stock | 133.4 | 133.5 | 133.36 | 133.46 | 4778.0 |
| 2021-04-22 04:30:00 | AAPL | Stock | 133.48 | 133.6 | 133.45 | 133.45 | 2313.0 |
| 2021-04-22 05:00:00 | AAPL | Stock | 133.4 | 133.5 | 133.4 | 133.5 | 3132.0 |
| 2021-04-22 05:30:00 | AAPL | Stock | 133.32 | 133.36 | 133.3 | 133.36 | 790.0 |
| 2021-04-22 06:00:00 | AAPL | Stock | 133.31 | 133.55 | 133.31 | 133.5 | 4212.0 |
| 2021-04-22 06:30:00 | AAPL | Stock | 133.54 | 133.55 | 133.44 | 133.44 | 3514.0 |
| 2021-04-22 07:00:00 | AAPL | Stock | 133.4 | 133.4 | 133.18 | 133.22 | 45743.0 |
| 2021-04-22 07:30:00 | AAPL | Stock | 133.23 | 133.26 | 133.01 | 133.11 | 34413.0 |
| 2021-04-22 08:00:00 | AAPL | Stock | 133.23 | 133.3 | 133.0 | 133.18 | 148665.0 |
| 2021-04-22 08:30:00 | AAPL | Stock | 133.18 | 133.46 | 133.12 | 133.3 | 112094.0 |
| 2021-04-22 09:00:00 | AAPL | Stock | 133.3 | 133.4 | 132.75 | 133.0 | 251292.0 |
| 2021-04-22 09:30:00 | AAPL | Stock | 132.86 | 133.26 | 132.52 | 132.96 | 7727394.0 |
| 2021-04-22 10:00:00 | AAPL | Stock | 132.9599 | 133.6899 | 132.61 | 133.65 | 5837597.0 |
| 2021-04-22 10:30:00 | AAPL | Stock | 133.66 | 134.15 | 133.63 | 133.965 | 5451853.0 |
| 2021-04-22 11:00:00 | AAPL | Stock | 133.97 | 134.11 | 133.62 | 133.71 | 3466177.0 |
| 2021-04-22 11:30:00 | AAPL | Stock | 133.705 | 134.025 | 133.625 | 133.8117 | 2779112.0 |
| 2021-04-22 12:00:00 | AAPL | Stock | 133.82 | 133.93 | 133.54 | 133.89 | 2620061.0 |
| 2021-04-22 12:30:00 | AAPL | Stock | 133.8914 | 134.1 | 133.86 | 134.03 | 2431130.0 |
| 2021-04-22 13:00:00 | AAPL | Stock | 134.025 | 134.08 | 132.23 | 133.09 | 7626586.0 |
| 2021-04-22 13:30:00 | AAPL | Stock | 133.0901 | 133.1812 | 131.62 | 131.805 | 7138147.0 |
| 2021-04-22 14:00:00 | AAPL | Stock | 131.7976 | 132.53 | 131.41 | 132.475 | 7271667.0 |
| 2021-04-22 14:30:00 | AAPL | Stock | 132.4899 | 132.6 | 132.2 | 132.25 | 3846487.0 |
| 2021-04-22 15:00:00 | AAPL | Stock | 132.25 | 132.52 | 131.8616 | 132.0332 | 3888514.0 |
| 2021-04-22 15:30:00 | AAPL | Stock | 132.03 | 132.36 | 131.9 | 131.94 | 7236404.0 |
| 2021-04-22 16:00:00 | AAPL | Stock | 131.94 | 132.08 | 131.84 | 131.9 | 7246803.0 |
| 2021-04-22 16:30:00 | AAPL | Stock | 131.86 | 132.7582 | 131.86 | 131.96 | 57893.0 |
| 2021-04-22 17:00:00 | AAPL | Stock | 131.93 | 131.98 | 131.89 | 131.98 | 19486.0 |
| 2021-04-22 17:30:00 | AAPL | Stock | 131.93 | 131.99 | 131.84 | 131.88 | 23452.0 |
| 2021-04-22 18:00:00 | AAPL | Stock | 131.88 | 131.96 | 131.88 | 131.9099 | 24169.0 |
| 2021-04-22 18:30:00 | AAPL | Stock | 131.91 | 132.02 | 131.88 | 132.02 | 22986.0 |
| 2021-04-22 19:00:00 | AAPL | Stock | 132.02 | 132.08 | 131.94 | 131.94 | 12883.0 |
| 2021-04-22 19:30:00 | AAPL | Stock | 131.98 | 131.98 | 131.88 | 131.88 | 36130.0 |
| 2021-04-22 04:00:00 | MSFT | Stock | 260.6 | 260.6 | 260.34 | 260.52 | 2109.0 |
| 2021-04-22 04:30:00 | MSFT | Stock | 260.77 | 260.77 | 260.77 | 260.77 | 250.0 |
| 2021-04-22 05:00:00 | MSFT | Stock | 260.4 | 260.4 | 260.38 | 260.38 | 1297.0 |
| 2021-04-22 05:30:00 | MSFT | Stock | 260.21 | 260.21 | 260.0 | 260.0 | 2310.0 |
| 2021-04-22 06:00:00 | MSFT | Stock | 260.0 | 260.0 | 259.97 | 259.97 | 3959.0 |
| 2021-04-22 06:30:00 | MSFT | Stock | 260.1 | 260.34 | 260.03 | 260.03 | 1322.0 |
| 2021-04-22 07:00:00 | MSFT | Stock | 260.25 | 260.5 | 260.05 | 260.39 | 11229.0 |
| 2021-04-22 07:30:00 | MSFT | Stock | 260.29 | 260.29 | 260.0 | 260.01 | 3855.0 |
| 2021-04-22 08:00:00 | MSFT | Stock | 260.5 | 260.5 | 259.81 | 260.1 | 11315.0 |
| 2021-04-22 08:30:00 | MSFT | Stock | 260.1 | 260.57 | 260.03 | 260.4 | 12122.0 |
| 2021-04-22 09:00:00 | MSFT | Stock | 260.2 | 260.54 | 259.71 | 260.0 | 13876.0 |
| 2021-04-22 09:30:00 | MSFT | Stock | 260.21 | 261.78 | 259.93 | 260.25 | 2130500.0 |
| 2021-04-22 10:00:00 | MSFT | Stock | 260.22 | 261.27 | 259.74 | 261.14 | 1062763.0 |
| 2021-04-22 10:30:00 | MSFT | Stock | 261.16 | 261.7 | 260.79 | 261.12 | 893989.0 |
| 2021-04-22 11:00:00 | MSFT | Stock | 261.14 | 261.33 | 260.56 | 260.6 | 652409.0 |
| 2021-04-22 11:30:00 | MSFT | Stock | 260.62 | 260.8901 | 260.18 | 260.48 | 669217.0 |
| 2021-04-22 12:00:00 | MSFT | Stock | 260.49 | 260.78 | 260.31 | 260.73 | 455342.0 |
| 2021-04-22 12:30:00 | MSFT | Stock | 260.7202 | 261.02 | 260.62 | 260.815 | 558458.0 |
> showing 50 of 109,533 rows — these rows as CSV