PREVIEW / stock_5min / 2015-07-09
file: by_date/stock_5min/2015/2015-07-09.parquet size: 5.5 MB rows: 363,904 symbols: 3,474
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-07-09 04:00:00 | AAPL | Stock | 30.86 | 30.9375 | 30.86 | 30.9 | 6600.0 |
| 2015-07-09 04:10:00 | AAPL | Stock | 30.9175 | 30.9175 | 30.9175 | 30.9175 | 8800.0 |
| 2015-07-09 04:15:00 | AAPL | Stock | 30.97 | 30.97 | 30.945 | 30.9625 | 4600.0 |
| 2015-07-09 04:20:00 | AAPL | Stock | 30.9625 | 30.975 | 30.9 | 30.9 | 8212.0 |
| 2015-07-09 04:30:00 | AAPL | Stock | 30.945 | 30.945 | 30.945 | 30.945 | 800.0 |
| 2015-07-09 04:35:00 | AAPL | Stock | 30.9125 | 30.9125 | 30.9125 | 30.9125 | 1780.0 |
| 2015-07-09 04:40:00 | AAPL | Stock | 30.9 | 30.9 | 30.9 | 30.9 | 1200.0 |
| 2015-07-09 04:45:00 | AAPL | Stock | 30.945 | 30.945 | 30.945 | 30.945 | 800.0 |
| 2015-07-09 04:50:00 | AAPL | Stock | 30.93 | 30.93 | 30.93 | 30.93 | 1600.0 |
| 2015-07-09 04:55:00 | AAPL | Stock | 30.9075 | 30.9075 | 30.9075 | 30.9075 | 1600.0 |
| 2015-07-09 05:00:00 | AAPL | Stock | 30.9075 | 30.9075 | 30.9075 | 30.9075 | 960.0 |
| 2015-07-09 05:05:00 | AAPL | Stock | 30.895 | 30.9075 | 30.895 | 30.895 | 2664.0 |
| 2015-07-09 05:10:00 | AAPL | Stock | 30.895 | 30.895 | 30.895 | 30.895 | 2096.0 |
| 2015-07-09 05:20:00 | AAPL | Stock | 30.9225 | 30.9225 | 30.9225 | 30.9225 | 800.0 |
| 2015-07-09 05:30:00 | AAPL | Stock | 30.9575 | 30.9625 | 30.9575 | 30.9625 | 17984.0 |
| 2015-07-09 05:35:00 | AAPL | Stock | 30.9625 | 30.9625 | 30.9625 | 30.9625 | 6400.0 |
| 2015-07-09 05:40:00 | AAPL | Stock | 30.9625 | 30.975 | 30.9625 | 30.975 | 10624.0 |
| 2015-07-09 05:45:00 | AAPL | Stock | 30.97 | 30.975 | 30.9625 | 30.9625 | 8400.0 |
| 2015-07-09 05:50:00 | AAPL | Stock | 30.965 | 30.965 | 30.965 | 30.965 | 3940.0 |
| 2015-07-09 06:05:00 | AAPL | Stock | 30.96 | 30.96 | 30.96 | 30.96 | 3600.0 |
| 2015-07-09 06:10:00 | AAPL | Stock | 30.95 | 30.95 | 30.95 | 30.95 | 2236.0 |
| 2015-07-09 06:15:00 | AAPL | Stock | 30.95 | 30.95 | 30.95 | 30.95 | 3600.0 |
| 2015-07-09 06:20:00 | AAPL | Stock | 30.9575 | 30.9575 | 30.9575 | 30.9575 | 1100.0 |
| 2015-07-09 06:25:00 | AAPL | Stock | 30.955 | 30.955 | 30.9475 | 30.9525 | 5396.0 |
| 2015-07-09 06:30:00 | AAPL | Stock | 30.9525 | 30.955 | 30.9525 | 30.955 | 2000.0 |
| 2015-07-09 06:35:00 | AAPL | Stock | 30.955 | 30.955 | 30.955 | 30.955 | 1360.0 |
| 2015-07-09 06:40:00 | AAPL | Stock | 30.955 | 30.9725 | 30.955 | 30.9725 | 18420.0 |
| 2015-07-09 06:45:00 | AAPL | Stock | 30.9725 | 31.0 | 30.9725 | 31.0 | 38800.0 |
| 2015-07-09 06:50:00 | AAPL | Stock | 30.9975 | 31.0 | 30.9775 | 30.9775 | 7880.0 |
| 2015-07-09 06:55:00 | AAPL | Stock | 30.975 | 30.975 | 30.965 | 30.9725 | 34772.0 |
| 2015-07-09 07:00:00 | AAPL | Stock | 30.97 | 30.9925 | 30.945 | 30.9475 | 81644.0 |
| 2015-07-09 07:05:00 | AAPL | Stock | 30.9475 | 31.0275 | 30.9475 | 31.025 | 51136.0 |
| 2015-07-09 07:10:00 | AAPL | Stock | 31.025 | 31.0925 | 31.0025 | 31.0075 | 16456.0 |
| 2015-07-09 07:15:00 | AAPL | Stock | 31.0175 | 31.025 | 30.9875 | 31.0125 | 41108.0 |
| 2015-07-09 07:20:00 | AAPL | Stock | 31.0125 | 31.035 | 31.0 | 31.0025 | 14096.0 |
| 2015-07-09 07:25:00 | AAPL | Stock | 31.0 | 31.0 | 30.975 | 30.975 | 33324.0 |
| 2015-07-09 07:30:00 | AAPL | Stock | 30.965 | 30.985 | 30.95 | 30.9525 | 61948.0 |
| 2015-07-09 07:35:00 | AAPL | Stock | 30.9525 | 30.9625 | 30.945 | 30.95 | 38108.0 |
| 2015-07-09 07:40:00 | AAPL | Stock | 30.95 | 30.95 | 30.9275 | 30.945 | 41928.0 |
| 2015-07-09 07:45:00 | AAPL | Stock | 30.94 | 30.94 | 30.9375 | 30.9375 | 5100.0 |
| 2015-07-09 07:50:00 | AAPL | Stock | 30.9375 | 30.9375 | 30.92 | 30.92 | 10580.0 |
| 2015-07-09 07:55:00 | AAPL | Stock | 30.9375 | 30.9875 | 30.9375 | 30.9875 | 40960.0 |
| 2015-07-09 08:00:00 | AAPL | Stock | 30.995 | 31.05 | 30.9375 | 31.035 | 317104.0 |
| 2015-07-09 08:05:00 | AAPL | Stock | 30.9525 | 30.9525 | 30.945 | 30.945 | 42480.0 |
| 2015-07-09 08:10:00 | AAPL | Stock | 30.95 | 30.9525 | 30.925 | 30.9425 | 99852.0 |
| 2015-07-09 08:15:00 | AAPL | Stock | 30.9425 | 30.965 | 30.9325 | 30.965 | 125596.0 |
| 2015-07-09 08:20:00 | AAPL | Stock | 30.965 | 30.9675 | 30.9475 | 30.9675 | 75376.0 |
| 2015-07-09 08:25:00 | AAPL | Stock | 30.96 | 30.9625 | 30.9425 | 30.95 | 39436.0 |
| 2015-07-09 08:30:00 | AAPL | Stock | 30.95 | 30.9675 | 30.95 | 30.965 | 68100.0 |
| 2015-07-09 08:35:00 | AAPL | Stock | 30.965 | 30.98 | 30.9625 | 30.9625 | 67212.0 |
> showing 50 of 363,904 rows — these rows as CSV