PREVIEW / etf_1min / 2022-09-08
file: by_date/etf_1min/2022/2022-09-08.parquet size: 4.2 MB rows: 247,960
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-09-08 04:00:00 | SPY | ETF | 397.25 | 397.51 | 397.18 | 397.19 | 1219.0 |
| 2022-09-08 04:01:00 | SPY | ETF | 397.11 | 397.11 | 397.11 | 397.11 | 17600.0 |
| 2022-09-08 04:02:00 | SPY | ETF | 397.11 | 397.11 | 397.0 | 397.01 | 3800.0 |
| 2022-09-08 04:03:00 | SPY | ETF | 396.97 | 396.98 | 396.81 | 396.81 | 5700.0 |
| 2022-09-08 04:04:00 | SPY | ETF | 396.87 | 396.94 | 396.84 | 396.91 | 28380.0 |
| 2022-09-08 04:05:00 | SPY | ETF | 396.94 | 396.95 | 396.89 | 396.95 | 15800.0 |
| 2022-09-08 04:06:00 | SPY | ETF | 396.98 | 397.08 | 396.98 | 397.06 | 20501.0 |
| 2022-09-08 04:07:00 | SPY | ETF | 397.07 | 397.08 | 397.0 | 397.01 | 11800.0 |
| 2022-09-08 04:08:00 | SPY | ETF | 397.02 | 397.07 | 397.02 | 397.07 | 2400.0 |
| 2022-09-08 04:09:00 | SPY | ETF | 397.02 | 397.02 | 397.01 | 397.01 | 550.0 |
| 2022-09-08 04:10:00 | SPY | ETF | 397.06 | 397.06 | 397.06 | 397.06 | 10000.0 |
| 2022-09-08 04:11:00 | SPY | ETF | 397.12 | 397.12 | 397.12 | 397.12 | 2100.0 |
| 2022-09-08 04:12:00 | SPY | ETF | 397.03 | 397.12 | 397.03 | 397.12 | 10355.0 |
| 2022-09-08 04:13:00 | SPY | ETF | 397.15 | 397.2 | 397.02 | 397.2 | 10246.0 |
| 2022-09-08 04:15:00 | SPY | ETF | 397.24 | 397.24 | 397.24 | 397.24 | 100.0 |
| 2022-09-08 04:16:00 | SPY | ETF | 397.31 | 397.31 | 397.31 | 397.31 | 500.0 |
| 2022-09-08 04:17:00 | SPY | ETF | 397.28 | 397.48 | 397.28 | 397.48 | 375.0 |
| 2022-09-08 04:19:00 | SPY | ETF | 397.4 | 397.41 | 397.37 | 397.37 | 3347.0 |
| 2022-09-08 04:21:00 | SPY | ETF | 397.39 | 397.39 | 397.39 | 397.39 | 113.0 |
| 2022-09-08 04:22:00 | SPY | ETF | 397.46 | 397.46 | 397.29 | 397.29 | 607.0 |
| 2022-09-08 04:23:00 | SPY | ETF | 397.26 | 397.26 | 397.26 | 397.26 | 100.0 |
| 2022-09-08 04:24:00 | SPY | ETF | 397.2 | 397.2 | 397.2 | 397.2 | 249.0 |
| 2022-09-08 04:26:00 | SPY | ETF | 397.11 | 397.11 | 397.11 | 397.11 | 100.0 |
| 2022-09-08 04:27:00 | SPY | ETF | 397.18 | 397.19 | 397.18 | 397.19 | 600.0 |
| 2022-09-08 04:29:00 | SPY | ETF | 397.34 | 397.34 | 397.29 | 397.32 | 1615.0 |
| 2022-09-08 04:30:00 | SPY | ETF | 397.26 | 397.26 | 397.26 | 397.26 | 150.0 |
| 2022-09-08 04:31:00 | SPY | ETF | 397.31 | 397.31 | 397.31 | 397.31 | 500.0 |
| 2022-09-08 04:32:00 | SPY | ETF | 397.41 | 397.41 | 397.37 | 397.37 | 500.0 |
| 2022-09-08 04:33:00 | SPY | ETF | 397.21 | 397.27 | 397.21 | 397.27 | 210.0 |
| 2022-09-08 04:35:00 | SPY | ETF | 397.23 | 397.23 | 397.21 | 397.21 | 500.0 |
| 2022-09-08 04:45:00 | SPY | ETF | 397.58 | 397.58 | 397.58 | 397.58 | 100.0 |
| 2022-09-08 04:58:00 | SPY | ETF | 397.77 | 397.77 | 397.76 | 397.76 | 200.0 |
| 2022-09-08 05:00:00 | SPY | ETF | 397.89 | 397.91 | 397.87 | 397.87 | 3194.0 |
| 2022-09-08 05:01:00 | SPY | ETF | 397.81 | 397.81 | 397.76 | 397.76 | 400.0 |
| 2022-09-08 05:04:00 | SPY | ETF | 397.87 | 397.87 | 397.87 | 397.87 | 193.0 |
| 2022-09-08 05:05:00 | SPY | ETF | 397.8 | 397.8 | 397.8 | 397.8 | 2000.0 |
| 2022-09-08 05:08:00 | SPY | ETF | 397.71 | 397.71 | 397.71 | 397.71 | 748.0 |
| 2022-09-08 05:09:00 | SPY | ETF | 397.66 | 397.66 | 397.66 | 397.66 | 900.0 |
| 2022-09-08 05:10:00 | SPY | ETF | 397.65 | 397.65 | 397.65 | 397.65 | 199.0 |
| 2022-09-08 05:15:00 | SPY | ETF | 397.5 | 397.5 | 397.5 | 397.5 | 500.0 |
| 2022-09-08 05:22:00 | SPY | ETF | 397.6 | 397.6 | 397.6 | 397.6 | 100.0 |
| 2022-09-08 05:25:00 | SPY | ETF | 397.66 | 397.66 | 397.66 | 397.66 | 120.0 |
| 2022-09-08 05:26:00 | SPY | ETF | 397.64 | 397.64 | 397.64 | 397.64 | 225.0 |
| 2022-09-08 05:32:00 | SPY | ETF | 397.44 | 397.44 | 397.42 | 397.42 | 550.0 |
| 2022-09-08 05:35:00 | SPY | ETF | 397.45 | 397.45 | 397.43 | 397.43 | 2483.0 |
| 2022-09-08 05:36:00 | SPY | ETF | 397.39 | 397.39 | 397.38 | 397.38 | 2479.0 |
| 2022-09-08 05:38:00 | SPY | ETF | 397.68 | 397.68 | 397.68 | 397.68 | 500.0 |
| 2022-09-08 05:39:00 | SPY | ETF | 397.74 | 397.74 | 397.74 | 397.74 | 200.0 |
| 2022-09-08 05:40:00 | SPY | ETF | 397.76 | 397.78 | 397.74 | 397.74 | 16000.0 |
| 2022-09-08 05:41:00 | SPY | ETF | 397.72 | 397.81 | 397.72 | 397.74 | 14830.0 |
> showing 50 of 247,960 rows — these rows as CSV