PREVIEW / etf_1min / 2019-12-26
file: by_date/etf_1min/2019/2019-12-26.parquet size: 2.8 MB rows: 147,431
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-12-26 04:00:00 | SPY | ETF | 321.54 | 321.58 | 321.54 | 321.58 | 1981.0 |
| 2019-12-26 04:02:00 | SPY | ETF | 321.64 | 321.64 | 321.64 | 321.64 | 363.0 |
| 2019-12-26 04:03:00 | SPY | ETF | 321.66 | 321.66 | 321.66 | 321.66 | 100.0 |
| 2019-12-26 04:06:00 | SPY | ETF | 321.75 | 321.75 | 321.75 | 321.75 | 188.0 |
| 2019-12-26 04:07:00 | SPY | ETF | 321.73 | 321.73 | 321.73 | 321.73 | 200.0 |
| 2019-12-26 04:17:00 | SPY | ETF | 321.71 | 321.71 | 321.71 | 321.71 | 401.0 |
| 2019-12-26 04:20:00 | SPY | ETF | 321.76 | 321.78 | 321.76 | 321.78 | 4400.0 |
| 2019-12-26 04:22:00 | SPY | ETF | 321.79 | 321.79 | 321.79 | 321.79 | 126.0 |
| 2019-12-26 04:30:00 | SPY | ETF | 321.79 | 321.79 | 321.79 | 321.79 | 101.0 |
| 2019-12-26 04:36:00 | SPY | ETF | 321.78 | 321.78 | 321.78 | 321.78 | 361.0 |
| 2019-12-26 04:55:00 | SPY | ETF | 321.76 | 321.76 | 321.76 | 321.76 | 105.0 |
| 2019-12-26 05:21:00 | SPY | ETF | 321.79 | 321.8 | 321.79 | 321.79 | 1800.0 |
| 2019-12-26 05:32:00 | SPY | ETF | 321.77 | 321.77 | 321.77 | 321.77 | 100.0 |
| 2019-12-26 06:11:00 | SPY | ETF | 321.77 | 321.77 | 321.77 | 321.77 | 200.0 |
| 2019-12-26 06:49:00 | SPY | ETF | 321.77 | 321.77 | 321.77 | 321.77 | 200.0 |
| 2019-12-26 06:50:00 | SPY | ETF | 321.77 | 321.77 | 321.77 | 321.77 | 100.0 |
| 2019-12-26 06:51:00 | SPY | ETF | 321.75 | 321.75 | 321.75 | 321.75 | 100.0 |
| 2019-12-26 07:00:00 | SPY | ETF | 321.75 | 321.77 | 321.74 | 321.74 | 4594.0 |
| 2019-12-26 07:01:00 | SPY | ETF | 321.74 | 321.741 | 321.74 | 321.741 | 1161.0 |
| 2019-12-26 07:05:00 | SPY | ETF | 321.78 | 321.78 | 321.78 | 321.78 | 456.0 |
| 2019-12-26 07:10:00 | SPY | ETF | 321.76 | 321.76 | 321.76 | 321.76 | 298.0 |
| 2019-12-26 07:13:00 | SPY | ETF | 321.76 | 321.77 | 321.76 | 321.77 | 210.0 |
| 2019-12-26 07:19:00 | SPY | ETF | 321.74 | 321.74 | 321.74 | 321.74 | 109.0 |
| 2019-12-26 07:29:00 | SPY | ETF | 321.73 | 321.73 | 321.73 | 321.73 | 300.0 |
| 2019-12-26 07:30:00 | SPY | ETF | 321.74 | 321.74 | 321.74 | 321.74 | 1300.0 |
| 2019-12-26 07:40:00 | SPY | ETF | 321.73 | 321.73 | 321.73 | 321.73 | 450.0 |
| 2019-12-26 07:44:00 | SPY | ETF | 321.74 | 321.74 | 321.74 | 321.74 | 500.0 |
| 2019-12-26 07:50:00 | SPY | ETF | 321.76 | 321.77 | 321.75 | 321.75 | 5300.0 |
| 2019-12-26 07:51:00 | SPY | ETF | 321.75 | 321.75 | 321.75 | 321.75 | 510.0 |
| 2019-12-26 07:53:00 | SPY | ETF | 321.7 | 321.74 | 321.7 | 321.74 | 1500.0 |
| 2019-12-26 07:54:00 | SPY | ETF | 321.74 | 321.74 | 321.74 | 321.74 | 120.0 |
| 2019-12-26 07:58:00 | SPY | ETF | 321.76 | 321.76 | 321.76 | 321.76 | 1991.0 |
| 2019-12-26 08:00:00 | SPY | ETF | 321.76 | 321.76 | 321.7 | 321.76 | 5264.0 |
| 2019-12-26 08:01:00 | SPY | ETF | 321.75 | 321.8 | 321.72 | 321.8 | 1710.0 |
| 2019-12-26 08:02:00 | SPY | ETF | 321.76 | 321.76 | 321.76 | 321.76 | 155.0 |
| 2019-12-26 08:03:00 | SPY | ETF | 321.76 | 321.76 | 321.76 | 321.76 | 1006.0 |
| 2019-12-26 08:04:00 | SPY | ETF | 321.76 | 321.76 | 321.72 | 321.76 | 906.0 |
| 2019-12-26 08:07:00 | SPY | ETF | 321.74 | 321.74 | 321.74 | 321.74 | 250.0 |
| 2019-12-26 08:10:00 | SPY | ETF | 321.73 | 321.73 | 321.73 | 321.73 | 472.0 |
| 2019-12-26 08:12:00 | SPY | ETF | 321.71 | 321.71 | 321.65 | 321.65 | 3844.0 |
| 2019-12-26 08:13:00 | SPY | ETF | 321.68 | 321.68 | 321.68 | 321.68 | 862.0 |
| 2019-12-26 08:14:00 | SPY | ETF | 321.65 | 321.68 | 321.65 | 321.68 | 350.0 |
| 2019-12-26 08:15:00 | SPY | ETF | 321.67 | 321.68 | 321.67 | 321.68 | 200.0 |
| 2019-12-26 08:16:00 | SPY | ETF | 321.68 | 321.69 | 321.68 | 321.69 | 700.0 |
| 2019-12-26 08:18:00 | SPY | ETF | 321.69 | 321.69 | 321.69 | 321.69 | 140.0 |
| 2019-12-26 08:20:00 | SPY | ETF | 321.69 | 321.7 | 321.69 | 321.69 | 3287.0 |
| 2019-12-26 08:21:00 | SPY | ETF | 321.7 | 321.74 | 321.7 | 321.74 | 12982.0 |
| 2019-12-26 08:22:00 | SPY | ETF | 321.75 | 321.75 | 321.75 | 321.75 | 850.0 |
| 2019-12-26 08:23:00 | SPY | ETF | 321.75 | 321.75 | 321.75 | 321.75 | 303.0 |
| 2019-12-26 08:24:00 | SPY | ETF | 321.74 | 321.74 | 321.73 | 321.74 | 3070.0 |
> showing 50 of 147,431 rows — these rows as CSV