PREVIEW / etf_5min / 2020-06-22
file: by_date/etf_5min/2020/2020-06-22.parquet size: 1.6 MB rows: 74,330
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-22 04:00:00 | SPY | ETF | 308.5 | 308.64 | 308.3 | 308.3 | 15524.0 |
| 2020-06-22 04:05:00 | SPY | ETF | 308.28 | 308.55 | 308.26 | 308.43 | 20481.0 |
| 2020-06-22 04:10:00 | SPY | ETF | 308.56 | 308.59 | 308.03 | 308.05 | 10337.0 |
| 2020-06-22 04:15:00 | SPY | ETF | 308.05 | 308.35 | 308.05 | 308.25 | 1807.0 |
| 2020-06-22 04:20:00 | SPY | ETF | 308.25 | 308.41 | 308.2 | 308.25 | 3026.0 |
| 2020-06-22 04:25:00 | SPY | ETF | 308.2 | 308.28 | 308.12 | 308.27 | 3070.0 |
| 2020-06-22 04:30:00 | SPY | ETF | 308.22 | 308.4 | 308.22 | 308.35 | 4477.0 |
| 2020-06-22 04:35:00 | SPY | ETF | 308.35 | 309.0 | 308.35 | 308.96 | 35342.0 |
| 2020-06-22 04:40:00 | SPY | ETF | 308.98 | 309.25 | 308.98 | 309.25 | 6673.0 |
| 2020-06-22 04:45:00 | SPY | ETF | 309.19 | 309.36 | 309.19 | 309.36 | 6840.0 |
| 2020-06-22 04:50:00 | SPY | ETF | 309.22 | 309.3 | 309.16 | 309.27 | 2046.0 |
| 2020-06-22 04:55:00 | SPY | ETF | 309.34 | 309.34 | 309.06 | 309.15 | 5757.0 |
| 2020-06-22 05:00:00 | SPY | ETF | 309.27 | 309.77 | 309.27 | 309.66 | 16024.0 |
| 2020-06-22 05:05:00 | SPY | ETF | 309.72 | 309.79 | 309.55 | 309.59 | 10635.0 |
| 2020-06-22 05:10:00 | SPY | ETF | 309.53 | 309.53 | 309.34 | 309.44 | 9905.0 |
| 2020-06-22 05:15:00 | SPY | ETF | 309.45 | 309.52 | 309.34 | 309.52 | 2520.0 |
| 2020-06-22 05:20:00 | SPY | ETF | 309.42 | 309.65 | 309.42 | 309.65 | 7135.0 |
| 2020-06-22 05:25:00 | SPY | ETF | 309.57 | 309.68 | 309.45 | 309.68 | 5779.0 |
| 2020-06-22 05:30:00 | SPY | ETF | 309.51 | 309.59 | 309.16 | 309.16 | 4446.0 |
| 2020-06-22 05:35:00 | SPY | ETF | 309.11 | 309.5 | 309.09 | 309.22 | 11790.0 |
| 2020-06-22 05:40:00 | SPY | ETF | 309.24 | 309.27 | 309.06 | 309.21 | 4860.0 |
| 2020-06-22 05:45:00 | SPY | ETF | 309.11 | 309.26 | 309.11 | 309.23 | 4632.0 |
| 2020-06-22 05:50:00 | SPY | ETF | 309.21 | 309.21 | 309.08 | 309.08 | 4960.0 |
| 2020-06-22 05:55:00 | SPY | ETF | 309.02 | 309.05 | 308.95 | 309.01 | 3495.0 |
| 2020-06-22 06:00:00 | SPY | ETF | 308.96 | 308.96 | 308.76 | 308.88 | 5358.0 |
| 2020-06-22 06:05:00 | SPY | ETF | 308.94 | 308.99 | 308.86 | 308.91 | 9195.0 |
| 2020-06-22 06:10:00 | SPY | ETF | 308.88 | 308.91 | 308.58 | 308.68 | 6800.0 |
| 2020-06-22 06:15:00 | SPY | ETF | 308.68 | 308.71 | 308.6 | 308.6 | 2226.0 |
| 2020-06-22 06:20:00 | SPY | ETF | 308.53 | 308.62 | 308.44 | 308.46 | 3357.0 |
| 2020-06-22 06:25:00 | SPY | ETF | 308.48 | 308.51 | 308.44 | 308.48 | 4468.0 |
| 2020-06-22 06:30:00 | SPY | ETF | 308.56 | 308.56 | 308.45 | 308.56 | 17170.0 |
| 2020-06-22 06:35:00 | SPY | ETF | 308.58 | 308.62 | 308.55 | 308.62 | 2605.0 |
| 2020-06-22 06:40:00 | SPY | ETF | 308.62 | 308.68 | 308.6 | 308.68 | 2900.0 |
| 2020-06-22 06:45:00 | SPY | ETF | 308.74 | 308.74 | 308.55 | 308.55 | 1795.0 |
| 2020-06-22 06:50:00 | SPY | ETF | 308.6 | 308.66 | 308.33 | 308.33 | 30064.0 |
| 2020-06-22 06:55:00 | SPY | ETF | 308.44 | 308.44 | 308.22 | 308.44 | 11441.0 |
| 2020-06-22 07:00:00 | SPY | ETF | 308.43 | 308.48 | 307.89 | 307.95 | 53254.0 |
| 2020-06-22 07:05:00 | SPY | ETF | 307.95 | 307.95 | 307.61 | 307.7 | 26040.0 |
| 2020-06-22 07:10:00 | SPY | ETF | 307.7 | 307.8 | 307.68 | 307.73 | 13743.0 |
| 2020-06-22 07:15:00 | SPY | ETF | 307.73 | 308.01 | 307.68 | 307.73 | 72452.0 |
| 2020-06-22 07:20:00 | SPY | ETF | 307.75 | 307.75 | 307.55 | 307.7 | 22589.0 |
| 2020-06-22 07:25:00 | SPY | ETF | 307.7 | 307.83 | 307.6 | 307.73 | 24202.0 |
| 2020-06-22 07:30:00 | SPY | ETF | 307.74 | 307.8 | 307.69 | 307.78 | 30033.0 |
| 2020-06-22 07:35:00 | SPY | ETF | 307.78 | 307.82 | 307.77 | 307.82 | 12181.0 |
| 2020-06-22 07:40:00 | SPY | ETF | 307.86 | 308.07 | 307.79 | 307.87 | 33538.0 |
| 2020-06-22 07:45:00 | SPY | ETF | 307.87 | 308.16 | 307.87 | 308.09 | 46483.0 |
| 2020-06-22 07:50:00 | SPY | ETF | 308.09 | 308.23 | 308.06 | 308.14 | 27867.0 |
| 2020-06-22 07:55:00 | SPY | ETF | 308.14 | 308.46 | 308.05 | 308.46 | 32235.0 |
| 2020-06-22 08:00:00 | SPY | ETF | 308.46 | 309.45 | 306.81 | 307.04 | 154863.0 |
| 2020-06-22 08:05:00 | SPY | ETF | 308.53 | 308.6 | 306.1 | 308.47 | 78927.0 |
> showing 50 of 74,330 rows — these rows as CSV