PREVIEW / etf_5min / 2019-08-22
file: by_date/etf_5min/2019/2019-08-22.parquet size: 1.4 MB rows: 60,284
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 |
|---|---|---|---|---|---|---|---|
| 2019-08-22 04:00:00 | SPY | ETF | 293.17 | 293.24 | 293.0 | 293.09 | 5210.0 |
| 2019-08-22 04:05:00 | SPY | ETF | 292.97 | 293.02 | 292.97 | 292.97 | 801.0 |
| 2019-08-22 04:10:00 | SPY | ETF | 293.05 | 293.12 | 293.05 | 293.05 | 6600.0 |
| 2019-08-22 04:15:00 | SPY | ETF | 293.13 | 293.13 | 292.94 | 292.94 | 681.0 |
| 2019-08-22 04:20:00 | SPY | ETF | 292.98 | 292.98 | 292.85 | 292.85 | 501.0 |
| 2019-08-22 04:25:00 | SPY | ETF | 292.78 | 292.78 | 292.49 | 292.49 | 2385.0 |
| 2019-08-22 04:30:00 | SPY | ETF | 292.44 | 292.44 | 292.22 | 292.27 | 2154.0 |
| 2019-08-22 04:35:00 | SPY | ETF | 292.3 | 292.8 | 292.28 | 292.4 | 16904.0 |
| 2019-08-22 04:40:00 | SPY | ETF | 292.35 | 292.43 | 292.35 | 292.37 | 3154.0 |
| 2019-08-22 04:45:00 | SPY | ETF | 292.45 | 292.5 | 292.45 | 292.48 | 1800.0 |
| 2019-08-22 04:50:00 | SPY | ETF | 292.53 | 292.53 | 292.48 | 292.48 | 5450.0 |
| 2019-08-22 04:55:00 | SPY | ETF | 292.55 | 292.6 | 292.55 | 292.6 | 600.0 |
| 2019-08-22 05:00:00 | SPY | ETF | 292.52 | 292.61 | 292.52 | 292.61 | 1100.0 |
| 2019-08-22 05:05:00 | SPY | ETF | 292.6 | 292.6 | 292.35 | 292.45 | 6400.0 |
| 2019-08-22 05:10:00 | SPY | ETF | 292.51 | 292.51 | 292.4 | 292.4 | 903.0 |
| 2019-08-22 05:20:00 | SPY | ETF | 292.33 | 292.33 | 292.09 | 292.24 | 3570.0 |
| 2019-08-22 05:25:00 | SPY | ETF | 292.18 | 292.18 | 292.0 | 292.01 | 3822.0 |
| 2019-08-22 05:30:00 | SPY | ETF | 292.07 | 292.07 | 292.0 | 292.0 | 1370.0 |
| 2019-08-22 05:35:00 | SPY | ETF | 292.01 | 292.11 | 291.98 | 292.11 | 2000.0 |
| 2019-08-22 05:40:00 | SPY | ETF | 292.08 | 292.08 | 292.03 | 292.03 | 400.0 |
| 2019-08-22 05:45:00 | SPY | ETF | 291.86 | 292.1 | 291.85 | 292.1 | 1879.0 |
| 2019-08-22 05:50:00 | SPY | ETF | 292.08 | 292.13 | 291.96 | 292.13 | 1189.0 |
| 2019-08-22 05:55:00 | SPY | ETF | 292.08 | 292.08 | 292.08 | 292.08 | 500.0 |
| 2019-08-22 06:00:00 | SPY | ETF | 292.24 | 292.24 | 292.24 | 292.24 | 100.0 |
| 2019-08-22 06:05:00 | SPY | ETF | 292.16 | 292.28 | 292.16 | 292.28 | 1850.0 |
| 2019-08-22 06:10:00 | SPY | ETF | 292.28 | 292.28 | 292.25 | 292.25 | 360.0 |
| 2019-08-22 06:15:00 | SPY | ETF | 292.38 | 292.5 | 292.35 | 292.48 | 1624.0 |
| 2019-08-22 06:25:00 | SPY | ETF | 292.4 | 292.4 | 292.33 | 292.37 | 710.0 |
| 2019-08-22 06:35:00 | SPY | ETF | 292.4 | 292.45 | 292.38 | 292.43 | 3650.0 |
| 2019-08-22 06:40:00 | SPY | ETF | 292.4 | 292.45 | 292.4 | 292.45 | 2200.0 |
| 2019-08-22 06:45:00 | SPY | ETF | 292.4 | 292.52 | 292.4 | 292.47 | 48993.0 |
| 2019-08-22 06:50:00 | SPY | ETF | 292.45 | 292.45 | 292.35 | 292.4 | 9169.0 |
| 2019-08-22 06:55:00 | SPY | ETF | 292.36 | 292.4 | 292.32 | 292.32 | 12893.0 |
| 2019-08-22 07:00:00 | SPY | ETF | 292.42 | 292.5 | 292.37 | 292.43 | 9939.0 |
| 2019-08-22 07:05:00 | SPY | ETF | 292.52 | 292.54 | 292.52 | 292.52 | 14310.0 |
| 2019-08-22 07:10:00 | SPY | ETF | 292.47 | 292.47 | 292.37 | 292.41 | 12410.0 |
| 2019-08-22 07:15:00 | SPY | ETF | 292.46 | 292.82 | 292.46 | 292.82 | 7064.0 |
| 2019-08-22 07:20:00 | SPY | ETF | 292.79 | 292.87 | 292.76 | 292.84 | 9049.0 |
| 2019-08-22 07:25:00 | SPY | ETF | 292.88 | 293.05 | 292.88 | 292.98 | 38858.0 |
| 2019-08-22 07:30:00 | SPY | ETF | 292.97 | 292.98 | 292.89 | 292.91 | 11154.0 |
| 2019-08-22 07:35:00 | SPY | ETF | 292.96 | 293.19 | 292.94 | 293.16 | 15815.0 |
| 2019-08-22 07:40:00 | SPY | ETF | 293.14 | 293.29 | 293.11 | 293.28 | 30890.0 |
| 2019-08-22 07:45:00 | SPY | ETF | 293.27 | 293.4 | 293.25 | 293.3 | 51697.0 |
| 2019-08-22 07:50:00 | SPY | ETF | 293.3 | 293.34 | 293.27 | 293.28 | 6370.0 |
| 2019-08-22 07:55:00 | SPY | ETF | 293.3 | 293.3 | 293.24 | 293.27 | 18394.0 |
| 2019-08-22 08:00:00 | SPY | ETF | 292.39 | 293.45 | 292.33 | 293.35 | 63489.0 |
| 2019-08-22 08:05:00 | SPY | ETF | 293.34 | 293.38 | 293.29 | 293.32 | 62560.0 |
| 2019-08-22 08:10:00 | SPY | ETF | 293.33 | 293.45 | 293.3 | 293.37 | 48914.0 |
| 2019-08-22 08:15:00 | SPY | ETF | 293.36 | 293.43 | 291.95 | 293.21 | 88415.0 |
| 2019-08-22 08:20:00 | SPY | ETF | 293.22 | 293.23 | 293.16 | 293.23 | 14710.0 |
> showing 50 of 60,284 rows — these rows as CSV