PREVIEW / stock_5min / 2016-06-15
file: by_date/stock_5min/2016/2016-06-15.parquet size: 5.3 MB rows: 358,123 symbols: 3,291
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-06-15 04:25:00 | AAPL | Stock | 24.415 | 24.415 | 24.415 | 24.415 | 1072.0 |
| 2016-06-15 04:40:00 | AAPL | Stock | 24.4325 | 24.4325 | 24.4325 | 24.4325 | 400.0 |
| 2016-06-15 04:45:00 | AAPL | Stock | 24.45 | 24.45 | 24.45 | 24.45 | 400.0 |
| 2016-06-15 04:55:00 | AAPL | Stock | 24.4325 | 24.4325 | 24.4325 | 24.4325 | 500.0 |
| 2016-06-15 05:00:00 | AAPL | Stock | 24.45 | 24.45 | 24.45 | 24.45 | 800.0 |
| 2016-06-15 05:10:00 | AAPL | Stock | 24.455 | 24.455 | 24.455 | 24.455 | 1012.0 |
| 2016-06-15 05:20:00 | AAPL | Stock | 24.47 | 24.4725 | 24.47 | 24.4725 | 2292.0 |
| 2016-06-15 05:55:00 | AAPL | Stock | 24.475 | 24.475 | 24.475 | 24.475 | 640.0 |
| 2016-06-15 06:20:00 | AAPL | Stock | 24.475 | 24.475 | 24.475 | 24.475 | 400.0 |
| 2016-06-15 07:00:00 | AAPL | Stock | 24.475 | 24.475 | 24.475 | 24.475 | 3200.0 |
| 2016-06-15 07:10:00 | AAPL | Stock | 24.455 | 24.455 | 24.45 | 24.45 | 2560.0 |
| 2016-06-15 07:15:00 | AAPL | Stock | 24.4575 | 24.47 | 24.4575 | 24.47 | 2908.0 |
| 2016-06-15 07:20:00 | AAPL | Stock | 24.47 | 24.4825 | 24.47 | 24.4825 | 12328.0 |
| 2016-06-15 07:25:00 | AAPL | Stock | 24.475 | 24.475 | 24.475 | 24.475 | 4800.0 |
| 2016-06-15 07:30:00 | AAPL | Stock | 24.4775 | 24.4775 | 24.4775 | 24.4775 | 400.0 |
| 2016-06-15 07:35:00 | AAPL | Stock | 24.47 | 24.47 | 24.47 | 24.47 | 800.0 |
| 2016-06-15 07:40:00 | AAPL | Stock | 24.4775 | 24.4775 | 24.47 | 24.47 | 1600.0 |
| 2016-06-15 07:45:00 | AAPL | Stock | 24.4575 | 24.4575 | 24.455 | 24.455 | 2000.0 |
| 2016-06-15 07:50:00 | AAPL | Stock | 24.455 | 24.455 | 24.455 | 24.455 | 1832.0 |
| 2016-06-15 08:00:00 | AAPL | Stock | 24.4375 | 24.475 | 24.41 | 24.44 | 75900.0 |
| 2016-06-15 08:05:00 | AAPL | Stock | 24.4375 | 24.4375 | 24.4375 | 24.4375 | 420.0 |
| 2016-06-15 08:10:00 | AAPL | Stock | 24.4375 | 24.4375 | 24.4375 | 24.4375 | 1600.0 |
| 2016-06-15 08:15:00 | AAPL | Stock | 24.44 | 24.44 | 24.4375 | 24.4375 | 21160.0 |
| 2016-06-15 08:20:00 | AAPL | Stock | 24.43 | 24.455 | 24.43 | 24.4525 | 27200.0 |
| 2016-06-15 08:25:00 | AAPL | Stock | 24.425 | 24.4525 | 24.425 | 24.4525 | 7144.0 |
| 2016-06-15 08:30:00 | AAPL | Stock | 24.43 | 24.43 | 24.4025 | 24.42 | 11600.0 |
| 2016-06-15 08:35:00 | AAPL | Stock | 24.43 | 24.4375 | 24.4225 | 24.425 | 24024.0 |
| 2016-06-15 08:40:00 | AAPL | Stock | 24.435 | 24.44 | 24.435 | 24.4375 | 29832.0 |
| 2016-06-15 08:45:00 | AAPL | Stock | 24.4425 | 24.4425 | 24.435 | 24.4425 | 19480.0 |
| 2016-06-15 08:50:00 | AAPL | Stock | 24.44 | 24.445 | 24.44 | 24.445 | 2600.0 |
| 2016-06-15 08:55:00 | AAPL | Stock | 24.4425 | 24.445 | 24.44 | 24.445 | 10740.0 |
| 2016-06-15 09:00:00 | AAPL | Stock | 24.4425 | 24.4425 | 24.4375 | 24.4425 | 6780.0 |
| 2016-06-15 09:05:00 | AAPL | Stock | 24.4425 | 24.4425 | 24.43 | 24.43 | 33688.0 |
| 2016-06-15 09:10:00 | AAPL | Stock | 24.435 | 24.44 | 24.435 | 24.44 | 1600.0 |
| 2016-06-15 09:15:00 | AAPL | Stock | 24.44 | 24.45 | 24.44 | 24.445 | 16000.0 |
| 2016-06-15 09:20:00 | AAPL | Stock | 24.435 | 24.445 | 24.435 | 24.445 | 4960.0 |
| 2016-06-15 09:25:00 | AAPL | Stock | 24.4425 | 24.455 | 24.4425 | 24.45 | 18356.0 |
| 2016-06-15 09:30:00 | AAPL | Stock | 24.455 | 24.5275 | 24.45 | 24.4835 | 4167448.0 |
| 2016-06-15 09:35:00 | AAPL | Stock | 24.4825 | 24.5725 | 24.475 | 24.57 | 3020108.0 |
| 2016-06-15 09:40:00 | AAPL | Stock | 24.57 | 24.6025 | 24.4952 | 24.53 | 3575468.0 |
| 2016-06-15 09:45:00 | AAPL | Stock | 24.5275 | 24.565 | 24.4985 | 24.55 | 2557152.0 |
| 2016-06-15 09:50:00 | AAPL | Stock | 24.55 | 24.565 | 24.5197 | 24.5275 | 1563964.0 |
| 2016-06-15 09:55:00 | AAPL | Stock | 24.53 | 24.53 | 24.48 | 24.495 | 1706524.0 |
| 2016-06-15 10:00:00 | AAPL | Stock | 24.495 | 24.5675 | 24.495 | 24.5485 | 1819344.0 |
| 2016-06-15 10:05:00 | AAPL | Stock | 24.5487 | 24.5725 | 24.5325 | 24.5682 | 1522912.0 |
| 2016-06-15 10:10:00 | AAPL | Stock | 24.57 | 24.57 | 24.5325 | 24.555 | 1046056.0 |
| 2016-06-15 10:15:00 | AAPL | Stock | 24.555 | 24.555 | 24.515 | 24.5262 | 1354480.0 |
| 2016-06-15 10:20:00 | AAPL | Stock | 24.5262 | 24.537 | 24.5 | 24.5022 | 917868.0 |
| 2016-06-15 10:25:00 | AAPL | Stock | 24.501 | 24.51 | 24.4775 | 24.4965 | 1135656.0 |
| 2016-06-15 10:30:00 | AAPL | Stock | 24.4975 | 24.526 | 24.485 | 24.52 | 1303088.0 |
> showing 50 of 358,123 rows — these rows as CSV