PREVIEW / stock_5min / 2018-11-19
file: by_date/stock_5min/2018/2018-11-19.parquet size: 5.6 MB rows: 355,657 symbols: 2,764
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 |
|---|---|---|---|---|---|---|---|
| 2018-11-19 04:00:00 | AAPL | Stock | 48.6775 | 48.7 | 48.6625 | 48.6625 | 9420.0 |
| 2018-11-19 04:10:00 | AAPL | Stock | 48.625 | 48.625 | 48.5875 | 48.5875 | 800.0 |
| 2018-11-19 04:15:00 | AAPL | Stock | 48.525 | 48.525 | 48.075 | 48.1275 | 28192.0 |
| 2018-11-19 04:20:00 | AAPL | Stock | 48.13 | 48.13 | 48.0 | 48.0 | 5092.0 |
| 2018-11-19 04:30:00 | AAPL | Stock | 48.0225 | 48.06 | 48.0 | 48.06 | 7904.0 |
| 2018-11-19 04:35:00 | AAPL | Stock | 47.9625 | 47.9625 | 47.96 | 47.96 | 1200.0 |
| 2018-11-19 04:40:00 | AAPL | Stock | 47.875 | 47.875 | 47.87 | 47.875 | 1800.0 |
| 2018-11-19 04:45:00 | AAPL | Stock | 47.9 | 47.9125 | 47.9 | 47.9125 | 2800.0 |
| 2018-11-19 04:50:00 | AAPL | Stock | 47.865 | 47.865 | 47.8575 | 47.8575 | 1044.0 |
| 2018-11-19 04:55:00 | AAPL | Stock | 47.8575 | 47.9 | 47.8575 | 47.9 | 3804.0 |
| 2018-11-19 05:05:00 | AAPL | Stock | 47.9 | 47.9 | 47.895 | 47.9 | 2192.0 |
| 2018-11-19 05:10:00 | AAPL | Stock | 47.9 | 47.9 | 47.9 | 47.9 | 1592.0 |
| 2018-11-19 05:15:00 | AAPL | Stock | 47.9 | 47.9 | 47.9 | 47.9 | 1600.0 |
| 2018-11-19 05:20:00 | AAPL | Stock | 47.9 | 47.9 | 47.875 | 47.875 | 3320.0 |
| 2018-11-19 05:25:00 | AAPL | Stock | 47.8875 | 47.8875 | 47.8875 | 47.8875 | 600.0 |
| 2018-11-19 05:40:00 | AAPL | Stock | 47.8725 | 47.8725 | 47.8 | 47.8 | 5476.0 |
| 2018-11-19 05:45:00 | AAPL | Stock | 47.825 | 47.825 | 47.75 | 47.75 | 7508.0 |
| 2018-11-19 05:50:00 | AAPL | Stock | 47.75 | 47.75 | 47.69 | 47.69 | 2760.0 |
| 2018-11-19 05:55:00 | AAPL | Stock | 47.69 | 47.69 | 47.62 | 47.62 | 8240.0 |
| 2018-11-19 06:00:00 | AAPL | Stock | 47.68 | 47.685 | 47.6525 | 47.685 | 8676.0 |
| 2018-11-19 06:05:00 | AAPL | Stock | 47.675 | 47.675 | 47.63 | 47.63 | 1200.0 |
| 2018-11-19 06:10:00 | AAPL | Stock | 47.6 | 47.6 | 47.5275 | 47.575 | 4980.0 |
| 2018-11-19 06:15:00 | AAPL | Stock | 47.6 | 47.6 | 47.5225 | 47.55 | 18304.0 |
| 2018-11-19 06:20:00 | AAPL | Stock | 47.55 | 47.55 | 47.4475 | 47.4475 | 35028.0 |
| 2018-11-19 06:25:00 | AAPL | Stock | 47.4425 | 47.5375 | 47.4325 | 47.5375 | 9600.0 |
| 2018-11-19 06:30:00 | AAPL | Stock | 47.5325 | 47.545 | 47.475 | 47.545 | 4000.0 |
| 2018-11-19 06:35:00 | AAPL | Stock | 47.475 | 47.475 | 47.38 | 47.45 | 7248.0 |
| 2018-11-19 06:40:00 | AAPL | Stock | 47.415 | 47.415 | 47.35 | 47.415 | 7664.0 |
| 2018-11-19 06:45:00 | AAPL | Stock | 47.45 | 47.475 | 47.3875 | 47.4 | 14608.0 |
| 2018-11-19 06:50:00 | AAPL | Stock | 47.3925 | 47.5 | 47.3875 | 47.485 | 11200.0 |
| 2018-11-19 06:55:00 | AAPL | Stock | 47.4975 | 47.5 | 47.4425 | 47.4425 | 12036.0 |
| 2018-11-19 07:00:00 | AAPL | Stock | 47.47 | 47.6725 | 47.375 | 47.6525 | 138364.0 |
| 2018-11-19 07:05:00 | AAPL | Stock | 47.61 | 47.625 | 47.53 | 47.5975 | 69448.0 |
| 2018-11-19 07:10:00 | AAPL | Stock | 47.57 | 47.585 | 47.45 | 47.5 | 54524.0 |
| 2018-11-19 07:15:00 | AAPL | Stock | 47.5375 | 47.675 | 47.5375 | 47.65 | 74028.0 |
| 2018-11-19 07:20:00 | AAPL | Stock | 47.65 | 47.8 | 47.65 | 47.675 | 111832.0 |
| 2018-11-19 07:25:00 | AAPL | Stock | 47.6825 | 47.75 | 47.6225 | 47.65 | 59316.0 |
| 2018-11-19 07:30:00 | AAPL | Stock | 47.6775 | 47.6775 | 47.55 | 47.595 | 33404.0 |
| 2018-11-19 07:35:00 | AAPL | Stock | 47.585 | 47.6325 | 47.5375 | 47.62 | 27140.0 |
| 2018-11-19 07:40:00 | AAPL | Stock | 47.58 | 47.64 | 47.58 | 47.635 | 20516.0 |
| 2018-11-19 07:45:00 | AAPL | Stock | 47.635 | 47.635 | 47.5375 | 47.5625 | 39664.0 |
| 2018-11-19 07:50:00 | AAPL | Stock | 47.5625 | 47.625 | 47.5525 | 47.615 | 27832.0 |
| 2018-11-19 07:55:00 | AAPL | Stock | 47.6225 | 47.625 | 47.5925 | 47.595 | 14328.0 |
| 2018-11-19 08:00:00 | AAPL | Stock | 47.595 | 47.7775 | 47.375 | 47.5125 | 261236.0 |
| 2018-11-19 08:05:00 | AAPL | Stock | 47.5175 | 47.595 | 47.5075 | 47.5875 | 80080.0 |
| 2018-11-19 08:10:00 | AAPL | Stock | 47.5875 | 47.725 | 47.555 | 47.695 | 102616.0 |
| 2018-11-19 08:15:00 | AAPL | Stock | 47.685 | 47.695 | 47.5825 | 47.615 | 81444.0 |
| 2018-11-19 08:20:00 | AAPL | Stock | 47.61 | 47.68 | 47.5375 | 47.5525 | 198556.0 |
| 2018-11-19 08:25:00 | AAPL | Stock | 47.5525 | 47.585 | 47.5375 | 47.55 | 74892.0 |
| 2018-11-19 08:30:00 | AAPL | Stock | 47.56 | 47.58 | 47.485 | 47.53 | 127244.0 |
> showing 50 of 355,657 rows — these rows as CSV