PREVIEW / stock_30min / 2020-09-30
file: by_date/stock_30min/2020/2020-09-30.parquet size: 1.9 MB rows: 97,318 symbols: 2,502
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 |
|---|---|---|---|---|---|---|---|
| 2020-09-30 04:00:00 | AAPL | Stock | 113.1 | 113.4 | 112.75 | 112.97 | 25607.0 |
| 2020-09-30 04:30:00 | AAPL | Stock | 113.06 | 113.26 | 112.72 | 113.26 | 9318.0 |
| 2020-09-30 05:00:00 | AAPL | Stock | 113.26 | 113.27 | 112.44 | 112.61 | 13446.0 |
| 2020-09-30 05:30:00 | AAPL | Stock | 112.7 | 113.14 | 112.7 | 113.07 | 10849.0 |
| 2020-09-30 06:00:00 | AAPL | Stock | 113.06 | 113.1 | 112.76 | 113.1 | 4175.0 |
| 2020-09-30 06:30:00 | AAPL | Stock | 113.12 | 113.71 | 113.12 | 113.5 | 16176.0 |
| 2020-09-30 07:00:00 | AAPL | Stock | 113.49 | 113.63 | 113.19 | 113.48 | 153247.0 |
| 2020-09-30 07:30:00 | AAPL | Stock | 113.55 | 113.55 | 113.12 | 113.2 | 75030.0 |
| 2020-09-30 08:00:00 | AAPL | Stock | 113.49 | 114.37 | 113.08 | 113.7 | 431822.0 |
| 2020-09-30 08:30:00 | AAPL | Stock | 113.7 | 114.23 | 113.61 | 114.03 | 331338.0 |
| 2020-09-30 09:00:00 | AAPL | Stock | 114.01 | 114.19 | 113.6 | 113.65 | 235872.0 |
| 2020-09-30 09:30:00 | AAPL | Stock | 113.79 | 115.86 | 113.62 | 115.76 | 13204296.0 |
| 2020-09-30 10:00:00 | AAPL | Stock | 115.74 | 116.49 | 115.32 | 116.15 | 12705194.0 |
| 2020-09-30 10:30:00 | AAPL | Stock | 116.135 | 116.42 | 115.77 | 116.17 | 8565899.0 |
| 2020-09-30 11:00:00 | AAPL | Stock | 116.155 | 116.29 | 115.71 | 115.81 | 6923825.0 |
| 2020-09-30 11:30:00 | AAPL | Stock | 115.83 | 116.695 | 115.76 | 116.58 | 7602500.0 |
| 2020-09-30 12:00:00 | AAPL | Stock | 116.58 | 116.89 | 116.47 | 116.595 | 5044764.0 |
| 2020-09-30 12:30:00 | AAPL | Stock | 116.6 | 116.74 | 116.05 | 116.24 | 4493777.0 |
| 2020-09-30 13:00:00 | AAPL | Stock | 116.24 | 116.295 | 115.78 | 116.27 | 4631663.0 |
| 2020-09-30 13:30:00 | AAPL | Stock | 116.25 | 116.97 | 116.24 | 116.82 | 5580562.0 |
| 2020-09-30 14:00:00 | AAPL | Stock | 116.83 | 117.26 | 116.35 | 116.75 | 9168771.0 |
| 2020-09-30 14:30:00 | AAPL | Stock | 116.71 | 116.735 | 115.67 | 116.374 | 9291629.0 |
| 2020-09-30 15:00:00 | AAPL | Stock | 116.37 | 116.65 | 114.96 | 115.585 | 11782627.0 |
| 2020-09-30 15:30:00 | AAPL | Stock | 115.59 | 116.4 | 115.15 | 115.61 | 13053551.0 |
| 2020-09-30 16:00:00 | AAPL | Stock | 115.79 | 115.982 | 115.19 | 115.42 | 15756215.0 |
| 2020-09-30 16:30:00 | AAPL | Stock | 115.45 | 115.81 | 115.2 | 115.33 | 133736.0 |
| 2020-09-30 17:00:00 | AAPL | Stock | 115.3 | 115.59 | 115.3 | 115.48 | 81069.0 |
| 2020-09-30 17:30:00 | AAPL | Stock | 115.5 | 115.6 | 115.47 | 115.57 | 48409.0 |
| 2020-09-30 18:00:00 | AAPL | Stock | 115.59 | 116.0 | 115.59 | 115.91 | 121312.0 |
| 2020-09-30 18:30:00 | AAPL | Stock | 115.91 | 116.15 | 115.85 | 116.05 | 79481.0 |
| 2020-09-30 19:00:00 | AAPL | Stock | 116.09 | 116.15 | 116.01 | 116.04 | 61180.0 |
| 2020-09-30 19:30:00 | AAPL | Stock | 116.04 | 116.3 | 116.01 | 116.3 | 121768.0 |
| 2020-09-30 04:00:00 | MSFT | Stock | 205.45 | 206.13 | 205.25 | 205.25 | 2466.0 |
| 2020-09-30 04:30:00 | MSFT | Stock | 205.26 | 206.27 | 205.15 | 206.27 | 3409.0 |
| 2020-09-30 05:00:00 | MSFT | Stock | 205.63 | 205.63 | 204.79 | 204.79 | 3258.0 |
| 2020-09-30 05:30:00 | MSFT | Stock | 204.78 | 205.7 | 204.78 | 205.7 | 901.0 |
| 2020-09-30 06:00:00 | MSFT | Stock | 205.79 | 205.79 | 205.79 | 205.79 | 100.0 |
| 2020-09-30 06:30:00 | MSFT | Stock | 206.36 | 206.91 | 206.36 | 206.91 | 971.0 |
| 2020-09-30 07:00:00 | MSFT | Stock | 206.37 | 206.6 | 206.22 | 206.35 | 9628.0 |
| 2020-09-30 07:30:00 | MSFT | Stock | 206.42 | 206.42 | 206.0 | 206.0 | 9748.0 |
| 2020-09-30 08:00:00 | MSFT | Stock | 206.37 | 206.91 | 205.97 | 206.91 | 18810.0 |
| 2020-09-30 08:30:00 | MSFT | Stock | 206.95 | 207.5 | 206.8 | 207.26 | 18919.0 |
| 2020-09-30 09:00:00 | MSFT | Stock | 207.01 | 207.95 | 207.01 | 207.63 | 17183.0 |
| 2020-09-30 09:30:00 | MSFT | Stock | 207.63 | 208.48 | 206.54 | 208.4 | 2523161.0 |
| 2020-09-30 10:00:00 | MSFT | Stock | 208.404 | 209.79 | 207.89 | 209.19 | 1891304.0 |
| 2020-09-30 10:30:00 | MSFT | Stock | 209.18 | 209.68 | 208.843 | 209.168 | 953075.0 |
| 2020-09-30 11:00:00 | MSFT | Stock | 209.15 | 211.38 | 209.02 | 211.27 | 1756104.0 |
| 2020-09-30 11:30:00 | MSFT | Stock | 211.27 | 211.8 | 210.82 | 211.44 | 1532625.0 |
| 2020-09-30 12:00:00 | MSFT | Stock | 211.445 | 211.84 | 211.38 | 211.8 | 1038078.0 |
| 2020-09-30 12:30:00 | MSFT | Stock | 211.81 | 211.98 | 210.61 | 210.85 | 1093343.0 |
> showing 50 of 97,318 rows — these rows as CSV