PREVIEW / stock_5min / 2015-05-07
file: by_date/stock_5min/2015/2015-05-07.parquet size: 5.5 MB rows: 368,053 symbols: 3,510
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-07 04:00:00 | AAPL | Stock | 31.995 | 31.995 | 31.125 | 31.125 | 10984.0 |
| 2015-05-07 04:05:00 | AAPL | Stock | 31.2 | 31.2 | 31.2 | 31.2 | 400.0 |
| 2015-05-07 04:10:00 | AAPL | Stock | 31.1525 | 31.1525 | 31.1525 | 31.1525 | 6000.0 |
| 2015-05-07 04:20:00 | AAPL | Stock | 31.15 | 31.15 | 31.125 | 31.125 | 800.0 |
| 2015-05-07 04:25:00 | AAPL | Stock | 31.125 | 31.125 | 31.125 | 31.125 | 400.0 |
| 2015-05-07 04:30:00 | AAPL | Stock | 31.075 | 31.075 | 31.0625 | 31.0625 | 1200.0 |
| 2015-05-07 04:40:00 | AAPL | Stock | 31.045 | 31.045 | 31.045 | 31.045 | 400.0 |
| 2015-05-07 04:45:00 | AAPL | Stock | 31.015 | 31.015 | 31.0 | 31.0 | 24400.0 |
| 2015-05-07 04:50:00 | AAPL | Stock | 30.995 | 30.995 | 30.925 | 30.925 | 8000.0 |
| 2015-05-07 04:55:00 | AAPL | Stock | 30.9725 | 30.9725 | 30.9725 | 30.9725 | 4000.0 |
| 2015-05-07 05:00:00 | AAPL | Stock | 30.9575 | 30.9725 | 30.9575 | 30.9725 | 11860.0 |
| 2015-05-07 05:05:00 | AAPL | Stock | 30.9625 | 30.9625 | 30.9625 | 30.9625 | 400.0 |
| 2015-05-07 05:10:00 | AAPL | Stock | 30.925 | 30.925 | 30.925 | 30.925 | 1860.0 |
| 2015-05-07 05:15:00 | AAPL | Stock | 30.95 | 30.95 | 30.9 | 30.9 | 4400.0 |
| 2015-05-07 05:20:00 | AAPL | Stock | 30.85 | 30.875 | 30.815 | 30.875 | 10816.0 |
| 2015-05-07 05:25:00 | AAPL | Stock | 30.9525 | 30.955 | 30.895 | 30.895 | 8240.0 |
| 2015-05-07 05:35:00 | AAPL | Stock | 30.88 | 30.88 | 30.875 | 30.875 | 5496.0 |
| 2015-05-07 05:40:00 | AAPL | Stock | 30.875 | 30.9375 | 30.875 | 30.915 | 9792.0 |
| 2015-05-07 05:45:00 | AAPL | Stock | 30.875 | 30.875 | 30.875 | 30.875 | 1424.0 |
| 2015-05-07 05:50:00 | AAPL | Stock | 30.875 | 30.875 | 30.875 | 30.875 | 1172.0 |
| 2015-05-07 06:00:00 | AAPL | Stock | 31.0 | 31.0 | 31.0 | 31.0 | 3704.0 |
| 2015-05-07 06:05:00 | AAPL | Stock | 31.0 | 31.045 | 31.0 | 31.0 | 5320.0 |
| 2015-05-07 06:10:00 | AAPL | Stock | 31.0125 | 31.0125 | 30.925 | 30.925 | 19596.0 |
| 2015-05-07 06:15:00 | AAPL | Stock | 30.9675 | 30.9975 | 30.9675 | 30.975 | 11176.0 |
| 2015-05-07 06:20:00 | AAPL | Stock | 30.975 | 30.975 | 30.975 | 30.975 | 1720.0 |
| 2015-05-07 06:25:00 | AAPL | Stock | 30.9375 | 30.9725 | 30.9375 | 30.9725 | 1000.0 |
| 2015-05-07 06:30:00 | AAPL | Stock | 30.9325 | 30.9325 | 30.875 | 30.875 | 28504.0 |
| 2015-05-07 06:35:00 | AAPL | Stock | 30.8875 | 30.9725 | 30.85 | 30.855 | 15200.0 |
| 2015-05-07 06:40:00 | AAPL | Stock | 30.8875 | 30.9 | 30.865 | 30.9 | 5200.0 |
| 2015-05-07 06:50:00 | AAPL | Stock | 30.8875 | 30.9175 | 30.8875 | 30.9175 | 1700.0 |
| 2015-05-07 06:55:00 | AAPL | Stock | 30.92 | 30.92 | 30.86 | 30.915 | 25488.0 |
| 2015-05-07 07:00:00 | AAPL | Stock | 30.935 | 31.025 | 30.91 | 31.0125 | 32160.0 |
| 2015-05-07 07:05:00 | AAPL | Stock | 31.0 | 31.0 | 30.96 | 30.96 | 32616.0 |
| 2015-05-07 07:10:00 | AAPL | Stock | 30.975 | 31.0 | 30.975 | 31.0 | 18380.0 |
| 2015-05-07 07:15:00 | AAPL | Stock | 30.9875 | 31.0625 | 30.9875 | 31.05 | 14680.0 |
| 2015-05-07 07:20:00 | AAPL | Stock | 31.05 | 31.0725 | 31.025 | 31.025 | 28008.0 |
| 2015-05-07 07:25:00 | AAPL | Stock | 31.0275 | 31.0275 | 31.0275 | 31.0275 | 600.0 |
| 2015-05-07 07:30:00 | AAPL | Stock | 31.0325 | 31.0475 | 31.025 | 31.0475 | 4800.0 |
| 2015-05-07 07:35:00 | AAPL | Stock | 31.05 | 31.05 | 31.025 | 31.0275 | 15400.0 |
| 2015-05-07 07:40:00 | AAPL | Stock | 31.05 | 31.11 | 31.0375 | 31.11 | 18000.0 |
| 2015-05-07 07:45:00 | AAPL | Stock | 31.105 | 31.1075 | 31.0875 | 31.1 | 17600.0 |
| 2015-05-07 07:50:00 | AAPL | Stock | 31.1 | 31.1175 | 31.095 | 31.095 | 40024.0 |
| 2015-05-07 07:55:00 | AAPL | Stock | 31.1 | 31.1475 | 31.0925 | 31.1475 | 78744.0 |
| 2015-05-07 08:00:00 | AAPL | Stock | 31.1475 | 31.1875 | 30.91 | 31.1775 | 220684.0 |
| 2015-05-07 08:05:00 | AAPL | Stock | 31.185 | 31.2025 | 31.1375 | 31.1725 | 61940.0 |
| 2015-05-07 08:10:00 | AAPL | Stock | 31.175 | 31.225 | 31.175 | 31.1975 | 68864.0 |
| 2015-05-07 08:15:00 | AAPL | Stock | 31.1975 | 31.2075 | 31.1725 | 31.175 | 17076.0 |
| 2015-05-07 08:20:00 | AAPL | Stock | 31.185 | 31.1975 | 31.1575 | 31.1675 | 59308.0 |
| 2015-05-07 08:25:00 | AAPL | Stock | 31.165 | 31.18 | 31.16 | 31.16 | 40200.0 |
| 2015-05-07 08:30:00 | AAPL | Stock | 31.1525 | 31.1575 | 31.1 | 31.135 | 99332.0 |
> showing 50 of 368,053 rows — these rows as CSV