PREVIEW / etf_5min / 2014-10-02
file: by_date/etf_5min/2014/2014-10-02.parquet size: 1.2 MB rows: 48,591
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-10-02 04:05:00 | SPY | ETF | 194.6 | 194.6 | 194.6 | 194.6 | 100.0 |
| 2014-10-02 04:25:00 | SPY | ETF | 194.37 | 194.37 | 194.33 | 194.33 | 323.0 |
| 2014-10-02 04:35:00 | SPY | ETF | 194.33 | 194.33 | 194.29 | 194.29 | 309.0 |
| 2014-10-02 04:40:00 | SPY | ETF | 194.26 | 194.26 | 194.18 | 194.18 | 622.0 |
| 2014-10-02 04:45:00 | SPY | ETF | 194.16 | 194.16 | 194.15 | 194.15 | 300.0 |
| 2014-10-02 04:50:00 | SPY | ETF | 194.13 | 194.19 | 194.13 | 194.19 | 658.0 |
| 2014-10-02 04:55:00 | SPY | ETF | 194.21 | 194.21 | 194.2 | 194.2 | 300.0 |
| 2014-10-02 05:00:00 | SPY | ETF | 194.29 | 194.31 | 194.29 | 194.3 | 1100.0 |
| 2014-10-02 05:05:00 | SPY | ETF | 194.27 | 194.27 | 194.27 | 194.27 | 109.0 |
| 2014-10-02 05:20:00 | SPY | ETF | 194.29 | 194.29 | 194.29 | 194.29 | 166.0 |
| 2014-10-02 05:25:00 | SPY | ETF | 194.4 | 194.4 | 194.36 | 194.4 | 554.0 |
| 2014-10-02 05:30:00 | SPY | ETF | 194.3 | 194.3 | 194.28 | 194.3 | 3200.0 |
| 2014-10-02 05:40:00 | SPY | ETF | 194.43 | 194.43 | 194.43 | 194.43 | 500.0 |
| 2014-10-02 05:45:00 | SPY | ETF | 194.43 | 194.45 | 194.43 | 194.45 | 888.0 |
| 2014-10-02 05:50:00 | SPY | ETF | 194.44 | 194.48 | 194.44 | 194.48 | 5700.0 |
| 2014-10-02 06:00:00 | SPY | ETF | 194.45 | 194.45 | 194.45 | 194.45 | 100.0 |
| 2014-10-02 06:05:00 | SPY | ETF | 194.43 | 194.43 | 194.39 | 194.39 | 6400.0 |
| 2014-10-02 06:10:00 | SPY | ETF | 194.34 | 194.39 | 194.34 | 194.39 | 10144.0 |
| 2014-10-02 06:15:00 | SPY | ETF | 194.41 | 194.47 | 194.41 | 194.47 | 200.0 |
| 2014-10-02 06:20:00 | SPY | ETF | 194.44 | 194.5 | 194.44 | 194.5 | 2200.0 |
| 2014-10-02 06:30:00 | SPY | ETF | 194.45 | 194.46 | 194.45 | 194.46 | 10217.0 |
| 2014-10-02 06:35:00 | SPY | ETF | 194.46 | 194.55 | 194.46 | 194.55 | 15600.0 |
| 2014-10-02 06:40:00 | SPY | ETF | 194.48 | 194.48 | 194.48 | 194.48 | 25000.0 |
| 2014-10-02 06:45:00 | SPY | ETF | 194.48 | 194.48 | 194.48 | 194.48 | 100.0 |
| 2014-10-02 06:55:00 | SPY | ETF | 194.62 | 194.7 | 194.56 | 194.58 | 29420.0 |
| 2014-10-02 07:00:00 | SPY | ETF | 194.58 | 194.7 | 194.58 | 194.7 | 17700.0 |
| 2014-10-02 07:05:00 | SPY | ETF | 194.63 | 194.8 | 194.63 | 194.72 | 28833.0 |
| 2014-10-02 07:10:00 | SPY | ETF | 194.69 | 194.83 | 194.69 | 194.83 | 64700.0 |
| 2014-10-02 07:15:00 | SPY | ETF | 194.82 | 194.85 | 194.64 | 194.74 | 111916.0 |
| 2014-10-02 07:20:00 | SPY | ETF | 194.77 | 194.88 | 194.77 | 194.88 | 37100.0 |
| 2014-10-02 07:25:00 | SPY | ETF | 194.9 | 194.93 | 194.87 | 194.93 | 13500.0 |
| 2014-10-02 07:30:00 | SPY | ETF | 194.9 | 194.93 | 194.85 | 194.9 | 191311.0 |
| 2014-10-02 07:35:00 | SPY | ETF | 194.93 | 194.93 | 194.85 | 194.85 | 19165.0 |
| 2014-10-02 07:40:00 | SPY | ETF | 194.92 | 194.95 | 194.81 | 194.95 | 31567.0 |
| 2014-10-02 07:45:00 | SPY | ETF | 194.87 | 194.87 | 194.74 | 194.77 | 38781.0 |
| 2014-10-02 07:50:00 | SPY | ETF | 194.77 | 194.85 | 194.76 | 194.85 | 56741.0 |
| 2014-10-02 07:55:00 | SPY | ETF | 194.88 | 194.89 | 194.76 | 194.76 | 55049.0 |
| 2014-10-02 08:00:00 | SPY | ETF | 194.74 | 194.9 | 194.63 | 194.76 | 71708.0 |
| 2014-10-02 08:05:00 | SPY | ETF | 194.8 | 194.84 | 194.79 | 194.82 | 17235.0 |
| 2014-10-02 08:10:00 | SPY | ETF | 194.8 | 194.8 | 194.76 | 194.79 | 9500.0 |
| 2014-10-02 08:15:00 | SPY | ETF | 194.85 | 194.86 | 194.8 | 194.8 | 7740.0 |
| 2014-10-02 08:20:00 | SPY | ETF | 194.8 | 194.84 | 194.8 | 194.83 | 105967.0 |
| 2014-10-02 08:25:00 | SPY | ETF | 194.84 | 194.9 | 194.78 | 194.81 | 66087.0 |
| 2014-10-02 08:30:00 | SPY | ETF | 194.8 | 194.87 | 194.78 | 194.78 | 70241.0 |
| 2014-10-02 08:35:00 | SPY | ETF | 194.78 | 194.99 | 194.76 | 194.95 | 242708.0 |
| 2014-10-02 08:40:00 | SPY | ETF | 194.95 | 195.07 | 194.41 | 194.48 | 608524.0 |
| 2014-10-02 08:45:00 | SPY | ETF | 194.47 | 194.56 | 194.26 | 194.43 | 301772.0 |
| 2014-10-02 08:50:00 | SPY | ETF | 194.45 | 194.59 | 194.43 | 194.56 | 327621.0 |
| 2014-10-02 08:55:00 | SPY | ETF | 194.58 | 194.69 | 194.46 | 194.48 | 137378.0 |
| 2014-10-02 09:00:00 | SPY | ETF | 194.46 | 194.55 | 194.37 | 194.37 | 205433.0 |
> showing 50 of 48,591 rows — these rows as CSV