PREVIEW / stock_30min / 2021-04-15
file: by_date/stock_30min/2021/2021-04-15.parquet size: 2.2 MB rows: 111,093 symbols: 2,956
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-15 04:00:00 | AAPL | Stock | 132.77 | 133.07 | 132.62 | 132.7 | 14893.0 |
| 2021-04-15 04:30:00 | AAPL | Stock | 132.78 | 132.78 | 132.72 | 132.75 | 1841.0 |
| 2021-04-15 05:00:00 | AAPL | Stock | 132.82 | 132.83 | 132.72 | 132.83 | 4028.0 |
| 2021-04-15 05:30:00 | AAPL | Stock | 132.76 | 132.81 | 132.72 | 132.8 | 2802.0 |
| 2021-04-15 06:00:00 | AAPL | Stock | 132.72 | 132.8 | 132.65 | 132.8 | 3368.0 |
| 2021-04-15 06:30:00 | AAPL | Stock | 132.77 | 133.07 | 132.77 | 133.01 | 4653.0 |
| 2021-04-15 07:00:00 | AAPL | Stock | 132.95 | 133.36 | 132.9 | 133.3 | 100282.0 |
| 2021-04-15 07:30:00 | AAPL | Stock | 133.32 | 133.43 | 133.2 | 133.29 | 77503.0 |
| 2021-04-15 08:00:00 | AAPL | Stock | 132.9701 | 133.71 | 132.36 | 133.48 | 288165.0 |
| 2021-04-15 08:30:00 | AAPL | Stock | 133.48 | 133.75 | 133.48 | 133.69 | 198233.0 |
| 2021-04-15 09:00:00 | AAPL | Stock | 133.69 | 133.99 | 133.44 | 133.82 | 297203.0 |
| 2021-04-15 09:30:00 | AAPL | Stock | 133.82 | 134.96 | 133.64 | 134.3599 | 13241804.0 |
| 2021-04-15 10:00:00 | AAPL | Stock | 134.36 | 134.945 | 134.07 | 134.94 | 7133185.0 |
| 2021-04-15 10:30:00 | AAPL | Stock | 134.9318 | 135.0 | 134.19 | 134.31 | 6233005.0 |
| 2021-04-15 11:00:00 | AAPL | Stock | 134.3 | 134.695 | 134.17 | 134.215 | 4109892.0 |
| 2021-04-15 11:30:00 | AAPL | Stock | 134.215 | 134.45 | 134.05 | 134.3119 | 3805141.0 |
| 2021-04-15 12:00:00 | AAPL | Stock | 134.31 | 134.355 | 133.71 | 133.7711 | 4721103.0 |
| 2021-04-15 12:30:00 | AAPL | Stock | 133.7719 | 134.5872 | 133.7 | 134.57 | 4685546.0 |
| 2021-04-15 13:00:00 | AAPL | Stock | 134.575 | 134.67 | 134.27 | 134.6401 | 3174641.0 |
| 2021-04-15 13:30:00 | AAPL | Stock | 134.645 | 134.76 | 134.531 | 134.585 | 2615639.0 |
| 2021-04-15 14:00:00 | AAPL | Stock | 134.59 | 134.6899 | 134.35 | 134.4999 | 2410162.0 |
| 2021-04-15 14:30:00 | AAPL | Stock | 134.5 | 134.59 | 134.13 | 134.28 | 3187807.0 |
| 2021-04-15 15:00:00 | AAPL | Stock | 134.27 | 134.34 | 133.94 | 134.09 | 3427294.0 |
| 2021-04-15 15:30:00 | AAPL | Stock | 134.095 | 134.51 | 133.99 | 134.51 | 7341881.0 |
| 2021-04-15 16:00:00 | AAPL | Stock | 134.5 | 134.5 | 134.35 | 134.35 | 11124981.0 |
| 2021-04-15 16:30:00 | AAPL | Stock | 134.35 | 134.48 | 134.2 | 134.28 | 39225.0 |
| 2021-04-15 17:00:00 | AAPL | Stock | 134.26 | 134.31 | 134.2 | 134.31 | 31486.0 |
| 2021-04-15 17:30:00 | AAPL | Stock | 134.3 | 134.35 | 134.25 | 134.34 | 7973.0 |
| 2021-04-15 18:00:00 | AAPL | Stock | 134.27 | 134.35 | 134.19 | 134.31 | 28401.0 |
| 2021-04-15 18:30:00 | AAPL | Stock | 134.33 | 134.4 | 134.33 | 134.4 | 19977.0 |
| 2021-04-15 19:00:00 | AAPL | Stock | 134.39 | 134.39 | 134.33 | 134.33 | 13155.0 |
| 2021-04-15 19:30:00 | AAPL | Stock | 134.33 | 134.39 | 134.3 | 134.37 | 22337.0 |
| 2021-04-15 04:00:00 | MSFT | Stock | 257.52 | 257.52 | 257.2 | 257.41 | 1359.0 |
| 2021-04-15 04:30:00 | MSFT | Stock | 257.15 | 257.48 | 257.15 | 257.4 | 925.0 |
| 2021-04-15 05:00:00 | MSFT | Stock | 257.46 | 257.53 | 257.46 | 257.53 | 1318.0 |
| 2021-04-15 05:30:00 | MSFT | Stock | 257.36 | 257.36 | 257.1 | 257.1 | 2336.0 |
| 2021-04-15 06:00:00 | MSFT | Stock | 257.07 | 257.43 | 257.07 | 257.36 | 4749.0 |
| 2021-04-15 06:30:00 | MSFT | Stock | 257.38 | 257.5 | 257.34 | 257.5 | 2459.0 |
| 2021-04-15 07:00:00 | MSFT | Stock | 257.63 | 257.71 | 257.04 | 257.48 | 8706.0 |
| 2021-04-15 07:30:00 | MSFT | Stock | 257.43 | 257.67 | 257.23 | 257.65 | 8066.0 |
| 2021-04-15 08:00:00 | MSFT | Stock | 257.16 | 257.9 | 254.952 | 257.55 | 21667.0 |
| 2021-04-15 08:30:00 | MSFT | Stock | 257.74 | 258.29 | 257.74 | 258.0 | 33686.0 |
| 2021-04-15 09:00:00 | MSFT | Stock | 258.01 | 258.49 | 257.7 | 257.79 | 57652.0 |
| 2021-04-15 09:30:00 | MSFT | Stock | 257.85 | 259.35 | 257.73 | 258.53 | 1928117.0 |
| 2021-04-15 10:00:00 | MSFT | Stock | 258.54 | 259.1785 | 258.12 | 259.13 | 1116730.0 |
| 2021-04-15 10:30:00 | MSFT | Stock | 259.12 | 259.68 | 258.83 | 259.11 | 1231643.0 |
| 2021-04-15 11:00:00 | MSFT | Stock | 259.11 | 259.59 | 258.57 | 258.6782 | 1049352.0 |
| 2021-04-15 11:30:00 | MSFT | Stock | 258.69 | 259.07 | 258.0 | 258.21 | 903376.0 |
| 2021-04-15 12:00:00 | MSFT | Stock | 258.21 | 258.86 | 257.9 | 258.79 | 634834.0 |
| 2021-04-15 12:30:00 | MSFT | Stock | 258.8 | 259.69 | 258.8 | 259.67 | 853128.0 |
> showing 50 of 111,093 rows — these rows as CSV