PREVIEW / etf_5min / 2020-06-23
file: by_date/etf_5min/2020/2020-06-23.parquet size: 1.6 MB rows: 76,006
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-06-23 04:00:00 | SPY | ETF | 313.37 | 313.4 | 313.13 | 313.2 | 12269.0 |
| 2020-06-23 04:05:00 | SPY | ETF | 313.39 | 313.51 | 313.25 | 313.3 | 3797.0 |
| 2020-06-23 04:10:00 | SPY | ETF | 313.33 | 313.47 | 313.01 | 313.13 | 2636.0 |
| 2020-06-23 04:15:00 | SPY | ETF | 313.06 | 313.21 | 313.06 | 313.18 | 2851.0 |
| 2020-06-23 04:20:00 | SPY | ETF | 313.07 | 313.07 | 312.97 | 312.97 | 2550.0 |
| 2020-06-23 04:25:00 | SPY | ETF | 312.96 | 313.26 | 312.96 | 313.26 | 4637.0 |
| 2020-06-23 04:30:00 | SPY | ETF | 313.29 | 313.33 | 313.04 | 313.11 | 1103.0 |
| 2020-06-23 04:35:00 | SPY | ETF | 313.12 | 313.18 | 313.02 | 313.02 | 3150.0 |
| 2020-06-23 04:40:00 | SPY | ETF | 312.97 | 313.18 | 312.97 | 313.16 | 1011.0 |
| 2020-06-23 04:45:00 | SPY | ETF | 312.82 | 312.82 | 312.75 | 312.82 | 1360.0 |
| 2020-06-23 04:50:00 | SPY | ETF | 312.88 | 313.01 | 312.88 | 313.01 | 302.0 |
| 2020-06-23 04:55:00 | SPY | ETF | 312.95 | 312.95 | 312.79 | 312.89 | 3660.0 |
| 2020-06-23 05:00:00 | SPY | ETF | 312.74 | 312.77 | 312.66 | 312.77 | 1415.0 |
| 2020-06-23 05:05:00 | SPY | ETF | 312.81 | 312.89 | 312.71 | 312.89 | 548.0 |
| 2020-06-23 05:10:00 | SPY | ETF | 312.75 | 312.8 | 312.66 | 312.66 | 2475.0 |
| 2020-06-23 05:15:00 | SPY | ETF | 312.75 | 312.75 | 312.75 | 312.75 | 408.0 |
| 2020-06-23 05:20:00 | SPY | ETF | 312.83 | 312.88 | 312.82 | 312.88 | 630.0 |
| 2020-06-23 05:25:00 | SPY | ETF | 312.85 | 312.85 | 312.85 | 312.85 | 2275.0 |
| 2020-06-23 05:30:00 | SPY | ETF | 313.0 | 313.13 | 313.0 | 313.13 | 3314.0 |
| 2020-06-23 05:35:00 | SPY | ETF | 313.19 | 313.38 | 313.16 | 313.35 | 7790.0 |
| 2020-06-23 05:40:00 | SPY | ETF | 313.34 | 313.5 | 313.34 | 313.5 | 2365.0 |
| 2020-06-23 05:45:00 | SPY | ETF | 313.41 | 313.51 | 313.4 | 313.51 | 2065.0 |
| 2020-06-23 05:50:00 | SPY | ETF | 313.5 | 313.5 | 313.39 | 313.42 | 4563.0 |
| 2020-06-23 05:55:00 | SPY | ETF | 313.3 | 313.36 | 313.2 | 313.22 | 3290.0 |
| 2020-06-23 06:00:00 | SPY | ETF | 313.31 | 313.31 | 313.15 | 313.26 | 1960.0 |
| 2020-06-23 06:05:00 | SPY | ETF | 313.26 | 313.46 | 313.25 | 313.46 | 3491.0 |
| 2020-06-23 06:10:00 | SPY | ETF | 313.41 | 313.81 | 313.41 | 313.81 | 2285.0 |
| 2020-06-23 06:15:00 | SPY | ETF | 313.84 | 313.96 | 313.74 | 313.86 | 6407.0 |
| 2020-06-23 06:20:00 | SPY | ETF | 313.83 | 313.88 | 313.66 | 313.66 | 6495.0 |
| 2020-06-23 06:25:00 | SPY | ETF | 313.69 | 313.77 | 313.65 | 313.73 | 1911.0 |
| 2020-06-23 06:30:00 | SPY | ETF | 313.75 | 313.78 | 313.58 | 313.61 | 9663.0 |
| 2020-06-23 06:35:00 | SPY | ETF | 313.58 | 313.63 | 313.56 | 313.61 | 21511.0 |
| 2020-06-23 06:40:00 | SPY | ETF | 313.61 | 313.61 | 313.51 | 313.57 | 1805.0 |
| 2020-06-23 06:45:00 | SPY | ETF | 313.53 | 313.63 | 313.5 | 313.57 | 1625.0 |
| 2020-06-23 06:50:00 | SPY | ETF | 313.51 | 313.8 | 313.36 | 313.75 | 15203.0 |
| 2020-06-23 06:55:00 | SPY | ETF | 313.72 | 313.72 | 313.47 | 313.47 | 9310.0 |
| 2020-06-23 07:00:00 | SPY | ETF | 313.61 | 313.63 | 313.19 | 313.25 | 41553.0 |
| 2020-06-23 07:05:00 | SPY | ETF | 313.21 | 313.3 | 313.2 | 313.24 | 9364.0 |
| 2020-06-23 07:10:00 | SPY | ETF | 313.21 | 313.36 | 313.2 | 313.3 | 8712.0 |
| 2020-06-23 07:15:00 | SPY | ETF | 313.3 | 313.62 | 313.28 | 313.59 | 21324.0 |
| 2020-06-23 07:20:00 | SPY | ETF | 313.61 | 313.72 | 313.6 | 313.72 | 16004.0 |
| 2020-06-23 07:25:00 | SPY | ETF | 313.78 | 313.84 | 313.7 | 313.7 | 19969.0 |
| 2020-06-23 07:30:00 | SPY | ETF | 313.72 | 313.77 | 313.67 | 313.73 | 31103.0 |
| 2020-06-23 07:35:00 | SPY | ETF | 313.73 | 313.86 | 313.72 | 313.86 | 26625.0 |
| 2020-06-23 07:40:00 | SPY | ETF | 313.83 | 313.9 | 313.77 | 313.83 | 14616.0 |
| 2020-06-23 07:45:00 | SPY | ETF | 313.77 | 313.81 | 313.72 | 313.78 | 13668.0 |
| 2020-06-23 07:50:00 | SPY | ETF | 313.79 | 313.81 | 313.62 | 313.73 | 12240.0 |
| 2020-06-23 07:55:00 | SPY | ETF | 313.77 | 313.79 | 313.69 | 313.79 | 9905.0 |
| 2020-06-23 08:00:00 | SPY | ETF | 313.3398 | 313.88 | 309.91 | 313.75 | 67928.0 |
| 2020-06-23 08:05:00 | SPY | ETF | 313.72 | 314.23 | 313.72 | 314.19 | 50825.0 |
> showing 50 of 76,006 rows — these rows as CSV