PREVIEW / stock_1min / 2020-08-04
file: by_date/stock_1min/2020/2020-08-04.parquet size: 20.6 MB rows: 1,292,129 symbols: 2,062
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-04 04:00:00 | AAPL | Stock | 108.805 | 108.805 | 108.805 | 108.805 | 2852.0 |
| 2020-08-04 04:04:00 | AAPL | Stock | 108.79 | 108.79 | 108.79 | 108.79 | 3968.0 |
| 2020-08-04 04:06:00 | AAPL | Stock | 108.625 | 108.625 | 108.625 | 108.625 | 1200.0 |
| 2020-08-04 04:07:00 | AAPL | Stock | 108.5 | 108.525 | 108.5 | 108.525 | 800.0 |
| 2020-08-04 04:08:00 | AAPL | Stock | 108.4875 | 108.4875 | 108.405 | 108.405 | 2680.0 |
| 2020-08-04 04:10:00 | AAPL | Stock | 108.325 | 108.325 | 108.29 | 108.29 | 2000.0 |
| 2020-08-04 04:11:00 | AAPL | Stock | 108.425 | 108.475 | 108.425 | 108.475 | 1200.0 |
| 2020-08-04 04:12:00 | AAPL | Stock | 108.4275 | 108.4275 | 108.4275 | 108.4275 | 800.0 |
| 2020-08-04 04:13:00 | AAPL | Stock | 108.475 | 108.475 | 108.475 | 108.475 | 1896.0 |
| 2020-08-04 04:22:00 | AAPL | Stock | 108.445 | 108.5 | 108.445 | 108.5 | 1200.0 |
| 2020-08-04 04:27:00 | AAPL | Stock | 108.54 | 108.55 | 108.54 | 108.55 | 800.0 |
| 2020-08-04 04:33:00 | AAPL | Stock | 108.555 | 108.555 | 108.5 | 108.5 | 2244.0 |
| 2020-08-04 04:36:00 | AAPL | Stock | 108.4425 | 108.4425 | 108.4425 | 108.4425 | 960.0 |
| 2020-08-04 04:37:00 | AAPL | Stock | 108.545 | 108.575 | 108.545 | 108.575 | 800.0 |
| 2020-08-04 04:39:00 | AAPL | Stock | 108.5 | 108.5 | 108.5 | 108.5 | 836.0 |
| 2020-08-04 04:43:00 | AAPL | Stock | 108.545 | 108.545 | 108.545 | 108.545 | 2400.0 |
| 2020-08-04 04:45:00 | AAPL | Stock | 108.505 | 108.505 | 108.505 | 108.505 | 800.0 |
| 2020-08-04 04:50:00 | AAPL | Stock | 108.42 | 108.42 | 108.42 | 108.42 | 468.0 |
| 2020-08-04 04:51:00 | AAPL | Stock | 108.4275 | 108.4275 | 108.4275 | 108.4275 | 472.0 |
| 2020-08-04 05:06:00 | AAPL | Stock | 108.625 | 108.75 | 108.625 | 108.75 | 8156.0 |
| 2020-08-04 05:09:00 | AAPL | Stock | 108.8675 | 108.8675 | 108.7825 | 108.7825 | 1200.0 |
| 2020-08-04 05:15:00 | AAPL | Stock | 108.7825 | 108.7825 | 108.7825 | 108.7825 | 1068.0 |
| 2020-08-04 05:18:00 | AAPL | Stock | 108.7475 | 108.7475 | 108.7475 | 108.7475 | 836.0 |
| 2020-08-04 05:25:00 | AAPL | Stock | 108.7 | 108.7 | 108.7 | 108.7 | 548.0 |
| 2020-08-04 05:39:00 | AAPL | Stock | 108.675 | 108.6825 | 108.675 | 108.6825 | 800.0 |
| 2020-08-04 05:42:00 | AAPL | Stock | 108.7 | 108.7 | 108.7 | 108.7 | 800.0 |
| 2020-08-04 05:43:00 | AAPL | Stock | 108.7075 | 108.7075 | 108.7075 | 108.7075 | 400.0 |
| 2020-08-04 05:44:00 | AAPL | Stock | 108.7 | 108.7 | 108.7 | 108.7 | 800.0 |
| 2020-08-04 05:49:00 | AAPL | Stock | 108.8125 | 108.8125 | 108.8125 | 108.8125 | 496.0 |
| 2020-08-04 06:01:00 | AAPL | Stock | 108.785 | 108.785 | 108.785 | 108.785 | 860.0 |
| 2020-08-04 06:13:00 | AAPL | Stock | 108.78 | 108.78 | 108.78 | 108.78 | 500.0 |
| 2020-08-04 06:20:00 | AAPL | Stock | 108.7275 | 108.7275 | 108.7275 | 108.7275 | 400.0 |
| 2020-08-04 06:23:00 | AAPL | Stock | 108.7925 | 108.7925 | 108.7925 | 108.7925 | 400.0 |
| 2020-08-04 06:35:00 | AAPL | Stock | 108.75 | 108.75 | 108.7475 | 108.7475 | 2256.0 |
| 2020-08-04 06:36:00 | AAPL | Stock | 108.75 | 108.75 | 108.75 | 108.75 | 1572.0 |
| 2020-08-04 06:41:00 | AAPL | Stock | 108.7525 | 108.7525 | 108.7525 | 108.7525 | 504.0 |
| 2020-08-04 06:45:00 | AAPL | Stock | 108.75 | 108.75 | 108.75 | 108.75 | 636.0 |
| 2020-08-04 06:48:00 | AAPL | Stock | 108.8475 | 108.8475 | 108.8475 | 108.8475 | 400.0 |
| 2020-08-04 06:49:00 | AAPL | Stock | 108.7625 | 108.85 | 108.75 | 108.85 | 1640.0 |
| 2020-08-04 06:52:00 | AAPL | Stock | 108.76 | 108.76 | 108.76 | 108.76 | 792.0 |
| 2020-08-04 06:53:00 | AAPL | Stock | 108.75 | 108.75 | 108.75 | 108.75 | 1200.0 |
| 2020-08-04 06:56:00 | AAPL | Stock | 108.75 | 108.75 | 108.75 | 108.75 | 800.0 |
| 2020-08-04 07:00:00 | AAPL | Stock | 108.75 | 108.85 | 108.735 | 108.85 | 13176.0 |
| 2020-08-04 07:01:00 | AAPL | Stock | 108.845 | 108.9975 | 108.84 | 108.98 | 9572.0 |
| 2020-08-04 07:02:00 | AAPL | Stock | 108.9525 | 109.145 | 108.9475 | 109.0075 | 13456.0 |
| 2020-08-04 07:03:00 | AAPL | Stock | 109.0925 | 109.1125 | 109.0275 | 109.1125 | 10060.0 |
| 2020-08-04 07:04:00 | AAPL | Stock | 109.0775 | 109.1075 | 109.0775 | 109.1075 | 6376.0 |
| 2020-08-04 07:05:00 | AAPL | Stock | 109.0675 | 109.1125 | 109.0675 | 109.1125 | 3000.0 |
| 2020-08-04 07:06:00 | AAPL | Stock | 109.1125 | 109.205 | 109.1125 | 109.205 | 6588.0 |
| 2020-08-04 07:07:00 | AAPL | Stock | 109.1925 | 109.25 | 109.1625 | 109.2075 | 14600.0 |
> showing 50 of 1,292,129 rows — these rows as CSV