PREVIEW / etf_5min / 2022-12-13
file: by_date/etf_5min/2022/2022-12-13.parquet size: 2.1 MB rows: 104,204
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-13 04:00:00 | SPY | ETF | 398.9 | 399.3 | 398.9 | 399.21 | 3852.0 |
| 2022-12-13 04:05:00 | SPY | ETF | 399.17 | 399.54 | 399.17 | 399.48 | 1825.0 |
| 2022-12-13 04:10:00 | SPY | ETF | 399.42 | 399.49 | 399.28 | 399.29 | 2523.0 |
| 2022-12-13 04:15:00 | SPY | ETF | 399.29 | 399.49 | 399.29 | 399.42 | 23750.0 |
| 2022-12-13 04:20:00 | SPY | ETF | 399.4 | 399.43 | 399.3 | 399.35 | 9835.0 |
| 2022-12-13 04:25:00 | SPY | ETF | 399.57 | 399.64 | 399.57 | 399.64 | 1250.0 |
| 2022-12-13 04:30:00 | SPY | ETF | 399.7 | 400.13 | 399.7 | 400.13 | 22525.0 |
| 2022-12-13 04:35:00 | SPY | ETF | 400.13 | 400.23 | 400.1 | 400.22 | 14992.0 |
| 2022-12-13 04:40:00 | SPY | ETF | 400.27 | 400.27 | 399.54 | 399.55 | 3857.0 |
| 2022-12-13 04:45:00 | SPY | ETF | 399.52 | 399.57 | 399.48 | 399.56 | 18553.0 |
| 2022-12-13 04:50:00 | SPY | ETF | 399.56 | 399.65 | 399.55 | 399.65 | 4725.0 |
| 2022-12-13 04:55:00 | SPY | ETF | 399.61 | 399.81 | 399.61 | 399.81 | 682.0 |
| 2022-12-13 05:00:00 | SPY | ETF | 399.75 | 399.75 | 399.37 | 399.44 | 2515.0 |
| 2022-12-13 05:05:00 | SPY | ETF | 399.59 | 399.65 | 399.59 | 399.65 | 506.0 |
| 2022-12-13 05:10:00 | SPY | ETF | 399.57 | 399.57 | 399.41 | 399.57 | 4005.0 |
| 2022-12-13 05:15:00 | SPY | ETF | 399.55 | 399.55 | 399.55 | 399.55 | 300.0 |
| 2022-12-13 05:20:00 | SPY | ETF | 399.9 | 400.03 | 399.9 | 400.03 | 2214.0 |
| 2022-12-13 05:25:00 | SPY | ETF | 400.01 | 400.34 | 399.98 | 400.25 | 3713.0 |
| 2022-12-13 05:30:00 | SPY | ETF | 400.29 | 400.42 | 400.2 | 400.4 | 1303.0 |
| 2022-12-13 05:35:00 | SPY | ETF | 400.56 | 400.56 | 400.43 | 400.43 | 1600.0 |
| 2022-12-13 05:40:00 | SPY | ETF | 400.51 | 400.72 | 400.41 | 400.51 | 6450.0 |
| 2022-12-13 05:45:00 | SPY | ETF | 400.46 | 400.47 | 400.37 | 400.37 | 1335.0 |
| 2022-12-13 05:50:00 | SPY | ETF | 400.6 | 400.7 | 400.56 | 400.56 | 2000.0 |
| 2022-12-13 05:55:00 | SPY | ETF | 400.57 | 400.75 | 400.57 | 400.63 | 500.0 |
| 2022-12-13 06:00:00 | SPY | ETF | 400.68 | 400.74 | 400.64 | 400.66 | 1727.0 |
| 2022-12-13 06:05:00 | SPY | ETF | 400.66 | 400.66 | 400.45 | 400.45 | 7231.0 |
| 2022-12-13 06:10:00 | SPY | ETF | 400.54 | 400.85 | 400.54 | 400.66 | 6787.0 |
| 2022-12-13 06:15:00 | SPY | ETF | 400.63 | 400.72 | 400.54 | 400.54 | 1975.0 |
| 2022-12-13 06:20:00 | SPY | ETF | 400.6 | 400.92 | 400.6 | 400.92 | 6863.0 |
| 2022-12-13 06:25:00 | SPY | ETF | 400.9 | 400.96 | 400.9 | 400.93 | 950.0 |
| 2022-12-13 06:30:00 | SPY | ETF | 401.0 | 401.0 | 400.79 | 400.82 | 4998.0 |
| 2022-12-13 06:35:00 | SPY | ETF | 400.84 | 400.92 | 400.79 | 400.89 | 2030.0 |
| 2022-12-13 06:40:00 | SPY | ETF | 400.89 | 401.03 | 400.89 | 400.93 | 6732.0 |
| 2022-12-13 06:45:00 | SPY | ETF | 400.91 | 400.92 | 400.75 | 400.81 | 8225.0 |
| 2022-12-13 06:50:00 | SPY | ETF | 400.82 | 401.3 | 400.81 | 401.07 | 20712.0 |
| 2022-12-13 06:55:00 | SPY | ETF | 401.22 | 401.23 | 400.96 | 401.02 | 6364.0 |
| 2022-12-13 07:00:00 | SPY | ETF | 400.97 | 401.0 | 400.69 | 400.69 | 22150.0 |
| 2022-12-13 07:05:00 | SPY | ETF | 400.66 | 400.85 | 400.66 | 400.85 | 13739.0 |
| 2022-12-13 07:10:00 | SPY | ETF | 400.85 | 400.89 | 400.85 | 400.88 | 12205.0 |
| 2022-12-13 07:15:00 | SPY | ETF | 400.85 | 400.88 | 400.85 | 400.85 | 4674.0 |
| 2022-12-13 07:20:00 | SPY | ETF | 400.9 | 401.1 | 400.83 | 401.04 | 20129.0 |
| 2022-12-13 07:25:00 | SPY | ETF | 401.07 | 401.16 | 401.0 | 401.06 | 30605.0 |
| 2022-12-13 07:30:00 | SPY | ETF | 400.99 | 401.23 | 400.99 | 401.13 | 9115.0 |
| 2022-12-13 07:35:00 | SPY | ETF | 401.15 | 401.4 | 401.15 | 401.35 | 35388.0 |
| 2022-12-13 07:40:00 | SPY | ETF | 401.28 | 401.35 | 401.26 | 401.26 | 13306.0 |
| 2022-12-13 07:45:00 | SPY | ETF | 401.28 | 401.55 | 401.23 | 401.5 | 21550.0 |
| 2022-12-13 07:50:00 | SPY | ETF | 401.47 | 401.47 | 401.3 | 401.3 | 25757.0 |
| 2022-12-13 07:55:00 | SPY | ETF | 401.28 | 401.81 | 401.28 | 401.72 | 36460.0 |
| 2022-12-13 08:00:00 | SPY | ETF | 400.89 | 401.75 | 398.8 | 401.31 | 94656.0 |
| 2022-12-13 08:05:00 | SPY | ETF | 401.34 | 401.4 | 401.18 | 401.28 | 50152.0 |
> showing 50 of 104,204 rows — these rows as CSV