PREVIEW / stock_5min / 2019-01-24
file: by_date/stock_5min/2019/2019-01-24.parquet size: 5.5 MB rows: 347,379 symbols: 2,676
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-24 04:10:00 | AAPL | Stock | 38.5475 | 38.55 | 38.5475 | 38.55 | 800.0 |
| 2019-01-24 04:15:00 | AAPL | Stock | 38.6 | 38.6225 | 38.6 | 38.6225 | 800.0 |
| 2019-01-24 04:20:00 | AAPL | Stock | 38.625 | 38.625 | 38.6225 | 38.6225 | 1172.0 |
| 2019-01-24 04:30:00 | AAPL | Stock | 38.6275 | 38.6275 | 38.5625 | 38.5625 | 19452.0 |
| 2019-01-24 05:10:00 | AAPL | Stock | 38.6975 | 38.6975 | 38.695 | 38.695 | 820.0 |
| 2019-01-24 05:30:00 | AAPL | Stock | 38.735 | 38.75 | 38.7325 | 38.75 | 16068.0 |
| 2019-01-24 05:35:00 | AAPL | Stock | 38.7225 | 38.7225 | 38.7225 | 38.7225 | 2144.0 |
| 2019-01-24 05:40:00 | AAPL | Stock | 38.7225 | 38.7225 | 38.6625 | 38.6625 | 3872.0 |
| 2019-01-24 05:45:00 | AAPL | Stock | 38.6625 | 38.6625 | 38.6625 | 38.6625 | 1072.0 |
| 2019-01-24 05:50:00 | AAPL | Stock | 38.6625 | 38.6625 | 38.6625 | 38.6625 | 3216.0 |
| 2019-01-24 05:55:00 | AAPL | Stock | 38.7225 | 38.7225 | 38.7225 | 38.7225 | 1012.0 |
| 2019-01-24 06:05:00 | AAPL | Stock | 38.7875 | 38.7875 | 38.7875 | 38.7875 | 2128.0 |
| 2019-01-24 06:10:00 | AAPL | Stock | 38.75 | 38.75 | 38.75 | 38.75 | 11640.0 |
| 2019-01-24 06:15:00 | AAPL | Stock | 38.7475 | 38.75 | 38.7475 | 38.75 | 8000.0 |
| 2019-01-24 06:20:00 | AAPL | Stock | 38.6775 | 38.68 | 38.6625 | 38.6625 | 3532.0 |
| 2019-01-24 06:30:00 | AAPL | Stock | 38.725 | 38.725 | 38.725 | 38.725 | 800.0 |
| 2019-01-24 06:35:00 | AAPL | Stock | 38.6775 | 38.6775 | 38.665 | 38.665 | 2000.0 |
| 2019-01-24 06:40:00 | AAPL | Stock | 38.675 | 38.7 | 38.675 | 38.675 | 7132.0 |
| 2019-01-24 07:00:00 | AAPL | Stock | 38.675 | 38.7 | 38.625 | 38.675 | 16316.0 |
| 2019-01-24 07:05:00 | AAPL | Stock | 38.6825 | 38.6875 | 38.65 | 38.65 | 6368.0 |
| 2019-01-24 07:10:00 | AAPL | Stock | 38.65 | 38.675 | 38.65 | 38.675 | 3472.0 |
| 2019-01-24 07:15:00 | AAPL | Stock | 38.675 | 38.675 | 38.655 | 38.655 | 3816.0 |
| 2019-01-24 07:20:00 | AAPL | Stock | 38.65 | 38.65 | 38.6475 | 38.65 | 3000.0 |
| 2019-01-24 07:25:00 | AAPL | Stock | 38.65 | 38.6625 | 38.65 | 38.6625 | 5504.0 |
| 2019-01-24 07:30:00 | AAPL | Stock | 38.65 | 38.65 | 38.635 | 38.635 | 8252.0 |
| 2019-01-24 07:40:00 | AAPL | Stock | 38.6625 | 38.6625 | 38.6625 | 38.6625 | 1000.0 |
| 2019-01-24 07:45:00 | AAPL | Stock | 38.65 | 38.65 | 38.625 | 38.6275 | 4384.0 |
| 2019-01-24 07:50:00 | AAPL | Stock | 38.6475 | 38.65 | 38.625 | 38.625 | 20472.0 |
| 2019-01-24 07:55:00 | AAPL | Stock | 38.585 | 38.585 | 38.585 | 38.585 | 892.0 |
| 2019-01-24 08:00:00 | AAPL | Stock | 38.6875 | 38.7 | 38.575 | 38.6125 | 39248.0 |
| 2019-01-24 08:05:00 | AAPL | Stock | 38.6125 | 38.65 | 38.6125 | 38.65 | 7252.0 |
| 2019-01-24 08:10:00 | AAPL | Stock | 38.64 | 38.6425 | 38.64 | 38.64 | 7200.0 |
| 2019-01-24 08:15:00 | AAPL | Stock | 38.65 | 38.65 | 38.635 | 38.64 | 12008.0 |
| 2019-01-24 08:20:00 | AAPL | Stock | 38.6475 | 38.665 | 38.6475 | 38.6625 | 28244.0 |
| 2019-01-24 08:25:00 | AAPL | Stock | 38.64 | 38.66 | 38.625 | 38.625 | 24872.0 |
| 2019-01-24 08:30:00 | AAPL | Stock | 38.625 | 38.65 | 38.4625 | 38.5365 | 116252.0 |
| 2019-01-24 08:35:00 | AAPL | Stock | 38.4825 | 38.55 | 38.45 | 38.55 | 55960.0 |
| 2019-01-24 08:40:00 | AAPL | Stock | 38.5425 | 38.5825 | 38.49 | 38.49 | 18320.0 |
| 2019-01-24 08:45:00 | AAPL | Stock | 38.5625 | 38.5625 | 38.49 | 38.49 | 4260.0 |
| 2019-01-24 08:50:00 | AAPL | Stock | 38.495 | 38.495 | 38.3925 | 38.4 | 103384.0 |
| 2019-01-24 08:55:00 | AAPL | Stock | 38.415 | 38.4325 | 38.4 | 38.425 | 11220.0 |
| 2019-01-24 09:00:00 | AAPL | Stock | 38.4225 | 38.535 | 38.4075 | 38.535 | 35360.0 |
| 2019-01-24 09:05:00 | AAPL | Stock | 38.525 | 38.54 | 38.5 | 38.5375 | 10696.0 |
| 2019-01-24 09:10:00 | AAPL | Stock | 38.5525 | 38.645 | 38.55 | 38.6025 | 26376.0 |
| 2019-01-24 09:15:00 | AAPL | Stock | 38.625 | 38.6625 | 38.5875 | 38.59 | 24484.0 |
| 2019-01-24 09:20:00 | AAPL | Stock | 38.575 | 38.5875 | 38.5625 | 38.575 | 11416.0 |
| 2019-01-24 09:25:00 | AAPL | Stock | 38.575 | 38.575 | 38.465 | 38.475 | 16108.0 |
| 2019-01-24 09:30:00 | AAPL | Stock | 38.5325 | 38.6075 | 38.4075 | 38.5662 | 2808716.0 |
| 2019-01-24 09:35:00 | AAPL | Stock | 38.57 | 38.62 | 38.505 | 38.53 | 1420968.0 |
| 2019-01-24 09:40:00 | AAPL | Stock | 38.5325 | 38.5475 | 38.4 | 38.442 | 1857708.0 |
> showing 50 of 347,379 rows — these rows as CSV