PREVIEW / etf_5min / 2022-06-30
file: by_date/etf_5min/2022/2022-06-30.parquet size: 2.0 MB rows: 98,203
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-06-30 04:00:00 | SPY | ETF | 377.48 | 377.48 | 376.33 | 376.81 | 21125.0 |
| 2022-06-30 04:05:00 | SPY | ETF | 376.81 | 377.01 | 376.41 | 376.53 | 4209.0 |
| 2022-06-30 04:10:00 | SPY | ETF | 376.48 | 376.65 | 376.47 | 376.65 | 650.0 |
| 2022-06-30 04:15:00 | SPY | ETF | 376.59 | 376.62 | 376.41 | 376.41 | 8771.0 |
| 2022-06-30 04:20:00 | SPY | ETF | 376.16 | 376.36 | 376.16 | 376.2 | 2264.0 |
| 2022-06-30 04:25:00 | SPY | ETF | 376.13 | 376.2 | 375.89 | 376.12 | 9763.0 |
| 2022-06-30 04:30:00 | SPY | ETF | 375.93 | 376.19 | 375.85 | 375.86 | 22299.0 |
| 2022-06-30 04:35:00 | SPY | ETF | 375.93 | 376.79 | 375.81 | 376.66 | 27824.0 |
| 2022-06-30 04:40:00 | SPY | ETF | 376.32 | 377.01 | 376.28 | 376.81 | 12230.0 |
| 2022-06-30 04:45:00 | SPY | ETF | 376.44 | 376.44 | 376.25 | 376.25 | 600.0 |
| 2022-06-30 04:50:00 | SPY | ETF | 376.16 | 376.31 | 376.16 | 376.29 | 1350.0 |
| 2022-06-30 04:55:00 | SPY | ETF | 376.36 | 376.37 | 376.02 | 376.02 | 1716.0 |
| 2022-06-30 05:00:00 | SPY | ETF | 376.08 | 376.19 | 375.84 | 375.87 | 9125.0 |
| 2022-06-30 05:05:00 | SPY | ETF | 375.87 | 376.16 | 375.6 | 375.69 | 13050.0 |
| 2022-06-30 05:10:00 | SPY | ETF | 375.54 | 375.54 | 374.96 | 374.96 | 30091.0 |
| 2022-06-30 05:15:00 | SPY | ETF | 374.9 | 374.98 | 374.75 | 374.76 | 8023.0 |
| 2022-06-30 05:20:00 | SPY | ETF | 374.7 | 374.8 | 374.7 | 374.79 | 8429.0 |
| 2022-06-30 05:25:00 | SPY | ETF | 374.71 | 374.82 | 374.71 | 374.71 | 8299.0 |
| 2022-06-30 05:30:00 | SPY | ETF | 374.72 | 374.95 | 374.6 | 374.75 | 7650.0 |
| 2022-06-30 05:35:00 | SPY | ETF | 374.78 | 374.78 | 374.73 | 374.77 | 600.0 |
| 2022-06-30 05:40:00 | SPY | ETF | 374.8 | 374.85 | 374.8 | 374.85 | 450.0 |
| 2022-06-30 05:45:00 | SPY | ETF | 374.83 | 375.06 | 374.83 | 375.05 | 6524.0 |
| 2022-06-30 05:50:00 | SPY | ETF | 374.95 | 375.2 | 374.95 | 375.2 | 13509.0 |
| 2022-06-30 05:55:00 | SPY | ETF | 375.24 | 375.88 | 375.13 | 375.82 | 19946.0 |
| 2022-06-30 06:00:00 | SPY | ETF | 375.8 | 375.99 | 375.53 | 375.53 | 19250.0 |
| 2022-06-30 06:05:00 | SPY | ETF | 375.5 | 375.67 | 375.35 | 375.65 | 22999.0 |
| 2022-06-30 06:10:00 | SPY | ETF | 375.64 | 375.67 | 375.42 | 375.5 | 2240.0 |
| 2022-06-30 06:15:00 | SPY | ETF | 375.47 | 375.52 | 375.36 | 375.52 | 1174.0 |
| 2022-06-30 06:20:00 | SPY | ETF | 375.38 | 375.65 | 375.38 | 375.6 | 16450.0 |
| 2022-06-30 06:25:00 | SPY | ETF | 375.4 | 375.4 | 375.01 | 375.01 | 4710.0 |
| 2022-06-30 06:30:00 | SPY | ETF | 375.06 | 375.16 | 375.03 | 375.16 | 8500.0 |
| 2022-06-30 06:35:00 | SPY | ETF | 375.0 | 375.0 | 374.82 | 374.82 | 4195.0 |
| 2022-06-30 06:40:00 | SPY | ETF | 374.85 | 375.05 | 374.67 | 374.99 | 11520.0 |
| 2022-06-30 06:45:00 | SPY | ETF | 375.0 | 375.13 | 374.87 | 374.97 | 9607.0 |
| 2022-06-30 06:50:00 | SPY | ETF | 374.9 | 375.24 | 374.9 | 375.24 | 15813.0 |
| 2022-06-30 06:55:00 | SPY | ETF | 375.3 | 375.55 | 375.3 | 375.51 | 22674.0 |
| 2022-06-30 07:00:00 | SPY | ETF | 375.55 | 375.6 | 375.1 | 375.2 | 40061.0 |
| 2022-06-30 07:05:00 | SPY | ETF | 375.13 | 375.34 | 375.1 | 375.34 | 13483.0 |
| 2022-06-30 07:10:00 | SPY | ETF | 375.4 | 375.57 | 375.321 | 375.55 | 17019.0 |
| 2022-06-30 07:15:00 | SPY | ETF | 375.51 | 375.6 | 375.2 | 375.31 | 17338.0 |
| 2022-06-30 07:20:00 | SPY | ETF | 375.32 | 375.44 | 375.3 | 375.42 | 16974.0 |
| 2022-06-30 07:25:00 | SPY | ETF | 375.34 | 375.61 | 375.29 | 375.56 | 7900.0 |
| 2022-06-30 07:30:00 | SPY | ETF | 375.54 | 375.54 | 375.0 | 375.04 | 8726.0 |
| 2022-06-30 07:35:00 | SPY | ETF | 375.0 | 375.07 | 374.68 | 374.76 | 29428.0 |
| 2022-06-30 07:40:00 | SPY | ETF | 374.68 | 374.94 | 374.55 | 374.8 | 94197.0 |
| 2022-06-30 07:45:00 | SPY | ETF | 374.84 | 374.84 | 374.54 | 374.75 | 29619.0 |
| 2022-06-30 07:50:00 | SPY | ETF | 374.77 | 374.94 | 374.68 | 374.94 | 7732.0 |
| 2022-06-30 07:55:00 | SPY | ETF | 374.95 | 375.14 | 374.95 | 375.01 | 34800.0 |
| 2022-06-30 08:00:00 | SPY | ETF | 375.5001 | 379.4 | 374.56 | 375.2 | 83581.0 |
| 2022-06-30 08:05:00 | SPY | ETF | 375.5038 | 375.5038 | 374.97 | 375.05 | 50893.0 |
> showing 50 of 98,203 rows — these rows as CSV