PREVIEW / etf_1min / 2020-06-10
file: by_date/etf_1min/2020/2020-06-10.parquet size: 4.1 MB rows: 220,053
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-06-10 04:00:00 | SPY | ETF | 322.42 | 322.42 | 322.3 | 322.38 | 3206.0 |
| 2020-06-10 04:01:00 | SPY | ETF | 322.39 | 322.39 | 322.23 | 322.29 | 1393.0 |
| 2020-06-10 04:02:00 | SPY | ETF | 322.2 | 322.2 | 322.2 | 322.2 | 600.0 |
| 2020-06-10 04:03:00 | SPY | ETF | 322.12 | 322.12 | 322.12 | 322.12 | 315.0 |
| 2020-06-10 04:04:00 | SPY | ETF | 322.12 | 322.12 | 322.04 | 322.07 | 3225.0 |
| 2020-06-10 04:05:00 | SPY | ETF | 322.0 | 322.07 | 322.0 | 322.04 | 2782.0 |
| 2020-06-10 04:06:00 | SPY | ETF | 321.95 | 321.95 | 321.95 | 321.95 | 150.0 |
| 2020-06-10 04:07:00 | SPY | ETF | 321.9 | 321.9 | 321.88 | 321.88 | 514.0 |
| 2020-06-10 04:08:00 | SPY | ETF | 321.9 | 322.02 | 321.9 | 322.02 | 1050.0 |
| 2020-06-10 04:09:00 | SPY | ETF | 321.92 | 322.04 | 321.92 | 322.04 | 685.0 |
| 2020-06-10 04:10:00 | SPY | ETF | 321.93 | 321.95 | 321.92 | 321.95 | 393.0 |
| 2020-06-10 04:11:00 | SPY | ETF | 321.99 | 322.07 | 321.99 | 322.07 | 601.0 |
| 2020-06-10 04:13:00 | SPY | ETF | 322.05 | 322.05 | 322.05 | 322.05 | 201.0 |
| 2020-06-10 04:14:00 | SPY | ETF | 322.05 | 322.05 | 322.03 | 322.03 | 1024.0 |
| 2020-06-10 04:16:00 | SPY | ETF | 322.18 | 322.2 | 322.18 | 322.2 | 800.0 |
| 2020-06-10 04:17:00 | SPY | ETF | 322.25 | 322.25 | 322.25 | 322.25 | 2111.0 |
| 2020-06-10 04:19:00 | SPY | ETF | 322.3 | 322.3 | 322.3 | 322.3 | 330.0 |
| 2020-06-10 04:20:00 | SPY | ETF | 322.3 | 322.3 | 322.26 | 322.26 | 1160.0 |
| 2020-06-10 04:21:00 | SPY | ETF | 322.15 | 322.15 | 322.15 | 322.15 | 3550.0 |
| 2020-06-10 04:23:00 | SPY | ETF | 322.2 | 322.2 | 322.2 | 322.2 | 210.0 |
| 2020-06-10 04:24:00 | SPY | ETF | 322.1 | 322.1 | 322.1 | 322.1 | 2001.0 |
| 2020-06-10 04:25:00 | SPY | ETF | 322.14 | 322.14 | 322.14 | 322.14 | 150.0 |
| 2020-06-10 04:29:00 | SPY | ETF | 322.36 | 322.36 | 322.36 | 322.36 | 315.0 |
| 2020-06-10 04:31:00 | SPY | ETF | 322.26 | 322.35 | 322.26 | 322.35 | 5235.0 |
| 2020-06-10 04:32:00 | SPY | ETF | 322.32 | 322.32 | 322.3 | 322.3 | 200.0 |
| 2020-06-10 04:34:00 | SPY | ETF | 322.4 | 322.45 | 322.4 | 322.45 | 2920.0 |
| 2020-06-10 04:35:00 | SPY | ETF | 322.4 | 322.47 | 322.4 | 322.47 | 2900.0 |
| 2020-06-10 04:36:00 | SPY | ETF | 322.37 | 322.37 | 322.36 | 322.36 | 220.0 |
| 2020-06-10 04:38:00 | SPY | ETF | 322.37 | 322.37 | 322.37 | 322.37 | 225.0 |
| 2020-06-10 04:40:00 | SPY | ETF | 322.33 | 322.33 | 322.33 | 322.33 | 1565.0 |
| 2020-06-10 04:41:00 | SPY | ETF | 322.27 | 322.27 | 322.2 | 322.2 | 300.0 |
| 2020-06-10 04:43:00 | SPY | ETF | 322.23 | 322.23 | 322.23 | 322.23 | 300.0 |
| 2020-06-10 04:44:00 | SPY | ETF | 322.18 | 322.18 | 322.18 | 322.18 | 301.0 |
| 2020-06-10 04:45:00 | SPY | ETF | 322.1 | 322.1 | 322.07 | 322.07 | 1071.0 |
| 2020-06-10 04:46:00 | SPY | ETF | 322.0 | 322.05 | 322.0 | 322.05 | 350.0 |
| 2020-06-10 04:47:00 | SPY | ETF | 322.06 | 322.06 | 322.06 | 322.06 | 400.0 |
| 2020-06-10 04:48:00 | SPY | ETF | 322.12 | 322.12 | 322.07 | 322.08 | 1200.0 |
| 2020-06-10 04:49:00 | SPY | ETF | 322.0 | 322.0 | 321.98 | 321.98 | 260.0 |
| 2020-06-10 04:50:00 | SPY | ETF | 321.88 | 321.88 | 321.88 | 321.88 | 401.0 |
| 2020-06-10 04:52:00 | SPY | ETF | 321.87 | 321.87 | 321.87 | 321.87 | 150.0 |
| 2020-06-10 04:53:00 | SPY | ETF | 321.83 | 321.83 | 321.83 | 321.83 | 200.0 |
| 2020-06-10 04:56:00 | SPY | ETF | 321.8 | 321.8 | 321.71 | 321.71 | 1970.0 |
| 2020-06-10 04:57:00 | SPY | ETF | 321.61 | 321.61 | 321.5 | 321.5 | 1997.0 |
| 2020-06-10 04:58:00 | SPY | ETF | 321.47 | 321.5 | 321.42 | 321.5 | 4318.0 |
| 2020-06-10 04:59:00 | SPY | ETF | 321.48 | 321.48 | 321.45 | 321.47 | 501.0 |
| 2020-06-10 05:00:00 | SPY | ETF | 321.36 | 321.36 | 321.15 | 321.15 | 2249.0 |
| 2020-06-10 05:01:00 | SPY | ETF | 321.17 | 321.17 | 321.02 | 321.12 | 1700.0 |
| 2020-06-10 05:02:00 | SPY | ETF | 321.11 | 321.12 | 320.65 | 320.65 | 3166.0 |
| 2020-06-10 05:03:00 | SPY | ETF | 320.65 | 320.65 | 320.5 | 320.5 | 2147.0 |
| 2020-06-10 05:04:00 | SPY | ETF | 320.51 | 320.51 | 320.2 | 320.2 | 1898.0 |
> showing 50 of 220,053 rows — these rows as CSV