PREVIEW / etf_1hour / 2014-06-30

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-06-30.parquet
  size:    218 KB
  rows:    7,007

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-06-30 04:00:00	SPY	ETF	195.7	195.73	195.6	195.6	2037.0
2014-06-30 05:00:00	SPY	ETF	195.63	195.67	195.63	195.65	4596.0
2014-06-30 06:00:00	SPY	ETF	195.72	195.88	195.51	195.51	17081.0
2014-06-30 07:00:00	SPY	ETF	195.47	195.6	195.26	195.49	271837.0
2014-06-30 08:00:00	SPY	ETF	195.51	195.855	195.51	195.63	365202.0
2014-06-30 09:00:00	SPY	ETF	195.62	195.83	195.55	195.78	7609137.0
2014-06-30 10:00:00	SPY	ETF	195.78	196.165	195.69	195.73	10908934.0
2014-06-30 11:00:00	SPY	ETF	195.73	196.06	195.61	195.845	8232775.0
2014-06-30 12:00:00	SPY	ETF	195.84	195.95	195.775	195.87	4272786.0
2014-06-30 13:00:00	SPY	ETF	195.865	195.99	195.855	195.925	3374848.0
2014-06-30 14:00:00	SPY	ETF	195.93	196.1	195.75	195.77	6401631.0
2014-06-30 15:00:00	SPY	ETF	195.77	195.9	195.53	195.71	19593459.0
2014-06-30 16:00:00	SPY	ETF	195.7	195.97	195.69	195.92	8017714.0
2014-06-30 17:00:00	SPY	ETF	195.92	195.96	195.72	195.9	372177.0
2014-06-30 18:00:00	SPY	ETF	195.92	195.98	195.87	195.87	76671.0
2014-06-30 19:00:00	SPY	ETF	195.89	195.98	195.89	195.97	30090.0
2014-06-30 06:00:00	QQQ	ETF	93.66	93.66	93.6	93.63	2200.0
2014-06-30 07:00:00	QQQ	ETF	93.62	93.64	93.56	93.64	5400.0
2014-06-30 08:00:00	QQQ	ETF	93.67	93.74	93.67	93.7	113459.0
2014-06-30 09:00:00	QQQ	ETF	93.7	93.93	93.67	93.86	3862161.0
2014-06-30 10:00:00	QQQ	ETF	93.87	94.0	93.83	93.84	3632694.0
2014-06-30 11:00:00	QQQ	ETF	93.84	94.03	93.79	93.94	2293936.0
2014-06-30 12:00:00	QQQ	ETF	93.94	94.04	93.91	93.995	968791.0
2014-06-30 13:00:00	QQQ	ETF	93.99	94.1	93.98	94.06	1327310.0
2014-06-30 14:00:00	QQQ	ETF	94.06	94.14	93.93	93.935	1358578.0
2014-06-30 15:00:00	QQQ	ETF	93.94	94.03	93.84	93.9	4205531.0
2014-06-30 16:00:00	QQQ	ETF	93.91	94.05	93.9	94.02	1271404.0
2014-06-30 17:00:00	QQQ	ETF	94.03	94.05	93.91	93.97	85287.0
2014-06-30 18:00:00	QQQ	ETF	93.99	94.0	93.99	94.0	2770.0
2014-06-30 19:00:00	QQQ	ETF	94.0	94.03	94.0	94.03	10064.0
2014-06-30 04:00:00	IWM	ETF	118.11	118.11	117.9	117.9	800.0
2014-06-30 05:00:00	IWM	ETF	118.0	118.0	118.0	118.0	600.0
2014-06-30 06:00:00	IWM	ETF	118.0	118.0	117.9	117.9	200.0
2014-06-30 07:00:00	IWM	ETF	117.81	117.81	117.8	117.8	800.0
2014-06-30 08:00:00	IWM	ETF	117.98	118.12	117.98	117.99	90521.0
2014-06-30 09:00:00	IWM	ETF	117.99	118.33	117.83	118.06	4255492.0
2014-06-30 10:00:00	IWM	ETF	118.09	118.525	118.04	118.07	5115385.0
2014-06-30 11:00:00	IWM	ETF	118.07	118.45	117.9	118.395	2591852.0
2014-06-30 12:00:00	IWM	ETF	118.39	118.61	118.36	118.5	2077151.0
2014-06-30 13:00:00	IWM	ETF	118.5	118.63	118.43	118.61	2012963.0
2014-06-30 14:00:00	IWM	ETF	118.61	118.79	118.56	118.565	2516622.0
2014-06-30 15:00:00	IWM	ETF	118.56	118.88	118.51	118.81	8759755.0
2014-06-30 16:00:00	IWM	ETF	118.81	118.99	118.4554	118.99	2393336.0
2014-06-30 17:00:00	IWM	ETF	118.86	118.95	118.81	118.92	69011.0
2014-06-30 18:00:00	IWM	ETF	118.88	118.88	118.69	118.77	19591.0
2014-06-30 19:00:00	IWM	ETF	118.77	118.85	118.77	118.84	2750.0
2014-06-30 07:00:00	DIA	ETF	167.7	167.7	167.7	167.7	100.0
2014-06-30 08:00:00	DIA	ETF	168.07	168.07	168.05	168.05	3100.0
2014-06-30 09:00:00	DIA	ETF	167.94	168.01	167.65	167.83	1679705.0
2014-06-30 10:00:00	DIA	ETF	167.85	168.35	167.8	167.93	1883635.0

> showing 50 of 7,007 rows — these rows as CSV

> unlock the full archive -- $79 one-time