PREVIEW / stock_5min / 2015-12-02
file: by_date/stock_5min/2015/2015-12-02.parquet size: 5.5 MB rows: 363,679 symbols: 3,445
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-12-02 04:00:00 | AAPL | Stock | 29.3425 | 29.3425 | 29.3425 | 29.3425 | 400.0 |
| 2015-12-02 04:30:00 | AAPL | Stock | 29.3725 | 29.3725 | 29.3725 | 29.3725 | 1200.0 |
| 2015-12-02 04:45:00 | AAPL | Stock | 29.3725 | 29.3725 | 29.3725 | 29.3725 | 400.0 |
| 2015-12-02 04:55:00 | AAPL | Stock | 29.3725 | 29.3725 | 29.3725 | 29.3725 | 400.0 |
| 2015-12-02 05:20:00 | AAPL | Stock | 29.365 | 29.365 | 29.365 | 29.365 | 400.0 |
| 2015-12-02 05:40:00 | AAPL | Stock | 29.35 | 29.35 | 29.35 | 29.35 | 400.0 |
| 2015-12-02 06:05:00 | AAPL | Stock | 29.35 | 29.3725 | 29.35 | 29.3725 | 1680.0 |
| 2015-12-02 06:10:00 | AAPL | Stock | 29.35 | 29.35 | 29.35 | 29.35 | 400.0 |
| 2015-12-02 06:20:00 | AAPL | Stock | 29.35 | 29.3625 | 29.35 | 29.3625 | 2752.0 |
| 2015-12-02 06:25:00 | AAPL | Stock | 29.37 | 29.37 | 29.37 | 29.37 | 1372.0 |
| 2015-12-02 06:35:00 | AAPL | Stock | 29.3625 | 29.3625 | 29.3625 | 29.3625 | 1200.0 |
| 2015-12-02 06:45:00 | AAPL | Stock | 29.3625 | 29.3625 | 29.3625 | 29.3625 | 800.0 |
| 2015-12-02 06:50:00 | AAPL | Stock | 29.35 | 29.35 | 29.35 | 29.35 | 400.0 |
| 2015-12-02 06:55:00 | AAPL | Stock | 29.3375 | 29.35 | 29.335 | 29.335 | 2432.0 |
| 2015-12-02 07:00:00 | AAPL | Stock | 29.335 | 29.34 | 29.33 | 29.34 | 3668.0 |
| 2015-12-02 07:05:00 | AAPL | Stock | 29.335 | 29.335 | 29.3125 | 29.32 | 2000.0 |
| 2015-12-02 07:10:00 | AAPL | Stock | 29.3125 | 29.3125 | 29.305 | 29.3075 | 12400.0 |
| 2015-12-02 07:20:00 | AAPL | Stock | 29.2975 | 29.2975 | 29.2975 | 29.2975 | 2800.0 |
| 2015-12-02 07:25:00 | AAPL | Stock | 29.2975 | 29.31 | 29.2975 | 29.31 | 2000.0 |
| 2015-12-02 07:30:00 | AAPL | Stock | 29.31 | 29.3125 | 29.3 | 29.3125 | 2200.0 |
| 2015-12-02 07:35:00 | AAPL | Stock | 29.3125 | 29.3125 | 29.2925 | 29.2925 | 6400.0 |
| 2015-12-02 07:40:00 | AAPL | Stock | 29.2975 | 29.2975 | 29.2975 | 29.2975 | 400.0 |
| 2015-12-02 07:45:00 | AAPL | Stock | 29.2975 | 29.2975 | 29.2975 | 29.2975 | 1200.0 |
| 2015-12-02 07:50:00 | AAPL | Stock | 29.3125 | 29.3125 | 29.3 | 29.3 | 2080.0 |
| 2015-12-02 07:55:00 | AAPL | Stock | 29.3 | 29.3 | 29.2875 | 29.29 | 23168.0 |
| 2015-12-02 08:00:00 | AAPL | Stock | 29.3 | 29.3125 | 29.2875 | 29.29 | 25508.0 |
| 2015-12-02 08:05:00 | AAPL | Stock | 29.295 | 29.295 | 29.275 | 29.275 | 41728.0 |
| 2015-12-02 08:10:00 | AAPL | Stock | 29.2775 | 29.2775 | 29.265 | 29.2675 | 12172.0 |
| 2015-12-02 08:15:00 | AAPL | Stock | 29.265 | 29.2825 | 29.2625 | 29.275 | 21696.0 |
| 2015-12-02 08:20:00 | AAPL | Stock | 29.2675 | 29.2825 | 29.2675 | 29.2825 | 7900.0 |
| 2015-12-02 08:25:00 | AAPL | Stock | 29.2675 | 29.27 | 29.2625 | 29.265 | 16780.0 |
| 2015-12-02 08:30:00 | AAPL | Stock | 29.27 | 29.2725 | 29.2425 | 29.2425 | 16452.0 |
| 2015-12-02 08:35:00 | AAPL | Stock | 29.2425 | 29.2475 | 29.225 | 29.225 | 47680.0 |
| 2015-12-02 08:40:00 | AAPL | Stock | 29.23 | 29.2475 | 29.23 | 29.2475 | 36840.0 |
| 2015-12-02 08:45:00 | AAPL | Stock | 29.2375 | 29.25 | 29.2375 | 29.25 | 11096.0 |
| 2015-12-02 08:50:00 | AAPL | Stock | 29.2625 | 29.2625 | 29.2375 | 29.25 | 27980.0 |
| 2015-12-02 08:55:00 | AAPL | Stock | 29.255 | 29.335 | 29.2425 | 29.2425 | 17800.0 |
| 2015-12-02 09:00:00 | AAPL | Stock | 29.2475 | 29.2475 | 29.235 | 29.2475 | 16640.0 |
| 2015-12-02 09:05:00 | AAPL | Stock | 29.245 | 29.2525 | 29.24 | 29.2525 | 43148.0 |
| 2015-12-02 09:10:00 | AAPL | Stock | 29.255 | 29.275 | 29.255 | 29.275 | 8800.0 |
| 2015-12-02 09:15:00 | AAPL | Stock | 29.2725 | 29.2725 | 29.2575 | 29.2575 | 23224.0 |
| 2015-12-02 09:20:00 | AAPL | Stock | 29.255 | 29.28 | 29.2525 | 29.275 | 20180.0 |
| 2015-12-02 09:25:00 | AAPL | Stock | 29.2625 | 29.2625 | 29.25 | 29.2525 | 27600.0 |
| 2015-12-02 09:30:00 | AAPL | Stock | 29.2625 | 29.3325 | 29.25 | 29.2825 | 3252204.0 |
| 2015-12-02 09:35:00 | AAPL | Stock | 29.2825 | 29.3925 | 29.2825 | 29.3825 | 2806232.0 |
| 2015-12-02 09:40:00 | AAPL | Stock | 29.3825 | 29.45 | 29.3725 | 29.415 | 3288248.0 |
| 2015-12-02 09:45:00 | AAPL | Stock | 29.415 | 29.4332 | 29.4 | 29.4175 | 2049372.0 |
| 2015-12-02 09:50:00 | AAPL | Stock | 29.42 | 29.4375 | 29.3875 | 29.4045 | 1852068.0 |
| 2015-12-02 09:55:00 | AAPL | Stock | 29.405 | 29.4175 | 29.3775 | 29.405 | 1398964.0 |
| 2015-12-02 10:00:00 | AAPL | Stock | 29.405 | 29.4375 | 29.4 | 29.4272 | 2095744.0 |
> showing 50 of 363,679 rows — these rows as CSV