PREVIEW / etf_5min / 2020-02-27
file: by_date/etf_5min/2020/2020-02-27.parquet size: 2.0 MB rows: 88,128
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-02-27 04:00:00 | SPY | ETF | 309.38 | 310.19 | 309.38 | 309.85 | 18177.0 |
| 2020-02-27 04:05:00 | SPY | ETF | 309.95 | 309.97 | 309.46 | 309.5 | 14482.0 |
| 2020-02-27 04:10:00 | SPY | ETF | 309.48 | 309.7 | 309.29 | 309.6 | 8929.0 |
| 2020-02-27 04:15:00 | SPY | ETF | 309.58 | 309.75 | 309.46 | 309.5 | 3949.0 |
| 2020-02-27 04:20:00 | SPY | ETF | 309.57 | 309.97 | 309.3 | 309.92 | 19593.0 |
| 2020-02-27 04:25:00 | SPY | ETF | 309.86 | 310.16 | 309.86 | 310.16 | 9716.0 |
| 2020-02-27 04:30:00 | SPY | ETF | 310.07 | 310.41 | 310.0 | 310.41 | 3588.0 |
| 2020-02-27 04:35:00 | SPY | ETF | 310.01 | 310.01 | 309.4 | 309.53 | 10117.0 |
| 2020-02-27 04:40:00 | SPY | ETF | 309.84 | 309.84 | 309.6 | 309.61 | 1982.0 |
| 2020-02-27 04:45:00 | SPY | ETF | 309.55 | 309.55 | 309.1 | 309.51 | 17255.0 |
| 2020-02-27 04:50:00 | SPY | ETF | 309.49 | 309.49 | 309.21 | 309.21 | 3413.0 |
| 2020-02-27 04:55:00 | SPY | ETF | 309.12 | 309.17 | 308.93 | 309.07 | 6624.0 |
| 2020-02-27 05:00:00 | SPY | ETF | 309.23 | 309.5 | 309.23 | 309.41 | 6414.0 |
| 2020-02-27 05:05:00 | SPY | ETF | 309.29 | 309.35 | 309.05 | 309.32 | 3346.0 |
| 2020-02-27 05:10:00 | SPY | ETF | 309.33 | 309.48 | 309.16 | 309.42 | 4400.0 |
| 2020-02-27 05:15:00 | SPY | ETF | 309.35 | 309.35 | 309.0 | 309.27 | 10130.0 |
| 2020-02-27 05:20:00 | SPY | ETF | 309.24 | 309.24 | 309.05 | 309.22 | 13721.0 |
| 2020-02-27 05:25:00 | SPY | ETF | 309.12 | 309.24 | 308.68 | 308.74 | 6389.0 |
| 2020-02-27 05:30:00 | SPY | ETF | 308.7 | 309.16 | 308.7 | 309.16 | 13765.0 |
| 2020-02-27 05:35:00 | SPY | ETF | 309.17 | 309.28 | 309.11 | 309.2 | 15051.0 |
| 2020-02-27 05:40:00 | SPY | ETF | 309.2 | 309.5 | 309.16 | 309.26 | 12032.0 |
| 2020-02-27 05:45:00 | SPY | ETF | 308.99 | 309.08 | 308.63 | 308.69 | 6802.0 |
| 2020-02-27 05:50:00 | SPY | ETF | 308.69 | 308.7 | 308.14 | 308.3 | 33194.0 |
| 2020-02-27 05:55:00 | SPY | ETF | 308.34 | 308.34 | 307.85 | 307.85 | 14294.0 |
| 2020-02-27 06:00:00 | SPY | ETF | 307.9 | 308.22 | 307.9 | 307.97 | 14957.0 |
| 2020-02-27 06:05:00 | SPY | ETF | 307.94 | 307.94 | 307.64 | 307.65 | 12409.0 |
| 2020-02-27 06:10:00 | SPY | ETF | 307.6 | 308.16 | 307.6 | 308.11 | 19453.0 |
| 2020-02-27 06:15:00 | SPY | ETF | 308.13 | 308.52 | 308.06 | 308.3 | 20800.0 |
| 2020-02-27 06:20:00 | SPY | ETF | 308.39 | 308.39 | 308.2 | 308.36 | 12299.0 |
| 2020-02-27 06:25:00 | SPY | ETF | 308.3 | 308.63 | 308.17 | 308.56 | 37446.0 |
| 2020-02-27 06:30:00 | SPY | ETF | 308.63 | 308.7 | 308.34 | 308.35 | 21363.0 |
| 2020-02-27 06:35:00 | SPY | ETF | 308.47 | 308.66 | 307.96 | 308.66 | 31686.0 |
| 2020-02-27 06:40:00 | SPY | ETF | 308.52 | 308.75 | 308.47 | 308.75 | 28947.0 |
| 2020-02-27 06:45:00 | SPY | ETF | 308.72 | 308.79 | 308.5 | 308.5 | 33057.0 |
| 2020-02-27 06:50:00 | SPY | ETF | 308.51 | 308.6 | 308.39 | 308.5 | 22527.0 |
| 2020-02-27 06:55:00 | SPY | ETF | 308.48 | 308.48 | 307.84 | 307.98 | 38624.0 |
| 2020-02-27 07:00:00 | SPY | ETF | 307.98 | 308.25 | 307.85 | 308.07 | 111136.0 |
| 2020-02-27 07:05:00 | SPY | ETF | 308.05 | 308.47 | 308.0 | 308.17 | 58741.0 |
| 2020-02-27 07:10:00 | SPY | ETF | 308.2 | 308.38 | 308.11 | 308.28 | 61812.0 |
| 2020-02-27 07:15:00 | SPY | ETF | 308.24 | 308.33 | 307.92 | 308.07 | 78260.0 |
| 2020-02-27 07:20:00 | SPY | ETF | 308.07 | 308.15 | 307.48 | 307.54 | 82869.0 |
| 2020-02-27 07:25:00 | SPY | ETF | 307.5 | 307.68 | 306.92 | 306.97 | 138261.0 |
| 2020-02-27 07:30:00 | SPY | ETF | 306.9 | 307.63 | 306.65 | 307.35 | 269952.0 |
| 2020-02-27 07:35:00 | SPY | ETF | 307.35 | 307.35 | 306.96 | 306.97 | 58842.0 |
| 2020-02-27 07:40:00 | SPY | ETF | 307.05 | 307.1 | 306.8 | 306.83 | 70244.0 |
| 2020-02-27 07:45:00 | SPY | ETF | 306.8 | 307.2 | 306.72 | 307.19 | 97986.0 |
| 2020-02-27 07:50:00 | SPY | ETF | 307.2 | 307.49 | 306.89 | 306.96 | 205395.0 |
| 2020-02-27 07:55:00 | SPY | ETF | 306.93 | 307.13 | 306.72 | 306.76 | 107362.0 |
| 2020-02-27 08:00:00 | SPY | ETF | 307.95 | 309.78 | 306.23 | 307.2 | 245216.0 |
| 2020-02-27 08:05:00 | SPY | ETF | 307.15 | 307.15 | 306.8 | 306.86 | 66931.0 |
> showing 50 of 88,128 rows — these rows as CSV