PREVIEW / etf_1hour / 2014-07-11

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-07-11.parquet
  size:    221 KB
  rows:    7,215

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-07-11 04:00:00	SPY	ETF	196.75	196.79	196.67	196.71	7291.0
2014-07-11 05:00:00	SPY	ETF	196.69	196.7	196.59	196.65	6003.0
2014-07-11 06:00:00	SPY	ETF	196.65	196.72	196.43	196.47	43521.0
2014-07-11 07:00:00	SPY	ETF	196.49	196.67	196.49	196.67	143096.0
2014-07-11 08:00:00	SPY	ETF	196.65	196.68	196.2	196.23	1088180.0
2014-07-11 09:00:00	SPY	ETF	196.22	196.47	195.78	196.08	10577594.0
2014-07-11 10:00:00	SPY	ETF	196.09	196.46	195.9	196.16	10096986.0
2014-07-11 11:00:00	SPY	ETF	196.17	196.28	195.91	196.06	7225466.0
2014-07-11 12:00:00	SPY	ETF	196.065	196.205	195.98	196.165	4992199.0
2014-07-11 13:00:00	SPY	ETF	196.165	196.44	196.165	196.35	4842129.0
2014-07-11 14:00:00	SPY	ETF	196.35	196.62	196.35	196.48	5821577.0
2014-07-11 15:00:00	SPY	ETF	196.48	196.75	196.42	196.59	11469429.0
2014-07-11 16:00:00	SPY	ETF	196.61	196.75	196.0	196.74	6049370.0
2014-07-11 17:00:00	SPY	ETF	196.74	196.75	196.61	196.64	1339446.0
2014-07-11 18:00:00	SPY	ETF	196.7	196.72	196.69	196.69	1977.0
2014-07-11 19:00:00	SPY	ETF	196.67	196.7	196.65	196.7	9199.0
2014-07-11 04:00:00	QQQ	ETF	94.88	95.04	94.88	95.04	2500.0
2014-07-11 05:00:00	QQQ	ETF	94.94	94.94	94.94	94.94	100.0
2014-07-11 06:00:00	QQQ	ETF	94.9	94.9	94.89	94.9	700.0
2014-07-11 07:00:00	QQQ	ETF	94.9	94.98	94.85	94.96	37850.0
2014-07-11 08:00:00	QQQ	ETF	94.96	94.96	94.78	94.79	151139.0
2014-07-11 09:00:00	QQQ	ETF	94.78	95.03	94.61	94.87	4018290.0
2014-07-11 10:00:00	QQQ	ETF	94.87	95.07	94.7881	95.02	3358217.0
2014-07-11 11:00:00	QQQ	ETF	95.02	95.07	94.8373	94.9099	2522971.0
2014-07-11 12:00:00	QQQ	ETF	94.9	94.98	94.8801	94.95	904572.0
2014-07-11 13:00:00	QQQ	ETF	94.9623	95.23	94.9601	95.15	2297706.0
2014-07-11 14:00:00	QQQ	ETF	95.16	95.26	95.14	95.17	1597118.0
2014-07-11 15:00:00	QQQ	ETF	95.17	95.27	95.12	95.25	3332181.0
2014-07-11 16:00:00	QQQ	ETF	95.26	95.27	94.8075	95.26	956742.0
2014-07-11 17:00:00	QQQ	ETF	95.26	95.27	95.21	95.21	6435.0
2014-07-11 18:00:00	QQQ	ETF	95.24	95.24	95.21	95.21	845.0
2014-07-11 19:00:00	QQQ	ETF	95.23	95.27	95.23	95.25	3200.0
2014-07-11 04:00:00	IWM	ETF	116.0	116.0	116.0	116.0	300.0
2014-07-11 06:00:00	IWM	ETF	115.75	115.79	115.75	115.79	235.0
2014-07-11 07:00:00	IWM	ETF	115.6	115.62	115.59	115.59	14940.0
2014-07-11 08:00:00	IWM	ETF	115.63	115.64	115.12	115.14	151406.0
2014-07-11 09:00:00	IWM	ETF	115.13	115.35	114.57	114.99	6144438.0
2014-07-11 10:00:00	IWM	ETF	114.97	115.38	114.78	114.86	5747228.0
2014-07-11 11:00:00	IWM	ETF	114.86	115.0	114.51	114.73	4944684.0
2014-07-11 12:00:00	IWM	ETF	114.73	114.94	114.635	114.9	1965827.0
2014-07-11 13:00:00	IWM	ETF	114.91	115.15	114.8932	115.03	2234932.0
2014-07-11 14:00:00	IWM	ETF	115.035	115.33	115.015	115.21	2291011.0
2014-07-11 15:00:00	IWM	ETF	115.2	115.3	115.03	115.12	4161148.0
2014-07-11 16:00:00	IWM	ETF	115.1201	115.14	114.6992	115.07	1358755.0
2014-07-11 17:00:00	IWM	ETF	115.09	115.12	115.01	115.01	10400.0
2014-07-11 08:00:00	DIA	ETF	169.2	169.3	168.9	168.9	3575.0
2014-07-11 09:00:00	DIA	ETF	168.74	168.96	168.3201	168.5656	667581.0
2014-07-11 10:00:00	DIA	ETF	168.55	168.895	168.4	168.64	428865.0
2014-07-11 11:00:00	DIA	ETF	168.65	168.74	168.42	168.6	262856.0
2014-07-11 12:00:00	DIA	ETF	168.59	168.73	168.53	168.69	140568.0

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

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