PREVIEW / stock_5min / 2016-06-03
file: by_date/stock_5min/2016/2016-06-03.parquet size: 5.3 MB rows: 355,983 symbols: 3,298
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-03 05:40:00 | AAPL | Stock | 24.4875 | 24.4875 | 24.4875 | 24.4875 | 400.0 |
| 2016-06-03 06:05:00 | AAPL | Stock | 24.5 | 24.5 | 24.5 | 24.5 | 800.0 |
| 2016-06-03 06:50:00 | AAPL | Stock | 24.475 | 24.475 | 24.475 | 24.475 | 1260.0 |
| 2016-06-03 06:55:00 | AAPL | Stock | 24.495 | 24.495 | 24.495 | 24.495 | 400.0 |
| 2016-06-03 07:25:00 | AAPL | Stock | 24.475 | 24.475 | 24.475 | 24.475 | 1200.0 |
| 2016-06-03 07:35:00 | AAPL | Stock | 24.49 | 24.4925 | 24.49 | 24.4925 | 800.0 |
| 2016-06-03 07:40:00 | AAPL | Stock | 24.4925 | 24.4925 | 24.4925 | 24.4925 | 800.0 |
| 2016-06-03 07:45:00 | AAPL | Stock | 24.495 | 24.495 | 24.495 | 24.495 | 400.0 |
| 2016-06-03 07:50:00 | AAPL | Stock | 24.495 | 24.495 | 24.4875 | 24.4875 | 10700.0 |
| 2016-06-03 07:55:00 | AAPL | Stock | 24.485 | 24.4875 | 24.485 | 24.4875 | 5108.0 |
| 2016-06-03 08:00:00 | AAPL | Stock | 24.4875 | 24.495 | 24.475 | 24.4925 | 27200.0 |
| 2016-06-03 08:05:00 | AAPL | Stock | 24.49 | 24.49 | 24.485 | 24.49 | 11120.0 |
| 2016-06-03 08:10:00 | AAPL | Stock | 24.49 | 24.5075 | 24.49 | 24.5 | 34428.0 |
| 2016-06-03 08:15:00 | AAPL | Stock | 24.5 | 24.5025 | 24.4975 | 24.5025 | 20852.0 |
| 2016-06-03 08:20:00 | AAPL | Stock | 24.51 | 24.515 | 24.4875 | 24.4875 | 12668.0 |
| 2016-06-03 08:25:00 | AAPL | Stock | 24.49 | 24.5 | 24.49 | 24.49 | 7180.0 |
| 2016-06-03 08:30:00 | AAPL | Stock | 24.49 | 24.52 | 24.405 | 24.485 | 218112.0 |
| 2016-06-03 08:35:00 | AAPL | Stock | 24.5 | 24.5 | 24.4625 | 24.49 | 62500.0 |
| 2016-06-03 08:40:00 | AAPL | Stock | 24.4975 | 24.4975 | 24.4875 | 24.4875 | 16348.0 |
| 2016-06-03 08:45:00 | AAPL | Stock | 24.4825 | 24.4825 | 24.4175 | 24.4175 | 55808.0 |
| 2016-06-03 08:50:00 | AAPL | Stock | 24.4175 | 24.425 | 24.3775 | 24.38 | 163012.0 |
| 2016-06-03 08:55:00 | AAPL | Stock | 24.38 | 24.38 | 24.3575 | 24.36 | 67212.0 |
| 2016-06-03 09:00:00 | AAPL | Stock | 24.365 | 24.365 | 24.335 | 24.355 | 79172.0 |
| 2016-06-03 09:05:00 | AAPL | Stock | 24.3425 | 24.3575 | 24.3425 | 24.3475 | 15692.0 |
| 2016-06-03 09:10:00 | AAPL | Stock | 24.3475 | 24.375 | 24.3475 | 24.375 | 28036.0 |
| 2016-06-03 09:15:00 | AAPL | Stock | 24.3725 | 24.38 | 24.3675 | 24.3675 | 35820.0 |
| 2016-06-03 09:20:00 | AAPL | Stock | 24.37 | 24.415 | 24.3575 | 24.405 | 57964.0 |
| 2016-06-03 09:25:00 | AAPL | Stock | 24.4075 | 24.455 | 24.4075 | 24.455 | 303520.0 |
| 2016-06-03 09:30:00 | AAPL | Stock | 24.455 | 24.5675 | 24.4225 | 24.5475 | 6429472.0 |
| 2016-06-03 09:35:00 | AAPL | Stock | 24.55 | 24.5612 | 24.4775 | 24.5075 | 2293372.0 |
| 2016-06-03 09:40:00 | AAPL | Stock | 24.509 | 24.5225 | 24.4862 | 24.51 | 2519684.0 |
| 2016-06-03 09:45:00 | AAPL | Stock | 24.5125 | 24.5275 | 24.4625 | 24.495 | 2875268.0 |
| 2016-06-03 09:50:00 | AAPL | Stock | 24.495 | 24.4975 | 24.46 | 24.4812 | 1894008.0 |
| 2016-06-03 09:55:00 | AAPL | Stock | 24.4825 | 24.485 | 24.4375 | 24.4675 | 2332556.0 |
| 2016-06-03 10:00:00 | AAPL | Stock | 24.4675 | 24.5125 | 24.445 | 24.4762 | 3072316.0 |
| 2016-06-03 10:05:00 | AAPL | Stock | 24.475 | 24.494 | 24.4075 | 24.4175 | 2179764.0 |
| 2016-06-03 10:10:00 | AAPL | Stock | 24.4175 | 24.42 | 24.3625 | 24.4125 | 2382408.0 |
| 2016-06-03 10:15:00 | AAPL | Stock | 24.4112 | 24.43 | 24.405 | 24.415 | 1588412.0 |
| 2016-06-03 10:20:00 | AAPL | Stock | 24.4148 | 24.42 | 24.385 | 24.415 | 1488948.0 |
| 2016-06-03 10:25:00 | AAPL | Stock | 24.415 | 24.4375 | 24.4025 | 24.4325 | 1492900.0 |
| 2016-06-03 10:30:00 | AAPL | Stock | 24.43 | 24.4775 | 24.405 | 24.4725 | 1871644.0 |
| 2016-06-03 10:35:00 | AAPL | Stock | 24.4725 | 24.505 | 24.4475 | 24.5028 | 1630108.0 |
| 2016-06-03 10:40:00 | AAPL | Stock | 24.5038 | 24.5125 | 24.4675 | 24.4888 | 1694396.0 |
| 2016-06-03 10:45:00 | AAPL | Stock | 24.4875 | 24.5038 | 24.46 | 24.495 | 1336896.0 |
| 2016-06-03 10:50:00 | AAPL | Stock | 24.495 | 24.4975 | 24.46 | 24.47 | 1084820.0 |
| 2016-06-03 10:55:00 | AAPL | Stock | 24.47 | 24.475 | 24.4275 | 24.44 | 1581424.0 |
| 2016-06-03 11:00:00 | AAPL | Stock | 24.44 | 24.46 | 24.4 | 24.4225 | 1683548.0 |
| 2016-06-03 11:05:00 | AAPL | Stock | 24.4225 | 24.4475 | 24.4 | 24.4075 | 1111960.0 |
| 2016-06-03 11:10:00 | AAPL | Stock | 24.405 | 24.42 | 24.4 | 24.4075 | 948904.0 |
| 2016-06-03 11:15:00 | AAPL | Stock | 24.4088 | 24.435 | 24.4025 | 24.4328 | 787056.0 |
> showing 50 of 355,983 rows — these rows as CSV