PREVIEW / etf_1min / 2020-09-24
file: by_date/etf_1min/2020/2020-09-24.parquet size: 3.8 MB rows: 213,201
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-09-24 04:00:00 | SPY | ETF | 323.0 | 323.17 | 323.0 | 323.17 | 5001.0 |
| 2020-09-24 04:01:00 | SPY | ETF | 323.0 | 323.0 | 322.91 | 322.94 | 969.0 |
| 2020-09-24 04:02:00 | SPY | ETF | 322.97 | 322.97 | 322.79 | 322.84 | 2900.0 |
| 2020-09-24 04:03:00 | SPY | ETF | 322.66 | 322.66 | 322.66 | 322.66 | 207.0 |
| 2020-09-24 04:04:00 | SPY | ETF | 322.72 | 322.72 | 322.72 | 322.72 | 105.0 |
| 2020-09-24 04:06:00 | SPY | ETF | 322.6 | 322.6 | 322.52 | 322.52 | 1100.0 |
| 2020-09-24 04:09:00 | SPY | ETF | 322.59 | 322.59 | 322.59 | 322.59 | 225.0 |
| 2020-09-24 04:10:00 | SPY | ETF | 322.64 | 322.75 | 322.64 | 322.73 | 1600.0 |
| 2020-09-24 04:11:00 | SPY | ETF | 322.51 | 322.51 | 322.51 | 322.51 | 179.0 |
| 2020-09-24 04:14:00 | SPY | ETF | 322.21 | 322.23 | 322.21 | 322.23 | 640.0 |
| 2020-09-24 04:16:00 | SPY | ETF | 322.0 | 322.0 | 322.0 | 322.0 | 2035.0 |
| 2020-09-24 04:17:00 | SPY | ETF | 322.11 | 322.11 | 322.11 | 322.11 | 720.0 |
| 2020-09-24 04:21:00 | SPY | ETF | 322.19 | 322.19 | 322.19 | 322.19 | 306.0 |
| 2020-09-24 04:22:00 | SPY | ETF | 322.27 | 322.27 | 322.17 | 322.17 | 577.0 |
| 2020-09-24 04:24:00 | SPY | ETF | 321.95 | 321.99 | 321.95 | 321.99 | 731.0 |
| 2020-09-24 04:26:00 | SPY | ETF | 322.34 | 322.34 | 322.3 | 322.3 | 2100.0 |
| 2020-09-24 04:32:00 | SPY | ETF | 322.49 | 322.49 | 322.42 | 322.42 | 500.0 |
| 2020-09-24 04:35:00 | SPY | ETF | 322.72 | 322.72 | 322.72 | 322.72 | 153.0 |
| 2020-09-24 04:36:00 | SPY | ETF | 322.87 | 322.87 | 322.87 | 322.87 | 5153.0 |
| 2020-09-24 04:37:00 | SPY | ETF | 322.8 | 322.8 | 322.8 | 322.8 | 250.0 |
| 2020-09-24 04:38:00 | SPY | ETF | 322.8 | 322.8 | 322.8 | 322.8 | 2000.0 |
| 2020-09-24 04:39:00 | SPY | ETF | 322.69 | 322.69 | 322.67 | 322.67 | 600.0 |
| 2020-09-24 04:40:00 | SPY | ETF | 322.6 | 322.6 | 322.6 | 322.6 | 1018.0 |
| 2020-09-24 04:42:00 | SPY | ETF | 322.6 | 322.7 | 322.6 | 322.7 | 230.0 |
| 2020-09-24 04:44:00 | SPY | ETF | 322.53 | 322.53 | 322.53 | 322.53 | 130.0 |
| 2020-09-24 04:47:00 | SPY | ETF | 322.42 | 322.42 | 322.42 | 322.42 | 100.0 |
| 2020-09-24 04:48:00 | SPY | ETF | 322.47 | 322.47 | 322.42 | 322.42 | 1865.0 |
| 2020-09-24 04:49:00 | SPY | ETF | 322.31 | 322.31 | 322.31 | 322.31 | 501.0 |
| 2020-09-24 04:50:00 | SPY | ETF | 322.22 | 322.22 | 322.12 | 322.12 | 600.0 |
| 2020-09-24 04:56:00 | SPY | ETF | 322.37 | 322.37 | 322.37 | 322.37 | 210.0 |
| 2020-09-24 05:05:00 | SPY | ETF | 322.2 | 322.2 | 322.2 | 322.2 | 100.0 |
| 2020-09-24 05:06:00 | SPY | ETF | 322.12 | 322.12 | 322.12 | 322.12 | 500.0 |
| 2020-09-24 05:09:00 | SPY | ETF | 322.0 | 322.0 | 321.87 | 321.87 | 2821.0 |
| 2020-09-24 05:17:00 | SPY | ETF | 322.45 | 322.58 | 322.45 | 322.56 | 10086.0 |
| 2020-09-24 05:19:00 | SPY | ETF | 322.4 | 322.4 | 322.4 | 322.4 | 115.0 |
| 2020-09-24 05:25:00 | SPY | ETF | 322.52 | 322.52 | 322.52 | 322.52 | 337.0 |
| 2020-09-24 05:27:00 | SPY | ETF | 322.39 | 322.48 | 322.39 | 322.48 | 7510.0 |
| 2020-09-24 05:30:00 | SPY | ETF | 322.77 | 322.77 | 322.77 | 322.77 | 301.0 |
| 2020-09-24 05:33:00 | SPY | ETF | 322.54 | 322.54 | 322.49 | 322.53 | 4390.0 |
| 2020-09-24 05:39:00 | SPY | ETF | 322.52 | 322.52 | 322.52 | 322.52 | 1002.0 |
| 2020-09-24 05:40:00 | SPY | ETF | 322.45 | 322.45 | 322.45 | 322.45 | 610.0 |
| 2020-09-24 05:41:00 | SPY | ETF | 322.5 | 322.5 | 322.5 | 322.5 | 276.0 |
| 2020-09-24 05:42:00 | SPY | ETF | 322.64 | 322.64 | 322.64 | 322.64 | 300.0 |
| 2020-09-24 05:43:00 | SPY | ETF | 322.7 | 322.7 | 322.7 | 322.7 | 502.0 |
| 2020-09-24 05:44:00 | SPY | ETF | 322.67 | 322.68 | 322.67 | 322.67 | 1300.0 |
| 2020-09-24 05:47:00 | SPY | ETF | 322.55 | 322.6 | 322.55 | 322.6 | 1006.0 |
| 2020-09-24 05:48:00 | SPY | ETF | 322.6 | 322.6 | 322.6 | 322.6 | 183.0 |
| 2020-09-24 05:49:00 | SPY | ETF | 322.57 | 322.62 | 322.4 | 322.4 | 6251.0 |
| 2020-09-24 05:50:00 | SPY | ETF | 322.65 | 322.65 | 322.65 | 322.65 | 1003.0 |
| 2020-09-24 05:51:00 | SPY | ETF | 322.55 | 322.56 | 322.55 | 322.56 | 1301.0 |
> showing 50 of 213,201 rows — these rows as CSV