PREVIEW / etf_5min / 2021-06-17
file: by_date/etf_5min/2021/2021-06-17.parquet size: 1.8 MB rows: 85,593
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 |
|---|---|---|---|---|---|---|---|
| 2021-06-17 04:00:00 | SPY | ETF | 420.26 | 420.86 | 420.26 | 420.86 | 2299.0 |
| 2021-06-17 04:05:00 | SPY | ETF | 420.83 | 420.83 | 420.73 | 420.73 | 700.0 |
| 2021-06-17 04:10:00 | SPY | ETF | 420.75 | 420.75 | 420.67 | 420.7 | 914.0 |
| 2021-06-17 04:15:00 | SPY | ETF | 420.42 | 420.44 | 420.42 | 420.44 | 200.0 |
| 2021-06-17 04:20:00 | SPY | ETF | 420.34 | 420.34 | 420.22 | 420.22 | 788.0 |
| 2021-06-17 04:25:00 | SPY | ETF | 420.51 | 420.57 | 420.49 | 420.57 | 3100.0 |
| 2021-06-17 04:30:00 | SPY | ETF | 420.62 | 420.63 | 420.62 | 420.63 | 1000.0 |
| 2021-06-17 04:35:00 | SPY | ETF | 420.45 | 420.45 | 420.32 | 420.32 | 598.0 |
| 2021-06-17 04:40:00 | SPY | ETF | 420.24 | 420.24 | 420.24 | 420.24 | 100.0 |
| 2021-06-17 04:45:00 | SPY | ETF | 419.91 | 420.04 | 419.91 | 420.04 | 1400.0 |
| 2021-06-17 04:50:00 | SPY | ETF | 420.1 | 420.1 | 420.1 | 420.1 | 100.0 |
| 2021-06-17 05:00:00 | SPY | ETF | 420.12 | 420.39 | 420.12 | 420.37 | 500.0 |
| 2021-06-17 05:05:00 | SPY | ETF | 420.4 | 420.5 | 420.4 | 420.5 | 680.0 |
| 2021-06-17 05:10:00 | SPY | ETF | 420.43 | 420.43 | 420.43 | 420.43 | 700.0 |
| 2021-06-17 05:15:00 | SPY | ETF | 420.48 | 420.73 | 420.48 | 420.72 | 3281.0 |
| 2021-06-17 05:20:00 | SPY | ETF | 420.7 | 420.7 | 420.6 | 420.62 | 3998.0 |
| 2021-06-17 05:25:00 | SPY | ETF | 420.65 | 420.65 | 420.56 | 420.58 | 707.0 |
| 2021-06-17 05:30:00 | SPY | ETF | 420.59 | 420.59 | 420.42 | 420.42 | 1500.0 |
| 2021-06-17 05:35:00 | SPY | ETF | 420.55 | 420.55 | 420.55 | 420.55 | 400.0 |
| 2021-06-17 05:40:00 | SPY | ETF | 420.59 | 420.64 | 420.59 | 420.6 | 800.0 |
| 2021-06-17 05:45:00 | SPY | ETF | 420.57 | 420.65 | 420.57 | 420.65 | 1750.0 |
| 2021-06-17 05:50:00 | SPY | ETF | 420.68 | 420.68 | 420.68 | 420.68 | 500.0 |
| 2021-06-17 05:55:00 | SPY | ETF | 420.68 | 420.78 | 420.68 | 420.78 | 1820.0 |
| 2021-06-17 06:00:00 | SPY | ETF | 420.78 | 420.79 | 420.78 | 420.79 | 700.0 |
| 2021-06-17 06:05:00 | SPY | ETF | 420.75 | 420.77 | 420.74 | 420.77 | 500.0 |
| 2021-06-17 06:10:00 | SPY | ETF | 420.77 | 420.93 | 420.77 | 420.87 | 1872.0 |
| 2021-06-17 06:15:00 | SPY | ETF | 420.93 | 420.93 | 420.87 | 420.87 | 2500.0 |
| 2021-06-17 06:20:00 | SPY | ETF | 420.82 | 420.96 | 420.82 | 420.84 | 2198.0 |
| 2021-06-17 06:25:00 | SPY | ETF | 420.83 | 420.88 | 420.7 | 420.7 | 502.0 |
| 2021-06-17 06:30:00 | SPY | ETF | 420.68 | 420.68 | 420.63 | 420.63 | 200.0 |
| 2021-06-17 06:35:00 | SPY | ETF | 420.51 | 420.58 | 420.51 | 420.58 | 1050.0 |
| 2021-06-17 06:40:00 | SPY | ETF | 420.5 | 420.58 | 420.38 | 420.38 | 3749.0 |
| 2021-06-17 06:45:00 | SPY | ETF | 420.33 | 420.5 | 420.32 | 420.5 | 18784.0 |
| 2021-06-17 06:50:00 | SPY | ETF | 420.57 | 420.61 | 420.57 | 420.61 | 400.0 |
| 2021-06-17 06:55:00 | SPY | ETF | 420.7 | 420.73 | 420.68 | 420.73 | 1160.0 |
| 2021-06-17 07:00:00 | SPY | ETF | 420.71 | 420.92 | 420.71 | 420.84 | 16123.0 |
| 2021-06-17 07:05:00 | SPY | ETF | 420.92 | 421.27 | 420.92 | 421.23 | 37663.0 |
| 2021-06-17 07:10:00 | SPY | ETF | 421.28 | 421.39 | 421.15 | 421.3 | 6578.0 |
| 2021-06-17 07:15:00 | SPY | ETF | 421.28 | 421.28 | 421.05 | 421.25 | 3634.0 |
| 2021-06-17 07:20:00 | SPY | ETF | 421.24 | 421.38 | 421.2 | 421.38 | 4064.0 |
| 2021-06-17 07:25:00 | SPY | ETF | 421.35 | 421.42 | 421.23 | 421.29 | 15824.0 |
| 2021-06-17 07:30:00 | SPY | ETF | 421.3 | 421.33 | 421.26 | 421.27 | 4618.0 |
| 2021-06-17 07:35:00 | SPY | ETF | 421.27 | 421.34 | 421.21 | 421.28 | 14743.0 |
| 2021-06-17 07:40:00 | SPY | ETF | 421.32 | 421.33 | 421.17 | 421.17 | 6299.0 |
| 2021-06-17 07:45:00 | SPY | ETF | 421.15 | 421.15 | 421.04 | 421.1 | 8068.0 |
| 2021-06-17 07:50:00 | SPY | ETF | 421.1 | 421.1 | 420.96 | 420.99 | 10462.0 |
| 2021-06-17 07:55:00 | SPY | ETF | 420.97 | 420.97 | 420.56 | 420.59 | 10954.0 |
| 2021-06-17 08:00:00 | SPY | ETF | 420.58 | 421.38 | 420.34 | 420.88 | 81537.0 |
| 2021-06-17 08:05:00 | SPY | ETF | 420.88 | 420.95 | 420.27 | 420.85 | 37062.0 |
| 2021-06-17 08:10:00 | SPY | ETF | 420.87 | 420.9 | 420.69 | 420.72 | 28702.0 |
> showing 50 of 85,593 rows — these rows as CSV