PREVIEW / etf_1hour / 2011-10-18

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-10-18.parquet
  size:    182 KB
  rows:    5,600

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-10-18 04:00:00	SPY	ETF	119.6	119.98	119.6	119.88	24750.0
2011-10-18 05:00:00	SPY	ETF	119.77	119.98	119.47	119.7	84248.0
2011-10-18 06:00:00	SPY	ETF	119.77	119.99	119.69	119.89	160701.0
2011-10-18 07:00:00	SPY	ETF	119.94	120.05	119.15	119.29	1781357.0
2011-10-18 08:00:00	SPY	ETF	119.3	119.99	119.25	119.82	3668834.0
2011-10-18 09:00:00	SPY	ETF	119.81	120.47	119.3	119.58	27412450.0
2011-10-18 10:00:00	SPY	ETF	119.525	120.93	119.2	120.67	46419725.0
2011-10-18 11:00:00	SPY	ETF	120.66	121.34	120.27	121.2	29292512.0
2011-10-18 12:00:00	SPY	ETF	121.205	121.635	121.0	121.5201	17495321.0
2011-10-18 13:00:00	SPY	ETF	121.53	121.69	121.13	121.52	15399678.0
2011-10-18 14:00:00	SPY	ETF	121.52	121.88	121.43	121.71	20606782.0
2011-10-18 15:00:00	SPY	ETF	121.71	123.5	121.71	122.58	128181189.0
2011-10-18 16:00:00	SPY	ETF	122.58	123.0565	120.1788	122.27	21728487.0
2011-10-18 17:00:00	SPY	ETF	122.25	122.35	122.12	122.24	753725.0
2011-10-18 18:00:00	SPY	ETF	122.23	122.61	122.1	122.33	598722.0
2011-10-18 19:00:00	SPY	ETF	122.33	122.35	122.21	122.24	146529.0
2011-10-18 04:00:00	QQQ	ETF	57.0	57.0	57.0	57.0	200.0
2011-10-18 05:00:00	QQQ	ETF	57.11	57.28	57.11	57.28	700.0
2011-10-18 06:00:00	QQQ	ETF	57.25	57.31	57.25	57.27	2000.0
2011-10-18 07:00:00	QQQ	ETF	57.29	57.3	56.9	56.97	426926.0
2011-10-18 08:00:00	QQQ	ETF	57.08	57.29	56.95	57.23	787063.0
2011-10-18 09:00:00	QQQ	ETF	57.24	57.44	56.74	56.91	10659923.0
2011-10-18 10:00:00	QQQ	ETF	56.9	57.37	56.66	57.27	12855326.0
2011-10-18 11:00:00	QQQ	ETF	57.28	57.68	57.1	57.59	8220379.0
2011-10-18 12:00:00	QQQ	ETF	57.6	57.68	57.4209	57.57	4707518.0
2011-10-18 13:00:00	QQQ	ETF	57.57	57.7	57.36	57.59	3693161.0
2011-10-18 14:00:00	QQQ	ETF	57.59	57.68	57.48	57.57	5126025.0
2011-10-18 15:00:00	QQQ	ETF	57.57	58.29	57.57	57.98	20681578.0
2011-10-18 16:00:00	QQQ	ETF	57.98	58.33	57.44	57.57	4203885.0
2011-10-18 17:00:00	QQQ	ETF	57.55	57.62	57.47	57.47	803515.0
2011-10-18 18:00:00	QQQ	ETF	57.49	57.61	57.47	57.56	111443.0
2011-10-18 19:00:00	QQQ	ETF	57.54	57.59	57.52	57.55	48056.0
2011-10-18 04:00:00	IWM	ETF	68.56	68.56	68.56	68.56	357.0
2011-10-18 05:00:00	IWM	ETF	68.54	68.79	68.54	68.79	200.0
2011-10-18 07:00:00	IWM	ETF	68.79	68.79	68.26	68.34	70191.0
2011-10-18 08:00:00	IWM	ETF	68.41	68.94	68.32	68.8	956306.0
2011-10-18 09:00:00	IWM	ETF	68.81	69.39	68.02	68.19	11335349.0
2011-10-18 10:00:00	IWM	ETF	68.21	69.5	67.85	69.339	15038202.0
2011-10-18 11:00:00	IWM	ETF	69.35	69.98	69.06	69.82	9596389.0
2011-10-18 12:00:00	IWM	ETF	69.8262	70.11	69.5499	69.955	4112315.0
2011-10-18 13:00:00	IWM	ETF	69.98	70.04	69.56	69.9199	3288213.0
2011-10-18 14:00:00	IWM	ETF	69.92	70.22	69.75	69.97	6536603.0
2011-10-18 15:00:00	IWM	ETF	69.97	71.29	69.97	70.8	31271721.0
2011-10-18 16:00:00	IWM	ETF	70.8	71.2	68.7845	70.41	7344616.0
2011-10-18 17:00:00	IWM	ETF	70.43	70.49	68.7845	70.36	642630.0
2011-10-18 18:00:00	IWM	ETF	70.32	70.45	70.29	70.45	6200.0
2011-10-18 19:00:00	IWM	ETF	70.41	70.49	70.33	70.37	2800.0
2011-10-18 06:00:00	DIA	ETF	113.34	113.36	113.34	113.34	2000.0
2011-10-18 07:00:00	DIA	ETF	113.29	113.29	112.82	112.82	7140.0
2011-10-18 08:00:00	DIA	ETF	112.8	113.33	112.76	113.29	25885.0

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

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