PREVIEW / stock_1min / 2019-07-15
file: by_date/stock_1min/2019/2019-07-15.parquet size: 14.6 MB rows: 1,046,107 symbols: 2,164
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-07-15 04:23:00 | AAPL | Stock | 50.8825 | 50.8825 | 50.8825 | 50.8825 | 800.0 |
| 2019-07-15 04:24:00 | AAPL | Stock | 50.865 | 50.865 | 50.865 | 50.865 | 400.0 |
| 2019-07-15 05:21:00 | AAPL | Stock | 50.8875 | 50.8875 | 50.8875 | 50.8875 | 1000.0 |
| 2019-07-15 05:36:00 | AAPL | Stock | 50.8625 | 50.8625 | 50.8625 | 50.8625 | 2000.0 |
| 2019-07-15 05:42:00 | AAPL | Stock | 50.865 | 50.865 | 50.865 | 50.865 | 400.0 |
| 2019-07-15 06:02:00 | AAPL | Stock | 50.865 | 50.865 | 50.865 | 50.865 | 3720.0 |
| 2019-07-15 06:03:00 | AAPL | Stock | 50.865 | 50.865 | 50.865 | 50.865 | 600.0 |
| 2019-07-15 07:00:00 | AAPL | Stock | 50.88 | 50.915 | 50.88 | 50.915 | 1384.0 |
| 2019-07-15 07:01:00 | AAPL | Stock | 50.9325 | 50.9325 | 50.9325 | 50.9325 | 3200.0 |
| 2019-07-15 07:03:00 | AAPL | Stock | 50.9425 | 50.9525 | 50.9375 | 50.9525 | 7484.0 |
| 2019-07-15 07:04:00 | AAPL | Stock | 50.95 | 50.95 | 50.925 | 50.925 | 1760.0 |
| 2019-07-15 07:16:00 | AAPL | Stock | 50.9625 | 50.9625 | 50.9625 | 50.9625 | 1600.0 |
| 2019-07-15 07:17:00 | AAPL | Stock | 50.9325 | 50.9325 | 50.9325 | 50.9325 | 400.0 |
| 2019-07-15 07:20:00 | AAPL | Stock | 50.9375 | 50.9375 | 50.9325 | 50.9325 | 1108.0 |
| 2019-07-15 07:31:00 | AAPL | Stock | 50.9625 | 50.9625 | 50.95 | 50.95 | 3536.0 |
| 2019-07-15 07:32:00 | AAPL | Stock | 50.95 | 50.95 | 50.95 | 50.95 | 448.0 |
| 2019-07-15 07:34:00 | AAPL | Stock | 50.9525 | 50.9525 | 50.9525 | 50.9525 | 752.0 |
| 2019-07-15 07:41:00 | AAPL | Stock | 50.93 | 50.93 | 50.93 | 50.93 | 2400.0 |
| 2019-07-15 07:42:00 | AAPL | Stock | 50.9325 | 50.9325 | 50.9325 | 50.9325 | 708.0 |
| 2019-07-15 07:44:00 | AAPL | Stock | 50.9375 | 50.9375 | 50.9375 | 50.9375 | 4000.0 |
| 2019-07-15 07:54:00 | AAPL | Stock | 50.9625 | 50.9625 | 50.9625 | 50.9625 | 8848.0 |
| 2019-07-15 07:57:00 | AAPL | Stock | 50.9625 | 50.9625 | 50.9625 | 50.9625 | 800.0 |
| 2019-07-15 07:58:00 | AAPL | Stock | 50.95 | 50.95 | 50.95 | 50.95 | 1000.0 |
| 2019-07-15 08:00:00 | AAPL | Stock | 50.9125 | 50.9875 | 50.9 | 50.9375 | 46728.0 |
| 2019-07-15 08:01:00 | AAPL | Stock | 50.9625 | 50.9625 | 50.9625 | 50.9625 | 2000.0 |
| 2019-07-15 08:11:00 | AAPL | Stock | 50.9625 | 50.965 | 50.9625 | 50.965 | 800.0 |
| 2019-07-15 08:14:00 | AAPL | Stock | 50.9725 | 50.9725 | 50.9725 | 50.9725 | 5196.0 |
| 2019-07-15 08:15:00 | AAPL | Stock | 50.9675 | 50.97 | 50.9675 | 50.9675 | 2016.0 |
| 2019-07-15 08:16:00 | AAPL | Stock | 50.9825 | 50.9825 | 50.9825 | 50.9825 | 3708.0 |
| 2019-07-15 08:17:00 | AAPL | Stock | 50.9875 | 50.9875 | 50.9825 | 50.985 | 1400.0 |
| 2019-07-15 08:19:00 | AAPL | Stock | 50.965 | 50.965 | 50.9625 | 50.9625 | 8884.0 |
| 2019-07-15 08:23:00 | AAPL | Stock | 50.9575 | 50.9575 | 50.94 | 50.94 | 1000.0 |
| 2019-07-15 08:28:00 | AAPL | Stock | 50.975 | 50.975 | 50.975 | 50.975 | 800.0 |
| 2019-07-15 08:29:00 | AAPL | Stock | 50.9875 | 50.9875 | 50.9875 | 50.9875 | 1400.0 |
| 2019-07-15 08:30:00 | AAPL | Stock | 50.98 | 50.9875 | 50.98 | 50.9875 | 4352.0 |
| 2019-07-15 08:34:00 | AAPL | Stock | 50.975 | 50.975 | 50.975 | 50.975 | 800.0 |
| 2019-07-15 08:35:00 | AAPL | Stock | 50.9875 | 50.9875 | 50.9875 | 50.9875 | 400.0 |
| 2019-07-15 08:38:00 | AAPL | Stock | 50.9875 | 50.9875 | 50.9875 | 50.9875 | 400.0 |
| 2019-07-15 08:39:00 | AAPL | Stock | 50.9575 | 50.9575 | 50.9575 | 50.9575 | 400.0 |
| 2019-07-15 08:46:00 | AAPL | Stock | 50.975 | 50.975 | 50.975 | 50.975 | 400.0 |
| 2019-07-15 08:47:00 | AAPL | Stock | 50.985 | 50.9875 | 50.985 | 50.9875 | 3200.0 |
| 2019-07-15 08:48:00 | AAPL | Stock | 50.9875 | 50.99 | 50.9875 | 50.99 | 2000.0 |
| 2019-07-15 08:49:00 | AAPL | Stock | 50.995 | 50.9975 | 50.995 | 50.9975 | 1324.0 |
| 2019-07-15 08:51:00 | AAPL | Stock | 51.0 | 51.0 | 51.0 | 51.0 | 1364.0 |
| 2019-07-15 08:52:00 | AAPL | Stock | 51.0 | 51.0 | 51.0 | 51.0 | 14000.0 |
| 2019-07-15 08:53:00 | AAPL | Stock | 50.9975 | 50.9975 | 50.9975 | 50.9975 | 2000.0 |
| 2019-07-15 08:54:00 | AAPL | Stock | 50.9993 | 50.9993 | 50.9993 | 50.9993 | 400.0 |
| 2019-07-15 08:55:00 | AAPL | Stock | 51.0 | 51.0 | 51.0 | 51.0 | 1200.0 |
| 2019-07-15 08:56:00 | AAPL | Stock | 51.0 | 51.0 | 51.0 | 51.0 | 812.0 |
| 2019-07-15 08:57:00 | AAPL | Stock | 51.0 | 51.0 | 51.0 | 51.0 | 4196.0 |
> showing 50 of 1,046,107 rows — these rows as CSV