PREVIEW / stock_5min / 2019-05-16
file: by_date/stock_5min/2019/2019-05-16.parquet size: 5.7 MB rows: 359,239 symbols: 2,597
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 |
|---|---|---|---|---|---|---|---|
| 2019-05-16 04:00:00 | AAPL | Stock | 47.5 | 47.5 | 47.5 | 47.5 | 2000.0 |
| 2019-05-16 04:05:00 | AAPL | Stock | 47.5 | 47.585 | 47.5 | 47.5075 | 4000.0 |
| 2019-05-16 04:10:00 | AAPL | Stock | 47.5625 | 47.5625 | 47.5625 | 47.5625 | 4000.0 |
| 2019-05-16 04:15:00 | AAPL | Stock | 47.5925 | 47.6 | 47.5925 | 47.6 | 2400.0 |
| 2019-05-16 04:20:00 | AAPL | Stock | 47.6 | 47.6125 | 47.6 | 47.6125 | 6352.0 |
| 2019-05-16 04:25:00 | AAPL | Stock | 47.6175 | 47.6175 | 47.5875 | 47.5875 | 1600.0 |
| 2019-05-16 04:35:00 | AAPL | Stock | 47.6375 | 47.645 | 47.6375 | 47.645 | 4400.0 |
| 2019-05-16 04:40:00 | AAPL | Stock | 47.655 | 47.655 | 47.655 | 47.655 | 400.0 |
| 2019-05-16 04:50:00 | AAPL | Stock | 47.655 | 47.655 | 47.655 | 47.655 | 488.0 |
| 2019-05-16 05:10:00 | AAPL | Stock | 47.6525 | 47.6525 | 47.65 | 47.6525 | 2624.0 |
| 2019-05-16 05:20:00 | AAPL | Stock | 47.6975 | 47.6975 | 47.6975 | 47.6975 | 400.0 |
| 2019-05-16 05:45:00 | AAPL | Stock | 47.7475 | 47.7475 | 47.7475 | 47.7475 | 400.0 |
| 2019-05-16 06:00:00 | AAPL | Stock | 47.705 | 47.705 | 47.6975 | 47.6975 | 4312.0 |
| 2019-05-16 06:05:00 | AAPL | Stock | 47.725 | 47.7525 | 47.725 | 47.7525 | 4488.0 |
| 2019-05-16 06:15:00 | AAPL | Stock | 47.9 | 47.9 | 47.9 | 47.9 | 1980.0 |
| 2019-05-16 06:20:00 | AAPL | Stock | 47.8925 | 47.915 | 47.8925 | 47.915 | 9116.0 |
| 2019-05-16 06:25:00 | AAPL | Stock | 47.895 | 47.895 | 47.895 | 47.895 | 1972.0 |
| 2019-05-16 06:30:00 | AAPL | Stock | 47.9125 | 47.9125 | 47.9125 | 47.9125 | 1200.0 |
| 2019-05-16 06:35:00 | AAPL | Stock | 47.91 | 47.91 | 47.8875 | 47.8875 | 2000.0 |
| 2019-05-16 06:40:00 | AAPL | Stock | 47.9025 | 47.9025 | 47.8725 | 47.875 | 6444.0 |
| 2019-05-16 06:45:00 | AAPL | Stock | 47.85 | 47.85 | 47.8375 | 47.8375 | 800.0 |
| 2019-05-16 06:50:00 | AAPL | Stock | 47.8725 | 47.8875 | 47.8725 | 47.8875 | 3836.0 |
| 2019-05-16 06:55:00 | AAPL | Stock | 47.875 | 47.875 | 47.875 | 47.875 | 772.0 |
| 2019-05-16 07:00:00 | AAPL | Stock | 47.8775 | 47.8875 | 47.8375 | 47.8875 | 40792.0 |
| 2019-05-16 07:05:00 | AAPL | Stock | 47.8875 | 47.91 | 47.8875 | 47.9 | 10416.0 |
| 2019-05-16 07:10:00 | AAPL | Stock | 47.9075 | 47.91 | 47.9 | 47.91 | 23696.0 |
| 2019-05-16 07:15:00 | AAPL | Stock | 47.9125 | 47.925 | 47.895 | 47.895 | 85112.0 |
| 2019-05-16 07:20:00 | AAPL | Stock | 47.8925 | 47.9275 | 47.8925 | 47.92 | 13568.0 |
| 2019-05-16 07:25:00 | AAPL | Stock | 47.9125 | 47.9425 | 47.8875 | 47.9425 | 20204.0 |
| 2019-05-16 07:30:00 | AAPL | Stock | 47.93 | 47.945 | 47.9175 | 47.93 | 23348.0 |
| 2019-05-16 07:35:00 | AAPL | Stock | 47.9575 | 47.9575 | 47.9425 | 47.9425 | 2800.0 |
| 2019-05-16 07:40:00 | AAPL | Stock | 47.9575 | 47.96 | 47.8675 | 47.8775 | 24708.0 |
| 2019-05-16 07:45:00 | AAPL | Stock | 47.9225 | 47.9225 | 47.855 | 47.855 | 31392.0 |
| 2019-05-16 07:50:00 | AAPL | Stock | 47.875 | 47.875 | 47.765 | 47.8375 | 22756.0 |
| 2019-05-16 07:55:00 | AAPL | Stock | 47.845 | 47.875 | 47.845 | 47.875 | 10656.0 |
| 2019-05-16 08:00:00 | AAPL | Stock | 47.8625 | 47.96 | 47.8 | 47.8 | 147508.0 |
| 2019-05-16 08:05:00 | AAPL | Stock | 47.8025 | 47.8025 | 47.69 | 47.6975 | 129272.0 |
| 2019-05-16 08:10:00 | AAPL | Stock | 47.7225 | 47.7425 | 47.675 | 47.675 | 51608.0 |
| 2019-05-16 08:15:00 | AAPL | Stock | 47.6725 | 47.7225 | 47.6625 | 47.6875 | 18200.0 |
| 2019-05-16 08:20:00 | AAPL | Stock | 47.675 | 47.6875 | 47.625 | 47.625 | 57612.0 |
| 2019-05-16 08:25:00 | AAPL | Stock | 47.6275 | 47.725 | 47.6275 | 47.6875 | 28712.0 |
| 2019-05-16 08:30:00 | AAPL | Stock | 47.6875 | 47.7425 | 47.6875 | 47.73 | 41888.0 |
| 2019-05-16 08:35:00 | AAPL | Stock | 47.73 | 47.73 | 47.6775 | 47.6975 | 20484.0 |
| 2019-05-16 08:40:00 | AAPL | Stock | 47.6775 | 47.68 | 47.575 | 47.5925 | 47480.0 |
| 2019-05-16 08:45:00 | AAPL | Stock | 47.5925 | 47.6025 | 47.5375 | 47.55 | 71504.0 |
| 2019-05-16 08:50:00 | AAPL | Stock | 47.56 | 47.56 | 47.48 | 47.5 | 72444.0 |
| 2019-05-16 08:55:00 | AAPL | Stock | 47.5 | 47.5575 | 47.49 | 47.5525 | 37140.0 |
| 2019-05-16 09:00:00 | AAPL | Stock | 47.52 | 47.52 | 47.5 | 47.5025 | 93320.0 |
| 2019-05-16 09:05:00 | AAPL | Stock | 47.5138 | 47.5175 | 47.4375 | 47.45 | 53572.0 |
| 2019-05-16 09:10:00 | AAPL | Stock | 47.47 | 47.475 | 47.3975 | 47.4225 | 42764.0 |
> showing 50 of 359,239 rows — these rows as CSV