PREVIEW / etf_1hour / 2011-11-25

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-11-25.parquet
  size:    114 KB
  rows:    3,404

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-11-25 04:00:00	SPY	ETF	115.99	116.0	115.36	116.0	157137.0
2011-11-25 05:00:00	SPY	ETF	115.68	115.87	115.5	115.5	26320.0
2011-11-25 06:00:00	SPY	ETF	115.51	115.93	115.47	115.76	57172.0
2011-11-25 07:00:00	SPY	ETF	115.81	116.0	115.65	115.81	333397.0
2011-11-25 08:00:00	SPY	ETF	115.8	116.23	115.35	116.17	2223427.0
2011-11-25 09:00:00	SPY	ETF	116.2	117.44	116.04	117.08	26698522.0
2011-11-25 10:00:00	SPY	ETF	117.08	117.7	117.03	117.34	19340544.0
2011-11-25 11:00:00	SPY	ETF	117.35	117.55	116.64	116.729	19053641.0
2011-11-25 12:00:00	SPY	ETF	116.72	116.85	116.32	116.33	23456335.0
2011-11-25 13:00:00	SPY	ETF	116.33	116.37	115.52	115.98	5115269.0
2011-11-25 14:00:00	SPY	ETF	115.97	116.2	115.93	115.99	132794.0
2011-11-25 15:00:00	SPY	ETF	115.97	115.97	115.91	115.92	139480.0
2011-11-25 16:00:00	SPY	ETF	115.94	115.97	115.83	115.96	55962.0
2011-11-25 04:00:00	QQQ	ETF	52.9	52.99	52.54	52.79	14085.0
2011-11-25 05:00:00	QQQ	ETF	52.74	52.77	52.71	52.71	2500.0
2011-11-25 06:00:00	QQQ	ETF	52.68	52.68	52.68	52.68	2400.0
2011-11-25 07:00:00	QQQ	ETF	52.74	52.89	52.73	52.8	170200.0
2011-11-25 08:00:00	QQQ	ETF	52.79	53.0	52.74	52.96	335020.0
2011-11-25 09:00:00	QQQ	ETF	52.96	53.67	52.9	53.38	6090735.0
2011-11-25 10:00:00	QQQ	ETF	53.38	53.65	53.36	53.46	4154690.0
2011-11-25 11:00:00	QQQ	ETF	53.46	53.53	53.04	53.11	5597348.0
2011-11-25 12:00:00	QQQ	ETF	53.1	53.24	52.88	52.89	6748770.0
2011-11-25 13:00:00	QQQ	ETF	52.87	52.9927	52.68	52.83	622782.0
2011-11-25 14:00:00	QQQ	ETF	52.84	52.86	52.81	52.81	2800.0
2011-11-25 15:00:00	QQQ	ETF	52.88	52.92	52.87	52.91	1269.0
2011-11-25 16:00:00	QQQ	ETF	52.9	52.92	52.88	52.9	4011.0
2011-11-25 04:00:00	IWM	ETF	66.7	66.7	66.55	66.65	2096.0
2011-11-25 05:00:00	IWM	ETF	66.58	66.58	66.58	66.58	100.0
2011-11-25 06:00:00	IWM	ETF	66.45	66.59	66.45	66.59	700.0
2011-11-25 07:00:00	IWM	ETF	66.67	66.89	66.64	66.66	65162.0
2011-11-25 08:00:00	IWM	ETF	66.68	66.94	66.59	66.89	318929.0
2011-11-25 09:00:00	IWM	ETF	66.92	67.9	66.86	67.54	5075425.0
2011-11-25 10:00:00	IWM	ETF	67.55	68.04	67.5	67.79	5403464.0
2011-11-25 11:00:00	IWM	ETF	67.79	67.84	67.08	67.1	5822293.0
2011-11-25 12:00:00	IWM	ETF	67.11	67.17	66.62	66.64	8579963.0
2011-11-25 13:00:00	IWM	ETF	66.64	66.69	65.44	66.5	1231458.0
2011-11-25 14:00:00	IWM	ETF	66.23	66.5	66.23	66.49	1700.0
2011-11-25 15:00:00	IWM	ETF	66.45	66.45	66.41	66.45	12084.0
2011-11-25 06:00:00	DIA	ETF	111.85	111.85	111.85	111.85	100.0
2011-11-25 08:00:00	DIA	ETF	111.9	112.18	111.57	111.93	352954.0
2011-11-25 09:00:00	DIA	ETF	112.05	113.14	112.05	112.9	588516.0
2011-11-25 10:00:00	DIA	ETF	112.9	113.46	112.86	113.12	909790.0
2011-11-25 11:00:00	DIA	ETF	113.14	113.33	112.51	112.59	746085.0
2011-11-25 12:00:00	DIA	ETF	112.59	112.69	112.22	112.24	747931.0
2011-11-25 13:00:00	DIA	ETF	112.24	112.29	111.67	112.02	156091.0
2011-11-25 15:00:00	DIA	ETF	111.7	111.7	111.7	111.7	200.0
2011-11-25 16:00:00	DIA	ETF	111.7	111.7	111.7	111.7	646.0
2011-11-25 05:00:00	GLD	ETF	163.12	163.23	163.0	163.0	3900.0
2011-11-25 06:00:00	GLD	ETF	163.02	163.23	163.02	163.16	1300.0
2011-11-25 07:00:00	GLD	ETF	163.16	163.58	163.12	163.52	78243.0

> showing 50 of 3,404 rows — these rows as CSV

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