PREVIEW / etf_1hour / 2014-06-10

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-06-10.parquet
  size:    213 KB
  rows:    6,851

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-10 04:00:00	SPY	ETF	195.4	195.4	195.1	195.29	52486.0
2014-06-10 05:00:00	SPY	ETF	195.29	195.36	195.22	195.25	5310.0
2014-06-10 06:00:00	SPY	ETF	195.25	195.34	195.17	195.31	16405.0
2014-06-10 07:00:00	SPY	ETF	195.33	195.34	195.15	195.21	137826.0
2014-06-10 08:00:00	SPY	ETF	195.31	195.31	195.11	195.2	349408.0
2014-06-10 09:00:00	SPY	ETF	195.2	195.47	195.17	195.25	6818416.0
2014-06-10 10:00:00	SPY	ETF	195.24	195.49	194.92	195.44	10249789.0
2014-06-10 11:00:00	SPY	ETF	195.44	195.47	195.29	195.33	6691066.0
2014-06-10 12:00:00	SPY	ETF	195.32	195.34	195.13	195.28	4690326.0
2014-06-10 13:00:00	SPY	ETF	195.285	195.42	195.14	195.38	4787175.0
2014-06-10 14:00:00	SPY	ETF	195.38	195.49	195.32	195.35	6316471.0
2014-06-10 15:00:00	SPY	ETF	195.345	195.6	195.33	195.6	10779993.0
2014-06-10 16:00:00	SPY	ETF	195.61	195.72	195.2049	195.72	3306888.0
2014-06-10 17:00:00	SPY	ETF	195.73	195.75	195.56	195.64	1076367.0
2014-06-10 18:00:00	SPY	ETF	195.64	195.65	195.54	195.55	118680.0
2014-06-10 19:00:00	SPY	ETF	195.55	195.55	195.5	195.5	22589.0
2014-06-10 04:00:00	QQQ	ETF	92.56	93.37	92.52	93.25	51978.0
2014-06-10 06:00:00	QQQ	ETF	92.64	92.64	92.58	92.58	2500.0
2014-06-10 07:00:00	QQQ	ETF	92.59	92.63	92.57	92.57	17800.0
2014-06-10 08:00:00	QQQ	ETF	92.56	92.6	92.53	92.56	35700.0
2014-06-10 09:00:00	QQQ	ETF	92.57	92.91	92.57	92.72	4756249.0
2014-06-10 10:00:00	QQQ	ETF	92.72	92.93	92.56	92.8799	3617951.0
2014-06-10 11:00:00	QQQ	ETF	92.88	92.96	92.785	92.859	1889117.0
2014-06-10 12:00:00	QQQ	ETF	92.85	92.8601	92.66	92.77	1439071.0
2014-06-10 13:00:00	QQQ	ETF	92.765	92.88	92.68	92.85	1522141.0
2014-06-10 14:00:00	QQQ	ETF	92.85	92.91	92.8	92.81	1738547.0
2014-06-10 15:00:00	QQQ	ETF	92.815	92.91	92.81	92.89	3001018.0
2014-06-10 16:00:00	QQQ	ETF	92.89	92.96	92.7994	92.92	1153536.0
2014-06-10 17:00:00	QQQ	ETF	92.97	92.97	92.94	92.95	7118.0
2014-06-10 18:00:00	QQQ	ETF	92.94	92.94	92.87	92.89	20727.0
2014-06-10 19:00:00	QQQ	ETF	92.88	92.89	92.87	92.87	4400.0
2014-06-10 06:00:00	IWM	ETF	116.41	116.55	116.38	116.55	1200.0
2014-06-10 07:00:00	IWM	ETF	116.55	116.55	116.39	116.5	96799.0
2014-06-10 08:00:00	IWM	ETF	116.44	116.9	116.36	116.42	130374.0
2014-06-10 09:00:00	IWM	ETF	116.42	116.83	116.42	116.49	3953050.0
2014-06-10 10:00:00	IWM	ETF	116.4801	116.63	116.07	116.49	7305365.0
2014-06-10 11:00:00	IWM	ETF	116.51	116.57	116.14	116.27	2374791.0
2014-06-10 12:00:00	IWM	ETF	116.27	116.27	115.96	116.17	2153285.0
2014-06-10 13:00:00	IWM	ETF	116.17	116.4	116.05	116.36	1961199.0
2014-06-10 14:00:00	IWM	ETF	116.35	116.58	116.3	116.45	2666204.0
2014-06-10 15:00:00	IWM	ETF	116.45	116.66	116.43	116.65	3566425.0
2014-06-10 16:00:00	IWM	ETF	116.66	116.77	116.1805	116.75	1146575.0
2014-06-10 17:00:00	IWM	ETF	116.76	116.8	116.76	116.8	3100.0
2014-06-10 18:00:00	IWM	ETF	116.69	116.71	116.69	116.7	1300.0
2014-06-10 19:00:00	IWM	ETF	116.67	116.67	116.66	116.66	490.0
2014-06-10 07:00:00	DIA	ETF	169.06	169.06	169.06	169.06	100.0
2014-06-10 08:00:00	DIA	ETF	169.05	169.05	169.05	169.05	600.0
2014-06-10 09:00:00	DIA	ETF	169.1	169.29	168.91	169.01	558449.0
2014-06-10 10:00:00	DIA	ETF	169.0255	169.2	168.84	169.18	294926.0
2014-06-10 11:00:00	DIA	ETF	169.2	169.25	169.13	169.18	556796.0

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

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