PREVIEW / stock_5min / 2015-09-23
file: by_date/stock_5min/2015/2015-09-23.parquet size: 5.3 MB rows: 352,741 symbols: 3,429
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-09-23 04:00:00 | AAPL | Stock | 27.775 | 28.3225 | 27.775 | 28.3225 | 12424.0 |
| 2015-09-23 04:05:00 | AAPL | Stock | 28.29 | 28.3225 | 28.29 | 28.3225 | 6176.0 |
| 2015-09-23 04:10:00 | AAPL | Stock | 28.375 | 28.4 | 28.375 | 28.4 | 3200.0 |
| 2015-09-23 04:35:00 | AAPL | Stock | 28.4 | 28.4075 | 28.36 | 28.36 | 2800.0 |
| 2015-09-23 04:45:00 | AAPL | Stock | 28.465 | 28.465 | 28.4175 | 28.4175 | 1200.0 |
| 2015-09-23 05:10:00 | AAPL | Stock | 28.4425 | 28.4425 | 28.4425 | 28.4425 | 400.0 |
| 2015-09-23 05:15:00 | AAPL | Stock | 28.425 | 28.425 | 28.425 | 28.425 | 4000.0 |
| 2015-09-23 05:20:00 | AAPL | Stock | 28.425 | 28.445 | 28.425 | 28.425 | 16000.0 |
| 2015-09-23 05:45:00 | AAPL | Stock | 28.435 | 28.4425 | 28.435 | 28.4425 | 3600.0 |
| 2015-09-23 05:50:00 | AAPL | Stock | 28.4425 | 28.445 | 28.4425 | 28.445 | 2936.0 |
| 2015-09-23 05:55:00 | AAPL | Stock | 28.445 | 28.445 | 28.445 | 28.445 | 1200.0 |
| 2015-09-23 06:00:00 | AAPL | Stock | 28.445 | 28.5 | 28.445 | 28.5 | 5728.0 |
| 2015-09-23 06:05:00 | AAPL | Stock | 28.4725 | 28.495 | 28.4725 | 28.495 | 10800.0 |
| 2015-09-23 06:10:00 | AAPL | Stock | 28.4775 | 28.4775 | 28.4525 | 28.4725 | 14804.0 |
| 2015-09-23 06:15:00 | AAPL | Stock | 28.4725 | 28.4725 | 28.45 | 28.45 | 7200.0 |
| 2015-09-23 06:20:00 | AAPL | Stock | 28.4375 | 28.4475 | 28.425 | 28.435 | 7600.0 |
| 2015-09-23 06:25:00 | AAPL | Stock | 28.44 | 28.44 | 28.44 | 28.44 | 400.0 |
| 2015-09-23 06:30:00 | AAPL | Stock | 28.43 | 28.44 | 28.43 | 28.44 | 800.0 |
| 2015-09-23 06:35:00 | AAPL | Stock | 28.4475 | 28.4475 | 28.4375 | 28.44 | 1200.0 |
| 2015-09-23 06:45:00 | AAPL | Stock | 28.4325 | 28.4325 | 28.4325 | 28.4325 | 800.0 |
| 2015-09-23 06:55:00 | AAPL | Stock | 28.4475 | 28.4475 | 28.4475 | 28.4475 | 6000.0 |
| 2015-09-23 07:00:00 | AAPL | Stock | 28.4475 | 28.4875 | 28.4425 | 28.4525 | 17096.0 |
| 2015-09-23 07:05:00 | AAPL | Stock | 28.48 | 28.4975 | 28.48 | 28.4975 | 8696.0 |
| 2015-09-23 07:10:00 | AAPL | Stock | 28.5 | 28.5125 | 28.5 | 28.5125 | 27916.0 |
| 2015-09-23 07:15:00 | AAPL | Stock | 28.5 | 28.5 | 28.475 | 28.475 | 4320.0 |
| 2015-09-23 07:20:00 | AAPL | Stock | 28.48 | 28.4975 | 28.48 | 28.4925 | 7840.0 |
| 2015-09-23 07:25:00 | AAPL | Stock | 28.475 | 28.49 | 28.475 | 28.49 | 5600.0 |
| 2015-09-23 07:30:00 | AAPL | Stock | 28.4875 | 28.4975 | 28.4875 | 28.4875 | 10992.0 |
| 2015-09-23 07:35:00 | AAPL | Stock | 28.4875 | 28.49 | 28.48 | 28.48 | 8060.0 |
| 2015-09-23 07:40:00 | AAPL | Stock | 28.4775 | 28.4775 | 28.4375 | 28.455 | 65552.0 |
| 2015-09-23 07:45:00 | AAPL | Stock | 28.4675 | 28.48 | 28.4375 | 28.45 | 8480.0 |
| 2015-09-23 07:50:00 | AAPL | Stock | 28.45 | 28.4625 | 28.45 | 28.4625 | 3920.0 |
| 2015-09-23 07:55:00 | AAPL | Stock | 28.4625 | 28.4625 | 28.45 | 28.45 | 5600.0 |
| 2015-09-23 08:00:00 | AAPL | Stock | 28.455 | 28.5 | 28.4375 | 28.4525 | 103984.0 |
| 2015-09-23 08:05:00 | AAPL | Stock | 28.4525 | 28.4725 | 28.45 | 28.4575 | 47472.0 |
| 2015-09-23 08:10:00 | AAPL | Stock | 28.4575 | 28.47 | 28.4575 | 28.4625 | 11160.0 |
| 2015-09-23 08:15:00 | AAPL | Stock | 28.475 | 28.485 | 28.475 | 28.485 | 48872.0 |
| 2015-09-23 08:20:00 | AAPL | Stock | 28.4875 | 28.5175 | 28.48 | 28.5175 | 74812.0 |
| 2015-09-23 08:25:00 | AAPL | Stock | 28.5125 | 28.545 | 28.5075 | 28.5375 | 111332.0 |
| 2015-09-23 08:30:00 | AAPL | Stock | 28.5275 | 28.5375 | 28.525 | 28.525 | 152516.0 |
| 2015-09-23 08:35:00 | AAPL | Stock | 28.525 | 28.5375 | 28.5125 | 28.5325 | 78400.0 |
| 2015-09-23 08:40:00 | AAPL | Stock | 28.54 | 28.5525 | 28.5275 | 28.5375 | 36544.0 |
| 2015-09-23 08:45:00 | AAPL | Stock | 28.5325 | 28.5325 | 28.5125 | 28.5125 | 13200.0 |
| 2015-09-23 08:50:00 | AAPL | Stock | 28.5125 | 28.5175 | 28.4875 | 28.5 | 44212.0 |
| 2015-09-23 08:55:00 | AAPL | Stock | 28.5 | 28.5025 | 28.48 | 28.4825 | 30196.0 |
| 2015-09-23 09:00:00 | AAPL | Stock | 28.485 | 28.4925 | 28.475 | 28.4775 | 24000.0 |
| 2015-09-23 09:05:00 | AAPL | Stock | 28.4675 | 28.47 | 28.405 | 28.415 | 135036.0 |
| 2015-09-23 09:10:00 | AAPL | Stock | 28.415 | 28.43 | 28.375 | 28.405 | 86300.0 |
| 2015-09-23 09:15:00 | AAPL | Stock | 28.4125 | 28.415 | 28.4075 | 28.4125 | 27108.0 |
| 2015-09-23 09:20:00 | AAPL | Stock | 28.425 | 28.45 | 28.425 | 28.44 | 19740.0 |
> showing 50 of 352,741 rows — these rows as CSV