PREVIEW / stock_30min / 2021-02-24
file: by_date/stock_30min/2021/2021-02-24.parquet size: 2.4 MB rows: 123,102 symbols: 2,835
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-24 04:00:00 | AAPL | Stock | 125.3 | 126.39 | 125.3 | 126.39 | 57052.0 |
| 2021-02-24 04:30:00 | AAPL | Stock | 126.35 | 126.4 | 126.1 | 126.2 | 24898.0 |
| 2021-02-24 05:00:00 | AAPL | Stock | 126.23 | 126.5 | 125.76 | 126.2 | 25257.0 |
| 2021-02-24 05:30:00 | AAPL | Stock | 126.3 | 126.59 | 126.3 | 126.3 | 18868.0 |
| 2021-02-24 06:00:00 | AAPL | Stock | 126.34 | 126.38 | 125.9 | 126.14 | 12997.0 |
| 2021-02-24 06:30:00 | AAPL | Stock | 126.05 | 126.05 | 125.32 | 125.9 | 29179.0 |
| 2021-02-24 07:00:00 | AAPL | Stock | 125.93 | 126.7 | 125.77 | 126.6 | 185220.0 |
| 2021-02-24 07:30:00 | AAPL | Stock | 126.6 | 127.48 | 126.44 | 127.19 | 207735.0 |
| 2021-02-24 08:00:00 | AAPL | Stock | 125.87 | 127.49 | 125.78 | 126.76 | 447092.0 |
| 2021-02-24 08:30:00 | AAPL | Stock | 126.73 | 126.74 | 124.3 | 124.79 | 562193.0 |
| 2021-02-24 09:00:00 | AAPL | Stock | 124.81 | 125.1 | 124.0 | 124.95 | 603341.0 |
| 2021-02-24 09:30:00 | AAPL | Stock | 124.95 | 125.35 | 123.21 | 123.364 | 15422725.0 |
| 2021-02-24 10:00:00 | AAPL | Stock | 123.37 | 124.075 | 122.23 | 124.015 | 11635739.0 |
| 2021-02-24 10:30:00 | AAPL | Stock | 124.02 | 124.48 | 123.5 | 124.26 | 6331608.0 |
| 2021-02-24 11:00:00 | AAPL | Stock | 124.255 | 124.93 | 123.955 | 124.562 | 6211034.0 |
| 2021-02-24 11:30:00 | AAPL | Stock | 124.56 | 124.92 | 124.15 | 124.529 | 4847315.0 |
| 2021-02-24 12:00:00 | AAPL | Stock | 124.52 | 125.11 | 124.52 | 125.105 | 4907291.0 |
| 2021-02-24 12:30:00 | AAPL | Stock | 125.11 | 125.14 | 124.41 | 124.433 | 4604930.0 |
| 2021-02-24 13:00:00 | AAPL | Stock | 124.435 | 124.59 | 123.95 | 124.45 | 5140059.0 |
| 2021-02-24 13:30:00 | AAPL | Stock | 124.46 | 125.185 | 124.435 | 124.93 | 5181342.0 |
| 2021-02-24 14:00:00 | AAPL | Stock | 124.92 | 124.99 | 124.32 | 124.46 | 3980197.0 |
| 2021-02-24 14:30:00 | AAPL | Stock | 124.46 | 124.78 | 124.282 | 124.457 | 3330450.0 |
| 2021-02-24 15:00:00 | AAPL | Stock | 124.46 | 124.93 | 124.21 | 124.93 | 4903872.0 |
| 2021-02-24 15:30:00 | AAPL | Stock | 124.92 | 125.56 | 124.72 | 125.32 | 10025258.0 |
| 2021-02-24 16:00:00 | AAPL | Stock | 125.32 | 125.7 | 125.29 | 125.7 | 6088300.0 |
| 2021-02-24 16:30:00 | AAPL | Stock | 125.69 | 125.78 | 124.96 | 125.1 | 206037.0 |
| 2021-02-24 17:00:00 | AAPL | Stock | 125.15 | 125.35 | 125.0 | 125.27 | 96273.0 |
| 2021-02-24 17:30:00 | AAPL | Stock | 125.25 | 125.31 | 125.02 | 125.15 | 48727.0 |
| 2021-02-24 18:00:00 | AAPL | Stock | 125.15 | 125.31 | 125.12 | 125.13 | 47068.0 |
| 2021-02-24 18:30:00 | AAPL | Stock | 125.17 | 125.31 | 125.14 | 125.31 | 43219.0 |
| 2021-02-24 19:00:00 | AAPL | Stock | 125.29 | 125.29 | 125.12 | 125.2 | 44701.0 |
| 2021-02-24 19:30:00 | AAPL | Stock | 125.22 | 125.29 | 124.89 | 124.9 | 127752.0 |
| 2021-02-24 04:00:00 | MSFT | Stock | 233.18 | 234.0 | 233.0 | 234.0 | 5287.0 |
| 2021-02-24 04:30:00 | MSFT | Stock | 234.05 | 234.14 | 233.75 | 233.75 | 1304.0 |
| 2021-02-24 05:00:00 | MSFT | Stock | 233.22 | 233.28 | 232.75 | 233.22 | 3142.0 |
| 2021-02-24 05:30:00 | MSFT | Stock | 233.8 | 233.8 | 233.23 | 233.23 | 1496.0 |
| 2021-02-24 06:00:00 | MSFT | Stock | 233.0 | 233.2 | 232.44 | 232.55 | 4902.0 |
| 2021-02-24 06:30:00 | MSFT | Stock | 232.49 | 232.55 | 232.0 | 232.15 | 6035.0 |
| 2021-02-24 07:00:00 | MSFT | Stock | 232.44 | 233.95 | 232.44 | 233.72 | 18222.0 |
| 2021-02-24 07:30:00 | MSFT | Stock | 233.54 | 234.96 | 233.4 | 234.09 | 22368.0 |
| 2021-02-24 08:00:00 | MSFT | Stock | 233.003 | 234.95 | 232.687 | 233.46 | 44278.0 |
| 2021-02-24 08:30:00 | MSFT | Stock | 233.499 | 233.6 | 230.0 | 230.53 | 66127.0 |
| 2021-02-24 09:00:00 | MSFT | Stock | 230.52 | 231.7 | 229.83 | 229.93 | 68254.0 |
| 2021-02-24 09:30:00 | MSFT | Stock | 230.03 | 231.74 | 229.52 | 229.8 | 3057321.0 |
| 2021-02-24 10:00:00 | MSFT | Stock | 229.83 | 231.58 | 229.0 | 231.21 | 1949535.0 |
| 2021-02-24 10:30:00 | MSFT | Stock | 231.22 | 231.6 | 229.91 | 231.08 | 1327334.0 |
| 2021-02-24 11:00:00 | MSFT | Stock | 231.08 | 232.227 | 230.94 | 231.97 | 1258173.0 |
| 2021-02-24 11:30:00 | MSFT | Stock | 232.03 | 232.3 | 231.65 | 231.973 | 884618.0 |
| 2021-02-24 12:00:00 | MSFT | Stock | 232.01 | 232.66 | 231.945 | 232.34 | 888733.0 |
| 2021-02-24 12:30:00 | MSFT | Stock | 232.39 | 233.05 | 232.28 | 233.015 | 938170.0 |
> showing 50 of 123,102 rows — these rows as CSV