PREVIEW / stock_30min / 2021-02-05
file: by_date/stock_30min/2021/2021-02-05.parquet size: 2.3 MB rows: 119,343 symbols: 2,779
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-02-05 04:00:00 | AAPL | Stock | 137.03 | 137.7 | 137.0 | 137.7 | 11913.0 |
| 2021-02-05 04:30:00 | AAPL | Stock | 137.64 | 137.85 | 137.5 | 137.58 | 14343.0 |
| 2021-02-05 05:00:00 | AAPL | Stock | 137.73 | 137.82 | 137.58 | 137.73 | 10878.0 |
| 2021-02-05 05:30:00 | AAPL | Stock | 137.73 | 137.86 | 137.7 | 137.86 | 27672.0 |
| 2021-02-05 06:00:00 | AAPL | Stock | 137.89 | 138.04 | 137.6 | 137.7 | 45717.0 |
| 2021-02-05 06:30:00 | AAPL | Stock | 137.71 | 137.98 | 137.71 | 137.85 | 10651.0 |
| 2021-02-05 07:00:00 | AAPL | Stock | 137.78 | 138.19 | 137.71 | 138.06 | 155896.0 |
| 2021-02-05 07:30:00 | AAPL | Stock | 138.03 | 138.1 | 137.9 | 138.05 | 70795.0 |
| 2021-02-05 08:00:00 | AAPL | Stock | 137.85 | 138.19 | 137.525 | 137.79 | 334310.0 |
| 2021-02-05 08:30:00 | AAPL | Stock | 137.77 | 138.04 | 137.6 | 137.75 | 248138.0 |
| 2021-02-05 09:00:00 | AAPL | Stock | 137.75 | 137.86 | 137.19 | 137.3 | 319787.0 |
| 2021-02-05 09:30:00 | AAPL | Stock | 137.32 | 137.42 | 136.08 | 136.53 | 11052664.0 |
| 2021-02-05 10:00:00 | AAPL | Stock | 136.53 | 136.76 | 135.86 | 136.4 | 6840300.0 |
| 2021-02-05 10:30:00 | AAPL | Stock | 136.395 | 136.57 | 135.99 | 136.47 | 4468037.0 |
| 2021-02-05 11:00:00 | AAPL | Stock | 136.47 | 136.67 | 136.2 | 136.294 | 3589189.0 |
| 2021-02-05 11:30:00 | AAPL | Stock | 136.305 | 136.77 | 136.3 | 136.589 | 2829419.0 |
| 2021-02-05 12:00:00 | AAPL | Stock | 136.58 | 137.02 | 136.515 | 136.99 | 3703194.0 |
| 2021-02-05 12:30:00 | AAPL | Stock | 136.999 | 137.129 | 136.79 | 137.06 | 2820753.0 |
| 2021-02-05 13:00:00 | AAPL | Stock | 137.06 | 137.33 | 136.94 | 137.075 | 2886101.0 |
| 2021-02-05 13:30:00 | AAPL | Stock | 137.075 | 137.08 | 136.51 | 136.535 | 3127796.0 |
| 2021-02-05 14:00:00 | AAPL | Stock | 136.54 | 136.78 | 136.451 | 136.58 | 2913988.0 |
| 2021-02-05 14:30:00 | AAPL | Stock | 136.59 | 136.7 | 136.42 | 136.665 | 2403145.0 |
| 2021-02-05 15:00:00 | AAPL | Stock | 136.66 | 136.74 | 136.06 | 136.205 | 4464193.0 |
| 2021-02-05 15:30:00 | AAPL | Stock | 136.201 | 136.83 | 136.18 | 136.77 | 5791117.0 |
| 2021-02-05 16:00:00 | AAPL | Stock | 136.76 | 136.91 | 136.12 | 136.69 | 4894770.0 |
| 2021-02-05 16:30:00 | AAPL | Stock | 136.69 | 136.8 | 135.85 | 136.55 | 238850.0 |
| 2021-02-05 17:00:00 | AAPL | Stock | 136.55 | 136.68 | 136.35 | 136.4 | 62068.0 |
| 2021-02-05 17:30:00 | AAPL | Stock | 136.36 | 136.44 | 136.26 | 136.38 | 53442.0 |
| 2021-02-05 18:00:00 | AAPL | Stock | 136.37 | 136.38 | 136.24 | 136.28 | 39132.0 |
| 2021-02-05 18:30:00 | AAPL | Stock | 136.3 | 136.36 | 136.29 | 136.35 | 24706.0 |
| 2021-02-05 19:00:00 | AAPL | Stock | 136.33 | 136.43 | 136.31 | 136.42 | 20266.0 |
| 2021-02-05 19:30:00 | AAPL | Stock | 136.4 | 136.7 | 136.39 | 136.68 | 74417.0 |
| 2021-02-05 04:00:00 | MSFT | Stock | 242.71 | 242.71 | 242.71 | 242.71 | 995.0 |
| 2021-02-05 05:00:00 | MSFT | Stock | 242.63 | 242.63 | 242.55 | 242.55 | 466.0 |
| 2021-02-05 05:30:00 | MSFT | Stock | 242.63 | 242.63 | 242.07 | 242.07 | 1016.0 |
| 2021-02-05 06:00:00 | MSFT | Stock | 242.18 | 242.2 | 241.91 | 241.91 | 2668.0 |
| 2021-02-05 06:30:00 | MSFT | Stock | 242.14 | 242.7 | 242.14 | 242.69 | 7396.0 |
| 2021-02-05 07:00:00 | MSFT | Stock | 242.7 | 242.75 | 242.52 | 242.58 | 7808.0 |
| 2021-02-05 07:30:00 | MSFT | Stock | 242.6 | 242.78 | 242.6 | 242.76 | 15868.0 |
| 2021-02-05 08:00:00 | MSFT | Stock | 242.7 | 242.84 | 241.41 | 242.56 | 18033.0 |
| 2021-02-05 08:30:00 | MSFT | Stock | 242.58 | 242.77 | 242.2 | 242.2 | 134124.0 |
| 2021-02-05 09:00:00 | MSFT | Stock | 242.15 | 242.4 | 242.09 | 242.24 | 26530.0 |
| 2021-02-05 09:30:00 | MSFT | Stock | 242.23 | 243.28 | 240.42 | 240.72 | 2163538.0 |
| 2021-02-05 10:00:00 | MSFT | Stock | 240.74 | 241.85 | 240.53 | 241.58 | 1188304.0 |
| 2021-02-05 10:30:00 | MSFT | Stock | 241.57 | 242.03 | 241.04 | 241.61 | 844803.0 |
| 2021-02-05 11:00:00 | MSFT | Stock | 241.61 | 241.89 | 240.77 | 240.882 | 925027.0 |
| 2021-02-05 11:30:00 | MSFT | Stock | 240.9 | 241.35 | 240.8 | 240.96 | 634717.0 |
| 2021-02-05 12:00:00 | MSFT | Stock | 240.97 | 241.99 | 240.9 | 241.75 | 658392.0 |
| 2021-02-05 12:30:00 | MSFT | Stock | 241.76 | 242.51 | 241.71 | 242.5 | 624249.0 |
| 2021-02-05 13:00:00 | MSFT | Stock | 242.5 | 242.67 | 242.12 | 242.445 | 591847.0 |
> showing 50 of 119,343 rows — these rows as CSV