PREVIEW / stock_30min / 2012-12-11
file: by_date/stock_30min/2012/2012-12-11.parquet size: 1.4 MB rows: 76,478 symbols: 3,494
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-12-11 04:00:00 | AAPL | Stock | 19.0179 | 19.0975 | 19.0179 | 19.0357 | 49336.0 |
| 2012-12-11 04:30:00 | AAPL | Stock | 19.0368 | 19.0818 | 19.0186 | 19.0818 | 16240.0 |
| 2012-12-11 05:00:00 | AAPL | Stock | 19.0714 | 19.0839 | 19.0518 | 19.0839 | 42000.0 |
| 2012-12-11 05:30:00 | AAPL | Stock | 19.0571 | 19.0807 | 19.0536 | 19.0536 | 19600.0 |
| 2012-12-11 06:00:00 | AAPL | Stock | 19.0586 | 19.0693 | 19.0446 | 19.0693 | 8400.0 |
| 2012-12-11 06:30:00 | AAPL | Stock | 19.0511 | 19.0679 | 19.0446 | 19.0668 | 47600.0 |
| 2012-12-11 07:00:00 | AAPL | Stock | 19.0614 | 19.1 | 19.0071 | 19.1 | 239456.0 |
| 2012-12-11 07:30:00 | AAPL | Stock | 19.0993 | 19.1 | 19.0714 | 19.0854 | 239120.0 |
| 2012-12-11 08:00:00 | AAPL | Stock | 19.0954 | 19.2236 | 19.0357 | 19.1875 | 2614164.0 |
| 2012-12-11 08:30:00 | AAPL | Stock | 19.1875 | 19.1911 | 19.1521 | 19.1575 | 1798580.0 |
| 2012-12-11 09:00:00 | AAPL | Stock | 19.1596 | 19.2957 | 19.1586 | 19.2804 | 4238388.0 |
| 2012-12-11 09:30:00 | AAPL | Stock | 19.2775 | 19.4286 | 19.1918 | 19.3723 | 96794320.0 |
| 2012-12-11 10:00:00 | AAPL | Stock | 19.3711 | 19.4429 | 19.2993 | 19.4332 | 45411352.0 |
| 2012-12-11 10:30:00 | AAPL | Stock | 19.4311 | 19.5318 | 19.42 | 19.4693 | 45318196.0 |
| 2012-12-11 11:00:00 | AAPL | Stock | 19.4714 | 19.6271 | 19.4671 | 19.5757 | 56022120.0 |
| 2012-12-11 11:30:00 | AAPL | Stock | 19.575 | 19.5875 | 19.4429 | 19.47 | 43462356.0 |
| 2012-12-11 12:00:00 | AAPL | Stock | 19.4736 | 19.5761 | 19.3946 | 19.5239 | 42173600.0 |
| 2012-12-11 12:30:00 | AAPL | Stock | 19.5293 | 19.5443 | 19.4614 | 19.4964 | 16465960.0 |
| 2012-12-11 13:00:00 | AAPL | Stock | 19.4929 | 19.5096 | 19.4175 | 19.4772 | 16775080.0 |
| 2012-12-11 13:30:00 | AAPL | Stock | 19.4807 | 19.5482 | 19.4643 | 19.5107 | 18526704.0 |
| 2012-12-11 14:00:00 | AAPL | Stock | 19.5107 | 19.5446 | 19.4839 | 19.5077 | 18971148.0 |
| 2012-12-11 14:30:00 | AAPL | Stock | 19.5061 | 19.5071 | 19.3196 | 19.3632 | 46871384.0 |
| 2012-12-11 15:00:00 | AAPL | Stock | 19.3632 | 19.3682 | 19.2143 | 19.3514 | 69013616.0 |
| 2012-12-11 15:30:00 | AAPL | Stock | 19.3514 | 19.3804 | 19.3093 | 19.3218 | 45727668.0 |
| 2012-12-11 16:00:00 | AAPL | Stock | 19.3218 | 19.5118 | 19.3067 | 19.3439 | 8986600.0 |
| 2012-12-11 16:30:00 | AAPL | Stock | 19.3429 | 19.3804 | 19.3354 | 19.3679 | 897316.0 |
| 2012-12-11 17:00:00 | AAPL | Stock | 19.3675 | 19.3675 | 19.3471 | 19.3661 | 417788.0 |
| 2012-12-11 17:30:00 | AAPL | Stock | 19.3643 | 19.4054 | 19.3618 | 19.3971 | 421512.0 |
| 2012-12-11 18:00:00 | AAPL | Stock | 19.3982 | 19.4032 | 19.3764 | 19.3893 | 266084.0 |
| 2012-12-11 18:30:00 | AAPL | Stock | 19.3929 | 19.4036 | 19.3929 | 19.3964 | 81648.0 |
| 2012-12-11 19:00:00 | AAPL | Stock | 19.3979 | 19.3996 | 19.3821 | 19.3925 | 136752.0 |
| 2012-12-11 19:30:00 | AAPL | Stock | 19.3925 | 19.4018 | 19.3911 | 19.3936 | 140700.0 |
| 2012-12-11 05:00:00 | MSFT | Stock | 27.05 | 27.1 | 27.05 | 27.1 | 520.0 |
| 2012-12-11 05:30:00 | MSFT | Stock | 27.14 | 27.14 | 27.14 | 27.14 | 1465.0 |
| 2012-12-11 06:00:00 | MSFT | Stock | 27.14 | 27.14 | 27.14 | 27.14 | 320.0 |
| 2012-12-11 07:00:00 | MSFT | Stock | 27.1 | 27.1 | 27.1 | 27.1 | 1330.0 |
| 2012-12-11 07:30:00 | MSFT | Stock | 27.1 | 27.14 | 27.1 | 27.12 | 3708.0 |
| 2012-12-11 08:00:00 | MSFT | Stock | 27.11 | 27.12 | 26.99 | 27.05 | 24748.0 |
| 2012-12-11 08:30:00 | MSFT | Stock | 27.05 | 27.08 | 27.05 | 27.06 | 8337.0 |
| 2012-12-11 09:00:00 | MSFT | Stock | 27.07 | 27.12 | 27.04 | 27.07 | 39816.0 |
| 2012-12-11 09:30:00 | MSFT | Stock | 27.05 | 27.29 | 27.05 | 27.28 | 6453089.0 |
| 2012-12-11 10:00:00 | MSFT | Stock | 27.285 | 27.41 | 27.25 | 27.39 | 4744686.0 |
| 2012-12-11 10:30:00 | MSFT | Stock | 27.385 | 27.48 | 27.36 | 27.415 | 4450948.0 |
| 2012-12-11 11:00:00 | MSFT | Stock | 27.42 | 27.48 | 27.4 | 27.42 | 3291902.0 |
| 2012-12-11 11:30:00 | MSFT | Stock | 27.415 | 27.42 | 27.3 | 27.31 | 2851174.0 |
| 2012-12-11 12:00:00 | MSFT | Stock | 27.31 | 27.43 | 27.28 | 27.405 | 3533706.0 |
| 2012-12-11 12:30:00 | MSFT | Stock | 27.4 | 27.47 | 27.4 | 27.43 | 2742335.0 |
| 2012-12-11 13:00:00 | MSFT | Stock | 27.42 | 27.45 | 27.4 | 27.425 | 2424132.0 |
| 2012-12-11 13:30:00 | MSFT | Stock | 27.425 | 27.48 | 27.41 | 27.47 | 2003803.0 |
| 2012-12-11 14:00:00 | MSFT | Stock | 27.47 | 27.49 | 27.41 | 27.435 | 1867854.0 |
> showing 50 of 76,478 rows — these rows as CSV