PREVIEW / stock_1min / 2018-06-25
file: by_date/stock_1min/2018/2018-06-25.parquet size: 16.2 MB rows: 1,151,522 symbols: 2,346
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-06-25 04:00:00 | AAPL | Stock | 46.125 | 46.125 | 45.9225 | 45.9225 | 3200.0 |
| 2018-06-25 04:05:00 | AAPL | Stock | 45.9575 | 45.9575 | 45.9575 | 45.9575 | 2000.0 |
| 2018-06-25 04:10:00 | AAPL | Stock | 45.9575 | 45.9575 | 45.9475 | 45.9475 | 800.0 |
| 2018-06-25 04:15:00 | AAPL | Stock | 45.9625 | 45.9625 | 45.9625 | 45.9625 | 1984.0 |
| 2018-06-25 04:24:00 | AAPL | Stock | 45.945 | 45.945 | 45.9275 | 45.9275 | 2436.0 |
| 2018-06-25 04:43:00 | AAPL | Stock | 45.8775 | 45.8775 | 45.8775 | 45.8775 | 1616.0 |
| 2018-06-25 05:04:00 | AAPL | Stock | 45.8 | 45.8875 | 45.77 | 45.77 | 5120.0 |
| 2018-06-25 05:07:00 | AAPL | Stock | 45.7775 | 45.7775 | 45.7775 | 45.7775 | 1920.0 |
| 2018-06-25 05:08:00 | AAPL | Stock | 45.7525 | 45.7525 | 45.75 | 45.7525 | 2164.0 |
| 2018-06-25 05:09:00 | AAPL | Stock | 45.8125 | 45.8125 | 45.8125 | 45.8125 | 1408.0 |
| 2018-06-25 05:10:00 | AAPL | Stock | 45.7525 | 45.7525 | 45.7525 | 45.7525 | 800.0 |
| 2018-06-25 05:12:00 | AAPL | Stock | 45.8125 | 45.8125 | 45.8125 | 45.8125 | 400.0 |
| 2018-06-25 05:14:00 | AAPL | Stock | 45.8175 | 45.8175 | 45.8175 | 45.8175 | 600.0 |
| 2018-06-25 05:17:00 | AAPL | Stock | 45.75 | 45.75 | 45.7 | 45.7 | 2516.0 |
| 2018-06-25 05:19:00 | AAPL | Stock | 45.675 | 45.675 | 45.675 | 45.675 | 608.0 |
| 2018-06-25 05:25:00 | AAPL | Stock | 45.675 | 45.675 | 45.675 | 45.675 | 3808.0 |
| 2018-06-25 05:26:00 | AAPL | Stock | 45.675 | 45.675 | 45.675 | 45.675 | 2000.0 |
| 2018-06-25 05:27:00 | AAPL | Stock | 45.6775 | 45.6775 | 45.6775 | 45.6775 | 2000.0 |
| 2018-06-25 05:28:00 | AAPL | Stock | 45.7325 | 45.7325 | 45.6825 | 45.6825 | 1216.0 |
| 2018-06-25 05:57:00 | AAPL | Stock | 45.72 | 45.72 | 45.72 | 45.72 | 800.0 |
| 2018-06-25 05:59:00 | AAPL | Stock | 45.7125 | 45.7125 | 45.7125 | 45.7125 | 1000.0 |
| 2018-06-25 06:03:00 | AAPL | Stock | 45.75 | 45.75 | 45.75 | 45.75 | 400.0 |
| 2018-06-25 06:09:00 | AAPL | Stock | 45.75 | 45.75 | 45.75 | 45.75 | 400.0 |
| 2018-06-25 06:17:00 | AAPL | Stock | 45.71 | 45.71 | 45.71 | 45.71 | 1600.0 |
| 2018-06-25 06:29:00 | AAPL | Stock | 45.7025 | 45.7025 | 45.7 | 45.7 | 9676.0 |
| 2018-06-25 06:31:00 | AAPL | Stock | 45.7275 | 45.7275 | 45.7275 | 45.7275 | 2000.0 |
| 2018-06-25 06:32:00 | AAPL | Stock | 45.7275 | 45.7275 | 45.7275 | 45.7275 | 2000.0 |
| 2018-06-25 06:33:00 | AAPL | Stock | 45.7275 | 45.7275 | 45.7275 | 45.7275 | 8836.0 |
| 2018-06-25 06:34:00 | AAPL | Stock | 45.7125 | 45.7125 | 45.7125 | 45.7125 | 400.0 |
| 2018-06-25 06:35:00 | AAPL | Stock | 45.71 | 45.71 | 45.71 | 45.71 | 2000.0 |
| 2018-06-25 06:40:00 | AAPL | Stock | 45.6925 | 45.6925 | 45.69 | 45.69 | 2012.0 |
| 2018-06-25 06:42:00 | AAPL | Stock | 45.69 | 45.69 | 45.6875 | 45.6875 | 2596.0 |
| 2018-06-25 06:43:00 | AAPL | Stock | 45.6875 | 45.6875 | 45.6875 | 45.6875 | 800.0 |
| 2018-06-25 06:45:00 | AAPL | Stock | 45.735 | 45.735 | 45.7325 | 45.7325 | 800.0 |
| 2018-06-25 06:46:00 | AAPL | Stock | 45.7225 | 45.775 | 45.7225 | 45.775 | 3140.0 |
| 2018-06-25 06:47:00 | AAPL | Stock | 45.7575 | 45.7575 | 45.745 | 45.745 | 2400.0 |
| 2018-06-25 06:48:00 | AAPL | Stock | 45.7325 | 45.7325 | 45.725 | 45.725 | 800.0 |
| 2018-06-25 06:50:00 | AAPL | Stock | 45.7725 | 45.7725 | 45.7725 | 45.7725 | 1000.0 |
| 2018-06-25 06:51:00 | AAPL | Stock | 45.75 | 45.75 | 45.75 | 45.75 | 400.0 |
| 2018-06-25 06:59:00 | AAPL | Stock | 45.7525 | 45.7525 | 45.75 | 45.75 | 7352.0 |
| 2018-06-25 07:00:00 | AAPL | Stock | 45.75 | 45.82 | 45.6775 | 45.7375 | 72796.0 |
| 2018-06-25 07:01:00 | AAPL | Stock | 45.7325 | 45.7375 | 45.7325 | 45.7375 | 2000.0 |
| 2018-06-25 07:02:00 | AAPL | Stock | 45.7475 | 45.75 | 45.7475 | 45.75 | 16000.0 |
| 2018-06-25 07:06:00 | AAPL | Stock | 45.7475 | 45.7475 | 45.7475 | 45.7475 | 1848.0 |
| 2018-06-25 07:07:00 | AAPL | Stock | 45.75 | 45.75 | 45.75 | 45.75 | 800.0 |
| 2018-06-25 07:08:00 | AAPL | Stock | 45.75 | 45.75 | 45.75 | 45.75 | 3800.0 |
| 2018-06-25 07:09:00 | AAPL | Stock | 45.75 | 45.8175 | 45.75 | 45.8075 | 12448.0 |
| 2018-06-25 07:11:00 | AAPL | Stock | 45.7975 | 45.7975 | 45.7975 | 45.7975 | 4400.0 |
| 2018-06-25 07:12:00 | AAPL | Stock | 45.8025 | 45.8175 | 45.8025 | 45.8175 | 11596.0 |
| 2018-06-25 07:13:00 | AAPL | Stock | 45.825 | 45.8375 | 45.8225 | 45.835 | 16040.0 |
> showing 50 of 1,151,522 rows — these rows as CSV