PREVIEW / etf_5min / 2018-12-18
file: by_date/etf_5min/2018/2018-12-18.parquet size: 1.6 MB rows: 69,228
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 |
|---|---|---|---|---|---|---|---|
| 2018-12-18 04:00:00 | SPY | ETF | 256.37 | 256.53 | 256.14 | 256.16 | 5633.0 |
| 2018-12-18 04:05:00 | SPY | ETF | 256.16 | 256.16 | 255.97 | 256.12 | 5578.0 |
| 2018-12-18 04:10:00 | SPY | ETF | 256.21 | 256.36 | 256.21 | 256.36 | 560.0 |
| 2018-12-18 04:15:00 | SPY | ETF | 256.36 | 256.36 | 256.25 | 256.25 | 300.0 |
| 2018-12-18 04:20:00 | SPY | ETF | 256.01 | 256.01 | 255.94 | 255.96 | 2945.0 |
| 2018-12-18 04:25:00 | SPY | ETF | 256.25 | 256.28 | 256.08 | 256.08 | 6370.0 |
| 2018-12-18 04:30:00 | SPY | ETF | 256.06 | 256.12 | 256.04 | 256.04 | 4610.0 |
| 2018-12-18 04:35:00 | SPY | ETF | 256.25 | 256.32 | 256.25 | 256.32 | 1350.0 |
| 2018-12-18 04:40:00 | SPY | ETF | 256.35 | 256.51 | 256.35 | 256.47 | 3570.0 |
| 2018-12-18 04:45:00 | SPY | ETF | 256.56 | 256.73 | 256.56 | 256.72 | 7223.0 |
| 2018-12-18 04:50:00 | SPY | ETF | 256.74 | 256.77 | 256.63 | 256.67 | 6518.0 |
| 2018-12-18 04:55:00 | SPY | ETF | 256.71 | 256.82 | 256.71 | 256.73 | 4758.0 |
| 2018-12-18 05:00:00 | SPY | ETF | 256.7 | 256.7 | 256.64 | 256.67 | 2150.0 |
| 2018-12-18 05:05:00 | SPY | ETF | 256.68 | 256.78 | 256.64 | 256.74 | 4460.0 |
| 2018-12-18 05:10:00 | SPY | ETF | 256.72 | 256.72 | 256.69 | 256.7 | 2850.0 |
| 2018-12-18 05:15:00 | SPY | ETF | 256.74 | 256.79 | 256.65 | 256.75 | 14645.0 |
| 2018-12-18 05:20:00 | SPY | ETF | 256.73 | 257.0 | 256.73 | 256.9 | 15494.0 |
| 2018-12-18 05:25:00 | SPY | ETF | 256.89 | 256.99 | 256.82 | 256.99 | 5388.0 |
| 2018-12-18 05:30:00 | SPY | ETF | 256.94 | 256.94 | 256.82 | 256.82 | 8300.0 |
| 2018-12-18 05:35:00 | SPY | ETF | 256.81 | 256.83 | 256.73 | 256.75 | 6209.0 |
| 2018-12-18 05:40:00 | SPY | ETF | 256.72 | 256.74 | 256.59 | 256.59 | 10500.0 |
| 2018-12-18 05:45:00 | SPY | ETF | 256.57 | 256.57 | 256.47 | 256.49 | 5520.0 |
| 2018-12-18 05:50:00 | SPY | ETF | 256.53 | 256.56 | 256.52 | 256.56 | 2261.0 |
| 2018-12-18 05:55:00 | SPY | ETF | 256.58 | 256.6 | 256.47 | 256.47 | 8715.0 |
| 2018-12-18 06:00:00 | SPY | ETF | 256.5 | 256.6 | 256.46 | 256.6 | 5476.0 |
| 2018-12-18 06:05:00 | SPY | ETF | 256.68 | 256.8 | 256.68 | 256.8 | 7214.0 |
| 2018-12-18 06:10:00 | SPY | ETF | 256.76 | 256.86 | 256.76 | 256.86 | 2345.0 |
| 2018-12-18 06:15:00 | SPY | ETF | 256.82 | 256.82 | 256.7 | 256.7 | 8200.0 |
| 2018-12-18 06:20:00 | SPY | ETF | 256.66 | 256.66 | 256.62 | 256.62 | 3638.0 |
| 2018-12-18 06:25:00 | SPY | ETF | 256.83 | 256.89 | 256.81 | 256.81 | 8795.0 |
| 2018-12-18 06:30:00 | SPY | ETF | 256.8 | 256.8 | 256.65 | 256.65 | 3300.0 |
| 2018-12-18 06:35:00 | SPY | ETF | 256.66 | 256.66 | 256.56 | 256.61 | 17745.0 |
| 2018-12-18 06:40:00 | SPY | ETF | 256.82 | 256.93 | 256.82 | 256.89 | 2969.0 |
| 2018-12-18 06:45:00 | SPY | ETF | 256.94 | 256.95 | 256.72 | 256.75 | 14783.0 |
| 2018-12-18 06:50:00 | SPY | ETF | 256.75 | 256.82 | 256.71 | 256.82 | 6929.0 |
| 2018-12-18 06:55:00 | SPY | ETF | 256.84 | 256.85 | 256.65 | 256.7 | 12645.0 |
| 2018-12-18 07:00:00 | SPY | ETF | 256.72 | 256.85 | 256.7 | 256.75 | 69839.0 |
| 2018-12-18 07:05:00 | SPY | ETF | 256.75 | 256.76 | 256.65 | 256.68 | 30713.0 |
| 2018-12-18 07:10:00 | SPY | ETF | 256.67 | 256.7 | 256.55 | 256.65 | 21689.0 |
| 2018-12-18 07:15:00 | SPY | ETF | 256.63 | 256.7 | 256.58 | 256.58 | 2083.0 |
| 2018-12-18 07:20:00 | SPY | ETF | 256.69 | 256.78 | 256.66 | 256.77 | 38899.0 |
| 2018-12-18 07:25:00 | SPY | ETF | 256.78 | 256.86 | 256.77 | 256.85 | 18335.0 |
| 2018-12-18 07:30:00 | SPY | ETF | 256.85 | 257.1 | 256.85 | 257.1 | 43637.0 |
| 2018-12-18 07:35:00 | SPY | ETF | 257.09 | 257.22 | 257.06 | 257.1 | 92806.0 |
| 2018-12-18 07:40:00 | SPY | ETF | 257.14 | 257.19 | 257.13 | 257.18 | 42413.0 |
| 2018-12-18 07:45:00 | SPY | ETF | 257.19 | 257.57 | 257.19 | 257.57 | 70545.0 |
| 2018-12-18 07:50:00 | SPY | ETF | 257.53 | 257.69 | 257.5 | 257.68 | 35761.0 |
| 2018-12-18 07:55:00 | SPY | ETF | 257.65 | 257.74 | 257.58 | 257.6 | 89398.0 |
| 2018-12-18 08:00:00 | SPY | ETF | 257.6 | 257.78 | 255.48 | 257.45 | 167743.0 |
| 2018-12-18 08:05:00 | SPY | ETF | 257.44 | 257.47 | 257.33 | 257.4 | 103115.0 |
> showing 50 of 69,228 rows — these rows as CSV