PREVIEW / stock_1min / 2019-04-22
file: by_date/stock_1min/2019/2019-04-22.parquet size: 15.2 MB rows: 1,058,625 symbols: 2,216
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-22 04:57:00 | AAPL | Stock | 50.9 | 50.9 | 50.9 | 50.9 | 400.0 |
| 2019-04-22 05:33:00 | AAPL | Stock | 50.825 | 50.825 | 50.825 | 50.825 | 400.0 |
| 2019-04-22 05:37:00 | AAPL | Stock | 50.8125 | 50.8125 | 50.8125 | 50.8125 | 400.0 |
| 2019-04-22 07:00:00 | AAPL | Stock | 50.8675 | 50.875 | 50.8675 | 50.875 | 4764.0 |
| 2019-04-22 07:02:00 | AAPL | Stock | 50.8725 | 50.8725 | 50.8725 | 50.8725 | 1200.0 |
| 2019-04-22 07:04:00 | AAPL | Stock | 50.875 | 50.875 | 50.875 | 50.875 | 400.0 |
| 2019-04-22 07:05:00 | AAPL | Stock | 50.875 | 50.875 | 50.875 | 50.875 | 400.0 |
| 2019-04-22 07:06:00 | AAPL | Stock | 50.875 | 50.875 | 50.875 | 50.875 | 400.0 |
| 2019-04-22 07:07:00 | AAPL | Stock | 50.855 | 50.855 | 50.855 | 50.855 | 1760.0 |
| 2019-04-22 07:10:00 | AAPL | Stock | 50.8425 | 50.865 | 50.8425 | 50.865 | 800.0 |
| 2019-04-22 07:11:00 | AAPL | Stock | 50.8375 | 50.8375 | 50.8375 | 50.8375 | 848.0 |
| 2019-04-22 07:13:00 | AAPL | Stock | 50.8425 | 50.8425 | 50.8425 | 50.8425 | 800.0 |
| 2019-04-22 07:14:00 | AAPL | Stock | 50.8375 | 50.8375 | 50.8375 | 50.8375 | 3996.0 |
| 2019-04-22 07:15:00 | AAPL | Stock | 50.8375 | 50.8625 | 50.8375 | 50.86 | 2408.0 |
| 2019-04-22 07:17:00 | AAPL | Stock | 50.8375 | 50.8375 | 50.8375 | 50.8375 | 400.0 |
| 2019-04-22 07:22:00 | AAPL | Stock | 50.855 | 50.855 | 50.855 | 50.855 | 400.0 |
| 2019-04-22 07:23:00 | AAPL | Stock | 50.8375 | 50.8375 | 50.8375 | 50.8375 | 500.0 |
| 2019-04-22 07:24:00 | AAPL | Stock | 50.8275 | 50.8275 | 50.8275 | 50.8275 | 2036.0 |
| 2019-04-22 07:29:00 | AAPL | Stock | 50.825 | 50.825 | 50.8225 | 50.8225 | 2176.0 |
| 2019-04-22 07:30:00 | AAPL | Stock | 50.8125 | 50.8125 | 50.8125 | 50.8125 | 2140.0 |
| 2019-04-22 07:31:00 | AAPL | Stock | 50.825 | 50.825 | 50.825 | 50.825 | 848.0 |
| 2019-04-22 07:36:00 | AAPL | Stock | 50.8275 | 50.8275 | 50.825 | 50.825 | 848.0 |
| 2019-04-22 07:37:00 | AAPL | Stock | 50.83 | 50.83 | 50.825 | 50.825 | 1896.0 |
| 2019-04-22 07:40:00 | AAPL | Stock | 50.825 | 50.825 | 50.825 | 50.825 | 1520.0 |
| 2019-04-22 07:45:00 | AAPL | Stock | 50.825 | 50.825 | 50.805 | 50.805 | 6508.0 |
| 2019-04-22 07:48:00 | AAPL | Stock | 50.7875 | 50.7875 | 50.7825 | 50.7825 | 1288.0 |
| 2019-04-22 07:57:00 | AAPL | Stock | 50.8 | 50.8 | 50.8 | 50.8 | 1584.0 |
| 2019-04-22 07:59:00 | AAPL | Stock | 50.8 | 50.8 | 50.8 | 50.8 | 1200.0 |
| 2019-04-22 08:00:00 | AAPL | Stock | 50.875 | 50.875 | 50.7825 | 50.7825 | 41760.0 |
| 2019-04-22 08:01:00 | AAPL | Stock | 50.8095 | 50.8095 | 50.805 | 50.805 | 1280.0 |
| 2019-04-22 08:02:00 | AAPL | Stock | 50.805 | 50.805 | 50.765 | 50.765 | 2720.0 |
| 2019-04-22 08:03:00 | AAPL | Stock | 50.775 | 50.775 | 50.7675 | 50.7675 | 4400.0 |
| 2019-04-22 08:04:00 | AAPL | Stock | 50.7675 | 50.7875 | 50.765 | 50.765 | 9324.0 |
| 2019-04-22 08:05:00 | AAPL | Stock | 50.7575 | 50.7875 | 50.7575 | 50.7875 | 3788.0 |
| 2019-04-22 08:06:00 | AAPL | Stock | 50.7725 | 50.7725 | 50.7625 | 50.765 | 4400.0 |
| 2019-04-22 08:07:00 | AAPL | Stock | 50.7875 | 50.7875 | 50.7875 | 50.7875 | 1200.0 |
| 2019-04-22 08:08:00 | AAPL | Stock | 50.76 | 50.775 | 50.76 | 50.775 | 3400.0 |
| 2019-04-22 08:09:00 | AAPL | Stock | 50.7875 | 50.7875 | 50.7875 | 50.7875 | 400.0 |
| 2019-04-22 08:10:00 | AAPL | Stock | 50.7875 | 50.7875 | 50.7875 | 50.7875 | 1600.0 |
| 2019-04-22 08:12:00 | AAPL | Stock | 50.775 | 50.7875 | 50.775 | 50.7875 | 1600.0 |
| 2019-04-22 08:15:00 | AAPL | Stock | 50.7875 | 50.7875 | 50.7875 | 50.7875 | 2680.0 |
| 2019-04-22 08:16:00 | AAPL | Stock | 50.76 | 50.76 | 50.715 | 50.715 | 27692.0 |
| 2019-04-22 08:17:00 | AAPL | Stock | 50.725 | 50.725 | 50.725 | 50.725 | 800.0 |
| 2019-04-22 08:19:00 | AAPL | Stock | 50.725 | 50.725 | 50.7225 | 50.725 | 4708.0 |
| 2019-04-22 08:20:00 | AAPL | Stock | 50.745 | 50.745 | 50.7425 | 50.7425 | 820.0 |
| 2019-04-22 08:21:00 | AAPL | Stock | 50.7425 | 50.7425 | 50.7275 | 50.7275 | 1240.0 |
| 2019-04-22 08:22:00 | AAPL | Stock | 50.7325 | 50.7475 | 50.7225 | 50.7475 | 8272.0 |
| 2019-04-22 08:23:00 | AAPL | Stock | 50.7475 | 50.7475 | 50.7475 | 50.7475 | 400.0 |
| 2019-04-22 08:24:00 | AAPL | Stock | 50.75 | 50.75 | 50.75 | 50.75 | 1200.0 |
| 2019-04-22 08:25:00 | AAPL | Stock | 50.76 | 50.7625 | 50.76 | 50.7625 | 956.0 |
> showing 50 of 1,058,625 rows — these rows as CSV