PREVIEW / etf_1hour / 2012-09-19

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-09-19.parquet
  size:    189 KB
  rows:    5,934

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-09-19 04:00:00	SPY	ETF	147.02	147.06	146.71	146.72	9998.0
2012-09-19 05:00:00	SPY	ETF	146.8	146.85	146.75	146.76	7645.0
2012-09-19 06:00:00	SPY	ETF	146.69	146.82	146.69	146.75	44000.0
2012-09-19 07:00:00	SPY	ETF	146.75	146.78	146.65	146.68	151113.0
2012-09-19 08:00:00	SPY	ETF	146.68	146.85	146.63	146.83	548476.0
2012-09-19 09:00:00	SPY	ETF	146.83	146.91	146.3855	146.52	11037268.0
2012-09-19 10:00:00	SPY	ETF	146.53	146.97	146.48	146.675	23508068.0
2012-09-19 11:00:00	SPY	ETF	146.67	147.06	146.62	146.95	11216562.0
2012-09-19 12:00:00	SPY	ETF	146.957	147.17	146.88	147.0798	8320772.0
2012-09-19 13:00:00	SPY	ETF	147.075	147.11	146.83	146.925	10426726.0
2012-09-19 14:00:00	SPY	ETF	146.93	147.12	146.91	147.115	7445691.0
2012-09-19 15:00:00	SPY	ETF	147.12	147.16	146.7	146.7	21090550.0
2012-09-19 16:00:00	SPY	ETF	146.7	146.9075	146.42	146.45	25426071.0
2012-09-19 17:00:00	SPY	ETF	146.46	146.53	146.46	146.52	6620713.0
2012-09-19 18:00:00	SPY	ETF	146.51	146.59	146.49	146.59	88548.0
2012-09-19 19:00:00	SPY	ETF	146.6	146.63	146.54	146.54	61490.0
2012-09-19 07:00:00	QQQ	ETF	70.3	70.32	70.29	70.31	12500.0
2012-09-19 08:00:00	QQQ	ETF	70.29	70.36	70.27	70.3	66978.0
2012-09-19 09:00:00	QQQ	ETF	70.3	70.33	70.09	70.2	3330062.0
2012-09-19 10:00:00	QQQ	ETF	70.22	70.35	70.06	70.2	4445573.0
2012-09-19 11:00:00	QQQ	ETF	70.21	70.42	70.19	70.35	3129429.0
2012-09-19 12:00:00	QQQ	ETF	70.3587	70.49	70.31	70.4399	2000251.0
2012-09-19 13:00:00	QQQ	ETF	70.4391	70.46	70.36	70.42	1985376.0
2012-09-19 14:00:00	QQQ	ETF	70.41	70.55	70.4	70.54	1612771.0
2012-09-19 15:00:00	QQQ	ETF	70.54	70.58	70.38	70.39	5212083.0
2012-09-19 16:00:00	QQQ	ETF	70.4	70.4986	70.2394	70.27	3345095.0
2012-09-19 17:00:00	QQQ	ETF	70.29	70.32	70.29	70.29	6350.0
2012-09-19 18:00:00	QQQ	ETF	70.31	70.37	70.31	70.37	21000.0
2012-09-19 06:00:00	IWM	ETF	85.76	85.76	85.76	85.76	997.0
2012-09-19 07:00:00	IWM	ETF	85.76	85.8	85.71	85.8	40324.0
2012-09-19 08:00:00	IWM	ETF	85.8	85.96	85.75	85.87	150840.0
2012-09-19 09:00:00	IWM	ETF	85.87	85.95	85.54	85.58	2738826.0
2012-09-19 10:00:00	IWM	ETF	85.58	86.03	85.41	85.66	5443586.0
2012-09-19 11:00:00	IWM	ETF	85.66	85.88	85.6	85.63	3962324.0
2012-09-19 12:00:00	IWM	ETF	85.63	85.94	85.53	85.87	3292509.0
2012-09-19 13:00:00	IWM	ETF	85.87	85.89	85.58	85.65	2487580.0
2012-09-19 14:00:00	IWM	ETF	85.65	85.845	85.645	85.77	2367339.0
2012-09-19 15:00:00	IWM	ETF	85.76	85.78	85.53	85.555	5453575.0
2012-09-19 16:00:00	IWM	ETF	85.56	85.6224	85.48	85.53	921128.0
2012-09-19 17:00:00	IWM	ETF	85.4	85.4	85.4	85.4	600.0
2012-09-19 18:00:00	IWM	ETF	85.5	85.5	85.48	85.48	2500.0
2012-09-19 07:00:00	DIA	ETF	135.79	135.79	135.79	135.79	143.0
2012-09-19 08:00:00	DIA	ETF	135.93	135.93	135.85	135.89	4900.0
2012-09-19 09:00:00	DIA	ETF	135.89	135.92	135.55	135.687	443774.0
2012-09-19 10:00:00	DIA	ETF	135.7	136.11	135.63	135.752	534245.0
2012-09-19 11:00:00	DIA	ETF	135.75	136.15	135.69	136.035	438835.0
2012-09-19 12:00:00	DIA	ETF	136.02	136.235	135.955	136.15	602343.0
2012-09-19 13:00:00	DIA	ETF	136.1601	136.1836	135.97	136.02	187148.0
2012-09-19 14:00:00	DIA	ETF	136.01	136.115	135.99	136.11	185723.0
2012-09-19 15:00:00	DIA	ETF	136.11	136.14	135.75	135.75	571086.0

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

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