PREVIEW / stock_30min / 2020-09-03
file: by_date/stock_30min/2020/2020-09-03.parquet size: 2.0 MB rows: 99,539 symbols: 2,474
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-03 04:00:00 | AAPL | Stock | 131.9 | 132.25 | 130.31 | 130.81 | 44507.0 |
| 2020-09-03 04:30:00 | AAPL | Stock | 130.94 | 131.04 | 130.45 | 130.5 | 29647.0 |
| 2020-09-03 05:00:00 | AAPL | Stock | 130.79 | 130.79 | 129.33 | 129.52 | 72117.0 |
| 2020-09-03 05:30:00 | AAPL | Stock | 129.68 | 129.81 | 128.32 | 128.32 | 61106.0 |
| 2020-09-03 06:00:00 | AAPL | Stock | 128.31 | 129.0 | 128.18 | 129.0 | 78226.0 |
| 2020-09-03 06:30:00 | AAPL | Stock | 129.06 | 129.49 | 128.65 | 129.15 | 54046.0 |
| 2020-09-03 07:00:00 | AAPL | Stock | 129.1 | 129.7 | 127.7 | 128.1 | 492504.0 |
| 2020-09-03 07:30:00 | AAPL | Stock | 128.05 | 128.95 | 128.0 | 128.4 | 247059.0 |
| 2020-09-03 08:00:00 | AAPL | Stock | 129.25 | 129.696 | 127.8 | 127.99 | 1047434.0 |
| 2020-09-03 08:30:00 | AAPL | Stock | 127.96 | 128.8 | 127.6 | 127.85 | 843504.0 |
| 2020-09-03 09:00:00 | AAPL | Stock | 127.75 | 127.84 | 126.49 | 126.94 | 1643699.0 |
| 2020-09-03 09:30:00 | AAPL | Stock | 126.94 | 128.84 | 126.27 | 127.345 | 24005072.0 |
| 2020-09-03 10:00:00 | AAPL | Stock | 127.32 | 127.79 | 125.24 | 126.135 | 17212645.0 |
| 2020-09-03 10:30:00 | AAPL | Stock | 126.125 | 126.57 | 123.22 | 124.98 | 22865902.0 |
| 2020-09-03 11:00:00 | AAPL | Stock | 124.975 | 125.089 | 120.72 | 123.295 | 24016713.0 |
| 2020-09-03 11:30:00 | AAPL | Stock | 123.276 | 125.17 | 122.92 | 124.1 | 15115673.0 |
| 2020-09-03 12:00:00 | AAPL | Stock | 124.115 | 124.41 | 123.15 | 123.39 | 9754335.0 |
| 2020-09-03 12:30:00 | AAPL | Stock | 123.4 | 123.48 | 122.08 | 122.695 | 10196289.0 |
| 2020-09-03 13:00:00 | AAPL | Stock | 122.698 | 123.84 | 121.81 | 123.783 | 10436516.0 |
| 2020-09-03 13:30:00 | AAPL | Stock | 123.77 | 123.77 | 122.07 | 122.756 | 8311028.0 |
| 2020-09-03 14:00:00 | AAPL | Stock | 122.76 | 123.4 | 122.25 | 122.775 | 6720932.0 |
| 2020-09-03 14:30:00 | AAPL | Stock | 122.77 | 123.38 | 121.77 | 121.77 | 8243143.0 |
| 2020-09-03 15:00:00 | AAPL | Stock | 121.808 | 122.29 | 120.8 | 120.85 | 14250733.0 |
| 2020-09-03 15:30:00 | AAPL | Stock | 120.86 | 121.7 | 120.5 | 120.92 | 25376901.0 |
| 2020-09-03 16:00:00 | AAPL | Stock | 120.94 | 122.965 | 120.07 | 120.71 | 17384654.0 |
| 2020-09-03 16:30:00 | AAPL | Stock | 120.7 | 121.4 | 120.4 | 121.4 | 1062540.0 |
| 2020-09-03 17:00:00 | AAPL | Stock | 121.35 | 121.65 | 120.06 | 120.17 | 561680.0 |
| 2020-09-03 17:30:00 | AAPL | Stock | 120.18 | 120.88 | 119.0 | 119.2 | 796028.0 |
| 2020-09-03 18:00:00 | AAPL | Stock | 119.26 | 119.7 | 118.1 | 118.35 | 644643.0 |
| 2020-09-03 18:30:00 | AAPL | Stock | 118.35 | 119.0 | 117.25 | 117.3 | 686861.0 |
| 2020-09-03 19:00:00 | AAPL | Stock | 117.3 | 118.01 | 117.0 | 117.23 | 552098.0 |
| 2020-09-03 19:30:00 | AAPL | Stock | 117.24 | 117.5 | 116.7 | 117.19 | 743064.0 |
| 2020-09-03 04:00:00 | MSFT | Stock | 231.21 | 231.22 | 230.45 | 230.45 | 2749.0 |
| 2020-09-03 04:30:00 | MSFT | Stock | 230.64 | 230.64 | 230.33 | 230.46 | 1669.0 |
| 2020-09-03 05:00:00 | MSFT | Stock | 230.33 | 230.6 | 229.96 | 230.54 | 9774.0 |
| 2020-09-03 05:30:00 | MSFT | Stock | 230.39 | 230.49 | 229.52 | 229.52 | 10318.0 |
| 2020-09-03 06:00:00 | MSFT | Stock | 229.79 | 230.23 | 229.55 | 229.62 | 10262.0 |
| 2020-09-03 06:30:00 | MSFT | Stock | 229.76 | 230.0 | 229.4 | 229.4 | 4442.0 |
| 2020-09-03 07:00:00 | MSFT | Stock | 229.5 | 229.98 | 228.97 | 229.58 | 38603.0 |
| 2020-09-03 07:30:00 | MSFT | Stock | 229.59 | 229.85 | 229.1 | 229.35 | 25161.0 |
| 2020-09-03 08:00:00 | MSFT | Stock | 229.21 | 229.95 | 229.0 | 229.73 | 37906.0 |
| 2020-09-03 08:30:00 | MSFT | Stock | 229.8 | 230.075 | 229.43 | 229.62 | 50161.0 |
| 2020-09-03 09:00:00 | MSFT | Stock | 229.63 | 230.2 | 228.84 | 229.18 | 92667.0 |
| 2020-09-03 09:30:00 | MSFT | Stock | 229.27 | 229.31 | 226.0 | 226.63 | 3730114.0 |
| 2020-09-03 10:00:00 | MSFT | Stock | 226.59 | 226.8 | 223.23 | 224.37 | 2881847.0 |
| 2020-09-03 10:30:00 | MSFT | Stock | 224.41 | 224.57 | 221.82 | 223.02 | 2756834.0 |
| 2020-09-03 11:00:00 | MSFT | Stock | 222.99 | 223.12 | 218.351 | 219.7 | 4223438.0 |
| 2020-09-03 11:30:00 | MSFT | Stock | 219.735 | 221.65 | 218.94 | 220.12 | 2195863.0 |
| 2020-09-03 12:00:00 | MSFT | Stock | 220.1 | 220.8 | 219.064 | 219.26 | 1706468.0 |
| 2020-09-03 12:30:00 | MSFT | Stock | 219.25 | 219.8 | 218.02 | 218.24 | 1690272.0 |
> showing 50 of 99,539 rows — these rows as CSV