PREVIEW / etf_1min / 2022-04-07
file: by_date/etf_1min/2022/2022-04-07.parquet size: 4.7 MB rows: 262,371
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 |
|---|---|---|---|---|---|---|---|
| 2022-04-07 04:00:00 | SPY | ETF | 445.74 | 446.32 | 445.61 | 446.22 | 5598.0 |
| 2022-04-07 04:01:00 | SPY | ETF | 446.24 | 446.4 | 446.24 | 446.33 | 1442.0 |
| 2022-04-07 04:02:00 | SPY | ETF | 446.36 | 446.36 | 446.24 | 446.24 | 229.0 |
| 2022-04-07 04:03:00 | SPY | ETF | 446.2 | 446.25 | 446.2 | 446.25 | 275.0 |
| 2022-04-07 04:04:00 | SPY | ETF | 446.29 | 446.35 | 446.29 | 446.35 | 2600.0 |
| 2022-04-07 04:06:00 | SPY | ETF | 446.35 | 446.54 | 446.35 | 446.54 | 1200.0 |
| 2022-04-07 04:07:00 | SPY | ETF | 446.56 | 446.65 | 446.56 | 446.6 | 1500.0 |
| 2022-04-07 04:08:00 | SPY | ETF | 446.59 | 446.59 | 446.46 | 446.48 | 593.0 |
| 2022-04-07 04:10:00 | SPY | ETF | 446.7 | 446.7 | 446.7 | 446.7 | 100.0 |
| 2022-04-07 04:11:00 | SPY | ETF | 446.73 | 446.73 | 446.59 | 446.59 | 1024.0 |
| 2022-04-07 04:14:00 | SPY | ETF | 446.38 | 446.38 | 446.27 | 446.36 | 822.0 |
| 2022-04-07 04:16:00 | SPY | ETF | 446.49 | 446.63 | 446.49 | 446.63 | 9063.0 |
| 2022-04-07 04:17:00 | SPY | ETF | 446.52 | 446.52 | 446.52 | 446.52 | 110.0 |
| 2022-04-07 04:18:00 | SPY | ETF | 446.32 | 446.32 | 446.19 | 446.2 | 772.0 |
| 2022-04-07 04:19:00 | SPY | ETF | 446.39 | 446.42 | 446.39 | 446.4 | 500.0 |
| 2022-04-07 04:21:00 | SPY | ETF | 446.66 | 446.66 | 446.61 | 446.61 | 299.0 |
| 2022-04-07 04:23:00 | SPY | ETF | 446.64 | 446.64 | 446.64 | 446.64 | 200.0 |
| 2022-04-07 04:24:00 | SPY | ETF | 446.6 | 446.62 | 446.6 | 446.62 | 1200.0 |
| 2022-04-07 04:26:00 | SPY | ETF | 446.51 | 446.51 | 446.51 | 446.51 | 145.0 |
| 2022-04-07 04:27:00 | SPY | ETF | 446.61 | 446.71 | 446.61 | 446.71 | 1800.0 |
| 2022-04-07 04:29:00 | SPY | ETF | 446.74 | 446.74 | 446.72 | 446.72 | 200.0 |
| 2022-04-07 04:30:00 | SPY | ETF | 446.59 | 446.59 | 446.59 | 446.59 | 200.0 |
| 2022-04-07 04:31:00 | SPY | ETF | 446.79 | 446.79 | 446.79 | 446.79 | 1100.0 |
| 2022-04-07 04:32:00 | SPY | ETF | 446.65 | 446.65 | 446.65 | 446.65 | 100.0 |
| 2022-04-07 04:33:00 | SPY | ETF | 446.51 | 446.51 | 446.51 | 446.51 | 100.0 |
| 2022-04-07 04:35:00 | SPY | ETF | 446.66 | 446.66 | 446.66 | 446.66 | 100.0 |
| 2022-04-07 04:38:00 | SPY | ETF | 446.39 | 446.39 | 446.39 | 446.39 | 1000.0 |
| 2022-04-07 04:44:00 | SPY | ETF | 446.75 | 446.75 | 446.75 | 446.75 | 100.0 |
| 2022-04-07 04:45:00 | SPY | ETF | 446.74 | 446.75 | 446.74 | 446.75 | 300.0 |
| 2022-04-07 04:46:00 | SPY | ETF | 446.76 | 446.76 | 446.74 | 446.74 | 240.0 |
| 2022-04-07 04:47:00 | SPY | ETF | 446.88 | 446.88 | 446.88 | 446.88 | 100.0 |
| 2022-04-07 04:49:00 | SPY | ETF | 446.8 | 446.82 | 446.8 | 446.8 | 1500.0 |
| 2022-04-07 04:50:00 | SPY | ETF | 446.96 | 446.96 | 446.96 | 446.96 | 131.0 |
| 2022-04-07 04:51:00 | SPY | ETF | 447.01 | 447.01 | 447.01 | 447.01 | 184.0 |
| 2022-04-07 04:58:00 | SPY | ETF | 447.29 | 447.29 | 447.29 | 447.29 | 500.0 |
| 2022-04-07 04:59:00 | SPY | ETF | 447.5 | 447.5 | 447.5 | 447.5 | 100.0 |
| 2022-04-07 05:00:00 | SPY | ETF | 447.41 | 447.41 | 447.41 | 447.41 | 137.0 |
| 2022-04-07 05:01:00 | SPY | ETF | 447.4 | 447.4 | 447.4 | 447.4 | 300.0 |
| 2022-04-07 05:04:00 | SPY | ETF | 447.38 | 447.38 | 447.38 | 447.38 | 400.0 |
| 2022-04-07 05:05:00 | SPY | ETF | 447.3 | 447.3 | 447.3 | 447.3 | 394.0 |
| 2022-04-07 05:06:00 | SPY | ETF | 447.31 | 447.31 | 447.31 | 447.31 | 110.0 |
| 2022-04-07 05:07:00 | SPY | ETF | 447.29 | 447.29 | 447.29 | 447.29 | 1199.0 |
| 2022-04-07 05:08:00 | SPY | ETF | 447.1 | 447.1 | 447.1 | 447.1 | 400.0 |
| 2022-04-07 05:10:00 | SPY | ETF | 447.1 | 447.1 | 447.1 | 447.1 | 300.0 |
| 2022-04-07 05:12:00 | SPY | ETF | 447.11 | 447.11 | 447.11 | 447.11 | 200.0 |
| 2022-04-07 05:16:00 | SPY | ETF | 447.24 | 447.24 | 447.24 | 447.24 | 200.0 |
| 2022-04-07 05:17:00 | SPY | ETF | 447.27 | 447.5 | 447.27 | 447.5 | 12500.0 |
| 2022-04-07 05:18:00 | SPY | ETF | 447.5 | 447.5 | 447.5 | 447.5 | 100.0 |
| 2022-04-07 05:19:00 | SPY | ETF | 447.39 | 447.39 | 447.39 | 447.39 | 113.0 |
| 2022-04-07 05:20:00 | SPY | ETF | 447.29 | 447.29 | 447.29 | 447.29 | 598.0 |
> showing 50 of 262,371 rows — these rows as CSV