PREVIEW / etf_1hour / 2012-09-11

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-09-11.parquet
  size:    185 KB
  rows:    5,743

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-11 04:00:00	SPY	ETF	143.4	143.7	143.4	143.65	14781.0
2012-09-11 05:00:00	SPY	ETF	143.58	143.67	143.51	143.57	42525.0
2012-09-11 06:00:00	SPY	ETF	143.54	143.65	143.46	143.61	75450.0
2012-09-11 07:00:00	SPY	ETF	143.62	143.85	143.61	143.75	397389.0
2012-09-11 08:00:00	SPY	ETF	143.71	143.88	143.57	143.7	1253650.0
2012-09-11 09:00:00	SPY	ETF	143.73	144.07	143.56	144.0	13807138.0
2012-09-11 10:00:00	SPY	ETF	144.0099	144.15	143.9	144.1	11454524.0
2012-09-11 11:00:00	SPY	ETF	144.1	144.37	144.09	144.15	10096953.0
2012-09-11 12:00:00	SPY	ETF	144.15	144.19	143.99	144.1098	7841933.0
2012-09-11 13:00:00	SPY	ETF	144.1	144.28	144.02	144.16	6386872.0
2012-09-11 14:00:00	SPY	ETF	144.15	144.21	143.87	143.95	8812714.0
2012-09-11 15:00:00	SPY	ETF	143.94	144.02	143.79	143.88	14094047.0
2012-09-11 16:00:00	SPY	ETF	143.88	144.0	143.64	143.67	9808747.0
2012-09-11 17:00:00	SPY	ETF	143.67	144.06	143.4805	143.66	2687674.0
2012-09-11 18:00:00	SPY	ETF	143.63	143.65	143.52	143.56	91155.0
2012-09-11 19:00:00	SPY	ETF	143.55	143.62	143.51	143.61	87444.0
2012-09-11 06:00:00	QQQ	ETF	68.55	68.55	68.55	68.55	100.0
2012-09-11 07:00:00	QQQ	ETF	68.58	68.69	68.58	68.62	46400.0
2012-09-11 08:00:00	QQQ	ETF	68.64	68.7	68.58	68.64	72885.0
2012-09-11 09:00:00	QQQ	ETF	68.65	68.79	68.44	68.71	4277312.0
2012-09-11 10:00:00	QQQ	ETF	68.71	68.76	68.47	68.7	3865251.0
2012-09-11 11:00:00	QQQ	ETF	68.7035	68.82	68.63	68.66	3505810.0
2012-09-11 12:00:00	QQQ	ETF	68.65	68.74	68.52	68.61	2536702.0
2012-09-11 13:00:00	QQQ	ETF	68.61	68.75	68.55	68.65	1836576.0
2012-09-11 14:00:00	QQQ	ETF	68.65	68.69	68.38	68.45	4565680.0
2012-09-11 15:00:00	QQQ	ETF	68.45	68.53	68.32	68.44	6103253.0
2012-09-11 16:00:00	QQQ	ETF	68.44	68.5293	68.31	68.33	1891062.0
2012-09-11 17:00:00	QQQ	ETF	68.34	68.38	68.32	68.37	33856.0
2012-09-11 18:00:00	QQQ	ETF	68.38	68.38	68.28	68.3	38866.0
2012-09-11 19:00:00	QQQ	ETF	68.3	68.34	68.29	68.32	13970.0
2012-09-11 07:00:00	IWM	ETF	83.92	84.05	83.92	83.99	66494.0
2012-09-11 08:00:00	IWM	ETF	83.98	84.06	83.91	83.99	179638.0
2012-09-11 09:00:00	IWM	ETF	84.0	84.35	83.83	84.29	3840484.0
2012-09-11 10:00:00	IWM	ETF	84.29	84.43	84.26	84.31	4894838.0
2012-09-11 11:00:00	IWM	ETF	84.3001	84.56	84.3001	84.349	2880877.0
2012-09-11 12:00:00	IWM	ETF	84.35	84.36	84.0	84.11	3900155.0
2012-09-11 13:00:00	IWM	ETF	84.11	84.28	84.09	84.21	1650032.0
2012-09-11 14:00:00	IWM	ETF	84.21	84.26	83.9525	84.04	4104376.0
2012-09-11 15:00:00	IWM	ETF	84.04	84.17	83.91	84.03	6210959.0
2012-09-11 16:00:00	IWM	ETF	84.04	84.1737	83.89	83.97	1534900.0
2012-09-11 17:00:00	IWM	ETF	83.93	83.93	83.93	83.93	100.0
2012-09-11 18:00:00	IWM	ETF	83.93	83.97	83.93	83.97	13100.0
2012-09-11 19:00:00	IWM	ETF	83.98	84.07	83.96	84.07	20801.0
2012-09-11 07:00:00	DIA	ETF	132.78	132.78	132.78	132.78	100.0
2012-09-11 08:00:00	DIA	ETF	132.68	132.77	132.68	132.77	3620.0
2012-09-11 09:00:00	DIA	ETF	132.77	133.18	132.59	133.11	364775.0
2012-09-11 10:00:00	DIA	ETF	133.16	133.3	133.03	133.2712	325674.0
2012-09-11 11:00:00	DIA	ETF	133.2708	133.45	133.23	133.26	585437.0
2012-09-11 12:00:00	DIA	ETF	133.27	133.3	133.15	133.28	182332.0
2012-09-11 13:00:00	DIA	ETF	133.29	133.44	133.21	133.34	336968.0

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

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