PREVIEW / etf_1min / 2022-04-19
file: by_date/etf_1min/2022/2022-04-19.parquet size: 4.6 MB rows: 258,720
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-19 04:00:00 | SPY | ETF | 438.99 | 439.11 | 438.99 | 439.11 | 1356.0 |
| 2022-04-19 04:01:00 | SPY | ETF | 439.01 | 439.02 | 439.01 | 439.02 | 2432.0 |
| 2022-04-19 04:02:00 | SPY | ETF | 439.08 | 439.14 | 439.08 | 439.14 | 516.0 |
| 2022-04-19 04:03:00 | SPY | ETF | 439.11 | 439.14 | 439.05 | 439.12 | 1116.0 |
| 2022-04-19 04:04:00 | SPY | ETF | 439.07 | 439.08 | 439.07 | 439.08 | 1000.0 |
| 2022-04-19 04:05:00 | SPY | ETF | 439.09 | 439.1 | 439.09 | 439.1 | 500.0 |
| 2022-04-19 04:07:00 | SPY | ETF | 439.34 | 439.34 | 439.34 | 439.34 | 100.0 |
| 2022-04-19 04:08:00 | SPY | ETF | 439.47 | 439.5 | 439.47 | 439.5 | 300.0 |
| 2022-04-19 04:09:00 | SPY | ETF | 439.28 | 439.28 | 439.28 | 439.28 | 200.0 |
| 2022-04-19 04:11:00 | SPY | ETF | 439.34 | 439.34 | 439.34 | 439.34 | 200.0 |
| 2022-04-19 04:12:00 | SPY | ETF | 439.05 | 439.05 | 439.05 | 439.05 | 100.0 |
| 2022-04-19 04:14:00 | SPY | ETF | 439.07 | 439.07 | 439.06 | 439.06 | 1600.0 |
| 2022-04-19 04:16:00 | SPY | ETF | 439.12 | 439.12 | 439.06 | 439.06 | 2000.0 |
| 2022-04-19 04:17:00 | SPY | ETF | 439.08 | 439.1 | 439.08 | 439.1 | 300.0 |
| 2022-04-19 04:19:00 | SPY | ETF | 439.1 | 439.1 | 439.1 | 439.1 | 800.0 |
| 2022-04-19 04:20:00 | SPY | ETF | 439.02 | 439.03 | 439.02 | 439.03 | 400.0 |
| 2022-04-19 04:21:00 | SPY | ETF | 439.1 | 439.19 | 439.07 | 439.19 | 1700.0 |
| 2022-04-19 04:22:00 | SPY | ETF | 439.21 | 439.21 | 439.21 | 439.21 | 126.0 |
| 2022-04-19 04:23:00 | SPY | ETF | 439.31 | 439.34 | 439.31 | 439.34 | 200.0 |
| 2022-04-19 04:27:00 | SPY | ETF | 439.21 | 439.21 | 439.21 | 439.21 | 300.0 |
| 2022-04-19 04:28:00 | SPY | ETF | 439.45 | 439.45 | 439.45 | 439.45 | 100.0 |
| 2022-04-19 04:30:00 | SPY | ETF | 439.32 | 439.32 | 439.32 | 439.32 | 100.0 |
| 2022-04-19 04:31:00 | SPY | ETF | 439.32 | 439.32 | 439.32 | 439.32 | 100.0 |
| 2022-04-19 04:34:00 | SPY | ETF | 439.33 | 439.33 | 439.33 | 439.33 | 138.0 |
| 2022-04-19 04:36:00 | SPY | ETF | 439.4 | 439.4 | 439.4 | 439.4 | 300.0 |
| 2022-04-19 04:37:00 | SPY | ETF | 439.51 | 439.51 | 439.51 | 439.51 | 300.0 |
| 2022-04-19 04:39:00 | SPY | ETF | 439.48 | 439.48 | 439.48 | 439.48 | 100.0 |
| 2022-04-19 04:41:00 | SPY | ETF | 439.21 | 439.21 | 439.21 | 439.21 | 110.0 |
| 2022-04-19 04:43:00 | SPY | ETF | 439.28 | 439.28 | 439.28 | 439.28 | 1100.0 |
| 2022-04-19 04:44:00 | SPY | ETF | 439.21 | 439.21 | 439.0 | 439.0 | 1500.0 |
| 2022-04-19 04:45:00 | SPY | ETF | 438.91 | 438.91 | 438.78 | 438.78 | 2062.0 |
| 2022-04-19 04:46:00 | SPY | ETF | 438.65 | 438.66 | 438.61 | 438.61 | 3600.0 |
| 2022-04-19 04:47:00 | SPY | ETF | 438.51 | 438.51 | 438.4 | 438.46 | 7901.0 |
| 2022-04-19 04:48:00 | SPY | ETF | 438.26 | 438.26 | 438.1 | 438.11 | 1000.0 |
| 2022-04-19 04:49:00 | SPY | ETF | 438.02 | 438.02 | 437.68 | 437.88 | 20670.0 |
| 2022-04-19 04:50:00 | SPY | ETF | 437.82 | 437.92 | 437.82 | 437.92 | 1400.0 |
| 2022-04-19 04:53:00 | SPY | ETF | 437.74 | 437.76 | 437.74 | 437.76 | 800.0 |
| 2022-04-19 04:54:00 | SPY | ETF | 437.66 | 437.66 | 437.55 | 437.55 | 700.0 |
| 2022-04-19 04:55:00 | SPY | ETF | 437.52 | 437.57 | 437.51 | 437.55 | 11500.0 |
| 2022-04-19 04:56:00 | SPY | ETF | 437.57 | 437.58 | 437.52 | 437.52 | 2500.0 |
| 2022-04-19 04:57:00 | SPY | ETF | 437.5 | 437.5 | 437.5 | 437.5 | 500.0 |
| 2022-04-19 04:58:00 | SPY | ETF | 437.5 | 437.51 | 437.5 | 437.51 | 10356.0 |
| 2022-04-19 04:59:00 | SPY | ETF | 437.39 | 437.39 | 437.39 | 437.39 | 100.0 |
| 2022-04-19 05:00:00 | SPY | ETF | 437.46 | 437.46 | 437.46 | 437.46 | 2500.0 |
| 2022-04-19 05:01:00 | SPY | ETF | 437.35 | 437.39 | 437.3 | 437.3 | 2600.0 |
| 2022-04-19 05:02:00 | SPY | ETF | 437.35 | 437.35 | 437.27 | 437.27 | 17899.0 |
| 2022-04-19 05:03:00 | SPY | ETF | 437.27 | 437.27 | 437.27 | 437.27 | 100.0 |
| 2022-04-19 05:04:00 | SPY | ETF | 437.3 | 437.3 | 437.3 | 437.3 | 7500.0 |
| 2022-04-19 05:05:00 | SPY | ETF | 437.3 | 437.3 | 437.3 | 437.3 | 690.0 |
| 2022-04-19 05:06:00 | SPY | ETF | 437.36 | 437.36 | 437.36 | 437.36 | 13800.0 |
> showing 50 of 258,720 rows — these rows as CSV