PREVIEW / etf_5min / 2022-12-14
file: by_date/etf_5min/2022/2022-12-14.parquet size: 2.0 MB rows: 99,174
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-12-14 04:00:00 | SPY | ETF | 402.37 | 402.43 | 402.04 | 402.19 | 12625.0 |
| 2022-12-14 04:05:00 | SPY | ETF | 402.31 | 402.31 | 402.07 | 402.07 | 11832.0 |
| 2022-12-14 04:10:00 | SPY | ETF | 402.02 | 402.12 | 401.75 | 401.87 | 1510.0 |
| 2022-12-14 04:15:00 | SPY | ETF | 401.72 | 401.76 | 401.71 | 401.76 | 5747.0 |
| 2022-12-14 04:20:00 | SPY | ETF | 401.64 | 401.64 | 401.54 | 401.54 | 329.0 |
| 2022-12-14 04:25:00 | SPY | ETF | 401.87 | 402.0 | 401.87 | 402.0 | 890.0 |
| 2022-12-14 04:30:00 | SPY | ETF | 401.95 | 401.95 | 401.76 | 401.76 | 974.0 |
| 2022-12-14 04:35:00 | SPY | ETF | 401.7 | 401.9 | 401.6 | 401.68 | 20471.0 |
| 2022-12-14 04:40:00 | SPY | ETF | 401.62 | 401.98 | 401.62 | 401.98 | 37976.0 |
| 2022-12-14 04:45:00 | SPY | ETF | 401.84 | 401.84 | 401.72 | 401.72 | 1348.0 |
| 2022-12-14 04:50:00 | SPY | ETF | 401.65 | 401.82 | 401.51 | 401.82 | 6454.0 |
| 2022-12-14 04:55:00 | SPY | ETF | 401.99 | 402.04 | 401.99 | 402.03 | 1294.0 |
| 2022-12-14 05:00:00 | SPY | ETF | 402.08 | 402.08 | 402.0 | 402.0 | 215.0 |
| 2022-12-14 05:05:00 | SPY | ETF | 401.9 | 401.9 | 401.9 | 401.9 | 100.0 |
| 2022-12-14 05:10:00 | SPY | ETF | 401.91 | 401.91 | 401.86 | 401.86 | 2487.0 |
| 2022-12-14 05:15:00 | SPY | ETF | 401.97 | 401.97 | 401.97 | 401.97 | 600.0 |
| 2022-12-14 05:20:00 | SPY | ETF | 402.06 | 402.19 | 402.05 | 402.19 | 1040.0 |
| 2022-12-14 05:25:00 | SPY | ETF | 402.25 | 402.26 | 402.25 | 402.25 | 3400.0 |
| 2022-12-14 05:30:00 | SPY | ETF | 402.29 | 402.29 | 402.28 | 402.28 | 800.0 |
| 2022-12-14 05:35:00 | SPY | ETF | 402.22 | 402.22 | 402.01 | 402.17 | 732.0 |
| 2022-12-14 05:40:00 | SPY | ETF | 402.14 | 402.14 | 401.89 | 401.89 | 630.0 |
| 2022-12-14 05:45:00 | SPY | ETF | 401.83 | 401.83 | 401.81 | 401.81 | 204.0 |
| 2022-12-14 05:50:00 | SPY | ETF | 401.81 | 401.92 | 401.8 | 401.92 | 1097.0 |
| 2022-12-14 06:00:00 | SPY | ETF | 401.83 | 401.91 | 401.74 | 401.91 | 1800.0 |
| 2022-12-14 06:05:00 | SPY | ETF | 401.93 | 401.93 | 401.67 | 401.67 | 3411.0 |
| 2022-12-14 06:10:00 | SPY | ETF | 401.58 | 401.58 | 401.2 | 401.23 | 9696.0 |
| 2022-12-14 06:15:00 | SPY | ETF | 401.3 | 401.35 | 401.16 | 401.16 | 2597.0 |
| 2022-12-14 06:20:00 | SPY | ETF | 401.24 | 401.34 | 401.09 | 401.34 | 2067.0 |
| 2022-12-14 06:25:00 | SPY | ETF | 401.34 | 401.5 | 401.34 | 401.46 | 2719.0 |
| 2022-12-14 06:30:00 | SPY | ETF | 401.44 | 401.56 | 401.44 | 401.45 | 4750.0 |
| 2022-12-14 06:35:00 | SPY | ETF | 401.28 | 401.28 | 401.09 | 401.09 | 3700.0 |
| 2022-12-14 06:40:00 | SPY | ETF | 401.3 | 401.64 | 401.3 | 401.56 | 6913.0 |
| 2022-12-14 06:45:00 | SPY | ETF | 401.57 | 401.57 | 401.5 | 401.5 | 3092.0 |
| 2022-12-14 06:50:00 | SPY | ETF | 401.66 | 401.88 | 401.66 | 401.88 | 1194.0 |
| 2022-12-14 06:55:00 | SPY | ETF | 401.95 | 402.03 | 401.85 | 402.02 | 3799.0 |
| 2022-12-14 07:00:00 | SPY | ETF | 401.94 | 402.0 | 401.9 | 401.97 | 1386.0 |
| 2022-12-14 07:05:00 | SPY | ETF | 402.05 | 402.32 | 402.05 | 402.28 | 60484.0 |
| 2022-12-14 07:10:00 | SPY | ETF | 402.3 | 402.52 | 402.3 | 402.52 | 55708.0 |
| 2022-12-14 07:15:00 | SPY | ETF | 402.55 | 402.68 | 402.55 | 402.66 | 2406.0 |
| 2022-12-14 07:20:00 | SPY | ETF | 402.5 | 402.5 | 402.41 | 402.45 | 14125.0 |
| 2022-12-14 07:25:00 | SPY | ETF | 402.49 | 402.52 | 402.36 | 402.36 | 1925.0 |
| 2022-12-14 07:30:00 | SPY | ETF | 402.31 | 402.33 | 402.15 | 402.15 | 4452.0 |
| 2022-12-14 07:35:00 | SPY | ETF | 402.18 | 402.18 | 402.0 | 402.0 | 3774.0 |
| 2022-12-14 07:40:00 | SPY | ETF | 402.0 | 402.0 | 401.7 | 401.7 | 4579.0 |
| 2022-12-14 07:45:00 | SPY | ETF | 401.7 | 401.7 | 401.47 | 401.5 | 24587.0 |
| 2022-12-14 07:50:00 | SPY | ETF | 401.48 | 401.49 | 401.24 | 401.3 | 24857.0 |
| 2022-12-14 07:55:00 | SPY | ETF | 401.3 | 401.5 | 401.29 | 401.44 | 17776.0 |
| 2022-12-14 08:00:00 | SPY | ETF | 402.17 | 403.27 | 401.23 | 401.48 | 61443.0 |
| 2022-12-14 08:05:00 | SPY | ETF | 401.3304 | 401.51 | 401.29 | 401.41 | 41324.0 |
| 2022-12-14 08:10:00 | SPY | ETF | 401.35 | 401.44 | 401.05 | 401.05 | 37074.0 |
> showing 50 of 99,174 rows — these rows as CSV