PREVIEW / stock_5min / 2015-03-02
file: by_date/stock_5min/2015/2015-03-02.parquet size: 5.6 MB rows: 369,693 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.275 | 32.005 | 32.2 | 28752.0 |
| 2015-03-02 04:05:00 | AAPL | Stock | 32.2375 | 32.2375 | 31.75 | 32.0775 | 13816.0 |
| 2015-03-02 04:10:00 | AAPL | Stock | 32.0875 | 32.1525 | 32.04 | 32.1525 | 19200.0 |
| 2015-03-02 04:15:00 | AAPL | Stock | 32.22 | 32.225 | 32.2125 | 32.225 | 6800.0 |
| 2015-03-02 04:20:00 | AAPL | Stock | 32.17 | 32.225 | 32.17 | 32.185 | 11228.0 |
| 2015-03-02 04:25:00 | AAPL | Stock | 32.225 | 32.3075 | 32.225 | 32.3075 | 2400.0 |
| 2015-03-02 04:30:00 | AAPL | Stock | 32.3075 | 32.31 | 32.3075 | 32.31 | 4800.0 |
| 2015-03-02 04:35:00 | AAPL | Stock | 32.275 | 32.275 | 32.275 | 32.275 | 400.0 |
| 2015-03-02 04:40:00 | AAPL | Stock | 32.275 | 32.31 | 32.275 | 32.31 | 4392.0 |
| 2015-03-02 04:45:00 | AAPL | Stock | 32.31 | 32.31 | 32.31 | 32.31 | 400.0 |
| 2015-03-02 04:50:00 | AAPL | Stock | 32.3225 | 32.375 | 32.32 | 32.375 | 38392.0 |
| 2015-03-02 05:00:00 | AAPL | Stock | 32.315 | 32.315 | 32.315 | 32.315 | 400.0 |
| 2015-03-02 05:10:00 | AAPL | Stock | 32.275 | 32.315 | 32.275 | 32.3125 | 8400.0 |
| 2015-03-02 05:20:00 | AAPL | Stock | 32.275 | 32.315 | 32.275 | 32.275 | 8260.0 |
| 2015-03-02 05:25:00 | AAPL | Stock | 32.305 | 32.315 | 32.305 | 32.315 | 17192.0 |
| 2015-03-02 05:30:00 | AAPL | Stock | 32.3 | 32.3 | 32.2975 | 32.3 | 15500.0 |
| 2015-03-02 05:40:00 | AAPL | Stock | 32.32 | 32.32 | 32.32 | 32.32 | 400.0 |
| 2015-03-02 05:45:00 | AAPL | Stock | 32.32 | 32.32 | 32.32 | 32.32 | 400.0 |
| 2015-03-02 05:50:00 | AAPL | Stock | 32.32 | 32.325 | 32.32 | 32.325 | 2000.0 |
| 2015-03-02 05:55:00 | AAPL | Stock | 32.3125 | 32.325 | 32.3125 | 32.325 | 2400.0 |
| 2015-03-02 06:00:00 | AAPL | Stock | 32.3125 | 32.325 | 32.3025 | 32.31 | 7120.0 |
| 2015-03-02 06:05:00 | AAPL | Stock | 32.3075 | 32.3175 | 32.3 | 32.3 | 8520.0 |
| 2015-03-02 06:10:00 | AAPL | Stock | 32.3 | 32.3 | 32.275 | 32.275 | 6000.0 |
| 2015-03-02 06:15:00 | AAPL | Stock | 32.275 | 32.275 | 32.2725 | 32.275 | 8000.0 |
| 2015-03-02 06:20:00 | AAPL | Stock | 32.295 | 32.3375 | 32.295 | 32.305 | 55248.0 |
| 2015-03-02 06:25:00 | AAPL | Stock | 32.3125 | 32.3125 | 32.27 | 32.2975 | 13740.0 |
| 2015-03-02 06:30:00 | AAPL | Stock | 32.275 | 32.275 | 32.25 | 32.275 | 12848.0 |
| 2015-03-02 06:35:00 | AAPL | Stock | 32.2525 | 32.2625 | 32.2275 | 32.2275 | 8880.0 |
| 2015-03-02 06:40:00 | AAPL | Stock | 32.2475 | 32.25 | 32.2 | 32.2025 | 16508.0 |
| 2015-03-02 06:45:00 | AAPL | Stock | 32.2 | 32.2125 | 32.19 | 32.2 | 18000.0 |
| 2015-03-02 06:50:00 | AAPL | Stock | 32.245 | 32.245 | 32.245 | 32.245 | 800.0 |
| 2015-03-02 06:55:00 | AAPL | Stock | 32.23 | 32.23 | 32.2225 | 32.2225 | 2400.0 |
| 2015-03-02 07:00:00 | AAPL | Stock | 32.2225 | 32.2525 | 32.205 | 32.2525 | 23360.0 |
| 2015-03-02 07:05:00 | AAPL | Stock | 32.2425 | 32.2425 | 32.2375 | 32.2425 | 3304.0 |
| 2015-03-02 07:10:00 | AAPL | Stock | 32.25 | 32.275 | 32.25 | 32.275 | 31260.0 |
| 2015-03-02 07:15:00 | AAPL | Stock | 32.275 | 32.295 | 32.2625 | 32.295 | 21336.0 |
| 2015-03-02 07:20:00 | AAPL | Stock | 32.2875 | 32.325 | 32.2875 | 32.325 | 22372.0 |
| 2015-03-02 07:25:00 | AAPL | Stock | 32.3275 | 32.335 | 32.3125 | 32.3175 | 18084.0 |
| 2015-03-02 07:30:00 | AAPL | Stock | 32.3 | 32.3 | 32.29 | 32.3 | 6000.0 |
| 2015-03-02 07:35:00 | AAPL | Stock | 32.2925 | 32.2925 | 32.2525 | 32.2525 | 12400.0 |
| 2015-03-02 07:40:00 | AAPL | Stock | 32.2525 | 32.275 | 32.25 | 32.2675 | 10340.0 |
| 2015-03-02 07:45:00 | AAPL | Stock | 32.26 | 32.265 | 32.24 | 32.24 | 18840.0 |
| 2015-03-02 07:50:00 | AAPL | Stock | 32.2375 | 32.26 | 32.2225 | 32.26 | 26544.0 |
| 2015-03-02 07:55:00 | AAPL | Stock | 32.2425 | 32.255 | 32.225 | 32.255 | 37104.0 |
| 2015-03-02 08:00:00 | AAPL | Stock | 32.25 | 32.3075 | 32.115 | 32.2348 | 297992.0 |
| 2015-03-02 08:05:00 | AAPL | Stock | 32.2348 | 32.235 | 32.205 | 32.2125 | 62120.0 |
| 2015-03-02 08:10:00 | AAPL | Stock | 32.21 | 32.26 | 32.21 | 32.2425 | 80348.0 |
| 2015-03-02 08:15:00 | AAPL | Stock | 32.25 | 32.2525 | 32.2425 | 32.25 | 65512.0 |
| 2015-03-02 08:20:00 | AAPL | Stock | 32.25 | 32.2675 | 32.25 | 32.255 | 63112.0 |
| 2015-03-02 08:25:00 | AAPL | Stock | 32.2625 | 32.265 | 32.25 | 32.2525 | 38544.0 |
> showing 50 of 369,693 rows — these rows as CSV