PREVIEW / etf_1min / 2020-04-02
file: by_date/etf_1min/2020/2020-04-02.parquet size: 4.3 MB rows: 226,092
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-04-02 04:00:00 | SPY | ETF | 249.53 | 249.77 | 249.53 | 249.77 | 1781.0 |
| 2020-04-02 04:01:00 | SPY | ETF | 249.75 | 249.78 | 249.75 | 249.78 | 2773.0 |
| 2020-04-02 04:02:00 | SPY | ETF | 249.85 | 250.0 | 249.85 | 249.96 | 12749.0 |
| 2020-04-02 04:03:00 | SPY | ETF | 249.94 | 249.95 | 249.91 | 249.93 | 1980.0 |
| 2020-04-02 04:04:00 | SPY | ETF | 250.0 | 250.06 | 250.0 | 250.06 | 3422.0 |
| 2020-04-02 04:05:00 | SPY | ETF | 250.05 | 250.1 | 250.03 | 250.1 | 10578.0 |
| 2020-04-02 04:06:00 | SPY | ETF | 250.1 | 250.17 | 250.04 | 250.11 | 11335.0 |
| 2020-04-02 04:07:00 | SPY | ETF | 250.08 | 250.13 | 250.08 | 250.08 | 1785.0 |
| 2020-04-02 04:08:00 | SPY | ETF | 250.08 | 250.17 | 250.08 | 250.17 | 2120.0 |
| 2020-04-02 04:09:00 | SPY | ETF | 250.24 | 250.25 | 250.22 | 250.22 | 2188.0 |
| 2020-04-02 04:10:00 | SPY | ETF | 250.18 | 250.19 | 250.09 | 250.09 | 3297.0 |
| 2020-04-02 04:11:00 | SPY | ETF | 250.08 | 250.1 | 250.0 | 250.0 | 2543.0 |
| 2020-04-02 04:12:00 | SPY | ETF | 250.0 | 250.0 | 249.98 | 249.99 | 1505.0 |
| 2020-04-02 04:13:00 | SPY | ETF | 250.07 | 250.11 | 249.89 | 250.09 | 9275.0 |
| 2020-04-02 04:14:00 | SPY | ETF | 250.1 | 250.23 | 250.09 | 250.21 | 6654.0 |
| 2020-04-02 04:15:00 | SPY | ETF | 250.21 | 250.38 | 250.21 | 250.35 | 13585.0 |
| 2020-04-02 04:16:00 | SPY | ETF | 250.36 | 250.41 | 250.29 | 250.29 | 6445.0 |
| 2020-04-02 04:17:00 | SPY | ETF | 250.39 | 250.41 | 250.33 | 250.37 | 10855.0 |
| 2020-04-02 04:18:00 | SPY | ETF | 250.41 | 250.44 | 250.38 | 250.42 | 7301.0 |
| 2020-04-02 04:19:00 | SPY | ETF | 250.39 | 250.39 | 250.36 | 250.39 | 16475.0 |
| 2020-04-02 04:20:00 | SPY | ETF | 250.36 | 250.36 | 250.36 | 250.36 | 1110.0 |
| 2020-04-02 04:21:00 | SPY | ETF | 250.39 | 250.39 | 250.39 | 250.39 | 694.0 |
| 2020-04-02 04:22:00 | SPY | ETF | 250.39 | 250.39 | 250.38 | 250.38 | 1225.0 |
| 2020-04-02 04:23:00 | SPY | ETF | 250.39 | 250.63 | 250.39 | 250.61 | 22044.0 |
| 2020-04-02 04:24:00 | SPY | ETF | 250.52 | 250.52 | 250.28 | 250.31 | 3944.0 |
| 2020-04-02 04:25:00 | SPY | ETF | 250.35 | 250.42 | 250.17 | 250.21 | 9867.0 |
| 2020-04-02 04:26:00 | SPY | ETF | 250.22 | 250.23 | 250.2 | 250.2 | 860.0 |
| 2020-04-02 04:27:00 | SPY | ETF | 250.22 | 250.22 | 250.22 | 250.22 | 280.0 |
| 2020-04-02 04:28:00 | SPY | ETF | 250.25 | 250.29 | 250.2 | 250.27 | 52850.0 |
| 2020-04-02 04:29:00 | SPY | ETF | 250.22 | 250.27 | 250.22 | 250.27 | 52200.0 |
| 2020-04-02 04:30:00 | SPY | ETF | 250.22 | 250.27 | 250.22 | 250.27 | 5139.0 |
| 2020-04-02 04:31:00 | SPY | ETF | 250.17 | 250.23 | 250.14 | 250.2 | 6615.0 |
| 2020-04-02 04:32:00 | SPY | ETF | 250.21 | 250.21 | 250.2 | 250.2 | 14500.0 |
| 2020-04-02 04:33:00 | SPY | ETF | 250.2 | 250.23 | 250.2 | 250.23 | 37034.0 |
| 2020-04-02 04:34:00 | SPY | ETF | 250.28 | 250.36 | 250.28 | 250.33 | 28370.0 |
| 2020-04-02 04:35:00 | SPY | ETF | 250.3 | 250.3 | 250.28 | 250.29 | 41257.0 |
| 2020-04-02 04:36:00 | SPY | ETF | 250.3 | 250.39 | 250.29 | 250.39 | 28048.0 |
| 2020-04-02 04:37:00 | SPY | ETF | 250.42 | 250.45 | 250.35 | 250.45 | 51051.0 |
| 2020-04-02 04:38:00 | SPY | ETF | 250.4 | 250.4 | 250.2 | 250.2 | 6582.0 |
| 2020-04-02 04:39:00 | SPY | ETF | 250.27 | 250.28 | 250.2 | 250.25 | 12020.0 |
| 2020-04-02 04:40:00 | SPY | ETF | 250.25 | 250.27 | 250.25 | 250.25 | 8632.0 |
| 2020-04-02 04:41:00 | SPY | ETF | 250.24 | 250.26 | 250.09 | 250.1 | 15125.0 |
| 2020-04-02 04:42:00 | SPY | ETF | 250.07 | 250.07 | 249.94 | 250.01 | 12520.0 |
| 2020-04-02 04:43:00 | SPY | ETF | 249.92 | 250.0 | 249.88 | 249.9 | 18180.0 |
| 2020-04-02 04:44:00 | SPY | ETF | 249.9 | 250.06 | 249.89 | 250.06 | 20485.0 |
| 2020-04-02 04:45:00 | SPY | ETF | 250.05 | 250.06 | 249.85 | 249.92 | 6100.0 |
| 2020-04-02 04:46:00 | SPY | ETF | 249.92 | 249.94 | 249.84 | 249.84 | 5910.0 |
| 2020-04-02 04:47:00 | SPY | ETF | 249.87 | 249.99 | 249.87 | 249.99 | 1700.0 |
| 2020-04-02 04:48:00 | SPY | ETF | 249.98 | 249.98 | 249.84 | 249.84 | 3000.0 |
| 2020-04-02 04:49:00 | SPY | ETF | 249.87 | 249.92 | 249.86 | 249.92 | 577.0 |
> showing 50 of 226,092 rows — these rows as CSV