PREVIEW / stock_30min / 2020-12-03
file: by_date/stock_30min/2020/2020-12-03.parquet size: 2.1 MB rows: 104,627 symbols: 2,627
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-12-03 04:00:00 | AAPL | Stock | 123.27 | 123.36 | 123.23 | 123.23 | 7099.0 |
| 2020-12-03 04:30:00 | AAPL | Stock | 123.25 | 123.36 | 123.23 | 123.36 | 1760.0 |
| 2020-12-03 05:00:00 | AAPL | Stock | 123.4 | 123.4 | 123.28 | 123.28 | 841.0 |
| 2020-12-03 05:30:00 | AAPL | Stock | 123.25 | 123.33 | 123.25 | 123.33 | 3358.0 |
| 2020-12-03 06:00:00 | AAPL | Stock | 123.33 | 123.4 | 123.29 | 123.35 | 6310.0 |
| 2020-12-03 06:30:00 | AAPL | Stock | 123.36 | 123.4 | 123.32 | 123.36 | 5320.0 |
| 2020-12-03 07:00:00 | AAPL | Stock | 123.33 | 123.88 | 123.33 | 123.67 | 149991.0 |
| 2020-12-03 07:30:00 | AAPL | Stock | 123.68 | 123.75 | 123.51 | 123.67 | 54708.0 |
| 2020-12-03 08:00:00 | AAPL | Stock | 123.83 | 123.88 | 123.41 | 123.62 | 211600.0 |
| 2020-12-03 08:30:00 | AAPL | Stock | 123.63 | 123.66 | 123.43 | 123.48 | 119815.0 |
| 2020-12-03 09:00:00 | AAPL | Stock | 123.479 | 123.55 | 123.42 | 123.51 | 121160.0 |
| 2020-12-03 09:30:00 | AAPL | Stock | 123.52 | 123.78 | 122.69 | 123.16 | 11054958.0 |
| 2020-12-03 10:00:00 | AAPL | Stock | 123.16 | 123.45 | 122.85 | 122.91 | 6458277.0 |
| 2020-12-03 10:30:00 | AAPL | Stock | 122.91 | 123.27 | 122.58 | 122.603 | 5977647.0 |
| 2020-12-03 11:00:00 | AAPL | Stock | 122.61 | 122.88 | 122.21 | 122.82 | 4935048.0 |
| 2020-12-03 11:30:00 | AAPL | Stock | 122.83 | 123.19 | 122.78 | 123.095 | 3435720.0 |
| 2020-12-03 12:00:00 | AAPL | Stock | 123.1 | 123.23 | 122.78 | 122.911 | 3477051.0 |
| 2020-12-03 12:30:00 | AAPL | Stock | 122.91 | 123.2 | 122.74 | 122.885 | 2446623.0 |
| 2020-12-03 13:00:00 | AAPL | Stock | 122.88 | 123.03 | 122.72 | 122.99 | 2554767.0 |
| 2020-12-03 13:30:00 | AAPL | Stock | 122.981 | 123.01 | 122.595 | 122.66 | 2469267.0 |
| 2020-12-03 14:00:00 | AAPL | Stock | 122.67 | 123.01 | 122.615 | 122.855 | 2675544.0 |
| 2020-12-03 14:30:00 | AAPL | Stock | 122.855 | 123.1 | 122.81 | 123.039 | 2616140.0 |
| 2020-12-03 15:00:00 | AAPL | Stock | 123.035 | 123.33 | 122.945 | 123.222 | 3849852.0 |
| 2020-12-03 15:30:00 | AAPL | Stock | 123.23 | 123.33 | 122.53 | 122.94 | 8330987.0 |
| 2020-12-03 16:00:00 | AAPL | Stock | 122.94 | 123.05 | 122.73 | 122.85 | 10864015.0 |
| 2020-12-03 16:30:00 | AAPL | Stock | 122.85 | 122.94 | 122.75 | 122.85 | 88088.0 |
| 2020-12-03 17:00:00 | AAPL | Stock | 122.82 | 122.87 | 122.77 | 122.77 | 33266.0 |
| 2020-12-03 17:30:00 | AAPL | Stock | 122.77 | 122.82 | 122.77 | 122.8 | 18465.0 |
| 2020-12-03 18:00:00 | AAPL | Stock | 122.8 | 122.9 | 122.78 | 122.83 | 33215.0 |
| 2020-12-03 18:30:00 | AAPL | Stock | 122.83 | 122.95 | 122.8 | 122.87 | 34197.0 |
| 2020-12-03 19:00:00 | AAPL | Stock | 122.9 | 122.94 | 122.83 | 122.92 | 15179.0 |
| 2020-12-03 19:30:00 | AAPL | Stock | 122.92 | 123.05 | 122.85 | 122.88 | 55675.0 |
| 2020-12-03 04:00:00 | MSFT | Stock | 215.45 | 215.45 | 215.05 | 215.05 | 760.0 |
| 2020-12-03 04:30:00 | MSFT | Stock | 215.19 | 215.2 | 215.19 | 215.2 | 300.0 |
| 2020-12-03 05:00:00 | MSFT | Stock | 215.25 | 215.25 | 215.25 | 215.25 | 100.0 |
| 2020-12-03 05:30:00 | MSFT | Stock | 214.89 | 215.0 | 214.89 | 215.0 | 322.0 |
| 2020-12-03 06:30:00 | MSFT | Stock | 215.19 | 215.48 | 215.19 | 215.48 | 1839.0 |
| 2020-12-03 07:00:00 | MSFT | Stock | 215.25 | 215.37 | 214.9 | 214.95 | 6006.0 |
| 2020-12-03 07:30:00 | MSFT | Stock | 214.95 | 215.16 | 214.9 | 215.07 | 3983.0 |
| 2020-12-03 08:00:00 | MSFT | Stock | 214.8 | 215.336 | 214.75 | 215.187 | 19004.0 |
| 2020-12-03 08:30:00 | MSFT | Stock | 215.32 | 215.37 | 214.85 | 215.1 | 22726.0 |
| 2020-12-03 09:00:00 | MSFT | Stock | 215.2 | 215.24 | 214.6 | 214.61 | 23645.0 |
| 2020-12-03 09:30:00 | MSFT | Stock | 214.69 | 215.22 | 214.33 | 214.96 | 2314340.0 |
| 2020-12-03 10:00:00 | MSFT | Stock | 214.96 | 216.376 | 214.84 | 215.542 | 1778976.0 |
| 2020-12-03 10:30:00 | MSFT | Stock | 215.55 | 215.74 | 214.25 | 214.6 | 1725979.0 |
| 2020-12-03 11:00:00 | MSFT | Stock | 214.6 | 214.82 | 213.95 | 214.53 | 1637475.0 |
| 2020-12-03 11:30:00 | MSFT | Stock | 214.52 | 214.962 | 214.23 | 214.68 | 902621.0 |
| 2020-12-03 12:00:00 | MSFT | Stock | 214.69 | 214.99 | 214.32 | 214.48 | 712951.0 |
| 2020-12-03 12:30:00 | MSFT | Stock | 214.47 | 214.94 | 214.27 | 214.45 | 706143.0 |
| 2020-12-03 13:00:00 | MSFT | Stock | 214.47 | 214.59 | 214.12 | 214.38 | 879843.0 |
> showing 50 of 104,627 rows — these rows as CSV