PREVIEW / etf_1hour / 2012-12-05

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-12-05.parquet
  size:    189 KB
  rows:    5,909

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-12-05 04:00:00	SPY	ETF	141.75	141.86	141.56	141.56	31739.0
2012-12-05 05:00:00	SPY	ETF	141.57	141.66	141.52	141.57	18790.0
2012-12-05 06:00:00	SPY	ETF	141.52	141.75	141.52	141.61	24793.0
2012-12-05 07:00:00	SPY	ETF	141.66	141.81	141.54	141.69	324747.0
2012-12-05 08:00:00	SPY	ETF	141.68	141.73	141.48	141.5	801835.0
2012-12-05 09:00:00	SPY	ETF	141.5	141.67	141.16	141.18	14349325.0
2012-12-05 10:00:00	SPY	ETF	141.18	141.46	140.37	140.665	27444520.0
2012-12-05 11:00:00	SPY	ETF	140.67	141.72	140.53	141.6678	23427581.0
2012-12-05 12:00:00	SPY	ETF	141.66	142.16	141.65	142.0	20284650.0
2012-12-05 13:00:00	SPY	ETF	142.0	142.07	141.7	141.721	14518351.0
2012-12-05 14:00:00	SPY	ETF	141.721	142.02	141.72	141.7999	8743358.0
2012-12-05 15:00:00	SPY	ETF	141.7999	142.13	141.31	141.48	27294687.0
2012-12-05 16:00:00	SPY	ETF	141.48	141.8735	140.43	141.35	7280853.0
2012-12-05 17:00:00	SPY	ETF	141.34	141.4	141.27	141.27	1692988.0
2012-12-05 18:00:00	SPY	ETF	141.33	141.58	141.3	141.56	105614.0
2012-12-05 19:00:00	SPY	ETF	141.53	141.55	141.27	141.31	78209.0
2012-12-05 04:00:00	QQQ	ETF	65.84	65.85	65.84	65.85	1050.0
2012-12-05 05:00:00	QQQ	ETF	65.63	65.63	65.6	65.6	25000.0
2012-12-05 06:00:00	QQQ	ETF	65.64	65.69	65.64	65.69	800.0
2012-12-05 07:00:00	QQQ	ETF	65.68	65.7	65.61	65.69	131350.0
2012-12-05 08:00:00	QQQ	ETF	65.66	65.67	65.58	65.605	172032.0
2012-12-05 09:00:00	QQQ	ETF	65.59	65.6	65.04	65.14	6368091.0
2012-12-05 10:00:00	QQQ	ETF	65.135	65.24	64.55	64.7	11289996.0
2012-12-05 11:00:00	QQQ	ETF	64.71	65.21	64.63	65.1699	7022728.0
2012-12-05 12:00:00	QQQ	ETF	65.17	65.42	65.159	65.27	5330718.0
2012-12-05 13:00:00	QQQ	ETF	65.28	65.31	65.08	65.08	2886307.0
2012-12-05 14:00:00	QQQ	ETF	65.0801	65.27	65.08	65.111	2130654.0
2012-12-05 15:00:00	QQQ	ETF	65.12	65.34	64.83	64.9	6760496.0
2012-12-05 16:00:00	QQQ	ETF	64.9	65.3	64.6853	64.85	5349438.0
2012-12-05 17:00:00	QQQ	ETF	64.85	64.88	64.83	64.88	201240.0
2012-12-05 18:00:00	QQQ	ETF	64.85	64.94	64.85	64.93	18230.0
2012-12-05 19:00:00	QQQ	ETF	64.94	64.94	64.85	64.85	34340.0
2012-12-05 04:00:00	IWM	ETF	82.34	82.62	82.34	82.62	820.0
2012-12-05 05:00:00	IWM	ETF	82.5	82.93	82.5	82.93	300.0
2012-12-05 06:00:00	IWM	ETF	82.74	82.74	82.6	82.6	10100.0
2012-12-05 07:00:00	IWM	ETF	82.6	82.68	82.46	82.64	87415.0
2012-12-05 08:00:00	IWM	ETF	82.63	82.74	82.52	82.54	450403.0
2012-12-05 09:00:00	IWM	ETF	82.5	82.53	81.98	81.98	4988427.0
2012-12-05 10:00:00	IWM	ETF	82.0	82.11	81.4	81.64	9451622.0
2012-12-05 11:00:00	IWM	ETF	81.64	82.22	81.55	82.19	5340975.0
2012-12-05 12:00:00	IWM	ETF	82.18	82.4	82.12	82.21	4447327.0
2012-12-05 13:00:00	IWM	ETF	82.21	82.33	82.07	82.11	2442976.0
2012-12-05 14:00:00	IWM	ETF	82.11	82.31	82.11	82.16	2058700.0
2012-12-05 15:00:00	IWM	ETF	82.15	82.33	81.9	81.93	4107282.0
2012-12-05 16:00:00	IWM	ETF	81.94	82.15	81.92	81.93	855388.0
2012-12-05 17:00:00	IWM	ETF	81.94	81.95	81.9	81.9	22000.0
2012-12-05 19:00:00	IWM	ETF	82.0	82.0	82.0	82.0	420.0
2012-12-05 06:00:00	DIA	ETF	129.87	129.87	129.87	129.87	1500.0
2012-12-05 07:00:00	DIA	ETF	129.89	129.95	129.87	129.91	1200.0
2012-12-05 08:00:00	DIA	ETF	129.91	129.91	129.75	129.76	8100.0

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

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