PREVIEW / stock_1min / 2018-11-13
file: by_date/stock_1min/2018/2018-11-13.parquet size: 15.9 MB rows: 1,120,255 symbols: 2,301
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-13 04:00:00 | AAPL | Stock | 48.795 | 48.795 | 48.75 | 48.75 | 1800.0 |
| 2018-11-13 04:01:00 | AAPL | Stock | 48.75 | 48.795 | 48.75 | 48.75 | 4000.0 |
| 2018-11-13 04:05:00 | AAPL | Stock | 48.675 | 48.7475 | 48.6475 | 48.7475 | 2000.0 |
| 2018-11-13 04:07:00 | AAPL | Stock | 48.7 | 48.7 | 48.7 | 48.7 | 800.0 |
| 2018-11-13 04:08:00 | AAPL | Stock | 48.6975 | 48.6975 | 48.6975 | 48.6975 | 600.0 |
| 2018-11-13 04:12:00 | AAPL | Stock | 48.675 | 48.675 | 48.675 | 48.675 | 640.0 |
| 2018-11-13 04:13:00 | AAPL | Stock | 48.675 | 48.675 | 48.675 | 48.675 | 4840.0 |
| 2018-11-13 04:15:00 | AAPL | Stock | 48.6775 | 48.7 | 48.6775 | 48.7 | 800.0 |
| 2018-11-13 04:16:00 | AAPL | Stock | 48.625 | 48.625 | 48.625 | 48.625 | 400.0 |
| 2018-11-13 04:21:00 | AAPL | Stock | 48.675 | 48.675 | 48.675 | 48.675 | 600.0 |
| 2018-11-13 04:22:00 | AAPL | Stock | 48.6875 | 48.7 | 48.6875 | 48.7 | 1200.0 |
| 2018-11-13 04:38:00 | AAPL | Stock | 48.675 | 48.675 | 48.675 | 48.675 | 400.0 |
| 2018-11-13 04:39:00 | AAPL | Stock | 48.665 | 48.665 | 48.665 | 48.665 | 400.0 |
| 2018-11-13 04:40:00 | AAPL | Stock | 48.6375 | 48.6375 | 48.6375 | 48.6375 | 1000.0 |
| 2018-11-13 04:42:00 | AAPL | Stock | 48.65 | 48.65 | 48.65 | 48.65 | 3192.0 |
| 2018-11-13 04:44:00 | AAPL | Stock | 48.65 | 48.65 | 48.65 | 48.65 | 1500.0 |
| 2018-11-13 04:46:00 | AAPL | Stock | 48.6375 | 48.6375 | 48.625 | 48.625 | 3472.0 |
| 2018-11-13 04:52:00 | AAPL | Stock | 48.55 | 48.55 | 48.525 | 48.525 | 1664.0 |
| 2018-11-13 04:56:00 | AAPL | Stock | 48.56 | 48.5725 | 48.5575 | 48.5725 | 3880.0 |
| 2018-11-13 04:59:00 | AAPL | Stock | 48.475 | 48.475 | 48.45 | 48.45 | 3200.0 |
| 2018-11-13 05:00:00 | AAPL | Stock | 48.475 | 48.475 | 48.475 | 48.475 | 1804.0 |
| 2018-11-13 05:14:00 | AAPL | Stock | 48.4625 | 48.4625 | 48.4625 | 48.4625 | 1908.0 |
| 2018-11-13 05:21:00 | AAPL | Stock | 48.4125 | 48.4125 | 48.4125 | 48.4125 | 800.0 |
| 2018-11-13 05:27:00 | AAPL | Stock | 48.4375 | 48.4375 | 48.4375 | 48.4375 | 400.0 |
| 2018-11-13 05:28:00 | AAPL | Stock | 48.4375 | 48.4375 | 48.4375 | 48.4375 | 400.0 |
| 2018-11-13 05:29:00 | AAPL | Stock | 48.45 | 48.4525 | 48.45 | 48.4525 | 2180.0 |
| 2018-11-13 05:31:00 | AAPL | Stock | 48.4375 | 48.4375 | 48.4125 | 48.4125 | 4840.0 |
| 2018-11-13 05:36:00 | AAPL | Stock | 48.445 | 48.445 | 48.445 | 48.445 | 3296.0 |
| 2018-11-13 05:37:00 | AAPL | Stock | 48.475 | 48.475 | 48.475 | 48.475 | 2384.0 |
| 2018-11-13 05:38:00 | AAPL | Stock | 48.4375 | 48.4375 | 48.4375 | 48.4375 | 400.0 |
| 2018-11-13 05:39:00 | AAPL | Stock | 48.475 | 48.475 | 48.475 | 48.475 | 1176.0 |
| 2018-11-13 05:44:00 | AAPL | Stock | 48.4775 | 48.4775 | 48.475 | 48.475 | 800.0 |
| 2018-11-13 05:46:00 | AAPL | Stock | 48.5 | 48.5 | 48.5 | 48.5 | 7224.0 |
| 2018-11-13 05:48:00 | AAPL | Stock | 48.5225 | 48.5225 | 48.5225 | 48.5225 | 412.0 |
| 2018-11-13 05:50:00 | AAPL | Stock | 48.5225 | 48.55 | 48.5225 | 48.55 | 5176.0 |
| 2018-11-13 05:52:00 | AAPL | Stock | 48.56 | 48.56 | 48.545 | 48.545 | 1600.0 |
| 2018-11-13 05:53:00 | AAPL | Stock | 48.545 | 48.545 | 48.545 | 48.545 | 400.0 |
| 2018-11-13 05:56:00 | AAPL | Stock | 48.5375 | 48.5375 | 48.5375 | 48.5375 | 400.0 |
| 2018-11-13 06:00:00 | AAPL | Stock | 48.56 | 48.625 | 48.56 | 48.625 | 25220.0 |
| 2018-11-13 06:01:00 | AAPL | Stock | 48.5875 | 48.5875 | 48.5875 | 48.5875 | 2000.0 |
| 2018-11-13 06:02:00 | AAPL | Stock | 48.6 | 48.6 | 48.6 | 48.6 | 400.0 |
| 2018-11-13 06:05:00 | AAPL | Stock | 48.625 | 48.625 | 48.625 | 48.625 | 20000.0 |
| 2018-11-13 06:06:00 | AAPL | Stock | 48.625 | 48.625 | 48.6225 | 48.625 | 2400.0 |
| 2018-11-13 06:08:00 | AAPL | Stock | 48.615 | 48.6175 | 48.615 | 48.6175 | 1000.0 |
| 2018-11-13 06:10:00 | AAPL | Stock | 48.58 | 48.58 | 48.5375 | 48.5375 | 800.0 |
| 2018-11-13 06:14:00 | AAPL | Stock | 48.6 | 48.6 | 48.5975 | 48.5975 | 1980.0 |
| 2018-11-13 06:17:00 | AAPL | Stock | 48.6475 | 48.6475 | 48.6475 | 48.6475 | 1632.0 |
| 2018-11-13 06:21:00 | AAPL | Stock | 48.6225 | 48.6225 | 48.6225 | 48.6225 | 2000.0 |
| 2018-11-13 06:25:00 | AAPL | Stock | 48.62 | 48.6975 | 48.62 | 48.6975 | 13000.0 |
| 2018-11-13 06:26:00 | AAPL | Stock | 48.675 | 48.675 | 48.65 | 48.65 | 16556.0 |
> showing 50 of 1,120,255 rows — these rows as CSV