PREVIEW / stock_5min / 2016-08-12
file: by_date/stock_5min/2016/2016-08-12.parquet size: 5.2 MB rows: 346,874 symbols: 3,245
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-08-12 04:20:00 | AAPL | Stock | 27.03 | 27.04 | 27.03 | 27.04 | 2604.0 |
| 2016-08-12 04:25:00 | AAPL | Stock | 27.04 | 27.0425 | 27.04 | 27.0425 | 2032.0 |
| 2016-08-12 04:50:00 | AAPL | Stock | 27.0175 | 27.0175 | 27.0175 | 27.0175 | 800.0 |
| 2016-08-12 05:55:00 | AAPL | Stock | 27.0225 | 27.0225 | 27.0225 | 27.0225 | 400.0 |
| 2016-08-12 06:45:00 | AAPL | Stock | 27.025 | 27.025 | 27.025 | 27.025 | 400.0 |
| 2016-08-12 07:05:00 | AAPL | Stock | 27.025 | 27.025 | 27.025 | 27.025 | 700.0 |
| 2016-08-12 07:15:00 | AAPL | Stock | 27.01 | 27.01 | 27.01 | 27.01 | 536.0 |
| 2016-08-12 07:20:00 | AAPL | Stock | 27.0 | 27.0 | 27.0 | 27.0 | 756.0 |
| 2016-08-12 07:30:00 | AAPL | Stock | 27.025 | 27.025 | 27.025 | 27.025 | 4000.0 |
| 2016-08-12 07:40:00 | AAPL | Stock | 27.025 | 27.025 | 27.025 | 27.025 | 400.0 |
| 2016-08-12 07:45:00 | AAPL | Stock | 27.025 | 27.025 | 27.025 | 27.025 | 2000.0 |
| 2016-08-12 07:50:00 | AAPL | Stock | 27.025 | 27.025 | 27.025 | 27.025 | 400.0 |
| 2016-08-12 07:55:00 | AAPL | Stock | 27.025 | 27.025 | 27.025 | 27.025 | 2000.0 |
| 2016-08-12 08:00:00 | AAPL | Stock | 27.0425 | 27.05 | 27.0025 | 27.045 | 44716.0 |
| 2016-08-12 08:05:00 | AAPL | Stock | 27.045 | 27.045 | 27.0425 | 27.045 | 16040.0 |
| 2016-08-12 08:10:00 | AAPL | Stock | 27.0425 | 27.045 | 27.0425 | 27.045 | 1400.0 |
| 2016-08-12 08:15:00 | AAPL | Stock | 27.0425 | 27.0425 | 27.0425 | 27.0425 | 980.0 |
| 2016-08-12 08:20:00 | AAPL | Stock | 27.04 | 27.0425 | 27.04 | 27.04 | 9200.0 |
| 2016-08-12 08:25:00 | AAPL | Stock | 27.04 | 27.04 | 27.04 | 27.04 | 3200.0 |
| 2016-08-12 08:30:00 | AAPL | Stock | 27.05 | 27.055 | 27.04 | 27.04 | 41440.0 |
| 2016-08-12 08:35:00 | AAPL | Stock | 27.04 | 27.05 | 27.04 | 27.04 | 32992.0 |
| 2016-08-12 08:40:00 | AAPL | Stock | 27.04 | 27.045 | 27.04 | 27.04 | 71200.0 |
| 2016-08-12 08:45:00 | AAPL | Stock | 27.04 | 27.0475 | 27.04 | 27.0475 | 36364.0 |
| 2016-08-12 08:50:00 | AAPL | Stock | 27.05 | 27.05 | 27.045 | 27.0475 | 3420.0 |
| 2016-08-12 08:55:00 | AAPL | Stock | 27.045 | 27.045 | 27.04 | 27.04 | 9996.0 |
| 2016-08-12 09:00:00 | AAPL | Stock | 27.0425 | 27.0425 | 27.04 | 27.04 | 4880.0 |
| 2016-08-12 09:05:00 | AAPL | Stock | 27.04 | 27.04 | 27.04 | 27.04 | 3200.0 |
| 2016-08-12 09:10:00 | AAPL | Stock | 27.04 | 27.045 | 27.04 | 27.0425 | 25284.0 |
| 2016-08-12 09:15:00 | AAPL | Stock | 27.045 | 27.05 | 27.04 | 27.04 | 53144.0 |
| 2016-08-12 09:20:00 | AAPL | Stock | 27.045 | 27.05 | 27.04 | 27.04 | 26624.0 |
| 2016-08-12 09:25:00 | AAPL | Stock | 27.04 | 27.04 | 26.945 | 26.95 | 539404.0 |
| 2016-08-12 09:30:00 | AAPL | Stock | 26.945 | 27.06 | 26.9425 | 27.05 | 5167444.0 |
| 2016-08-12 09:35:00 | AAPL | Stock | 27.05 | 27.085 | 27.0375 | 27.0625 | 2690540.0 |
| 2016-08-12 09:40:00 | AAPL | Stock | 27.06 | 27.1 | 27.06 | 27.08 | 1774700.0 |
| 2016-08-12 09:45:00 | AAPL | Stock | 27.0825 | 27.0875 | 27.02 | 27.0575 | 1636556.0 |
| 2016-08-12 09:50:00 | AAPL | Stock | 27.0575 | 27.0725 | 27.0425 | 27.05 | 1513744.0 |
| 2016-08-12 09:55:00 | AAPL | Stock | 27.0478 | 27.07 | 27.0452 | 27.055 | 1057900.0 |
| 2016-08-12 10:00:00 | AAPL | Stock | 27.0562 | 27.065 | 27.03 | 27.03 | 1021488.0 |
| 2016-08-12 10:05:00 | AAPL | Stock | 27.03 | 27.0525 | 27.005 | 27.035 | 1652704.0 |
| 2016-08-12 10:10:00 | AAPL | Stock | 27.035 | 27.065 | 27.0225 | 27.0525 | 969760.0 |
| 2016-08-12 10:15:00 | AAPL | Stock | 27.0525 | 27.0575 | 27.04 | 27.0512 | 846972.0 |
| 2016-08-12 10:20:00 | AAPL | Stock | 27.05 | 27.07 | 27.035 | 27.07 | 1098144.0 |
| 2016-08-12 10:25:00 | AAPL | Stock | 27.0688 | 27.075 | 27.0575 | 27.06 | 843876.0 |
| 2016-08-12 10:30:00 | AAPL | Stock | 27.0612 | 27.0688 | 27.0525 | 27.053 | 751872.0 |
| 2016-08-12 10:35:00 | AAPL | Stock | 27.0535 | 27.0612 | 27.035 | 27.0522 | 797628.0 |
| 2016-08-12 10:40:00 | AAPL | Stock | 27.0502 | 27.0625 | 27.0362 | 27.0575 | 948764.0 |
| 2016-08-12 10:45:00 | AAPL | Stock | 27.0612 | 27.09 | 27.05 | 27.0825 | 1127480.0 |
| 2016-08-12 10:50:00 | AAPL | Stock | 27.0825 | 27.1025 | 27.0725 | 27.1 | 1091336.0 |
| 2016-08-12 10:55:00 | AAPL | Stock | 27.1025 | 27.11 | 27.0925 | 27.095 | 977724.0 |
| 2016-08-12 11:00:00 | AAPL | Stock | 27.095 | 27.0975 | 27.0825 | 27.0925 | 742916.0 |
> showing 50 of 346,874 rows — these rows as CSV