PREVIEW / stock_1min / 2019-05-10
file: by_date/stock_1min/2019/2019-05-10.parquet size: 16.2 MB rows: 1,109,765 symbols: 2,186
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-05-10 04:00:00 | AAPL | Stock | 49.9825 | 49.9825 | 49.85 | 49.85 | 800.0 |
| 2019-05-10 04:01:00 | AAPL | Stock | 49.7525 | 49.7525 | 49.745 | 49.745 | 31616.0 |
| 2019-05-10 04:04:00 | AAPL | Stock | 49.8375 | 49.8375 | 49.8375 | 49.8375 | 3656.0 |
| 2019-05-10 04:07:00 | AAPL | Stock | 49.8125 | 49.8125 | 49.8125 | 49.8125 | 800.0 |
| 2019-05-10 04:08:00 | AAPL | Stock | 49.85 | 49.85 | 49.85 | 49.85 | 468.0 |
| 2019-05-10 04:09:00 | AAPL | Stock | 49.8475 | 49.8475 | 49.8475 | 49.8475 | 800.0 |
| 2019-05-10 04:10:00 | AAPL | Stock | 49.8375 | 49.8375 | 49.8375 | 49.8375 | 712.0 |
| 2019-05-10 04:12:00 | AAPL | Stock | 49.815 | 49.815 | 49.7875 | 49.7875 | 3200.0 |
| 2019-05-10 04:26:00 | AAPL | Stock | 49.8625 | 49.9 | 49.8625 | 49.9 | 2400.0 |
| 2019-05-10 04:50:00 | AAPL | Stock | 49.905 | 49.905 | 49.905 | 49.905 | 7948.0 |
| 2019-05-10 04:51:00 | AAPL | Stock | 49.905 | 49.905 | 49.905 | 49.905 | 800.0 |
| 2019-05-10 04:56:00 | AAPL | Stock | 49.875 | 49.875 | 49.87 | 49.87 | 1536.0 |
| 2019-05-10 04:57:00 | AAPL | Stock | 49.845 | 49.845 | 49.84 | 49.845 | 3964.0 |
| 2019-05-10 05:10:00 | AAPL | Stock | 49.9475 | 49.9675 | 49.9475 | 49.9675 | 1848.0 |
| 2019-05-10 05:12:00 | AAPL | Stock | 49.97 | 49.9725 | 49.97 | 49.9725 | 2000.0 |
| 2019-05-10 05:18:00 | AAPL | Stock | 49.9725 | 49.9725 | 49.9725 | 49.9725 | 648.0 |
| 2019-05-10 05:19:00 | AAPL | Stock | 49.9525 | 49.9525 | 49.9525 | 49.9525 | 800.0 |
| 2019-05-10 05:23:00 | AAPL | Stock | 50.0025 | 50.0025 | 50.0025 | 50.0025 | 400.0 |
| 2019-05-10 05:29:00 | AAPL | Stock | 50.0775 | 50.1 | 50.0775 | 50.1 | 1800.0 |
| 2019-05-10 05:30:00 | AAPL | Stock | 50.1 | 50.1 | 50.1 | 50.1 | 400.0 |
| 2019-05-10 05:31:00 | AAPL | Stock | 50.1 | 50.125 | 50.1 | 50.125 | 2400.0 |
| 2019-05-10 05:32:00 | AAPL | Stock | 50.1 | 50.125 | 50.1 | 50.125 | 2204.0 |
| 2019-05-10 05:33:00 | AAPL | Stock | 50.1 | 50.1 | 50.1 | 50.1 | 800.0 |
| 2019-05-10 05:34:00 | AAPL | Stock | 50.15 | 50.15 | 50.1 | 50.1 | 2200.0 |
| 2019-05-10 05:35:00 | AAPL | Stock | 50.145 | 50.15 | 50.145 | 50.15 | 7264.0 |
| 2019-05-10 05:49:00 | AAPL | Stock | 50.0625 | 50.0625 | 50.0625 | 50.0625 | 800.0 |
| 2019-05-10 05:53:00 | AAPL | Stock | 50.0 | 50.0 | 49.96 | 49.96 | 1200.0 |
| 2019-05-10 05:55:00 | AAPL | Stock | 49.9625 | 49.9625 | 49.9525 | 49.9525 | 1600.0 |
| 2019-05-10 06:08:00 | AAPL | Stock | 50.0025 | 50.0025 | 50.0025 | 50.0025 | 400.0 |
| 2019-05-10 06:12:00 | AAPL | Stock | 50.0 | 50.0 | 50.0 | 50.0 | 400.0 |
| 2019-05-10 06:17:00 | AAPL | Stock | 49.9625 | 49.9625 | 49.9625 | 49.9625 | 400.0 |
| 2019-05-10 06:37:00 | AAPL | Stock | 50.0025 | 50.0025 | 50.0025 | 50.0025 | 2400.0 |
| 2019-05-10 06:38:00 | AAPL | Stock | 50.0 | 50.0125 | 50.0 | 50.0125 | 1332.0 |
| 2019-05-10 06:39:00 | AAPL | Stock | 50.0875 | 50.0875 | 50.0875 | 50.0875 | 400.0 |
| 2019-05-10 06:41:00 | AAPL | Stock | 50.175 | 50.175 | 50.175 | 50.175 | 400.0 |
| 2019-05-10 06:43:00 | AAPL | Stock | 50.065 | 50.065 | 50.0625 | 50.0625 | 2400.0 |
| 2019-05-10 06:44:00 | AAPL | Stock | 50.0625 | 50.0625 | 50.0625 | 50.0625 | 1600.0 |
| 2019-05-10 06:47:00 | AAPL | Stock | 50.07 | 50.07 | 50.07 | 50.07 | 1000.0 |
| 2019-05-10 06:52:00 | AAPL | Stock | 50.025 | 50.0275 | 49.9875 | 49.9875 | 3412.0 |
| 2019-05-10 06:54:00 | AAPL | Stock | 50.06 | 50.0725 | 49.85 | 49.85 | 6360.0 |
| 2019-05-10 06:55:00 | AAPL | Stock | 49.9625 | 49.985 | 49.9625 | 49.985 | 800.0 |
| 2019-05-10 06:56:00 | AAPL | Stock | 49.915 | 49.915 | 49.755 | 49.8 | 19244.0 |
| 2019-05-10 06:57:00 | AAPL | Stock | 49.755 | 49.755 | 49.7525 | 49.7525 | 1672.0 |
| 2019-05-10 06:58:00 | AAPL | Stock | 49.7775 | 49.7775 | 49.73 | 49.73 | 21084.0 |
| 2019-05-10 07:00:00 | AAPL | Stock | 49.7675 | 49.8075 | 49.7225 | 49.75 | 14088.0 |
| 2019-05-10 07:01:00 | AAPL | Stock | 49.7575 | 49.7575 | 49.7575 | 49.7575 | 400.0 |
| 2019-05-10 07:03:00 | AAPL | Stock | 49.765 | 49.765 | 49.7225 | 49.75 | 6940.0 |
| 2019-05-10 07:04:00 | AAPL | Stock | 49.7775 | 49.81 | 49.7775 | 49.81 | 3036.0 |
| 2019-05-10 07:05:00 | AAPL | Stock | 49.81 | 49.8125 | 49.81 | 49.8125 | 2704.0 |
| 2019-05-10 07:06:00 | AAPL | Stock | 49.8325 | 49.8375 | 49.8325 | 49.8375 | 2320.0 |
> showing 50 of 1,109,765 rows — these rows as CSV