PREVIEW / stock_5min / 2019-08-01
file: by_date/stock_5min/2019/2019-08-01.parquet size: 6.0 MB rows: 372,862 symbols: 2,572
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-08-01 04:00:00 | AAPL | Stock | 53.5 | 53.5 | 53.5 | 53.5 | 400.0 |
| 2019-08-01 04:15:00 | AAPL | Stock | 53.4875 | 53.4925 | 53.485 | 53.4925 | 7680.0 |
| 2019-08-01 04:20:00 | AAPL | Stock | 53.4875 | 53.5 | 53.4875 | 53.4925 | 4192.0 |
| 2019-08-01 04:25:00 | AAPL | Stock | 53.4875 | 53.4875 | 53.4875 | 53.4875 | 552.0 |
| 2019-08-01 04:35:00 | AAPL | Stock | 53.45 | 53.45 | 53.45 | 53.45 | 2400.0 |
| 2019-08-01 04:40:00 | AAPL | Stock | 53.445 | 53.445 | 53.445 | 53.445 | 980.0 |
| 2019-08-01 04:45:00 | AAPL | Stock | 53.45 | 53.45 | 53.45 | 53.45 | 800.0 |
| 2019-08-01 05:05:00 | AAPL | Stock | 53.52 | 53.55 | 53.52 | 53.55 | 2400.0 |
| 2019-08-01 05:15:00 | AAPL | Stock | 53.53 | 53.53 | 53.53 | 53.53 | 2000.0 |
| 2019-08-01 05:25:00 | AAPL | Stock | 53.5475 | 53.55 | 53.5475 | 53.55 | 7640.0 |
| 2019-08-01 05:35:00 | AAPL | Stock | 53.5675 | 53.57 | 53.5675 | 53.57 | 3600.0 |
| 2019-08-01 05:40:00 | AAPL | Stock | 53.57 | 53.6125 | 53.57 | 53.6125 | 4404.0 |
| 2019-08-01 05:50:00 | AAPL | Stock | 53.6175 | 53.6175 | 53.6125 | 53.6125 | 1200.0 |
| 2019-08-01 05:55:00 | AAPL | Stock | 53.625 | 53.625 | 53.625 | 53.625 | 708.0 |
| 2019-08-01 06:10:00 | AAPL | Stock | 53.625 | 53.625 | 53.625 | 53.625 | 2600.0 |
| 2019-08-01 06:20:00 | AAPL | Stock | 53.625 | 53.67 | 53.625 | 53.67 | 11368.0 |
| 2019-08-01 06:25:00 | AAPL | Stock | 53.6725 | 53.675 | 53.6725 | 53.675 | 1600.0 |
| 2019-08-01 06:30:00 | AAPL | Stock | 53.675 | 53.675 | 53.675 | 53.675 | 600.0 |
| 2019-08-01 06:40:00 | AAPL | Stock | 53.7075 | 53.7075 | 53.6775 | 53.6775 | 1200.0 |
| 2019-08-01 06:45:00 | AAPL | Stock | 53.645 | 53.645 | 53.6 | 53.6 | 6520.0 |
| 2019-08-01 06:50:00 | AAPL | Stock | 53.5775 | 53.5775 | 53.5775 | 53.5775 | 400.0 |
| 2019-08-01 06:55:00 | AAPL | Stock | 53.575 | 53.625 | 53.575 | 53.625 | 4944.0 |
| 2019-08-01 07:00:00 | AAPL | Stock | 53.62 | 53.6375 | 53.5625 | 53.6375 | 18580.0 |
| 2019-08-01 07:05:00 | AAPL | Stock | 53.6275 | 53.6275 | 53.5875 | 53.5875 | 35072.0 |
| 2019-08-01 07:10:00 | AAPL | Stock | 53.5575 | 53.5725 | 53.55 | 53.55 | 14780.0 |
| 2019-08-01 07:15:00 | AAPL | Stock | 53.55 | 53.59 | 53.5375 | 53.59 | 11440.0 |
| 2019-08-01 07:20:00 | AAPL | Stock | 53.595 | 53.6 | 53.57 | 53.5775 | 9428.0 |
| 2019-08-01 07:25:00 | AAPL | Stock | 53.5525 | 53.5625 | 53.5375 | 53.5625 | 4620.0 |
| 2019-08-01 07:30:00 | AAPL | Stock | 53.59 | 53.6475 | 53.59 | 53.6475 | 7488.0 |
| 2019-08-01 07:35:00 | AAPL | Stock | 53.625 | 53.7 | 53.625 | 53.6775 | 32492.0 |
| 2019-08-01 07:40:00 | AAPL | Stock | 53.675 | 53.675 | 53.5825 | 53.6 | 39924.0 |
| 2019-08-01 07:45:00 | AAPL | Stock | 53.58 | 53.625 | 53.555 | 53.6025 | 12928.0 |
| 2019-08-01 07:50:00 | AAPL | Stock | 53.5625 | 53.6 | 53.555 | 53.575 | 7600.0 |
| 2019-08-01 07:55:00 | AAPL | Stock | 53.595 | 53.6375 | 53.595 | 53.6375 | 44736.0 |
| 2019-08-01 08:00:00 | AAPL | Stock | 53.6425 | 53.715 | 53.1275 | 53.62 | 198540.0 |
| 2019-08-01 08:05:00 | AAPL | Stock | 53.625 | 53.6625 | 53.555 | 53.5625 | 65184.0 |
| 2019-08-01 08:10:00 | AAPL | Stock | 53.595 | 53.6125 | 53.575 | 53.575 | 13720.0 |
| 2019-08-01 08:15:00 | AAPL | Stock | 53.5575 | 53.575 | 53.55 | 53.575 | 14412.0 |
| 2019-08-01 08:20:00 | AAPL | Stock | 53.26 | 53.6 | 53.26 | 53.5525 | 29208.0 |
| 2019-08-01 08:25:00 | AAPL | Stock | 53.55 | 53.5625 | 53.525 | 53.5275 | 34196.0 |
| 2019-08-01 08:30:00 | AAPL | Stock | 53.53 | 53.5675 | 53.53 | 53.55 | 19568.0 |
| 2019-08-01 08:35:00 | AAPL | Stock | 53.55 | 53.6 | 53.55 | 53.5875 | 20448.0 |
| 2019-08-01 08:40:00 | AAPL | Stock | 53.5908 | 53.6 | 53.5825 | 53.5825 | 4796.0 |
| 2019-08-01 08:45:00 | AAPL | Stock | 53.605 | 53.6125 | 53.5375 | 53.5375 | 27432.0 |
| 2019-08-01 08:50:00 | AAPL | Stock | 53.5375 | 53.5875 | 53.5375 | 53.5875 | 15904.0 |
| 2019-08-01 08:55:00 | AAPL | Stock | 53.5875 | 53.597 | 53.5625 | 53.58 | 20696.0 |
| 2019-08-01 09:00:00 | AAPL | Stock | 53.58 | 53.61 | 53.575 | 53.575 | 49952.0 |
| 2019-08-01 09:05:00 | AAPL | Stock | 53.5525 | 53.58 | 53.4638 | 53.5 | 97496.0 |
| 2019-08-01 09:10:00 | AAPL | Stock | 53.475 | 53.5325 | 53.415 | 53.45 | 86712.0 |
| 2019-08-01 09:15:00 | AAPL | Stock | 53.4275 | 53.5025 | 53.4025 | 53.475 | 24488.0 |
> showing 50 of 372,862 rows — these rows as CSV