PREVIEW / stock_5min / 2015-08-25
file: by_date/stock_5min/2015/2015-08-25.parquet size: 5.8 MB rows: 383,525 symbols: 3,497
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-08-25 04:00:00 | AAPL | Stock | 26.4575 | 27.0 | 26.4575 | 27.0 | 29880.0 |
| 2015-08-25 04:05:00 | AAPL | Stock | 26.975 | 26.975 | 26.9025 | 26.95 | 24640.0 |
| 2015-08-25 04:10:00 | AAPL | Stock | 26.9 | 26.95 | 26.8625 | 26.8625 | 17700.0 |
| 2015-08-25 04:15:00 | AAPL | Stock | 26.8475 | 26.855 | 26.825 | 26.855 | 16716.0 |
| 2015-08-25 04:20:00 | AAPL | Stock | 26.9275 | 27.05 | 26.925 | 26.975 | 10016.0 |
| 2015-08-25 04:25:00 | AAPL | Stock | 26.975 | 27.0625 | 26.975 | 27.0625 | 5396.0 |
| 2015-08-25 04:30:00 | AAPL | Stock | 27.02 | 27.0875 | 27.02 | 27.0875 | 11704.0 |
| 2015-08-25 04:35:00 | AAPL | Stock | 27.0875 | 27.0875 | 27.02 | 27.02 | 17120.0 |
| 2015-08-25 04:40:00 | AAPL | Stock | 27.02 | 27.02 | 26.955 | 27.0 | 4600.0 |
| 2015-08-25 04:45:00 | AAPL | Stock | 27.0025 | 27.0025 | 26.9825 | 26.9825 | 9080.0 |
| 2015-08-25 04:50:00 | AAPL | Stock | 27.0375 | 27.0375 | 26.9875 | 27.0375 | 9440.0 |
| 2015-08-25 04:55:00 | AAPL | Stock | 27.0375 | 27.05 | 27.015 | 27.05 | 6924.0 |
| 2015-08-25 05:00:00 | AAPL | Stock | 27.05 | 27.0675 | 27.0 | 27.0375 | 13988.0 |
| 2015-08-25 05:05:00 | AAPL | Stock | 27.0375 | 27.0625 | 27.0 | 27.0025 | 8400.0 |
| 2015-08-25 05:10:00 | AAPL | Stock | 27.0 | 27.0 | 26.9625 | 26.9625 | 6712.0 |
| 2015-08-25 05:15:00 | AAPL | Stock | 26.9625 | 27.03 | 26.9625 | 26.9625 | 30104.0 |
| 2015-08-25 05:20:00 | AAPL | Stock | 27.025 | 27.025 | 26.9925 | 27.025 | 31892.0 |
| 2015-08-25 05:25:00 | AAPL | Stock | 27.025 | 27.025 | 27.025 | 27.025 | 6112.0 |
| 2015-08-25 05:30:00 | AAPL | Stock | 27.02 | 27.1675 | 27.02 | 27.1675 | 7200.0 |
| 2015-08-25 05:35:00 | AAPL | Stock | 27.1725 | 27.175 | 27.1075 | 27.12 | 7936.0 |
| 2015-08-25 05:40:00 | AAPL | Stock | 27.1075 | 27.1075 | 27.105 | 27.1075 | 7600.0 |
| 2015-08-25 05:45:00 | AAPL | Stock | 27.1125 | 27.1125 | 27.0275 | 27.075 | 24480.0 |
| 2015-08-25 05:50:00 | AAPL | Stock | 27.025 | 27.0625 | 27.0 | 27.025 | 13044.0 |
| 2015-08-25 05:55:00 | AAPL | Stock | 27.0025 | 27.0625 | 27.0 | 27.025 | 21288.0 |
| 2015-08-25 06:00:00 | AAPL | Stock | 27.1125 | 27.1125 | 27.075 | 27.0775 | 16992.0 |
| 2015-08-25 06:05:00 | AAPL | Stock | 27.0775 | 27.15 | 27.0625 | 27.125 | 81256.0 |
| 2015-08-25 06:10:00 | AAPL | Stock | 27.125 | 27.125 | 27.04 | 27.075 | 38320.0 |
| 2015-08-25 06:15:00 | AAPL | Stock | 27.095 | 27.325 | 27.0625 | 27.325 | 60828.0 |
| 2015-08-25 06:20:00 | AAPL | Stock | 27.3325 | 27.5575 | 27.3325 | 27.3325 | 132980.0 |
| 2015-08-25 06:25:00 | AAPL | Stock | 27.375 | 27.5 | 27.345 | 27.41 | 162320.0 |
| 2015-08-25 06:30:00 | AAPL | Stock | 27.41 | 27.4325 | 27.375 | 27.425 | 84788.0 |
| 2015-08-25 06:35:00 | AAPL | Stock | 27.425 | 27.45 | 27.325 | 27.4325 | 120444.0 |
| 2015-08-25 06:40:00 | AAPL | Stock | 27.44 | 27.4875 | 27.4 | 27.4525 | 85608.0 |
| 2015-08-25 06:45:00 | AAPL | Stock | 27.465 | 27.4775 | 27.4375 | 27.44 | 176712.0 |
| 2015-08-25 06:50:00 | AAPL | Stock | 27.44 | 27.4625 | 27.4025 | 27.4125 | 41916.0 |
| 2015-08-25 06:55:00 | AAPL | Stock | 27.415 | 27.425 | 27.3275 | 27.35 | 134832.0 |
| 2015-08-25 07:00:00 | AAPL | Stock | 27.35 | 27.425 | 27.35 | 27.425 | 127576.0 |
| 2015-08-25 07:05:00 | AAPL | Stock | 27.415 | 27.4375 | 27.345 | 27.3625 | 136884.0 |
| 2015-08-25 07:10:00 | AAPL | Stock | 27.375 | 27.41 | 27.305 | 27.4 | 52376.0 |
| 2015-08-25 07:15:00 | AAPL | Stock | 27.3775 | 27.3925 | 27.3425 | 27.3625 | 60840.0 |
| 2015-08-25 07:20:00 | AAPL | Stock | 27.3625 | 27.4025 | 27.335 | 27.3875 | 99748.0 |
| 2015-08-25 07:25:00 | AAPL | Stock | 27.375 | 27.375 | 27.2775 | 27.2775 | 109080.0 |
| 2015-08-25 07:30:00 | AAPL | Stock | 27.28 | 27.305 | 27.2775 | 27.305 | 108828.0 |
| 2015-08-25 07:35:00 | AAPL | Stock | 27.32 | 27.35 | 27.29 | 27.345 | 40196.0 |
| 2015-08-25 07:40:00 | AAPL | Stock | 27.3475 | 27.3625 | 27.34 | 27.3525 | 38300.0 |
| 2015-08-25 07:45:00 | AAPL | Stock | 27.3525 | 27.3625 | 27.265 | 27.265 | 113340.0 |
| 2015-08-25 07:50:00 | AAPL | Stock | 27.265 | 27.285 | 27.2525 | 27.2825 | 128520.0 |
| 2015-08-25 07:55:00 | AAPL | Stock | 27.29 | 27.3175 | 27.275 | 27.285 | 104440.0 |
| 2015-08-25 08:00:00 | AAPL | Stock | 27.285 | 27.5 | 27.0675 | 27.3268 | 736084.0 |
| 2015-08-25 08:05:00 | AAPL | Stock | 27.325 | 27.3275 | 27.175 | 27.175 | 339116.0 |
> showing 50 of 383,525 rows — these rows as CSV