PREVIEW / etf_5min / 2022-02-07
file: by_date/etf_5min/2022/2022-02-07.parquet size: 1.9 MB rows: 92,660
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-02-07 04:00:00 | SPY | ETF | 448.37 | 448.8 | 448.37 | 448.44 | 2419.0 |
| 2022-02-07 04:05:00 | SPY | ETF | 448.41 | 448.66 | 448.38 | 448.41 | 1576.0 |
| 2022-02-07 04:10:00 | SPY | ETF | 448.22 | 448.24 | 447.79 | 447.79 | 1900.0 |
| 2022-02-07 04:15:00 | SPY | ETF | 448.43 | 448.43 | 448.43 | 448.43 | 144.0 |
| 2022-02-07 04:20:00 | SPY | ETF | 448.2 | 448.2 | 448.14 | 448.14 | 711.0 |
| 2022-02-07 04:25:00 | SPY | ETF | 447.86 | 448.08 | 447.86 | 448.08 | 1235.0 |
| 2022-02-07 04:30:00 | SPY | ETF | 448.19 | 448.19 | 447.85 | 447.85 | 431.0 |
| 2022-02-07 04:35:00 | SPY | ETF | 447.67 | 447.86 | 447.67 | 447.86 | 700.0 |
| 2022-02-07 04:40:00 | SPY | ETF | 447.5 | 447.56 | 447.5 | 447.5 | 1700.0 |
| 2022-02-07 04:45:00 | SPY | ETF | 447.36 | 447.48 | 447.13 | 447.13 | 2100.0 |
| 2022-02-07 04:50:00 | SPY | ETF | 447.0 | 447.48 | 447.0 | 447.48 | 2498.0 |
| 2022-02-07 04:55:00 | SPY | ETF | 447.55 | 447.62 | 447.55 | 447.55 | 2900.0 |
| 2022-02-07 05:00:00 | SPY | ETF | 448.04 | 448.04 | 448.04 | 448.04 | 500.0 |
| 2022-02-07 05:05:00 | SPY | ETF | 447.8 | 447.8 | 447.73 | 447.73 | 1991.0 |
| 2022-02-07 05:10:00 | SPY | ETF | 448.06 | 448.06 | 447.99 | 448.01 | 1500.0 |
| 2022-02-07 05:15:00 | SPY | ETF | 448.14 | 448.15 | 448.14 | 448.15 | 500.0 |
| 2022-02-07 05:20:00 | SPY | ETF | 447.76 | 447.93 | 447.7 | 447.8 | 4600.0 |
| 2022-02-07 05:25:00 | SPY | ETF | 447.81 | 447.91 | 447.81 | 447.91 | 250.0 |
| 2022-02-07 05:30:00 | SPY | ETF | 448.07 | 448.07 | 447.73 | 447.73 | 300.0 |
| 2022-02-07 05:35:00 | SPY | ETF | 447.7 | 447.92 | 447.66 | 447.8 | 12735.0 |
| 2022-02-07 05:40:00 | SPY | ETF | 447.79 | 447.9 | 447.75 | 447.75 | 40100.0 |
| 2022-02-07 05:45:00 | SPY | ETF | 448.15 | 448.25 | 448.15 | 448.2 | 3536.0 |
| 2022-02-07 05:50:00 | SPY | ETF | 448.01 | 448.03 | 448.0 | 448.03 | 6690.0 |
| 2022-02-07 05:55:00 | SPY | ETF | 447.71 | 447.71 | 447.53 | 447.53 | 1115.0 |
| 2022-02-07 06:00:00 | SPY | ETF | 447.59 | 447.64 | 447.5 | 447.5 | 1400.0 |
| 2022-02-07 06:05:00 | SPY | ETF | 447.63 | 447.63 | 447.33 | 447.63 | 4600.0 |
| 2022-02-07 06:10:00 | SPY | ETF | 447.8 | 447.8 | 447.8 | 447.8 | 100.0 |
| 2022-02-07 06:15:00 | SPY | ETF | 447.94 | 447.98 | 447.83 | 447.91 | 1658.0 |
| 2022-02-07 06:20:00 | SPY | ETF | 447.97 | 448.08 | 447.97 | 448.0 | 2115.0 |
| 2022-02-07 06:25:00 | SPY | ETF | 448.13 | 448.23 | 448.13 | 448.18 | 2932.0 |
| 2022-02-07 06:30:00 | SPY | ETF | 448.26 | 448.4 | 448.26 | 448.33 | 1165.0 |
| 2022-02-07 06:35:00 | SPY | ETF | 448.38 | 448.62 | 448.29 | 448.5 | 3050.0 |
| 2022-02-07 06:40:00 | SPY | ETF | 448.21 | 448.21 | 448.01 | 448.03 | 15746.0 |
| 2022-02-07 06:45:00 | SPY | ETF | 448.03 | 448.11 | 448.03 | 448.03 | 46304.0 |
| 2022-02-07 06:50:00 | SPY | ETF | 448.21 | 448.21 | 448.01 | 448.21 | 1388.0 |
| 2022-02-07 06:55:00 | SPY | ETF | 448.24 | 448.5 | 448.24 | 448.5 | 1400.0 |
| 2022-02-07 07:00:00 | SPY | ETF | 448.34 | 448.81 | 448.34 | 448.7 | 11369.0 |
| 2022-02-07 07:05:00 | SPY | ETF | 448.84 | 449.01 | 448.84 | 448.96 | 23978.0 |
| 2022-02-07 07:10:00 | SPY | ETF | 449.0 | 449.4 | 449.0 | 449.35 | 7690.0 |
| 2022-02-07 07:15:00 | SPY | ETF | 449.42 | 449.74 | 449.39 | 449.39 | 95804.0 |
| 2022-02-07 07:20:00 | SPY | ETF | 449.35 | 449.36 | 449.1 | 449.15 | 9099.0 |
| 2022-02-07 07:25:00 | SPY | ETF | 449.1 | 449.14 | 448.97 | 449.14 | 7828.0 |
| 2022-02-07 07:30:00 | SPY | ETF | 449.14 | 449.24 | 449.12 | 449.12 | 4423.0 |
| 2022-02-07 07:35:00 | SPY | ETF | 449.1 | 449.23 | 449.07 | 449.07 | 4985.0 |
| 2022-02-07 07:40:00 | SPY | ETF | 449.19 | 449.27 | 449.16 | 449.27 | 5641.0 |
| 2022-02-07 07:45:00 | SPY | ETF | 449.31 | 449.55 | 449.31 | 449.53 | 10556.0 |
| 2022-02-07 07:50:00 | SPY | ETF | 449.54 | 449.82 | 449.5 | 449.5 | 22117.0 |
| 2022-02-07 07:55:00 | SPY | ETF | 449.53 | 449.76 | 449.5 | 449.52 | 15453.0 |
| 2022-02-07 08:00:00 | SPY | ETF | 449.5 | 449.91 | 447.25 | 449.036 | 46316.0 |
| 2022-02-07 08:05:00 | SPY | ETF | 449.9 | 450.27 | 449.78 | 450.11 | 49304.0 |
> showing 50 of 92,660 rows — these rows as CSV