PREVIEW / etf_5min / 2022-12-20
file: by_date/etf_5min/2022/2022-12-20.parquet size: 2.1 MB rows: 102,871
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-20 04:00:00 | SPY | ETF | 379.69 | 379.97 | 379.44 | 379.44 | 13780.0 |
| 2022-12-20 04:05:00 | SPY | ETF | 379.44 | 379.67 | 379.25 | 379.25 | 8851.0 |
| 2022-12-20 04:10:00 | SPY | ETF | 379.27 | 379.62 | 379.26 | 379.62 | 4064.0 |
| 2022-12-20 04:15:00 | SPY | ETF | 379.64 | 379.64 | 379.16 | 379.35 | 5741.0 |
| 2022-12-20 04:20:00 | SPY | ETF | 379.25 | 379.55 | 379.25 | 379.48 | 3343.0 |
| 2022-12-20 04:25:00 | SPY | ETF | 379.45 | 379.7 | 379.45 | 379.66 | 3000.0 |
| 2022-12-20 04:30:00 | SPY | ETF | 379.71 | 380.25 | 379.71 | 380.18 | 25714.0 |
| 2022-12-20 04:35:00 | SPY | ETF | 380.04 | 380.04 | 379.7 | 379.75 | 1826.0 |
| 2022-12-20 04:40:00 | SPY | ETF | 379.89 | 379.96 | 379.81 | 379.96 | 2279.0 |
| 2022-12-20 04:45:00 | SPY | ETF | 379.99 | 379.99 | 379.45 | 379.45 | 2879.0 |
| 2022-12-20 04:50:00 | SPY | ETF | 379.53 | 379.6 | 379.33 | 379.4 | 3162.0 |
| 2022-12-20 04:55:00 | SPY | ETF | 379.67 | 379.92 | 379.67 | 379.92 | 7123.0 |
| 2022-12-20 05:00:00 | SPY | ETF | 379.9 | 380.14 | 379.8 | 379.85 | 2484.0 |
| 2022-12-20 05:05:00 | SPY | ETF | 379.8 | 379.89 | 379.7 | 379.8 | 1781.0 |
| 2022-12-20 05:15:00 | SPY | ETF | 379.66 | 379.66 | 379.56 | 379.56 | 600.0 |
| 2022-12-20 05:20:00 | SPY | ETF | 379.7 | 379.82 | 379.64 | 379.82 | 1430.0 |
| 2022-12-20 05:25:00 | SPY | ETF | 379.91 | 379.96 | 379.88 | 379.96 | 1016.0 |
| 2022-12-20 05:30:00 | SPY | ETF | 380.0 | 380.0 | 379.63 | 379.68 | 2541.0 |
| 2022-12-20 05:35:00 | SPY | ETF | 379.56 | 379.6 | 379.31 | 379.31 | 2925.0 |
| 2022-12-20 05:40:00 | SPY | ETF | 379.26 | 379.41 | 379.23 | 379.28 | 2500.0 |
| 2022-12-20 05:45:00 | SPY | ETF | 379.25 | 379.55 | 379.25 | 379.55 | 1612.0 |
| 2022-12-20 05:50:00 | SPY | ETF | 379.59 | 379.89 | 379.59 | 379.89 | 3087.0 |
| 2022-12-20 05:55:00 | SPY | ETF | 379.86 | 379.88 | 379.74 | 379.74 | 12130.0 |
| 2022-12-20 06:00:00 | SPY | ETF | 379.85 | 380.1 | 379.85 | 380.08 | 6609.0 |
| 2022-12-20 06:05:00 | SPY | ETF | 379.77 | 379.77 | 379.73 | 379.75 | 1085.0 |
| 2022-12-20 06:10:00 | SPY | ETF | 379.92 | 380.14 | 379.92 | 380.13 | 3016.0 |
| 2022-12-20 06:15:00 | SPY | ETF | 380.12 | 380.28 | 379.91 | 380.27 | 10659.0 |
| 2022-12-20 06:20:00 | SPY | ETF | 380.25 | 380.4 | 380.21 | 380.4 | 10013.0 |
| 2022-12-20 06:25:00 | SPY | ETF | 380.4 | 380.4 | 380.17 | 380.24 | 3646.0 |
| 2022-12-20 06:30:00 | SPY | ETF | 380.32 | 380.32 | 380.16 | 380.16 | 3650.0 |
| 2022-12-20 06:35:00 | SPY | ETF | 380.15 | 380.15 | 379.88 | 379.88 | 2413.0 |
| 2022-12-20 06:40:00 | SPY | ETF | 379.89 | 380.27 | 379.89 | 380.27 | 2438.0 |
| 2022-12-20 06:45:00 | SPY | ETF | 380.17 | 380.17 | 379.99 | 380.1 | 950.0 |
| 2022-12-20 06:50:00 | SPY | ETF | 379.9 | 379.92 | 379.61 | 379.61 | 14871.0 |
| 2022-12-20 06:55:00 | SPY | ETF | 379.65 | 379.75 | 379.65 | 379.72 | 900.0 |
| 2022-12-20 07:00:00 | SPY | ETF | 379.87 | 380.19 | 379.69 | 379.7 | 65997.0 |
| 2022-12-20 07:05:00 | SPY | ETF | 379.69 | 380.15 | 379.65 | 380.15 | 23216.0 |
| 2022-12-20 07:10:00 | SPY | ETF | 380.04 | 380.2 | 379.96 | 380.19 | 10539.0 |
| 2022-12-20 07:15:00 | SPY | ETF | 380.15 | 380.3 | 380.1 | 380.3 | 13780.0 |
| 2022-12-20 07:20:00 | SPY | ETF | 380.2 | 380.43 | 380.2 | 380.32 | 9019.0 |
| 2022-12-20 07:25:00 | SPY | ETF | 380.31 | 380.31 | 380.08 | 380.18 | 17896.0 |
| 2022-12-20 07:30:00 | SPY | ETF | 380.09 | 380.09 | 379.9 | 379.96 | 6583.0 |
| 2022-12-20 07:35:00 | SPY | ETF | 379.85 | 379.89 | 379.65 | 379.68 | 31141.0 |
| 2022-12-20 07:40:00 | SPY | ETF | 379.69 | 379.87 | 379.62 | 379.7 | 22417.0 |
| 2022-12-20 07:45:00 | SPY | ETF | 379.69 | 379.69 | 379.4 | 379.52 | 27818.0 |
| 2022-12-20 07:50:00 | SPY | ETF | 379.46 | 379.6 | 379.36 | 379.49 | 33615.0 |
| 2022-12-20 07:55:00 | SPY | ETF | 379.4 | 379.53 | 378.95 | 378.95 | 22826.0 |
| 2022-12-20 08:00:00 | SPY | ETF | 378.96 | 380.3996 | 376.2 | 379.05 | 111461.0 |
| 2022-12-20 08:05:00 | SPY | ETF | 379.04 | 379.24 | 379.04 | 379.15 | 42098.0 |
| 2022-12-20 08:10:00 | SPY | ETF | 379.22 | 379.35 | 379.06 | 379.35 | 45650.0 |
> showing 50 of 102,871 rows — these rows as CSV