PREVIEW / etf_5min / 2014-12-18
file: by_date/etf_5min/2014/2014-12-18.parquet size: 1.2 MB rows: 52,173
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 |
|---|---|---|---|---|---|---|---|
| 2014-12-18 04:00:00 | SPY | ETF | 202.59 | 203.45 | 202.59 | 203.38 | 19201.0 |
| 2014-12-18 04:05:00 | SPY | ETF | 203.41 | 203.72 | 203.41 | 203.72 | 20310.0 |
| 2014-12-18 04:10:00 | SPY | ETF | 203.58 | 203.62 | 203.5 | 203.52 | 11200.0 |
| 2014-12-18 04:15:00 | SPY | ETF | 203.52 | 203.52 | 203.52 | 203.52 | 100.0 |
| 2014-12-18 04:20:00 | SPY | ETF | 203.55 | 203.55 | 203.5 | 203.5 | 10400.0 |
| 2014-12-18 04:25:00 | SPY | ETF | 203.6 | 203.75 | 203.58 | 203.75 | 28125.0 |
| 2014-12-18 04:30:00 | SPY | ETF | 203.77 | 204.1 | 203.77 | 204.1 | 12990.0 |
| 2014-12-18 04:35:00 | SPY | ETF | 204.07 | 204.17 | 203.81 | 203.81 | 29965.0 |
| 2014-12-18 04:40:00 | SPY | ETF | 203.8 | 203.85 | 203.78 | 203.85 | 2100.0 |
| 2014-12-18 04:45:00 | SPY | ETF | 203.92 | 203.92 | 203.78 | 203.78 | 4475.0 |
| 2014-12-18 04:50:00 | SPY | ETF | 203.82 | 203.82 | 203.6 | 203.6 | 10949.0 |
| 2014-12-18 05:00:00 | SPY | ETF | 203.8 | 203.8 | 203.8 | 203.8 | 380.0 |
| 2014-12-18 05:05:00 | SPY | ETF | 203.86 | 204.0 | 203.85 | 204.0 | 2874.0 |
| 2014-12-18 05:10:00 | SPY | ETF | 204.06 | 204.14 | 204.01 | 204.05 | 8990.0 |
| 2014-12-18 05:15:00 | SPY | ETF | 204.1 | 204.61 | 204.1 | 204.49 | 78267.0 |
| 2014-12-18 05:20:00 | SPY | ETF | 204.45 | 204.7 | 204.42 | 204.69 | 106346.0 |
| 2014-12-18 05:25:00 | SPY | ETF | 204.69 | 204.81 | 204.66 | 204.71 | 92427.0 |
| 2014-12-18 05:30:00 | SPY | ETF | 204.69 | 204.72 | 204.58 | 204.65 | 93345.0 |
| 2014-12-18 05:35:00 | SPY | ETF | 204.6 | 204.67 | 204.5 | 204.54 | 12500.0 |
| 2014-12-18 05:40:00 | SPY | ETF | 204.5 | 204.55 | 204.5 | 204.53 | 7390.0 |
| 2014-12-18 05:45:00 | SPY | ETF | 204.56 | 204.59 | 204.43 | 204.59 | 11393.0 |
| 2014-12-18 05:50:00 | SPY | ETF | 204.6 | 204.64 | 204.57 | 204.57 | 16425.0 |
| 2014-12-18 05:55:00 | SPY | ETF | 204.54 | 204.64 | 204.52 | 204.55 | 14986.0 |
| 2014-12-18 06:00:00 | SPY | ETF | 204.54 | 204.57 | 204.5 | 204.52 | 5350.0 |
| 2014-12-18 06:05:00 | SPY | ETF | 204.51 | 204.51 | 204.44 | 204.48 | 66507.0 |
| 2014-12-18 06:10:00 | SPY | ETF | 204.49 | 204.49 | 204.36 | 204.36 | 20700.0 |
| 2014-12-18 06:15:00 | SPY | ETF | 204.37 | 204.47 | 204.37 | 204.41 | 5300.0 |
| 2014-12-18 06:20:00 | SPY | ETF | 204.43 | 204.43 | 204.31 | 204.4 | 33350.0 |
| 2014-12-18 06:25:00 | SPY | ETF | 204.45 | 204.45 | 204.24 | 204.3 | 30800.0 |
| 2014-12-18 06:30:00 | SPY | ETF | 204.27 | 204.29 | 204.19 | 204.24 | 24575.0 |
| 2014-12-18 06:35:00 | SPY | ETF | 204.24 | 204.25 | 204.18 | 204.19 | 39255.0 |
| 2014-12-18 06:40:00 | SPY | ETF | 204.21 | 204.21 | 204.18 | 204.21 | 7500.0 |
| 2014-12-18 06:45:00 | SPY | ETF | 204.2 | 204.2 | 204.11 | 204.11 | 9100.0 |
| 2014-12-18 06:50:00 | SPY | ETF | 204.11 | 204.17 | 204.1 | 204.17 | 14380.0 |
| 2014-12-18 06:55:00 | SPY | ETF | 204.24 | 204.24 | 204.07 | 204.07 | 11000.0 |
| 2014-12-18 07:00:00 | SPY | ETF | 204.1 | 204.27 | 204.1 | 204.24 | 45185.0 |
| 2014-12-18 07:05:00 | SPY | ETF | 204.25 | 204.27 | 204.18 | 204.21 | 26575.0 |
| 2014-12-18 07:10:00 | SPY | ETF | 204.21 | 204.26 | 204.18 | 204.26 | 13390.0 |
| 2014-12-18 07:15:00 | SPY | ETF | 204.23 | 204.29 | 204.22 | 204.25 | 42275.0 |
| 2014-12-18 07:20:00 | SPY | ETF | 204.26 | 204.34 | 204.14 | 204.34 | 97064.0 |
| 2014-12-18 07:25:00 | SPY | ETF | 204.32 | 204.4 | 204.29 | 204.39 | 49655.0 |
| 2014-12-18 07:30:00 | SPY | ETF | 204.38 | 204.52 | 204.33 | 204.45 | 163893.0 |
| 2014-12-18 07:35:00 | SPY | ETF | 204.46 | 204.48 | 204.37 | 204.39 | 39597.0 |
| 2014-12-18 07:40:00 | SPY | ETF | 204.41 | 204.5 | 204.41 | 204.48 | 41911.0 |
| 2014-12-18 07:45:00 | SPY | ETF | 204.49 | 204.52 | 204.46 | 204.49 | 52399.0 |
| 2014-12-18 07:50:00 | SPY | ETF | 204.5 | 204.5 | 204.34 | 204.34 | 118947.0 |
| 2014-12-18 07:55:00 | SPY | ETF | 204.34 | 204.45 | 204.29 | 204.44 | 58494.0 |
| 2014-12-18 08:00:00 | SPY | ETF | 204.41 | 204.51 | 203.0 | 204.38 | 177258.0 |
| 2014-12-18 08:05:00 | SPY | ETF | 204.38 | 204.38 | 204.21 | 204.24 | 71569.0 |
| 2014-12-18 08:10:00 | SPY | ETF | 204.22 | 204.26 | 204.18 | 204.25 | 87424.0 |
> showing 50 of 52,173 rows — these rows as CSV