PREVIEW / stock_5min / 2015-01-29
file: by_date/stock_5min/2015/2015-01-29.parquet size: 5.5 MB rows: 363,620 symbols: 3,513
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-01-29 04:00:00 | AAPL | Stock | 28.9275 | 28.9275 | 28.9275 | 28.9275 | 400.0 |
| 2015-01-29 04:15:00 | AAPL | Stock | 29.05 | 29.0875 | 29.05 | 29.0875 | 3600.0 |
| 2015-01-29 04:25:00 | AAPL | Stock | 29.0625 | 29.0625 | 29.0625 | 29.0625 | 800.0 |
| 2015-01-29 04:50:00 | AAPL | Stock | 29.05 | 29.05 | 29.05 | 29.05 | 6640.0 |
| 2015-01-29 05:00:00 | AAPL | Stock | 29.05 | 29.05 | 29.05 | 29.05 | 2716.0 |
| 2015-01-29 05:10:00 | AAPL | Stock | 29.05 | 29.05 | 29.05 | 29.05 | 400.0 |
| 2015-01-29 05:15:00 | AAPL | Stock | 29.0025 | 29.0025 | 29.0 | 29.0 | 3220.0 |
| 2015-01-29 05:20:00 | AAPL | Stock | 29.05 | 29.05 | 29.05 | 29.05 | 10400.0 |
| 2015-01-29 05:25:00 | AAPL | Stock | 29.05 | 29.05 | 29.05 | 29.05 | 4400.0 |
| 2015-01-29 05:30:00 | AAPL | Stock | 29.05 | 29.05 | 29.05 | 29.05 | 12900.0 |
| 2015-01-29 05:35:00 | AAPL | Stock | 29.05 | 29.05 | 29.05 | 29.05 | 400.0 |
| 2015-01-29 05:40:00 | AAPL | Stock | 29.005 | 29.0125 | 29.0 | 29.0 | 5400.0 |
| 2015-01-29 05:45:00 | AAPL | Stock | 29.0325 | 29.0325 | 29.0325 | 29.0325 | 400.0 |
| 2015-01-29 05:50:00 | AAPL | Stock | 29.045 | 29.0475 | 29.0 | 29.0 | 4800.0 |
| 2015-01-29 06:00:00 | AAPL | Stock | 29.0475 | 29.0475 | 29.0475 | 29.0475 | 3900.0 |
| 2015-01-29 06:05:00 | AAPL | Stock | 29.0475 | 29.05 | 29.0375 | 29.05 | 6656.0 |
| 2015-01-29 06:10:00 | AAPL | Stock | 29.0275 | 29.045 | 29.025 | 29.045 | 10656.0 |
| 2015-01-29 06:15:00 | AAPL | Stock | 29.045 | 29.0475 | 29.025 | 29.025 | 4648.0 |
| 2015-01-29 06:20:00 | AAPL | Stock | 29.0275 | 29.045 | 29.0275 | 29.045 | 13308.0 |
| 2015-01-29 06:25:00 | AAPL | Stock | 29.0425 | 29.05 | 29.025 | 29.05 | 17804.0 |
| 2015-01-29 06:30:00 | AAPL | Stock | 29.045 | 29.05 | 29.0375 | 29.0375 | 9912.0 |
| 2015-01-29 06:35:00 | AAPL | Stock | 29.0375 | 29.05 | 29.0375 | 29.045 | 36784.0 |
| 2015-01-29 06:40:00 | AAPL | Stock | 29.0375 | 29.0475 | 29.0375 | 29.0475 | 12304.0 |
| 2015-01-29 06:45:00 | AAPL | Stock | 29.0475 | 29.0475 | 29.0475 | 29.0475 | 10096.0 |
| 2015-01-29 06:50:00 | AAPL | Stock | 29.0475 | 29.0475 | 29.0475 | 29.0475 | 27640.0 |
| 2015-01-29 06:55:00 | AAPL | Stock | 29.045 | 29.0475 | 29.0425 | 29.0425 | 26800.0 |
| 2015-01-29 07:00:00 | AAPL | Stock | 29.0475 | 29.075 | 29.0475 | 29.0625 | 98444.0 |
| 2015-01-29 07:05:00 | AAPL | Stock | 29.075 | 29.125 | 29.075 | 29.1 | 39992.0 |
| 2015-01-29 07:10:00 | AAPL | Stock | 29.0875 | 29.1225 | 29.0525 | 29.1225 | 38500.0 |
| 2015-01-29 07:15:00 | AAPL | Stock | 29.1075 | 29.1225 | 29.0925 | 29.0925 | 36228.0 |
| 2015-01-29 07:20:00 | AAPL | Stock | 29.08 | 29.08 | 29.075 | 29.075 | 17300.0 |
| 2015-01-29 07:25:00 | AAPL | Stock | 29.0875 | 29.0875 | 29.075 | 29.075 | 15920.0 |
| 2015-01-29 07:30:00 | AAPL | Stock | 29.075 | 29.0775 | 29.075 | 29.0775 | 24800.0 |
| 2015-01-29 07:35:00 | AAPL | Stock | 29.0775 | 29.0875 | 29.0775 | 29.085 | 20204.0 |
| 2015-01-29 07:40:00 | AAPL | Stock | 29.0525 | 29.055 | 29.045 | 29.045 | 17940.0 |
| 2015-01-29 07:45:00 | AAPL | Stock | 29.045 | 29.05 | 29.005 | 29.05 | 13200.0 |
| 2015-01-29 07:50:00 | AAPL | Stock | 29.05 | 29.0525 | 29.0375 | 29.05 | 8800.0 |
| 2015-01-29 07:55:00 | AAPL | Stock | 29.05 | 29.05 | 29.0175 | 29.0175 | 10200.0 |
| 2015-01-29 08:00:00 | AAPL | Stock | 29.025 | 29.115 | 28.775 | 29.015 | 333572.0 |
| 2015-01-29 08:05:00 | AAPL | Stock | 29.0125 | 29.0225 | 28.975 | 28.995 | 118028.0 |
| 2015-01-29 08:10:00 | AAPL | Stock | 28.99 | 28.9925 | 28.9375 | 28.9725 | 85320.0 |
| 2015-01-29 08:15:00 | AAPL | Stock | 28.9725 | 28.9825 | 28.9375 | 28.9825 | 99012.0 |
| 2015-01-29 08:20:00 | AAPL | Stock | 28.985 | 29.0375 | 28.98 | 29.0375 | 99504.0 |
| 2015-01-29 08:25:00 | AAPL | Stock | 29.0425 | 29.0625 | 29.03 | 29.0625 | 96380.0 |
| 2015-01-29 08:30:00 | AAPL | Stock | 29.06 | 29.11 | 29.05 | 29.085 | 188112.0 |
| 2015-01-29 08:35:00 | AAPL | Stock | 29.095 | 29.105 | 29.075 | 29.0875 | 89836.0 |
| 2015-01-29 08:40:00 | AAPL | Stock | 29.0825 | 29.0825 | 29.0625 | 29.065 | 82652.0 |
| 2015-01-29 08:45:00 | AAPL | Stock | 29.075 | 29.0775 | 29.03 | 29.055 | 129700.0 |
| 2015-01-29 08:50:00 | AAPL | Stock | 29.05 | 29.075 | 29.0475 | 29.0675 | 103984.0 |
| 2015-01-29 08:55:00 | AAPL | Stock | 29.0675 | 29.09 | 29.0675 | 29.075 | 136428.0 |
> showing 50 of 363,620 rows — these rows as CSV