PREVIEW / etf_1hour / 2012-09-25

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-09-25.parquet
  size:    195 KB
  rows:    5,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
2012-09-25 04:00:00	SPY	ETF	146.14	146.14	145.63	145.63	13200.0
2012-09-25 05:00:00	SPY	ETF	145.66	145.75	145.61	145.61	29150.0
2012-09-25 06:00:00	SPY	ETF	145.56	145.73	145.56	145.7	21850.0
2012-09-25 07:00:00	SPY	ETF	145.7	145.9	145.7	145.83	106120.0
2012-09-25 08:00:00	SPY	ETF	145.81	146.12	145.645	146.06	1087635.0
2012-09-25 09:00:00	SPY	ETF	146.06	146.09	145.59	145.86	9714568.0
2012-09-25 10:00:00	SPY	ETF	145.86	146.19	145.83	146.1	17066208.0
2012-09-25 11:00:00	SPY	ETF	146.11	146.24	145.92	145.94	6326563.0
2012-09-25 12:00:00	SPY	ETF	145.945	145.98	145.26	145.475	18187946.0
2012-09-25 13:00:00	SPY	ETF	145.48	145.58	145.24	145.38	12645108.0
2012-09-25 14:00:00	SPY	ETF	145.37	145.583	144.76	144.77	15738898.0
2012-09-25 15:00:00	SPY	ETF	144.77	144.865	144.06	144.14	37673951.0
2012-09-25 16:00:00	SPY	ETF	144.16	145.9	144.0597	144.35	8134759.0
2012-09-25 17:00:00	SPY	ETF	144.35	145.5833	144.3	144.42	678392.0
2012-09-25 18:00:00	SPY	ETF	144.4	144.4	144.3	144.37	61102.0
2012-09-25 19:00:00	SPY	ETF	144.35	144.35	144.24	144.33	43766.0
2012-09-25 05:00:00	QQQ	ETF	69.74	69.74	69.74	69.74	285.0
2012-09-25 07:00:00	QQQ	ETF	69.78	69.87	69.78	69.84	62900.0
2012-09-25 08:00:00	QQQ	ETF	69.85	70.01	69.85	69.99	208023.0
2012-09-25 09:00:00	QQQ	ETF	70.0	70.0	69.72	69.8	3250582.0
2012-09-25 10:00:00	QQQ	ETF	69.77	69.99	69.75	69.94	4015832.0
2012-09-25 11:00:00	QQQ	ETF	69.95	70.08	69.92	69.94	2819212.0
2012-09-25 12:00:00	QQQ	ETF	69.93	69.95	69.56	69.64	4563727.0
2012-09-25 13:00:00	QQQ	ETF	69.64	69.715	69.53	69.62	2522845.0
2012-09-25 14:00:00	QQQ	ETF	69.63	69.65	69.12	69.12	5439667.0
2012-09-25 15:00:00	QQQ	ETF	69.13	69.19	68.73	68.74	12531703.0
2012-09-25 16:00:00	QQQ	ETF	68.76	69.3527	68.76	68.93	1963266.0
2012-09-25 17:00:00	QQQ	ETF	68.94	68.96	68.9	68.9	12369.0
2012-09-25 18:00:00	QQQ	ETF	68.92	68.93	68.9	68.92	2460.0
2012-09-25 19:00:00	QQQ	ETF	68.9	68.91	68.87	68.91	7524.0
2012-09-25 04:00:00	IWM	ETF	85.15	85.15	85.15	85.15	500.0
2012-09-25 06:00:00	IWM	ETF	85.21	85.23	85.21	85.23	200.0
2012-09-25 07:00:00	IWM	ETF	85.25	85.35	85.25	85.29	20370.0
2012-09-25 08:00:00	IWM	ETF	85.3	85.55	85.3	85.51	306285.0
2012-09-25 09:00:00	IWM	ETF	85.5	85.55	85.04	85.16	5827891.0
2012-09-25 10:00:00	IWM	ETF	85.17	85.51	85.1	85.33	8746414.0
2012-09-25 11:00:00	IWM	ETF	85.34	85.45	85.15	85.21	3735229.0
2012-09-25 12:00:00	IWM	ETF	85.21	85.225	84.52	84.68	5571779.0
2012-09-25 13:00:00	IWM	ETF	84.68	84.78	84.45	84.58	3170190.0
2012-09-25 14:00:00	IWM	ETF	84.58	84.61	84.1	84.11	5091259.0
2012-09-25 15:00:00	IWM	ETF	84.11	84.17	83.58	83.71	19219198.0
2012-09-25 16:00:00	IWM	ETF	83.7	85.395	83.65	83.86	13663676.0
2012-09-25 17:00:00	IWM	ETF	83.88	83.9	83.85	83.9	4492.0
2012-09-25 18:00:00	IWM	ETF	83.85	83.89	83.84	83.84	8193.0
2012-09-25 19:00:00	IWM	ETF	83.84	83.88	83.83	83.83	13759.0
2012-09-25 07:00:00	DIA	ETF	135.55	135.55	135.55	135.55	300.0
2012-09-25 08:00:00	DIA	ETF	135.6	135.68	135.6	135.67	101700.0
2012-09-25 09:00:00	DIA	ETF	135.68	135.68	135.39	135.61	445404.0
2012-09-25 10:00:00	DIA	ETF	135.63	135.86	135.57	135.77	427386.0
2012-09-25 11:00:00	DIA	ETF	135.78	135.9	135.62	135.64	272660.0

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

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