PREVIEW / stock_30min / 2007-11-19
file: by_date/stock_30min/2007/2007-11-19.parquet size: 1.2 MB rows: 68,897 symbols: 3,211
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 |
|---|---|---|---|---|---|---|---|
| 2007-11-19 06:30:00 | AAPL | Stock | 5.9286 | 5.9311 | 5.9214 | 5.9311 | 26600.0 |
| 2007-11-19 07:00:00 | AAPL | Stock | 5.9214 | 5.9425 | 5.9139 | 5.9171 | 147000.0 |
| 2007-11-19 07:30:00 | AAPL | Stock | 5.9171 | 5.9271 | 5.9018 | 5.9175 | 258384.0 |
| 2007-11-19 08:00:00 | AAPL | Stock | 5.9329 | 5.9329 | 5.8932 | 5.8932 | 2165520.0 |
| 2007-11-19 08:30:00 | AAPL | Stock | 5.8943 | 5.9204 | 5.8939 | 5.9129 | 2035040.0 |
| 2007-11-19 09:00:00 | AAPL | Stock | 5.9129 | 5.9307 | 5.9107 | 5.9293 | 2968672.0 |
| 2007-11-19 09:30:00 | AAPL | Stock | 5.9304 | 6.0071 | 5.9018 | 5.9646 | 160532736.0 |
| 2007-11-19 10:00:00 | AAPL | Stock | 5.9646 | 5.9986 | 5.9357 | 5.9618 | 99590904.0 |
| 2007-11-19 10:30:00 | AAPL | Stock | 5.9607 | 5.9775 | 5.9068 | 5.9235 | 80239432.0 |
| 2007-11-19 11:00:00 | AAPL | Stock | 5.9232 | 5.9357 | 5.8304 | 5.8682 | 98262500.0 |
| 2007-11-19 11:30:00 | AAPL | Stock | 5.8675 | 5.9321 | 5.8675 | 5.8954 | 63541548.0 |
| 2007-11-19 12:00:00 | AAPL | Stock | 5.8961 | 5.9318 | 5.8757 | 5.915 | 58129064.0 |
| 2007-11-19 12:30:00 | AAPL | Stock | 5.915 | 5.92 | 5.8354 | 5.8546 | 52761240.0 |
| 2007-11-19 13:00:00 | AAPL | Stock | 5.855 | 5.8761 | 5.8018 | 5.8429 | 79435356.0 |
| 2007-11-19 13:30:00 | AAPL | Stock | 5.8446 | 5.8554 | 5.7975 | 5.8014 | 55288240.0 |
| 2007-11-19 14:00:00 | AAPL | Stock | 5.8018 | 5.8943 | 5.7893 | 5.8764 | 88125044.0 |
| 2007-11-19 14:30:00 | AAPL | Stock | 5.8768 | 5.9371 | 5.8518 | 5.8914 | 91314272.0 |
| 2007-11-19 15:00:00 | AAPL | Stock | 5.8911 | 5.9055 | 5.8429 | 5.89 | 76306636.0 |
| 2007-11-19 15:30:00 | AAPL | Stock | 5.89 | 5.89 | 5.7911 | 5.8571 | 115860976.0 |
| 2007-11-19 16:00:00 | AAPL | Stock | 5.8571 | 5.9475 | 5.8468 | 5.8786 | 23245152.0 |
| 2007-11-19 16:30:00 | AAPL | Stock | 5.8786 | 5.8989 | 5.8554 | 5.8857 | 2440424.0 |
| 2007-11-19 17:00:00 | AAPL | Stock | 5.8893 | 5.8929 | 5.8825 | 5.8857 | 317800.0 |
| 2007-11-19 17:30:00 | AAPL | Stock | 5.8839 | 5.8947 | 5.8336 | 5.875 | 576912.0 |
| 2007-11-19 18:00:00 | AAPL | Stock | 5.8786 | 5.8929 | 5.8786 | 5.8929 | 155876.0 |
| 2007-11-19 18:30:00 | AAPL | Stock | 5.8868 | 5.8929 | 5.8857 | 5.8925 | 175700.0 |
| 2007-11-19 19:00:00 | AAPL | Stock | 5.8911 | 5.8929 | 5.8882 | 5.8929 | 99344.0 |
| 2007-11-19 19:30:00 | AAPL | Stock | 5.8929 | 5.9079 | 5.8929 | 5.9068 | 488068.0 |
| 2007-11-19 08:00:00 | MSFT | Stock | 33.88 | 33.9 | 33.88 | 33.9 | 2397.0 |
| 2007-11-19 08:30:00 | MSFT | Stock | 33.9 | 33.95 | 33.87 | 33.9 | 1397.0 |
| 2007-11-19 09:00:00 | MSFT | Stock | 33.89 | 33.93 | 33.85 | 33.91 | 12006.0 |
| 2007-11-19 09:30:00 | MSFT | Stock | 33.95 | 34.24 | 33.87 | 34.01 | 4972282.0 |
| 2007-11-19 10:00:00 | MSFT | Stock | 34.01 | 34.2 | 34.01 | 34.17 | 3931133.0 |
| 2007-11-19 10:30:00 | MSFT | Stock | 34.16 | 34.17 | 33.98 | 34.04 | 4925489.0 |
| 2007-11-19 11:00:00 | MSFT | Stock | 34.03 | 34.04 | 33.9 | 33.967 | 4528529.0 |
| 2007-11-19 11:30:00 | MSFT | Stock | 33.97 | 34.12 | 33.96 | 34.02 | 3900317.0 |
| 2007-11-19 12:00:00 | MSFT | Stock | 34.02 | 34.21 | 34.0 | 34.15 | 2972121.0 |
| 2007-11-19 12:30:00 | MSFT | Stock | 34.15 | 34.22 | 34.08 | 34.1 | 2590795.0 |
| 2007-11-19 13:00:00 | MSFT | Stock | 34.11 | 34.19 | 34.05 | 34.18 | 3588479.0 |
| 2007-11-19 13:30:00 | MSFT | Stock | 34.18 | 34.19 | 34.02 | 34.02 | 3001932.0 |
| 2007-11-19 14:00:00 | MSFT | Stock | 34.02 | 34.19 | 34.0 | 34.12 | 4301007.0 |
| 2007-11-19 14:30:00 | MSFT | Stock | 34.12 | 34.19 | 34.07 | 34.098 | 3557580.0 |
| 2007-11-19 15:00:00 | MSFT | Stock | 34.1 | 34.1 | 34.01 | 34.06 | 5099685.0 |
| 2007-11-19 15:30:00 | MSFT | Stock | 34.06 | 34.07 | 33.93 | 33.97 | 11734304.0 |
| 2007-11-19 16:00:00 | MSFT | Stock | 33.96 | 34.12 | 33.9 | 34.05 | 3849551.0 |
| 2007-11-19 16:30:00 | MSFT | Stock | 34.04 | 34.04 | 33.96 | 34.0 | 25526.0 |
| 2007-11-19 17:00:00 | MSFT | Stock | 34.01 | 34.01 | 33.96 | 33.96 | 10721.0 |
| 2007-11-19 17:30:00 | MSFT | Stock | 34.02 | 34.059 | 34.0 | 34.0 | 9650.0 |
| 2007-11-19 18:00:00 | MSFT | Stock | 34.04 | 34.1 | 34.04 | 34.1 | 13050.0 |
| 2007-11-19 18:30:00 | MSFT | Stock | 34.02 | 34.02 | 34.02 | 34.02 | 100.0 |
| 2007-11-19 19:00:00 | MSFT | Stock | 34.0 | 34.01 | 34.0 | 34.0 | 3600.0 |
> showing 50 of 68,897 rows — these rows as CSV