PREVIEW / etf_5min / 2014-09-02
file: by_date/etf_5min/2014/2014-09-02.parquet size: 1.0 MB rows: 44,331
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-09-02 04:00:00 | SPY | ETF | 200.91 | 201.0 | 200.91 | 201.0 | 2945.0 |
| 2014-09-02 04:05:00 | SPY | ETF | 201.1 | 201.1 | 201.1 | 201.1 | 976.0 |
| 2014-09-02 04:10:00 | SPY | ETF | 201.15 | 201.15 | 200.92 | 200.92 | 1706.0 |
| 2014-09-02 04:15:00 | SPY | ETF | 201.11 | 201.11 | 201.11 | 201.11 | 100.0 |
| 2014-09-02 04:20:00 | SPY | ETF | 201.1 | 201.14 | 201.1 | 201.13 | 745.0 |
| 2014-09-02 04:55:00 | SPY | ETF | 201.18 | 201.18 | 201.18 | 201.18 | 248.0 |
| 2014-09-02 05:10:00 | SPY | ETF | 201.15 | 201.15 | 201.15 | 201.15 | 202.0 |
| 2014-09-02 05:20:00 | SPY | ETF | 201.08 | 201.1 | 201.08 | 201.1 | 250.0 |
| 2014-09-02 05:25:00 | SPY | ETF | 201.08 | 201.08 | 201.08 | 201.08 | 375.0 |
| 2014-09-02 05:30:00 | SPY | ETF | 201.08 | 201.08 | 201.08 | 201.08 | 100.0 |
| 2014-09-02 05:55:00 | SPY | ETF | 201.08 | 201.08 | 201.08 | 201.08 | 500.0 |
| 2014-09-02 06:00:00 | SPY | ETF | 201.08 | 201.08 | 201.08 | 201.08 | 200.0 |
| 2014-09-02 06:05:00 | SPY | ETF | 201.08 | 201.08 | 201.08 | 201.08 | 865.0 |
| 2014-09-02 06:10:00 | SPY | ETF | 201.07 | 201.13 | 201.07 | 201.13 | 3319.0 |
| 2014-09-02 06:15:00 | SPY | ETF | 201.14 | 201.14 | 201.14 | 201.14 | 100.0 |
| 2014-09-02 06:20:00 | SPY | ETF | 201.13 | 201.15 | 201.13 | 201.15 | 1054.0 |
| 2014-09-02 06:25:00 | SPY | ETF | 201.14 | 201.15 | 201.14 | 201.15 | 12228.0 |
| 2014-09-02 06:35:00 | SPY | ETF | 201.07 | 201.07 | 201.07 | 201.07 | 120.0 |
| 2014-09-02 06:40:00 | SPY | ETF | 201.09 | 201.12 | 201.09 | 201.12 | 850.0 |
| 2014-09-02 06:45:00 | SPY | ETF | 201.12 | 201.13 | 201.1 | 201.13 | 13500.0 |
| 2014-09-02 06:50:00 | SPY | ETF | 201.09 | 201.1 | 201.08 | 201.1 | 5825.0 |
| 2014-09-02 06:55:00 | SPY | ETF | 201.1 | 201.1 | 201.07 | 201.07 | 5500.0 |
| 2014-09-02 07:00:00 | SPY | ETF | 201.07 | 201.11 | 201.05 | 201.07 | 11675.0 |
| 2014-09-02 07:05:00 | SPY | ETF | 201.1 | 201.1 | 201.07 | 201.08 | 61000.0 |
| 2014-09-02 07:10:00 | SPY | ETF | 201.07 | 201.08 | 201.0 | 201.02 | 23800.0 |
| 2014-09-02 07:15:00 | SPY | ETF | 200.97 | 200.97 | 200.88 | 200.93 | 18210.0 |
| 2014-09-02 07:20:00 | SPY | ETF | 200.91 | 200.97 | 200.9 | 200.96 | 21135.0 |
| 2014-09-02 07:25:00 | SPY | ETF | 200.92 | 200.93 | 200.9 | 200.9 | 2250.0 |
| 2014-09-02 07:30:00 | SPY | ETF | 200.96 | 200.96 | 200.85 | 200.85 | 8500.0 |
| 2014-09-02 07:35:00 | SPY | ETF | 200.87 | 200.9 | 200.87 | 200.88 | 13648.0 |
| 2014-09-02 07:40:00 | SPY | ETF | 200.86 | 200.86 | 200.82 | 200.84 | 8700.0 |
| 2014-09-02 07:45:00 | SPY | ETF | 200.82 | 200.83 | 200.75 | 200.83 | 35580.0 |
| 2014-09-02 07:50:00 | SPY | ETF | 200.83 | 200.85 | 200.83 | 200.85 | 705.0 |
| 2014-09-02 07:55:00 | SPY | ETF | 200.87 | 200.88 | 200.85 | 200.88 | 16258.0 |
| 2014-09-02 08:00:00 | SPY | ETF | 201.07 | 201.07 | 200.7809 | 201.01 | 81089.0 |
| 2014-09-02 08:05:00 | SPY | ETF | 200.92 | 200.93 | 200.9 | 200.93 | 21950.0 |
| 2014-09-02 08:10:00 | SPY | ETF | 200.93 | 200.99 | 200.93 | 200.97 | 49945.0 |
| 2014-09-02 08:15:00 | SPY | ETF | 200.99 | 201.0 | 200.95 | 200.95 | 76000.0 |
| 2014-09-02 08:20:00 | SPY | ETF | 200.96 | 200.98 | 200.95 | 200.96 | 29650.0 |
| 2014-09-02 08:25:00 | SPY | ETF | 200.95 | 200.97 | 200.95 | 200.97 | 7600.0 |
| 2014-09-02 08:30:00 | SPY | ETF | 200.98 | 200.98 | 200.86 | 200.87 | 46660.0 |
| 2014-09-02 08:35:00 | SPY | ETF | 200.86 | 200.89 | 200.82 | 200.89 | 25715.0 |
| 2014-09-02 08:40:00 | SPY | ETF | 200.89 | 200.92 | 200.88 | 200.89 | 29300.0 |
| 2014-09-02 08:45:00 | SPY | ETF | 200.9 | 200.95 | 200.89 | 200.93 | 16078.0 |
| 2014-09-02 08:50:00 | SPY | ETF | 200.92 | 200.93 | 200.9 | 200.9 | 11700.0 |
| 2014-09-02 08:55:00 | SPY | ETF | 200.9 | 200.9 | 200.81 | 200.82 | 56148.0 |
| 2014-09-02 09:00:00 | SPY | ETF | 200.83 | 200.89 | 200.83 | 200.87 | 26987.0 |
| 2014-09-02 09:05:00 | SPY | ETF | 200.87 | 200.95 | 200.87 | 200.94 | 47001.0 |
| 2014-09-02 09:10:00 | SPY | ETF | 200.95 | 201.09 | 200.94 | 201.08 | 119652.0 |
| 2014-09-02 09:15:00 | SPY | ETF | 201.08 | 201.08 | 200.99 | 201.03 | 124401.0 |
> showing 50 of 44,331 rows — these rows as CSV