PREVIEW / etf_1min / 2020-02-26
file: by_date/etf_1min/2020/2020-02-26.parquet size: 4.5 MB rows: 228,296
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-26 04:00:00 | SPY | ETF | 311.76 | 311.76 | 311.28 | 311.5 | 24868.0 |
| 2020-02-26 04:01:00 | SPY | ETF | 311.51 | 311.55 | 310.89 | 310.89 | 17374.0 |
| 2020-02-26 04:02:00 | SPY | ETF | 310.88 | 311.15 | 310.88 | 311.1 | 17855.0 |
| 2020-02-26 04:03:00 | SPY | ETF | 311.09 | 311.1 | 310.82 | 310.82 | 3218.0 |
| 2020-02-26 04:04:00 | SPY | ETF | 310.81 | 310.89 | 310.65 | 310.77 | 15777.0 |
| 2020-02-26 04:05:00 | SPY | ETF | 310.63 | 310.63 | 310.3 | 310.47 | 46388.0 |
| 2020-02-26 04:06:00 | SPY | ETF | 310.47 | 310.51 | 310.3 | 310.37 | 15350.0 |
| 2020-02-26 04:07:00 | SPY | ETF | 310.46 | 310.61 | 310.1 | 310.12 | 8541.0 |
| 2020-02-26 04:08:00 | SPY | ETF | 310.05 | 310.2 | 309.96 | 310.17 | 27618.0 |
| 2020-02-26 04:09:00 | SPY | ETF | 310.06 | 310.06 | 309.64 | 309.85 | 9780.0 |
| 2020-02-26 04:10:00 | SPY | ETF | 309.92 | 309.92 | 309.42 | 309.42 | 8781.0 |
| 2020-02-26 04:11:00 | SPY | ETF | 309.44 | 309.44 | 309.11 | 309.11 | 6883.0 |
| 2020-02-26 04:12:00 | SPY | ETF | 309.08 | 309.59 | 309.08 | 309.59 | 4839.0 |
| 2020-02-26 04:13:00 | SPY | ETF | 309.67 | 309.9 | 309.67 | 309.77 | 6124.0 |
| 2020-02-26 04:14:00 | SPY | ETF | 309.88 | 310.2 | 309.88 | 310.11 | 11085.0 |
| 2020-02-26 04:15:00 | SPY | ETF | 310.16 | 310.32 | 310.16 | 310.32 | 2566.0 |
| 2020-02-26 04:16:00 | SPY | ETF | 310.16 | 310.23 | 310.16 | 310.18 | 2250.0 |
| 2020-02-26 04:17:00 | SPY | ETF | 310.4 | 311.05 | 310.4 | 310.99 | 17320.0 |
| 2020-02-26 04:18:00 | SPY | ETF | 311.07 | 311.25 | 310.88 | 310.88 | 13890.0 |
| 2020-02-26 04:19:00 | SPY | ETF | 310.89 | 311.24 | 310.84 | 311.2 | 14237.0 |
| 2020-02-26 04:20:00 | SPY | ETF | 310.81 | 310.81 | 310.76 | 310.76 | 859.0 |
| 2020-02-26 04:21:00 | SPY | ETF | 310.83 | 310.83 | 310.56 | 310.56 | 16614.0 |
| 2020-02-26 04:22:00 | SPY | ETF | 310.52 | 310.6 | 310.35 | 310.6 | 7312.0 |
| 2020-02-26 04:23:00 | SPY | ETF | 311.0 | 311.0 | 310.66 | 310.66 | 2650.0 |
| 2020-02-26 04:24:00 | SPY | ETF | 310.79 | 310.79 | 310.79 | 310.79 | 1021.0 |
| 2020-02-26 04:25:00 | SPY | ETF | 310.85 | 311.1 | 310.84 | 310.99 | 2071.0 |
| 2020-02-26 04:26:00 | SPY | ETF | 310.98 | 310.98 | 310.82 | 310.82 | 1990.0 |
| 2020-02-26 04:28:00 | SPY | ETF | 310.92 | 311.04 | 310.92 | 311.04 | 1103.0 |
| 2020-02-26 04:29:00 | SPY | ETF | 311.17 | 311.3 | 311.14 | 311.25 | 2508.0 |
| 2020-02-26 04:30:00 | SPY | ETF | 311.27 | 311.31 | 311.11 | 311.12 | 4676.0 |
| 2020-02-26 04:31:00 | SPY | ETF | 311.1 | 311.15 | 310.97 | 311.02 | 3642.0 |
| 2020-02-26 04:32:00 | SPY | ETF | 310.98 | 311.07 | 310.93 | 310.94 | 3274.0 |
| 2020-02-26 04:33:00 | SPY | ETF | 310.84 | 311.2 | 310.84 | 311.12 | 8600.0 |
| 2020-02-26 04:34:00 | SPY | ETF | 311.13 | 311.24 | 311.05 | 311.24 | 12403.0 |
| 2020-02-26 04:35:00 | SPY | ETF | 311.06 | 311.06 | 311.06 | 311.06 | 650.0 |
| 2020-02-26 04:36:00 | SPY | ETF | 311.08 | 311.17 | 310.98 | 311.17 | 1808.0 |
| 2020-02-26 04:37:00 | SPY | ETF | 311.33 | 311.41 | 311.33 | 311.36 | 1125.0 |
| 2020-02-26 04:38:00 | SPY | ETF | 311.35 | 311.5 | 311.28 | 311.34 | 10421.0 |
| 2020-02-26 04:39:00 | SPY | ETF | 311.54 | 312.1 | 311.54 | 311.83 | 21848.0 |
| 2020-02-26 04:40:00 | SPY | ETF | 311.79 | 311.87 | 311.61 | 311.87 | 7180.0 |
| 2020-02-26 04:41:00 | SPY | ETF | 311.97 | 312.15 | 311.97 | 312.15 | 2339.0 |
| 2020-02-26 04:42:00 | SPY | ETF | 312.12 | 312.12 | 311.99 | 311.99 | 244.0 |
| 2020-02-26 04:43:00 | SPY | ETF | 312.04 | 312.15 | 312.0 | 312.15 | 2184.0 |
| 2020-02-26 04:44:00 | SPY | ETF | 312.09 | 312.09 | 311.5 | 311.5 | 4286.0 |
| 2020-02-26 04:45:00 | SPY | ETF | 311.67 | 311.67 | 311.24 | 311.3 | 1638.0 |
| 2020-02-26 04:46:00 | SPY | ETF | 311.3 | 311.61 | 311.3 | 311.57 | 2624.0 |
| 2020-02-26 04:47:00 | SPY | ETF | 311.32 | 311.32 | 311.32 | 311.32 | 740.0 |
| 2020-02-26 04:48:00 | SPY | ETF | 311.33 | 311.33 | 311.25 | 311.25 | 744.0 |
| 2020-02-26 04:49:00 | SPY | ETF | 310.98 | 311.23 | 310.96 | 310.99 | 12349.0 |
| 2020-02-26 04:50:00 | SPY | ETF | 311.24 | 311.24 | 311.18 | 311.19 | 535.0 |
> showing 50 of 228,296 rows — these rows as CSV