PREVIEW / etf_1hour / 2014-04-11

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-04-11.parquet
  size:    222 KB
  rows:    6,986

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-04-11 04:00:00	SPY	ETF	183.46	183.52	183.25	183.25	18566.0
2014-04-11 05:00:00	SPY	ETF	183.25	183.4	183.16	183.35	38856.0
2014-04-11 06:00:00	SPY	ETF	183.32	183.32	183.03	183.04	94100.0
2014-04-11 07:00:00	SPY	ETF	183.06	183.09	182.01	182.36	1337307.0
2014-04-11 08:00:00	SPY	ETF	182.35	182.85	182.05	182.53	2056392.0
2014-04-11 09:00:00	SPY	ETF	182.5	183.17	181.86	182.69	25573637.0
2014-04-11 10:00:00	SPY	ETF	182.69	183.33	181.83	183.12	31049200.0
2014-04-11 11:00:00	SPY	ETF	183.11	183.42	182.45	182.64	20317572.0
2014-04-11 12:00:00	SPY	ETF	182.63	182.93	182.37	182.59	9392451.0
2014-04-11 13:00:00	SPY	ETF	182.6	182.61	181.95	182.04	11576683.0
2014-04-11 14:00:00	SPY	ETF	182.05	182.315	181.31	181.73	17576574.0
2014-04-11 15:00:00	SPY	ETF	181.73	182.21	181.422	181.48	34716309.0
2014-04-11 16:00:00	SPY	ETF	181.48	183.2155	181.47	181.72	9300625.0
2014-04-11 17:00:00	SPY	ETF	181.67	181.69	181.54	181.57	253544.0
2014-04-11 18:00:00	SPY	ETF	181.56	181.63	181.55	181.55	62819.0
2014-04-11 19:00:00	SPY	ETF	181.55	181.57	181.51	181.54	88413.0
2014-04-11 04:00:00	QQQ	ETF	85.16	85.2	85.05	85.05	9869.0
2014-04-11 05:00:00	QQQ	ETF	85.05	85.07	85.0	85.07	3000.0
2014-04-11 06:00:00	QQQ	ETF	84.99	85.03	84.9	84.93	17700.0
2014-04-11 07:00:00	QQQ	ETF	84.9	84.91	84.3	84.5	1097113.0
2014-04-11 08:00:00	QQQ	ETF	84.48	84.74	84.37	84.62	1688702.0
2014-04-11 09:00:00	QQQ	ETF	84.61	85.21	84.14	84.97	16460268.0
2014-04-11 10:00:00	QQQ	ETF	84.97	85.44	84.25	85.25	15251662.0
2014-04-11 11:00:00	QQQ	ETF	85.24	85.44	84.82	84.93	9602671.0
2014-04-11 12:00:00	QQQ	ETF	84.92	85.16	84.73	84.95	4118128.0
2014-04-11 13:00:00	QQQ	ETF	84.95	84.96	84.43	84.48	5989520.0
2014-04-11 14:00:00	QQQ	ETF	84.48	84.65	83.91	84.16	8810165.0
2014-04-11 15:00:00	QQQ	ETF	84.16	84.4	83.95	84.1	14944289.0
2014-04-11 16:00:00	QQQ	ETF	84.1	85.0847	84.08	84.2	6781545.0
2014-04-11 17:00:00	QQQ	ETF	84.19	84.19	84.13	84.18	19460.0
2014-04-11 18:00:00	QQQ	ETF	84.16	84.21	84.12	84.18	5330.0
2014-04-11 19:00:00	QQQ	ETF	84.21	84.24	84.17	84.19	18889.0
2014-04-11 06:00:00	IWM	ETF	111.85	111.85	111.57	111.67	10700.0
2014-04-11 07:00:00	IWM	ETF	111.57	111.57	110.9	111.18	240050.0
2014-04-11 08:00:00	IWM	ETF	111.23	111.49	111.03	111.34	410794.0
2014-04-11 09:00:00	IWM	ETF	111.33	111.97	110.7	111.63	10121218.0
2014-04-11 10:00:00	IWM	ETF	111.63	112.21	110.82	111.965	10784610.0
2014-04-11 11:00:00	IWM	ETF	111.96	112.2375	111.09	111.275	6788494.0
2014-04-11 12:00:00	IWM	ETF	111.27	111.52	110.99	111.26	3650630.0
2014-04-11 13:00:00	IWM	ETF	111.26	111.27	110.705	110.83	4168371.0
2014-04-11 14:00:00	IWM	ETF	110.82	111.08	109.86	110.35	9905106.0
2014-04-11 15:00:00	IWM	ETF	110.355	110.89	110.06	110.42	13972894.0
2014-04-11 16:00:00	IWM	ETF	110.41	111.1576	110.27	110.34	3403960.0
2014-04-11 17:00:00	IWM	ETF	110.36	110.36	110.3	110.35	1700.0
2014-04-11 18:00:00	IWM	ETF	110.31	110.4	110.25	110.4	5534.0
2014-04-11 19:00:00	IWM	ETF	110.4	110.42	110.32	110.41	2980.0
2014-04-11 06:00:00	DIA	ETF	161.33	161.33	161.24	161.33	2500.0
2014-04-11 07:00:00	DIA	ETF	161.27	161.27	160.83	160.89	10550.0
2014-04-11 08:00:00	DIA	ETF	161.0	161.22	160.75	160.99	14461.0
2014-04-11 09:00:00	DIA	ETF	160.92	161.03	160.29	160.78	1352960.0

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

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