PREVIEW / etf_1hour / 2014-05-15

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-05-15.parquet
  size:    219 KB
  rows:    6,916

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-05-15 04:00:00	SPY	ETF	189.16	189.16	188.85	188.94	11790.0
2014-05-15 05:00:00	SPY	ETF	188.94	189.02	188.88	188.92	11312.0
2014-05-15 06:00:00	SPY	ETF	188.88	189.04	188.84	188.96	18967.0
2014-05-15 07:00:00	SPY	ETF	188.96	188.96	188.67	188.78	451016.0
2014-05-15 08:00:00	SPY	ETF	188.82	189.03	188.67	188.82	1424841.0
2014-05-15 09:00:00	SPY	ETF	188.82	188.82	187.62	187.97	16877072.0
2014-05-15 10:00:00	SPY	ETF	187.97	187.98	186.99	187.24	37060922.0
2014-05-15 11:00:00	SPY	ETF	187.25	187.34	186.48	186.57	19588536.0
2014-05-15 12:00:00	SPY	ETF	186.57	187.07	186.53	187.02	11972334.0
2014-05-15 13:00:00	SPY	ETF	187.02	187.051	186.63	186.97	12197613.0
2014-05-15 14:00:00	SPY	ETF	186.97	187.45	186.821	187.34	21308262.0
2014-05-15 15:00:00	SPY	ETF	187.34	187.54	187.01	187.38	23336002.0
2014-05-15 16:00:00	SPY	ETF	187.38	189.1194	187.14	187.29	9646546.0
2014-05-15 17:00:00	SPY	ETF	187.28	187.3	187.23	187.29	106701.0
2014-05-15 18:00:00	SPY	ETF	187.3	187.4	187.26	187.26	46467.0
2014-05-15 19:00:00	SPY	ETF	187.3	187.35	187.29	187.33	10797.0
2014-05-15 04:00:00	QQQ	ETF	87.84	87.84	87.84	87.84	160.0
2014-05-15 05:00:00	QQQ	ETF	88.0	88.03	88.0	88.03	4700.0
2014-05-15 06:00:00	QQQ	ETF	87.95	88.01	87.94	88.01	2100.0
2014-05-15 07:00:00	QQQ	ETF	87.94	87.97	87.75	87.84	52664.0
2014-05-15 08:00:00	QQQ	ETF	87.95	87.99	87.77	87.84	247927.0
2014-05-15 09:00:00	QQQ	ETF	87.86	87.96	87.2	87.46	8466129.0
2014-05-15 10:00:00	QQQ	ETF	87.45	87.47	86.73	87.04	11628446.0
2014-05-15 11:00:00	QQQ	ETF	87.04	87.09	86.58	86.65	5257225.0
2014-05-15 12:00:00	QQQ	ETF	86.65	86.98	86.6301	86.92	4096156.0
2014-05-15 13:00:00	QQQ	ETF	86.929	86.97	86.75	86.93	3243126.0
2014-05-15 14:00:00	QQQ	ETF	86.93	87.34	86.86	87.275	5366236.0
2014-05-15 15:00:00	QQQ	ETF	87.28	87.33	87.04	87.14	7623843.0
2014-05-15 16:00:00	QQQ	ETF	87.14	87.8246	86.993	87.15	5386748.0
2014-05-15 17:00:00	QQQ	ETF	87.14	87.14	87.05	87.05	256721.0
2014-05-15 18:00:00	QQQ	ETF	87.11	87.19	87.11	87.17	32183.0
2014-05-15 19:00:00	QQQ	ETF	87.12	87.18	87.12	87.16	21130.0
2014-05-15 07:00:00	IWM	ETF	109.59	109.59	109.22	109.29	117453.0
2014-05-15 08:00:00	IWM	ETF	109.29	109.38	109.01	109.13	469714.0
2014-05-15 09:00:00	IWM	ETF	109.15	109.21	107.73	108.04	12100202.0
2014-05-15 10:00:00	IWM	ETF	108.035	108.2	107.44	108.04	14337347.0
2014-05-15 11:00:00	IWM	ETF	108.05	108.08	107.52	107.66	7213979.0
2014-05-15 12:00:00	IWM	ETF	107.65	108.24	107.54	108.18	4841459.0
2014-05-15 13:00:00	IWM	ETF	108.19	108.45	107.91	108.43	4013016.0
2014-05-15 14:00:00	IWM	ETF	108.43	108.995	108.24	108.78	7768056.0
2014-05-15 15:00:00	IWM	ETF	108.79	109.17	108.57	108.89	9705248.0
2014-05-15 16:00:00	IWM	ETF	108.88	109.6304	107.825	108.76	1890124.0
2014-05-15 17:00:00	IWM	ETF	108.73	108.89	108.72	108.8	69505.0
2014-05-15 18:00:00	IWM	ETF	108.82	108.88	108.8	108.88	5800.0
2014-05-15 19:00:00	IWM	ETF	108.81	108.81	108.77	108.78	10598.0
2014-05-15 04:00:00	DIA	ETF	166.16	166.16	166.1	166.1	300.0
2014-05-15 08:00:00	DIA	ETF	165.9	166.11	165.72	165.95	2855.0
2014-05-15 09:00:00	DIA	ETF	166.15	166.15	164.9677	165.25	1000801.0
2014-05-15 10:00:00	DIA	ETF	165.2	165.24	164.541	164.71	1820169.0
2014-05-15 11:00:00	DIA	ETF	164.71	164.78	164.14	164.26	1053951.0

> showing 50 of 6,916 rows — these rows as CSV

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