PREVIEW / etf_5min / 2015-06-12
file: by_date/etf_5min/2015/2015-06-12.parquet size: 1.0 MB rows: 44,458
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 |
|---|---|---|---|---|---|---|---|
| 2015-06-12 04:00:00 | SPY | ETF | 211.21 | 211.21 | 211.19 | 211.19 | 740.0 |
| 2015-06-12 04:05:00 | SPY | ETF | 211.19 | 211.19 | 211.03 | 211.04 | 670.0 |
| 2015-06-12 04:10:00 | SPY | ETF | 211.04 | 211.16 | 211.04 | 211.16 | 600.0 |
| 2015-06-12 04:15:00 | SPY | ETF | 211.16 | 211.16 | 211.16 | 211.16 | 1000.0 |
| 2015-06-12 04:20:00 | SPY | ETF | 211.03 | 211.03 | 210.96 | 210.96 | 785.0 |
| 2015-06-12 04:25:00 | SPY | ETF | 210.95 | 211.0 | 210.9 | 211.0 | 500.0 |
| 2015-06-12 04:40:00 | SPY | ETF | 211.2 | 211.2 | 211.18 | 211.18 | 1700.0 |
| 2015-06-12 04:50:00 | SPY | ETF | 211.16 | 211.16 | 211.03 | 211.03 | 27700.0 |
| 2015-06-12 05:00:00 | SPY | ETF | 210.95 | 210.95 | 210.95 | 210.95 | 27410.0 |
| 2015-06-12 05:05:00 | SPY | ETF | 211.02 | 211.1 | 211.02 | 211.08 | 2281.0 |
| 2015-06-12 05:10:00 | SPY | ETF | 211.07 | 211.08 | 211.07 | 211.07 | 6500.0 |
| 2015-06-12 05:15:00 | SPY | ETF | 211.08 | 211.12 | 211.08 | 211.12 | 500.0 |
| 2015-06-12 05:20:00 | SPY | ETF | 211.03 | 211.03 | 211.03 | 211.03 | 500.0 |
| 2015-06-12 05:25:00 | SPY | ETF | 211.0 | 211.0 | 211.0 | 211.0 | 100.0 |
| 2015-06-12 05:30:00 | SPY | ETF | 211.05 | 211.05 | 211.02 | 211.02 | 1100.0 |
| 2015-06-12 05:40:00 | SPY | ETF | 211.18 | 211.18 | 211.18 | 211.18 | 100.0 |
| 2015-06-12 05:45:00 | SPY | ETF | 211.26 | 211.38 | 211.17 | 211.38 | 2451.0 |
| 2015-06-12 05:50:00 | SPY | ETF | 211.38 | 211.45 | 211.33 | 211.45 | 2890.0 |
| 2015-06-12 06:00:00 | SPY | ETF | 211.28 | 211.28 | 211.28 | 211.28 | 120.0 |
| 2015-06-12 06:05:00 | SPY | ETF | 211.26 | 211.33 | 211.26 | 211.33 | 3220.0 |
| 2015-06-12 06:10:00 | SPY | ETF | 211.33 | 211.33 | 211.33 | 211.33 | 2000.0 |
| 2015-06-12 06:15:00 | SPY | ETF | 211.38 | 211.39 | 211.36 | 211.38 | 440.0 |
| 2015-06-12 06:20:00 | SPY | ETF | 211.4 | 211.48 | 211.4 | 211.45 | 3720.0 |
| 2015-06-12 06:30:00 | SPY | ETF | 211.32 | 211.32 | 211.32 | 211.32 | 200.0 |
| 2015-06-12 06:40:00 | SPY | ETF | 211.24 | 211.25 | 211.24 | 211.24 | 4000.0 |
| 2015-06-12 06:45:00 | SPY | ETF | 211.16 | 211.16 | 211.16 | 211.16 | 300.0 |
| 2015-06-12 06:50:00 | SPY | ETF | 211.08 | 211.08 | 211.08 | 211.08 | 200.0 |
| 2015-06-12 06:55:00 | SPY | ETF | 211.05 | 211.13 | 211.03 | 211.13 | 35100.0 |
| 2015-06-12 07:00:00 | SPY | ETF | 211.16 | 211.17 | 211.14 | 211.14 | 1100.0 |
| 2015-06-12 07:05:00 | SPY | ETF | 211.16 | 211.16 | 211.14 | 211.15 | 1280.0 |
| 2015-06-12 07:10:00 | SPY | ETF | 211.15 | 211.17 | 211.15 | 211.15 | 2963.0 |
| 2015-06-12 07:15:00 | SPY | ETF | 211.18 | 211.19 | 211.0 | 211.03 | 23230.0 |
| 2015-06-12 07:20:00 | SPY | ETF | 211.03 | 211.09 | 210.91 | 210.95 | 57350.0 |
| 2015-06-12 07:25:00 | SPY | ETF | 210.95 | 210.98 | 210.86 | 210.86 | 76315.0 |
| 2015-06-12 07:30:00 | SPY | ETF | 210.86 | 210.86 | 210.7 | 210.76 | 92606.0 |
| 2015-06-12 07:35:00 | SPY | ETF | 210.76 | 210.76 | 210.65 | 210.76 | 27985.0 |
| 2015-06-12 07:40:00 | SPY | ETF | 210.74 | 210.75 | 210.62 | 210.7 | 89520.0 |
| 2015-06-12 07:45:00 | SPY | ETF | 210.7 | 210.8 | 210.68 | 210.78 | 40297.0 |
| 2015-06-12 07:50:00 | SPY | ETF | 210.79 | 210.8 | 210.7 | 210.8 | 64943.0 |
| 2015-06-12 07:55:00 | SPY | ETF | 210.81 | 210.86 | 210.81 | 210.85 | 11295.0 |
| 2015-06-12 08:00:00 | SPY | ETF | 210.86 | 210.95 | 210.75 | 210.77 | 43253.0 |
| 2015-06-12 08:05:00 | SPY | ETF | 210.77 | 210.85 | 210.74 | 210.75 | 29736.0 |
| 2015-06-12 08:10:00 | SPY | ETF | 210.75 | 210.83 | 210.71 | 210.83 | 104951.0 |
| 2015-06-12 08:15:00 | SPY | ETF | 210.83 | 210.96 | 210.83 | 210.96 | 43488.0 |
| 2015-06-12 08:20:00 | SPY | ETF | 210.95 | 210.99 | 210.71 | 210.81 | 177964.0 |
| 2015-06-12 08:25:00 | SPY | ETF | 210.79 | 210.94 | 210.75 | 210.76 | 66632.0 |
| 2015-06-12 08:30:00 | SPY | ETF | 210.79 | 210.8 | 210.68 | 210.71 | 137196.0 |
| 2015-06-12 08:35:00 | SPY | ETF | 210.71 | 210.87 | 210.71 | 210.83 | 24506.0 |
| 2015-06-12 08:40:00 | SPY | ETF | 210.82 | 210.83 | 210.75 | 210.78 | 33006.0 |
| 2015-06-12 08:45:00 | SPY | ETF | 210.81 | 210.85 | 210.75 | 210.78 | 20187.0 |
> showing 50 of 44,458 rows — these rows as CSV