PREVIEW / stock_1min / 2018-11-19
file: by_date/stock_1min/2018/2018-11-19.parquet size: 15.9 MB rows: 1,108,953 symbols: 2,314
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 |
|---|---|---|---|---|---|---|---|
| 2018-11-19 04:00:00 | AAPL | Stock | 48.6775 | 48.7 | 48.6775 | 48.7 | 5424.0 |
| 2018-11-19 04:04:00 | AAPL | Stock | 48.6725 | 48.6725 | 48.6625 | 48.6625 | 3996.0 |
| 2018-11-19 04:11:00 | AAPL | Stock | 48.625 | 48.625 | 48.625 | 48.625 | 400.0 |
| 2018-11-19 04:14:00 | AAPL | Stock | 48.5875 | 48.5875 | 48.5875 | 48.5875 | 400.0 |
| 2018-11-19 04:15:00 | AAPL | Stock | 48.525 | 48.525 | 48.3825 | 48.3825 | 20024.0 |
| 2018-11-19 04:16:00 | AAPL | Stock | 48.35 | 48.35 | 48.18 | 48.18 | 4156.0 |
| 2018-11-19 04:17:00 | AAPL | Stock | 48.1 | 48.1 | 48.1 | 48.1 | 2400.0 |
| 2018-11-19 04:18:00 | AAPL | Stock | 48.1025 | 48.1275 | 48.075 | 48.1275 | 1612.0 |
| 2018-11-19 04:20:00 | AAPL | Stock | 48.13 | 48.13 | 48.13 | 48.13 | 400.0 |
| 2018-11-19 04:21:00 | AAPL | Stock | 48.1225 | 48.1225 | 48.075 | 48.1225 | 1600.0 |
| 2018-11-19 04:22:00 | AAPL | Stock | 48.075 | 48.075 | 48.075 | 48.075 | 400.0 |
| 2018-11-19 04:23:00 | AAPL | Stock | 48.05 | 48.05 | 48.0 | 48.0 | 2692.0 |
| 2018-11-19 04:32:00 | AAPL | Stock | 48.0225 | 48.025 | 48.0225 | 48.025 | 2704.0 |
| 2018-11-19 04:33:00 | AAPL | Stock | 48.0 | 48.02 | 48.0 | 48.02 | 1200.0 |
| 2018-11-19 04:34:00 | AAPL | Stock | 48.025 | 48.06 | 48.025 | 48.06 | 4000.0 |
| 2018-11-19 04:38:00 | AAPL | Stock | 47.9625 | 47.9625 | 47.96 | 47.96 | 1200.0 |
| 2018-11-19 04:41:00 | AAPL | Stock | 47.875 | 47.875 | 47.875 | 47.875 | 400.0 |
| 2018-11-19 04:43:00 | AAPL | Stock | 47.875 | 47.875 | 47.87 | 47.87 | 1000.0 |
| 2018-11-19 04:44:00 | AAPL | Stock | 47.875 | 47.875 | 47.875 | 47.875 | 400.0 |
| 2018-11-19 04:47:00 | AAPL | Stock | 47.9 | 47.9 | 47.9 | 47.9 | 2000.0 |
| 2018-11-19 04:48:00 | AAPL | Stock | 47.9125 | 47.9125 | 47.9125 | 47.9125 | 400.0 |
| 2018-11-19 04:49:00 | AAPL | Stock | 47.9125 | 47.9125 | 47.9125 | 47.9125 | 400.0 |
| 2018-11-19 04:51:00 | AAPL | Stock | 47.865 | 47.865 | 47.865 | 47.865 | 644.0 |
| 2018-11-19 04:52:00 | AAPL | Stock | 47.8575 | 47.8575 | 47.8575 | 47.8575 | 400.0 |
| 2018-11-19 04:55:00 | AAPL | Stock | 47.8575 | 47.8575 | 47.8575 | 47.8575 | 3004.0 |
| 2018-11-19 04:59:00 | AAPL | Stock | 47.9 | 47.9 | 47.9 | 47.9 | 800.0 |
| 2018-11-19 05:06:00 | AAPL | Stock | 47.9 | 47.9 | 47.9 | 47.9 | 400.0 |
| 2018-11-19 05:08:00 | AAPL | Stock | 47.895 | 47.895 | 47.895 | 47.895 | 1392.0 |
| 2018-11-19 05:09:00 | AAPL | Stock | 47.9 | 47.9 | 47.9 | 47.9 | 400.0 |
| 2018-11-19 05:13:00 | AAPL | Stock | 47.9 | 47.9 | 47.9 | 47.9 | 1592.0 |
| 2018-11-19 05:17:00 | AAPL | Stock | 47.9 | 47.9 | 47.9 | 47.9 | 1600.0 |
| 2018-11-19 05:20:00 | AAPL | Stock | 47.9 | 47.9 | 47.9 | 47.9 | 1600.0 |
| 2018-11-19 05:21:00 | AAPL | Stock | 47.8875 | 47.8875 | 47.8875 | 47.8875 | 800.0 |
| 2018-11-19 05:23:00 | AAPL | Stock | 47.8875 | 47.8875 | 47.8875 | 47.8875 | 400.0 |
| 2018-11-19 05:24:00 | AAPL | Stock | 47.875 | 47.875 | 47.875 | 47.875 | 520.0 |
| 2018-11-19 05:26:00 | AAPL | Stock | 47.8875 | 47.8875 | 47.8875 | 47.8875 | 600.0 |
| 2018-11-19 05:41:00 | AAPL | Stock | 47.8725 | 47.8725 | 47.8725 | 47.8725 | 800.0 |
| 2018-11-19 05:44:00 | AAPL | Stock | 47.83 | 47.83 | 47.8 | 47.8 | 4676.0 |
| 2018-11-19 05:45:00 | AAPL | Stock | 47.825 | 47.825 | 47.825 | 47.825 | 800.0 |
| 2018-11-19 05:47:00 | AAPL | Stock | 47.775 | 47.775 | 47.775 | 47.775 | 3900.0 |
| 2018-11-19 05:48:00 | AAPL | Stock | 47.7625 | 47.7625 | 47.75 | 47.75 | 1200.0 |
| 2018-11-19 05:49:00 | AAPL | Stock | 47.75 | 47.75 | 47.75 | 47.75 | 1608.0 |
| 2018-11-19 05:50:00 | AAPL | Stock | 47.75 | 47.75 | 47.75 | 47.75 | 400.0 |
| 2018-11-19 05:53:00 | AAPL | Stock | 47.6975 | 47.6975 | 47.69 | 47.69 | 2360.0 |
| 2018-11-19 05:55:00 | AAPL | Stock | 47.69 | 47.69 | 47.69 | 47.69 | 3760.0 |
| 2018-11-19 05:56:00 | AAPL | Stock | 47.685 | 47.6875 | 47.635 | 47.635 | 3320.0 |
| 2018-11-19 05:57:00 | AAPL | Stock | 47.625 | 47.625 | 47.625 | 47.625 | 400.0 |
| 2018-11-19 05:59:00 | AAPL | Stock | 47.62 | 47.62 | 47.62 | 47.62 | 760.0 |
| 2018-11-19 06:01:00 | AAPL | Stock | 47.68 | 47.68 | 47.68 | 47.68 | 1200.0 |
| 2018-11-19 06:02:00 | AAPL | Stock | 47.675 | 47.68 | 47.675 | 47.68 | 1196.0 |
> showing 50 of 1,108,953 rows — these rows as CSV