PREVIEW / stock_5min / 2015-05-26
file: by_date/stock_5min/2015/2015-05-26.parquet size: 5.5 MB rows: 367,086 symbols: 3,512
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-05-26 04:00:00 | AAPL | Stock | 33.125 | 33.125 | 33.0 | 33.025 | 22360.0 |
| 2015-05-26 04:05:00 | AAPL | Stock | 33.0125 | 33.0275 | 33.0025 | 33.0275 | 5288.0 |
| 2015-05-26 04:10:00 | AAPL | Stock | 32.985 | 32.985 | 32.9425 | 32.95 | 12128.0 |
| 2015-05-26 04:15:00 | AAPL | Stock | 32.9425 | 32.975 | 32.9425 | 32.9625 | 5556.0 |
| 2015-05-26 04:20:00 | AAPL | Stock | 32.9625 | 32.9625 | 32.9625 | 32.9625 | 820.0 |
| 2015-05-26 04:25:00 | AAPL | Stock | 32.9475 | 32.9475 | 32.9475 | 32.9475 | 400.0 |
| 2015-05-26 04:40:00 | AAPL | Stock | 32.965 | 32.965 | 32.965 | 32.965 | 928.0 |
| 2015-05-26 04:50:00 | AAPL | Stock | 32.94 | 32.94 | 32.94 | 32.94 | 1200.0 |
| 2015-05-26 04:55:00 | AAPL | Stock | 32.97 | 32.9775 | 32.965 | 32.9775 | 5564.0 |
| 2015-05-26 05:05:00 | AAPL | Stock | 32.9975 | 33.0 | 32.9975 | 33.0 | 800.0 |
| 2015-05-26 05:10:00 | AAPL | Stock | 33.01 | 33.01 | 33.01 | 33.01 | 2168.0 |
| 2015-05-26 05:25:00 | AAPL | Stock | 33.01 | 33.01 | 33.01 | 33.01 | 400.0 |
| 2015-05-26 05:30:00 | AAPL | Stock | 33.0 | 33.01 | 33.0 | 33.01 | 40580.0 |
| 2015-05-26 05:45:00 | AAPL | Stock | 33.02 | 33.02 | 33.02 | 33.02 | 2400.0 |
| 2015-05-26 05:50:00 | AAPL | Stock | 33.005 | 33.005 | 33.005 | 33.005 | 400.0 |
| 2015-05-26 05:55:00 | AAPL | Stock | 33.0125 | 33.025 | 33.0125 | 33.025 | 912.0 |
| 2015-05-26 06:00:00 | AAPL | Stock | 33.025 | 33.0275 | 33.0125 | 33.0125 | 5600.0 |
| 2015-05-26 06:10:00 | AAPL | Stock | 33.0425 | 33.0425 | 33.035 | 33.035 | 800.0 |
| 2015-05-26 06:15:00 | AAPL | Stock | 33.0575 | 33.0575 | 33.0575 | 33.0575 | 400.0 |
| 2015-05-26 06:20:00 | AAPL | Stock | 33.0525 | 33.0575 | 33.05 | 33.05 | 7752.0 |
| 2015-05-26 06:30:00 | AAPL | Stock | 33.06 | 33.06 | 33.06 | 33.06 | 400.0 |
| 2015-05-26 06:35:00 | AAPL | Stock | 33.08 | 33.08 | 33.08 | 33.08 | 400.0 |
| 2015-05-26 06:45:00 | AAPL | Stock | 33.09 | 33.09 | 33.09 | 33.09 | 828.0 |
| 2015-05-26 06:50:00 | AAPL | Stock | 33.09 | 33.09 | 33.09 | 33.09 | 400.0 |
| 2015-05-26 06:55:00 | AAPL | Stock | 33.0925 | 33.0925 | 33.0925 | 33.0925 | 1600.0 |
| 2015-05-26 07:00:00 | AAPL | Stock | 33.0875 | 33.12 | 33.0825 | 33.12 | 27560.0 |
| 2015-05-26 07:05:00 | AAPL | Stock | 33.12 | 33.12 | 33.115 | 33.115 | 1600.0 |
| 2015-05-26 07:10:00 | AAPL | Stock | 33.11 | 33.11 | 33.1 | 33.1 | 4068.0 |
| 2015-05-26 07:15:00 | AAPL | Stock | 33.095 | 33.1 | 33.095 | 33.1 | 6868.0 |
| 2015-05-26 07:20:00 | AAPL | Stock | 33.0975 | 33.1 | 33.0975 | 33.1 | 800.0 |
| 2015-05-26 07:25:00 | AAPL | Stock | 33.1125 | 33.1125 | 33.1125 | 33.1125 | 400.0 |
| 2015-05-26 07:30:00 | AAPL | Stock | 33.1175 | 33.125 | 33.1125 | 33.1125 | 24500.0 |
| 2015-05-26 07:35:00 | AAPL | Stock | 33.1125 | 33.135 | 33.1125 | 33.1325 | 21596.0 |
| 2015-05-26 07:40:00 | AAPL | Stock | 33.135 | 33.15 | 33.135 | 33.135 | 8480.0 |
| 2015-05-26 07:45:00 | AAPL | Stock | 33.15 | 33.155 | 33.15 | 33.155 | 5192.0 |
| 2015-05-26 07:50:00 | AAPL | Stock | 33.1575 | 33.16 | 33.15 | 33.155 | 12200.0 |
| 2015-05-26 07:55:00 | AAPL | Stock | 33.14 | 33.14 | 33.1325 | 33.1325 | 5200.0 |
| 2015-05-26 08:00:00 | AAPL | Stock | 33.1475 | 33.165 | 33.03 | 33.1525 | 144052.0 |
| 2015-05-26 08:05:00 | AAPL | Stock | 33.165 | 33.185 | 33.165 | 33.17 | 70040.0 |
| 2015-05-26 08:10:00 | AAPL | Stock | 33.17 | 33.1925 | 33.17 | 33.1875 | 46612.0 |
| 2015-05-26 08:15:00 | AAPL | Stock | 33.1875 | 33.2075 | 33.175 | 33.2 | 32628.0 |
| 2015-05-26 08:20:00 | AAPL | Stock | 33.2 | 33.225 | 33.2 | 33.2 | 119312.0 |
| 2015-05-26 08:25:00 | AAPL | Stock | 33.2 | 33.21 | 33.195 | 33.205 | 45660.0 |
| 2015-05-26 08:30:00 | AAPL | Stock | 33.2025 | 33.225 | 33.185 | 33.205 | 107724.0 |
| 2015-05-26 08:35:00 | AAPL | Stock | 33.205 | 33.205 | 33.1775 | 33.195 | 48068.0 |
| 2015-05-26 08:40:00 | AAPL | Stock | 33.1775 | 33.2 | 33.1775 | 33.1875 | 155580.0 |
| 2015-05-26 08:45:00 | AAPL | Stock | 33.1825 | 33.1825 | 33.125 | 33.15 | 132872.0 |
| 2015-05-26 08:50:00 | AAPL | Stock | 33.1475 | 33.1825 | 33.1428 | 33.1825 | 33852.0 |
| 2015-05-26 08:55:00 | AAPL | Stock | 33.1772 | 33.195 | 33.1625 | 33.195 | 47936.0 |
| 2015-05-26 09:00:00 | AAPL | Stock | 33.1925 | 33.1925 | 33.1775 | 33.1825 | 38384.0 |
> showing 50 of 367,086 rows — these rows as CSV