PREVIEW / etf_5min / 2014-02-04
file: by_date/etf_5min/2014/2014-02-04.parquet size: 1.1 MB rows: 47,381
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-02-04 04:00:00 | SPY | ETF | 174.6 | 174.65 | 174.59 | 174.62 | 22821.0 |
| 2014-02-04 04:05:00 | SPY | ETF | 174.56 | 174.61 | 174.56 | 174.58 | 15749.0 |
| 2014-02-04 04:10:00 | SPY | ETF | 174.62 | 174.65 | 174.61 | 174.65 | 62550.0 |
| 2014-02-04 04:15:00 | SPY | ETF | 174.66 | 174.66 | 174.57 | 174.57 | 63454.0 |
| 2014-02-04 04:20:00 | SPY | ETF | 174.52 | 174.55 | 174.5 | 174.51 | 17523.0 |
| 2014-02-04 04:25:00 | SPY | ETF | 174.49 | 174.61 | 174.49 | 174.61 | 7767.0 |
| 2014-02-04 04:30:00 | SPY | ETF | 174.65 | 174.7 | 174.65 | 174.69 | 25052.0 |
| 2014-02-04 04:35:00 | SPY | ETF | 174.7 | 174.79 | 174.7 | 174.78 | 70615.0 |
| 2014-02-04 04:40:00 | SPY | ETF | 174.79 | 174.8 | 174.74 | 174.74 | 855.0 |
| 2014-02-04 04:45:00 | SPY | ETF | 174.7 | 174.73 | 174.66 | 174.66 | 100630.0 |
| 2014-02-04 04:50:00 | SPY | ETF | 174.66 | 174.77 | 174.66 | 174.76 | 100037.0 |
| 2014-02-04 04:55:00 | SPY | ETF | 174.77 | 174.77 | 174.66 | 174.66 | 24235.0 |
| 2014-02-04 05:00:00 | SPY | ETF | 174.67 | 174.73 | 174.67 | 174.7 | 7399.0 |
| 2014-02-04 05:05:00 | SPY | ETF | 174.72 | 174.72 | 174.57 | 174.57 | 25936.0 |
| 2014-02-04 05:10:00 | SPY | ETF | 174.66 | 174.66 | 174.6 | 174.6 | 2372.0 |
| 2014-02-04 05:15:00 | SPY | ETF | 174.61 | 174.61 | 174.57 | 174.57 | 4043.0 |
| 2014-02-04 05:25:00 | SPY | ETF | 174.56 | 174.56 | 174.52 | 174.52 | 390.0 |
| 2014-02-04 05:30:00 | SPY | ETF | 174.5 | 174.5 | 174.37 | 174.37 | 2948.0 |
| 2014-02-04 05:35:00 | SPY | ETF | 174.34 | 174.34 | 174.34 | 174.34 | 3900.0 |
| 2014-02-04 05:45:00 | SPY | ETF | 174.32 | 174.32 | 174.28 | 174.28 | 4350.0 |
| 2014-02-04 05:55:00 | SPY | ETF | 174.32 | 174.36 | 174.27 | 174.35 | 27687.0 |
| 2014-02-04 06:00:00 | SPY | ETF | 174.33 | 174.33 | 174.24 | 174.24 | 52063.0 |
| 2014-02-04 06:05:00 | SPY | ETF | 174.29 | 174.29 | 174.29 | 174.29 | 549.0 |
| 2014-02-04 06:15:00 | SPY | ETF | 174.4 | 174.42 | 174.29 | 174.3 | 10755.0 |
| 2014-02-04 06:20:00 | SPY | ETF | 174.28 | 174.29 | 174.23 | 174.29 | 6811.0 |
| 2014-02-04 06:25:00 | SPY | ETF | 174.25 | 174.34 | 174.24 | 174.34 | 7205.0 |
| 2014-02-04 06:30:00 | SPY | ETF | 174.35 | 174.38 | 174.35 | 174.38 | 3530.0 |
| 2014-02-04 06:35:00 | SPY | ETF | 174.44 | 174.5 | 174.42 | 174.42 | 6786.0 |
| 2014-02-04 06:40:00 | SPY | ETF | 174.35 | 174.4 | 174.35 | 174.4 | 635.0 |
| 2014-02-04 06:45:00 | SPY | ETF | 174.39 | 174.5 | 174.38 | 174.5 | 8569.0 |
| 2014-02-04 06:50:00 | SPY | ETF | 174.48 | 174.48 | 174.43 | 174.43 | 11100.0 |
| 2014-02-04 06:55:00 | SPY | ETF | 174.47 | 174.47 | 174.36 | 174.36 | 8907.0 |
| 2014-02-04 07:00:00 | SPY | ETF | 174.38 | 174.45 | 174.35 | 174.42 | 5108.0 |
| 2014-02-04 07:05:00 | SPY | ETF | 174.5 | 174.5 | 174.39 | 174.39 | 1980.0 |
| 2014-02-04 07:10:00 | SPY | ETF | 174.4 | 174.45 | 174.39 | 174.39 | 13699.0 |
| 2014-02-04 07:15:00 | SPY | ETF | 174.36 | 174.4 | 174.29 | 174.4 | 74559.0 |
| 2014-02-04 07:20:00 | SPY | ETF | 174.36 | 174.45 | 174.36 | 174.45 | 16810.0 |
| 2014-02-04 07:25:00 | SPY | ETF | 174.45 | 174.5 | 174.36 | 174.4 | 29580.0 |
| 2014-02-04 07:30:00 | SPY | ETF | 174.38 | 174.42 | 174.38 | 174.38 | 27421.0 |
| 2014-02-04 07:35:00 | SPY | ETF | 174.37 | 174.37 | 174.29 | 174.35 | 70465.0 |
| 2014-02-04 07:40:00 | SPY | ETF | 174.31 | 174.32 | 174.24 | 174.28 | 28150.0 |
| 2014-02-04 07:45:00 | SPY | ETF | 174.27 | 174.35 | 174.27 | 174.27 | 30530.0 |
| 2014-02-04 07:50:00 | SPY | ETF | 174.26 | 174.4 | 174.26 | 174.38 | 4355.0 |
| 2014-02-04 07:55:00 | SPY | ETF | 174.38 | 174.48 | 174.37 | 174.43 | 72280.0 |
| 2014-02-04 08:00:00 | SPY | ETF | 174.44 | 174.77 | 174.24 | 174.45 | 150032.0 |
| 2014-02-04 08:05:00 | SPY | ETF | 174.45 | 174.64 | 174.45 | 174.63 | 199289.0 |
| 2014-02-04 08:10:00 | SPY | ETF | 174.63 | 174.72 | 174.6 | 174.66 | 102086.0 |
| 2014-02-04 08:15:00 | SPY | ETF | 174.66 | 174.78 | 174.62 | 174.76 | 124178.0 |
| 2014-02-04 08:20:00 | SPY | ETF | 174.73 | 174.92 | 174.73 | 174.92 | 209921.0 |
| 2014-02-04 08:25:00 | SPY | ETF | 174.91 | 174.95 | 174.87 | 174.9 | 163835.0 |
> showing 50 of 47,381 rows — these rows as CSV