PREVIEW / stock_30min / 2012-02-06
file: by_date/stock_30min/2012/2012-02-06.parquet size: 1.4 MB rows: 75,554 symbols: 3,553
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-02-06 06:00:00 | AAPL | Stock | 16.3607 | 16.3607 | 16.3571 | 16.3571 | 15120.0 |
| 2012-02-06 06:30:00 | AAPL | Stock | 16.3607 | 16.3607 | 16.3571 | 16.3571 | 8400.0 |
| 2012-02-06 07:00:00 | AAPL | Stock | 16.3654 | 16.3829 | 16.3632 | 16.3829 | 45108.0 |
| 2012-02-06 07:30:00 | AAPL | Stock | 16.3679 | 16.3679 | 16.3582 | 16.3589 | 14000.0 |
| 2012-02-06 08:00:00 | AAPL | Stock | 16.3711 | 16.3846 | 16.3611 | 16.3643 | 226548.0 |
| 2012-02-06 08:30:00 | AAPL | Stock | 16.3618 | 16.3643 | 16.3443 | 16.3539 | 276612.0 |
| 2012-02-06 09:00:00 | AAPL | Stock | 16.3496 | 16.3746 | 16.3468 | 16.3675 | 914144.0 |
| 2012-02-06 09:30:00 | AAPL | Stock | 16.365 | 16.4743 | 16.3643 | 16.4639 | 37077292.0 |
| 2012-02-06 10:00:00 | AAPL | Stock | 16.4636 | 16.4779 | 16.4547 | 16.4643 | 19840828.0 |
| 2012-02-06 10:30:00 | AAPL | Stock | 16.4643 | 16.5179 | 16.4557 | 16.5082 | 26442388.0 |
| 2012-02-06 11:00:00 | AAPL | Stock | 16.5082 | 16.5868 | 16.5004 | 16.5793 | 30391704.0 |
| 2012-02-06 11:30:00 | AAPL | Stock | 16.5754 | 16.5954 | 16.5714 | 16.5821 | 21476140.0 |
| 2012-02-06 12:00:00 | AAPL | Stock | 16.5821 | 16.5929 | 16.5525 | 16.5704 | 17174584.0 |
| 2012-02-06 12:30:00 | AAPL | Stock | 16.5718 | 16.6064 | 16.5661 | 16.5961 | 14939204.0 |
| 2012-02-06 13:00:00 | AAPL | Stock | 16.5961 | 16.6018 | 16.5857 | 16.5859 | 9210236.0 |
| 2012-02-06 13:30:00 | AAPL | Stock | 16.5857 | 16.5946 | 16.5468 | 16.5529 | 11557196.0 |
| 2012-02-06 14:00:00 | AAPL | Stock | 16.5539 | 16.5668 | 16.55 | 16.5571 | 7772940.0 |
| 2012-02-06 14:30:00 | AAPL | Stock | 16.5589 | 16.575 | 16.5464 | 16.5518 | 8391516.0 |
| 2012-02-06 15:00:00 | AAPL | Stock | 16.55 | 16.5679 | 16.55 | 16.5607 | 8806560.0 |
| 2012-02-06 15:30:00 | AAPL | Stock | 16.5605 | 16.5696 | 16.5482 | 16.5664 | 23450504.0 |
| 2012-02-06 16:00:00 | AAPL | Stock | 16.5704 | 16.5782 | 16.5263 | 16.5714 | 6196148.0 |
| 2012-02-06 16:30:00 | AAPL | Stock | 16.5743 | 16.5746 | 16.5567 | 16.5725 | 498960.0 |
| 2012-02-06 17:00:00 | AAPL | Stock | 16.5721 | 16.5857 | 16.5721 | 16.5839 | 127932.0 |
| 2012-02-06 17:30:00 | AAPL | Stock | 16.5857 | 16.6018 | 16.5829 | 16.5857 | 365064.0 |
| 2012-02-06 18:00:00 | AAPL | Stock | 16.5889 | 16.5925 | 16.585 | 16.5921 | 126140.0 |
| 2012-02-06 18:30:00 | AAPL | Stock | 16.5911 | 16.5921 | 16.5893 | 16.5914 | 82740.0 |
| 2012-02-06 19:00:00 | AAPL | Stock | 16.59 | 16.59 | 16.5821 | 16.5889 | 57372.0 |
| 2012-02-06 19:30:00 | AAPL | Stock | 16.5839 | 16.5911 | 16.5839 | 16.5911 | 98112.0 |
| 2012-02-06 07:30:00 | MSFT | Stock | 30.09 | 30.13 | 30.05 | 30.13 | 5343.0 |
| 2012-02-06 08:00:00 | MSFT | Stock | 30.16 | 30.17 | 30.04 | 30.09 | 9779.0 |
| 2012-02-06 08:30:00 | MSFT | Stock | 30.06 | 30.08 | 30.04 | 30.06 | 4150.0 |
| 2012-02-06 09:00:00 | MSFT | Stock | 30.04 | 30.08 | 30.01 | 30.07 | 20831.0 |
| 2012-02-06 09:30:00 | MSFT | Stock | 30.08 | 30.18 | 30.03 | 30.08 | 3249173.0 |
| 2012-02-06 10:00:00 | MSFT | Stock | 30.08 | 30.14 | 30.05 | 30.07 | 2350911.0 |
| 2012-02-06 10:30:00 | MSFT | Stock | 30.07 | 30.09 | 29.99 | 30.06 | 1979414.0 |
| 2012-02-06 11:00:00 | MSFT | Stock | 30.06 | 30.1 | 30.028 | 30.03 | 2319084.0 |
| 2012-02-06 11:30:00 | MSFT | Stock | 30.03 | 30.09 | 29.99 | 30.01 | 2078208.0 |
| 2012-02-06 12:00:00 | MSFT | Stock | 30.02 | 30.029 | 29.97 | 29.98 | 1297651.0 |
| 2012-02-06 12:30:00 | MSFT | Stock | 29.98 | 30.05 | 29.97 | 30.01 | 1126348.0 |
| 2012-02-06 13:00:00 | MSFT | Stock | 30.012 | 30.03 | 29.99 | 30.01 | 1000779.0 |
| 2012-02-06 13:30:00 | MSFT | Stock | 30.02 | 30.08 | 30.01 | 30.07 | 1331395.0 |
| 2012-02-06 14:00:00 | MSFT | Stock | 30.076 | 30.15 | 30.07 | 30.145 | 1168260.0 |
| 2012-02-06 14:30:00 | MSFT | Stock | 30.145 | 30.16 | 30.06 | 30.07 | 1966691.0 |
| 2012-02-06 15:00:00 | MSFT | Stock | 30.08 | 30.16 | 30.07 | 30.12 | 1787635.0 |
| 2012-02-06 15:30:00 | MSFT | Stock | 30.12 | 30.22 | 30.11 | 30.2 | 4405703.0 |
| 2012-02-06 16:00:00 | MSFT | Stock | 30.191 | 30.22 | 30.081 | 30.2 | 1491088.0 |
| 2012-02-06 16:30:00 | MSFT | Stock | 30.208 | 30.208 | 30.13 | 30.16 | 95228.0 |
| 2012-02-06 17:00:00 | MSFT | Stock | 30.16 | 30.16 | 30.025 | 30.025 | 36872.0 |
| 2012-02-06 17:30:00 | MSFT | Stock | 30.16 | 30.16 | 30.16 | 30.16 | 200.0 |
| 2012-02-06 18:00:00 | MSFT | Stock | 30.15 | 30.15 | 30.14 | 30.14 | 3330.0 |
> showing 50 of 75,554 rows — these rows as CSV