PREVIEW / stock_5min / 2015-08-04
file: by_date/stock_5min/2015/2015-08-04.parquet size: 5.3 MB rows: 354,934 symbols: 3,458
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-08-04 04:00:00 | AAPL | Stock | 29.375 | 29.5375 | 29.375 | 29.385 | 44476.0 |
| 2015-08-04 04:05:00 | AAPL | Stock | 29.36 | 29.3775 | 29.35 | 29.37 | 76256.0 |
| 2015-08-04 04:10:00 | AAPL | Stock | 29.37 | 29.3925 | 29.37 | 29.3925 | 3008.0 |
| 2015-08-04 04:15:00 | AAPL | Stock | 29.445 | 29.5 | 29.445 | 29.5 | 19976.0 |
| 2015-08-04 04:20:00 | AAPL | Stock | 29.5 | 29.5 | 29.5 | 29.5 | 16360.0 |
| 2015-08-04 04:25:00 | AAPL | Stock | 29.5075 | 29.5075 | 29.4975 | 29.5 | 34404.0 |
| 2015-08-04 04:30:00 | AAPL | Stock | 29.535 | 29.5375 | 29.5175 | 29.5175 | 18512.0 |
| 2015-08-04 04:45:00 | AAPL | Stock | 29.525 | 29.525 | 29.4875 | 29.4875 | 2464.0 |
| 2015-08-04 05:00:00 | AAPL | Stock | 29.5 | 29.5 | 29.5 | 29.5 | 36276.0 |
| 2015-08-04 05:25:00 | AAPL | Stock | 29.5 | 29.5 | 29.5 | 29.5 | 3640.0 |
| 2015-08-04 05:30:00 | AAPL | Stock | 29.5 | 29.5 | 29.5 | 29.5 | 21208.0 |
| 2015-08-04 05:35:00 | AAPL | Stock | 29.5 | 29.5125 | 29.5 | 29.5125 | 2400.0 |
| 2015-08-04 05:55:00 | AAPL | Stock | 29.5375 | 29.5375 | 29.5375 | 29.5375 | 1364.0 |
| 2015-08-04 06:00:00 | AAPL | Stock | 29.525 | 29.525 | 29.5125 | 29.5125 | 4804.0 |
| 2015-08-04 06:05:00 | AAPL | Stock | 29.5225 | 29.5325 | 29.515 | 29.5225 | 9420.0 |
| 2015-08-04 06:10:00 | AAPL | Stock | 29.5225 | 29.5225 | 29.51 | 29.51 | 4000.0 |
| 2015-08-04 06:15:00 | AAPL | Stock | 29.5 | 29.5 | 29.4425 | 29.4425 | 28800.0 |
| 2015-08-04 06:20:00 | AAPL | Stock | 29.4375 | 29.475 | 29.425 | 29.475 | 39372.0 |
| 2015-08-04 06:25:00 | AAPL | Stock | 29.425 | 29.425 | 29.425 | 29.425 | 2872.0 |
| 2015-08-04 06:30:00 | AAPL | Stock | 29.4625 | 29.4625 | 29.4625 | 29.4625 | 11768.0 |
| 2015-08-04 06:35:00 | AAPL | Stock | 29.44 | 29.44 | 29.4375 | 29.4375 | 1644.0 |
| 2015-08-04 06:40:00 | AAPL | Stock | 29.4375 | 29.4375 | 29.4375 | 29.4375 | 11600.0 |
| 2015-08-04 06:45:00 | AAPL | Stock | 29.4525 | 29.4525 | 29.4525 | 29.4525 | 444.0 |
| 2015-08-04 06:50:00 | AAPL | Stock | 29.445 | 29.4675 | 29.425 | 29.425 | 26492.0 |
| 2015-08-04 06:55:00 | AAPL | Stock | 29.4125 | 29.4125 | 29.4 | 29.4125 | 47932.0 |
| 2015-08-04 07:00:00 | AAPL | Stock | 29.4125 | 29.425 | 29.4 | 29.4125 | 12520.0 |
| 2015-08-04 07:05:00 | AAPL | Stock | 29.415 | 29.415 | 29.3825 | 29.3825 | 57520.0 |
| 2015-08-04 07:10:00 | AAPL | Stock | 29.4075 | 29.42 | 29.4075 | 29.41 | 31220.0 |
| 2015-08-04 07:15:00 | AAPL | Stock | 29.4125 | 29.4125 | 29.3875 | 29.4 | 79408.0 |
| 2015-08-04 07:20:00 | AAPL | Stock | 29.4075 | 29.41 | 29.4 | 29.4 | 5600.0 |
| 2015-08-04 07:25:00 | AAPL | Stock | 29.4025 | 29.4025 | 29.3875 | 29.3875 | 40732.0 |
| 2015-08-04 07:30:00 | AAPL | Stock | 29.3875 | 29.4 | 29.375 | 29.375 | 64888.0 |
| 2015-08-04 07:35:00 | AAPL | Stock | 29.375 | 29.375 | 29.355 | 29.3625 | 42516.0 |
| 2015-08-04 07:40:00 | AAPL | Stock | 29.355 | 29.355 | 29.3325 | 29.3375 | 87296.0 |
| 2015-08-04 07:45:00 | AAPL | Stock | 29.3475 | 29.3475 | 29.315 | 29.315 | 44612.0 |
| 2015-08-04 07:50:00 | AAPL | Stock | 29.315 | 29.3475 | 29.315 | 29.3375 | 26720.0 |
| 2015-08-04 07:55:00 | AAPL | Stock | 29.3275 | 29.3525 | 29.31 | 29.3525 | 71000.0 |
| 2015-08-04 08:00:00 | AAPL | Stock | 29.35 | 29.5125 | 29.3025 | 29.445 | 606236.0 |
| 2015-08-04 08:05:00 | AAPL | Stock | 29.4375 | 29.4475 | 29.4125 | 29.4125 | 37808.0 |
| 2015-08-04 08:10:00 | AAPL | Stock | 29.4125 | 29.445 | 29.4125 | 29.4375 | 48388.0 |
| 2015-08-04 08:15:00 | AAPL | Stock | 29.4375 | 29.4425 | 29.405 | 29.4125 | 23148.0 |
| 2015-08-04 08:20:00 | AAPL | Stock | 29.4225 | 29.4325 | 29.3875 | 29.3875 | 26456.0 |
| 2015-08-04 08:25:00 | AAPL | Stock | 29.3925 | 29.405 | 29.3925 | 29.395 | 58932.0 |
| 2015-08-04 08:30:00 | AAPL | Stock | 29.3925 | 29.3925 | 29.3775 | 29.385 | 26452.0 |
| 2015-08-04 08:35:00 | AAPL | Stock | 29.38 | 29.3875 | 29.38 | 29.385 | 38128.0 |
| 2015-08-04 08:40:00 | AAPL | Stock | 29.38 | 29.3825 | 29.35 | 29.3525 | 69476.0 |
| 2015-08-04 08:45:00 | AAPL | Stock | 29.3525 | 29.3575 | 29.325 | 29.3375 | 111140.0 |
| 2015-08-04 08:50:00 | AAPL | Stock | 29.3375 | 29.3625 | 29.2825 | 29.3625 | 161140.0 |
| 2015-08-04 08:55:00 | AAPL | Stock | 29.3625 | 29.4225 | 29.3225 | 29.335 | 187840.0 |
| 2015-08-04 09:00:00 | AAPL | Stock | 29.35 | 29.3575 | 29.325 | 29.325 | 101180.0 |
> showing 50 of 354,934 rows — these rows as CSV