PREVIEW / stock_30min / 2015-03-02
file: by_date/stock_30min/2015/2015-03-02.parquet size: 1.7 MB rows: 86,518 symbols: 3,533
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-03-02 04:00:00 | AAPL | Stock | 32.175 | 32.3075 | 31.75 | 32.3075 | 82196.0 |
| 2015-03-02 04:30:00 | AAPL | Stock | 32.3075 | 32.375 | 32.275 | 32.375 | 48384.0 |
| 2015-03-02 05:00:00 | AAPL | Stock | 32.315 | 32.315 | 32.275 | 32.315 | 34252.0 |
| 2015-03-02 05:30:00 | AAPL | Stock | 32.3 | 32.325 | 32.2975 | 32.325 | 20700.0 |
| 2015-03-02 06:00:00 | AAPL | Stock | 32.3125 | 32.3375 | 32.27 | 32.2975 | 98628.0 |
| 2015-03-02 06:30:00 | AAPL | Stock | 32.275 | 32.275 | 32.19 | 32.2225 | 59436.0 |
| 2015-03-02 07:00:00 | AAPL | Stock | 32.2225 | 32.335 | 32.205 | 32.3175 | 119716.0 |
| 2015-03-02 07:30:00 | AAPL | Stock | 32.3 | 32.3 | 32.2225 | 32.255 | 111228.0 |
| 2015-03-02 08:00:00 | AAPL | Stock | 32.25 | 32.3075 | 32.115 | 32.2525 | 607628.0 |
| 2015-03-02 08:30:00 | AAPL | Stock | 32.255 | 32.26 | 32.2275 | 32.2475 | 203708.0 |
| 2015-03-02 09:00:00 | AAPL | Stock | 32.2475 | 32.335 | 32.1925 | 32.31 | 565076.0 |
| 2015-03-02 09:30:00 | AAPL | Stock | 32.31 | 32.515 | 32.255 | 32.4925 | 31736800.0 |
| 2015-03-02 10:00:00 | AAPL | Stock | 32.4875 | 32.57 | 32.425 | 32.4875 | 16714616.0 |
| 2015-03-02 10:30:00 | AAPL | Stock | 32.4875 | 32.5025 | 32.3 | 32.36 | 13683160.0 |
| 2015-03-02 11:00:00 | AAPL | Stock | 32.36 | 32.4 | 32.2825 | 32.3775 | 9527492.0 |
| 2015-03-02 11:30:00 | AAPL | Stock | 32.3787 | 32.4475 | 32.3625 | 32.3925 | 6894448.0 |
| 2015-03-02 12:00:00 | AAPL | Stock | 32.3925 | 32.4125 | 32.2775 | 32.3025 | 6990420.0 |
| 2015-03-02 12:30:00 | AAPL | Stock | 32.3025 | 32.3125 | 32.1 | 32.2238 | 14522316.0 |
| 2015-03-02 13:00:00 | AAPL | Stock | 32.2225 | 32.225 | 32.075 | 32.1425 | 8103748.0 |
| 2015-03-02 13:30:00 | AAPL | Stock | 32.1425 | 32.2422 | 32.0975 | 32.2288 | 8891552.0 |
| 2015-03-02 14:00:00 | AAPL | Stock | 32.2275 | 32.2288 | 32.12 | 32.1625 | 8894592.0 |
| 2015-03-02 14:30:00 | AAPL | Stock | 32.1625 | 32.215 | 32.0775 | 32.1875 | 9582928.0 |
| 2015-03-02 15:00:00 | AAPL | Stock | 32.19 | 32.2725 | 32.1775 | 32.2725 | 10165896.0 |
| 2015-03-02 15:30:00 | AAPL | Stock | 32.27 | 32.2975 | 32.205 | 32.27 | 19389140.0 |
| 2015-03-02 16:00:00 | AAPL | Stock | 32.2725 | 32.3485 | 32.22 | 32.2575 | 15753224.0 |
| 2015-03-02 16:30:00 | AAPL | Stock | 32.3192 | 32.3192 | 32.25 | 32.2575 | 317488.0 |
| 2015-03-02 17:00:00 | AAPL | Stock | 32.255 | 32.2575 | 32.2375 | 32.24 | 45668.0 |
| 2015-03-02 17:30:00 | AAPL | Stock | 32.25 | 32.2575 | 32.2425 | 32.245 | 19060.0 |
| 2015-03-02 18:00:00 | AAPL | Stock | 32.2725 | 32.2725 | 32.25 | 32.26 | 97524.0 |
| 2015-03-02 18:30:00 | AAPL | Stock | 32.26 | 32.26 | 32.25 | 32.25 | 18520.0 |
| 2015-03-02 19:00:00 | AAPL | Stock | 32.2525 | 32.2575 | 32.25 | 32.25 | 18904.0 |
| 2015-03-02 19:30:00 | AAPL | Stock | 32.2575 | 32.2575 | 32.24 | 32.25 | 50620.0 |
| 2015-03-02 04:30:00 | MSFT | Stock | 43.84 | 43.84 | 43.84 | 43.84 | 100.0 |
| 2015-03-02 05:00:00 | MSFT | Stock | 43.84 | 43.84 | 43.84 | 43.84 | 200.0 |
| 2015-03-02 05:30:00 | MSFT | Stock | 43.84 | 43.84 | 43.84 | 43.84 | 400.0 |
| 2015-03-02 06:00:00 | MSFT | Stock | 43.84 | 43.93 | 43.84 | 43.93 | 400.0 |
| 2015-03-02 06:30:00 | MSFT | Stock | 43.85 | 43.85 | 43.85 | 43.85 | 200.0 |
| 2015-03-02 07:30:00 | MSFT | Stock | 43.84 | 43.84 | 43.73 | 43.73 | 600.0 |
| 2015-03-02 08:00:00 | MSFT | Stock | 43.85 | 43.85 | 43.68 | 43.73 | 45183.0 |
| 2015-03-02 08:30:00 | MSFT | Stock | 43.75 | 43.85 | 43.73 | 43.78 | 21458.0 |
| 2015-03-02 09:00:00 | MSFT | Stock | 43.75 | 43.85 | 43.56 | 43.56 | 59439.0 |
| 2015-03-02 09:30:00 | MSFT | Stock | 43.67 | 43.97 | 43.55 | 43.91 | 3477984.0 |
| 2015-03-02 10:00:00 | MSFT | Stock | 43.91 | 44.06 | 43.845 | 44.03 | 2159534.0 |
| 2015-03-02 10:30:00 | MSFT | Stock | 44.03 | 44.08 | 43.97 | 44.01 | 1264748.0 |
| 2015-03-02 11:00:00 | MSFT | Stock | 44.015 | 44.18 | 43.95 | 44.12 | 1894457.0 |
| 2015-03-02 11:30:00 | MSFT | Stock | 44.127 | 44.19 | 44.08 | 44.08 | 1275031.0 |
| 2015-03-02 12:00:00 | MSFT | Stock | 44.087 | 44.16 | 44.01 | 44.035 | 1036520.0 |
| 2015-03-02 12:30:00 | MSFT | Stock | 44.035 | 44.06 | 43.96 | 43.99 | 1159808.0 |
| 2015-03-02 13:00:00 | MSFT | Stock | 43.99 | 43.996 | 43.84 | 43.84 | 1313110.0 |
| 2015-03-02 13:30:00 | MSFT | Stock | 43.844 | 43.9 | 43.84 | 43.865 | 994451.0 |
> showing 50 of 86,518 rows — these rows as CSV