PREVIEW / stock_5min / 2015-10-19
file: by_date/stock_5min/2015/2015-10-19.parquet size: 5.2 MB rows: 347,712 symbols: 3,424
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-10-19 04:00:00 | AAPL | Stock | 27.8225 | 27.8225 | 27.8225 | 27.8225 | 2000.0 |
| 2015-10-19 04:20:00 | AAPL | Stock | 27.7625 | 27.7625 | 27.7625 | 27.7625 | 3600.0 |
| 2015-10-19 05:05:00 | AAPL | Stock | 27.7875 | 27.7875 | 27.7875 | 27.7875 | 800.0 |
| 2015-10-19 05:20:00 | AAPL | Stock | 27.775 | 27.775 | 27.775 | 27.775 | 728.0 |
| 2015-10-19 05:25:00 | AAPL | Stock | 27.7625 | 27.7625 | 27.7625 | 27.7625 | 2000.0 |
| 2015-10-19 05:35:00 | AAPL | Stock | 27.7625 | 27.7625 | 27.7625 | 27.7625 | 1776.0 |
| 2015-10-19 05:45:00 | AAPL | Stock | 27.7675 | 27.7675 | 27.7675 | 27.7675 | 1000.0 |
| 2015-10-19 06:00:00 | AAPL | Stock | 27.77 | 27.77 | 27.77 | 27.77 | 1248.0 |
| 2015-10-19 06:05:00 | AAPL | Stock | 27.775 | 27.775 | 27.77 | 27.77 | 800.0 |
| 2015-10-19 06:10:00 | AAPL | Stock | 27.75 | 27.75 | 27.75 | 27.75 | 2400.0 |
| 2015-10-19 06:15:00 | AAPL | Stock | 27.75 | 27.75 | 27.75 | 27.75 | 1200.0 |
| 2015-10-19 06:25:00 | AAPL | Stock | 27.75 | 27.75 | 27.75 | 27.75 | 1600.0 |
| 2015-10-19 06:45:00 | AAPL | Stock | 27.775 | 27.775 | 27.7725 | 27.7725 | 1584.0 |
| 2015-10-19 06:50:00 | AAPL | Stock | 27.7825 | 27.7875 | 27.7825 | 27.7825 | 3416.0 |
| 2015-10-19 07:00:00 | AAPL | Stock | 27.7675 | 27.7675 | 27.7475 | 27.7475 | 5756.0 |
| 2015-10-19 07:05:00 | AAPL | Stock | 27.7175 | 27.7175 | 27.7175 | 27.7175 | 1000.0 |
| 2015-10-19 07:10:00 | AAPL | Stock | 27.725 | 27.7275 | 27.725 | 27.7275 | 5400.0 |
| 2015-10-19 07:20:00 | AAPL | Stock | 27.75 | 27.775 | 27.75 | 27.775 | 13044.0 |
| 2015-10-19 07:25:00 | AAPL | Stock | 27.7875 | 27.795 | 27.775 | 27.795 | 8800.0 |
| 2015-10-19 07:30:00 | AAPL | Stock | 27.825 | 27.825 | 27.7875 | 27.8 | 8800.0 |
| 2015-10-19 07:35:00 | AAPL | Stock | 27.8 | 27.8 | 27.7875 | 27.7975 | 15136.0 |
| 2015-10-19 07:40:00 | AAPL | Stock | 27.79 | 27.79 | 27.7725 | 27.775 | 4960.0 |
| 2015-10-19 07:45:00 | AAPL | Stock | 27.7625 | 27.78 | 27.7625 | 27.78 | 5632.0 |
| 2015-10-19 07:50:00 | AAPL | Stock | 27.7725 | 27.7775 | 27.7725 | 27.775 | 3200.0 |
| 2015-10-19 07:55:00 | AAPL | Stock | 27.7775 | 27.7825 | 27.775 | 27.775 | 3676.0 |
| 2015-10-19 08:00:00 | AAPL | Stock | 27.775 | 27.835 | 27.7375 | 27.775 | 56708.0 |
| 2015-10-19 08:05:00 | AAPL | Stock | 27.77 | 27.7725 | 27.75 | 27.7625 | 46500.0 |
| 2015-10-19 08:10:00 | AAPL | Stock | 27.7625 | 27.77 | 27.76 | 27.765 | 6000.0 |
| 2015-10-19 08:15:00 | AAPL | Stock | 27.7675 | 27.775 | 27.7625 | 27.7725 | 20616.0 |
| 2015-10-19 08:20:00 | AAPL | Stock | 27.775 | 27.775 | 27.7625 | 27.775 | 13724.0 |
| 2015-10-19 08:25:00 | AAPL | Stock | 27.78 | 27.785 | 27.775 | 27.775 | 37744.0 |
| 2015-10-19 08:30:00 | AAPL | Stock | 27.775 | 27.775 | 27.73 | 27.735 | 35716.0 |
| 2015-10-19 08:35:00 | AAPL | Stock | 27.75 | 27.75 | 27.7375 | 27.75 | 11468.0 |
| 2015-10-19 08:40:00 | AAPL | Stock | 27.75 | 27.75 | 27.725 | 27.7275 | 17000.0 |
| 2015-10-19 08:45:00 | AAPL | Stock | 27.7375 | 27.7375 | 27.735 | 27.7375 | 9200.0 |
| 2015-10-19 08:50:00 | AAPL | Stock | 27.7375 | 27.7375 | 27.7125 | 27.725 | 53276.0 |
| 2015-10-19 08:55:00 | AAPL | Stock | 27.725 | 27.725 | 27.685 | 27.685 | 55552.0 |
| 2015-10-19 09:00:00 | AAPL | Stock | 27.685 | 27.6975 | 27.68 | 27.685 | 22760.0 |
| 2015-10-19 09:05:00 | AAPL | Stock | 27.6825 | 27.695 | 27.66 | 27.6725 | 60560.0 |
| 2015-10-19 09:10:00 | AAPL | Stock | 27.6675 | 27.675 | 27.6625 | 27.6625 | 8000.0 |
| 2015-10-19 09:15:00 | AAPL | Stock | 27.66 | 27.6675 | 27.6575 | 27.6675 | 18884.0 |
| 2015-10-19 09:20:00 | AAPL | Stock | 27.6675 | 27.68 | 27.64 | 27.64 | 59136.0 |
| 2015-10-19 09:25:00 | AAPL | Stock | 27.6525 | 27.735 | 27.6525 | 27.7125 | 89076.0 |
| 2015-10-19 09:30:00 | AAPL | Stock | 27.7 | 27.7475 | 27.5775 | 27.6175 | 4972620.0 |
| 2015-10-19 09:35:00 | AAPL | Stock | 27.62 | 27.635 | 27.5275 | 27.55 | 3396272.0 |
| 2015-10-19 09:40:00 | AAPL | Stock | 27.55 | 27.6175 | 27.5425 | 27.6 | 2715928.0 |
| 2015-10-19 09:45:00 | AAPL | Stock | 27.605 | 27.7 | 27.585 | 27.6925 | 2655800.0 |
| 2015-10-19 09:50:00 | AAPL | Stock | 27.69 | 27.705 | 27.6425 | 27.67 | 1865604.0 |
| 2015-10-19 09:55:00 | AAPL | Stock | 27.6675 | 27.7175 | 27.625 | 27.705 | 1363048.0 |
| 2015-10-19 10:00:00 | AAPL | Stock | 27.7 | 27.7125 | 27.645 | 27.6665 | 1576600.0 |
> showing 50 of 347,712 rows — these rows as CSV