PREVIEW / stock_1min / 2019-11-05
file: by_date/stock_1min/2019/2019-11-05.parquet size: 16.5 MB rows: 1,140,861 symbols: 2,134
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-11-05 04:02:00 | AAPL | Stock | 64.55 | 64.55 | 64.55 | 64.55 | 8000.0 |
| 2019-11-05 04:08:00 | AAPL | Stock | 64.5625 | 64.5625 | 64.5625 | 64.5625 | 1600.0 |
| 2019-11-05 04:11:00 | AAPL | Stock | 64.605 | 64.605 | 64.605 | 64.605 | 1252.0 |
| 2019-11-05 04:24:00 | AAPL | Stock | 64.5 | 64.5 | 64.5 | 64.5 | 3692.0 |
| 2019-11-05 04:27:00 | AAPL | Stock | 64.5625 | 64.5625 | 64.5625 | 64.5625 | 1200.0 |
| 2019-11-05 04:29:00 | AAPL | Stock | 64.5625 | 64.5625 | 64.5625 | 64.5625 | 800.0 |
| 2019-11-05 04:33:00 | AAPL | Stock | 64.5625 | 64.5625 | 64.5625 | 64.5625 | 800.0 |
| 2019-11-05 04:36:00 | AAPL | Stock | 64.585 | 64.585 | 64.585 | 64.585 | 540.0 |
| 2019-11-05 04:40:00 | AAPL | Stock | 64.605 | 64.605 | 64.605 | 64.605 | 1936.0 |
| 2019-11-05 04:45:00 | AAPL | Stock | 64.575 | 64.575 | 64.575 | 64.575 | 1200.0 |
| 2019-11-05 05:14:00 | AAPL | Stock | 64.5625 | 64.5625 | 64.5625 | 64.5625 | 400.0 |
| 2019-11-05 06:30:00 | AAPL | Stock | 64.4775 | 64.4775 | 64.4775 | 64.4775 | 1668.0 |
| 2019-11-05 06:31:00 | AAPL | Stock | 64.4775 | 64.4775 | 64.47 | 64.47 | 4608.0 |
| 2019-11-05 06:41:00 | AAPL | Stock | 64.4675 | 64.4675 | 64.4675 | 64.4675 | 800.0 |
| 2019-11-05 07:00:00 | AAPL | Stock | 64.4625 | 64.5 | 64.4625 | 64.5 | 9228.0 |
| 2019-11-05 07:01:00 | AAPL | Stock | 64.4775 | 64.4875 | 64.4775 | 64.4875 | 8712.0 |
| 2019-11-05 07:02:00 | AAPL | Stock | 64.5 | 64.5175 | 64.5 | 64.5075 | 9100.0 |
| 2019-11-05 07:03:00 | AAPL | Stock | 64.525 | 64.525 | 64.525 | 64.525 | 1640.0 |
| 2019-11-05 07:04:00 | AAPL | Stock | 64.52 | 64.53 | 64.52 | 64.53 | 7208.0 |
| 2019-11-05 07:05:00 | AAPL | Stock | 64.515 | 64.53 | 64.5125 | 64.53 | 5200.0 |
| 2019-11-05 07:06:00 | AAPL | Stock | 64.535 | 64.5375 | 64.535 | 64.5375 | 1600.0 |
| 2019-11-05 07:07:00 | AAPL | Stock | 64.5325 | 64.535 | 64.5325 | 64.5325 | 2780.0 |
| 2019-11-05 07:08:00 | AAPL | Stock | 64.5325 | 64.5325 | 64.5325 | 64.5325 | 400.0 |
| 2019-11-05 07:09:00 | AAPL | Stock | 64.5325 | 64.5325 | 64.5325 | 64.5325 | 1600.0 |
| 2019-11-05 07:12:00 | AAPL | Stock | 64.5225 | 64.5225 | 64.5125 | 64.5125 | 5200.0 |
| 2019-11-05 07:13:00 | AAPL | Stock | 64.5125 | 64.5125 | 64.5125 | 64.5125 | 800.0 |
| 2019-11-05 07:15:00 | AAPL | Stock | 64.525 | 64.525 | 64.525 | 64.525 | 1796.0 |
| 2019-11-05 07:16:00 | AAPL | Stock | 64.515 | 64.515 | 64.51 | 64.51 | 5864.0 |
| 2019-11-05 07:18:00 | AAPL | Stock | 64.51 | 64.51 | 64.51 | 64.51 | 600.0 |
| 2019-11-05 07:19:00 | AAPL | Stock | 64.5125 | 64.5125 | 64.5025 | 64.5025 | 2084.0 |
| 2019-11-05 07:20:00 | AAPL | Stock | 64.52 | 64.52 | 64.5 | 64.5 | 5236.0 |
| 2019-11-05 07:21:00 | AAPL | Stock | 64.5 | 64.5 | 64.48 | 64.48 | 7976.0 |
| 2019-11-05 07:22:00 | AAPL | Stock | 64.4775 | 64.4775 | 64.475 | 64.475 | 6400.0 |
| 2019-11-05 07:24:00 | AAPL | Stock | 64.4725 | 64.475 | 64.4725 | 64.475 | 3432.0 |
| 2019-11-05 07:25:00 | AAPL | Stock | 64.475 | 64.475 | 64.475 | 64.475 | 400.0 |
| 2019-11-05 07:26:00 | AAPL | Stock | 64.4625 | 64.4875 | 64.45 | 64.45 | 11420.0 |
| 2019-11-05 07:27:00 | AAPL | Stock | 64.475 | 64.4875 | 64.475 | 64.4875 | 5556.0 |
| 2019-11-05 07:29:00 | AAPL | Stock | 64.505 | 64.505 | 64.5 | 64.5 | 6160.0 |
| 2019-11-05 07:31:00 | AAPL | Stock | 64.49 | 64.49 | 64.4875 | 64.4875 | 6808.0 |
| 2019-11-05 07:32:00 | AAPL | Stock | 64.4675 | 64.4675 | 64.45 | 64.465 | 7968.0 |
| 2019-11-05 07:33:00 | AAPL | Stock | 64.46 | 64.46 | 64.455 | 64.455 | 1200.0 |
| 2019-11-05 07:34:00 | AAPL | Stock | 64.455 | 64.455 | 64.455 | 64.455 | 1200.0 |
| 2019-11-05 07:37:00 | AAPL | Stock | 64.4675 | 64.4675 | 64.4675 | 64.4675 | 400.0 |
| 2019-11-05 07:41:00 | AAPL | Stock | 64.465 | 64.465 | 64.465 | 64.465 | 3796.0 |
| 2019-11-05 07:42:00 | AAPL | Stock | 64.465 | 64.465 | 64.465 | 64.465 | 1840.0 |
| 2019-11-05 07:44:00 | AAPL | Stock | 64.4575 | 64.4575 | 64.4575 | 64.4575 | 800.0 |
| 2019-11-05 07:45:00 | AAPL | Stock | 64.4525 | 64.4525 | 64.4525 | 64.4525 | 2000.0 |
| 2019-11-05 07:46:00 | AAPL | Stock | 64.475 | 64.4875 | 64.475 | 64.4875 | 2400.0 |
| 2019-11-05 07:47:00 | AAPL | Stock | 64.4875 | 64.4875 | 64.4875 | 64.4875 | 616.0 |
| 2019-11-05 07:48:00 | AAPL | Stock | 64.495 | 64.495 | 64.495 | 64.495 | 400.0 |
> showing 50 of 1,140,861 rows — these rows as CSV