PREVIEW / etf_1min / 2016-07-28
file: by_date/etf_1min/2016/2016-07-28.parquet size: 2.5 MB rows: 128,653
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 |
|---|---|---|---|---|---|---|---|
| 2016-07-28 04:00:00 | SPY | ETF | 216.88 | 216.88 | 216.88 | 216.88 | 110.0 |
| 2016-07-28 04:01:00 | SPY | ETF | 216.82 | 216.84 | 216.82 | 216.84 | 435.0 |
| 2016-07-28 04:02:00 | SPY | ETF | 216.89 | 216.89 | 216.89 | 216.89 | 600.0 |
| 2016-07-28 04:03:00 | SPY | ETF | 216.97 | 216.97 | 216.97 | 216.97 | 100.0 |
| 2016-07-28 04:07:00 | SPY | ETF | 216.92 | 216.92 | 216.92 | 216.92 | 202.0 |
| 2016-07-28 04:09:00 | SPY | ETF | 216.93 | 216.97 | 216.93 | 216.97 | 200.0 |
| 2016-07-28 04:13:00 | SPY | ETF | 216.96 | 216.96 | 216.96 | 216.96 | 1301.0 |
| 2016-07-28 04:16:00 | SPY | ETF | 216.91 | 216.91 | 216.91 | 216.91 | 302.0 |
| 2016-07-28 04:26:00 | SPY | ETF | 216.93 | 216.93 | 216.93 | 216.93 | 502.0 |
| 2016-07-28 04:27:00 | SPY | ETF | 216.91 | 216.91 | 216.91 | 216.91 | 5000.0 |
| 2016-07-28 04:32:00 | SPY | ETF | 216.9 | 216.9 | 216.9 | 216.9 | 1001.0 |
| 2016-07-28 04:33:00 | SPY | ETF | 216.9 | 216.9 | 216.9 | 216.9 | 900.0 |
| 2016-07-28 04:42:00 | SPY | ETF | 216.86 | 216.86 | 216.86 | 216.86 | 300.0 |
| 2016-07-28 04:43:00 | SPY | ETF | 216.86 | 216.86 | 216.86 | 216.86 | 500.0 |
| 2016-07-28 04:45:00 | SPY | ETF | 216.86 | 216.86 | 216.86 | 216.86 | 301.0 |
| 2016-07-28 04:50:00 | SPY | ETF | 216.86 | 216.86 | 216.86 | 216.86 | 102.0 |
| 2016-07-28 04:57:00 | SPY | ETF | 216.91 | 216.91 | 216.91 | 216.91 | 401.0 |
| 2016-07-28 05:03:00 | SPY | ETF | 216.88 | 216.88 | 216.88 | 216.88 | 302.0 |
| 2016-07-28 05:04:00 | SPY | ETF | 216.91 | 216.91 | 216.91 | 216.91 | 200.0 |
| 2016-07-28 05:07:00 | SPY | ETF | 216.86 | 216.86 | 216.86 | 216.86 | 4002.0 |
| 2016-07-28 05:08:00 | SPY | ETF | 216.86 | 216.86 | 216.86 | 216.86 | 11002.0 |
| 2016-07-28 05:10:00 | SPY | ETF | 216.84 | 216.84 | 216.83 | 216.83 | 601.0 |
| 2016-07-28 05:14:00 | SPY | ETF | 216.89 | 216.89 | 216.89 | 216.89 | 303.0 |
| 2016-07-28 05:20:00 | SPY | ETF | 216.8 | 216.8 | 216.76 | 216.76 | 403.0 |
| 2016-07-28 05:26:00 | SPY | ETF | 216.7 | 216.71 | 216.7 | 216.71 | 1600.0 |
| 2016-07-28 05:28:00 | SPY | ETF | 216.75 | 216.75 | 216.75 | 216.75 | 603.0 |
| 2016-07-28 05:38:00 | SPY | ETF | 216.76 | 216.76 | 216.76 | 216.76 | 100.0 |
| 2016-07-28 05:53:00 | SPY | ETF | 216.78 | 216.78 | 216.78 | 216.78 | 300.0 |
| 2016-07-28 05:57:00 | SPY | ETF | 216.8 | 216.8 | 216.8 | 216.8 | 209.0 |
| 2016-07-28 06:02:00 | SPY | ETF | 216.69 | 216.74 | 216.69 | 216.74 | 1503.0 |
| 2016-07-28 06:03:00 | SPY | ETF | 216.71 | 216.71 | 216.71 | 216.71 | 101.0 |
| 2016-07-28 06:05:00 | SPY | ETF | 216.68 | 216.68 | 216.68 | 216.68 | 300.0 |
| 2016-07-28 06:11:00 | SPY | ETF | 216.74 | 216.74 | 216.74 | 216.74 | 202.0 |
| 2016-07-28 06:14:00 | SPY | ETF | 216.71 | 216.71 | 216.71 | 216.71 | 1400.0 |
| 2016-07-28 06:36:00 | SPY | ETF | 216.69 | 216.69 | 216.66 | 216.66 | 1202.0 |
| 2016-07-28 06:37:00 | SPY | ETF | 216.68 | 216.68 | 216.68 | 216.68 | 1000.0 |
| 2016-07-28 06:41:00 | SPY | ETF | 216.7 | 216.7 | 216.66 | 216.66 | 1008.0 |
| 2016-07-28 06:42:00 | SPY | ETF | 216.64 | 216.64 | 216.64 | 216.64 | 402.0 |
| 2016-07-28 06:45:00 | SPY | ETF | 216.64 | 216.64 | 216.63 | 216.63 | 2102.0 |
| 2016-07-28 06:55:00 | SPY | ETF | 216.52 | 216.52 | 216.52 | 216.52 | 201.0 |
| 2016-07-28 06:56:00 | SPY | ETF | 216.55 | 216.55 | 216.53 | 216.53 | 303.0 |
| 2016-07-28 06:57:00 | SPY | ETF | 216.53 | 216.53 | 216.53 | 216.53 | 349.0 |
| 2016-07-28 06:59:00 | SPY | ETF | 216.56 | 216.56 | 216.56 | 216.56 | 100.0 |
| 2016-07-28 07:01:00 | SPY | ETF | 216.6 | 216.6 | 216.6 | 216.6 | 201.0 |
| 2016-07-28 07:03:00 | SPY | ETF | 216.52 | 216.54 | 216.5 | 216.54 | 3804.0 |
| 2016-07-28 07:04:00 | SPY | ETF | 216.5 | 216.52 | 216.5 | 216.52 | 1261.0 |
| 2016-07-28 07:06:00 | SPY | ETF | 216.42 | 216.44 | 216.41 | 216.43 | 19951.0 |
| 2016-07-28 07:07:00 | SPY | ETF | 216.44 | 216.44 | 216.44 | 216.44 | 3500.0 |
| 2016-07-28 07:09:00 | SPY | ETF | 216.43 | 216.44 | 216.43 | 216.44 | 550.0 |
| 2016-07-28 07:10:00 | SPY | ETF | 216.38 | 216.38 | 216.38 | 216.38 | 3601.0 |
> showing 50 of 128,653 rows — these rows as CSV