PREVIEW / etf_1hour / 2012-05-03

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-03.parquet
  size:    182 KB
  rows:    5,633

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-05-03 04:00:00	SPY	ETF	140.73	140.73	140.15	140.15	8500.0
2012-05-03 05:00:00	SPY	ETF	140.3	140.32	140.3	140.32	40500.0
2012-05-03 06:00:00	SPY	ETF	140.51	140.57	140.44	140.54	35122.0
2012-05-03 07:00:00	SPY	ETF	140.56	140.69	140.56	140.67	242260.0
2012-05-03 08:00:00	SPY	ETF	140.6	140.81	140.32	140.46	2736958.0
2012-05-03 09:00:00	SPY	ETF	140.44	140.5	140.1	140.29	13540612.0
2012-05-03 10:00:00	SPY	ETF	140.28	140.4	139.64	140.18	25726623.0
2012-05-03 11:00:00	SPY	ETF	140.18	140.27	139.65	139.7499	14566920.0
2012-05-03 12:00:00	SPY	ETF	139.7412	139.86	139.61	139.67	9985135.0
2012-05-03 13:00:00	SPY	ETF	139.67	139.72	139.05	139.2	20938123.0
2012-05-03 14:00:00	SPY	ETF	139.2	139.29	138.99	139.15	11916605.0
2012-05-03 15:00:00	SPY	ETF	139.15	139.48	139.09	139.29	28306509.0
2012-05-03 16:00:00	SPY	ETF	139.29	139.2982	139.05	139.21	9711235.0
2012-05-03 17:00:00	SPY	ETF	139.25	139.25	139.13	139.22	207409.0
2012-05-03 18:00:00	SPY	ETF	139.22	139.28	139.1	139.18	180293.0
2012-05-03 19:00:00	SPY	ETF	139.19	139.28	139.17	139.19	64692.0
2012-05-03 06:00:00	QQQ	ETF	67.25	67.25	67.25	67.25	100.0
2012-05-03 07:00:00	QQQ	ETF	67.19	67.2	67.15	67.19	11900.0
2012-05-03 08:00:00	QQQ	ETF	67.18	67.27	67.08	67.12	400779.0
2012-05-03 09:00:00	QQQ	ETF	67.14	67.16	66.92	67.011	4244444.0
2012-05-03 10:00:00	QQQ	ETF	67.01	67.015	66.78	67.0	6133252.0
2012-05-03 11:00:00	QQQ	ETF	67.0	67.01	66.58	66.6023	5700691.0
2012-05-03 12:00:00	QQQ	ETF	66.61	66.6603	66.45	66.552	4296833.0
2012-05-03 13:00:00	QQQ	ETF	66.5501	66.59	66.22	66.265	5246986.0
2012-05-03 14:00:00	QQQ	ETF	66.26	66.53	66.175	66.26	3268574.0
2012-05-03 15:00:00	QQQ	ETF	66.27	66.491	66.21	66.36	12959356.0
2012-05-03 16:00:00	QQQ	ETF	66.35	67.091	66.16	66.35	2101817.0
2012-05-03 17:00:00	QQQ	ETF	66.25	66.26	66.2	66.2	5310.0
2012-05-03 18:00:00	QQQ	ETF	66.22	66.23	66.19	66.21	5850.0
2012-05-03 19:00:00	QQQ	ETF	66.22	66.25	66.21	66.22	8500.0
2012-05-03 06:00:00	IWM	ETF	81.86	81.86	81.83	81.83	963.0
2012-05-03 07:00:00	IWM	ETF	81.86	81.91	81.79	81.88	31605.0
2012-05-03 08:00:00	IWM	ETF	81.86	83.29	81.62	81.74	529416.0
2012-05-03 09:00:00	IWM	ETF	81.73	81.76	81.24	81.41	4035901.0
2012-05-03 10:00:00	IWM	ETF	81.42	81.45	80.81	81.43	8409113.0
2012-05-03 11:00:00	IWM	ETF	81.44	81.46	80.73	80.81	5321460.0
2012-05-03 12:00:00	IWM	ETF	80.82	80.97	80.65	80.66	4002302.0
2012-05-03 13:00:00	IWM	ETF	80.65	80.78	80.3	80.45	7572592.0
2012-05-03 14:00:00	IWM	ETF	80.44	80.51	80.17	80.28	4050235.0
2012-05-03 15:00:00	IWM	ETF	80.28	80.67	80.27	80.62	13693163.0
2012-05-03 16:00:00	IWM	ETF	80.62	80.62	80.34	80.56	2682135.0
2012-05-03 17:00:00	IWM	ETF	80.56	80.6	80.5	80.54	6200.0
2012-05-03 18:00:00	IWM	ETF	80.53	80.53	80.52	80.52	1800.0
2012-05-03 19:00:00	IWM	ETF	80.51	80.56	80.5	80.5	6373.0
2012-05-03 04:00:00	DIA	ETF	132.4	132.4	132.3	132.3	500.0
2012-05-03 05:00:00	DIA	ETF	132.4	132.4	132.4	132.4	100.0
2012-05-03 07:00:00	DIA	ETF	132.6	132.62	132.6	132.62	2980.0
2012-05-03 08:00:00	DIA	ETF	132.49	132.7	132.39	132.47	26022.0
2012-05-03 09:00:00	DIA	ETF	132.41	132.58	132.25	132.45	386801.0
2012-05-03 10:00:00	DIA	ETF	132.42	132.421	131.89	132.31	969892.0

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

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