PREVIEW / stock_30min / 2012-10-16
file: by_date/stock_30min/2012/2012-10-16.parquet size: 1.4 MB rows: 74,783 symbols: 3,476
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 |
|---|---|---|---|---|---|---|---|
| 2012-10-16 04:00:00 | AAPL | Stock | 22.7464 | 22.7464 | 22.7464 | 22.7464 | 13440.0 |
| 2012-10-16 04:30:00 | AAPL | Stock | 22.7557 | 22.7679 | 22.7557 | 22.7679 | 5600.0 |
| 2012-10-16 05:00:00 | AAPL | Stock | 22.7571 | 22.7679 | 22.7429 | 22.7679 | 25844.0 |
| 2012-10-16 05:30:00 | AAPL | Stock | 22.7607 | 22.8014 | 22.7571 | 22.7936 | 40992.0 |
| 2012-10-16 06:00:00 | AAPL | Stock | 22.7786 | 22.7786 | 22.7786 | 22.7786 | 8400.0 |
| 2012-10-16 06:30:00 | AAPL | Stock | 22.7718 | 22.7936 | 22.7593 | 22.7936 | 76636.0 |
| 2012-10-16 07:00:00 | AAPL | Stock | 22.7986 | 22.7986 | 22.7164 | 22.7264 | 248780.0 |
| 2012-10-16 07:30:00 | AAPL | Stock | 22.7418 | 22.7589 | 22.6357 | 22.6875 | 658616.0 |
| 2012-10-16 08:00:00 | AAPL | Stock | 22.7046 | 22.7686 | 22.6921 | 22.7493 | 1415820.0 |
| 2012-10-16 08:30:00 | AAPL | Stock | 22.7329 | 22.7464 | 22.6625 | 22.6807 | 1579592.0 |
| 2012-10-16 09:00:00 | AAPL | Stock | 22.6889 | 22.71 | 22.6786 | 22.7018 | 1264788.0 |
| 2012-10-16 09:30:00 | AAPL | Stock | 22.6979 | 22.7107 | 22.5357 | 22.602 | 59285800.0 |
| 2012-10-16 10:00:00 | AAPL | Stock | 22.5932 | 22.71 | 22.5625 | 22.6568 | 37488612.0 |
| 2012-10-16 10:30:00 | AAPL | Stock | 22.6564 | 22.8504 | 22.6275 | 22.8479 | 45587864.0 |
| 2012-10-16 11:00:00 | AAPL | Stock | 22.8446 | 23.0143 | 22.8214 | 22.9918 | 52294788.0 |
| 2012-10-16 11:30:00 | AAPL | Stock | 22.9886 | 23.0525 | 22.9571 | 22.9861 | 39510492.0 |
| 2012-10-16 12:00:00 | AAPL | Stock | 22.9889 | 23.1786 | 22.9614 | 23.1214 | 56124292.0 |
| 2012-10-16 12:30:00 | AAPL | Stock | 23.12 | 23.1964 | 23.1071 | 23.11 | 31534160.0 |
| 2012-10-16 13:00:00 | AAPL | Stock | 23.11 | 23.1714 | 23.0636 | 23.0954 | 24693004.0 |
| 2012-10-16 13:30:00 | AAPL | Stock | 23.0957 | 23.1282 | 23.0714 | 23.0936 | 22172948.0 |
| 2012-10-16 14:00:00 | AAPL | Stock | 23.0929 | 23.1143 | 23.0411 | 23.1107 | 26155276.0 |
| 2012-10-16 14:30:00 | AAPL | Stock | 23.1107 | 23.1964 | 23.1 | 23.1771 | 31856272.0 |
| 2012-10-16 15:00:00 | AAPL | Stock | 23.1761 | 23.2061 | 23.1429 | 23.1868 | 33415200.0 |
| 2012-10-16 15:30:00 | AAPL | Stock | 23.1873 | 23.225 | 23.1796 | 23.2004 | 58884196.0 |
| 2012-10-16 16:00:00 | AAPL | Stock | 23.2 | 23.2091 | 22.6821 | 23.1625 | 12719896.0 |
| 2012-10-16 16:30:00 | AAPL | Stock | 23.17 | 23.2068 | 23.15 | 23.1643 | 1189468.0 |
| 2012-10-16 17:00:00 | AAPL | Stock | 23.1607 | 23.1607 | 23.1536 | 23.1586 | 282604.0 |
| 2012-10-16 17:30:00 | AAPL | Stock | 23.1607 | 23.1643 | 23.1536 | 23.155 | 402780.0 |
| 2012-10-16 18:00:00 | AAPL | Stock | 23.1557 | 23.1607 | 23.1543 | 23.1557 | 53424.0 |
| 2012-10-16 18:30:00 | AAPL | Stock | 23.1543 | 23.1643 | 23.1254 | 23.1643 | 199024.0 |
| 2012-10-16 19:00:00 | AAPL | Stock | 23.1632 | 23.1661 | 23.1568 | 23.1661 | 140672.0 |
| 2012-10-16 19:30:00 | AAPL | Stock | 23.1711 | 23.1782 | 23.1646 | 23.1646 | 98308.0 |
| 2012-10-16 06:00:00 | MSFT | Stock | 29.27 | 29.27 | 29.27 | 29.27 | 200.0 |
| 2012-10-16 07:30:00 | MSFT | Stock | 29.62 | 29.7 | 29.6 | 29.7 | 7100.0 |
| 2012-10-16 08:00:00 | MSFT | Stock | 29.78 | 29.78 | 29.58 | 29.6 | 21927.0 |
| 2012-10-16 08:30:00 | MSFT | Stock | 29.6 | 29.6 | 29.5 | 29.5 | 37370.0 |
| 2012-10-16 09:00:00 | MSFT | Stock | 29.52 | 29.52 | 29.35 | 29.45 | 97870.0 |
| 2012-10-16 09:30:00 | MSFT | Stock | 29.45 | 29.56 | 29.32 | 29.51 | 4905070.0 |
| 2012-10-16 10:00:00 | MSFT | Stock | 29.52 | 29.58 | 29.5 | 29.56 | 3742165.0 |
| 2012-10-16 10:30:00 | MSFT | Stock | 29.55 | 29.59 | 29.505 | 29.565 | 2606544.0 |
| 2012-10-16 11:00:00 | MSFT | Stock | 29.56 | 29.65 | 29.55 | 29.646 | 2670712.0 |
| 2012-10-16 11:30:00 | MSFT | Stock | 29.65 | 29.72 | 29.6 | 29.68 | 3159207.0 |
| 2012-10-16 12:00:00 | MSFT | Stock | 29.674 | 29.74 | 29.63 | 29.655 | 2602977.0 |
| 2012-10-16 12:30:00 | MSFT | Stock | 29.652 | 29.68 | 29.63 | 29.635 | 2900063.0 |
| 2012-10-16 13:00:00 | MSFT | Stock | 29.635 | 29.66 | 29.63 | 29.64 | 1538271.0 |
| 2012-10-16 13:30:00 | MSFT | Stock | 29.645 | 29.65 | 29.59 | 29.615 | 1587132.0 |
| 2012-10-16 14:00:00 | MSFT | Stock | 29.62 | 29.62 | 29.51 | 29.517 | 3062939.0 |
| 2012-10-16 14:30:00 | MSFT | Stock | 29.52 | 29.52 | 29.46 | 29.485 | 2928103.0 |
| 2012-10-16 15:00:00 | MSFT | Stock | 29.485 | 29.51 | 29.43 | 29.475 | 4403040.0 |
| 2012-10-16 15:30:00 | MSFT | Stock | 29.48 | 29.585 | 29.45 | 29.52 | 8714885.0 |
> showing 50 of 74,783 rows — these rows as CSV