PREVIEW / stock_5min / 2019-01-15
file: by_date/stock_5min/2019/2019-01-15.parquet size: 5.6 MB rows: 353,536 symbols: 2,697
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-01-15 04:05:00 | AAPL | Stock | 37.765 | 37.765 | 37.7 | 37.725 | 10000.0 |
| 2019-01-15 04:10:00 | AAPL | Stock | 37.725 | 37.725 | 37.7 | 37.7 | 5548.0 |
| 2019-01-15 04:15:00 | AAPL | Stock | 37.7 | 37.7 | 37.7 | 37.7 | 2472.0 |
| 2019-01-15 04:50:00 | AAPL | Stock | 37.6 | 37.6 | 37.6 | 37.6 | 1444.0 |
| 2019-01-15 05:20:00 | AAPL | Stock | 37.7075 | 37.7075 | 37.7075 | 37.7075 | 400.0 |
| 2019-01-15 05:25:00 | AAPL | Stock | 37.7 | 37.7 | 37.7 | 37.7 | 800.0 |
| 2019-01-15 05:30:00 | AAPL | Stock | 37.6275 | 37.65 | 37.625 | 37.625 | 2272.0 |
| 2019-01-15 05:45:00 | AAPL | Stock | 37.6975 | 37.6975 | 37.6975 | 37.6975 | 1344.0 |
| 2019-01-15 05:55:00 | AAPL | Stock | 37.6975 | 37.6975 | 37.6975 | 37.6975 | 600.0 |
| 2019-01-15 06:05:00 | AAPL | Stock | 37.69 | 37.69 | 37.69 | 37.69 | 1600.0 |
| 2019-01-15 06:10:00 | AAPL | Stock | 37.6925 | 37.6925 | 37.6925 | 37.6925 | 500.0 |
| 2019-01-15 06:15:00 | AAPL | Stock | 37.6975 | 37.7 | 37.695 | 37.695 | 8400.0 |
| 2019-01-15 06:20:00 | AAPL | Stock | 37.69 | 37.69 | 37.69 | 37.69 | 908.0 |
| 2019-01-15 06:30:00 | AAPL | Stock | 37.69 | 37.7 | 37.69 | 37.7 | 1708.0 |
| 2019-01-15 06:35:00 | AAPL | Stock | 37.7 | 37.7 | 37.7 | 37.7 | 800.0 |
| 2019-01-15 06:40:00 | AAPL | Stock | 37.6625 | 37.6625 | 37.6625 | 37.6625 | 800.0 |
| 2019-01-15 06:50:00 | AAPL | Stock | 37.665 | 37.67 | 37.625 | 37.625 | 7120.0 |
| 2019-01-15 06:55:00 | AAPL | Stock | 37.625 | 37.625 | 37.6 | 37.6 | 1756.0 |
| 2019-01-15 07:00:00 | AAPL | Stock | 37.6 | 37.645 | 37.6 | 37.615 | 8116.0 |
| 2019-01-15 07:05:00 | AAPL | Stock | 37.6025 | 37.6025 | 37.6025 | 37.6025 | 1400.0 |
| 2019-01-15 07:10:00 | AAPL | Stock | 37.6 | 37.6 | 37.5775 | 37.5775 | 11520.0 |
| 2019-01-15 07:15:00 | AAPL | Stock | 37.5875 | 37.6125 | 37.5875 | 37.6125 | 2620.0 |
| 2019-01-15 07:20:00 | AAPL | Stock | 37.6225 | 37.625 | 37.6 | 37.6 | 4000.0 |
| 2019-01-15 07:25:00 | AAPL | Stock | 37.625 | 37.625 | 37.6125 | 37.6225 | 6180.0 |
| 2019-01-15 07:30:00 | AAPL | Stock | 37.6125 | 37.6125 | 37.6 | 37.6 | 1200.0 |
| 2019-01-15 07:35:00 | AAPL | Stock | 37.5875 | 37.6025 | 37.5875 | 37.6025 | 7268.0 |
| 2019-01-15 07:40:00 | AAPL | Stock | 37.6175 | 37.625 | 37.6 | 37.6 | 42240.0 |
| 2019-01-15 07:45:00 | AAPL | Stock | 37.6 | 37.635 | 37.5975 | 37.635 | 12240.0 |
| 2019-01-15 07:50:00 | AAPL | Stock | 37.6325 | 37.6325 | 37.6 | 37.6 | 11564.0 |
| 2019-01-15 07:55:00 | AAPL | Stock | 37.6375 | 37.6375 | 37.6375 | 37.6375 | 964.0 |
| 2019-01-15 08:00:00 | AAPL | Stock | 37.65 | 37.667 | 37.5775 | 37.65 | 67560.0 |
| 2019-01-15 08:05:00 | AAPL | Stock | 37.65 | 37.6775 | 37.6275 | 37.6275 | 44276.0 |
| 2019-01-15 08:10:00 | AAPL | Stock | 37.6375 | 37.65 | 37.625 | 37.65 | 7668.0 |
| 2019-01-15 08:15:00 | AAPL | Stock | 37.6475 | 37.65 | 37.625 | 37.625 | 12356.0 |
| 2019-01-15 08:20:00 | AAPL | Stock | 37.625 | 37.64 | 37.5725 | 37.575 | 46488.0 |
| 2019-01-15 08:25:00 | AAPL | Stock | 37.595 | 37.6 | 37.5625 | 37.5625 | 19192.0 |
| 2019-01-15 08:30:00 | AAPL | Stock | 37.5775 | 37.6 | 37.55 | 37.575 | 25960.0 |
| 2019-01-15 08:35:00 | AAPL | Stock | 37.575 | 37.575 | 37.5325 | 37.5375 | 12396.0 |
| 2019-01-15 08:40:00 | AAPL | Stock | 37.5625 | 37.575 | 37.5325 | 37.545 | 46348.0 |
| 2019-01-15 08:45:00 | AAPL | Stock | 37.565 | 37.565 | 37.535 | 37.5475 | 21820.0 |
| 2019-01-15 08:50:00 | AAPL | Stock | 37.5375 | 37.5492 | 37.5275 | 37.5492 | 5756.0 |
| 2019-01-15 08:55:00 | AAPL | Stock | 37.5375 | 37.55 | 37.5275 | 37.53 | 16936.0 |
| 2019-01-15 09:00:00 | AAPL | Stock | 37.547 | 37.5625 | 37.5325 | 37.56 | 37348.0 |
| 2019-01-15 09:05:00 | AAPL | Stock | 37.56 | 37.56 | 37.535 | 37.5478 | 141584.0 |
| 2019-01-15 09:10:00 | AAPL | Stock | 37.55 | 37.55 | 37.505 | 37.5225 | 26644.0 |
| 2019-01-15 09:15:00 | AAPL | Stock | 37.5175 | 37.55 | 37.5075 | 37.54 | 17472.0 |
| 2019-01-15 09:20:00 | AAPL | Stock | 37.54 | 37.5875 | 37.54 | 37.5675 | 23364.0 |
| 2019-01-15 09:25:00 | AAPL | Stock | 37.5675 | 37.5725 | 37.5025 | 37.5575 | 18688.0 |
| 2019-01-15 09:30:00 | AAPL | Stock | 37.5675 | 37.65 | 37.5125 | 37.64 | 3566728.0 |
| 2019-01-15 09:35:00 | AAPL | Stock | 37.645 | 37.8375 | 37.645 | 37.776 | 2694544.0 |
> showing 50 of 353,536 rows — these rows as CSV