PREVIEW / stock_5min / 2018-10-04
file: by_date/stock_5min/2018/2018-10-04.parquet size: 5.8 MB rows: 365,193 symbols: 2,794
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-10-04 04:00:00 | AAPL | Stock | 57.625 | 57.7 | 57.625 | 57.7 | 10000.0 |
| 2018-10-04 04:10:00 | AAPL | Stock | 57.65 | 57.65 | 57.63 | 57.6375 | 2456.0 |
| 2018-10-04 04:15:00 | AAPL | Stock | 57.7 | 57.7 | 57.625 | 57.625 | 3680.0 |
| 2018-10-04 04:35:00 | AAPL | Stock | 57.675 | 57.675 | 57.675 | 57.675 | 400.0 |
| 2018-10-04 04:40:00 | AAPL | Stock | 57.6725 | 57.675 | 57.6725 | 57.675 | 5200.0 |
| 2018-10-04 04:55:00 | AAPL | Stock | 57.63 | 57.63 | 57.6275 | 57.6275 | 2008.0 |
| 2018-10-04 05:00:00 | AAPL | Stock | 57.6325 | 57.6325 | 57.5 | 57.625 | 11476.0 |
| 2018-10-04 05:05:00 | AAPL | Stock | 57.5 | 57.6125 | 57.445 | 57.6125 | 14872.0 |
| 2018-10-04 05:10:00 | AAPL | Stock | 57.6175 | 57.625 | 57.6175 | 57.625 | 1200.0 |
| 2018-10-04 05:20:00 | AAPL | Stock | 57.625 | 57.625 | 57.625 | 57.625 | 1200.0 |
| 2018-10-04 05:25:00 | AAPL | Stock | 57.575 | 57.575 | 57.575 | 57.575 | 3744.0 |
| 2018-10-04 06:10:00 | AAPL | Stock | 57.6625 | 57.6625 | 57.6625 | 57.6625 | 3504.0 |
| 2018-10-04 06:20:00 | AAPL | Stock | 57.6625 | 57.6625 | 57.625 | 57.625 | 2416.0 |
| 2018-10-04 06:25:00 | AAPL | Stock | 57.625 | 57.625 | 57.625 | 57.625 | 704.0 |
| 2018-10-04 06:30:00 | AAPL | Stock | 57.625 | 57.625 | 57.5875 | 57.6 | 21332.0 |
| 2018-10-04 06:35:00 | AAPL | Stock | 57.6 | 57.6 | 57.6 | 57.6 | 400.0 |
| 2018-10-04 06:40:00 | AAPL | Stock | 57.6 | 57.6 | 57.6 | 57.6 | 1604.0 |
| 2018-10-04 06:45:00 | AAPL | Stock | 57.625 | 57.6625 | 57.625 | 57.625 | 8000.0 |
| 2018-10-04 06:50:00 | AAPL | Stock | 57.625 | 57.625 | 57.6225 | 57.625 | 6000.0 |
| 2018-10-04 06:55:00 | AAPL | Stock | 57.6625 | 57.675 | 57.6625 | 57.675 | 2800.0 |
| 2018-10-04 07:00:00 | AAPL | Stock | 57.72 | 57.7875 | 57.65 | 57.75 | 31348.0 |
| 2018-10-04 07:05:00 | AAPL | Stock | 57.77 | 57.7975 | 57.7675 | 57.7975 | 24400.0 |
| 2018-10-04 07:10:00 | AAPL | Stock | 57.82 | 57.895 | 57.82 | 57.8375 | 37764.0 |
| 2018-10-04 07:15:00 | AAPL | Stock | 57.8175 | 57.835 | 57.8025 | 57.835 | 12100.0 |
| 2018-10-04 07:20:00 | AAPL | Stock | 57.8425 | 57.8475 | 57.7975 | 57.8325 | 14856.0 |
| 2018-10-04 07:25:00 | AAPL | Stock | 57.8125 | 57.8125 | 57.7975 | 57.8025 | 10000.0 |
| 2018-10-04 07:30:00 | AAPL | Stock | 57.8025 | 57.8025 | 57.75 | 57.75 | 19852.0 |
| 2018-10-04 07:35:00 | AAPL | Stock | 57.75 | 57.75 | 57.6775 | 57.695 | 14076.0 |
| 2018-10-04 07:40:00 | AAPL | Stock | 57.7175 | 57.72 | 57.6625 | 57.6625 | 18104.0 |
| 2018-10-04 07:45:00 | AAPL | Stock | 57.6625 | 57.675 | 57.615 | 57.625 | 61740.0 |
| 2018-10-04 07:50:00 | AAPL | Stock | 57.625 | 57.7125 | 57.625 | 57.7125 | 42300.0 |
| 2018-10-04 07:55:00 | AAPL | Stock | 57.715 | 57.715 | 57.6375 | 57.69 | 92520.0 |
| 2018-10-04 08:00:00 | AAPL | Stock | 57.6812 | 57.8825 | 57.51 | 57.5125 | 221444.0 |
| 2018-10-04 08:05:00 | AAPL | Stock | 57.5125 | 57.575 | 57.4875 | 57.5675 | 104512.0 |
| 2018-10-04 08:10:00 | AAPL | Stock | 57.545 | 57.575 | 57.54 | 57.5625 | 26340.0 |
| 2018-10-04 08:15:00 | AAPL | Stock | 57.54 | 57.595 | 57.525 | 57.595 | 55364.0 |
| 2018-10-04 08:20:00 | AAPL | Stock | 57.5875 | 57.625 | 57.5875 | 57.6 | 21352.0 |
| 2018-10-04 08:25:00 | AAPL | Stock | 57.625 | 57.6625 | 57.5875 | 57.6375 | 52140.0 |
| 2018-10-04 08:30:00 | AAPL | Stock | 57.66 | 57.67 | 57.625 | 57.67 | 23916.0 |
| 2018-10-04 08:35:00 | AAPL | Stock | 57.6825 | 57.6875 | 57.655 | 57.675 | 50988.0 |
| 2018-10-04 08:40:00 | AAPL | Stock | 57.675 | 58.0175 | 57.575 | 57.575 | 61192.0 |
| 2018-10-04 08:45:00 | AAPL | Stock | 57.5975 | 57.655 | 57.5775 | 57.6475 | 39952.0 |
| 2018-10-04 08:50:00 | AAPL | Stock | 57.6575 | 57.7875 | 57.6575 | 57.7525 | 54920.0 |
| 2018-10-04 08:55:00 | AAPL | Stock | 57.785 | 57.785 | 57.5875 | 57.6875 | 56908.0 |
| 2018-10-04 09:00:00 | AAPL | Stock | 57.6875 | 57.725 | 57.6825 | 57.7 | 25796.0 |
| 2018-10-04 09:05:00 | AAPL | Stock | 57.7 | 57.7 | 57.6125 | 57.625 | 58328.0 |
| 2018-10-04 09:10:00 | AAPL | Stock | 57.6575 | 57.685 | 57.6325 | 57.685 | 15972.0 |
| 2018-10-04 09:15:00 | AAPL | Stock | 57.675 | 57.74 | 57.675 | 57.74 | 19904.0 |
| 2018-10-04 09:20:00 | AAPL | Stock | 57.74 | 57.7875 | 57.715 | 57.73 | 52396.0 |
| 2018-10-04 09:25:00 | AAPL | Stock | 57.7475 | 57.75 | 57.6875 | 57.715 | 22344.0 |
> showing 50 of 365,193 rows — these rows as CSV