PREVIEW / stock_1min / 2020-07-23
file: by_date/stock_1min/2020/2020-07-23.parquet size: 20.4 MB rows: 1,280,252 symbols: 2,076
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 |
|---|---|---|---|---|---|---|---|
| 2020-07-23 04:00:00 | AAPL | Stock | 97.7375 | 97.7375 | 97.7375 | 97.7375 | 1548.0 |
| 2020-07-23 04:02:00 | AAPL | Stock | 97.75 | 97.75 | 97.75 | 97.75 | 748.0 |
| 2020-07-23 04:06:00 | AAPL | Stock | 97.725 | 97.725 | 97.725 | 97.725 | 1000.0 |
| 2020-07-23 04:07:00 | AAPL | Stock | 97.725 | 97.725 | 97.725 | 97.725 | 5408.0 |
| 2020-07-23 04:09:00 | AAPL | Stock | 97.75 | 97.75 | 97.75 | 97.75 | 400.0 |
| 2020-07-23 04:10:00 | AAPL | Stock | 97.75 | 97.75 | 97.75 | 97.75 | 816.0 |
| 2020-07-23 04:14:00 | AAPL | Stock | 97.755 | 97.755 | 97.755 | 97.755 | 800.0 |
| 2020-07-23 04:29:00 | AAPL | Stock | 97.895 | 97.895 | 97.895 | 97.895 | 400.0 |
| 2020-07-23 04:45:00 | AAPL | Stock | 97.875 | 97.875 | 97.775 | 97.775 | 2264.0 |
| 2020-07-23 04:49:00 | AAPL | Stock | 97.775 | 97.775 | 97.75 | 97.775 | 3144.0 |
| 2020-07-23 04:59:00 | AAPL | Stock | 97.7025 | 97.7025 | 97.7025 | 97.7025 | 400.0 |
| 2020-07-23 05:05:00 | AAPL | Stock | 97.7025 | 97.7025 | 97.7025 | 97.7025 | 400.0 |
| 2020-07-23 05:12:00 | AAPL | Stock | 97.75 | 97.75 | 97.75 | 97.75 | 400.0 |
| 2020-07-23 05:20:00 | AAPL | Stock | 97.6875 | 97.6875 | 97.675 | 97.675 | 3200.0 |
| 2020-07-23 05:21:00 | AAPL | Stock | 97.675 | 97.675 | 97.675 | 97.675 | 2000.0 |
| 2020-07-23 05:23:00 | AAPL | Stock | 97.6425 | 97.6425 | 97.6425 | 97.6425 | 400.0 |
| 2020-07-23 05:26:00 | AAPL | Stock | 97.675 | 97.675 | 97.675 | 97.675 | 1200.0 |
| 2020-07-23 05:32:00 | AAPL | Stock | 97.675 | 97.675 | 97.675 | 97.675 | 400.0 |
| 2020-07-23 05:35:00 | AAPL | Stock | 97.6725 | 97.6725 | 97.6725 | 97.6725 | 1360.0 |
| 2020-07-23 05:37:00 | AAPL | Stock | 97.6725 | 97.6725 | 97.6725 | 97.6725 | 1024.0 |
| 2020-07-23 05:43:00 | AAPL | Stock | 97.6725 | 97.6725 | 97.64 | 97.64 | 1676.0 |
| 2020-07-23 05:55:00 | AAPL | Stock | 97.685 | 97.685 | 97.685 | 97.685 | 1132.0 |
| 2020-07-23 06:01:00 | AAPL | Stock | 97.64 | 97.675 | 97.64 | 97.675 | 2200.0 |
| 2020-07-23 06:05:00 | AAPL | Stock | 97.73 | 97.73 | 97.73 | 97.73 | 2200.0 |
| 2020-07-23 06:06:00 | AAPL | Stock | 97.7925 | 97.7925 | 97.7925 | 97.7925 | 400.0 |
| 2020-07-23 06:09:00 | AAPL | Stock | 97.7925 | 97.7925 | 97.7925 | 97.7925 | 912.0 |
| 2020-07-23 06:10:00 | AAPL | Stock | 97.7925 | 97.7925 | 97.7925 | 97.7925 | 400.0 |
| 2020-07-23 06:12:00 | AAPL | Stock | 97.7925 | 97.7925 | 97.7925 | 97.7925 | 992.0 |
| 2020-07-23 06:18:00 | AAPL | Stock | 97.865 | 97.9 | 97.865 | 97.865 | 7200.0 |
| 2020-07-23 06:24:00 | AAPL | Stock | 97.8 | 97.8 | 97.8 | 97.8 | 508.0 |
| 2020-07-23 06:26:00 | AAPL | Stock | 97.7675 | 97.7675 | 97.7675 | 97.7675 | 1976.0 |
| 2020-07-23 06:31:00 | AAPL | Stock | 97.7775 | 97.7775 | 97.7775 | 97.7775 | 400.0 |
| 2020-07-23 06:46:00 | AAPL | Stock | 97.725 | 97.725 | 97.725 | 97.725 | 476.0 |
| 2020-07-23 06:48:00 | AAPL | Stock | 97.7425 | 97.7425 | 97.7425 | 97.7425 | 688.0 |
| 2020-07-23 06:59:00 | AAPL | Stock | 97.73 | 97.73 | 97.73 | 97.73 | 400.0 |
| 2020-07-23 07:00:00 | AAPL | Stock | 97.75 | 97.75 | 97.7125 | 97.725 | 7712.0 |
| 2020-07-23 07:01:00 | AAPL | Stock | 97.78 | 97.8 | 97.7575 | 97.7575 | 5492.0 |
| 2020-07-23 07:02:00 | AAPL | Stock | 97.7775 | 97.875 | 97.7775 | 97.875 | 7080.0 |
| 2020-07-23 07:03:00 | AAPL | Stock | 97.875 | 97.88 | 97.85 | 97.85 | 4576.0 |
| 2020-07-23 07:04:00 | AAPL | Stock | 97.87 | 97.895 | 97.87 | 97.895 | 6160.0 |
| 2020-07-23 07:05:00 | AAPL | Stock | 97.8875 | 97.8875 | 97.8875 | 97.8875 | 496.0 |
| 2020-07-23 07:06:00 | AAPL | Stock | 97.85 | 97.85 | 97.85 | 97.85 | 35528.0 |
| 2020-07-23 07:07:00 | AAPL | Stock | 97.8075 | 97.8575 | 97.805 | 97.835 | 2036.0 |
| 2020-07-23 07:08:00 | AAPL | Stock | 97.815 | 97.815 | 97.815 | 97.815 | 540.0 |
| 2020-07-23 07:09:00 | AAPL | Stock | 97.83 | 97.83 | 97.83 | 97.83 | 800.0 |
| 2020-07-23 07:10:00 | AAPL | Stock | 97.7975 | 97.7975 | 97.7975 | 97.7975 | 400.0 |
| 2020-07-23 07:12:00 | AAPL | Stock | 97.8075 | 97.8075 | 97.75 | 97.75 | 4932.0 |
| 2020-07-23 07:13:00 | AAPL | Stock | 97.755 | 97.755 | 97.68 | 97.68 | 17916.0 |
| 2020-07-23 07:14:00 | AAPL | Stock | 97.68 | 97.6825 | 97.605 | 97.605 | 10676.0 |
| 2020-07-23 07:15:00 | AAPL | Stock | 97.595 | 97.6 | 97.595 | 97.6 | 3604.0 |
> showing 50 of 1,280,252 rows — these rows as CSV