PREVIEW / etf_1min / 2022-05-23
file: by_date/etf_1min/2022/2022-05-23.parquet size: 4.9 MB rows: 276,106
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-05-23 04:00:00 | SPY | ETF | 394.1 | 394.59 | 393.02 | 394.59 | 8570.0 |
| 2022-05-23 04:01:00 | SPY | ETF | 394.33 | 394.35 | 394.01 | 394.11 | 2690.0 |
| 2022-05-23 04:02:00 | SPY | ETF | 394.05 | 394.06 | 393.91 | 394.0 | 1987.0 |
| 2022-05-23 04:03:00 | SPY | ETF | 393.94 | 393.95 | 393.73 | 393.73 | 2461.0 |
| 2022-05-23 04:04:00 | SPY | ETF | 393.76 | 393.76 | 393.41 | 393.41 | 6750.0 |
| 2022-05-23 04:05:00 | SPY | ETF | 393.4 | 393.4 | 393.21 | 393.21 | 2398.0 |
| 2022-05-23 04:06:00 | SPY | ETF | 393.26 | 393.26 | 393.07 | 393.07 | 10091.0 |
| 2022-05-23 04:07:00 | SPY | ETF | 393.01 | 393.01 | 393.01 | 393.01 | 300.0 |
| 2022-05-23 04:08:00 | SPY | ETF | 392.88 | 393.15 | 392.88 | 393.1 | 1248.0 |
| 2022-05-23 04:09:00 | SPY | ETF | 393.24 | 393.24 | 392.92 | 392.92 | 1200.0 |
| 2022-05-23 04:10:00 | SPY | ETF | 392.99 | 393.05 | 392.88 | 393.01 | 5746.0 |
| 2022-05-23 04:11:00 | SPY | ETF | 393.08 | 393.08 | 392.89 | 392.89 | 1240.0 |
| 2022-05-23 04:12:00 | SPY | ETF | 392.81 | 392.81 | 392.53 | 392.53 | 400.0 |
| 2022-05-23 04:13:00 | SPY | ETF | 392.4 | 392.41 | 392.39 | 392.39 | 500.0 |
| 2022-05-23 04:14:00 | SPY | ETF | 392.26 | 392.26 | 392.16 | 392.19 | 1569.0 |
| 2022-05-23 04:15:00 | SPY | ETF | 392.03 | 392.09 | 392.03 | 392.06 | 600.0 |
| 2022-05-23 04:16:00 | SPY | ETF | 392.08 | 392.08 | 391.81 | 391.81 | 4997.0 |
| 2022-05-23 04:17:00 | SPY | ETF | 391.99 | 391.99 | 391.88 | 391.88 | 3429.0 |
| 2022-05-23 04:18:00 | SPY | ETF | 392.08 | 392.11 | 392.01 | 392.01 | 859.0 |
| 2022-05-23 04:19:00 | SPY | ETF | 391.9 | 391.9 | 391.53 | 391.54 | 2400.0 |
| 2022-05-23 04:20:00 | SPY | ETF | 391.58 | 391.58 | 391.58 | 391.58 | 999.0 |
| 2022-05-23 04:22:00 | SPY | ETF | 391.69 | 391.92 | 391.69 | 391.92 | 200.0 |
| 2022-05-23 04:23:00 | SPY | ETF | 392.0 | 392.0 | 391.87 | 391.87 | 1300.0 |
| 2022-05-23 04:24:00 | SPY | ETF | 391.95 | 392.01 | 391.95 | 392.0 | 2000.0 |
| 2022-05-23 04:25:00 | SPY | ETF | 392.18 | 392.18 | 392.17 | 392.18 | 500.0 |
| 2022-05-23 04:26:00 | SPY | ETF | 392.25 | 392.43 | 392.25 | 392.43 | 2900.0 |
| 2022-05-23 04:27:00 | SPY | ETF | 392.35 | 392.39 | 392.35 | 392.39 | 700.0 |
| 2022-05-23 04:28:00 | SPY | ETF | 392.2 | 392.2 | 392.06 | 392.06 | 310.0 |
| 2022-05-23 04:29:00 | SPY | ETF | 392.16 | 392.3 | 392.16 | 392.3 | 2300.0 |
| 2022-05-23 04:31:00 | SPY | ETF | 392.21 | 392.21 | 392.21 | 392.21 | 1100.0 |
| 2022-05-23 04:33:00 | SPY | ETF | 392.06 | 392.06 | 392.05 | 392.05 | 800.0 |
| 2022-05-23 04:35:00 | SPY | ETF | 391.56 | 391.56 | 391.22 | 391.22 | 10100.0 |
| 2022-05-23 04:36:00 | SPY | ETF | 391.29 | 391.35 | 391.23 | 391.35 | 593.0 |
| 2022-05-23 04:37:00 | SPY | ETF | 391.5 | 391.51 | 391.3 | 391.3 | 600.0 |
| 2022-05-23 04:38:00 | SPY | ETF | 391.37 | 391.37 | 391.37 | 391.37 | 100.0 |
| 2022-05-23 04:40:00 | SPY | ETF | 391.41 | 391.41 | 391.38 | 391.38 | 800.0 |
| 2022-05-23 04:41:00 | SPY | ETF | 391.46 | 391.58 | 391.46 | 391.57 | 700.0 |
| 2022-05-23 04:42:00 | SPY | ETF | 391.58 | 391.58 | 391.54 | 391.54 | 3120.0 |
| 2022-05-23 04:44:00 | SPY | ETF | 391.2 | 391.22 | 391.2 | 391.21 | 800.0 |
| 2022-05-23 04:46:00 | SPY | ETF | 391.34 | 391.34 | 391.15 | 391.16 | 3500.0 |
| 2022-05-23 04:47:00 | SPY | ETF | 391.19 | 391.3 | 391.0 | 391.09 | 3369.0 |
| 2022-05-23 04:48:00 | SPY | ETF | 391.2 | 391.4 | 391.19 | 391.4 | 300.0 |
| 2022-05-23 04:49:00 | SPY | ETF | 391.34 | 391.35 | 391.3 | 391.34 | 1400.0 |
| 2022-05-23 04:50:00 | SPY | ETF | 391.31 | 391.33 | 391.31 | 391.33 | 200.0 |
| 2022-05-23 04:51:00 | SPY | ETF | 391.3 | 391.3 | 391.2 | 391.2 | 2400.0 |
| 2022-05-23 04:52:00 | SPY | ETF | 391.49 | 391.49 | 391.49 | 391.49 | 500.0 |
| 2022-05-23 04:53:00 | SPY | ETF | 391.57 | 391.57 | 391.31 | 391.31 | 200.0 |
| 2022-05-23 04:54:00 | SPY | ETF | 391.23 | 391.23 | 391.23 | 391.23 | 100.0 |
| 2022-05-23 04:57:00 | SPY | ETF | 391.79 | 391.79 | 391.79 | 391.79 | 605.0 |
| 2022-05-23 04:58:00 | SPY | ETF | 391.83 | 391.84 | 391.83 | 391.84 | 700.0 |
> showing 50 of 276,106 rows — these rows as CSV