PREVIEW / etf_1hour / 2011-09-02

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-09-02.parquet
  size:    183 KB
  rows:    5,632

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-02 04:00:00	SPY	ETF	120.28	120.28	119.65	119.9	30602.0
2011-09-02 05:00:00	SPY	ETF	119.86	119.86	119.65	119.76	16700.0
2011-09-02 06:00:00	SPY	ETF	119.76	119.8	119.55	119.66	119404.0
2011-09-02 07:00:00	SPY	ETF	119.71	119.95	119.65	119.79	493496.0
2011-09-02 08:00:00	SPY	ETF	119.81	120.29	118.53	118.82	11033135.0
2011-09-02 09:00:00	SPY	ETF	118.82	118.95	118.08	118.55	39925489.0
2011-09-02 10:00:00	SPY	ETF	118.54	119.08	118.08	118.6	38055612.0
2011-09-02 11:00:00	SPY	ETF	118.6	120.8726	118.5	118.68	25167143.0
2011-09-02 12:00:00	SPY	ETF	118.68	119.04	118.63	118.73	14579719.0
2011-09-02 13:00:00	SPY	ETF	118.74	118.83	118.18	118.32	13976357.0
2011-09-02 14:00:00	SPY	ETF	118.33	118.41	117.49	117.71	28723960.0
2011-09-02 15:00:00	SPY	ETF	117.7	118.24	117.43	117.82	45924625.0
2011-09-02 16:00:00	SPY	ETF	117.82	120.8734	117.33	117.44	33903799.0
2011-09-02 17:00:00	SPY	ETF	117.42	117.45	117.4	117.4	187259.0
2011-09-02 18:00:00	SPY	ETF	117.38	117.84	117.37	117.38	323997.0
2011-09-02 19:00:00	SPY	ETF	117.37	117.44	117.36	117.42	73920.0
2011-09-02 04:00:00	QQQ	ETF	54.4	54.4	54.17	54.17	1313.0
2011-09-02 06:00:00	QQQ	ETF	54.17	54.17	54.0	54.0	1650.0
2011-09-02 07:00:00	QQQ	ETF	54.03	54.16	54.03	54.09	164542.0
2011-09-02 08:00:00	QQQ	ETF	54.11	54.39	53.63	53.75	2601249.0
2011-09-02 09:00:00	QQQ	ETF	53.74	54.6143	53.35	53.59	9437510.0
2011-09-02 10:00:00	QQQ	ETF	53.58	53.83	53.37	53.58	8773476.0
2011-09-02 11:00:00	QQQ	ETF	53.58	53.74	53.54	53.57	6222935.0
2011-09-02 12:00:00	QQQ	ETF	53.57	53.7	53.56	53.59	2690333.0
2011-09-02 13:00:00	QQQ	ETF	53.6	53.63	53.3	53.36	4501489.0
2011-09-02 14:00:00	QQQ	ETF	53.3501	53.39	53.03	53.1	8214988.0
2011-09-02 15:00:00	QQQ	ETF	53.1	53.44	52.99	53.27	12669742.0
2011-09-02 16:00:00	QQQ	ETF	53.28	53.4005	53.14	53.22	2031178.0
2011-09-02 17:00:00	QQQ	ETF	53.19	53.25	53.18	53.25	8000.0
2011-09-02 18:00:00	QQQ	ETF	53.17	53.28	53.17	53.21	23868.0
2011-09-02 19:00:00	QQQ	ETF	53.23	53.26	53.16	53.26	12032.0
2011-09-02 04:00:00	IWM	ETF	70.49	70.49	70.3	70.3	680.0
2011-09-02 06:00:00	IWM	ETF	70.11	70.21	70.11	70.11	1900.0
2011-09-02 07:00:00	IWM	ETF	70.1	70.35	70.1	70.2	50564.0
2011-09-02 08:00:00	IWM	ETF	70.22	70.69	69.35	69.6	2508366.0
2011-09-02 09:00:00	IWM	ETF	69.59	69.79	69.1	69.64	11299646.0
2011-09-02 10:00:00	IWM	ETF	69.63	70.04	69.29	69.64	10407349.0
2011-09-02 11:00:00	IWM	ETF	69.63	70.0	69.54	69.71	4890856.0
2011-09-02 12:00:00	IWM	ETF	69.71	69.85	69.34	69.37	3066317.0
2011-09-02 13:00:00	IWM	ETF	69.38	69.44	68.72	68.89	6638657.0
2011-09-02 14:00:00	IWM	ETF	68.88	68.92	68.15	68.23	9916390.0
2011-09-02 15:00:00	IWM	ETF	68.22	68.74	68.1	68.45	11558539.0
2011-09-02 16:00:00	IWM	ETF	68.45	68.5	68.0	68.24	1854370.0
2011-09-02 17:00:00	IWM	ETF	68.21	68.24	68.1	68.22	16249.0
2011-09-02 18:00:00	IWM	ETF	68.19	68.22	68.19	68.19	2000.0
2011-09-02 19:00:00	IWM	ETF	68.16	68.2	68.16	68.2	1200.0
2011-09-02 07:00:00	DIA	ETF	114.07	114.07	113.95	113.95	200.0
2011-09-02 08:00:00	DIA	ETF	114.05	114.86	112.92	113.08	111947.0
2011-09-02 09:00:00	DIA	ETF	113.09	113.15	112.31	112.64	1997420.0
2011-09-02 10:00:00	DIA	ETF	112.63	113.12	112.36	112.79	1660676.0

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

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