PREVIEW / stock_5min / 2015-11-19
file: by_date/stock_5min/2015/2015-11-19.parquet size: 5.3 MB rows: 353,826 symbols: 3,425
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-11-19 04:00:00 | AAPL | Stock | 29.45 | 29.4625 | 29.45 | 29.4575 | 1200.0 |
| 2015-11-19 04:10:00 | AAPL | Stock | 29.45 | 29.45 | 29.445 | 29.445 | 1600.0 |
| 2015-11-19 04:15:00 | AAPL | Stock | 29.445 | 29.45 | 29.435 | 29.45 | 9600.0 |
| 2015-11-19 04:25:00 | AAPL | Stock | 29.4575 | 29.4575 | 29.4575 | 29.4575 | 8888.0 |
| 2015-11-19 04:30:00 | AAPL | Stock | 29.4525 | 29.4525 | 29.435 | 29.435 | 2000.0 |
| 2015-11-19 04:35:00 | AAPL | Stock | 29.455 | 29.455 | 29.455 | 29.455 | 800.0 |
| 2015-11-19 04:40:00 | AAPL | Stock | 29.455 | 29.455 | 29.455 | 29.455 | 400.0 |
| 2015-11-19 04:50:00 | AAPL | Stock | 29.4575 | 29.4575 | 29.45 | 29.45 | 4480.0 |
| 2015-11-19 04:55:00 | AAPL | Stock | 29.4575 | 29.465 | 29.4575 | 29.465 | 4400.0 |
| 2015-11-19 05:00:00 | AAPL | Stock | 29.4625 | 29.4625 | 29.4625 | 29.4625 | 400.0 |
| 2015-11-19 05:05:00 | AAPL | Stock | 29.465 | 29.465 | 29.465 | 29.465 | 400.0 |
| 2015-11-19 05:10:00 | AAPL | Stock | 29.46 | 29.46 | 29.455 | 29.455 | 2192.0 |
| 2015-11-19 05:15:00 | AAPL | Stock | 29.46 | 29.46 | 29.46 | 29.46 | 400.0 |
| 2015-11-19 05:20:00 | AAPL | Stock | 29.4625 | 29.4625 | 29.4625 | 29.4625 | 400.0 |
| 2015-11-19 05:30:00 | AAPL | Stock | 29.4625 | 29.4625 | 29.4625 | 29.4625 | 540.0 |
| 2015-11-19 05:35:00 | AAPL | Stock | 29.455 | 29.455 | 29.45 | 29.45 | 1768.0 |
| 2015-11-19 05:40:00 | AAPL | Stock | 29.4575 | 29.4625 | 29.435 | 29.435 | 3652.0 |
| 2015-11-19 05:50:00 | AAPL | Stock | 29.4575 | 29.4575 | 29.4575 | 29.4575 | 400.0 |
| 2015-11-19 06:00:00 | AAPL | Stock | 29.465 | 29.4975 | 29.465 | 29.4975 | 800.0 |
| 2015-11-19 06:05:00 | AAPL | Stock | 29.4875 | 29.49 | 29.4875 | 29.49 | 4000.0 |
| 2015-11-19 06:10:00 | AAPL | Stock | 29.49 | 29.5225 | 29.49 | 29.5025 | 22740.0 |
| 2015-11-19 06:15:00 | AAPL | Stock | 29.505 | 29.505 | 29.5025 | 29.5025 | 5900.0 |
| 2015-11-19 06:20:00 | AAPL | Stock | 29.5025 | 29.5025 | 29.5 | 29.5025 | 6000.0 |
| 2015-11-19 06:25:00 | AAPL | Stock | 29.5025 | 29.51 | 29.5025 | 29.51 | 1200.0 |
| 2015-11-19 06:30:00 | AAPL | Stock | 29.5025 | 29.5025 | 29.495 | 29.5025 | 31236.0 |
| 2015-11-19 06:35:00 | AAPL | Stock | 29.5 | 29.5175 | 29.5 | 29.5175 | 23376.0 |
| 2015-11-19 06:40:00 | AAPL | Stock | 29.5175 | 29.535 | 29.5175 | 29.535 | 2320.0 |
| 2015-11-19 06:50:00 | AAPL | Stock | 29.505 | 29.5125 | 29.485 | 29.4875 | 37980.0 |
| 2015-11-19 06:55:00 | AAPL | Stock | 29.4875 | 29.4875 | 29.46 | 29.46 | 5600.0 |
| 2015-11-19 07:00:00 | AAPL | Stock | 29.465 | 29.4675 | 29.425 | 29.425 | 24888.0 |
| 2015-11-19 07:05:00 | AAPL | Stock | 29.44 | 29.45 | 29.4125 | 29.425 | 41456.0 |
| 2015-11-19 07:10:00 | AAPL | Stock | 29.425 | 29.4775 | 29.4225 | 29.4775 | 56076.0 |
| 2015-11-19 07:15:00 | AAPL | Stock | 29.48 | 29.495 | 29.4375 | 29.4375 | 56464.0 |
| 2015-11-19 07:20:00 | AAPL | Stock | 29.425 | 29.45 | 29.3875 | 29.45 | 21332.0 |
| 2015-11-19 07:25:00 | AAPL | Stock | 29.45 | 29.475 | 29.4275 | 29.4275 | 72500.0 |
| 2015-11-19 07:30:00 | AAPL | Stock | 29.45 | 29.45 | 29.45 | 29.45 | 16400.0 |
| 2015-11-19 07:35:00 | AAPL | Stock | 29.46 | 29.4725 | 29.46 | 29.4625 | 15208.0 |
| 2015-11-19 07:40:00 | AAPL | Stock | 29.46 | 29.4675 | 29.4 | 29.4375 | 64880.0 |
| 2015-11-19 07:45:00 | AAPL | Stock | 29.4475 | 29.4575 | 29.435 | 29.445 | 28964.0 |
| 2015-11-19 07:50:00 | AAPL | Stock | 29.44 | 29.44 | 29.3875 | 29.4 | 65824.0 |
| 2015-11-19 07:55:00 | AAPL | Stock | 29.4 | 29.4 | 29.2525 | 29.305 | 64992.0 |
| 2015-11-19 08:00:00 | AAPL | Stock | 29.305 | 29.49 | 29.305 | 29.3425 | 163024.0 |
| 2015-11-19 08:05:00 | AAPL | Stock | 29.345 | 29.3925 | 29.3425 | 29.39 | 46280.0 |
| 2015-11-19 08:10:00 | AAPL | Stock | 29.3875 | 29.3875 | 29.3575 | 29.365 | 31308.0 |
| 2015-11-19 08:15:00 | AAPL | Stock | 29.36 | 29.36 | 29.3475 | 29.3475 | 35620.0 |
| 2015-11-19 08:20:00 | AAPL | Stock | 29.36 | 29.36 | 29.265 | 29.28 | 111216.0 |
| 2015-11-19 08:25:00 | AAPL | Stock | 29.28 | 29.3025 | 29.2725 | 29.295 | 48168.0 |
| 2015-11-19 08:30:00 | AAPL | Stock | 29.295 | 29.345 | 29.29 | 29.3375 | 71992.0 |
| 2015-11-19 08:35:00 | AAPL | Stock | 29.3375 | 29.3375 | 29.2875 | 29.2975 | 56616.0 |
| 2015-11-19 08:40:00 | AAPL | Stock | 29.2975 | 29.2975 | 29.2775 | 29.2825 | 35560.0 |
> showing 50 of 353,826 rows — these rows as CSV