PREVIEW / stock_30min / 2010-07-15
file: by_date/stock_30min/2010/2010-07-15.parquet size: 1.3 MB rows: 70,711 symbols: 3,435
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 |
|---|---|---|---|---|---|---|---|
| 2010-07-15 06:00:00 | AAPL | Stock | 8.9736 | 9.0 | 8.9721 | 9.0 | 19600.0 |
| 2010-07-15 06:30:00 | AAPL | Stock | 9.0075 | 9.0179 | 9.0075 | 9.0179 | 11200.0 |
| 2010-07-15 07:00:00 | AAPL | Stock | 9.0 | 9.0268 | 8.9521 | 8.9604 | 149884.0 |
| 2010-07-15 07:30:00 | AAPL | Stock | 8.9607 | 8.9721 | 8.9304 | 8.9643 | 1035804.0 |
| 2010-07-15 08:00:00 | AAPL | Stock | 8.9679 | 8.9968 | 8.9571 | 8.9964 | 2015412.0 |
| 2010-07-15 08:30:00 | AAPL | Stock | 8.9932 | 9.0079 | 8.9732 | 8.9779 | 2322320.0 |
| 2010-07-15 09:00:00 | AAPL | Stock | 8.9764 | 8.9957 | 8.8393 | 8.865 | 15342768.0 |
| 2010-07-15 09:30:00 | AAPL | Stock | 8.8654 | 8.9321 | 8.8321 | 8.9137 | 156277996.0 |
| 2010-07-15 10:00:00 | AAPL | Stock | 8.9137 | 8.925 | 8.85 | 8.8804 | 89182912.0 |
| 2010-07-15 10:30:00 | AAPL | Stock | 8.88 | 8.9025 | 8.8382 | 8.9 | 76352668.0 |
| 2010-07-15 11:00:00 | AAPL | Stock | 8.8977 | 8.9114 | 8.8793 | 8.8932 | 37037196.0 |
| 2010-07-15 11:30:00 | AAPL | Stock | 8.8943 | 8.9107 | 8.88 | 8.8871 | 27858544.0 |
| 2010-07-15 12:00:00 | AAPL | Stock | 8.8882 | 8.9184 | 8.8807 | 8.9046 | 24596488.0 |
| 2010-07-15 12:30:00 | AAPL | Stock | 8.9029 | 8.9054 | 8.8611 | 8.8681 | 31565716.0 |
| 2010-07-15 13:00:00 | AAPL | Stock | 8.8693 | 8.9104 | 8.8689 | 8.9073 | 27578516.0 |
| 2010-07-15 13:30:00 | AAPL | Stock | 8.9075 | 8.9143 | 8.8868 | 8.8879 | 23325764.0 |
| 2010-07-15 14:00:00 | AAPL | Stock | 8.8879 | 8.9164 | 8.8811 | 8.9126 | 23172940.0 |
| 2010-07-15 14:30:00 | AAPL | Stock | 8.9143 | 8.9832 | 8.9107 | 8.9493 | 68949160.0 |
| 2010-07-15 15:00:00 | AAPL | Stock | 8.9493 | 9.1775 | 8.9096 | 8.9785 | 86290540.0 |
| 2010-07-15 15:30:00 | AAPL | Stock | 8.9768 | 9.0246 | 8.9507 | 8.975 | 108104304.0 |
| 2010-07-15 16:00:00 | AAPL | Stock | 8.9796 | 9.0008 | 8.8542 | 8.9643 | 14893424.0 |
| 2010-07-15 16:30:00 | AAPL | Stock | 8.9675 | 9.0075 | 8.9589 | 8.9929 | 1278844.0 |
| 2010-07-15 17:00:00 | AAPL | Stock | 9.0 | 9.0054 | 8.9979 | 9.0 | 782040.0 |
| 2010-07-15 17:30:00 | AAPL | Stock | 9.0 | 9.0793 | 8.9968 | 9.0754 | 1479492.0 |
| 2010-07-15 18:00:00 | AAPL | Stock | 9.0754 | 9.0889 | 8.9804 | 9.0518 | 1713180.0 |
| 2010-07-15 18:30:00 | AAPL | Stock | 9.05 | 9.0679 | 9.05 | 9.0596 | 506408.0 |
| 2010-07-15 19:00:00 | AAPL | Stock | 9.0607 | 9.0607 | 9.05 | 9.0589 | 280644.0 |
| 2010-07-15 19:30:00 | AAPL | Stock | 9.0539 | 9.0539 | 9.025 | 9.0257 | 534744.0 |
| 2010-07-15 04:30:00 | MSFT | Stock | 25.45 | 25.45 | 25.45 | 25.45 | 200.0 |
| 2010-07-15 06:30:00 | MSFT | Stock | 25.5 | 25.5 | 25.44 | 25.44 | 500.0 |
| 2010-07-15 07:00:00 | MSFT | Stock | 25.44 | 25.5 | 25.44 | 25.5 | 1500.0 |
| 2010-07-15 07:30:00 | MSFT | Stock | 25.5 | 25.54 | 25.5 | 25.54 | 400.0 |
| 2010-07-15 08:00:00 | MSFT | Stock | 25.52 | 25.6 | 25.5 | 25.55 | 23790.0 |
| 2010-07-15 08:30:00 | MSFT | Stock | 25.55 | 25.55 | 25.45 | 25.52 | 7700.0 |
| 2010-07-15 09:00:00 | MSFT | Stock | 25.51 | 25.56 | 25.45 | 25.45 | 73981.0 |
| 2010-07-15 09:30:00 | MSFT | Stock | 25.48 | 25.58 | 25.235 | 25.378 | 5646386.0 |
| 2010-07-15 10:00:00 | MSFT | Stock | 25.38 | 25.38 | 24.98 | 25.12 | 6968297.0 |
| 2010-07-15 10:30:00 | MSFT | Stock | 25.115 | 25.21 | 25.08 | 25.15 | 2719678.0 |
| 2010-07-15 11:00:00 | MSFT | Stock | 25.15 | 25.28 | 24.98 | 25.24 | 6249322.0 |
| 2010-07-15 11:30:00 | MSFT | Stock | 25.24 | 25.41 | 25.23 | 25.375 | 4508800.0 |
| 2010-07-15 12:00:00 | MSFT | Stock | 25.37 | 25.46 | 25.29 | 25.36 | 4406350.0 |
| 2010-07-15 12:30:00 | MSFT | Stock | 25.36 | 25.41 | 25.3 | 25.36 | 2542375.0 |
| 2010-07-15 13:00:00 | MSFT | Stock | 25.355 | 25.49 | 25.355 | 25.421 | 1842458.0 |
| 2010-07-15 13:30:00 | MSFT | Stock | 25.42 | 25.47 | 25.38 | 25.39 | 1776789.0 |
| 2010-07-15 14:00:00 | MSFT | Stock | 25.4 | 25.45 | 25.33 | 25.433 | 1947272.0 |
| 2010-07-15 14:30:00 | MSFT | Stock | 25.44 | 25.47 | 25.33 | 25.345 | 2608399.0 |
| 2010-07-15 15:00:00 | MSFT | Stock | 25.35 | 25.41 | 25.26 | 25.37 | 3779080.0 |
| 2010-07-15 15:30:00 | MSFT | Stock | 25.37 | 25.59 | 25.36 | 25.52 | 9072839.0 |
| 2010-07-15 16:00:00 | MSFT | Stock | 25.51 | 25.56 | 25.322 | 25.505 | 2102972.0 |
| 2010-07-15 16:30:00 | MSFT | Stock | 25.48 | 25.51 | 25.358 | 25.48 | 48076.0 |
> showing 50 of 70,711 rows — these rows as CSV