PREVIEW / etf_5min / 2023-10-04
file: by_date/etf_5min/2023/2023-10-04.parquet size: 2.1 MB rows: 103,855
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 |
|---|---|---|---|---|---|---|---|
| 2023-10-04 04:00:00 | SPY | ETF | 420.33 | 420.48 | 420.07 | 420.3 | 8025.0 |
| 2023-10-04 04:05:00 | SPY | ETF | 420.17 | 420.54 | 420.17 | 420.52 | 2050.0 |
| 2023-10-04 04:10:00 | SPY | ETF | 420.49 | 420.83 | 420.42 | 420.71 | 3244.0 |
| 2023-10-04 04:15:00 | SPY | ETF | 420.85 | 420.91 | 420.68 | 420.68 | 1195.0 |
| 2023-10-04 04:20:00 | SPY | ETF | 420.55 | 420.73 | 420.51 | 420.73 | 1875.0 |
| 2023-10-04 04:25:00 | SPY | ETF | 420.77 | 421.0 | 420.77 | 420.98 | 4250.0 |
| 2023-10-04 04:30:00 | SPY | ETF | 421.04 | 421.12 | 420.95 | 421.08 | 5125.0 |
| 2023-10-04 04:35:00 | SPY | ETF | 420.92 | 421.08 | 420.84 | 421.08 | 6150.0 |
| 2023-10-04 04:40:00 | SPY | ETF | 421.05 | 421.31 | 421.05 | 421.09 | 6300.0 |
| 2023-10-04 04:45:00 | SPY | ETF | 421.16 | 421.16 | 420.95 | 421.07 | 2711.0 |
| 2023-10-04 04:50:00 | SPY | ETF | 420.99 | 421.04 | 420.99 | 421.04 | 3200.0 |
| 2023-10-04 05:00:00 | SPY | ETF | 420.93 | 420.93 | 420.87 | 420.89 | 2250.0 |
| 2023-10-04 05:05:00 | SPY | ETF | 421.0 | 421.25 | 420.9 | 421.25 | 2752.0 |
| 2023-10-04 05:10:00 | SPY | ETF | 421.26 | 421.26 | 421.23 | 421.23 | 1121.0 |
| 2023-10-04 05:15:00 | SPY | ETF | 421.14 | 421.18 | 421.11 | 421.18 | 1600.0 |
| 2023-10-04 05:20:00 | SPY | ETF | 421.05 | 421.17 | 421.05 | 421.15 | 300.0 |
| 2023-10-04 05:25:00 | SPY | ETF | 421.16 | 421.21 | 421.11 | 421.21 | 600.0 |
| 2023-10-04 05:30:00 | SPY | ETF | 421.4 | 421.52 | 421.38 | 421.38 | 2861.0 |
| 2023-10-04 05:35:00 | SPY | ETF | 421.55 | 421.65 | 421.52 | 421.54 | 3189.0 |
| 2023-10-04 05:40:00 | SPY | ETF | 421.67 | 421.74 | 421.43 | 421.55 | 41785.0 |
| 2023-10-04 05:45:00 | SPY | ETF | 421.55 | 421.68 | 421.55 | 421.6 | 1825.0 |
| 2023-10-04 05:50:00 | SPY | ETF | 421.61 | 421.7 | 421.61 | 421.69 | 1350.0 |
| 2023-10-04 05:55:00 | SPY | ETF | 421.75 | 421.75 | 421.55 | 421.68 | 3182.0 |
| 2023-10-04 06:00:00 | SPY | ETF | 421.68 | 421.73 | 421.67 | 421.7 | 900.0 |
| 2023-10-04 06:05:00 | SPY | ETF | 421.72 | 421.83 | 421.63 | 421.76 | 20098.0 |
| 2023-10-04 06:10:00 | SPY | ETF | 421.63 | 421.85 | 421.63 | 421.82 | 21926.0 |
| 2023-10-04 06:15:00 | SPY | ETF | 421.76 | 421.86 | 421.76 | 421.82 | 29261.0 |
| 2023-10-04 06:20:00 | SPY | ETF | 421.76 | 421.95 | 421.75 | 421.95 | 8820.0 |
| 2023-10-04 06:25:00 | SPY | ETF | 421.88 | 421.95 | 421.83 | 421.91 | 2768.0 |
| 2023-10-04 06:30:00 | SPY | ETF | 421.68 | 421.68 | 421.48 | 421.55 | 4013.0 |
| 2023-10-04 06:35:00 | SPY | ETF | 421.53 | 421.59 | 421.48 | 421.59 | 2915.0 |
| 2023-10-04 06:40:00 | SPY | ETF | 421.51 | 421.52 | 421.38 | 421.39 | 2968.0 |
| 2023-10-04 06:45:00 | SPY | ETF | 421.3 | 421.34 | 421.13 | 421.13 | 3800.0 |
| 2023-10-04 06:50:00 | SPY | ETF | 421.12 | 421.19 | 421.05 | 421.19 | 4072.0 |
| 2023-10-04 06:55:00 | SPY | ETF | 421.13 | 421.45 | 421.13 | 421.45 | 3750.0 |
| 2023-10-04 07:00:00 | SPY | ETF | 421.42 | 421.53 | 421.24 | 421.42 | 33466.0 |
| 2023-10-04 07:05:00 | SPY | ETF | 421.5 | 422.1 | 421.5 | 422.1 | 76680.0 |
| 2023-10-04 07:10:00 | SPY | ETF | 422.02 | 422.23 | 421.99 | 422.23 | 26879.0 |
| 2023-10-04 07:15:00 | SPY | ETF | 422.23 | 422.45 | 422.2 | 422.27 | 38150.0 |
| 2023-10-04 07:20:00 | SPY | ETF | 422.22 | 422.22 | 422.03 | 422.03 | 116480.0 |
| 2023-10-04 07:25:00 | SPY | ETF | 422.14 | 422.24 | 421.99 | 422.01 | 20183.0 |
| 2023-10-04 07:30:00 | SPY | ETF | 422.0 | 422.22 | 421.9 | 422.04 | 38984.0 |
| 2023-10-04 07:35:00 | SPY | ETF | 422.06 | 422.25 | 421.89 | 422.15 | 37103.0 |
| 2023-10-04 07:40:00 | SPY | ETF | 422.1 | 422.31 | 422.09 | 422.26 | 42515.0 |
| 2023-10-04 07:45:00 | SPY | ETF | 422.24 | 422.57 | 422.24 | 422.52 | 36083.0 |
| 2023-10-04 07:50:00 | SPY | ETF | 422.46 | 422.57 | 422.4 | 422.43 | 12673.0 |
| 2023-10-04 07:55:00 | SPY | ETF | 422.4 | 422.44 | 422.24 | 422.37 | 46009.0 |
| 2023-10-04 08:00:00 | SPY | ETF | 422.2385 | 422.55 | 418.81 | 422.37 | 161379.0 |
| 2023-10-04 08:05:00 | SPY | ETF | 422.4 | 422.47 | 422.18 | 422.31 | 43545.0 |
| 2023-10-04 08:10:00 | SPY | ETF | 422.29 | 422.41 | 422.29 | 422.32 | 12677.0 |
> showing 50 of 103,855 rows — these rows as CSV