PREVIEW / etf_5min / 2015-09-28
file: by_date/etf_5min/2015/2015-09-28.parquet size: 1.2 MB rows: 50,733
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-09-28 04:00:00 | SPY | ETF | 193.02 | 193.17 | 193.02 | 193.15 | 2662.0 |
| 2015-09-28 04:05:00 | SPY | ETF | 193.24 | 193.25 | 193.09 | 193.19 | 4330.0 |
| 2015-09-28 04:15:00 | SPY | ETF | 193.23 | 193.28 | 193.23 | 193.28 | 5500.0 |
| 2015-09-28 04:20:00 | SPY | ETF | 193.24 | 193.26 | 193.2 | 193.2 | 622.0 |
| 2015-09-28 04:30:00 | SPY | ETF | 192.73 | 192.76 | 192.65 | 192.69 | 90500.0 |
| 2015-09-28 04:35:00 | SPY | ETF | 192.69 | 192.69 | 192.45 | 192.45 | 88975.0 |
| 2015-09-28 04:40:00 | SPY | ETF | 192.34 | 192.41 | 192.16 | 192.26 | 4156.0 |
| 2015-09-28 04:45:00 | SPY | ETF | 192.21 | 192.46 | 192.21 | 192.41 | 1410.0 |
| 2015-09-28 04:50:00 | SPY | ETF | 192.41 | 192.48 | 192.4 | 192.48 | 2100.0 |
| 2015-09-28 04:55:00 | SPY | ETF | 192.43 | 192.43 | 192.33 | 192.35 | 42566.0 |
| 2015-09-28 05:00:00 | SPY | ETF | 192.4 | 192.45 | 192.4 | 192.43 | 59706.0 |
| 2015-09-28 05:05:00 | SPY | ETF | 192.32 | 192.34 | 192.14 | 192.14 | 73247.0 |
| 2015-09-28 05:10:00 | SPY | ETF | 192.12 | 192.16 | 192.1 | 192.12 | 3530.0 |
| 2015-09-28 05:15:00 | SPY | ETF | 192.02 | 192.05 | 191.85 | 191.85 | 3112.0 |
| 2015-09-28 05:20:00 | SPY | ETF | 191.85 | 192.06 | 191.85 | 192.02 | 1000.0 |
| 2015-09-28 05:25:00 | SPY | ETF | 191.95 | 191.99 | 191.95 | 191.99 | 610.0 |
| 2015-09-28 05:30:00 | SPY | ETF | 192.02 | 192.02 | 191.8 | 191.8 | 1200.0 |
| 2015-09-28 05:35:00 | SPY | ETF | 191.77 | 191.77 | 191.67 | 191.67 | 645.0 |
| 2015-09-28 05:40:00 | SPY | ETF | 191.67 | 191.84 | 191.67 | 191.84 | 400.0 |
| 2015-09-28 05:45:00 | SPY | ETF | 191.82 | 191.95 | 191.82 | 191.94 | 2799.0 |
| 2015-09-28 05:50:00 | SPY | ETF | 191.95 | 192.01 | 191.84 | 191.84 | 4203.0 |
| 2015-09-28 05:55:00 | SPY | ETF | 191.77 | 191.86 | 191.7 | 191.7 | 3551.0 |
| 2015-09-28 06:00:00 | SPY | ETF | 191.79 | 191.87 | 191.79 | 191.87 | 502.0 |
| 2015-09-28 06:05:00 | SPY | ETF | 191.99 | 191.99 | 191.9 | 191.9 | 22005.0 |
| 2015-09-28 06:10:00 | SPY | ETF | 191.81 | 191.81 | 191.8 | 191.8 | 500.0 |
| 2015-09-28 06:15:00 | SPY | ETF | 191.77 | 191.77 | 191.58 | 191.63 | 7693.0 |
| 2015-09-28 06:20:00 | SPY | ETF | 191.66 | 191.68 | 191.44 | 191.51 | 28952.0 |
| 2015-09-28 06:25:00 | SPY | ETF | 191.48 | 191.48 | 191.39 | 191.41 | 128495.0 |
| 2015-09-28 06:30:00 | SPY | ETF | 191.41 | 191.45 | 191.27 | 191.27 | 60655.0 |
| 2015-09-28 06:35:00 | SPY | ETF | 191.25 | 191.3 | 191.13 | 191.2 | 8298.0 |
| 2015-09-28 06:40:00 | SPY | ETF | 191.15 | 191.28 | 191.1 | 191.23 | 120987.0 |
| 2015-09-28 06:45:00 | SPY | ETF | 191.3 | 191.32 | 191.3 | 191.3 | 89388.0 |
| 2015-09-28 06:50:00 | SPY | ETF | 191.3 | 191.38 | 191.3 | 191.32 | 28282.0 |
| 2015-09-28 06:55:00 | SPY | ETF | 191.26 | 191.29 | 191.22 | 191.29 | 20900.0 |
| 2015-09-28 07:00:00 | SPY | ETF | 191.32 | 191.4 | 191.32 | 191.39 | 96611.0 |
| 2015-09-28 07:05:00 | SPY | ETF | 191.43 | 191.6 | 191.4 | 191.5 | 18085.0 |
| 2015-09-28 07:10:00 | SPY | ETF | 191.49 | 191.57 | 191.44 | 191.57 | 11794.0 |
| 2015-09-28 07:15:00 | SPY | ETF | 191.54 | 191.61 | 191.42 | 191.61 | 44043.0 |
| 2015-09-28 07:20:00 | SPY | ETF | 191.59 | 191.73 | 191.54 | 191.73 | 25195.0 |
| 2015-09-28 07:25:00 | SPY | ETF | 191.7 | 191.85 | 191.65 | 191.85 | 20776.0 |
| 2015-09-28 07:30:00 | SPY | ETF | 191.82 | 191.89 | 191.65 | 191.69 | 55998.0 |
| 2015-09-28 07:35:00 | SPY | ETF | 191.69 | 191.79 | 191.34 | 191.37 | 22990.0 |
| 2015-09-28 07:40:00 | SPY | ETF | 191.37 | 191.39 | 191.18 | 191.34 | 48179.0 |
| 2015-09-28 07:45:00 | SPY | ETF | 191.31 | 191.38 | 190.98 | 191.06 | 119211.0 |
| 2015-09-28 07:50:00 | SPY | ETF | 191.09 | 191.47 | 191.09 | 191.37 | 69318.0 |
| 2015-09-28 07:55:00 | SPY | ETF | 191.38 | 191.41 | 191.27 | 191.27 | 28769.0 |
| 2015-09-28 08:00:00 | SPY | ETF | 191.28 | 191.79 | 191.16 | 191.39 | 248282.0 |
| 2015-09-28 08:05:00 | SPY | ETF | 191.44 | 191.52 | 191.38 | 191.42 | 27767.0 |
| 2015-09-28 08:10:00 | SPY | ETF | 191.4 | 191.6 | 191.4 | 191.54 | 50838.0 |
| 2015-09-28 08:15:00 | SPY | ETF | 191.57 | 191.781 | 191.41 | 191.55 | 37411.0 |
> showing 50 of 50,733 rows — these rows as CSV