PREVIEW / etf_5min / 2022-01-21
file: by_date/etf_5min/2022/2022-01-21.parquet size: 2.2 MB rows: 106,853
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-01-21 04:00:00 | SPY | ETF | 445.51 | 446.23 | 445.51 | 445.93 | 25917.0 |
| 2022-01-21 04:05:00 | SPY | ETF | 445.98 | 446.18 | 445.43 | 445.56 | 6226.0 |
| 2022-01-21 04:10:00 | SPY | ETF | 445.49 | 445.57 | 445.27 | 445.3 | 4801.0 |
| 2022-01-21 04:15:00 | SPY | ETF | 445.26 | 445.45 | 445.0 | 445.3 | 6024.0 |
| 2022-01-21 04:20:00 | SPY | ETF | 445.51 | 445.94 | 445.51 | 445.94 | 8976.0 |
| 2022-01-21 04:25:00 | SPY | ETF | 445.89 | 446.28 | 445.89 | 446.28 | 3177.0 |
| 2022-01-21 04:30:00 | SPY | ETF | 446.29 | 446.43 | 446.15 | 446.15 | 3000.0 |
| 2022-01-21 04:35:00 | SPY | ETF | 446.15 | 446.21 | 445.82 | 445.89 | 1350.0 |
| 2022-01-21 04:40:00 | SPY | ETF | 445.87 | 446.3 | 445.87 | 446.16 | 1498.0 |
| 2022-01-21 04:45:00 | SPY | ETF | 446.13 | 446.24 | 446.08 | 446.24 | 938.0 |
| 2022-01-21 04:50:00 | SPY | ETF | 446.26 | 446.72 | 446.25 | 446.65 | 11854.0 |
| 2022-01-21 04:55:00 | SPY | ETF | 446.65 | 446.73 | 446.56 | 446.61 | 12304.0 |
| 2022-01-21 05:00:00 | SPY | ETF | 446.59 | 446.6 | 446.25 | 446.3 | 6058.0 |
| 2022-01-21 05:05:00 | SPY | ETF | 446.44 | 446.52 | 446.17 | 446.17 | 4124.0 |
| 2022-01-21 05:10:00 | SPY | ETF | 446.28 | 446.38 | 446.09 | 446.09 | 1572.0 |
| 2022-01-21 05:15:00 | SPY | ETF | 446.15 | 446.99 | 446.15 | 446.85 | 25910.0 |
| 2022-01-21 05:20:00 | SPY | ETF | 446.82 | 447.06 | 446.76 | 446.79 | 16122.0 |
| 2022-01-21 05:25:00 | SPY | ETF | 446.76 | 446.85 | 446.68 | 446.85 | 3227.0 |
| 2022-01-21 05:30:00 | SPY | ETF | 446.71 | 446.84 | 446.63 | 446.67 | 2069.0 |
| 2022-01-21 05:35:00 | SPY | ETF | 446.63 | 446.81 | 446.63 | 446.74 | 1600.0 |
| 2022-01-21 05:40:00 | SPY | ETF | 446.81 | 446.92 | 446.75 | 446.92 | 15043.0 |
| 2022-01-21 05:45:00 | SPY | ETF | 446.93 | 446.93 | 446.59 | 446.59 | 3826.0 |
| 2022-01-21 05:50:00 | SPY | ETF | 446.8 | 446.83 | 446.57 | 446.57 | 1675.0 |
| 2022-01-21 05:55:00 | SPY | ETF | 446.57 | 446.85 | 446.5 | 446.85 | 1400.0 |
| 2022-01-21 06:00:00 | SPY | ETF | 446.78 | 446.78 | 446.4 | 446.46 | 2252.0 |
| 2022-01-21 06:05:00 | SPY | ETF | 446.53 | 446.54 | 445.48 | 445.48 | 18060.0 |
| 2022-01-21 06:10:00 | SPY | ETF | 445.63 | 445.8 | 445.45 | 445.57 | 6442.0 |
| 2022-01-21 06:15:00 | SPY | ETF | 445.33 | 445.33 | 444.83 | 444.83 | 10165.0 |
| 2022-01-21 06:20:00 | SPY | ETF | 445.05 | 445.12 | 444.5 | 444.5 | 18487.0 |
| 2022-01-21 06:25:00 | SPY | ETF | 444.5 | 444.87 | 444.5 | 444.87 | 6408.0 |
| 2022-01-21 06:30:00 | SPY | ETF | 444.91 | 444.92 | 444.44 | 444.54 | 13975.0 |
| 2022-01-21 06:35:00 | SPY | ETF | 444.52 | 445.4 | 444.5 | 445.28 | 17437.0 |
| 2022-01-21 06:40:00 | SPY | ETF | 445.24 | 445.26 | 444.82 | 445.06 | 15860.0 |
| 2022-01-21 06:45:00 | SPY | ETF | 444.86 | 444.88 | 444.5 | 444.61 | 8825.0 |
| 2022-01-21 06:50:00 | SPY | ETF | 444.71 | 444.78 | 444.57 | 444.75 | 1748.0 |
| 2022-01-21 06:55:00 | SPY | ETF | 444.87 | 445.5 | 444.87 | 445.49 | 15599.0 |
| 2022-01-21 07:00:00 | SPY | ETF | 445.39 | 445.58 | 444.68 | 444.7 | 41656.0 |
| 2022-01-21 07:05:00 | SPY | ETF | 444.76 | 444.76 | 444.08 | 444.25 | 9638.0 |
| 2022-01-21 07:10:00 | SPY | ETF | 444.25 | 444.29 | 443.75 | 444.19 | 48154.0 |
| 2022-01-21 07:15:00 | SPY | ETF | 444.25 | 444.86 | 444.25 | 444.75 | 35098.0 |
| 2022-01-21 07:20:00 | SPY | ETF | 444.83 | 445.02 | 444.81 | 444.88 | 19995.0 |
| 2022-01-21 07:25:00 | SPY | ETF | 444.87 | 444.87 | 444.53 | 444.56 | 15970.0 |
| 2022-01-21 07:30:00 | SPY | ETF | 444.5 | 444.66 | 444.13 | 444.29 | 30589.0 |
| 2022-01-21 07:35:00 | SPY | ETF | 444.34 | 444.9 | 444.25 | 444.86 | 24295.0 |
| 2022-01-21 07:40:00 | SPY | ETF | 444.79 | 444.79 | 444.29 | 444.35 | 57461.0 |
| 2022-01-21 07:45:00 | SPY | ETF | 444.32 | 444.63 | 444.23 | 444.4 | 54266.0 |
| 2022-01-21 07:50:00 | SPY | ETF | 444.35 | 444.63 | 444.02 | 444.02 | 22195.0 |
| 2022-01-21 07:55:00 | SPY | ETF | 444.09 | 444.4 | 443.83 | 444.36 | 18098.0 |
| 2022-01-21 08:00:00 | SPY | ETF | 444.88 | 447.115 | 443.88 | 444.13 | 243844.0 |
| 2022-01-21 08:05:00 | SPY | ETF | 444.14 | 445.88 | 444.11 | 444.47 | 47427.0 |
> showing 50 of 106,853 rows — these rows as CSV