PREVIEW / etf_1min / 2020-10-02
file: by_date/etf_1min/2020/2020-10-02.parquet size: 3.7 MB rows: 206,413
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-10-02 04:00:00 | SPY | ETF | 332.89 | 332.94 | 332.52 | 332.85 | 11230.0 |
| 2020-10-02 04:01:00 | SPY | ETF | 332.9 | 332.9 | 332.7 | 332.73 | 6699.0 |
| 2020-10-02 04:02:00 | SPY | ETF | 332.86 | 332.86 | 332.86 | 332.86 | 328.0 |
| 2020-10-02 04:03:00 | SPY | ETF | 332.94 | 332.94 | 332.9 | 332.9 | 1672.0 |
| 2020-10-02 04:04:00 | SPY | ETF | 332.88 | 332.88 | 332.86 | 332.86 | 2054.0 |
| 2020-10-02 04:05:00 | SPY | ETF | 332.94 | 333.0 | 332.94 | 333.0 | 324.0 |
| 2020-10-02 04:06:00 | SPY | ETF | 332.91 | 332.92 | 332.87 | 332.92 | 1222.0 |
| 2020-10-02 04:07:00 | SPY | ETF | 332.92 | 332.92 | 332.82 | 332.82 | 1570.0 |
| 2020-10-02 04:08:00 | SPY | ETF | 332.64 | 332.7 | 332.64 | 332.7 | 1753.0 |
| 2020-10-02 04:09:00 | SPY | ETF | 332.63 | 332.63 | 332.59 | 332.59 | 1565.0 |
| 2020-10-02 04:10:00 | SPY | ETF | 332.5 | 332.5 | 332.43 | 332.46 | 2542.0 |
| 2020-10-02 04:11:00 | SPY | ETF | 332.43 | 332.43 | 332.28 | 332.33 | 2448.0 |
| 2020-10-02 04:12:00 | SPY | ETF | 332.3 | 332.3 | 332.25 | 332.25 | 5152.0 |
| 2020-10-02 04:13:00 | SPY | ETF | 332.21 | 332.28 | 332.21 | 332.28 | 2778.0 |
| 2020-10-02 04:14:00 | SPY | ETF | 332.25 | 332.31 | 332.16 | 332.31 | 878.0 |
| 2020-10-02 04:15:00 | SPY | ETF | 332.42 | 332.42 | 332.42 | 332.42 | 120.0 |
| 2020-10-02 04:16:00 | SPY | ETF | 332.58 | 332.62 | 332.58 | 332.62 | 9060.0 |
| 2020-10-02 04:17:00 | SPY | ETF | 332.61 | 332.64 | 332.61 | 332.64 | 1182.0 |
| 2020-10-02 04:18:00 | SPY | ETF | 332.63 | 332.63 | 332.61 | 332.61 | 200.0 |
| 2020-10-02 04:19:00 | SPY | ETF | 332.66 | 332.66 | 332.66 | 332.66 | 962.0 |
| 2020-10-02 04:20:00 | SPY | ETF | 332.79 | 332.79 | 332.75 | 332.79 | 621.0 |
| 2020-10-02 04:21:00 | SPY | ETF | 332.69 | 332.69 | 332.69 | 332.69 | 100.0 |
| 2020-10-02 04:22:00 | SPY | ETF | 332.65 | 332.65 | 332.65 | 332.65 | 160.0 |
| 2020-10-02 04:23:00 | SPY | ETF | 332.8 | 332.86 | 332.74 | 332.74 | 1120.0 |
| 2020-10-02 04:24:00 | SPY | ETF | 332.87 | 332.87 | 332.87 | 332.87 | 201.0 |
| 2020-10-02 04:25:00 | SPY | ETF | 332.94 | 332.95 | 332.94 | 332.95 | 1039.0 |
| 2020-10-02 04:27:00 | SPY | ETF | 332.95 | 333.07 | 332.95 | 333.07 | 2247.0 |
| 2020-10-02 04:29:00 | SPY | ETF | 333.17 | 333.25 | 333.14 | 333.22 | 3388.0 |
| 2020-10-02 04:31:00 | SPY | ETF | 332.62 | 332.77 | 332.53 | 332.77 | 596.0 |
| 2020-10-02 04:32:00 | SPY | ETF | 332.7 | 332.71 | 332.67 | 332.67 | 903.0 |
| 2020-10-02 04:33:00 | SPY | ETF | 332.6 | 332.6 | 332.6 | 332.6 | 268.0 |
| 2020-10-02 04:34:00 | SPY | ETF | 332.89 | 332.89 | 332.89 | 332.89 | 370.0 |
| 2020-10-02 04:35:00 | SPY | ETF | 332.9 | 332.93 | 332.9 | 332.92 | 1811.0 |
| 2020-10-02 04:37:00 | SPY | ETF | 332.85 | 333.08 | 332.85 | 333.08 | 752.0 |
| 2020-10-02 04:38:00 | SPY | ETF | 333.1 | 333.1 | 333.1 | 333.1 | 500.0 |
| 2020-10-02 04:39:00 | SPY | ETF | 333.03 | 333.03 | 332.88 | 332.9 | 1430.0 |
| 2020-10-02 04:40:00 | SPY | ETF | 332.77 | 332.94 | 332.77 | 332.94 | 2290.0 |
| 2020-10-02 04:41:00 | SPY | ETF | 333.08 | 333.08 | 333.08 | 333.08 | 185.0 |
| 2020-10-02 04:42:00 | SPY | ETF | 332.9 | 332.9 | 332.88 | 332.88 | 348.0 |
| 2020-10-02 04:44:00 | SPY | ETF | 332.89 | 332.89 | 332.85 | 332.85 | 395.0 |
| 2020-10-02 04:45:00 | SPY | ETF | 332.94 | 332.94 | 332.94 | 332.94 | 313.0 |
| 2020-10-02 04:48:00 | SPY | ETF | 332.87 | 332.92 | 332.87 | 332.92 | 1255.0 |
| 2020-10-02 04:49:00 | SPY | ETF | 332.94 | 332.94 | 332.94 | 332.94 | 262.0 |
| 2020-10-02 04:50:00 | SPY | ETF | 332.73 | 332.73 | 332.73 | 332.73 | 196.0 |
| 2020-10-02 04:51:00 | SPY | ETF | 332.78 | 332.78 | 332.76 | 332.76 | 1535.0 |
| 2020-10-02 04:52:00 | SPY | ETF | 332.78 | 332.78 | 332.71 | 332.71 | 401.0 |
| 2020-10-02 04:53:00 | SPY | ETF | 332.98 | 332.98 | 332.98 | 332.98 | 925.0 |
| 2020-10-02 04:56:00 | SPY | ETF | 333.08 | 333.08 | 333.08 | 333.08 | 500.0 |
| 2020-10-02 04:58:00 | SPY | ETF | 332.89 | 332.9 | 332.83 | 332.83 | 7100.0 |
| 2020-10-02 04:59:00 | SPY | ETF | 332.92 | 332.92 | 332.85 | 332.85 | 1510.0 |
> showing 50 of 206,413 rows — these rows as CSV