PREVIEW / stock_5min / 2015-04-24
file: by_date/stock_5min/2015/2015-04-24.parquet size: 5.3 MB rows: 351,881 symbols: 3,520
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-04-24 04:00:00 | AAPL | Stock | 32.625 | 32.635 | 32.5225 | 32.6275 | 18400.0 |
| 2015-04-24 04:05:00 | AAPL | Stock | 32.6275 | 32.6275 | 32.6275 | 32.6275 | 1600.0 |
| 2015-04-24 04:10:00 | AAPL | Stock | 32.625 | 32.625 | 32.6025 | 32.6025 | 4000.0 |
| 2015-04-24 04:15:00 | AAPL | Stock | 32.5925 | 32.5925 | 32.59 | 32.59 | 7056.0 |
| 2015-04-24 04:20:00 | AAPL | Stock | 32.59 | 32.6125 | 32.59 | 32.6125 | 5200.0 |
| 2015-04-24 04:25:00 | AAPL | Stock | 32.6125 | 32.6125 | 32.605 | 32.605 | 1336.0 |
| 2015-04-24 04:30:00 | AAPL | Stock | 32.59 | 32.59 | 32.59 | 32.59 | 2000.0 |
| 2015-04-24 04:40:00 | AAPL | Stock | 32.6125 | 32.6125 | 32.59 | 32.59 | 6136.0 |
| 2015-04-24 04:45:00 | AAPL | Stock | 32.6125 | 32.6125 | 32.6125 | 32.6125 | 3836.0 |
| 2015-04-24 04:50:00 | AAPL | Stock | 32.59 | 32.59 | 32.59 | 32.59 | 1884.0 |
| 2015-04-24 05:15:00 | AAPL | Stock | 32.59 | 32.59 | 32.59 | 32.59 | 400.0 |
| 2015-04-24 05:20:00 | AAPL | Stock | 32.59 | 32.59 | 32.59 | 32.59 | 800.0 |
| 2015-04-24 05:30:00 | AAPL | Stock | 32.59 | 32.59 | 32.59 | 32.59 | 2000.0 |
| 2015-04-24 05:35:00 | AAPL | Stock | 32.59 | 32.59 | 32.585 | 32.585 | 15172.0 |
| 2015-04-24 05:45:00 | AAPL | Stock | 32.5625 | 32.5625 | 32.5625 | 32.5625 | 6956.0 |
| 2015-04-24 05:55:00 | AAPL | Stock | 32.5525 | 32.5525 | 32.55 | 32.55 | 6800.0 |
| 2015-04-24 06:00:00 | AAPL | Stock | 32.5275 | 32.5625 | 32.525 | 32.5625 | 7600.0 |
| 2015-04-24 06:05:00 | AAPL | Stock | 32.55 | 32.55 | 32.5 | 32.5 | 9600.0 |
| 2015-04-24 06:10:00 | AAPL | Stock | 32.505 | 32.505 | 32.5 | 32.5 | 800.0 |
| 2015-04-24 06:15:00 | AAPL | Stock | 32.5 | 32.5125 | 32.5 | 32.5125 | 11276.0 |
| 2015-04-24 06:30:00 | AAPL | Stock | 32.525 | 32.5425 | 32.525 | 32.5425 | 800.0 |
| 2015-04-24 06:35:00 | AAPL | Stock | 32.545 | 32.545 | 32.5125 | 32.5125 | 2800.0 |
| 2015-04-24 06:40:00 | AAPL | Stock | 32.54 | 32.54 | 32.54 | 32.54 | 424.0 |
| 2015-04-24 06:45:00 | AAPL | Stock | 32.545 | 32.545 | 32.545 | 32.545 | 464.0 |
| 2015-04-24 06:50:00 | AAPL | Stock | 32.5275 | 32.5425 | 32.5275 | 32.5275 | 4668.0 |
| 2015-04-24 06:55:00 | AAPL | Stock | 32.5425 | 32.55 | 32.5425 | 32.55 | 13436.0 |
| 2015-04-24 07:00:00 | AAPL | Stock | 32.56 | 32.5625 | 32.535 | 32.5625 | 24364.0 |
| 2015-04-24 07:05:00 | AAPL | Stock | 32.555 | 32.555 | 32.55 | 32.55 | 4332.0 |
| 2015-04-24 07:10:00 | AAPL | Stock | 32.56 | 32.56 | 32.55 | 32.56 | 11852.0 |
| 2015-04-24 07:15:00 | AAPL | Stock | 32.56 | 32.575 | 32.56 | 32.5625 | 14208.0 |
| 2015-04-24 07:20:00 | AAPL | Stock | 32.575 | 32.595 | 32.575 | 32.595 | 24716.0 |
| 2015-04-24 07:25:00 | AAPL | Stock | 32.5975 | 32.6125 | 32.5875 | 32.61 | 21360.0 |
| 2015-04-24 07:30:00 | AAPL | Stock | 32.6075 | 32.6075 | 32.575 | 32.5825 | 19380.0 |
| 2015-04-24 07:35:00 | AAPL | Stock | 32.585 | 32.585 | 32.525 | 32.5275 | 23304.0 |
| 2015-04-24 07:40:00 | AAPL | Stock | 32.535 | 32.5425 | 32.525 | 32.54 | 12592.0 |
| 2015-04-24 07:45:00 | AAPL | Stock | 32.55 | 32.56 | 32.55 | 32.56 | 3828.0 |
| 2015-04-24 07:50:00 | AAPL | Stock | 32.555 | 32.56 | 32.54 | 32.55 | 14608.0 |
| 2015-04-24 07:55:00 | AAPL | Stock | 32.55 | 32.5625 | 32.55 | 32.5625 | 7600.0 |
| 2015-04-24 08:00:00 | AAPL | Stock | 32.5625 | 32.6125 | 32.5025 | 32.575 | 177832.0 |
| 2015-04-24 08:05:00 | AAPL | Stock | 32.585 | 32.6125 | 32.585 | 32.605 | 117576.0 |
| 2015-04-24 08:10:00 | AAPL | Stock | 32.6052 | 32.62 | 32.605 | 32.6198 | 73256.0 |
| 2015-04-24 08:15:00 | AAPL | Stock | 32.6175 | 32.625 | 32.615 | 32.62 | 50524.0 |
| 2015-04-24 08:20:00 | AAPL | Stock | 32.6225 | 32.625 | 32.6125 | 32.6125 | 75980.0 |
| 2015-04-24 08:25:00 | AAPL | Stock | 32.615 | 32.62 | 32.6075 | 32.6125 | 43496.0 |
| 2015-04-24 08:30:00 | AAPL | Stock | 32.6 | 32.6125 | 32.59 | 32.5975 | 67056.0 |
| 2015-04-24 08:35:00 | AAPL | Stock | 32.6 | 32.6075 | 32.59 | 32.5975 | 137032.0 |
| 2015-04-24 08:40:00 | AAPL | Stock | 32.605 | 32.6075 | 32.6 | 32.605 | 59816.0 |
| 2015-04-24 08:45:00 | AAPL | Stock | 32.6025 | 32.6125 | 32.6 | 32.605 | 67568.0 |
| 2015-04-24 08:50:00 | AAPL | Stock | 32.605 | 32.62 | 32.605 | 32.62 | 130552.0 |
| 2015-04-24 08:55:00 | AAPL | Stock | 32.62 | 32.625 | 32.6175 | 32.6225 | 50856.0 |
> showing 50 of 351,881 rows — these rows as CSV