PREVIEW / stock_30min / 2020-12-17
file: by_date/stock_30min/2020/2020-12-17.parquet size: 2.2 MB rows: 108,751 symbols: 2,687
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-17 04:00:00 | AAPL | Stock | 128.2 | 128.41 | 128.2 | 128.3 | 6823.0 |
| 2020-12-17 04:30:00 | AAPL | Stock | 128.3 | 128.5 | 128.29 | 128.4 | 14357.0 |
| 2020-12-17 05:00:00 | AAPL | Stock | 128.4 | 128.42 | 128.15 | 128.15 | 2931.0 |
| 2020-12-17 05:30:00 | AAPL | Stock | 128.15 | 128.29 | 128.15 | 128.27 | 2139.0 |
| 2020-12-17 06:00:00 | AAPL | Stock | 128.29 | 128.34 | 128.27 | 128.3 | 2131.0 |
| 2020-12-17 06:30:00 | AAPL | Stock | 128.23 | 128.23 | 128.16 | 128.18 | 7111.0 |
| 2020-12-17 07:00:00 | AAPL | Stock | 128.16 | 128.5 | 128.16 | 128.43 | 133142.0 |
| 2020-12-17 07:30:00 | AAPL | Stock | 128.42 | 128.54 | 128.37 | 128.47 | 68687.0 |
| 2020-12-17 08:00:00 | AAPL | Stock | 128.4 | 128.57 | 127.59 | 128.48 | 214905.0 |
| 2020-12-17 08:30:00 | AAPL | Stock | 128.47 | 128.59 | 128.41 | 128.57 | 173971.0 |
| 2020-12-17 09:00:00 | AAPL | Stock | 128.58 | 129.4 | 128.55 | 128.89 | 539291.0 |
| 2020-12-17 09:30:00 | AAPL | Stock | 128.9 | 129.58 | 128.52 | 128.941 | 13667794.0 |
| 2020-12-17 10:00:00 | AAPL | Stock | 128.955 | 129.05 | 128.19 | 129.045 | 7734757.0 |
| 2020-12-17 10:30:00 | AAPL | Stock | 129.05 | 129.2 | 128.73 | 128.781 | 5385601.0 |
| 2020-12-17 11:00:00 | AAPL | Stock | 128.79 | 129.04 | 128.59 | 128.675 | 4070620.0 |
| 2020-12-17 11:30:00 | AAPL | Stock | 128.68 | 128.71 | 128.045 | 128.39 | 4795151.0 |
| 2020-12-17 12:00:00 | AAPL | Stock | 128.4 | 128.57 | 128.21 | 128.414 | 3547826.0 |
| 2020-12-17 12:30:00 | AAPL | Stock | 128.41 | 128.52 | 128.143 | 128.471 | 3465935.0 |
| 2020-12-17 13:00:00 | AAPL | Stock | 128.48 | 128.71 | 128.4 | 128.505 | 2723355.0 |
| 2020-12-17 13:30:00 | AAPL | Stock | 128.505 | 128.67 | 128.28 | 128.455 | 2882424.0 |
| 2020-12-17 14:00:00 | AAPL | Stock | 128.46 | 128.53 | 128.22 | 128.285 | 2947252.0 |
| 2020-12-17 14:30:00 | AAPL | Stock | 128.29 | 128.54 | 128.12 | 128.455 | 3375186.0 |
| 2020-12-17 15:00:00 | AAPL | Stock | 128.459 | 128.52 | 128.24 | 128.37 | 2935780.0 |
| 2020-12-17 15:30:00 | AAPL | Stock | 128.37 | 128.83 | 128.29 | 128.65 | 7556401.0 |
| 2020-12-17 16:00:00 | AAPL | Stock | 128.65 | 128.75 | 128.53 | 128.55 | 9730573.0 |
| 2020-12-17 16:30:00 | AAPL | Stock | 128.55 | 128.7 | 128.54 | 128.57 | 84532.0 |
| 2020-12-17 17:00:00 | AAPL | Stock | 128.58 | 128.58 | 128.5 | 128.57 | 43276.0 |
| 2020-12-17 17:30:00 | AAPL | Stock | 128.54 | 128.59 | 128.27 | 128.41 | 45825.0 |
| 2020-12-17 18:00:00 | AAPL | Stock | 128.42 | 128.59 | 128.33 | 128.45 | 37748.0 |
| 2020-12-17 18:30:00 | AAPL | Stock | 128.5 | 128.59 | 128.4 | 128.45 | 23435.0 |
| 2020-12-17 19:00:00 | AAPL | Stock | 128.42 | 128.48 | 128.38 | 128.39 | 20290.0 |
| 2020-12-17 19:30:00 | AAPL | Stock | 128.38 | 128.52 | 128.31 | 128.35 | 38826.0 |
| 2020-12-17 04:00:00 | MSFT | Stock | 219.9 | 220.73 | 219.9 | 220.51 | 2183.0 |
| 2020-12-17 04:30:00 | MSFT | Stock | 220.6 | 220.72 | 220.6 | 220.71 | 705.0 |
| 2020-12-17 05:00:00 | MSFT | Stock | 220.62 | 220.62 | 220.3 | 220.3 | 441.0 |
| 2020-12-17 05:30:00 | MSFT | Stock | 220.22 | 220.22 | 220.2 | 220.2 | 601.0 |
| 2020-12-17 06:00:00 | MSFT | Stock | 220.12 | 220.3 | 220.1 | 220.3 | 621.0 |
| 2020-12-17 06:30:00 | MSFT | Stock | 220.3 | 220.3 | 219.7 | 219.74 | 5963.0 |
| 2020-12-17 07:00:00 | MSFT | Stock | 219.86 | 219.91 | 219.64 | 219.69 | 16887.0 |
| 2020-12-17 07:30:00 | MSFT | Stock | 219.77 | 220.0 | 219.77 | 219.9 | 16797.0 |
| 2020-12-17 08:00:00 | MSFT | Stock | 219.8 | 219.95 | 218.82 | 219.63 | 32417.0 |
| 2020-12-17 08:30:00 | MSFT | Stock | 219.51 | 219.8 | 219.4 | 219.686 | 14873.0 |
| 2020-12-17 09:00:00 | MSFT | Stock | 219.63 | 220.0 | 219.52 | 219.77 | 48631.0 |
| 2020-12-17 09:30:00 | MSFT | Stock | 219.79 | 220.89 | 219.23 | 219.56 | 3146999.0 |
| 2020-12-17 10:00:00 | MSFT | Stock | 219.56 | 219.64 | 218.17 | 219.22 | 2414265.0 |
| 2020-12-17 10:30:00 | MSFT | Stock | 219.24 | 219.28 | 218.07 | 218.138 | 1862540.0 |
| 2020-12-17 11:00:00 | MSFT | Stock | 218.13 | 218.57 | 218.072 | 218.48 | 1174716.0 |
| 2020-12-17 11:30:00 | MSFT | Stock | 218.48 | 218.66 | 217.92 | 218.65 | 1257714.0 |
| 2020-12-17 12:00:00 | MSFT | Stock | 218.66 | 218.789 | 218.28 | 218.63 | 1008469.0 |
| 2020-12-17 12:30:00 | MSFT | Stock | 218.62 | 218.95 | 218.45 | 218.87 | 788736.0 |
> showing 50 of 108,751 rows — these rows as CSV