PREVIEW / stock_5min / 2014-11-04
file: by_date/stock_5min/2014/2014-11-04.parquet size: 5.4 MB rows: 361,578 symbols: 3,535
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 |
|---|---|---|---|---|---|---|---|
| 2014-11-04 04:00:00 | AAPL | Stock | 27.4225 | 27.4375 | 27.4225 | 27.4375 | 9120.0 |
| 2014-11-04 04:05:00 | AAPL | Stock | 27.4625 | 27.4675 | 27.4625 | 27.4675 | 7280.0 |
| 2014-11-04 04:10:00 | AAPL | Stock | 27.4225 | 27.475 | 27.4225 | 27.475 | 4144.0 |
| 2014-11-04 04:15:00 | AAPL | Stock | 27.4725 | 27.475 | 27.425 | 27.425 | 6000.0 |
| 2014-11-04 04:25:00 | AAPL | Stock | 27.4625 | 27.4775 | 27.4625 | 27.4775 | 1600.0 |
| 2014-11-04 04:30:00 | AAPL | Stock | 27.475 | 27.475 | 27.475 | 27.475 | 2000.0 |
| 2014-11-04 04:35:00 | AAPL | Stock | 27.475 | 27.48 | 27.475 | 27.48 | 4456.0 |
| 2014-11-04 04:40:00 | AAPL | Stock | 27.4725 | 27.4725 | 27.45 | 27.45 | 4028.0 |
| 2014-11-04 04:50:00 | AAPL | Stock | 27.4275 | 27.4375 | 27.4275 | 27.4375 | 6800.0 |
| 2014-11-04 04:55:00 | AAPL | Stock | 27.4375 | 27.4375 | 27.4375 | 27.4375 | 2000.0 |
| 2014-11-04 05:00:00 | AAPL | Stock | 27.4375 | 27.4375 | 27.4275 | 27.4275 | 2800.0 |
| 2014-11-04 05:05:00 | AAPL | Stock | 27.4125 | 27.425 | 27.4125 | 27.425 | 4400.0 |
| 2014-11-04 05:10:00 | AAPL | Stock | 27.4125 | 27.4125 | 27.375 | 27.375 | 42700.0 |
| 2014-11-04 05:15:00 | AAPL | Stock | 27.375 | 27.375 | 27.365 | 27.365 | 6800.0 |
| 2014-11-04 05:20:00 | AAPL | Stock | 27.375 | 27.375 | 27.3625 | 27.3625 | 6152.0 |
| 2014-11-04 05:25:00 | AAPL | Stock | 27.365 | 27.365 | 27.36 | 27.365 | 10000.0 |
| 2014-11-04 05:30:00 | AAPL | Stock | 27.3625 | 27.375 | 27.3625 | 27.365 | 24168.0 |
| 2014-11-04 05:35:00 | AAPL | Stock | 27.3725 | 27.3725 | 27.3725 | 27.3725 | 800.0 |
| 2014-11-04 05:40:00 | AAPL | Stock | 27.3625 | 27.3625 | 27.33 | 27.3475 | 15200.0 |
| 2014-11-04 05:45:00 | AAPL | Stock | 27.3625 | 27.3625 | 27.35 | 27.3525 | 2268.0 |
| 2014-11-04 05:50:00 | AAPL | Stock | 27.325 | 27.375 | 27.325 | 27.375 | 4200.0 |
| 2014-11-04 05:55:00 | AAPL | Stock | 27.34 | 27.3525 | 27.325 | 27.3375 | 6048.0 |
| 2014-11-04 06:05:00 | AAPL | Stock | 27.3375 | 27.3375 | 27.3375 | 27.3375 | 800.0 |
| 2014-11-04 06:10:00 | AAPL | Stock | 27.34 | 27.34 | 27.34 | 27.34 | 400.0 |
| 2014-11-04 06:15:00 | AAPL | Stock | 27.33 | 27.33 | 27.33 | 27.33 | 428.0 |
| 2014-11-04 06:25:00 | AAPL | Stock | 27.3425 | 27.3425 | 27.3425 | 27.3425 | 400.0 |
| 2014-11-04 06:35:00 | AAPL | Stock | 27.35 | 27.3525 | 27.35 | 27.3525 | 904.0 |
| 2014-11-04 06:40:00 | AAPL | Stock | 27.34 | 27.345 | 27.335 | 27.345 | 2808.0 |
| 2014-11-04 06:50:00 | AAPL | Stock | 27.35 | 27.36 | 27.35 | 27.36 | 800.0 |
| 2014-11-04 06:55:00 | AAPL | Stock | 27.3625 | 27.3775 | 27.3625 | 27.375 | 8784.0 |
| 2014-11-04 07:00:00 | AAPL | Stock | 27.375 | 27.375 | 27.345 | 27.345 | 20460.0 |
| 2014-11-04 07:05:00 | AAPL | Stock | 27.35 | 27.3775 | 27.345 | 27.375 | 22312.0 |
| 2014-11-04 07:10:00 | AAPL | Stock | 27.375 | 27.3775 | 27.375 | 27.3775 | 5224.0 |
| 2014-11-04 07:20:00 | AAPL | Stock | 27.35 | 27.35 | 27.325 | 27.325 | 7364.0 |
| 2014-11-04 07:25:00 | AAPL | Stock | 27.33 | 27.33 | 27.325 | 27.325 | 8000.0 |
| 2014-11-04 07:30:00 | AAPL | Stock | 27.33 | 27.345 | 27.325 | 27.325 | 14820.0 |
| 2014-11-04 07:35:00 | AAPL | Stock | 27.3375 | 27.3375 | 27.3325 | 27.3325 | 10252.0 |
| 2014-11-04 07:40:00 | AAPL | Stock | 27.3325 | 27.3325 | 27.3325 | 27.3325 | 800.0 |
| 2014-11-04 07:45:00 | AAPL | Stock | 27.3375 | 27.3625 | 27.3375 | 27.3625 | 5200.0 |
| 2014-11-04 07:50:00 | AAPL | Stock | 27.355 | 27.355 | 27.34 | 27.34 | 6764.0 |
| 2014-11-04 07:55:00 | AAPL | Stock | 27.3325 | 27.3325 | 27.3125 | 27.3125 | 16160.0 |
| 2014-11-04 08:00:00 | AAPL | Stock | 27.3175 | 27.375 | 27.2775 | 27.2875 | 180216.0 |
| 2014-11-04 08:05:00 | AAPL | Stock | 27.29 | 27.31 | 27.25 | 27.2925 | 61280.0 |
| 2014-11-04 08:10:00 | AAPL | Stock | 27.3075 | 27.31 | 27.285 | 27.285 | 17812.0 |
| 2014-11-04 08:15:00 | AAPL | Stock | 27.2875 | 27.3 | 27.2825 | 27.3 | 19020.0 |
| 2014-11-04 08:20:00 | AAPL | Stock | 27.3025 | 27.3025 | 27.2925 | 27.3 | 19732.0 |
| 2014-11-04 08:25:00 | AAPL | Stock | 27.3 | 27.3075 | 27.3 | 27.3025 | 3980.0 |
| 2014-11-04 08:30:00 | AAPL | Stock | 27.2925 | 27.3 | 27.275 | 27.2775 | 51432.0 |
| 2014-11-04 08:35:00 | AAPL | Stock | 27.2875 | 27.2975 | 27.275 | 27.2975 | 18776.0 |
| 2014-11-04 08:40:00 | AAPL | Stock | 27.295 | 27.31 | 27.2925 | 27.31 | 19372.0 |
> showing 50 of 361,578 rows — these rows as CSV