PREVIEW / stock_5min / 2015-03-25
file: by_date/stock_5min/2015/2015-03-25.parquet size: 5.6 MB rows: 365,813 symbols: 3,490
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-03-25 04:00:00 | AAPL | Stock | 31.75 | 31.7775 | 31.75 | 31.775 | 2800.0 |
| 2015-03-25 04:05:00 | AAPL | Stock | 31.75 | 31.75 | 31.75 | 31.75 | 400.0 |
| 2015-03-25 04:25:00 | AAPL | Stock | 31.785 | 31.785 | 31.785 | 31.785 | 400.0 |
| 2015-03-25 05:00:00 | AAPL | Stock | 31.7425 | 31.7425 | 31.7425 | 31.7425 | 400.0 |
| 2015-03-25 05:55:00 | AAPL | Stock | 31.7375 | 31.75 | 31.7375 | 31.75 | 2400.0 |
| 2015-03-25 06:05:00 | AAPL | Stock | 31.765 | 31.7725 | 31.75 | 31.75 | 1200.0 |
| 2015-03-25 06:40:00 | AAPL | Stock | 31.7425 | 31.7425 | 31.7425 | 31.7425 | 400.0 |
| 2015-03-25 07:05:00 | AAPL | Stock | 31.7075 | 31.7125 | 31.7075 | 31.7125 | 10800.0 |
| 2015-03-25 07:10:00 | AAPL | Stock | 31.685 | 31.685 | 31.6825 | 31.6825 | 2400.0 |
| 2015-03-25 07:15:00 | AAPL | Stock | 31.7125 | 31.7175 | 31.7125 | 31.7175 | 800.0 |
| 2015-03-25 07:20:00 | AAPL | Stock | 31.72 | 31.72 | 31.715 | 31.715 | 3200.0 |
| 2015-03-25 07:30:00 | AAPL | Stock | 31.7 | 31.7 | 31.6875 | 31.6875 | 7804.0 |
| 2015-03-25 07:35:00 | AAPL | Stock | 31.6875 | 31.6975 | 31.6625 | 31.6625 | 30192.0 |
| 2015-03-25 07:40:00 | AAPL | Stock | 31.6625 | 31.6625 | 31.65 | 31.65 | 6080.0 |
| 2015-03-25 07:45:00 | AAPL | Stock | 31.665 | 31.665 | 31.665 | 31.665 | 1000.0 |
| 2015-03-25 07:50:00 | AAPL | Stock | 31.6525 | 31.655 | 31.6525 | 31.6525 | 5240.0 |
| 2015-03-25 07:55:00 | AAPL | Stock | 31.645 | 31.645 | 31.25 | 31.45 | 229564.0 |
| 2015-03-25 08:00:00 | AAPL | Stock | 31.4525 | 31.76 | 31.375 | 31.475 | 325600.0 |
| 2015-03-25 08:05:00 | AAPL | Stock | 31.475 | 31.57 | 31.4625 | 31.57 | 149668.0 |
| 2015-03-25 08:10:00 | AAPL | Stock | 31.57 | 31.57 | 31.5275 | 31.5625 | 106152.0 |
| 2015-03-25 08:15:00 | AAPL | Stock | 31.57 | 31.57 | 31.5475 | 31.5475 | 10400.0 |
| 2015-03-25 08:20:00 | AAPL | Stock | 31.555 | 31.5625 | 31.5525 | 31.555 | 32140.0 |
| 2015-03-25 08:25:00 | AAPL | Stock | 31.555 | 31.5975 | 31.555 | 31.5975 | 75676.0 |
| 2015-03-25 08:30:00 | AAPL | Stock | 31.5975 | 31.61 | 31.575 | 31.6 | 69000.0 |
| 2015-03-25 08:35:00 | AAPL | Stock | 31.6 | 31.6125 | 31.5825 | 31.5975 | 35824.0 |
| 2015-03-25 08:40:00 | AAPL | Stock | 31.59 | 31.635 | 31.5875 | 31.635 | 32200.0 |
| 2015-03-25 08:45:00 | AAPL | Stock | 31.6375 | 31.65 | 31.6275 | 31.64 | 51224.0 |
| 2015-03-25 08:50:00 | AAPL | Stock | 31.6425 | 31.6425 | 31.6325 | 31.6325 | 15576.0 |
| 2015-03-25 08:55:00 | AAPL | Stock | 31.6375 | 31.6425 | 31.6325 | 31.6425 | 13560.0 |
| 2015-03-25 09:00:00 | AAPL | Stock | 31.6425 | 31.6525 | 31.6425 | 31.6525 | 10352.0 |
| 2015-03-25 09:05:00 | AAPL | Stock | 31.655 | 31.685 | 31.655 | 31.685 | 43552.0 |
| 2015-03-25 09:10:00 | AAPL | Stock | 31.675 | 31.6975 | 31.6725 | 31.6725 | 38672.0 |
| 2015-03-25 09:15:00 | AAPL | Stock | 31.67 | 31.6825 | 31.665 | 31.665 | 20536.0 |
| 2015-03-25 09:20:00 | AAPL | Stock | 31.655 | 31.675 | 31.64 | 31.65 | 32508.0 |
| 2015-03-25 09:25:00 | AAPL | Stock | 31.64 | 31.6775 | 31.6125 | 31.6375 | 305236.0 |
| 2015-03-25 09:30:00 | AAPL | Stock | 31.6725 | 31.705 | 31.5925 | 31.6075 | 4734716.0 |
| 2015-03-25 09:35:00 | AAPL | Stock | 31.605 | 31.615 | 31.53 | 31.5588 | 4462188.0 |
| 2015-03-25 09:40:00 | AAPL | Stock | 31.5575 | 31.6325 | 31.515 | 31.5862 | 3108684.0 |
| 2015-03-25 09:45:00 | AAPL | Stock | 31.5825 | 31.595 | 31.4475 | 31.4575 | 5589940.0 |
| 2015-03-25 09:50:00 | AAPL | Stock | 31.4575 | 31.4875 | 31.3975 | 31.4338 | 3969544.0 |
| 2015-03-25 09:55:00 | AAPL | Stock | 31.4328 | 31.45 | 31.3825 | 31.4375 | 3358476.0 |
| 2015-03-25 10:00:00 | AAPL | Stock | 31.4375 | 31.4388 | 31.3475 | 31.3525 | 4316776.0 |
| 2015-03-25 10:05:00 | AAPL | Stock | 31.3525 | 31.41 | 31.325 | 31.38 | 3426140.0 |
| 2015-03-25 10:10:00 | AAPL | Stock | 31.38 | 31.4475 | 31.3738 | 31.4025 | 2638880.0 |
| 2015-03-25 10:15:00 | AAPL | Stock | 31.4002 | 31.47 | 31.4 | 31.45 | 1743684.0 |
| 2015-03-25 10:20:00 | AAPL | Stock | 31.45 | 31.5225 | 31.4475 | 31.4968 | 2311004.0 |
| 2015-03-25 10:25:00 | AAPL | Stock | 31.4975 | 31.51 | 31.4625 | 31.4875 | 1685292.0 |
| 2015-03-25 10:30:00 | AAPL | Stock | 31.485 | 31.485 | 31.4375 | 31.4625 | 1365756.0 |
| 2015-03-25 10:35:00 | AAPL | Stock | 31.4638 | 31.4725 | 31.4125 | 31.425 | 1106840.0 |
| 2015-03-25 10:40:00 | AAPL | Stock | 31.425 | 31.4275 | 31.37 | 31.405 | 1881028.0 |
> showing 50 of 365,813 rows — these rows as CSV