PREVIEW / stock_30min / 2021-04-19
file: by_date/stock_30min/2021/2021-04-19.parquet size: 2.2 MB rows: 112,127 symbols: 2,972
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-19 04:00:00 | AAPL | Stock | 134.24 | 134.39 | 134.16 | 134.26 | 7683.0 |
| 2021-04-19 04:30:00 | AAPL | Stock | 134.32 | 134.4 | 134.29 | 134.4 | 2427.0 |
| 2021-04-19 05:00:00 | AAPL | Stock | 134.35 | 134.39 | 134.2 | 134.27 | 2877.0 |
| 2021-04-19 05:30:00 | AAPL | Stock | 134.24 | 134.31 | 134.18 | 134.31 | 1803.0 |
| 2021-04-19 06:00:00 | AAPL | Stock | 134.3 | 134.32 | 134.28 | 134.32 | 2230.0 |
| 2021-04-19 06:30:00 | AAPL | Stock | 134.29 | 134.29 | 133.76 | 134.01 | 16895.0 |
| 2021-04-19 07:00:00 | AAPL | Stock | 134.01 | 134.12 | 133.79 | 133.83 | 61461.0 |
| 2021-04-19 07:30:00 | AAPL | Stock | 133.83 | 133.99 | 133.82 | 133.96 | 23069.0 |
| 2021-04-19 08:00:00 | AAPL | Stock | 133.99 | 134.495 | 133.7 | 133.81 | 216335.0 |
| 2021-04-19 08:30:00 | AAPL | Stock | 133.8 | 133.86 | 133.71 | 133.77 | 104524.0 |
| 2021-04-19 09:00:00 | AAPL | Stock | 133.76 | 133.8798 | 133.47 | 133.47 | 183422.0 |
| 2021-04-19 09:30:00 | AAPL | Stock | 133.47 | 135.33 | 133.34 | 135.22 | 12323690.0 |
| 2021-04-19 10:00:00 | AAPL | Stock | 135.23 | 135.47 | 134.26 | 134.81 | 7825935.0 |
| 2021-04-19 10:30:00 | AAPL | Stock | 134.81 | 135.22 | 134.15 | 134.7961 | 6334513.0 |
| 2021-04-19 11:00:00 | AAPL | Stock | 134.8 | 135.09 | 134.6399 | 134.94 | 4663769.0 |
| 2021-04-19 11:30:00 | AAPL | Stock | 134.93 | 134.95 | 134.25 | 134.38 | 4716047.0 |
| 2021-04-19 12:00:00 | AAPL | Stock | 134.37 | 134.54 | 134.015 | 134.1782 | 4102270.0 |
| 2021-04-19 12:30:00 | AAPL | Stock | 134.1709 | 134.2 | 133.72 | 134.0462 | 4368725.0 |
| 2021-04-19 13:00:00 | AAPL | Stock | 134.055 | 134.54 | 133.96 | 134.39 | 3239728.0 |
| 2021-04-19 13:30:00 | AAPL | Stock | 134.395 | 134.67 | 134.3 | 134.553 | 2290304.0 |
| 2021-04-19 14:00:00 | AAPL | Stock | 134.55 | 134.82 | 134.391 | 134.75 | 3088647.0 |
| 2021-04-19 14:30:00 | AAPL | Stock | 134.74 | 134.76 | 134.33 | 134.575 | 3094452.0 |
| 2021-04-19 15:00:00 | AAPL | Stock | 134.58 | 134.61 | 134.2 | 134.29 | 3414095.0 |
| 2021-04-19 15:30:00 | AAPL | Stock | 134.285 | 134.94 | 134.145 | 134.86 | 6487949.0 |
| 2021-04-19 16:00:00 | AAPL | Stock | 134.84 | 134.93 | 134.55 | 134.86 | 13227905.0 |
| 2021-04-19 16:30:00 | AAPL | Stock | 134.89 | 134.9 | 134.73 | 134.8 | 65896.0 |
| 2021-04-19 17:00:00 | AAPL | Stock | 134.8 | 134.85 | 134.77 | 134.83 | 21626.0 |
| 2021-04-19 17:30:00 | AAPL | Stock | 134.84 | 134.9 | 134.82 | 134.9 | 26607.0 |
| 2021-04-19 18:00:00 | AAPL | Stock | 134.89 | 135.0 | 134.86 | 134.95 | 47028.0 |
| 2021-04-19 18:30:00 | AAPL | Stock | 134.95 | 135.0 | 134.84 | 134.99 | 122142.0 |
| 2021-04-19 19:00:00 | AAPL | Stock | 134.96 | 135.0 | 134.96 | 134.97 | 28826.0 |
| 2021-04-19 19:30:00 | AAPL | Stock | 134.97 | 135.0 | 134.89 | 134.98 | 61198.0 |
| 2021-04-19 04:00:00 | MSFT | Stock | 261.0 | 261.0 | 260.7 | 260.7 | 1015.0 |
| 2021-04-19 05:00:00 | MSFT | Stock | 260.63 | 261.0 | 260.63 | 261.0 | 1999.0 |
| 2021-04-19 05:30:00 | MSFT | Stock | 260.94 | 261.4 | 260.94 | 261.3 | 1383.0 |
| 2021-04-19 06:00:00 | MSFT | Stock | 261.35 | 261.39 | 261.21 | 261.21 | 575.0 |
| 2021-04-19 06:30:00 | MSFT | Stock | 261.02 | 261.02 | 260.0 | 260.0 | 3527.0 |
| 2021-04-19 07:00:00 | MSFT | Stock | 260.17 | 260.67 | 260.05 | 260.13 | 7364.0 |
| 2021-04-19 07:30:00 | MSFT | Stock | 260.35 | 260.75 | 260.25 | 260.45 | 7125.0 |
| 2021-04-19 08:00:00 | MSFT | Stock | 260.8 | 260.8 | 259.99 | 260.38 | 23232.0 |
| 2021-04-19 08:30:00 | MSFT | Stock | 260.32 | 260.39 | 259.98 | 259.98 | 19903.0 |
| 2021-04-19 09:00:00 | MSFT | Stock | 260.07 | 260.6 | 259.18 | 260.24 | 28610.0 |
| 2021-04-19 09:30:00 | MSFT | Stock | 260.19 | 261.48 | 259.32 | 260.41 | 1780348.0 |
| 2021-04-19 10:00:00 | MSFT | Stock | 260.405 | 260.752 | 259.05 | 259.88 | 1288592.0 |
| 2021-04-19 10:30:00 | MSFT | Stock | 259.89 | 260.331 | 258.765 | 260.12 | 1271113.0 |
| 2021-04-19 11:00:00 | MSFT | Stock | 260.11 | 260.48 | 259.72 | 259.89 | 849501.0 |
| 2021-04-19 11:30:00 | MSFT | Stock | 259.88 | 259.89 | 258.83 | 259.03 | 876362.0 |
| 2021-04-19 12:00:00 | MSFT | Stock | 259.01 | 259.05 | 258.16 | 258.34 | 845512.0 |
| 2021-04-19 12:30:00 | MSFT | Stock | 258.35 | 258.44 | 257.821 | 258.21 | 739409.0 |
| 2021-04-19 13:00:00 | MSFT | Stock | 258.21 | 258.94 | 258.05 | 258.395 | 694546.0 |
> showing 50 of 112,127 rows — these rows as CSV