PREVIEW / etf_5min / 2020-10-02
file: by_date/etf_5min/2020/2020-10-02.parquet size: 1.6 MB rows: 74,931
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 |
|---|---|---|---|---|---|---|---|
| 2020-10-02 04:00:00 | SPY | ETF | 332.89 | 332.94 | 332.52 | 332.86 | 21983.0 |
| 2020-10-02 04:05:00 | SPY | ETF | 332.94 | 333.0 | 332.59 | 332.59 | 6434.0 |
| 2020-10-02 04:10:00 | SPY | ETF | 332.5 | 332.5 | 332.16 | 332.31 | 13798.0 |
| 2020-10-02 04:15:00 | SPY | ETF | 332.42 | 332.66 | 332.42 | 332.66 | 11524.0 |
| 2020-10-02 04:20:00 | SPY | ETF | 332.79 | 332.87 | 332.65 | 332.87 | 2202.0 |
| 2020-10-02 04:25:00 | SPY | ETF | 332.94 | 333.25 | 332.94 | 333.22 | 6674.0 |
| 2020-10-02 04:30:00 | SPY | ETF | 332.62 | 332.89 | 332.53 | 332.89 | 2137.0 |
| 2020-10-02 04:35:00 | SPY | ETF | 332.9 | 333.1 | 332.85 | 332.9 | 4493.0 |
| 2020-10-02 04:40:00 | SPY | ETF | 332.77 | 333.08 | 332.77 | 332.85 | 3218.0 |
| 2020-10-02 04:45:00 | SPY | ETF | 332.94 | 332.94 | 332.87 | 332.94 | 1830.0 |
| 2020-10-02 04:50:00 | SPY | ETF | 332.73 | 332.98 | 332.71 | 332.98 | 3057.0 |
| 2020-10-02 04:55:00 | SPY | ETF | 333.08 | 333.08 | 332.83 | 332.85 | 9110.0 |
| 2020-10-02 05:00:00 | SPY | ETF | 332.83 | 333.05 | 332.77 | 333.04 | 1792.0 |
| 2020-10-02 05:05:00 | SPY | ETF | 333.12 | 333.31 | 333.12 | 333.17 | 7786.0 |
| 2020-10-02 05:10:00 | SPY | ETF | 333.25 | 333.44 | 333.21 | 333.22 | 9501.0 |
| 2020-10-02 05:15:00 | SPY | ETF | 333.23 | 333.34 | 333.09 | 333.09 | 8532.0 |
| 2020-10-02 05:20:00 | SPY | ETF | 333.06 | 333.27 | 332.58 | 332.58 | 6339.0 |
| 2020-10-02 05:25:00 | SPY | ETF | 332.47 | 332.57 | 332.2 | 332.23 | 8382.0 |
| 2020-10-02 05:30:00 | SPY | ETF | 332.3 | 332.34 | 332.0 | 332.05 | 54249.0 |
| 2020-10-02 05:35:00 | SPY | ETF | 331.95 | 332.1 | 331.58 | 331.69 | 38932.0 |
| 2020-10-02 05:40:00 | SPY | ETF | 331.6 | 331.6 | 331.05 | 331.15 | 19958.0 |
| 2020-10-02 05:45:00 | SPY | ETF | 331.19 | 331.75 | 331.17 | 331.6 | 17846.0 |
| 2020-10-02 05:50:00 | SPY | ETF | 331.58 | 331.79 | 331.47 | 331.79 | 4277.0 |
| 2020-10-02 05:55:00 | SPY | ETF | 331.78 | 331.78 | 331.25 | 331.34 | 12747.0 |
| 2020-10-02 06:00:00 | SPY | ETF | 331.3 | 331.3 | 330.89 | 331.14 | 21633.0 |
| 2020-10-02 06:05:00 | SPY | ETF | 331.13 | 331.15 | 330.87 | 331.0 | 38882.0 |
| 2020-10-02 06:10:00 | SPY | ETF | 331.0 | 331.17 | 330.76 | 330.87 | 39287.0 |
| 2020-10-02 06:15:00 | SPY | ETF | 330.8 | 330.87 | 330.49 | 330.59 | 33688.0 |
| 2020-10-02 06:20:00 | SPY | ETF | 330.63 | 330.8 | 330.47 | 330.75 | 34874.0 |
| 2020-10-02 06:25:00 | SPY | ETF | 330.73 | 331.58 | 330.73 | 331.39 | 177286.0 |
| 2020-10-02 06:30:00 | SPY | ETF | 331.43 | 331.74 | 331.29 | 331.69 | 17090.0 |
| 2020-10-02 06:35:00 | SPY | ETF | 331.49 | 331.97 | 331.49 | 331.97 | 39096.0 |
| 2020-10-02 06:40:00 | SPY | ETF | 331.99 | 332.24 | 331.93 | 332.24 | 81671.0 |
| 2020-10-02 06:45:00 | SPY | ETF | 332.18 | 332.24 | 331.88 | 331.98 | 35565.0 |
| 2020-10-02 06:50:00 | SPY | ETF | 331.93 | 332.32 | 331.92 | 332.24 | 47802.0 |
| 2020-10-02 06:55:00 | SPY | ETF | 332.26 | 332.31 | 332.1 | 332.17 | 16057.0 |
| 2020-10-02 07:00:00 | SPY | ETF | 332.15 | 332.46 | 332.09 | 332.43 | 111964.0 |
| 2020-10-02 07:05:00 | SPY | ETF | 332.4 | 332.52 | 331.9 | 331.96 | 181212.0 |
| 2020-10-02 07:10:00 | SPY | ETF | 331.97 | 332.23 | 331.94 | 332.07 | 193011.0 |
| 2020-10-02 07:15:00 | SPY | ETF | 332.04 | 332.12 | 331.76 | 331.84 | 29095.0 |
| 2020-10-02 07:20:00 | SPY | ETF | 331.85 | 331.94 | 331.45 | 331.45 | 125524.0 |
| 2020-10-02 07:25:00 | SPY | ETF | 331.44 | 331.58 | 331.36 | 331.55 | 76419.0 |
| 2020-10-02 07:30:00 | SPY | ETF | 331.57 | 331.75 | 331.4 | 331.5 | 33412.0 |
| 2020-10-02 07:35:00 | SPY | ETF | 331.52 | 331.61 | 331.4 | 331.58 | 17591.0 |
| 2020-10-02 07:40:00 | SPY | ETF | 331.55 | 331.55 | 331.2 | 331.22 | 38004.0 |
| 2020-10-02 07:45:00 | SPY | ETF | 331.21 | 331.54 | 331.2 | 331.54 | 33770.0 |
| 2020-10-02 07:50:00 | SPY | ETF | 331.55 | 331.97 | 331.2 | 331.67 | 76096.0 |
| 2020-10-02 07:55:00 | SPY | ETF | 331.62 | 331.79 | 331.13 | 331.36 | 141001.0 |
| 2020-10-02 08:00:00 | SPY | ETF | 331.38 | 336.4 | 330.67 | 331.35 | 157298.0 |
| 2020-10-02 08:05:00 | SPY | ETF | 331.35 | 332.11 | 331.32 | 332.07 | 167941.0 |
> showing 50 of 74,931 rows — these rows as CSV