PREVIEW / etf_5min / 2022-04-06
file: by_date/etf_5min/2022/2022-04-06.parquet size: 2.0 MB rows: 98,982
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-04-06 04:00:00 | SPY | ETF | 451.27 | 451.27 | 449.14 | 449.49 | 3658.0 |
| 2022-04-06 04:05:00 | SPY | ETF | 449.45 | 449.64 | 449.45 | 449.55 | 2444.0 |
| 2022-04-06 04:10:00 | SPY | ETF | 449.46 | 449.54 | 449.32 | 449.53 | 1341.0 |
| 2022-04-06 04:15:00 | SPY | ETF | 449.53 | 449.59 | 449.03 | 449.08 | 1059.0 |
| 2022-04-06 04:20:00 | SPY | ETF | 449.09 | 449.1 | 448.79 | 448.79 | 4599.0 |
| 2022-04-06 04:25:00 | SPY | ETF | 448.9 | 449.24 | 448.9 | 449.11 | 3622.0 |
| 2022-04-06 04:30:00 | SPY | ETF | 449.15 | 449.18 | 448.83 | 448.88 | 2105.0 |
| 2022-04-06 04:35:00 | SPY | ETF | 449.11 | 449.11 | 448.8 | 448.92 | 6046.0 |
| 2022-04-06 04:40:00 | SPY | ETF | 448.91 | 448.91 | 448.8 | 448.8 | 2600.0 |
| 2022-04-06 04:45:00 | SPY | ETF | 449.13 | 449.3 | 449.1 | 449.22 | 2871.0 |
| 2022-04-06 04:50:00 | SPY | ETF | 449.26 | 449.43 | 449.26 | 449.37 | 2622.0 |
| 2022-04-06 04:55:00 | SPY | ETF | 449.46 | 449.47 | 449.46 | 449.47 | 231.0 |
| 2022-04-06 05:00:00 | SPY | ETF | 449.6 | 449.6 | 449.4 | 449.4 | 1200.0 |
| 2022-04-06 05:05:00 | SPY | ETF | 449.42 | 449.43 | 449.21 | 449.21 | 7923.0 |
| 2022-04-06 05:10:00 | SPY | ETF | 449.33 | 449.33 | 449.06 | 449.06 | 5578.0 |
| 2022-04-06 05:15:00 | SPY | ETF | 449.0 | 449.16 | 448.8 | 449.09 | 2600.0 |
| 2022-04-06 05:20:00 | SPY | ETF | 449.0 | 449.02 | 448.89 | 448.89 | 890.0 |
| 2022-04-06 05:25:00 | SPY | ETF | 449.02 | 449.02 | 448.84 | 448.84 | 1400.0 |
| 2022-04-06 05:30:00 | SPY | ETF | 448.88 | 448.88 | 448.86 | 448.86 | 600.0 |
| 2022-04-06 05:35:00 | SPY | ETF | 448.68 | 448.69 | 448.55 | 448.55 | 960.0 |
| 2022-04-06 05:40:00 | SPY | ETF | 448.7 | 448.7 | 448.2 | 448.32 | 6296.0 |
| 2022-04-06 05:45:00 | SPY | ETF | 448.46 | 448.46 | 448.17 | 448.17 | 2141.0 |
| 2022-04-06 05:50:00 | SPY | ETF | 448.13 | 448.18 | 447.99 | 448.18 | 6513.0 |
| 2022-04-06 05:55:00 | SPY | ETF | 448.14 | 448.65 | 448.14 | 448.65 | 1500.0 |
| 2022-04-06 06:00:00 | SPY | ETF | 448.7 | 448.7 | 448.55 | 448.56 | 1452.0 |
| 2022-04-06 06:05:00 | SPY | ETF | 448.71 | 448.71 | 448.71 | 448.71 | 120.0 |
| 2022-04-06 06:10:00 | SPY | ETF | 448.56 | 448.64 | 448.24 | 448.32 | 3701.0 |
| 2022-04-06 06:15:00 | SPY | ETF | 448.26 | 448.28 | 447.9 | 448.01 | 9878.0 |
| 2022-04-06 06:20:00 | SPY | ETF | 448.01 | 448.22 | 447.91 | 448.22 | 5153.0 |
| 2022-04-06 06:25:00 | SPY | ETF | 448.15 | 448.31 | 448.09 | 448.3 | 2776.0 |
| 2022-04-06 06:30:00 | SPY | ETF | 448.2 | 448.2 | 447.96 | 448.06 | 5840.0 |
| 2022-04-06 06:35:00 | SPY | ETF | 448.12 | 448.12 | 447.8 | 447.84 | 30974.0 |
| 2022-04-06 06:40:00 | SPY | ETF | 447.87 | 448.05 | 447.86 | 448.03 | 1743.0 |
| 2022-04-06 06:45:00 | SPY | ETF | 447.94 | 447.98 | 447.88 | 447.88 | 3172.0 |
| 2022-04-06 06:50:00 | SPY | ETF | 447.89 | 447.91 | 447.69 | 447.85 | 3427.0 |
| 2022-04-06 06:55:00 | SPY | ETF | 447.77 | 447.89 | 447.73 | 447.75 | 2357.0 |
| 2022-04-06 07:00:00 | SPY | ETF | 447.82 | 447.99 | 447.81 | 447.89 | 16264.0 |
| 2022-04-06 07:05:00 | SPY | ETF | 447.9 | 447.9 | 447.59 | 447.59 | 6544.0 |
| 2022-04-06 07:10:00 | SPY | ETF | 447.59 | 447.62 | 447.25 | 447.25 | 42592.0 |
| 2022-04-06 07:15:00 | SPY | ETF | 447.31 | 447.53 | 447.19 | 447.46 | 10225.0 |
| 2022-04-06 07:20:00 | SPY | ETF | 447.45 | 447.51 | 447.15 | 447.15 | 19226.0 |
| 2022-04-06 07:25:00 | SPY | ETF | 447.14 | 447.17 | 447.1 | 447.15 | 37399.0 |
| 2022-04-06 07:30:00 | SPY | ETF | 447.15 | 447.25 | 446.94 | 447.23 | 132538.0 |
| 2022-04-06 07:35:00 | SPY | ETF | 447.23 | 447.35 | 447.14 | 447.2 | 90778.0 |
| 2022-04-06 07:40:00 | SPY | ETF | 447.21 | 447.21 | 446.9 | 446.92 | 50218.0 |
| 2022-04-06 07:45:00 | SPY | ETF | 446.969 | 447.25 | 446.92 | 447.02 | 57891.0 |
| 2022-04-06 07:50:00 | SPY | ETF | 446.93 | 446.95 | 446.75 | 446.86 | 15500.0 |
| 2022-04-06 07:55:00 | SPY | ETF | 446.86 | 446.89 | 446.51 | 446.72 | 108296.0 |
| 2022-04-06 08:00:00 | SPY | ETF | 447.3199 | 451.55 | 446.49 | 446.54 | 103129.0 |
| 2022-04-06 08:05:00 | SPY | ETF | 446.61 | 446.75 | 446.43 | 446.75 | 19913.0 |
> showing 50 of 98,982 rows — these rows as CSV