PREVIEW / etf_5min / 2015-12-23
file: by_date/etf_5min/2015/2015-12-23.parquet size: 1.2 MB rows: 50,905
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 |
|---|---|---|---|---|---|---|---|
| 2015-12-23 04:00:00 | SPY | ETF | 204.08 | 204.35 | 204.08 | 204.15 | 1230.0 |
| 2015-12-23 04:05:00 | SPY | ETF | 204.25 | 204.28 | 204.2 | 204.2 | 9300.0 |
| 2015-12-23 04:10:00 | SPY | ETF | 204.12 | 204.15 | 204.12 | 204.15 | 1400.0 |
| 2015-12-23 04:20:00 | SPY | ETF | 204.25 | 204.35 | 204.25 | 204.3 | 1412.0 |
| 2015-12-23 04:25:00 | SPY | ETF | 204.24 | 204.26 | 204.24 | 204.26 | 355.0 |
| 2015-12-23 04:30:00 | SPY | ETF | 204.25 | 204.25 | 204.25 | 204.25 | 220.0 |
| 2015-12-23 04:35:00 | SPY | ETF | 204.32 | 204.32 | 204.26 | 204.26 | 2536.0 |
| 2015-12-23 04:40:00 | SPY | ETF | 204.26 | 204.26 | 204.26 | 204.26 | 300.0 |
| 2015-12-23 04:45:00 | SPY | ETF | 204.25 | 204.36 | 204.25 | 204.36 | 321.0 |
| 2015-12-23 04:50:00 | SPY | ETF | 204.29 | 204.29 | 204.29 | 204.29 | 3300.0 |
| 2015-12-23 04:55:00 | SPY | ETF | 204.34 | 204.43 | 204.34 | 204.39 | 1540.0 |
| 2015-12-23 05:00:00 | SPY | ETF | 204.39 | 204.45 | 204.39 | 204.45 | 2430.0 |
| 2015-12-23 05:05:00 | SPY | ETF | 204.38 | 204.38 | 204.3 | 204.3 | 2822.0 |
| 2015-12-23 05:10:00 | SPY | ETF | 204.28 | 204.3 | 204.28 | 204.3 | 1100.0 |
| 2015-12-23 05:15:00 | SPY | ETF | 204.35 | 204.37 | 204.33 | 204.33 | 7252.0 |
| 2015-12-23 05:20:00 | SPY | ETF | 204.39 | 204.39 | 204.32 | 204.32 | 1700.0 |
| 2015-12-23 05:25:00 | SPY | ETF | 204.3 | 204.39 | 204.29 | 204.39 | 3848.0 |
| 2015-12-23 05:30:00 | SPY | ETF | 204.37 | 204.39 | 204.37 | 204.37 | 985.0 |
| 2015-12-23 05:35:00 | SPY | ETF | 204.38 | 204.39 | 204.33 | 204.33 | 1200.0 |
| 2015-12-23 05:40:00 | SPY | ETF | 204.37 | 204.37 | 204.34 | 204.34 | 1677.0 |
| 2015-12-23 05:50:00 | SPY | ETF | 204.38 | 204.44 | 204.38 | 204.39 | 3100.0 |
| 2015-12-23 05:55:00 | SPY | ETF | 204.34 | 204.34 | 204.32 | 204.32 | 1903.0 |
| 2015-12-23 06:00:00 | SPY | ETF | 204.24 | 204.24 | 204.2 | 204.2 | 301.0 |
| 2015-12-23 06:05:00 | SPY | ETF | 204.19 | 204.2 | 204.19 | 204.2 | 1700.0 |
| 2015-12-23 06:15:00 | SPY | ETF | 204.25 | 204.25 | 204.25 | 204.25 | 200.0 |
| 2015-12-23 06:20:00 | SPY | ETF | 204.42 | 204.5 | 204.42 | 204.5 | 10445.0 |
| 2015-12-23 06:25:00 | SPY | ETF | 204.53 | 204.64 | 204.53 | 204.57 | 32078.0 |
| 2015-12-23 06:30:00 | SPY | ETF | 204.53 | 204.55 | 204.5 | 204.5 | 9230.0 |
| 2015-12-23 06:35:00 | SPY | ETF | 204.57 | 204.65 | 204.57 | 204.65 | 6310.0 |
| 2015-12-23 06:40:00 | SPY | ETF | 204.59 | 204.6 | 204.58 | 204.58 | 695.0 |
| 2015-12-23 06:45:00 | SPY | ETF | 204.55 | 204.55 | 204.49 | 204.5 | 8384.0 |
| 2015-12-23 06:50:00 | SPY | ETF | 204.5 | 204.51 | 204.5 | 204.5 | 7400.0 |
| 2015-12-23 06:55:00 | SPY | ETF | 204.57 | 204.58 | 204.57 | 204.58 | 3125.0 |
| 2015-12-23 07:00:00 | SPY | ETF | 204.61 | 204.69 | 204.57 | 204.69 | 11865.0 |
| 2015-12-23 07:05:00 | SPY | ETF | 204.65 | 204.85 | 204.65 | 204.85 | 29365.0 |
| 2015-12-23 07:10:00 | SPY | ETF | 204.84 | 204.87 | 204.8 | 204.8 | 16072.0 |
| 2015-12-23 07:15:00 | SPY | ETF | 204.83 | 204.87 | 204.81 | 204.87 | 5525.0 |
| 2015-12-23 07:20:00 | SPY | ETF | 204.85 | 204.95 | 204.85 | 204.9 | 7311.0 |
| 2015-12-23 07:25:00 | SPY | ETF | 204.88 | 204.93 | 204.86 | 204.89 | 36850.0 |
| 2015-12-23 07:30:00 | SPY | ETF | 204.89 | 204.91 | 204.85 | 204.91 | 7600.0 |
| 2015-12-23 07:35:00 | SPY | ETF | 204.89 | 204.89 | 204.8 | 204.85 | 36575.0 |
| 2015-12-23 07:40:00 | SPY | ETF | 204.84 | 204.84 | 204.76 | 204.77 | 21141.0 |
| 2015-12-23 07:45:00 | SPY | ETF | 204.79 | 204.86 | 204.78 | 204.85 | 6575.0 |
| 2015-12-23 07:50:00 | SPY | ETF | 204.85 | 204.85 | 204.78 | 204.8 | 5697.0 |
| 2015-12-23 07:55:00 | SPY | ETF | 204.8 | 204.8 | 204.69 | 204.74 | 36647.0 |
| 2015-12-23 08:00:00 | SPY | ETF | 204.74 | 204.89 | 204.61 | 204.72 | 84171.0 |
| 2015-12-23 08:05:00 | SPY | ETF | 204.72 | 204.76 | 204.69 | 204.69 | 18724.0 |
| 2015-12-23 08:10:00 | SPY | ETF | 204.6801 | 204.7 | 204.63 | 204.66 | 17959.0 |
| 2015-12-23 08:15:00 | SPY | ETF | 204.64 | 204.7 | 204.57 | 204.67 | 57730.0 |
| 2015-12-23 08:20:00 | SPY | ETF | 204.66 | 204.7 | 204.62 | 204.66 | 27759.0 |
> showing 50 of 50,905 rows — these rows as CSV