PREVIEW / stock_30min / 2015-11-10
file: by_date/stock_30min/2015/2015-11-10.parquet size: 1.6 MB rows: 81,586 symbols: 3,398
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-10 04:00:00 | AAPL | Stock | 30.1125 | 30.1125 | 29.9825 | 30.0225 | 27444.0 |
| 2015-11-10 04:30:00 | AAPL | Stock | 30.0 | 30.0 | 29.9725 | 29.9725 | 16380.0 |
| 2015-11-10 05:00:00 | AAPL | Stock | 30.0075 | 30.0075 | 29.9975 | 29.9975 | 2472.0 |
| 2015-11-10 05:30:00 | AAPL | Stock | 30.0 | 30.0 | 29.95 | 29.95 | 9000.0 |
| 2015-11-10 06:00:00 | AAPL | Stock | 29.93 | 29.93 | 29.8625 | 29.89 | 70500.0 |
| 2015-11-10 06:30:00 | AAPL | Stock | 29.8775 | 29.925 | 29.8725 | 29.895 | 87504.0 |
| 2015-11-10 07:00:00 | AAPL | Stock | 29.91 | 29.9125 | 29.575 | 29.6 | 618368.0 |
| 2015-11-10 07:30:00 | AAPL | Stock | 29.625 | 29.7 | 29.4775 | 29.575 | 529024.0 |
| 2015-11-10 08:00:00 | AAPL | Stock | 29.575 | 30.075 | 29.495 | 29.51 | 1447464.0 |
| 2015-11-10 08:30:00 | AAPL | Stock | 29.5 | 29.5025 | 29.3775 | 29.445 | 2072864.0 |
| 2015-11-10 09:00:00 | AAPL | Stock | 29.445 | 29.4475 | 29.2025 | 29.205 | 3413944.0 |
| 2015-11-10 09:30:00 | AAPL | Stock | 29.225 | 29.475 | 29.14 | 29.3525 | 47670928.0 |
| 2015-11-10 10:00:00 | AAPL | Stock | 29.3475 | 29.43 | 29.275 | 29.3625 | 16945996.0 |
| 2015-11-10 10:30:00 | AAPL | Stock | 29.3612 | 29.485 | 29.2875 | 29.454 | 12199908.0 |
| 2015-11-10 11:00:00 | AAPL | Stock | 29.4525 | 29.5175 | 29.3975 | 29.4462 | 11141092.0 |
| 2015-11-10 11:30:00 | AAPL | Stock | 29.4475 | 29.48 | 29.3525 | 29.3688 | 8680844.0 |
| 2015-11-10 12:00:00 | AAPL | Stock | 29.37 | 29.37 | 29.2275 | 29.3162 | 14962788.0 |
| 2015-11-10 12:30:00 | AAPL | Stock | 29.3175 | 29.32 | 29.195 | 29.2325 | 9634032.0 |
| 2015-11-10 13:00:00 | AAPL | Stock | 29.2325 | 29.2348 | 29.1275 | 29.195 | 11223772.0 |
| 2015-11-10 13:30:00 | AAPL | Stock | 29.1975 | 29.2075 | 29.095 | 29.0975 | 10266324.0 |
| 2015-11-10 14:00:00 | AAPL | Stock | 29.0975 | 29.1525 | 29.0152 | 29.0575 | 14542376.0 |
| 2015-11-10 14:30:00 | AAPL | Stock | 29.0572 | 29.2 | 29.0482 | 29.1875 | 11638620.0 |
| 2015-11-10 15:00:00 | AAPL | Stock | 29.1875 | 29.2425 | 29.1748 | 29.196 | 12193888.0 |
| 2015-11-10 15:30:00 | AAPL | Stock | 29.1962 | 29.265 | 29.0825 | 29.195 | 22723444.0 |
| 2015-11-10 16:00:00 | AAPL | Stock | 29.1688 | 29.205 | 29.0375 | 29.185 | 9990928.0 |
| 2015-11-10 16:30:00 | AAPL | Stock | 29.18 | 29.1925 | 29.1625 | 29.1675 | 438776.0 |
| 2015-11-10 17:00:00 | AAPL | Stock | 29.1725 | 29.1725 | 29.08 | 29.0975 | 358272.0 |
| 2015-11-10 17:30:00 | AAPL | Stock | 29.0975 | 29.1225 | 29.0975 | 29.1025 | 67756.0 |
| 2015-11-10 18:00:00 | AAPL | Stock | 29.1125 | 29.12 | 29.09 | 29.115 | 45744.0 |
| 2015-11-10 18:30:00 | AAPL | Stock | 29.1075 | 29.12 | 29.1 | 29.1 | 89840.0 |
| 2015-11-10 19:00:00 | AAPL | Stock | 29.1075 | 29.1175 | 29.0975 | 29.1 | 24608.0 |
| 2015-11-10 19:30:00 | AAPL | Stock | 29.0975 | 29.1075 | 29.085 | 29.085 | 76976.0 |
| 2015-11-10 06:30:00 | MSFT | Stock | 54.08 | 54.1 | 54.03 | 54.03 | 4730.0 |
| 2015-11-10 07:00:00 | MSFT | Stock | 54.03 | 54.03 | 54.03 | 54.03 | 100.0 |
| 2015-11-10 07:30:00 | MSFT | Stock | 54.1 | 54.1 | 54.1 | 54.1 | 2100.0 |
| 2015-11-10 08:00:00 | MSFT | Stock | 54.03 | 54.1 | 54.03 | 54.1 | 5926.0 |
| 2015-11-10 08:30:00 | MSFT | Stock | 54.14 | 54.2 | 54.1 | 54.18 | 34580.0 |
| 2015-11-10 09:00:00 | MSFT | Stock | 54.2 | 54.2 | 53.94 | 53.98 | 71009.0 |
| 2015-11-10 09:30:00 | MSFT | Stock | 53.94 | 54.13 | 53.81 | 54.0 | 4603841.0 |
| 2015-11-10 10:00:00 | MSFT | Stock | 54.0 | 54.015 | 53.47 | 53.49 | 2633541.0 |
| 2015-11-10 10:30:00 | MSFT | Stock | 53.481 | 53.61 | 53.44 | 53.57 | 2220910.0 |
| 2015-11-10 11:00:00 | MSFT | Stock | 53.58 | 53.7 | 53.55 | 53.607 | 3014966.0 |
| 2015-11-10 11:30:00 | MSFT | Stock | 53.61 | 53.7 | 53.51 | 53.515 | 2136418.0 |
| 2015-11-10 12:00:00 | MSFT | Stock | 53.511 | 53.56 | 53.413 | 53.5 | 12077104.0 |
| 2015-11-10 12:30:00 | MSFT | Stock | 53.5 | 53.525 | 53.43 | 53.43 | 3495231.0 |
| 2015-11-10 13:00:00 | MSFT | Stock | 53.438 | 53.45 | 53.27 | 53.37 | 2701594.0 |
| 2015-11-10 13:30:00 | MSFT | Stock | 53.38 | 53.56 | 53.38 | 53.51 | 3505023.0 |
| 2015-11-10 14:00:00 | MSFT | Stock | 53.505 | 53.53 | 53.39 | 53.412 | 1103905.0 |
| 2015-11-10 14:30:00 | MSFT | Stock | 53.41 | 53.57 | 53.38 | 53.499 | 2581578.0 |
| 2015-11-10 15:00:00 | MSFT | Stock | 53.5 | 53.505 | 53.29 | 53.41 | 2880404.0 |
> showing 50 of 81,586 rows — these rows as CSV