PREVIEW / etf_1min / 2021-09-14
file: by_date/etf_1min/2021/2021-09-14.parquet size: 3.9 MB rows: 215,760
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 |
|---|---|---|---|---|---|---|---|
| 2021-09-14 04:01:00 | SPY | ETF | 446.84 | 446.84 | 446.84 | 446.84 | 900.0 |
| 2021-09-14 04:02:00 | SPY | ETF | 446.74 | 447.0 | 446.69 | 446.74 | 26399.0 |
| 2021-09-14 04:03:00 | SPY | ETF | 446.75 | 446.75 | 446.63 | 446.63 | 200.0 |
| 2021-09-14 04:04:00 | SPY | ETF | 446.61 | 446.69 | 446.61 | 446.69 | 200.0 |
| 2021-09-14 04:05:00 | SPY | ETF | 446.76 | 446.77 | 446.67 | 446.67 | 400.0 |
| 2021-09-14 04:07:00 | SPY | ETF | 446.66 | 446.66 | 446.65 | 446.65 | 1200.0 |
| 2021-09-14 04:08:00 | SPY | ETF | 446.64 | 446.64 | 446.64 | 446.64 | 200.0 |
| 2021-09-14 04:09:00 | SPY | ETF | 446.69 | 446.69 | 446.69 | 446.69 | 105.0 |
| 2021-09-14 04:12:00 | SPY | ETF | 446.8 | 446.8 | 446.8 | 446.8 | 125.0 |
| 2021-09-14 04:13:00 | SPY | ETF | 446.71 | 446.71 | 446.71 | 446.71 | 101.0 |
| 2021-09-14 04:14:00 | SPY | ETF | 446.7 | 446.7 | 446.7 | 446.7 | 125.0 |
| 2021-09-14 04:16:00 | SPY | ETF | 446.68 | 446.68 | 446.68 | 446.68 | 100.0 |
| 2021-09-14 04:17:00 | SPY | ETF | 446.56 | 446.56 | 446.45 | 446.45 | 2066.0 |
| 2021-09-14 04:19:00 | SPY | ETF | 446.42 | 446.42 | 446.35 | 446.35 | 912.0 |
| 2021-09-14 04:20:00 | SPY | ETF | 446.38 | 446.38 | 446.38 | 446.38 | 100.0 |
| 2021-09-14 04:21:00 | SPY | ETF | 446.43 | 446.43 | 446.43 | 446.43 | 107.0 |
| 2021-09-14 04:22:00 | SPY | ETF | 446.51 | 446.51 | 446.5 | 446.51 | 1490.0 |
| 2021-09-14 04:23:00 | SPY | ETF | 446.58 | 446.63 | 446.58 | 446.62 | 3606.0 |
| 2021-09-14 04:24:00 | SPY | ETF | 446.6 | 446.6 | 446.6 | 446.6 | 300.0 |
| 2021-09-14 04:25:00 | SPY | ETF | 446.68 | 446.68 | 446.65 | 446.65 | 200.0 |
| 2021-09-14 04:29:00 | SPY | ETF | 446.97 | 446.99 | 446.97 | 446.99 | 1999.0 |
| 2021-09-14 04:31:00 | SPY | ETF | 446.98 | 447.05 | 446.98 | 447.05 | 300.0 |
| 2021-09-14 04:35:00 | SPY | ETF | 447.27 | 447.31 | 447.27 | 447.27 | 1784.0 |
| 2021-09-14 04:36:00 | SPY | ETF | 447.24 | 447.27 | 447.24 | 447.27 | 200.0 |
| 2021-09-14 04:37:00 | SPY | ETF | 447.35 | 447.35 | 447.35 | 447.35 | 100.0 |
| 2021-09-14 04:42:00 | SPY | ETF | 447.32 | 447.32 | 447.32 | 447.32 | 100.0 |
| 2021-09-14 04:45:00 | SPY | ETF | 447.32 | 447.32 | 447.32 | 447.32 | 100.0 |
| 2021-09-14 04:46:00 | SPY | ETF | 447.25 | 447.25 | 447.2 | 447.2 | 900.0 |
| 2021-09-14 04:50:00 | SPY | ETF | 447.12 | 447.12 | 447.12 | 447.12 | 300.0 |
| 2021-09-14 05:01:00 | SPY | ETF | 447.25 | 447.25 | 447.25 | 447.25 | 100.0 |
| 2021-09-14 05:04:00 | SPY | ETF | 447.17 | 447.17 | 447.17 | 447.17 | 100.0 |
| 2021-09-14 05:05:00 | SPY | ETF | 447.15 | 447.15 | 447.15 | 447.15 | 100.0 |
| 2021-09-14 05:11:00 | SPY | ETF | 447.27 | 447.27 | 447.27 | 447.27 | 300.0 |
| 2021-09-14 05:12:00 | SPY | ETF | 447.31 | 447.35 | 447.31 | 447.35 | 700.0 |
| 2021-09-14 05:14:00 | SPY | ETF | 447.36 | 447.36 | 447.36 | 447.36 | 200.0 |
| 2021-09-14 05:25:00 | SPY | ETF | 447.2 | 447.21 | 447.19 | 447.21 | 500.0 |
| 2021-09-14 05:29:00 | SPY | ETF | 447.17 | 447.18 | 447.17 | 447.17 | 400.0 |
| 2021-09-14 05:31:00 | SPY | ETF | 447.12 | 447.12 | 447.12 | 447.12 | 100.0 |
| 2021-09-14 05:32:00 | SPY | ETF | 447.14 | 447.15 | 447.14 | 447.15 | 451.0 |
| 2021-09-14 05:35:00 | SPY | ETF | 447.16 | 447.16 | 447.11 | 447.11 | 400.0 |
| 2021-09-14 05:36:00 | SPY | ETF | 447.11 | 447.11 | 447.11 | 447.11 | 600.0 |
| 2021-09-14 05:38:00 | SPY | ETF | 447.12 | 447.12 | 447.12 | 447.12 | 200.0 |
| 2021-09-14 05:41:00 | SPY | ETF | 447.03 | 447.03 | 447.03 | 447.03 | 100.0 |
| 2021-09-14 05:42:00 | SPY | ETF | 446.93 | 446.96 | 446.93 | 446.96 | 200.0 |
| 2021-09-14 05:43:00 | SPY | ETF | 446.98 | 446.98 | 446.98 | 446.98 | 300.0 |
| 2021-09-14 05:44:00 | SPY | ETF | 446.98 | 446.98 | 446.98 | 446.98 | 300.0 |
| 2021-09-14 05:51:00 | SPY | ETF | 446.86 | 446.86 | 446.86 | 446.86 | 100.0 |
| 2021-09-14 05:53:00 | SPY | ETF | 446.88 | 446.88 | 446.88 | 446.88 | 300.0 |
| 2021-09-14 05:54:00 | SPY | ETF | 446.87 | 446.87 | 446.81 | 446.81 | 625.0 |
| 2021-09-14 05:55:00 | SPY | ETF | 446.78 | 446.82 | 446.78 | 446.82 | 700.0 |
> showing 50 of 215,760 rows — these rows as CSV