PREVIEW / stock_30min / 2016-02-05
file: by_date/stock_30min/2016/2016-02-05.parquet size: 1.6 MB rows: 81,249 symbols: 3,344
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 |
|---|---|---|---|---|---|---|---|
| 2016-02-05 04:00:00 | AAPL | Stock | 24.1925 | 24.1925 | 24.19 | 24.19 | 2000.0 |
| 2016-02-05 05:00:00 | AAPL | Stock | 24.1625 | 24.1625 | 24.1625 | 24.1625 | 3960.0 |
| 2016-02-05 05:30:00 | AAPL | Stock | 24.2225 | 24.225 | 24.2225 | 24.225 | 800.0 |
| 2016-02-05 06:00:00 | AAPL | Stock | 24.2325 | 24.2325 | 24.18 | 24.18 | 4616.0 |
| 2016-02-05 06:30:00 | AAPL | Stock | 24.17 | 24.17 | 24.17 | 24.17 | 400.0 |
| 2016-02-05 07:00:00 | AAPL | Stock | 24.22 | 24.2275 | 24.205 | 24.2275 | 3312.0 |
| 2016-02-05 07:30:00 | AAPL | Stock | 24.2275 | 24.2475 | 24.2025 | 24.2025 | 13928.0 |
| 2016-02-05 08:00:00 | AAPL | Stock | 24.18 | 24.2275 | 24.125 | 24.1725 | 72780.0 |
| 2016-02-05 08:30:00 | AAPL | Stock | 24.1525 | 24.1675 | 24.025 | 24.1225 | 252876.0 |
| 2016-02-05 09:00:00 | AAPL | Stock | 24.1 | 24.175 | 24.0875 | 24.1275 | 105072.0 |
| 2016-02-05 09:30:00 | AAPL | Stock | 24.13 | 24.23 | 23.9375 | 24.0175 | 17784288.0 |
| 2016-02-05 10:00:00 | AAPL | Stock | 24.0162 | 24.0675 | 23.7625 | 23.7975 | 16733444.0 |
| 2016-02-05 10:30:00 | AAPL | Stock | 23.7975 | 23.935 | 23.745 | 23.7725 | 12025500.0 |
| 2016-02-05 11:00:00 | AAPL | Stock | 23.775 | 23.8525 | 23.735 | 23.8012 | 11358768.0 |
| 2016-02-05 11:30:00 | AAPL | Stock | 23.8028 | 23.8575 | 23.721 | 23.8025 | 9697484.0 |
| 2016-02-05 12:00:00 | AAPL | Stock | 23.8 | 23.8575 | 23.7525 | 23.8375 | 7968568.0 |
| 2016-02-05 12:30:00 | AAPL | Stock | 23.8375 | 23.895 | 23.725 | 23.7825 | 7067416.0 |
| 2016-02-05 13:00:00 | AAPL | Stock | 23.7812 | 23.8225 | 23.75 | 23.7987 | 5348792.0 |
| 2016-02-05 13:30:00 | AAPL | Stock | 23.795 | 23.805 | 23.6548 | 23.6825 | 9065280.0 |
| 2016-02-05 14:00:00 | AAPL | Stock | 23.6802 | 23.73 | 23.5425 | 23.55 | 10988240.0 |
| 2016-02-05 14:30:00 | AAPL | Stock | 23.5475 | 23.5975 | 23.5025 | 23.5525 | 11505056.0 |
| 2016-02-05 15:00:00 | AAPL | Stock | 23.554 | 23.6775 | 23.49 | 23.6175 | 14187360.0 |
| 2016-02-05 15:30:00 | AAPL | Stock | 23.6175 | 23.6175 | 23.4225 | 23.5025 | 25303784.0 |
| 2016-02-05 16:00:00 | AAPL | Stock | 23.505 | 23.5375 | 23.4875 | 23.4975 | 7962924.0 |
| 2016-02-05 16:30:00 | AAPL | Stock | 23.505 | 23.51 | 23.4975 | 23.5 | 87376.0 |
| 2016-02-05 17:00:00 | AAPL | Stock | 23.5 | 23.51 | 23.49 | 23.49 | 68696.0 |
| 2016-02-05 17:30:00 | AAPL | Stock | 23.49 | 23.4975 | 23.4875 | 23.4925 | 38464.0 |
| 2016-02-05 18:00:00 | AAPL | Stock | 23.4975 | 23.4975 | 23.475 | 23.4775 | 19472.0 |
| 2016-02-05 18:30:00 | AAPL | Stock | 23.4875 | 23.4875 | 23.475 | 23.4775 | 7540.0 |
| 2016-02-05 19:00:00 | AAPL | Stock | 23.4775 | 23.4875 | 23.4775 | 23.48 | 7660.0 |
| 2016-02-05 19:30:00 | AAPL | Stock | 23.485 | 23.4875 | 23.4675 | 23.4875 | 52036.0 |
| 2016-02-05 07:00:00 | MSFT | Stock | 51.9 | 51.9 | 51.79 | 51.79 | 1200.0 |
| 2016-02-05 07:30:00 | MSFT | Stock | 51.82 | 51.82 | 51.82 | 51.82 | 200.0 |
| 2016-02-05 08:00:00 | MSFT | Stock | 51.87 | 51.87 | 51.75 | 51.87 | 1311.0 |
| 2016-02-05 08:30:00 | MSFT | Stock | 51.76 | 52.0 | 51.68 | 51.8 | 45840.0 |
| 2016-02-05 09:00:00 | MSFT | Stock | 51.75 | 51.95 | 51.71 | 51.95 | 16265.0 |
| 2016-02-05 09:30:00 | MSFT | Stock | 51.95 | 52.0 | 51.41 | 51.48 | 5777730.0 |
| 2016-02-05 10:00:00 | MSFT | Stock | 51.48 | 51.75 | 51.25 | 51.3 | 3165676.0 |
| 2016-02-05 10:30:00 | MSFT | Stock | 51.3 | 51.42 | 50.87 | 50.91 | 2739172.0 |
| 2016-02-05 11:00:00 | MSFT | Stock | 50.905 | 50.975 | 50.295 | 50.58 | 3146830.0 |
| 2016-02-05 11:30:00 | MSFT | Stock | 50.575 | 50.84 | 50.46 | 50.82 | 2709132.0 |
| 2016-02-05 12:00:00 | MSFT | Stock | 50.82 | 50.87 | 50.59 | 50.715 | 2583539.0 |
| 2016-02-05 12:30:00 | MSFT | Stock | 50.71 | 50.82 | 50.39 | 50.56 | 2391578.0 |
| 2016-02-05 13:00:00 | MSFT | Stock | 50.56 | 50.56 | 50.29 | 50.43 | 2076287.0 |
| 2016-02-05 13:30:00 | MSFT | Stock | 50.434 | 50.46 | 50.035 | 50.065 | 3014283.0 |
| 2016-02-05 14:00:00 | MSFT | Stock | 50.065 | 50.19 | 49.7 | 49.726 | 5347280.0 |
| 2016-02-05 14:30:00 | MSFT | Stock | 49.73 | 49.96 | 49.66 | 49.725 | 4479295.0 |
| 2016-02-05 15:00:00 | MSFT | Stock | 49.73 | 50.23 | 49.56 | 50.16 | 6828976.0 |
| 2016-02-05 15:30:00 | MSFT | Stock | 50.16 | 50.19 | 49.87 | 50.16 | 8892136.0 |
| 2016-02-05 16:00:00 | MSFT | Stock | 50.16 | 50.26 | 50.15 | 50.21 | 3335195.0 |
> showing 50 of 81,249 rows — these rows as CSV