PREVIEW / stock_1min / 2019-04-11
file: by_date/stock_1min/2019/2019-04-11.parquet size: 14.6 MB rows: 1,046,423 symbols: 2,209
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-04-11 04:21:00 | AAPL | Stock | 50.0975 | 50.0975 | 50.0975 | 50.0975 | 408.0 |
| 2019-04-11 04:31:00 | AAPL | Stock | 50.1225 | 50.125 | 50.1225 | 50.125 | 4012.0 |
| 2019-04-11 05:04:00 | AAPL | Stock | 50.125 | 50.125 | 50.125 | 50.125 | 2072.0 |
| 2019-04-11 05:24:00 | AAPL | Stock | 50.15 | 50.15 | 50.15 | 50.15 | 1996.0 |
| 2019-04-11 05:32:00 | AAPL | Stock | 50.125 | 50.125 | 50.125 | 50.125 | 800.0 |
| 2019-04-11 05:38:00 | AAPL | Stock | 50.1 | 50.1 | 50.1 | 50.1 | 10004.0 |
| 2019-04-11 05:45:00 | AAPL | Stock | 50.09 | 50.09 | 50.09 | 50.09 | 2000.0 |
| 2019-04-11 06:06:00 | AAPL | Stock | 50.1525 | 50.155 | 50.1525 | 50.155 | 812.0 |
| 2019-04-11 06:07:00 | AAPL | Stock | 50.175 | 50.175 | 50.175 | 50.175 | 400.0 |
| 2019-04-11 06:24:00 | AAPL | Stock | 50.175 | 50.175 | 50.175 | 50.175 | 800.0 |
| 2019-04-11 06:41:00 | AAPL | Stock | 50.15 | 50.15 | 50.15 | 50.15 | 400.0 |
| 2019-04-11 06:45:00 | AAPL | Stock | 50.17 | 50.175 | 50.17 | 50.175 | 3184.0 |
| 2019-04-11 06:54:00 | AAPL | Stock | 50.175 | 50.175 | 50.175 | 50.175 | 400.0 |
| 2019-04-11 06:59:00 | AAPL | Stock | 50.125 | 50.125 | 50.125 | 50.125 | 480.0 |
| 2019-04-11 07:00:00 | AAPL | Stock | 50.1875 | 50.2025 | 50.155 | 50.195 | 22396.0 |
| 2019-04-11 07:01:00 | AAPL | Stock | 50.195 | 50.195 | 50.195 | 50.195 | 2000.0 |
| 2019-04-11 07:02:00 | AAPL | Stock | 50.19 | 50.2125 | 50.19 | 50.2125 | 3344.0 |
| 2019-04-11 07:03:00 | AAPL | Stock | 50.225 | 50.225 | 50.2225 | 50.225 | 2668.0 |
| 2019-04-11 07:04:00 | AAPL | Stock | 50.25 | 50.25 | 50.225 | 50.225 | 15312.0 |
| 2019-04-11 07:09:00 | AAPL | Stock | 50.235 | 50.235 | 50.235 | 50.235 | 2000.0 |
| 2019-04-11 07:10:00 | AAPL | Stock | 50.22 | 50.22 | 50.215 | 50.215 | 1864.0 |
| 2019-04-11 07:11:00 | AAPL | Stock | 50.2125 | 50.2125 | 50.2125 | 50.2125 | 2396.0 |
| 2019-04-11 07:14:00 | AAPL | Stock | 50.22 | 50.22 | 50.22 | 50.22 | 800.0 |
| 2019-04-11 07:17:00 | AAPL | Stock | 50.2025 | 50.215 | 50.2025 | 50.215 | 3400.0 |
| 2019-04-11 07:18:00 | AAPL | Stock | 50.225 | 50.225 | 50.225 | 50.225 | 676.0 |
| 2019-04-11 07:21:00 | AAPL | Stock | 50.2125 | 50.2175 | 50.2125 | 50.2175 | 2384.0 |
| 2019-04-11 07:22:00 | AAPL | Stock | 50.2175 | 50.2175 | 50.2175 | 50.2175 | 720.0 |
| 2019-04-11 07:23:00 | AAPL | Stock | 50.2375 | 50.25 | 50.2375 | 50.25 | 20520.0 |
| 2019-04-11 07:24:00 | AAPL | Stock | 50.27 | 50.275 | 50.24 | 50.24 | 3600.0 |
| 2019-04-11 07:25:00 | AAPL | Stock | 50.25 | 50.2625 | 50.25 | 50.2625 | 6600.0 |
| 2019-04-11 07:26:00 | AAPL | Stock | 50.2675 | 50.2875 | 50.2625 | 50.2875 | 4592.0 |
| 2019-04-11 07:27:00 | AAPL | Stock | 50.25 | 50.25 | 50.25 | 50.25 | 400.0 |
| 2019-04-11 07:30:00 | AAPL | Stock | 50.3 | 50.3 | 50.3 | 50.3 | 400.0 |
| 2019-04-11 07:31:00 | AAPL | Stock | 50.3075 | 50.31 | 50.305 | 50.3075 | 4000.0 |
| 2019-04-11 07:33:00 | AAPL | Stock | 50.2825 | 50.2825 | 50.2825 | 50.2825 | 9600.0 |
| 2019-04-11 07:34:00 | AAPL | Stock | 50.27 | 50.27 | 50.27 | 50.27 | 4800.0 |
| 2019-04-11 07:35:00 | AAPL | Stock | 50.2925 | 50.2925 | 50.2725 | 50.2725 | 5600.0 |
| 2019-04-11 07:36:00 | AAPL | Stock | 50.275 | 50.275 | 50.275 | 50.275 | 1204.0 |
| 2019-04-11 07:37:00 | AAPL | Stock | 50.27 | 50.275 | 50.265 | 50.275 | 3080.0 |
| 2019-04-11 07:39:00 | AAPL | Stock | 50.275 | 50.275 | 50.265 | 50.275 | 11260.0 |
| 2019-04-11 07:40:00 | AAPL | Stock | 50.265 | 50.275 | 50.25 | 50.275 | 36636.0 |
| 2019-04-11 07:41:00 | AAPL | Stock | 50.24 | 50.255 | 50.2375 | 50.255 | 2400.0 |
| 2019-04-11 07:42:00 | AAPL | Stock | 50.2625 | 50.2625 | 50.25 | 50.25 | 800.0 |
| 2019-04-11 07:44:00 | AAPL | Stock | 50.2725 | 50.2725 | 50.2725 | 50.2725 | 400.0 |
| 2019-04-11 07:45:00 | AAPL | Stock | 50.27 | 50.275 | 50.27 | 50.275 | 2200.0 |
| 2019-04-11 07:46:00 | AAPL | Stock | 50.275 | 50.2825 | 50.275 | 50.2825 | 800.0 |
| 2019-04-11 07:48:00 | AAPL | Stock | 50.305 | 50.3075 | 50.305 | 50.3075 | 800.0 |
| 2019-04-11 07:49:00 | AAPL | Stock | 50.32 | 50.32 | 50.32 | 50.32 | 400.0 |
| 2019-04-11 07:50:00 | AAPL | Stock | 50.32 | 50.32 | 50.32 | 50.32 | 1400.0 |
| 2019-04-11 07:51:00 | AAPL | Stock | 50.32 | 50.32 | 50.32 | 50.32 | 1704.0 |
> showing 50 of 1,046,423 rows — these rows as CSV