PREVIEW / stock_5min / 2019-07-12
file: by_date/stock_5min/2019/2019-07-12.parquet size: 5.6 MB rows: 349,856 symbols: 2,577
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-07-12 04:15:00 | AAPL | Stock | 50.54 | 50.59 | 50.54 | 50.59 | 1996.0 |
| 2019-07-12 04:40:00 | AAPL | Stock | 50.6 | 50.6 | 50.6 | 50.6 | 400.0 |
| 2019-07-12 05:00:00 | AAPL | Stock | 50.55 | 50.55 | 50.55 | 50.55 | 3480.0 |
| 2019-07-12 05:20:00 | AAPL | Stock | 50.5925 | 50.5925 | 50.5925 | 50.5925 | 400.0 |
| 2019-07-12 05:25:00 | AAPL | Stock | 50.555 | 50.555 | 50.55 | 50.55 | 2400.0 |
| 2019-07-12 05:30:00 | AAPL | Stock | 50.54 | 50.54 | 50.5375 | 50.5375 | 3680.0 |
| 2019-07-12 05:45:00 | AAPL | Stock | 50.5625 | 50.5625 | 50.5625 | 50.5625 | 400.0 |
| 2019-07-12 05:50:00 | AAPL | Stock | 50.5675 | 50.5675 | 50.5675 | 50.5675 | 1680.0 |
| 2019-07-12 06:05:00 | AAPL | Stock | 50.6 | 50.625 | 50.5975 | 50.625 | 10372.0 |
| 2019-07-12 06:10:00 | AAPL | Stock | 50.6425 | 50.6425 | 50.6375 | 50.6375 | 2400.0 |
| 2019-07-12 06:20:00 | AAPL | Stock | 50.65 | 50.6875 | 50.65 | 50.6875 | 3200.0 |
| 2019-07-12 06:30:00 | AAPL | Stock | 50.65 | 50.65 | 50.65 | 50.65 | 800.0 |
| 2019-07-12 06:40:00 | AAPL | Stock | 50.63 | 50.63 | 50.63 | 50.63 | 1020.0 |
| 2019-07-12 06:45:00 | AAPL | Stock | 50.675 | 50.675 | 50.5525 | 50.5525 | 2400.0 |
| 2019-07-12 06:50:00 | AAPL | Stock | 50.555 | 50.555 | 50.5275 | 50.5275 | 2000.0 |
| 2019-07-12 06:55:00 | AAPL | Stock | 50.5275 | 50.55 | 50.525 | 50.55 | 3896.0 |
| 2019-07-12 07:00:00 | AAPL | Stock | 50.54 | 50.595 | 50.53 | 50.59 | 9284.0 |
| 2019-07-12 07:05:00 | AAPL | Stock | 50.575 | 50.59 | 50.5675 | 50.5675 | 24100.0 |
| 2019-07-12 07:10:00 | AAPL | Stock | 50.575 | 50.5825 | 50.5675 | 50.5725 | 9412.0 |
| 2019-07-12 07:15:00 | AAPL | Stock | 50.575 | 50.575 | 50.55 | 50.55 | 9000.0 |
| 2019-07-12 07:20:00 | AAPL | Stock | 50.5525 | 50.5825 | 50.5525 | 50.575 | 1816.0 |
| 2019-07-12 07:25:00 | AAPL | Stock | 50.5775 | 50.595 | 50.5775 | 50.58 | 7636.0 |
| 2019-07-12 07:30:00 | AAPL | Stock | 50.5575 | 50.5775 | 50.5325 | 50.5325 | 20700.0 |
| 2019-07-12 07:35:00 | AAPL | Stock | 50.5725 | 50.575 | 50.5725 | 50.575 | 1200.0 |
| 2019-07-12 07:40:00 | AAPL | Stock | 50.5825 | 50.595 | 50.575 | 50.575 | 5200.0 |
| 2019-07-12 07:45:00 | AAPL | Stock | 50.5975 | 50.6 | 50.5975 | 50.6 | 14272.0 |
| 2019-07-12 07:50:00 | AAPL | Stock | 50.6025 | 50.62 | 50.6025 | 50.62 | 2000.0 |
| 2019-07-12 07:55:00 | AAPL | Stock | 50.595 | 50.595 | 50.595 | 50.595 | 800.0 |
| 2019-07-12 08:00:00 | AAPL | Stock | 50.5918 | 50.6 | 50.5625 | 50.595 | 80444.0 |
| 2019-07-12 08:05:00 | AAPL | Stock | 50.5875 | 50.6225 | 50.565 | 50.6 | 5900.0 |
| 2019-07-12 08:10:00 | AAPL | Stock | 50.6 | 50.6 | 50.6 | 50.6 | 400.0 |
| 2019-07-12 08:15:00 | AAPL | Stock | 50.5925 | 50.6125 | 50.5925 | 50.6125 | 1600.0 |
| 2019-07-12 08:20:00 | AAPL | Stock | 50.5875 | 50.6225 | 50.5875 | 50.6225 | 3556.0 |
| 2019-07-12 08:25:00 | AAPL | Stock | 50.62 | 50.62 | 50.6 | 50.6 | 4740.0 |
| 2019-07-12 08:30:00 | AAPL | Stock | 50.57 | 50.575 | 50.5375 | 50.5375 | 10400.0 |
| 2019-07-12 08:35:00 | AAPL | Stock | 50.54 | 50.5625 | 50.54 | 50.5625 | 8488.0 |
| 2019-07-12 08:40:00 | AAPL | Stock | 50.575 | 50.58 | 50.5625 | 50.57 | 8920.0 |
| 2019-07-12 08:45:00 | AAPL | Stock | 50.5875 | 50.601 | 50.565 | 50.565 | 8800.0 |
| 2019-07-12 08:50:00 | AAPL | Stock | 50.5825 | 50.5825 | 50.5575 | 50.5575 | 15044.0 |
| 2019-07-12 09:00:00 | AAPL | Stock | 50.5575 | 50.5575 | 50.54 | 50.5425 | 12000.0 |
| 2019-07-12 09:05:00 | AAPL | Stock | 50.5425 | 50.5425 | 50.5075 | 50.525 | 8516.0 |
| 2019-07-12 09:10:00 | AAPL | Stock | 50.52 | 50.535 | 50.4925 | 50.4925 | 24960.0 |
| 2019-07-12 09:15:00 | AAPL | Stock | 50.5 | 50.5275 | 50.5 | 50.5125 | 11332.0 |
| 2019-07-12 09:20:00 | AAPL | Stock | 50.5275 | 50.5375 | 50.5275 | 50.5375 | 6200.0 |
| 2019-07-12 09:25:00 | AAPL | Stock | 50.54 | 50.6325 | 50.515 | 50.6325 | 17464.0 |
| 2019-07-12 09:30:00 | AAPL | Stock | 50.6325 | 50.81 | 50.55 | 50.77 | 3441284.0 |
| 2019-07-12 09:35:00 | AAPL | Stock | 50.769 | 50.8025 | 50.7025 | 50.7612 | 1796148.0 |
| 2019-07-12 09:40:00 | AAPL | Stock | 50.765 | 50.8625 | 50.7475 | 50.8475 | 1911632.0 |
| 2019-07-12 09:45:00 | AAPL | Stock | 50.8475 | 50.9875 | 50.8425 | 50.975 | 1815944.0 |
| 2019-07-12 09:50:00 | AAPL | Stock | 50.975 | 50.9848 | 50.91 | 50.9648 | 1565676.0 |
> showing 50 of 349,856 rows — these rows as CSV