PREVIEW / stock_5min / 2015-06-12
file: by_date/stock_5min/2015/2015-06-12.parquet size: 5.3 MB rows: 353,486 symbols: 3,486
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-06-12 04:00:00 | AAPL | Stock | 32.1875 | 32.1975 | 32.055 | 32.1975 | 1732.0 |
| 2015-06-12 04:25:00 | AAPL | Stock | 32.0625 | 32.0625 | 32.0625 | 32.0625 | 400.0 |
| 2015-06-12 04:45:00 | AAPL | Stock | 32.0625 | 32.0625 | 32.0625 | 32.0625 | 400.0 |
| 2015-06-12 04:55:00 | AAPL | Stock | 32.0625 | 32.0625 | 32.0375 | 32.0375 | 3440.0 |
| 2015-06-12 05:40:00 | AAPL | Stock | 32.0725 | 32.0725 | 32.0725 | 32.0725 | 2000.0 |
| 2015-06-12 05:45:00 | AAPL | Stock | 32.0975 | 32.0975 | 32.0975 | 32.0975 | 1200.0 |
| 2015-06-12 05:55:00 | AAPL | Stock | 32.12 | 32.12 | 32.12 | 32.12 | 1908.0 |
| 2015-06-12 06:00:00 | AAPL | Stock | 32.135 | 32.135 | 32.135 | 32.135 | 800.0 |
| 2015-06-12 06:05:00 | AAPL | Stock | 32.1475 | 32.185 | 32.1375 | 32.1375 | 4800.0 |
| 2015-06-12 06:25:00 | AAPL | Stock | 32.1625 | 32.1625 | 32.1625 | 32.1625 | 1300.0 |
| 2015-06-12 06:30:00 | AAPL | Stock | 32.125 | 32.125 | 32.125 | 32.125 | 6000.0 |
| 2015-06-12 06:40:00 | AAPL | Stock | 32.1375 | 32.1375 | 32.125 | 32.125 | 1000.0 |
| 2015-06-12 06:50:00 | AAPL | Stock | 32.1025 | 32.1025 | 32.1025 | 32.1025 | 1200.0 |
| 2015-06-12 06:55:00 | AAPL | Stock | 32.1225 | 32.1225 | 32.1225 | 32.1225 | 404.0 |
| 2015-06-12 07:05:00 | AAPL | Stock | 32.1075 | 32.1075 | 32.1 | 32.1 | 10800.0 |
| 2015-06-12 07:10:00 | AAPL | Stock | 32.0975 | 32.0975 | 32.0925 | 32.0925 | 2400.0 |
| 2015-06-12 07:15:00 | AAPL | Stock | 32.1075 | 32.1075 | 32.1075 | 32.1075 | 4400.0 |
| 2015-06-12 07:20:00 | AAPL | Stock | 32.1075 | 32.1075 | 32.09 | 32.0925 | 9016.0 |
| 2015-06-12 07:25:00 | AAPL | Stock | 32.1025 | 32.1075 | 32.0925 | 32.0925 | 5176.0 |
| 2015-06-12 07:30:00 | AAPL | Stock | 32.0925 | 32.0925 | 32.075 | 32.075 | 17524.0 |
| 2015-06-12 07:35:00 | AAPL | Stock | 32.0725 | 32.0725 | 32.0625 | 32.0625 | 7196.0 |
| 2015-06-12 07:40:00 | AAPL | Stock | 32.0625 | 32.0625 | 32.05 | 32.0525 | 16000.0 |
| 2015-06-12 07:45:00 | AAPL | Stock | 32.06 | 32.0625 | 32.06 | 32.06 | 10000.0 |
| 2015-06-12 07:50:00 | AAPL | Stock | 32.0725 | 32.075 | 32.07 | 32.07 | 7600.0 |
| 2015-06-12 07:55:00 | AAPL | Stock | 32.0725 | 32.075 | 32.065 | 32.075 | 6704.0 |
| 2015-06-12 08:00:00 | AAPL | Stock | 32.09 | 32.1225 | 32.0525 | 32.0825 | 79948.0 |
| 2015-06-12 08:05:00 | AAPL | Stock | 32.08 | 32.11 | 32.0775 | 32.1025 | 31160.0 |
| 2015-06-12 08:10:00 | AAPL | Stock | 32.09 | 32.11 | 32.09 | 32.1075 | 19328.0 |
| 2015-06-12 08:15:00 | AAPL | Stock | 32.115 | 32.125 | 32.1125 | 32.12 | 28352.0 |
| 2015-06-12 08:20:00 | AAPL | Stock | 32.12 | 32.12 | 32.1 | 32.1 | 79764.0 |
| 2015-06-12 08:25:00 | AAPL | Stock | 32.1 | 32.1 | 32.0925 | 32.1 | 13952.0 |
| 2015-06-12 08:30:00 | AAPL | Stock | 32.0925 | 32.095 | 32.08 | 32.08 | 62600.0 |
| 2015-06-12 08:35:00 | AAPL | Stock | 32.0825 | 32.1 | 32.0825 | 32.1 | 16500.0 |
| 2015-06-12 08:40:00 | AAPL | Stock | 32.0992 | 32.0992 | 32.0825 | 32.0858 | 11696.0 |
| 2015-06-12 08:45:00 | AAPL | Stock | 32.0925 | 32.0925 | 32.0775 | 32.08 | 28632.0 |
| 2015-06-12 08:50:00 | AAPL | Stock | 32.0825 | 32.085 | 32.0675 | 32.075 | 16200.0 |
| 2015-06-12 08:55:00 | AAPL | Stock | 32.075 | 32.08 | 32.0675 | 32.0675 | 19248.0 |
| 2015-06-12 09:00:00 | AAPL | Stock | 32.0725 | 32.08 | 32.0675 | 32.08 | 27600.0 |
| 2015-06-12 09:05:00 | AAPL | Stock | 32.075 | 32.0825 | 32.0525 | 32.06 | 120972.0 |
| 2015-06-12 09:10:00 | AAPL | Stock | 32.0525 | 32.06 | 32.0325 | 32.05 | 61620.0 |
| 2015-06-12 09:15:00 | AAPL | Stock | 32.05 | 32.05 | 32.0425 | 32.0425 | 33984.0 |
| 2015-06-12 09:20:00 | AAPL | Stock | 32.0475 | 32.0575 | 32.045 | 32.055 | 20660.0 |
| 2015-06-12 09:25:00 | AAPL | Stock | 32.055 | 32.06 | 32.0275 | 32.0375 | 56092.0 |
| 2015-06-12 09:30:00 | AAPL | Stock | 32.04 | 32.0525 | 31.925 | 32.0175 | 6479132.0 |
| 2015-06-12 09:35:00 | AAPL | Stock | 32.0175 | 32.035 | 31.955 | 31.965 | 4336840.0 |
| 2015-06-12 09:40:00 | AAPL | Stock | 31.9625 | 32.0 | 31.9375 | 31.9425 | 2894860.0 |
| 2015-06-12 09:45:00 | AAPL | Stock | 31.94 | 32.0175 | 31.93 | 31.985 | 3317396.0 |
| 2015-06-12 09:50:00 | AAPL | Stock | 31.9875 | 32.0075 | 31.95 | 31.975 | 2452588.0 |
| 2015-06-12 09:55:00 | AAPL | Stock | 31.9725 | 32.0012 | 31.9575 | 31.98 | 1543096.0 |
| 2015-06-12 10:00:00 | AAPL | Stock | 31.9825 | 32.0595 | 31.957 | 32.04 | 3567768.0 |
> showing 50 of 353,486 rows — these rows as CSV