PREVIEW / stock_1min / 2020-08-13
file: by_date/stock_1min/2020/2020-08-13.parquet size: 19.8 MB rows: 1,234,356 symbols: 2,058
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-08-13 04:00:00 | AAPL | Stock | 113.1225 | 113.1225 | 113.1225 | 113.1225 | 400.0 |
| 2020-08-13 04:03:00 | AAPL | Stock | 112.875 | 112.875 | 112.875 | 112.875 | 1600.0 |
| 2020-08-13 04:04:00 | AAPL | Stock | 112.8375 | 112.8375 | 112.8375 | 112.8375 | 572.0 |
| 2020-08-13 04:06:00 | AAPL | Stock | 112.825 | 112.825 | 112.825 | 112.825 | 400.0 |
| 2020-08-13 04:11:00 | AAPL | Stock | 112.7875 | 112.7875 | 112.7875 | 112.7875 | 800.0 |
| 2020-08-13 04:15:00 | AAPL | Stock | 112.73 | 112.73 | 112.73 | 112.73 | 992.0 |
| 2020-08-13 04:20:00 | AAPL | Stock | 112.7225 | 112.7225 | 112.7225 | 112.7225 | 400.0 |
| 2020-08-13 04:21:00 | AAPL | Stock | 112.7375 | 112.7375 | 112.7375 | 112.7375 | 400.0 |
| 2020-08-13 04:22:00 | AAPL | Stock | 112.75 | 112.75 | 112.7125 | 112.7125 | 800.0 |
| 2020-08-13 04:34:00 | AAPL | Stock | 112.675 | 112.675 | 112.675 | 112.675 | 800.0 |
| 2020-08-13 04:39:00 | AAPL | Stock | 112.765 | 112.765 | 112.765 | 112.765 | 400.0 |
| 2020-08-13 04:40:00 | AAPL | Stock | 112.765 | 112.775 | 112.765 | 112.775 | 1324.0 |
| 2020-08-13 04:46:00 | AAPL | Stock | 112.825 | 112.825 | 112.825 | 112.825 | 400.0 |
| 2020-08-13 04:52:00 | AAPL | Stock | 112.875 | 112.925 | 112.875 | 112.925 | 848.0 |
| 2020-08-13 05:14:00 | AAPL | Stock | 112.9175 | 112.9175 | 112.9175 | 112.9175 | 400.0 |
| 2020-08-13 05:17:00 | AAPL | Stock | 112.875 | 112.875 | 112.875 | 112.875 | 952.0 |
| 2020-08-13 05:23:00 | AAPL | Stock | 112.8725 | 112.875 | 112.8725 | 112.875 | 1520.0 |
| 2020-08-13 05:32:00 | AAPL | Stock | 112.875 | 112.875 | 112.875 | 112.875 | 1976.0 |
| 2020-08-13 05:38:00 | AAPL | Stock | 112.875 | 112.875 | 112.875 | 112.875 | 2000.0 |
| 2020-08-13 05:39:00 | AAPL | Stock | 112.875 | 112.875 | 112.875 | 112.875 | 1200.0 |
| 2020-08-13 06:00:00 | AAPL | Stock | 112.915 | 113.0 | 112.875 | 113.0 | 18908.0 |
| 2020-08-13 06:01:00 | AAPL | Stock | 113.0375 | 113.13 | 113.0375 | 113.1125 | 8896.0 |
| 2020-08-13 06:02:00 | AAPL | Stock | 113.265 | 113.265 | 113.1125 | 113.12 | 1604.0 |
| 2020-08-13 06:05:00 | AAPL | Stock | 113.2875 | 113.2875 | 113.285 | 113.285 | 1188.0 |
| 2020-08-13 06:08:00 | AAPL | Stock | 113.195 | 113.2675 | 113.1875 | 113.195 | 2976.0 |
| 2020-08-13 06:09:00 | AAPL | Stock | 113.205 | 113.205 | 113.1925 | 113.1925 | 8764.0 |
| 2020-08-13 06:12:00 | AAPL | Stock | 113.235 | 113.235 | 113.235 | 113.235 | 400.0 |
| 2020-08-13 06:13:00 | AAPL | Stock | 113.245 | 113.25 | 113.245 | 113.25 | 2228.0 |
| 2020-08-13 06:15:00 | AAPL | Stock | 113.2925 | 113.375 | 113.2925 | 113.375 | 2648.0 |
| 2020-08-13 06:16:00 | AAPL | Stock | 113.4475 | 113.6925 | 113.4475 | 113.675 | 11048.0 |
| 2020-08-13 06:19:00 | AAPL | Stock | 113.57 | 113.575 | 113.57 | 113.575 | 800.0 |
| 2020-08-13 06:21:00 | AAPL | Stock | 113.525 | 113.525 | 113.505 | 113.505 | 800.0 |
| 2020-08-13 06:22:00 | AAPL | Stock | 113.4575 | 113.4575 | 113.4575 | 113.4575 | 400.0 |
| 2020-08-13 06:23:00 | AAPL | Stock | 113.47 | 113.47 | 113.47 | 113.47 | 400.0 |
| 2020-08-13 06:25:00 | AAPL | Stock | 113.5375 | 113.5875 | 113.5375 | 113.5875 | 1596.0 |
| 2020-08-13 06:26:00 | AAPL | Stock | 113.6225 | 113.6225 | 113.6225 | 113.6225 | 400.0 |
| 2020-08-13 06:27:00 | AAPL | Stock | 113.62 | 113.6225 | 113.62 | 113.6225 | 1608.0 |
| 2020-08-13 06:33:00 | AAPL | Stock | 113.5425 | 113.5425 | 113.5425 | 113.5425 | 2400.0 |
| 2020-08-13 06:36:00 | AAPL | Stock | 113.6025 | 113.6025 | 113.6 | 113.6 | 1200.0 |
| 2020-08-13 06:37:00 | AAPL | Stock | 113.5275 | 113.5275 | 113.505 | 113.505 | 3600.0 |
| 2020-08-13 06:40:00 | AAPL | Stock | 113.525 | 113.525 | 113.525 | 113.525 | 1596.0 |
| 2020-08-13 06:46:00 | AAPL | Stock | 113.47 | 113.475 | 113.47 | 113.475 | 1600.0 |
| 2020-08-13 06:52:00 | AAPL | Stock | 113.555 | 113.555 | 113.48 | 113.48 | 6800.0 |
| 2020-08-13 06:55:00 | AAPL | Stock | 113.495 | 113.495 | 113.495 | 113.495 | 944.0 |
| 2020-08-13 07:00:00 | AAPL | Stock | 113.505 | 113.545 | 113.2575 | 113.525 | 33328.0 |
| 2020-08-13 07:01:00 | AAPL | Stock | 113.475 | 113.5625 | 113.475 | 113.5425 | 18928.0 |
| 2020-08-13 07:02:00 | AAPL | Stock | 113.525 | 113.6225 | 113.525 | 113.6 | 33888.0 |
| 2020-08-13 07:03:00 | AAPL | Stock | 113.595 | 113.6 | 113.565 | 113.565 | 5608.0 |
| 2020-08-13 07:04:00 | AAPL | Stock | 113.5825 | 113.635 | 113.5825 | 113.635 | 14212.0 |
| 2020-08-13 07:05:00 | AAPL | Stock | 113.705 | 113.705 | 113.63 | 113.7025 | 2356.0 |
> showing 50 of 1,234,356 rows — these rows as CSV