PREVIEW / etf_1min / 2019-06-17
file: by_date/etf_1min/2019/2019-06-17.parquet size: 2.8 MB rows: 147,564
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-06-17 04:08:00 | SPY | ETF | 289.8 | 289.8 | 289.8 | 289.8 | 334.0 |
| 2019-06-17 04:15:00 | SPY | ETF | 289.91 | 289.91 | 289.91 | 289.91 | 100.0 |
| 2019-06-17 04:22:00 | SPY | ETF | 289.85 | 289.85 | 289.85 | 289.85 | 300.0 |
| 2019-06-17 04:24:00 | SPY | ETF | 289.82 | 289.82 | 289.82 | 289.82 | 103.0 |
| 2019-06-17 04:26:00 | SPY | ETF | 289.73 | 289.73 | 289.73 | 289.73 | 411.0 |
| 2019-06-17 04:37:00 | SPY | ETF | 289.8 | 289.8 | 289.78 | 289.78 | 881.0 |
| 2019-06-17 04:39:00 | SPY | ETF | 289.78 | 289.78 | 289.78 | 289.78 | 103.0 |
| 2019-06-17 04:45:00 | SPY | ETF | 289.81 | 289.81 | 289.81 | 289.81 | 401.0 |
| 2019-06-17 04:47:00 | SPY | ETF | 289.78 | 289.78 | 289.78 | 289.78 | 603.0 |
| 2019-06-17 05:08:00 | SPY | ETF | 289.94 | 289.94 | 289.94 | 289.94 | 996.0 |
| 2019-06-17 05:10:00 | SPY | ETF | 289.91 | 289.91 | 289.91 | 289.91 | 305.0 |
| 2019-06-17 05:11:00 | SPY | ETF | 289.91 | 289.95 | 289.91 | 289.95 | 600.0 |
| 2019-06-17 05:13:00 | SPY | ETF | 289.91 | 289.91 | 289.89 | 289.89 | 1424.0 |
| 2019-06-17 05:19:00 | SPY | ETF | 289.86 | 289.86 | 289.84 | 289.84 | 1301.0 |
| 2019-06-17 05:20:00 | SPY | ETF | 289.84 | 289.84 | 289.84 | 289.84 | 704.0 |
| 2019-06-17 05:21:00 | SPY | ETF | 289.86 | 289.86 | 289.86 | 289.86 | 500.0 |
| 2019-06-17 05:26:00 | SPY | ETF | 289.82 | 289.82 | 289.77 | 289.77 | 821.0 |
| 2019-06-17 05:38:00 | SPY | ETF | 289.87 | 289.87 | 289.86 | 289.86 | 2092.0 |
| 2019-06-17 05:43:00 | SPY | ETF | 289.88 | 289.88 | 289.88 | 289.88 | 101.0 |
| 2019-06-17 05:44:00 | SPY | ETF | 289.87 | 289.87 | 289.82 | 289.82 | 2306.0 |
| 2019-06-17 05:45:00 | SPY | ETF | 289.78 | 289.78 | 289.78 | 289.78 | 1006.0 |
| 2019-06-17 05:47:00 | SPY | ETF | 289.75 | 289.75 | 289.75 | 289.75 | 100.0 |
| 2019-06-17 05:57:00 | SPY | ETF | 289.78 | 289.78 | 289.78 | 289.78 | 100.0 |
| 2019-06-17 05:59:00 | SPY | ETF | 289.78 | 289.78 | 289.78 | 289.78 | 900.0 |
| 2019-06-17 06:03:00 | SPY | ETF | 289.8 | 289.8 | 289.8 | 289.8 | 203.0 |
| 2019-06-17 06:04:00 | SPY | ETF | 289.77 | 289.77 | 289.77 | 289.77 | 301.0 |
| 2019-06-17 06:05:00 | SPY | ETF | 289.77 | 289.77 | 289.73 | 289.73 | 2605.0 |
| 2019-06-17 06:09:00 | SPY | ETF | 289.72 | 289.72 | 289.72 | 289.72 | 401.0 |
| 2019-06-17 06:12:00 | SPY | ETF | 289.72 | 289.72 | 289.72 | 289.72 | 601.0 |
| 2019-06-17 06:13:00 | SPY | ETF | 289.7 | 289.7 | 289.69 | 289.69 | 4001.0 |
| 2019-06-17 06:17:00 | SPY | ETF | 289.67 | 289.67 | 289.67 | 289.67 | 401.0 |
| 2019-06-17 06:21:00 | SPY | ETF | 289.67 | 289.67 | 289.67 | 289.67 | 290.0 |
| 2019-06-17 06:22:00 | SPY | ETF | 289.65 | 289.65 | 289.64 | 289.64 | 1088.0 |
| 2019-06-17 06:23:00 | SPY | ETF | 289.64 | 289.64 | 289.64 | 289.64 | 141.0 |
| 2019-06-17 06:27:00 | SPY | ETF | 289.69 | 289.69 | 289.69 | 289.69 | 100.0 |
| 2019-06-17 06:32:00 | SPY | ETF | 289.66 | 289.66 | 289.66 | 289.66 | 300.0 |
| 2019-06-17 06:33:00 | SPY | ETF | 289.66 | 289.66 | 289.66 | 289.66 | 500.0 |
| 2019-06-17 06:41:00 | SPY | ETF | 289.66 | 289.66 | 289.66 | 289.66 | 621.0 |
| 2019-06-17 06:42:00 | SPY | ETF | 289.73 | 289.73 | 289.73 | 289.73 | 130.0 |
| 2019-06-17 06:49:00 | SPY | ETF | 289.66 | 289.66 | 289.66 | 289.66 | 200.0 |
| 2019-06-17 06:50:00 | SPY | ETF | 289.66 | 289.66 | 289.66 | 289.66 | 1102.0 |
| 2019-06-17 06:53:00 | SPY | ETF | 289.64 | 289.64 | 289.59 | 289.59 | 3011.0 |
| 2019-06-17 06:54:00 | SPY | ETF | 289.56 | 289.56 | 289.56 | 289.56 | 1305.0 |
| 2019-06-17 06:55:00 | SPY | ETF | 289.51 | 289.51 | 289.49 | 289.49 | 6221.0 |
| 2019-06-17 06:56:00 | SPY | ETF | 289.49 | 289.49 | 289.49 | 289.49 | 500.0 |
| 2019-06-17 06:57:00 | SPY | ETF | 289.49 | 289.49 | 289.49 | 289.49 | 302.0 |
| 2019-06-17 06:59:00 | SPY | ETF | 289.49 | 289.49 | 289.49 | 289.49 | 442.0 |
| 2019-06-17 07:00:00 | SPY | ETF | 289.54 | 289.54 | 289.54 | 289.54 | 393.0 |
| 2019-06-17 07:01:00 | SPY | ETF | 289.55 | 289.55 | 289.55 | 289.55 | 410.0 |
| 2019-06-17 07:03:00 | SPY | ETF | 289.59 | 289.59 | 289.59 | 289.59 | 200.0 |
> showing 50 of 147,564 rows — these rows as CSV