PREVIEW / stock_5min / 2016-03-10
file: by_date/stock_5min/2016/2016-03-10.parquet size: 5.4 MB rows: 356,571 symbols: 3,331
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 |
|---|---|---|---|---|---|---|---|
| 2016-03-10 04:05:00 | AAPL | Stock | 25.3 | 25.365 | 25.3 | 25.365 | 2804.0 |
| 2016-03-10 04:35:00 | AAPL | Stock | 25.3 | 25.3 | 25.3 | 25.3 | 800.0 |
| 2016-03-10 06:15:00 | AAPL | Stock | 25.3225 | 25.3225 | 25.3225 | 25.3225 | 740.0 |
| 2016-03-10 06:40:00 | AAPL | Stock | 25.325 | 25.325 | 25.325 | 25.325 | 2000.0 |
| 2016-03-10 07:05:00 | AAPL | Stock | 25.3375 | 25.3625 | 25.335 | 25.3625 | 31064.0 |
| 2016-03-10 07:10:00 | AAPL | Stock | 25.3625 | 25.395 | 25.3625 | 25.395 | 8928.0 |
| 2016-03-10 07:15:00 | AAPL | Stock | 25.395 | 25.3975 | 25.385 | 25.385 | 2740.0 |
| 2016-03-10 07:25:00 | AAPL | Stock | 25.3875 | 25.405 | 25.3875 | 25.405 | 4996.0 |
| 2016-03-10 07:30:00 | AAPL | Stock | 25.4 | 25.405 | 25.4 | 25.405 | 8800.0 |
| 2016-03-10 07:35:00 | AAPL | Stock | 25.4125 | 25.4125 | 25.395 | 25.41 | 7600.0 |
| 2016-03-10 07:40:00 | AAPL | Stock | 25.4125 | 25.425 | 25.4025 | 25.425 | 9156.0 |
| 2016-03-10 07:45:00 | AAPL | Stock | 25.4375 | 25.55 | 25.4375 | 25.4675 | 46208.0 |
| 2016-03-10 07:50:00 | AAPL | Stock | 25.4925 | 25.55 | 25.4625 | 25.51 | 53832.0 |
| 2016-03-10 07:55:00 | AAPL | Stock | 25.5375 | 25.56 | 25.51 | 25.55 | 25904.0 |
| 2016-03-10 08:00:00 | AAPL | Stock | 25.525 | 25.55 | 25.3625 | 25.5 | 107012.0 |
| 2016-03-10 08:05:00 | AAPL | Stock | 25.52 | 25.53 | 25.475 | 25.4875 | 69780.0 |
| 2016-03-10 08:10:00 | AAPL | Stock | 25.5 | 25.54 | 25.5 | 25.5375 | 72792.0 |
| 2016-03-10 08:15:00 | AAPL | Stock | 25.5275 | 25.5425 | 25.5025 | 25.5425 | 39388.0 |
| 2016-03-10 08:20:00 | AAPL | Stock | 25.5425 | 25.5425 | 25.49 | 25.49 | 45252.0 |
| 2016-03-10 08:25:00 | AAPL | Stock | 25.5 | 25.5325 | 25.475 | 25.5225 | 49352.0 |
| 2016-03-10 08:30:00 | AAPL | Stock | 25.5275 | 25.535 | 25.5075 | 25.5125 | 12808.0 |
| 2016-03-10 08:35:00 | AAPL | Stock | 25.5275 | 25.555 | 25.5175 | 25.55 | 101736.0 |
| 2016-03-10 08:40:00 | AAPL | Stock | 25.55 | 25.55 | 25.5325 | 25.5325 | 24500.0 |
| 2016-03-10 08:45:00 | AAPL | Stock | 25.525 | 25.5325 | 25.5025 | 25.525 | 27736.0 |
| 2016-03-10 08:50:00 | AAPL | Stock | 25.515 | 25.52 | 25.475 | 25.505 | 28812.0 |
| 2016-03-10 08:55:00 | AAPL | Stock | 25.485 | 25.5 | 25.4525 | 25.475 | 69476.0 |
| 2016-03-10 09:00:00 | AAPL | Stock | 25.465 | 25.47 | 25.4425 | 25.4675 | 82124.0 |
| 2016-03-10 09:05:00 | AAPL | Stock | 25.4675 | 25.4925 | 25.4675 | 25.4925 | 25216.0 |
| 2016-03-10 09:10:00 | AAPL | Stock | 25.4975 | 25.4975 | 25.3975 | 25.4 | 113072.0 |
| 2016-03-10 09:15:00 | AAPL | Stock | 25.425 | 25.45 | 25.42 | 25.45 | 9200.0 |
| 2016-03-10 09:20:00 | AAPL | Stock | 25.45 | 25.455 | 25.4225 | 25.45 | 25048.0 |
| 2016-03-10 09:25:00 | AAPL | Stock | 25.44 | 25.4425 | 25.35 | 25.36 | 105572.0 |
| 2016-03-10 09:30:00 | AAPL | Stock | 25.3525 | 25.53 | 25.3075 | 25.4875 | 5522136.0 |
| 2016-03-10 09:35:00 | AAPL | Stock | 25.48 | 25.4978 | 25.3925 | 25.4775 | 2603528.0 |
| 2016-03-10 09:40:00 | AAPL | Stock | 25.4825 | 25.4825 | 25.4025 | 25.4513 | 1730328.0 |
| 2016-03-10 09:45:00 | AAPL | Stock | 25.4515 | 25.52 | 25.4125 | 25.4612 | 2377044.0 |
| 2016-03-10 09:50:00 | AAPL | Stock | 25.4615 | 25.525 | 25.445 | 25.5075 | 1976732.0 |
| 2016-03-10 09:55:00 | AAPL | Stock | 25.5075 | 25.56 | 25.485 | 25.55 | 2962376.0 |
| 2016-03-10 10:00:00 | AAPL | Stock | 25.552 | 25.56 | 25.49 | 25.497 | 1836792.0 |
| 2016-03-10 10:05:00 | AAPL | Stock | 25.495 | 25.5 | 25.4312 | 25.4575 | 2410640.0 |
| 2016-03-10 10:10:00 | AAPL | Stock | 25.459 | 25.47 | 25.425 | 25.462 | 1569376.0 |
| 2016-03-10 10:15:00 | AAPL | Stock | 25.4625 | 25.4875 | 25.425 | 25.43 | 1144680.0 |
| 2016-03-10 10:20:00 | AAPL | Stock | 25.428 | 25.4525 | 25.4 | 25.4 | 1734120.0 |
| 2016-03-10 10:25:00 | AAPL | Stock | 25.4025 | 25.4175 | 25.3525 | 25.37 | 1630492.0 |
| 2016-03-10 10:30:00 | AAPL | Stock | 25.3675 | 25.3775 | 25.3225 | 25.3355 | 1905736.0 |
| 2016-03-10 10:35:00 | AAPL | Stock | 25.3375 | 25.3675 | 25.275 | 25.315 | 2283212.0 |
| 2016-03-10 10:40:00 | AAPL | Stock | 25.315 | 25.3575 | 25.2675 | 25.3575 | 2056844.0 |
| 2016-03-10 10:45:00 | AAPL | Stock | 25.355 | 25.362 | 25.3025 | 25.31 | 1231556.0 |
| 2016-03-10 10:50:00 | AAPL | Stock | 25.3088 | 25.34 | 25.29 | 25.325 | 976040.0 |
| 2016-03-10 10:55:00 | AAPL | Stock | 25.325 | 25.3325 | 25.19 | 25.205 | 2070068.0 |
> showing 50 of 356,571 rows — these rows as CSV