PREVIEW / stock_30min / 2021-09-01
file: by_date/stock_30min/2021/2021-09-01.parquet size: 2.2 MB rows: 110,684 symbols: 2,781
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-09-01 04:00:00 | AAPL | Stock | 152.34 | 152.4 | 151.92 | 151.92 | 6961.0 |
| 2021-09-01 04:30:00 | AAPL | Stock | 151.84 | 152.07 | 151.84 | 151.94 | 3434.0 |
| 2021-09-01 05:00:00 | AAPL | Stock | 151.93 | 151.95 | 151.86 | 151.9 | 1620.0 |
| 2021-09-01 05:30:00 | AAPL | Stock | 151.96 | 152.0 | 151.96 | 152.0 | 4591.0 |
| 2021-09-01 06:00:00 | AAPL | Stock | 152.04 | 152.11 | 152.04 | 152.11 | 3241.0 |
| 2021-09-01 06:30:00 | AAPL | Stock | 152.14 | 152.26 | 152.14 | 152.26 | 7616.0 |
| 2021-09-01 07:00:00 | AAPL | Stock | 152.25 | 152.55 | 152.07 | 152.52 | 92737.0 |
| 2021-09-01 07:30:00 | AAPL | Stock | 152.49 | 152.59 | 152.389 | 152.53 | 51371.0 |
| 2021-09-01 08:00:00 | AAPL | Stock | 152.4302 | 152.68 | 151.451 | 152.55 | 312112.0 |
| 2021-09-01 08:30:00 | AAPL | Stock | 152.56 | 152.67 | 152.38 | 152.5 | 142852.0 |
| 2021-09-01 09:00:00 | AAPL | Stock | 152.49 | 152.88 | 152.4 | 152.8 | 329930.0 |
| 2021-09-01 09:30:00 | AAPL | Stock | 152.8 | 154.82 | 152.58 | 154.11 | 15310620.0 |
| 2021-09-01 10:00:00 | AAPL | Stock | 154.12 | 154.79 | 154.05 | 154.69 | 6452524.0 |
| 2021-09-01 10:30:00 | AAPL | Stock | 154.69 | 154.98 | 154.48 | 154.53 | 5933760.0 |
| 2021-09-01 11:00:00 | AAPL | Stock | 154.54 | 154.95 | 154.39 | 154.67 | 4073401.0 |
| 2021-09-01 11:30:00 | AAPL | Stock | 154.675 | 154.94 | 154.4 | 154.5 | 2980458.0 |
| 2021-09-01 12:00:00 | AAPL | Stock | 154.5001 | 154.62 | 153.98 | 154.02 | 3085753.0 |
| 2021-09-01 12:30:00 | AAPL | Stock | 154.0219 | 154.0299 | 153.65 | 153.665 | 3261764.0 |
| 2021-09-01 13:00:00 | AAPL | Stock | 153.66 | 154.005 | 153.55 | 153.9299 | 3273439.0 |
| 2021-09-01 13:30:00 | AAPL | Stock | 153.93 | 153.94 | 153.65 | 153.795 | 1785141.0 |
| 2021-09-01 14:00:00 | AAPL | Stock | 153.7935 | 153.8 | 153.2 | 153.2199 | 2754275.0 |
| 2021-09-01 14:30:00 | AAPL | Stock | 153.2101 | 153.3 | 152.78 | 152.89 | 3982007.0 |
| 2021-09-01 15:00:00 | AAPL | Stock | 152.8802 | 153.175 | 152.79 | 152.955 | 3290026.0 |
| 2021-09-01 15:30:00 | AAPL | Stock | 152.955 | 152.97 | 152.34 | 152.54 | 8149121.0 |
| 2021-09-01 16:00:00 | AAPL | Stock | 152.51 | 152.7168 | 152.49 | 152.58 | 5008843.0 |
| 2021-09-01 16:30:00 | AAPL | Stock | 152.57 | 152.6 | 152.49 | 152.54 | 38897.0 |
| 2021-09-01 17:00:00 | AAPL | Stock | 152.57 | 153.13 | 152.57 | 153.1 | 68748.0 |
| 2021-09-01 17:30:00 | AAPL | Stock | 153.0 | 153.15 | 152.8 | 152.88 | 64665.0 |
| 2021-09-01 18:00:00 | AAPL | Stock | 152.99 | 153.05 | 152.9 | 153.0 | 40951.0 |
| 2021-09-01 18:30:00 | AAPL | Stock | 152.96 | 153.0 | 152.93 | 152.97 | 27596.0 |
| 2021-09-01 19:00:00 | AAPL | Stock | 152.98 | 152.99 | 152.94 | 152.99 | 15787.0 |
| 2021-09-01 19:30:00 | AAPL | Stock | 152.98 | 153.25 | 152.98 | 153.16 | 50811.0 |
| 2021-09-01 04:00:00 | MSFT | Stock | 303.1 | 303.17 | 302.79 | 302.98 | 2609.0 |
| 2021-09-01 04:30:00 | MSFT | Stock | 303.09 | 303.09 | 302.87 | 302.99 | 847.0 |
| 2021-09-01 05:00:00 | MSFT | Stock | 303.0 | 303.0 | 302.65 | 302.71 | 2194.0 |
| 2021-09-01 05:30:00 | MSFT | Stock | 302.8 | 303.0 | 302.8 | 303.0 | 5199.0 |
| 2021-09-01 06:00:00 | MSFT | Stock | 303.09 | 303.27 | 303.09 | 303.27 | 300.0 |
| 2021-09-01 06:30:00 | MSFT | Stock | 303.21 | 303.38 | 303.21 | 303.34 | 4499.0 |
| 2021-09-01 07:00:00 | MSFT | Stock | 303.39 | 303.48 | 303.03 | 303.09 | 7979.0 |
| 2021-09-01 07:30:00 | MSFT | Stock | 303.14 | 303.17 | 303.01 | 303.06 | 1840.0 |
| 2021-09-01 08:00:00 | MSFT | Stock | 303.2 | 303.3499 | 303.0 | 303.05 | 10907.0 |
| 2021-09-01 08:30:00 | MSFT | Stock | 303.05 | 303.17 | 302.83 | 302.9 | 6784.0 |
| 2021-09-01 09:00:00 | MSFT | Stock | 302.88 | 303.0 | 302.6 | 302.72 | 13865.0 |
| 2021-09-01 09:30:00 | MSFT | Stock | 302.8 | 305.06 | 302.68 | 304.59 | 2420301.0 |
| 2021-09-01 10:00:00 | MSFT | Stock | 304.6 | 305.19 | 304.0 | 304.17 | 998270.0 |
| 2021-09-01 10:30:00 | MSFT | Stock | 304.16 | 304.35 | 303.3 | 303.57 | 681817.0 |
| 2021-09-01 11:00:00 | MSFT | Stock | 303.6 | 304.15 | 303.38 | 303.64 | 620741.0 |
| 2021-09-01 11:30:00 | MSFT | Stock | 303.635 | 304.02 | 303.26 | 303.38 | 540220.0 |
| 2021-09-01 12:00:00 | MSFT | Stock | 303.36 | 303.63 | 303.08 | 303.1031 | 539025.0 |
| 2021-09-01 12:30:00 | MSFT | Stock | 303.1 | 303.17 | 302.72 | 302.73 | 616698.0 |
> showing 50 of 110,684 rows — these rows as CSV