PREVIEW / etf_1hour / 2012-04-27

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-04-27.parquet
  size:    189 KB
  rows:    6,012

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-04-27 04:00:00	SPY	ETF	139.65	139.92	139.65	139.85	4299.0
2012-04-27 05:00:00	SPY	ETF	139.98	140.2	139.98	140.05	15900.0
2012-04-27 06:00:00	SPY	ETF	140.01	140.28	139.99	140.24	140613.0
2012-04-27 07:00:00	SPY	ETF	140.2	140.53	140.13	140.45	1378795.0
2012-04-27 08:00:00	SPY	ETF	140.43	140.75	140.13	140.51	3670234.0
2012-04-27 09:00:00	SPY	ETF	140.52	140.77	140.03	140.22	15637074.0
2012-04-27 10:00:00	SPY	ETF	140.21	140.3	139.8	140.245	27717415.0
2012-04-27 11:00:00	SPY	ETF	140.24	140.4	140.19	140.3299	14229319.0
2012-04-27 12:00:00	SPY	ETF	140.33	140.42	140.26	140.39	7160218.0
2012-04-27 13:00:00	SPY	ETF	140.39	140.79	140.36	140.65	11401428.0
2012-04-27 14:00:00	SPY	ETF	140.65	140.68	140.41	140.55	8388011.0
2012-04-27 15:00:00	SPY	ETF	140.55	140.66	140.34	140.43	22268716.0
2012-04-27 16:00:00	SPY	ETF	140.42	140.45	140.16	140.38	11056757.0
2012-04-27 17:00:00	SPY	ETF	140.39	140.43	140.31	140.39	125916.0
2012-04-27 18:00:00	SPY	ETF	140.41	140.42	140.28	140.37	34377.0
2012-04-27 19:00:00	SPY	ETF	140.35	140.43	140.32	140.43	45114.0
2012-04-27 04:00:00	QQQ	ETF	66.57	66.81	66.57	66.81	2630.0
2012-04-27 05:00:00	QQQ	ETF	66.83	66.85	66.83	66.85	940.0
2012-04-27 06:00:00	QQQ	ETF	66.86	66.94	66.86	66.94	10700.0
2012-04-27 07:00:00	QQQ	ETF	66.98	67.09	66.94	67.07	479073.0
2012-04-27 08:00:00	QQQ	ETF	67.06	67.15	66.95	67.09	1203538.0
2012-04-27 09:00:00	QQQ	ETF	67.1	67.2	66.87	66.99	7174318.0
2012-04-27 10:00:00	QQQ	ETF	66.99	67.15	66.77	67.0971	10726404.0
2012-04-27 11:00:00	QQQ	ETF	67.095	67.25	67.08	67.22	5454958.0
2012-04-27 12:00:00	QQQ	ETF	67.23	67.29	67.15	67.28	2270609.0
2012-04-27 13:00:00	QQQ	ETF	67.275	67.45	67.26	67.355	6231060.0
2012-04-27 14:00:00	QQQ	ETF	67.355	67.37	67.2	67.3175	2674783.0
2012-04-27 15:00:00	QQQ	ETF	67.31	67.37	67.11	67.24	6408848.0
2012-04-27 16:00:00	QQQ	ETF	67.24	67.36	67.15	67.29	1344170.0
2012-04-27 17:00:00	QQQ	ETF	67.23	67.25	67.23	67.23	5287.0
2012-04-27 18:00:00	QQQ	ETF	67.26	67.32	67.24	67.28	5420.0
2012-04-27 19:00:00	QQQ	ETF	67.3	67.32	67.23	67.23	5649.0
2012-04-27 04:00:00	IWM	ETF	81.36	81.56	81.36	81.5	1945.0
2012-04-27 05:00:00	IWM	ETF	81.73	81.73	81.73	81.73	980.0
2012-04-27 06:00:00	IWM	ETF	81.77	81.84	81.77	81.84	4600.0
2012-04-27 07:00:00	IWM	ETF	81.9	82.0	81.76	81.97	38940.0
2012-04-27 08:00:00	IWM	ETF	81.95	82.11	81.44	81.98	330733.0
2012-04-27 09:00:00	IWM	ETF	81.96	82.06	81.23	81.46	5510118.0
2012-04-27 10:00:00	IWM	ETF	81.45	81.85	81.03	81.8	7629740.0
2012-04-27 11:00:00	IWM	ETF	81.79	82.04	81.76	82.005	3794649.0
2012-04-27 12:00:00	IWM	ETF	82.01	82.09	81.95	82.07	2535320.0
2012-04-27 13:00:00	IWM	ETF	82.08	82.51	82.04	82.38	4722729.0
2012-04-27 14:00:00	IWM	ETF	82.385	82.46	82.32	82.45	2745079.0
2012-04-27 15:00:00	IWM	ETF	82.45	82.53	82.355	82.38	6881598.0
2012-04-27 16:00:00	IWM	ETF	82.37	82.49	82.3	82.42	1539122.0
2012-04-27 19:00:00	IWM	ETF	82.41	82.43	82.41	82.43	240.0
2012-04-27 06:00:00	DIA	ETF	132.01	132.03	132.01	132.03	2000.0
2012-04-27 07:00:00	DIA	ETF	132.05	132.1	131.9	132.1	3600.0
2012-04-27 08:00:00	DIA	ETF	132.03	132.2	131.87	132.14	45930.0
2012-04-27 09:00:00	DIA	ETF	132.1	132.23	131.79	131.95	492421.0

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

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