PREVIEW / stock_30min / 2021-07-08
file: by_date/stock_30min/2021/2021-07-08.parquet size: 2.3 MB rows: 116,081 symbols: 2,871
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-07-08 04:00:00 | AAPL | Stock | 142.52 | 143.43 | 141.39 | 141.9 | 105431.0 |
| 2021-07-08 04:30:00 | AAPL | Stock | 141.62 | 142.26 | 141.6 | 142.2 | 71084.0 |
| 2021-07-08 05:00:00 | AAPL | Stock | 142.23 | 142.61 | 141.9 | 142.24 | 88962.0 |
| 2021-07-08 05:30:00 | AAPL | Stock | 142.17 | 142.46 | 142.13 | 142.28 | 88440.0 |
| 2021-07-08 06:00:00 | AAPL | Stock | 142.2 | 142.75 | 141.6 | 141.75 | 134449.0 |
| 2021-07-08 06:30:00 | AAPL | Stock | 141.65 | 142.49 | 141.65 | 142.48 | 77405.0 |
| 2021-07-08 07:00:00 | AAPL | Stock | 142.42 | 142.7 | 142.0 | 142.25 | 261610.0 |
| 2021-07-08 07:30:00 | AAPL | Stock | 142.221 | 142.221 | 141.75 | 141.75 | 202390.0 |
| 2021-07-08 08:00:00 | AAPL | Stock | 142.48 | 142.65 | 141.2 | 141.57 | 976783.0 |
| 2021-07-08 08:30:00 | AAPL | Stock | 141.6 | 141.94 | 141.5 | 141.69 | 385636.0 |
| 2021-07-08 09:00:00 | AAPL | Stock | 141.675 | 142.235 | 141.26 | 141.56 | 612830.0 |
| 2021-07-08 09:30:00 | AAPL | Stock | 141.57 | 143.15 | 140.665 | 141.97 | 20628966.0 |
| 2021-07-08 10:00:00 | AAPL | Stock | 141.9666 | 142.29 | 141.48 | 142.085 | 8150938.0 |
| 2021-07-08 10:30:00 | AAPL | Stock | 142.085 | 142.35 | 141.52 | 141.58 | 5789533.0 |
| 2021-07-08 11:00:00 | AAPL | Stock | 141.61 | 142.27 | 141.49 | 142.19 | 4678053.0 |
| 2021-07-08 11:30:00 | AAPL | Stock | 142.19 | 142.73 | 141.84 | 142.6489 | 4379557.0 |
| 2021-07-08 12:00:00 | AAPL | Stock | 142.645 | 142.73 | 142.32 | 142.6656 | 2973094.0 |
| 2021-07-08 12:30:00 | AAPL | Stock | 142.6684 | 143.34 | 142.653 | 143.275 | 5148485.0 |
| 2021-07-08 13:00:00 | AAPL | Stock | 143.27 | 143.72 | 143.12 | 143.533 | 4967765.0 |
| 2021-07-08 13:30:00 | AAPL | Stock | 143.5385 | 144.06 | 143.48 | 143.81 | 4109642.0 |
| 2021-07-08 14:00:00 | AAPL | Stock | 143.81 | 143.97 | 143.2 | 143.32 | 4109445.0 |
| 2021-07-08 14:30:00 | AAPL | Stock | 143.32 | 143.53 | 142.87 | 143.19 | 4040508.0 |
| 2021-07-08 15:00:00 | AAPL | Stock | 143.18 | 143.33 | 142.637 | 143.0 | 4350453.0 |
| 2021-07-08 15:30:00 | AAPL | Stock | 143.0 | 143.32 | 142.45 | 143.32 | 7710785.0 |
| 2021-07-08 16:00:00 | AAPL | Stock | 143.26 | 143.49 | 142.5322 | 143.28 | 6850304.0 |
| 2021-07-08 16:30:00 | AAPL | Stock | 143.27 | 143.32 | 143.25 | 143.29 | 30034.0 |
| 2021-07-08 17:00:00 | AAPL | Stock | 143.29 | 143.32 | 143.25 | 143.3 | 14880.0 |
| 2021-07-08 17:30:00 | AAPL | Stock | 143.28 | 143.3 | 143.25 | 143.28 | 15046.0 |
| 2021-07-08 18:00:00 | AAPL | Stock | 143.28 | 143.28 | 143.13 | 143.13 | 31459.0 |
| 2021-07-08 18:30:00 | AAPL | Stock | 143.15 | 143.15 | 143.05 | 143.1 | 31394.0 |
| 2021-07-08 19:00:00 | AAPL | Stock | 143.08 | 143.25 | 143.01 | 143.18 | 37608.0 |
| 2021-07-08 19:30:00 | AAPL | Stock | 143.1999 | 143.24 | 143.0 | 143.0 | 39910.0 |
| 2021-07-08 04:00:00 | MSFT | Stock | 277.77 | 277.77 | 276.6 | 276.99 | 17380.0 |
| 2021-07-08 04:30:00 | MSFT | Stock | 277.1 | 277.4 | 276.55 | 277.4 | 7642.0 |
| 2021-07-08 05:00:00 | MSFT | Stock | 277.5 | 278.3 | 276.65 | 277.0 | 15014.0 |
| 2021-07-08 05:30:00 | MSFT | Stock | 277.0 | 277.5 | 276.14 | 276.8 | 13881.0 |
| 2021-07-08 06:00:00 | MSFT | Stock | 276.44 | 276.87 | 275.06 | 276.58 | 17782.0 |
| 2021-07-08 06:30:00 | MSFT | Stock | 276.12 | 277.0 | 275.8 | 277.0 | 25179.0 |
| 2021-07-08 07:00:00 | MSFT | Stock | 277.18 | 277.41 | 276.5 | 277.0 | 48296.0 |
| 2021-07-08 07:30:00 | MSFT | Stock | 276.7 | 276.7 | 276.0 | 276.0 | 31956.0 |
| 2021-07-08 08:00:00 | MSFT | Stock | 277.08 | 277.44 | 275.25 | 276.22 | 71973.0 |
| 2021-07-08 08:30:00 | MSFT | Stock | 276.2 | 276.95 | 275.86 | 276.34 | 49441.0 |
| 2021-07-08 09:00:00 | MSFT | Stock | 276.42 | 277.13 | 276.08 | 277.0 | 36892.0 |
| 2021-07-08 09:30:00 | MSFT | Stock | 276.82 | 278.73 | 276.45 | 277.65 | 3101241.0 |
| 2021-07-08 10:00:00 | MSFT | Stock | 277.63 | 277.93 | 275.74 | 276.6922 | 1473641.0 |
| 2021-07-08 10:30:00 | MSFT | Stock | 276.74 | 276.99 | 275.27 | 275.39 | 1234266.0 |
| 2021-07-08 11:00:00 | MSFT | Stock | 275.41 | 276.91 | 274.87 | 276.76 | 1257344.0 |
| 2021-07-08 11:30:00 | MSFT | Stock | 276.77 | 277.48 | 275.84 | 277.39 | 1015596.0 |
| 2021-07-08 12:00:00 | MSFT | Stock | 277.4 | 277.52 | 276.92 | 277.29 | 703112.0 |
| 2021-07-08 12:30:00 | MSFT | Stock | 277.28 | 277.74 | 277.06 | 277.525 | 631035.0 |
> showing 50 of 116,081 rows — these rows as CSV