PREVIEW / stock_5min / 2015-02-24
file: by_date/stock_5min/2015/2015-02-24.parquet size: 5.5 MB rows: 359,925 symbols: 3,516
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-02-24 04:00:00 | AAPL | Stock | 33.33 | 33.415 | 33.33 | 33.415 | 2640.0 |
| 2015-02-24 04:05:00 | AAPL | Stock | 33.3725 | 33.375 | 33.37 | 33.375 | 3640.0 |
| 2015-02-24 04:10:00 | AAPL | Stock | 33.37 | 33.37 | 33.37 | 33.37 | 2400.0 |
| 2015-02-24 04:15:00 | AAPL | Stock | 33.3575 | 33.3575 | 33.325 | 33.35 | 8000.0 |
| 2015-02-24 04:20:00 | AAPL | Stock | 33.3475 | 33.3475 | 33.34 | 33.34 | 1200.0 |
| 2015-02-24 04:25:00 | AAPL | Stock | 33.34 | 33.34 | 33.325 | 33.325 | 1200.0 |
| 2015-02-24 04:30:00 | AAPL | Stock | 33.3475 | 33.3475 | 33.3075 | 33.3475 | 14000.0 |
| 2015-02-24 04:35:00 | AAPL | Stock | 33.35 | 33.35 | 33.35 | 33.35 | 2800.0 |
| 2015-02-24 04:40:00 | AAPL | Stock | 33.3625 | 33.3625 | 33.36 | 33.3625 | 9400.0 |
| 2015-02-24 04:45:00 | AAPL | Stock | 33.36 | 33.3675 | 33.3475 | 33.3675 | 8408.0 |
| 2015-02-24 04:50:00 | AAPL | Stock | 33.365 | 33.375 | 33.3 | 33.35 | 25116.0 |
| 2015-02-24 04:55:00 | AAPL | Stock | 33.3725 | 33.375 | 33.275 | 33.32 | 46488.0 |
| 2015-02-24 05:05:00 | AAPL | Stock | 33.3225 | 33.3225 | 33.3225 | 33.3225 | 1204.0 |
| 2015-02-24 05:10:00 | AAPL | Stock | 33.3325 | 33.3325 | 33.3325 | 33.3325 | 1860.0 |
| 2015-02-24 05:15:00 | AAPL | Stock | 33.32 | 33.375 | 33.3075 | 33.375 | 22424.0 |
| 2015-02-24 05:20:00 | AAPL | Stock | 33.375 | 33.375 | 33.3375 | 33.35 | 45624.0 |
| 2015-02-24 05:25:00 | AAPL | Stock | 33.34 | 33.3725 | 33.3375 | 33.3725 | 7824.0 |
| 2015-02-24 05:35:00 | AAPL | Stock | 33.365 | 33.365 | 33.3375 | 33.3375 | 6156.0 |
| 2015-02-24 05:50:00 | AAPL | Stock | 33.325 | 33.325 | 33.325 | 33.325 | 10000.0 |
| 2015-02-24 05:55:00 | AAPL | Stock | 33.3125 | 33.3125 | 33.305 | 33.305 | 6400.0 |
| 2015-02-24 06:00:00 | AAPL | Stock | 33.3125 | 33.325 | 33.275 | 33.2925 | 37128.0 |
| 2015-02-24 06:05:00 | AAPL | Stock | 33.2925 | 33.2925 | 33.2925 | 33.2925 | 400.0 |
| 2015-02-24 06:10:00 | AAPL | Stock | 33.3025 | 33.3025 | 33.28 | 33.28 | 972.0 |
| 2015-02-24 06:20:00 | AAPL | Stock | 33.3125 | 33.325 | 33.2775 | 33.2775 | 7772.0 |
| 2015-02-24 06:25:00 | AAPL | Stock | 33.3225 | 33.3225 | 33.3225 | 33.3225 | 400.0 |
| 2015-02-24 06:30:00 | AAPL | Stock | 33.2825 | 33.2825 | 33.2825 | 33.2825 | 2400.0 |
| 2015-02-24 06:35:00 | AAPL | Stock | 33.3225 | 33.3225 | 33.2875 | 33.2875 | 4400.0 |
| 2015-02-24 06:40:00 | AAPL | Stock | 33.3 | 33.3 | 33.28 | 33.28 | 16248.0 |
| 2015-02-24 06:45:00 | AAPL | Stock | 33.3 | 33.3625 | 33.3 | 33.3625 | 84344.0 |
| 2015-02-24 06:50:00 | AAPL | Stock | 33.35 | 33.3575 | 33.2875 | 33.2875 | 34800.0 |
| 2015-02-24 06:55:00 | AAPL | Stock | 33.2975 | 33.3 | 33.2975 | 33.2975 | 40060.0 |
| 2015-02-24 07:00:00 | AAPL | Stock | 33.285 | 33.29 | 33.25 | 33.275 | 52988.0 |
| 2015-02-24 07:05:00 | AAPL | Stock | 33.275 | 33.275 | 33.2625 | 33.2675 | 19004.0 |
| 2015-02-24 07:10:00 | AAPL | Stock | 33.2675 | 33.2725 | 33.265 | 33.265 | 17236.0 |
| 2015-02-24 07:15:00 | AAPL | Stock | 33.265 | 33.275 | 33.2375 | 33.24 | 134604.0 |
| 2015-02-24 07:20:00 | AAPL | Stock | 33.2375 | 33.2625 | 33.2275 | 33.2625 | 51604.0 |
| 2015-02-24 07:25:00 | AAPL | Stock | 33.2725 | 33.2725 | 33.2575 | 33.2725 | 28212.0 |
| 2015-02-24 07:30:00 | AAPL | Stock | 33.2725 | 33.275 | 33.2725 | 33.2725 | 25756.0 |
| 2015-02-24 07:35:00 | AAPL | Stock | 33.265 | 33.275 | 33.255 | 33.2725 | 15172.0 |
| 2015-02-24 07:40:00 | AAPL | Stock | 33.26 | 33.26 | 33.255 | 33.255 | 8400.0 |
| 2015-02-24 07:45:00 | AAPL | Stock | 33.255 | 33.255 | 33.2375 | 33.25 | 56576.0 |
| 2015-02-24 07:50:00 | AAPL | Stock | 33.24 | 33.27 | 33.24 | 33.25 | 52408.0 |
| 2015-02-24 07:55:00 | AAPL | Stock | 33.25 | 33.255 | 33.25 | 33.25 | 7600.0 |
| 2015-02-24 08:00:00 | AAPL | Stock | 33.2525 | 33.3 | 33.15 | 33.2475 | 403744.0 |
| 2015-02-24 08:05:00 | AAPL | Stock | 33.245 | 33.2475 | 33.2075 | 33.225 | 143712.0 |
| 2015-02-24 08:10:00 | AAPL | Stock | 33.2225 | 33.225 | 33.175 | 33.175 | 124368.0 |
| 2015-02-24 08:15:00 | AAPL | Stock | 33.1875 | 33.1875 | 33.09 | 33.11 | 316320.0 |
| 2015-02-24 08:20:00 | AAPL | Stock | 33.1125 | 33.1375 | 33.09 | 33.1225 | 226600.0 |
| 2015-02-24 08:25:00 | AAPL | Stock | 33.1175 | 33.15 | 33.1175 | 33.1375 | 126336.0 |
| 2015-02-24 08:30:00 | AAPL | Stock | 33.145 | 33.16 | 33.1375 | 33.1575 | 85292.0 |
> showing 50 of 359,925 rows — these rows as CSV