PREVIEW / etf_5min / 2019-09-11
file: by_date/etf_5min/2019/2019-09-11.parquet size: 1.5 MB rows: 62,996
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-09-11 04:00:00 | SPY | ETF | 298.58 | 298.64 | 298.58 | 298.63 | 959.0 |
| 2019-09-11 04:05:00 | SPY | ETF | 298.52 | 298.56 | 298.52 | 298.56 | 350.0 |
| 2019-09-11 04:25:00 | SPY | ETF | 298.18 | 298.2 | 298.18 | 298.2 | 700.0 |
| 2019-09-11 04:30:00 | SPY | ETF | 298.19 | 298.19 | 298.19 | 298.19 | 100.0 |
| 2019-09-11 04:35:00 | SPY | ETF | 298.27 | 298.27 | 298.27 | 298.27 | 100.0 |
| 2019-09-11 04:40:00 | SPY | ETF | 298.39 | 298.42 | 298.34 | 298.34 | 540.0 |
| 2019-09-11 04:45:00 | SPY | ETF | 298.35 | 298.37 | 298.35 | 298.35 | 800.0 |
| 2019-09-11 04:50:00 | SPY | ETF | 298.4 | 298.4 | 298.4 | 298.4 | 100.0 |
| 2019-09-11 04:55:00 | SPY | ETF | 298.33 | 298.33 | 298.3 | 298.3 | 200.0 |
| 2019-09-11 05:00:00 | SPY | ETF | 298.0 | 298.12 | 297.77 | 298.06 | 4400.0 |
| 2019-09-11 05:05:00 | SPY | ETF | 298.05 | 298.05 | 298.05 | 298.05 | 100.0 |
| 2019-09-11 05:10:00 | SPY | ETF | 298.0 | 298.0 | 297.86 | 297.86 | 600.0 |
| 2019-09-11 05:30:00 | SPY | ETF | 297.97 | 298.05 | 297.97 | 298.05 | 1470.0 |
| 2019-09-11 05:35:00 | SPY | ETF | 297.96 | 297.96 | 297.96 | 297.96 | 100.0 |
| 2019-09-11 05:40:00 | SPY | ETF | 297.95 | 297.95 | 297.88 | 297.88 | 200.0 |
| 2019-09-11 05:45:00 | SPY | ETF | 297.87 | 297.9 | 297.87 | 297.9 | 1550.0 |
| 2019-09-11 05:50:00 | SPY | ETF | 297.95 | 298.1 | 297.95 | 298.1 | 900.0 |
| 2019-09-11 05:55:00 | SPY | ETF | 298.13 | 298.13 | 298.13 | 298.13 | 100.0 |
| 2019-09-11 06:00:00 | SPY | ETF | 298.14 | 298.14 | 298.04 | 298.04 | 925.0 |
| 2019-09-11 06:05:00 | SPY | ETF | 298.06 | 298.1 | 298.06 | 298.1 | 500.0 |
| 2019-09-11 06:10:00 | SPY | ETF | 298.15 | 298.17 | 298.15 | 298.17 | 200.0 |
| 2019-09-11 06:15:00 | SPY | ETF | 298.24 | 298.24 | 298.24 | 298.24 | 100.0 |
| 2019-09-11 06:25:00 | SPY | ETF | 298.17 | 298.17 | 298.17 | 298.17 | 100.0 |
| 2019-09-11 06:35:00 | SPY | ETF | 298.19 | 298.34 | 298.19 | 298.34 | 285.0 |
| 2019-09-11 06:40:00 | SPY | ETF | 298.28 | 298.29 | 298.28 | 298.29 | 1995.0 |
| 2019-09-11 06:45:00 | SPY | ETF | 298.2 | 298.25 | 298.19 | 298.25 | 1058.0 |
| 2019-09-11 06:50:00 | SPY | ETF | 298.2 | 298.2 | 298.0 | 298.0 | 1250.0 |
| 2019-09-11 06:55:00 | SPY | ETF | 298.07 | 298.1 | 298.07 | 298.09 | 45000.0 |
| 2019-09-11 07:00:00 | SPY | ETF | 298.05 | 298.13 | 298.05 | 298.1 | 5645.0 |
| 2019-09-11 07:05:00 | SPY | ETF | 298.1 | 298.14 | 298.05 | 298.1 | 22843.0 |
| 2019-09-11 07:10:00 | SPY | ETF | 298.12 | 298.12 | 298.1 | 298.12 | 7350.0 |
| 2019-09-11 07:15:00 | SPY | ETF | 298.1 | 298.15 | 298.1 | 298.1 | 24300.0 |
| 2019-09-11 07:20:00 | SPY | ETF | 298.24 | 298.25 | 298.2 | 298.24 | 14788.0 |
| 2019-09-11 07:25:00 | SPY | ETF | 298.26 | 298.34 | 298.26 | 298.34 | 6659.0 |
| 2019-09-11 07:30:00 | SPY | ETF | 298.27 | 298.34 | 298.18 | 298.23 | 32103.0 |
| 2019-09-11 07:35:00 | SPY | ETF | 298.18 | 298.27 | 298.18 | 298.25 | 20001.0 |
| 2019-09-11 07:40:00 | SPY | ETF | 298.23 | 298.41 | 298.23 | 298.36 | 26440.0 |
| 2019-09-11 07:45:00 | SPY | ETF | 298.36 | 298.55 | 298.35 | 298.55 | 17234.0 |
| 2019-09-11 07:50:00 | SPY | ETF | 298.53 | 298.58 | 298.5 | 298.53 | 29582.0 |
| 2019-09-11 07:55:00 | SPY | ETF | 298.56 | 298.68 | 298.55 | 298.6 | 52179.0 |
| 2019-09-11 08:00:00 | SPY | ETF | 298.12 | 298.8 | 298.07 | 298.59 | 39369.0 |
| 2019-09-11 08:05:00 | SPY | ETF | 298.63 | 298.67 | 298.57 | 298.62 | 30564.0 |
| 2019-09-11 08:10:00 | SPY | ETF | 298.63 | 298.6901 | 298.54 | 298.59 | 24140.0 |
| 2019-09-11 08:15:00 | SPY | ETF | 298.61 | 298.65 | 298.57 | 298.57 | 13122.0 |
| 2019-09-11 08:20:00 | SPY | ETF | 298.6 | 298.67 | 298.6 | 298.64 | 72613.0 |
| 2019-09-11 08:25:00 | SPY | ETF | 298.64 | 298.66 | 298.56 | 298.6 | 19616.0 |
| 2019-09-11 08:30:00 | SPY | ETF | 298.54 | 298.57 | 298.4 | 298.44 | 39456.0 |
| 2019-09-11 08:35:00 | SPY | ETF | 298.45 | 298.52 | 298.45 | 298.47 | 58025.0 |
| 2019-09-11 08:40:00 | SPY | ETF | 298.47 | 298.58 | 298.42 | 298.46 | 8714.0 |
| 2019-09-11 08:45:00 | SPY | ETF | 298.46 | 298.48 | 298.45 | 298.45 | 11169.0 |
> showing 50 of 62,996 rows — these rows as CSV