PREVIEW / etf_1min / 2022-05-20
file: by_date/etf_1min/2022/2022-05-20.parquet size: 5.1 MB rows: 286,347
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-20 04:00:00 | SPY | ETF | 389.5 | 393.5 | 389.5 | 393.4 | 4579.0 |
| 2022-05-20 04:01:00 | SPY | ETF | 393.43 | 393.48 | 393.41 | 393.41 | 7270.0 |
| 2022-05-20 04:02:00 | SPY | ETF | 393.44 | 393.44 | 393.39 | 393.41 | 1031.0 |
| 2022-05-20 04:03:00 | SPY | ETF | 393.4 | 393.4 | 393.21 | 393.21 | 201.0 |
| 2022-05-20 04:04:00 | SPY | ETF | 393.2 | 393.21 | 393.2 | 393.21 | 410.0 |
| 2022-05-20 04:05:00 | SPY | ETF | 393.33 | 393.33 | 393.17 | 393.17 | 472.0 |
| 2022-05-20 04:06:00 | SPY | ETF | 393.12 | 393.27 | 393.12 | 393.27 | 726.0 |
| 2022-05-20 04:07:00 | SPY | ETF | 393.4 | 393.4 | 393.32 | 393.32 | 1100.0 |
| 2022-05-20 04:08:00 | SPY | ETF | 393.32 | 393.32 | 393.28 | 393.3 | 801.0 |
| 2022-05-20 04:10:00 | SPY | ETF | 393.32 | 393.36 | 393.32 | 393.36 | 577.0 |
| 2022-05-20 04:11:00 | SPY | ETF | 393.07 | 393.07 | 392.92 | 392.92 | 2900.0 |
| 2022-05-20 04:12:00 | SPY | ETF | 392.83 | 392.83 | 392.83 | 392.83 | 700.0 |
| 2022-05-20 04:13:00 | SPY | ETF | 392.84 | 393.04 | 392.75 | 392.97 | 521.0 |
| 2022-05-20 04:14:00 | SPY | ETF | 392.93 | 392.93 | 392.93 | 392.93 | 100.0 |
| 2022-05-20 04:16:00 | SPY | ETF | 393.1 | 393.1 | 392.97 | 392.97 | 200.0 |
| 2022-05-20 04:17:00 | SPY | ETF | 392.98 | 392.98 | 392.91 | 392.92 | 682.0 |
| 2022-05-20 04:19:00 | SPY | ETF | 392.99 | 393.09 | 392.99 | 393.09 | 800.0 |
| 2022-05-20 04:21:00 | SPY | ETF | 393.36 | 393.36 | 393.31 | 393.31 | 400.0 |
| 2022-05-20 04:22:00 | SPY | ETF | 393.32 | 393.32 | 393.28 | 393.32 | 400.0 |
| 2022-05-20 04:23:00 | SPY | ETF | 393.35 | 393.35 | 393.35 | 393.35 | 100.0 |
| 2022-05-20 04:24:00 | SPY | ETF | 393.39 | 393.39 | 393.38 | 393.38 | 218.0 |
| 2022-05-20 04:25:00 | SPY | ETF | 393.35 | 393.35 | 393.35 | 393.35 | 200.0 |
| 2022-05-20 04:26:00 | SPY | ETF | 393.3 | 393.3 | 393.3 | 393.3 | 2999.0 |
| 2022-05-20 04:28:00 | SPY | ETF | 393.44 | 393.61 | 393.44 | 393.61 | 861.0 |
| 2022-05-20 04:29:00 | SPY | ETF | 393.65 | 393.66 | 393.65 | 393.66 | 200.0 |
| 2022-05-20 04:30:00 | SPY | ETF | 393.8 | 393.8 | 393.8 | 393.8 | 300.0 |
| 2022-05-20 04:31:00 | SPY | ETF | 393.81 | 393.81 | 393.81 | 393.81 | 100.0 |
| 2022-05-20 04:34:00 | SPY | ETF | 393.91 | 394.1 | 393.91 | 394.1 | 3100.0 |
| 2022-05-20 04:35:00 | SPY | ETF | 394.04 | 394.04 | 394.04 | 394.04 | 100.0 |
| 2022-05-20 04:36:00 | SPY | ETF | 394.07 | 394.07 | 393.96 | 393.96 | 5300.0 |
| 2022-05-20 04:37:00 | SPY | ETF | 393.98 | 393.98 | 393.83 | 393.9 | 5700.0 |
| 2022-05-20 04:40:00 | SPY | ETF | 394.07 | 394.07 | 394.07 | 394.07 | 100.0 |
| 2022-05-20 04:41:00 | SPY | ETF | 394.1 | 394.11 | 394.1 | 394.11 | 200.0 |
| 2022-05-20 04:42:00 | SPY | ETF | 394.07 | 394.07 | 394.07 | 394.07 | 100.0 |
| 2022-05-20 04:43:00 | SPY | ETF | 394.18 | 394.21 | 394.18 | 394.21 | 10349.0 |
| 2022-05-20 04:44:00 | SPY | ETF | 394.25 | 394.32 | 394.25 | 394.25 | 400.0 |
| 2022-05-20 04:45:00 | SPY | ETF | 394.3 | 394.3 | 394.3 | 394.3 | 300.0 |
| 2022-05-20 04:47:00 | SPY | ETF | 394.32 | 394.32 | 394.2 | 394.2 | 299.0 |
| 2022-05-20 04:48:00 | SPY | ETF | 394.01 | 394.01 | 394.01 | 394.01 | 100.0 |
| 2022-05-20 04:49:00 | SPY | ETF | 393.97 | 393.97 | 393.97 | 393.97 | 1195.0 |
| 2022-05-20 04:50:00 | SPY | ETF | 393.84 | 393.84 | 393.84 | 393.84 | 100.0 |
| 2022-05-20 04:53:00 | SPY | ETF | 393.95 | 393.95 | 393.95 | 393.95 | 100.0 |
| 2022-05-20 04:54:00 | SPY | ETF | 393.95 | 393.96 | 393.95 | 393.95 | 300.0 |
| 2022-05-20 04:55:00 | SPY | ETF | 393.81 | 393.81 | 393.81 | 393.81 | 291.0 |
| 2022-05-20 04:57:00 | SPY | ETF | 393.96 | 393.96 | 393.94 | 393.94 | 300.0 |
| 2022-05-20 04:58:00 | SPY | ETF | 393.9 | 393.9 | 393.9 | 393.9 | 300.0 |
| 2022-05-20 04:59:00 | SPY | ETF | 393.9 | 393.9 | 393.9 | 393.9 | 600.0 |
| 2022-05-20 05:00:00 | SPY | ETF | 393.7 | 393.7 | 393.67 | 393.67 | 300.0 |
| 2022-05-20 05:01:00 | SPY | ETF | 393.68 | 393.83 | 393.68 | 393.8 | 600.0 |
| 2022-05-20 05:02:00 | SPY | ETF | 393.85 | 393.89 | 393.85 | 393.89 | 200.0 |
> showing 50 of 286,347 rows — these rows as CSV