PREVIEW / stock_30min / 2021-03-10
file: by_date/stock_30min/2021/2021-03-10.parquet size: 2.3 MB rows: 117,878 symbols: 2,890
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-03-10 04:00:00 | AAPL | Stock | 121.5 | 121.51 | 120.0 | 120.47 | 110164.0 |
| 2021-03-10 04:30:00 | AAPL | Stock | 120.47 | 121.1 | 120.15 | 120.8 | 19952.0 |
| 2021-03-10 05:00:00 | AAPL | Stock | 120.81 | 121.16 | 120.7 | 121.02 | 9097.0 |
| 2021-03-10 05:30:00 | AAPL | Stock | 120.88 | 120.95 | 120.49 | 120.49 | 19710.0 |
| 2021-03-10 06:00:00 | AAPL | Stock | 120.25 | 120.49 | 119.69 | 119.7 | 48509.0 |
| 2021-03-10 06:30:00 | AAPL | Stock | 119.72 | 120.51 | 119.72 | 120.51 | 90173.0 |
| 2021-03-10 07:00:00 | AAPL | Stock | 120.51 | 120.85 | 119.99 | 120.5 | 168387.0 |
| 2021-03-10 07:30:00 | AAPL | Stock | 120.49 | 120.67 | 120.2 | 120.55 | 151172.0 |
| 2021-03-10 08:00:00 | AAPL | Stock | 120.48 | 121.387 | 120.0 | 120.03 | 560107.0 |
| 2021-03-10 08:30:00 | AAPL | Stock | 120.05 | 121.69 | 120.05 | 121.69 | 904949.0 |
| 2021-03-10 09:00:00 | AAPL | Stock | 121.68 | 122.16 | 121.36 | 121.54 | 940389.0 |
| 2021-03-10 09:30:00 | AAPL | Stock | 121.54 | 122.17 | 120.11 | 120.71 | 17636443.0 |
| 2021-03-10 10:00:00 | AAPL | Stock | 120.71 | 121.13 | 119.795 | 119.93 | 9372365.0 |
| 2021-03-10 10:30:00 | AAPL | Stock | 119.92 | 120.3801 | 119.45 | 119.88 | 9016914.0 |
| 2021-03-10 11:00:00 | AAPL | Stock | 119.885 | 120.49 | 119.47 | 120.4293 | 6901547.0 |
| 2021-03-10 11:30:00 | AAPL | Stock | 120.42 | 120.5 | 119.795 | 120.34 | 4881547.0 |
| 2021-03-10 12:00:00 | AAPL | Stock | 120.34 | 120.49 | 119.84 | 119.861 | 4242741.0 |
| 2021-03-10 12:30:00 | AAPL | Stock | 119.8675 | 120.27 | 119.59 | 120.185 | 4675665.0 |
| 2021-03-10 13:00:00 | AAPL | Stock | 120.19 | 120.41 | 119.55 | 120.327 | 5886154.0 |
| 2021-03-10 13:30:00 | AAPL | Stock | 120.325 | 120.48 | 119.74 | 120.01 | 4664390.0 |
| 2021-03-10 14:00:00 | AAPL | Stock | 119.99 | 120.44 | 119.81 | 120.31 | 4165144.0 |
| 2021-03-10 14:30:00 | AAPL | Stock | 120.3096 | 120.92 | 120.205 | 120.67 | 3976061.0 |
| 2021-03-10 15:00:00 | AAPL | Stock | 120.67 | 120.83 | 120.23 | 120.36 | 4006714.0 |
| 2021-03-10 15:30:00 | AAPL | Stock | 120.36 | 120.56 | 119.86 | 119.97 | 7549423.0 |
| 2021-03-10 16:00:00 | AAPL | Stock | 119.97 | 120.14 | 119.91 | 120.04 | 5513001.0 |
| 2021-03-10 16:30:00 | AAPL | Stock | 120.01 | 120.09 | 120.0 | 120.07 | 43830.0 |
| 2021-03-10 17:00:00 | AAPL | Stock | 120.06 | 120.15 | 120.04 | 120.08 | 37049.0 |
| 2021-03-10 17:30:00 | AAPL | Stock | 120.13 | 120.15 | 120.04 | 120.15 | 31116.0 |
| 2021-03-10 18:00:00 | AAPL | Stock | 120.15 | 120.2 | 120.14 | 120.16 | 52266.0 |
| 2021-03-10 18:30:00 | AAPL | Stock | 120.17 | 120.17 | 120.09 | 120.1 | 26303.0 |
| 2021-03-10 19:00:00 | AAPL | Stock | 120.12 | 120.12 | 120.02 | 120.07 | 27611.0 |
| 2021-03-10 19:30:00 | AAPL | Stock | 120.07 | 120.1 | 119.88 | 119.93 | 78479.0 |
| 2021-03-10 04:00:00 | MSFT | Stock | 233.6 | 233.69 | 233.0 | 233.69 | 1316.0 |
| 2021-03-10 04:30:00 | MSFT | Stock | 233.41 | 233.78 | 233.41 | 233.78 | 1770.0 |
| 2021-03-10 05:00:00 | MSFT | Stock | 233.78 | 233.97 | 233.78 | 233.97 | 543.0 |
| 2021-03-10 05:30:00 | MSFT | Stock | 234.03 | 234.03 | 233.5 | 233.5 | 830.0 |
| 2021-03-10 06:00:00 | MSFT | Stock | 233.0 | 233.0 | 232.66 | 232.66 | 769.0 |
| 2021-03-10 06:30:00 | MSFT | Stock | 233.0 | 233.03 | 233.0 | 233.03 | 278.0 |
| 2021-03-10 07:00:00 | MSFT | Stock | 233.25 | 233.84 | 233.0 | 233.84 | 4287.0 |
| 2021-03-10 07:30:00 | MSFT | Stock | 233.51 | 233.6 | 233.08 | 233.32 | 9261.0 |
| 2021-03-10 08:00:00 | MSFT | Stock | 233.25 | 233.98 | 232.39 | 233.25 | 33616.0 |
| 2021-03-10 08:30:00 | MSFT | Stock | 233.42 | 235.59 | 233.24 | 235.1 | 42706.0 |
| 2021-03-10 09:00:00 | MSFT | Stock | 234.98 | 237.03 | 234.98 | 237.0 | 51179.0 |
| 2021-03-10 09:30:00 | MSFT | Stock | 237.0 | 237.0 | 234.99 | 235.22 | 3196610.0 |
| 2021-03-10 10:00:00 | MSFT | Stock | 235.29 | 236.03 | 234.025 | 234.24 | 1688248.0 |
| 2021-03-10 10:30:00 | MSFT | Stock | 234.27 | 235.14 | 233.81 | 234.51 | 1625710.0 |
| 2021-03-10 11:00:00 | MSFT | Stock | 234.549 | 235.01 | 234.06 | 234.63 | 1017492.0 |
| 2021-03-10 11:30:00 | MSFT | Stock | 234.63 | 235.59 | 234.12 | 235.11 | 1045431.0 |
| 2021-03-10 12:00:00 | MSFT | Stock | 235.11 | 235.15 | 234.44 | 234.51 | 905957.0 |
| 2021-03-10 12:30:00 | MSFT | Stock | 234.49 | 235.08 | 234.09 | 235.07 | 983273.0 |
> showing 50 of 117,878 rows — these rows as CSV