PREVIEW / etf_1hour / 2012-06-11

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-06-11.parquet
  size:    187 KB
  rows:    5,778

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
2012-06-11 04:00:00	SPY	ETF	134.5	134.93	134.5	134.59	62507.0
2012-06-11 05:00:00	SPY	ETF	134.69	134.71	134.38	134.38	38280.0
2012-06-11 06:00:00	SPY	ETF	134.44	134.55	134.31	134.33	101955.0
2012-06-11 07:00:00	SPY	ETF	134.32	134.35	133.81	134.0	943144.0
2012-06-11 08:00:00	SPY	ETF	134.0	134.96	133.84	134.11	2301291.0
2012-06-11 09:00:00	SPY	ETF	134.14	134.25	133.18	133.26	25192024.0
2012-06-11 10:00:00	SPY	ETF	133.25	133.48	132.62	132.74	30438679.0
2012-06-11 11:00:00	SPY	ETF	132.74	133.01	132.52	132.9	20890422.0
2012-06-11 12:00:00	SPY	ETF	132.89	133.03	132.66	132.88	10424305.0
2012-06-11 13:00:00	SPY	ETF	132.88	133.16	132.64	132.73	14169806.0
2012-06-11 14:00:00	SPY	ETF	132.725	132.73	132.26	132.38	15123402.0
2012-06-11 15:00:00	SPY	ETF	132.38	132.43	131.28	131.47	33952246.0
2012-06-11 16:00:00	SPY	ETF	131.47	131.65	131.19	131.27	12410734.0
2012-06-11 17:00:00	SPY	ETF	131.29	131.31	131.11	131.3	123000.0
2012-06-11 18:00:00	SPY	ETF	131.32	131.44	130.96	131.33	179033.0
2012-06-11 19:00:00	SPY	ETF	131.35	131.37	131.12	131.32	120037.0
2012-06-11 04:00:00	QQQ	ETF	63.58	63.63	63.58	63.63	785.0
2012-06-11 05:00:00	QQQ	ETF	63.45	63.45	63.45	63.45	852.0
2012-06-11 06:00:00	QQQ	ETF	63.45	63.48	63.4	63.48	13800.0
2012-06-11 07:00:00	QQQ	ETF	63.38	63.42	63.16	63.24	129418.0
2012-06-11 08:00:00	QQQ	ETF	63.25	63.34	63.19	63.3	515683.0
2012-06-11 09:00:00	QQQ	ETF	63.31	63.38	62.83	62.88	6475856.0
2012-06-11 10:00:00	QQQ	ETF	62.88	63.0	62.57	62.66	6303764.0
2012-06-11 11:00:00	QQQ	ETF	62.66	62.85	62.58	62.76	6416682.0
2012-06-11 12:00:00	QQQ	ETF	62.76	62.82	62.67	62.72	4687372.0
2012-06-11 13:00:00	QQQ	ETF	62.72	62.86	62.53	62.608	4648000.0
2012-06-11 14:00:00	QQQ	ETF	62.6	62.6	62.33	62.36	4886642.0
2012-06-11 15:00:00	QQQ	ETF	62.36	62.4	61.77	61.87	11357584.0
2012-06-11 16:00:00	QQQ	ETF	61.88	62.8864	61.8	61.83	2042518.0
2012-06-11 17:00:00	QQQ	ETF	61.83	61.86	61.78	61.85	19180.0
2012-06-11 18:00:00	QQQ	ETF	61.86	61.91	61.74	61.87	33480.0
2012-06-11 19:00:00	QQQ	ETF	61.87	61.87	61.79	61.87	22420.0
2012-06-11 04:00:00	IWM	ETF	77.87	78.2	77.87	78.06	2749.0
2012-06-11 05:00:00	IWM	ETF	78.1	78.1	77.95	77.95	900.0
2012-06-11 06:00:00	IWM	ETF	77.85	77.9	77.85	77.9	26913.0
2012-06-11 07:00:00	IWM	ETF	77.81	77.84	77.48	77.66	122984.0
2012-06-11 08:00:00	IWM	ETF	77.69	77.78	77.48	77.74	324225.0
2012-06-11 09:00:00	IWM	ETF	77.75	77.86	76.83	76.89	5995446.0
2012-06-11 10:00:00	IWM	ETF	76.88	76.981	76.38	76.51	6135718.0
2012-06-11 11:00:00	IWM	ETF	76.51	76.7	76.2	76.552	5934316.0
2012-06-11 12:00:00	IWM	ETF	76.55	76.61	76.28	76.4	3259759.0
2012-06-11 13:00:00	IWM	ETF	76.41	76.611	76.27	76.32	3372839.0
2012-06-11 14:00:00	IWM	ETF	76.32	76.32	75.87	75.96	3607153.0
2012-06-11 15:00:00	IWM	ETF	75.97	76.045	75.09	75.2	12021308.0
2012-06-11 16:00:00	IWM	ETF	75.21	75.35	74.95	75.0	6130969.0
2012-06-11 17:00:00	IWM	ETF	75.0	75.1	74.95	75.09	14525.0
2012-06-11 18:00:00	IWM	ETF	75.07	75.13	74.99	75.13	4925.0
2012-06-11 19:00:00	IWM	ETF	75.13	75.13	75.05	75.07	9830.0
2012-06-11 07:00:00	DIA	ETF	126.47	126.57	126.05	126.25	8125.0
2012-06-11 08:00:00	DIA	ETF	126.3	126.42	126.19	126.35	20349.0

> showing 50 of 5,778 rows — these rows as CSV

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