PREVIEW / etf_1hour / 2012-06-26

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-06-26.parquet
  size:    182 KB
  rows:    5,651

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-26 04:00:00	SPY	ETF	131.67	131.81	131.44	131.47	4606.0
2012-06-26 05:00:00	SPY	ETF	131.4	131.7	131.3	131.7	14400.0
2012-06-26 06:00:00	SPY	ETF	131.7	131.75	131.52	131.64	39525.0
2012-06-26 07:00:00	SPY	ETF	131.62	131.7	131.26	131.37	265515.0
2012-06-26 08:00:00	SPY	ETF	131.38	131.51	131.23	131.46	767557.0
2012-06-26 09:00:00	SPY	ETF	131.48	131.97	131.4	131.67	15556207.0
2012-06-26 10:00:00	SPY	ETF	131.67	131.96	131.14	131.38	24555335.0
2012-06-26 11:00:00	SPY	ETF	131.37	131.72	130.93	131.59	23722496.0
2012-06-26 12:00:00	SPY	ETF	131.6	132.06	131.595	131.86	17806829.0
2012-06-26 13:00:00	SPY	ETF	131.86	131.98	131.64	131.88	8012769.0
2012-06-26 14:00:00	SPY	ETF	131.88	132.38	131.85	132.13	22235350.0
2012-06-26 15:00:00	SPY	ETF	132.12	132.345	131.95	131.97	20925376.0
2012-06-26 16:00:00	SPY	ETF	131.98	132.2	131.3235	132.15	7010951.0
2012-06-26 17:00:00	SPY	ETF	132.15	132.16	132.09	132.1	48414.0
2012-06-26 18:00:00	SPY	ETF	132.1	132.2	132.07	132.07	41992.0
2012-06-26 19:00:00	SPY	ETF	132.08	132.08	131.98	131.98	205759.0
2012-06-26 04:00:00	QQQ	ETF	61.95	62.28	61.95	62.28	371.0
2012-06-26 05:00:00	QQQ	ETF	62.17	62.17	62.17	62.17	150.0
2012-06-26 06:00:00	QQQ	ETF	62.33	62.33	62.33	62.33	4400.0
2012-06-26 07:00:00	QQQ	ETF	62.3	62.31	62.15	62.18	23090.0
2012-06-26 08:00:00	QQQ	ETF	62.2	62.23	62.12	62.23	44044.0
2012-06-26 09:00:00	QQQ	ETF	62.22	62.56	62.18	62.42	3664476.0
2012-06-26 10:00:00	QQQ	ETF	62.43	62.6501	62.16	62.27	6052042.0
2012-06-26 11:00:00	QQQ	ETF	62.26	62.45	62.0575	62.37	4995904.0
2012-06-26 12:00:00	QQQ	ETF	62.38	62.535	62.34	62.445	2462999.0
2012-06-26 13:00:00	QQQ	ETF	62.45	62.48	62.26	62.395	2030635.0
2012-06-26 14:00:00	QQQ	ETF	62.39	62.7	62.3899	62.56	5022555.0
2012-06-26 15:00:00	QQQ	ETF	62.56	62.675	62.51	62.52	4555649.0
2012-06-26 16:00:00	QQQ	ETF	62.52	62.64	62.5086	62.58	677626.0
2012-06-26 17:00:00	QQQ	ETF	62.59	62.61	62.59	62.6	15442.0
2012-06-26 18:00:00	QQQ	ETF	62.6	62.63	62.58	62.58	19000.0
2012-06-26 19:00:00	QQQ	ETF	62.56	62.57	62.55	62.55	20475.0
2012-06-26 04:00:00	IWM	ETF	76.37	76.37	75.96	75.96	1700.0
2012-06-26 05:00:00	IWM	ETF	76.11	76.11	76.11	76.11	100.0
2012-06-26 06:00:00	IWM	ETF	76.11	76.11	76.11	76.11	800.0
2012-06-26 07:00:00	IWM	ETF	76.11	76.12	75.82	75.9	16700.0
2012-06-26 08:00:00	IWM	ETF	75.96	76.01	75.85	76.01	255560.0
2012-06-26 09:00:00	IWM	ETF	76.0	76.38	75.91	76.05	4249774.0
2012-06-26 10:00:00	IWM	ETF	76.05	76.34	75.48	75.68	8458167.0
2012-06-26 11:00:00	IWM	ETF	75.6887	75.95	75.42	75.86	5749832.0
2012-06-26 12:00:00	IWM	ETF	75.87	76.2	75.87	76.1	3485155.0
2012-06-26 13:00:00	IWM	ETF	76.1	76.2	75.95	76.12	2122126.0
2012-06-26 14:00:00	IWM	ETF	76.13	76.58	76.13	76.34	6238117.0
2012-06-26 15:00:00	IWM	ETF	76.33	76.49	76.16	76.25	6716327.0
2012-06-26 16:00:00	IWM	ETF	76.25	76.37	76.16	76.3	543070.0
2012-06-26 17:00:00	IWM	ETF	76.32	76.34	76.23	76.28	19925.0
2012-06-26 18:00:00	IWM	ETF	76.29	76.31	76.29	76.3	5215.0
2012-06-26 19:00:00	IWM	ETF	76.27	76.27	76.22	76.22	4536.0
2012-06-26 07:00:00	DIA	ETF	124.91	124.91	124.91	124.91	100.0
2012-06-26 08:00:00	DIA	ETF	124.79	124.98	124.79	124.98	429500.0

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

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