PREVIEW / etf_1hour / 2012-11-08

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-11-08.parquet
  size:    195 KB
  rows:    6,038

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-11-08 04:00:00	SPY	ETF	139.89	140.01	139.46	139.46	14160.0
2012-11-08 05:00:00	SPY	ETF	139.45	139.73	139.38	139.65	89325.0
2012-11-08 06:00:00	SPY	ETF	139.59	139.78	139.49	139.75	158057.0
2012-11-08 07:00:00	SPY	ETF	139.75	140.17	139.69	140.1	361171.0
2012-11-08 08:00:00	SPY	ETF	140.09	140.31	139.69	139.99	1355359.0
2012-11-08 09:00:00	SPY	ETF	139.97	140.41	139.66	140.12	14980570.0
2012-11-08 10:00:00	SPY	ETF	140.12	140.18	139.27	139.4899	28781814.0
2012-11-08 11:00:00	SPY	ETF	139.49	139.63	139.11	139.49	21910175.0
2012-11-08 12:00:00	SPY	ETF	139.485	139.485	138.89	139.14	17731220.0
2012-11-08 13:00:00	SPY	ETF	139.14	139.2	138.39	139.06	19733211.0
2012-11-08 14:00:00	SPY	ETF	139.06	139.07	138.58	138.77	15289122.0
2012-11-08 15:00:00	SPY	ETF	138.76	138.88	138.01	138.04	41335933.0
2012-11-08 16:00:00	SPY	ETF	138.04	140.3	137.92	138.25	15129214.0
2012-11-08 17:00:00	SPY	ETF	138.25	139.4	138.04	138.3	1016525.0
2012-11-08 18:00:00	SPY	ETF	138.28	138.32	138.22	138.3	62144.0
2012-11-08 19:00:00	SPY	ETF	138.3	138.3	138.18	138.28	103533.0
2012-11-08 04:00:00	QQQ	ETF	64.27	64.27	64.26	64.26	200.0
2012-11-08 05:00:00	QQQ	ETF	64.2	64.2	64.2	64.2	200.0
2012-11-08 07:00:00	QQQ	ETF	64.32	64.44	64.29	64.4	49727.0
2012-11-08 08:00:00	QQQ	ETF	64.4	64.41	64.31	64.38	386220.0
2012-11-08 09:00:00	QQQ	ETF	64.39	64.495	64.19	64.4	4508772.0
2012-11-08 10:00:00	QQQ	ETF	64.39	64.435	63.87	64.02	8093213.0
2012-11-08 11:00:00	QQQ	ETF	64.03	64.1	63.74	64.0101	7679192.0
2012-11-08 12:00:00	QQQ	ETF	64.01	64.01	63.62	63.75	4881615.0
2012-11-08 13:00:00	QQQ	ETF	63.75	63.779	63.43	63.7225	4848145.0
2012-11-08 14:00:00	QQQ	ETF	63.725	63.73	63.35	63.51	5875269.0
2012-11-08 15:00:00	QQQ	ETF	63.5	64.1565	63.18	63.2	14469590.0
2012-11-08 16:00:00	QQQ	ETF	63.18	64.1565	63.16	63.33	5410902.0
2012-11-08 17:00:00	QQQ	ETF	63.33	64.1565	63.29	63.29	533589.0
2012-11-08 18:00:00	QQQ	ETF	63.31	63.34	63.3	63.34	33000.0
2012-11-08 19:00:00	QQQ	ETF	63.33	63.35	63.31	63.33	28161.0
2012-11-08 04:00:00	IWM	ETF	80.25	80.25	80.25	80.25	200.0
2012-11-08 06:00:00	IWM	ETF	80.1	80.25	80.1	80.25	10100.0
2012-11-08 07:00:00	IWM	ETF	80.17	80.42	80.15	80.38	97351.0
2012-11-08 08:00:00	IWM	ETF	80.39	80.45	80.22	80.32	267324.0
2012-11-08 09:00:00	IWM	ETF	80.33	80.5	80.1	80.41	3019391.0
2012-11-08 10:00:00	IWM	ETF	80.4	80.44	80.04	80.12	5472300.0
2012-11-08 11:00:00	IWM	ETF	80.13	80.2	79.79	79.89	4187197.0
2012-11-08 12:00:00	IWM	ETF	79.89	79.89	79.56	79.61	3462224.0
2012-11-08 13:00:00	IWM	ETF	79.61	79.67	79.28	79.65	4873420.0
2012-11-08 14:00:00	IWM	ETF	79.65	79.66	79.38	79.49	3211717.0
2012-11-08 15:00:00	IWM	ETF	79.495	79.565	79.2	79.2	9657833.0
2012-11-08 16:00:00	IWM	ETF	79.2	79.32	79.06	79.16	1370924.0
2012-11-08 17:00:00	IWM	ETF	79.18	79.22	79.18	79.22	4221.0
2012-11-08 18:00:00	IWM	ETF	79.21	79.23	79.2	79.2	11203.0
2012-11-08 19:00:00	IWM	ETF	79.24	79.24	79.24	79.24	200.0
2012-11-08 04:00:00	DIA	ETF	129.14	129.14	129.14	129.14	100.0
2012-11-08 05:00:00	DIA	ETF	129.0	129.0	129.0	129.0	100.0
2012-11-08 06:00:00	DIA	ETF	129.25	129.25	129.25	129.25	200.0
2012-11-08 07:00:00	DIA	ETF	129.29	129.59	129.25	129.59	12300.0

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

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