PREVIEW / etf_1min / 2020-02-27
file: by_date/etf_1min/2020/2020-02-27.parquet size: 5.0 MB rows: 257,987
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-02-27 04:00:00 | SPY | ETF | 309.38 | 309.46 | 309.38 | 309.46 | 2411.0 |
| 2020-02-27 04:01:00 | SPY | ETF | 309.7 | 310.18 | 309.7 | 310.17 | 3272.0 |
| 2020-02-27 04:02:00 | SPY | ETF | 310.19 | 310.19 | 309.83 | 309.84 | 8608.0 |
| 2020-02-27 04:03:00 | SPY | ETF | 309.87 | 309.9 | 309.7 | 309.7 | 3221.0 |
| 2020-02-27 04:04:00 | SPY | ETF | 309.8 | 309.85 | 309.8 | 309.85 | 665.0 |
| 2020-02-27 04:05:00 | SPY | ETF | 309.95 | 309.95 | 309.89 | 309.89 | 1110.0 |
| 2020-02-27 04:06:00 | SPY | ETF | 309.93 | 309.97 | 309.83 | 309.97 | 3104.0 |
| 2020-02-27 04:07:00 | SPY | ETF | 309.83 | 309.83 | 309.7 | 309.8 | 1679.0 |
| 2020-02-27 04:08:00 | SPY | ETF | 309.75 | 309.75 | 309.71 | 309.71 | 1378.0 |
| 2020-02-27 04:09:00 | SPY | ETF | 309.58 | 309.58 | 309.46 | 309.5 | 7211.0 |
| 2020-02-27 04:10:00 | SPY | ETF | 309.48 | 309.48 | 309.3 | 309.3 | 2066.0 |
| 2020-02-27 04:11:00 | SPY | ETF | 309.33 | 309.33 | 309.29 | 309.29 | 2525.0 |
| 2020-02-27 04:12:00 | SPY | ETF | 309.31 | 309.31 | 309.31 | 309.31 | 150.0 |
| 2020-02-27 04:13:00 | SPY | ETF | 309.55 | 309.7 | 309.55 | 309.66 | 3851.0 |
| 2020-02-27 04:14:00 | SPY | ETF | 309.6 | 309.6 | 309.6 | 309.6 | 337.0 |
| 2020-02-27 04:15:00 | SPY | ETF | 309.58 | 309.74 | 309.58 | 309.74 | 1929.0 |
| 2020-02-27 04:16:00 | SPY | ETF | 309.75 | 309.75 | 309.75 | 309.75 | 520.0 |
| 2020-02-27 04:18:00 | SPY | ETF | 309.6 | 309.6 | 309.46 | 309.5 | 1500.0 |
| 2020-02-27 04:20:00 | SPY | ETF | 309.57 | 309.57 | 309.3 | 309.3 | 4491.0 |
| 2020-02-27 04:21:00 | SPY | ETF | 309.67 | 309.78 | 309.67 | 309.78 | 6722.0 |
| 2020-02-27 04:22:00 | SPY | ETF | 309.82 | 309.84 | 309.79 | 309.79 | 3260.0 |
| 2020-02-27 04:23:00 | SPY | ETF | 309.77 | 309.77 | 309.73 | 309.73 | 300.0 |
| 2020-02-27 04:24:00 | SPY | ETF | 309.84 | 309.97 | 309.84 | 309.92 | 4820.0 |
| 2020-02-27 04:25:00 | SPY | ETF | 309.86 | 310.1 | 309.86 | 310.1 | 6991.0 |
| 2020-02-27 04:26:00 | SPY | ETF | 310.04 | 310.04 | 309.93 | 309.93 | 1105.0 |
| 2020-02-27 04:27:00 | SPY | ETF | 309.95 | 310.09 | 309.95 | 310.09 | 800.0 |
| 2020-02-27 04:28:00 | SPY | ETF | 310.13 | 310.13 | 310.08 | 310.08 | 510.0 |
| 2020-02-27 04:29:00 | SPY | ETF | 310.16 | 310.16 | 310.16 | 310.16 | 310.0 |
| 2020-02-27 04:30:00 | SPY | ETF | 310.07 | 310.14 | 310.0 | 310.14 | 590.0 |
| 2020-02-27 04:31:00 | SPY | ETF | 310.2 | 310.2 | 310.06 | 310.16 | 1669.0 |
| 2020-02-27 04:32:00 | SPY | ETF | 310.23 | 310.27 | 310.23 | 310.27 | 573.0 |
| 2020-02-27 04:33:00 | SPY | ETF | 310.4 | 310.4 | 310.4 | 310.4 | 106.0 |
| 2020-02-27 04:34:00 | SPY | ETF | 310.36 | 310.41 | 310.36 | 310.41 | 650.0 |
| 2020-02-27 04:36:00 | SPY | ETF | 310.01 | 310.01 | 309.84 | 309.86 | 2102.0 |
| 2020-02-27 04:37:00 | SPY | ETF | 309.8 | 309.8 | 309.68 | 309.69 | 4281.0 |
| 2020-02-27 04:38:00 | SPY | ETF | 309.56 | 309.56 | 309.4 | 309.48 | 3284.0 |
| 2020-02-27 04:39:00 | SPY | ETF | 309.58 | 309.58 | 309.53 | 309.53 | 450.0 |
| 2020-02-27 04:41:00 | SPY | ETF | 309.84 | 309.84 | 309.68 | 309.68 | 400.0 |
| 2020-02-27 04:42:00 | SPY | ETF | 309.66 | 309.7 | 309.66 | 309.7 | 601.0 |
| 2020-02-27 04:43:00 | SPY | ETF | 309.6 | 309.6 | 309.6 | 309.6 | 231.0 |
| 2020-02-27 04:44:00 | SPY | ETF | 309.75 | 309.75 | 309.61 | 309.61 | 750.0 |
| 2020-02-27 04:45:00 | SPY | ETF | 309.55 | 309.55 | 309.1 | 309.45 | 9502.0 |
| 2020-02-27 04:46:00 | SPY | ETF | 309.55 | 309.55 | 309.5 | 309.5 | 381.0 |
| 2020-02-27 04:47:00 | SPY | ETF | 309.44 | 309.46 | 309.32 | 309.32 | 5304.0 |
| 2020-02-27 04:48:00 | SPY | ETF | 309.31 | 309.31 | 309.31 | 309.31 | 301.0 |
| 2020-02-27 04:49:00 | SPY | ETF | 309.39 | 309.51 | 309.39 | 309.51 | 1767.0 |
| 2020-02-27 04:50:00 | SPY | ETF | 309.49 | 309.49 | 309.3 | 309.3 | 1263.0 |
| 2020-02-27 04:52:00 | SPY | ETF | 309.34 | 309.34 | 309.34 | 309.34 | 250.0 |
| 2020-02-27 04:53:00 | SPY | ETF | 309.33 | 309.33 | 309.33 | 309.33 | 300.0 |
| 2020-02-27 04:54:00 | SPY | ETF | 309.4 | 309.4 | 309.21 | 309.21 | 1600.0 |
> showing 50 of 257,987 rows — these rows as CSV