PREVIEW / etf_1hour / 2011-09-14

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-09-14.parquet
  size:    179 KB
  rows:    5,513

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
2011-09-14 04:00:00	SPY	ETF	117.45	117.63	117.01	117.37	6250.0
2011-09-14 05:00:00	SPY	ETF	117.11	117.59	117.01	117.57	9000.0
2011-09-14 06:00:00	SPY	ETF	117.63	118.49	117.63	118.3	290392.0
2011-09-14 07:00:00	SPY	ETF	118.3	118.9	118.3	118.9	1292084.0
2011-09-14 08:00:00	SPY	ETF	118.9	118.9	117.1	118.32	4503912.0
2011-09-14 09:00:00	SPY	ETF	118.33	118.6	117.81	117.93	23555398.0
2011-09-14 10:00:00	SPY	ETF	117.94	118.06	116.72	117.6	55700908.0
2011-09-14 11:00:00	SPY	ETF	117.6	118.43	117.37	118.43	24540205.0
2011-09-14 12:00:00	SPY	ETF	118.42	118.76	118.1	118.54	17310579.0
2011-09-14 13:00:00	SPY	ETF	118.54	119.35	118.5	118.94	29071389.0
2011-09-14 14:00:00	SPY	ETF	118.93	119.8	118.93	119.7895	40004275.0
2011-09-14 15:00:00	SPY	ETF	119.79	120.8	119.34	119.37	83811471.0
2011-09-14 16:00:00	SPY	ETF	119.36	120.502	118.15	119.33	34530880.0
2011-09-14 17:00:00	SPY	ETF	119.32	119.33	119.02	119.1	613269.0
2011-09-14 18:00:00	SPY	ETF	119.1	119.36	118.99	119.27	1565933.0
2011-09-14 19:00:00	SPY	ETF	119.28	119.45	119.23	119.45	130334.0
2011-09-14 06:00:00	QQQ	ETF	54.63	54.93	54.63	54.91	8000.0
2011-09-14 07:00:00	QQQ	ETF	54.87	55.12	54.87	55.12	36587.0
2011-09-14 08:00:00	QQQ	ETF	55.12	55.12	54.78	54.88	465829.0
2011-09-14 09:00:00	QQQ	ETF	54.87	55.06	54.74	54.9	8134547.0
2011-09-14 10:00:00	QQQ	ETF	54.91	54.95	54.32	54.74	13279258.0
2011-09-14 11:00:00	QQQ	ETF	54.73	55.1	54.66	55.1	8758711.0
2011-09-14 12:00:00	QQQ	ETF	55.1	55.24	54.97	55.11	5784430.0
2011-09-14 13:00:00	QQQ	ETF	55.11	55.39	55.08	55.24	5788939.0
2011-09-14 14:00:00	QQQ	ETF	55.23	55.61	55.23	55.6	6832241.0
2011-09-14 15:00:00	QQQ	ETF	55.6	55.98	55.33	55.35	16484603.0
2011-09-14 16:00:00	QQQ	ETF	55.35	55.511	55.27	55.31	2290056.0
2011-09-14 17:00:00	QQQ	ETF	55.31	55.31	55.22	55.26	246437.0
2011-09-14 18:00:00	QQQ	ETF	55.25	55.36	54.571	55.31	602127.0
2011-09-14 19:00:00	QQQ	ETF	55.32	55.39	55.32	55.39	13521.0
2011-09-14 05:00:00	IWM	ETF	69.02	69.02	69.01	69.01	3000.0
2011-09-14 06:00:00	IWM	ETF	69.32	69.84	69.32	69.84	13800.0
2011-09-14 07:00:00	IWM	ETF	69.7	70.16	69.7	70.15	330731.0
2011-09-14 08:00:00	IWM	ETF	70.18	70.25	69.75	69.87	670215.0
2011-09-14 09:00:00	IWM	ETF	69.85	70.02	69.3	69.43	7303626.0
2011-09-14 10:00:00	IWM	ETF	69.45	69.65	68.44	68.96	14720907.0
2011-09-14 11:00:00	IWM	ETF	68.95	69.63	68.8	69.6	6347202.0
2011-09-14 12:00:00	IWM	ETF	69.6	69.82	69.33	69.545	4789592.0
2011-09-14 13:00:00	IWM	ETF	69.55	70.08	69.5	69.81	7269900.0
2011-09-14 14:00:00	IWM	ETF	69.81	70.64	69.8	70.58	7022369.0
2011-09-14 15:00:00	IWM	ETF	70.59	71.4	70.395	70.44	18997006.0
2011-09-14 16:00:00	IWM	ETF	70.44	70.5672	69.2525	70.2	3864833.0
2011-09-14 17:00:00	IWM	ETF	70.15	70.16	69.94	70.04	77339.0
2011-09-14 18:00:00	IWM	ETF	70.01	70.5	70.01	70.23	40802.0
2011-09-14 19:00:00	IWM	ETF	70.19	70.36	69.9	70.36	3500.0
2011-09-14 07:00:00	DIA	ETF	111.54	111.74	111.54	111.74	450.0
2011-09-14 08:00:00	DIA	ETF	111.59	111.94	111.31	111.47	30383.0
2011-09-14 09:00:00	DIA	ETF	111.25	111.77	110.97	111.1	1121582.0
2011-09-14 10:00:00	DIA	ETF	111.12	111.17	109.87	110.56	2716111.0
2011-09-14 11:00:00	DIA	ETF	110.55	111.48	110.38	111.48	2560472.0

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

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