PREVIEW / etf_1hour / 2012-12-28

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-12-28.parquet
  size:    197 KB
  rows:    6,113

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-28 04:00:00	SPY	ETF	141.94	141.94	141.3	141.3	9100.0
2012-12-28 05:00:00	SPY	ETF	141.2	141.24	141.03	141.03	11000.0
2012-12-28 06:00:00	SPY	ETF	141.05	141.05	140.83	140.95	19800.0
2012-12-28 07:00:00	SPY	ETF	140.92	140.93	140.5	140.58	236448.0
2012-12-28 08:00:00	SPY	ETF	140.59	140.89	140.31	140.59	2029283.0
2012-12-28 09:00:00	SPY	ETF	140.57	140.89	140.41	140.6801	12439815.0
2012-12-28 10:00:00	SPY	ETF	140.68	141.42	140.35	141.04	27655384.0
2012-12-28 11:00:00	SPY	ETF	141.03	141.17	140.73	140.91	14073215.0
2012-12-28 12:00:00	SPY	ETF	140.92	141.12	140.87	140.9	8105233.0
2012-12-28 13:00:00	SPY	ETF	140.91	141.04	140.76	140.82	6684318.0
2012-12-28 14:00:00	SPY	ETF	140.81	140.86	140.58	140.665	8904938.0
2012-12-28 15:00:00	SPY	ETF	140.65	140.87	139.91	139.95	43001776.0
2012-12-28 16:00:00	SPY	ETF	139.94	141.5899	138.55	138.83	18792076.0
2012-12-28 17:00:00	SPY	ETF	138.83	141.5899	138.83	139.3	2591193.0
2012-12-28 18:00:00	SPY	ETF	139.29	139.34	139.23	139.23	468184.0
2012-12-28 19:00:00	SPY	ETF	139.23	139.3	139.1	139.3	181635.0
2012-12-28 04:00:00	QQQ	ETF	64.28	64.28	64.28	64.28	100.0
2012-12-28 06:00:00	QQQ	ETF	64.17	64.17	64.06	64.06	1700.0
2012-12-28 07:00:00	QQQ	ETF	64.02	64.12	63.93	63.98	33299.0
2012-12-28 08:00:00	QQQ	ETF	63.99	64.4441	63.89	63.95	379860.0
2012-12-28 09:00:00	QQQ	ETF	63.95	64.2	63.9	64.1	4540918.0
2012-12-28 10:00:00	QQQ	ETF	64.1	64.43	63.94	64.3	6391407.0
2012-12-28 11:00:00	QQQ	ETF	64.3	64.37	64.13	64.1716	2713063.0
2012-12-28 12:00:00	QQQ	ETF	64.17	64.28	64.15	64.18	1993412.0
2012-12-28 13:00:00	QQQ	ETF	64.1761	64.26	64.125	64.155	2492630.0
2012-12-28 14:00:00	QQQ	ETF	64.16	64.178	64.03	64.089	3780063.0
2012-12-28 15:00:00	QQQ	ETF	64.09	64.24	63.75	63.78	7959137.0
2012-12-28 16:00:00	QQQ	ETF	63.78	64.003	63.34	63.37	1947609.0
2012-12-28 17:00:00	QQQ	ETF	64.4	64.4	63.37	63.56	71345.0
2012-12-28 18:00:00	QQQ	ETF	63.5	63.6	63.41	63.6	29411.0
2012-12-28 19:00:00	QQQ	ETF	63.55	63.67	63.45	63.63	18152.0
2012-12-28 05:00:00	IWM	ETF	83.0	83.2	83.0	83.2	2700.0
2012-12-28 06:00:00	IWM	ETF	83.07	83.07	82.97	82.99	5700.0
2012-12-28 07:00:00	IWM	ETF	82.97	82.97	82.69	82.71	21598.0
2012-12-28 08:00:00	IWM	ETF	82.73	82.8	82.57	82.7	115378.0
2012-12-28 09:00:00	IWM	ETF	82.69	82.95	82.59	82.94	3326486.0
2012-12-28 10:00:00	IWM	ETF	82.91	83.37	82.64	83.21	6521485.0
2012-12-28 11:00:00	IWM	ETF	83.195	83.275	82.875	83.07	2589346.0
2012-12-28 12:00:00	IWM	ETF	83.06	83.26	82.975	82.99	2470102.0
2012-12-28 13:00:00	IWM	ETF	82.995	83.19	82.975	83.051	1640594.0
2012-12-28 14:00:00	IWM	ETF	83.04	83.08	82.795	82.9	3283903.0
2012-12-28 15:00:00	IWM	ETF	82.9	83.17	82.52	82.56	7845050.0
2012-12-28 16:00:00	IWM	ETF	82.56	82.6	81.95	81.96	1951476.0
2012-12-28 17:00:00	IWM	ETF	81.97	82.33	81.97	82.26	115905.0
2012-12-28 18:00:00	IWM	ETF	82.19	82.38	82.12	82.18	13015.0
2012-12-28 19:00:00	IWM	ETF	82.27	82.33	82.27	82.33	7686.0
2012-12-28 05:00:00	DIA	ETF	130.08	130.08	130.08	130.08	500.0
2012-12-28 07:00:00	DIA	ETF	130.02	130.02	129.81	129.81	1300.0
2012-12-28 08:00:00	DIA	ETF	129.82	129.87	129.59	129.86	22900.0
2012-12-28 09:00:00	DIA	ETF	129.74	130.08	129.71	129.9	502325.0

> showing 50 of 6,113 rows — these rows as CSV

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