PREVIEW / etf_5min / 2022-10-25
file: by_date/etf_5min/2022/2022-10-25.parquet size: 2.0 MB rows: 99,313
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-10-25 04:00:00 | SPY | ETF | 378.0 | 378.98 | 378.0 | 378.93 | 12289.0 |
| 2022-10-25 04:05:00 | SPY | ETF | 378.9 | 379.23 | 378.89 | 378.89 | 2417.0 |
| 2022-10-25 04:10:00 | SPY | ETF | 378.91 | 379.25 | 378.9 | 379.16 | 5800.0 |
| 2022-10-25 04:15:00 | SPY | ETF | 379.24 | 379.25 | 379.0 | 379.0 | 2862.0 |
| 2022-10-25 04:20:00 | SPY | ETF | 378.87 | 378.87 | 378.7 | 378.7 | 4846.0 |
| 2022-10-25 04:25:00 | SPY | ETF | 378.7 | 378.7 | 378.6 | 378.61 | 10051.0 |
| 2022-10-25 04:30:00 | SPY | ETF | 378.61 | 378.74 | 378.61 | 378.74 | 17271.0 |
| 2022-10-25 04:35:00 | SPY | ETF | 378.72 | 378.72 | 378.67 | 378.72 | 800.0 |
| 2022-10-25 04:40:00 | SPY | ETF | 379.02 | 379.02 | 378.79 | 378.79 | 5150.0 |
| 2022-10-25 04:45:00 | SPY | ETF | 378.59 | 378.59 | 378.54 | 378.54 | 352.0 |
| 2022-10-25 04:50:00 | SPY | ETF | 378.53 | 378.6 | 378.53 | 378.6 | 600.0 |
| 2022-10-25 04:55:00 | SPY | ETF | 378.37 | 378.37 | 378.01 | 378.11 | 6309.0 |
| 2022-10-25 05:00:00 | SPY | ETF | 378.08 | 378.09 | 377.93 | 377.94 | 3900.0 |
| 2022-10-25 05:05:00 | SPY | ETF | 377.8 | 377.93 | 377.8 | 377.81 | 2569.0 |
| 2022-10-25 05:10:00 | SPY | ETF | 377.7 | 378.0 | 377.69 | 377.97 | 2605.0 |
| 2022-10-25 05:15:00 | SPY | ETF | 377.87 | 377.92 | 377.83 | 377.83 | 1121.0 |
| 2022-10-25 05:20:00 | SPY | ETF | 377.93 | 377.97 | 377.92 | 377.92 | 300.0 |
| 2022-10-25 05:25:00 | SPY | ETF | 377.87 | 377.88 | 377.7 | 377.7 | 300.0 |
| 2022-10-25 05:30:00 | SPY | ETF | 377.6 | 377.6 | 377.35 | 377.43 | 3585.0 |
| 2022-10-25 05:35:00 | SPY | ETF | 377.35 | 377.35 | 377.17 | 377.33 | 4950.0 |
| 2022-10-25 05:40:00 | SPY | ETF | 377.28 | 377.37 | 377.17 | 377.17 | 2605.0 |
| 2022-10-25 05:45:00 | SPY | ETF | 377.06 | 377.28 | 376.96 | 377.13 | 8675.0 |
| 2022-10-25 05:50:00 | SPY | ETF | 377.1 | 377.35 | 377.1 | 377.31 | 15356.0 |
| 2022-10-25 05:55:00 | SPY | ETF | 377.48 | 377.65 | 377.38 | 377.38 | 4112.0 |
| 2022-10-25 06:00:00 | SPY | ETF | 377.3 | 377.54 | 377.23 | 377.54 | 3768.0 |
| 2022-10-25 06:05:00 | SPY | ETF | 377.65 | 377.73 | 377.48 | 377.56 | 3753.0 |
| 2022-10-25 06:10:00 | SPY | ETF | 377.56 | 377.56 | 377.09 | 377.2 | 1000.0 |
| 2022-10-25 06:15:00 | SPY | ETF | 377.25 | 377.25 | 377.05 | 377.06 | 1950.0 |
| 2022-10-25 06:20:00 | SPY | ETF | 377.01 | 377.28 | 376.92 | 377.28 | 2678.0 |
| 2022-10-25 06:25:00 | SPY | ETF | 377.33 | 377.51 | 377.27 | 377.51 | 3700.0 |
| 2022-10-25 06:30:00 | SPY | ETF | 377.48 | 377.49 | 377.36 | 377.38 | 2144.0 |
| 2022-10-25 06:35:00 | SPY | ETF | 377.33 | 377.63 | 377.31 | 377.59 | 3045.0 |
| 2022-10-25 06:40:00 | SPY | ETF | 377.51 | 377.73 | 377.51 | 377.73 | 4287.0 |
| 2022-10-25 06:45:00 | SPY | ETF | 377.77 | 377.85 | 377.68 | 377.76 | 3280.0 |
| 2022-10-25 06:50:00 | SPY | ETF | 377.67 | 377.76 | 377.55 | 377.7 | 1474.0 |
| 2022-10-25 06:55:00 | SPY | ETF | 377.75 | 377.77 | 377.75 | 377.76 | 2100.0 |
| 2022-10-25 07:00:00 | SPY | ETF | 377.83 | 377.9 | 377.49 | 377.49 | 24419.0 |
| 2022-10-25 07:05:00 | SPY | ETF | 377.49 | 377.79 | 377.49 | 377.77 | 7149.0 |
| 2022-10-25 07:10:00 | SPY | ETF | 377.75 | 377.87 | 377.68 | 377.87 | 17100.0 |
| 2022-10-25 07:15:00 | SPY | ETF | 377.85 | 377.89 | 377.65 | 377.75 | 6113.0 |
| 2022-10-25 07:20:00 | SPY | ETF | 377.77 | 377.92 | 377.73 | 377.85 | 22452.0 |
| 2022-10-25 07:25:00 | SPY | ETF | 377.85 | 378.36 | 377.85 | 378.3 | 24101.0 |
| 2022-10-25 07:30:00 | SPY | ETF | 378.24 | 378.25 | 378.12 | 378.13 | 9205.0 |
| 2022-10-25 07:35:00 | SPY | ETF | 378.15 | 378.28 | 378.13 | 378.28 | 6497.0 |
| 2022-10-25 07:40:00 | SPY | ETF | 378.35 | 378.42 | 378.08 | 378.09 | 19913.0 |
| 2022-10-25 07:45:00 | SPY | ETF | 378.05 | 378.08 | 377.76 | 377.76 | 25248.0 |
| 2022-10-25 07:50:00 | SPY | ETF | 377.85 | 377.88 | 377.73 | 377.75 | 26451.0 |
| 2022-10-25 07:55:00 | SPY | ETF | 377.72 | 377.72 | 377.53 | 377.54 | 55264.0 |
| 2022-10-25 08:00:00 | SPY | ETF | 377.88 | 379.6 | 377.35 | 378.61 | 262589.0 |
| 2022-10-25 08:05:00 | SPY | ETF | 377.3 | 377.3 | 376.97 | 377.06 | 45094.0 |
> showing 50 of 99,313 rows — these rows as CSV