PREVIEW / etf_1hour / 2013-02-25

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-02-25.parquet
  size:    210 KB
  rows:    6,537

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
2013-02-25 04:00:00	SPY	ETF	152.0	152.14	152.0	152.14	22350.0
2013-02-25 05:00:00	SPY	ETF	152.11	152.51	152.11	152.49	39139.0
2013-02-25 06:00:00	SPY	ETF	152.39	152.65	152.39	152.52	147100.0
2013-02-25 07:00:00	SPY	ETF	152.51	152.77	152.49	152.66	400073.0
2013-02-25 08:00:00	SPY	ETF	152.64	152.7088	152.45	152.56	1963551.0
2013-02-25 09:00:00	SPY	ETF	152.56	152.76	152.36	152.615	14325106.0
2013-02-25 10:00:00	SPY	ETF	152.61	152.86	151.63	151.87	34483508.0
2013-02-25 11:00:00	SPY	ETF	151.86	152.14	151.06	151.18	29071684.0
2013-02-25 12:00:00	SPY	ETF	151.175	151.65	151.07	151.6	15562231.0
2013-02-25 13:00:00	SPY	ETF	151.61	151.67	150.63	150.73	15429901.0
2013-02-25 14:00:00	SPY	ETF	150.72	150.94	150.4	150.79	18634308.0
2013-02-25 15:00:00	SPY	ETF	150.79	150.89	149.0	149.01	57873511.0
2013-02-25 16:00:00	SPY	ETF	149.01	152.72	148.61	148.77	39473621.0
2013-02-25 17:00:00	SPY	ETF	148.76	151.8065	148.69	148.95	7268151.0
2013-02-25 18:00:00	SPY	ETF	148.97	151.8065	148.96	149.21	6360614.0
2013-02-25 19:00:00	SPY	ETF	149.22	149.44	149.22	149.44	164812.0
2013-02-25 05:00:00	QQQ	ETF	67.4	67.49	67.4	67.49	940.0
2013-02-25 06:00:00	QQQ	ETF	67.5	67.56	67.49	67.51	2800.0
2013-02-25 07:00:00	QQQ	ETF	67.51	67.65	67.51	67.63	27865.0
2013-02-25 08:00:00	QQQ	ETF	67.62	67.64	67.53	67.54	74037.0
2013-02-25 09:00:00	QQQ	ETF	67.56	67.74	67.53	67.7	5273643.0
2013-02-25 10:00:00	QQQ	ETF	67.7	67.81	67.29	67.38	7312503.0
2013-02-25 11:00:00	QQQ	ETF	67.3799	67.49	67.0	67.07	5410637.0
2013-02-25 12:00:00	QQQ	ETF	67.07	67.36	67.02	67.31	3094105.0
2013-02-25 13:00:00	QQQ	ETF	67.31	67.36	66.93	67.0	2733054.0
2013-02-25 14:00:00	QQQ	ETF	66.99	67.02	66.815	66.96	3962006.0
2013-02-25 15:00:00	QQQ	ETF	66.96	66.99	66.25	66.27	8257988.0
2013-02-25 16:00:00	QQQ	ETF	66.28	67.1406	66.11	66.23	3396893.0
2013-02-25 17:00:00	QQQ	ETF	66.21	66.28	66.19	66.27	42243.0
2013-02-25 18:00:00	QQQ	ETF	66.27	66.39	66.27	66.38	35207.0
2013-02-25 19:00:00	QQQ	ETF	66.38	66.45	66.38	66.42	31853.0
2013-02-25 05:00:00	IWM	ETF	91.3	91.35	91.3	91.35	2900.0
2013-02-25 07:00:00	IWM	ETF	91.3	91.54	91.3	91.49	62398.0
2013-02-25 08:00:00	IWM	ETF	91.48	91.52	91.38	91.45	124840.0
2013-02-25 09:00:00	IWM	ETF	91.46	91.53	91.12	91.19	4171397.0
2013-02-25 10:00:00	IWM	ETF	91.1899	91.32	90.61	90.68	9678762.0
2013-02-25 11:00:00	IWM	ETF	90.69	90.98	90.34	90.42	5986931.0
2013-02-25 12:00:00	IWM	ETF	90.42	90.65	90.34	90.58	2292519.0
2013-02-25 13:00:00	IWM	ETF	90.58	90.66	90.1	90.16	2858744.0
2013-02-25 14:00:00	IWM	ETF	90.15	90.28	89.95	90.06	5022480.0
2013-02-25 15:00:00	IWM	ETF	90.07	90.1	88.97	89.01	15538856.0
2013-02-25 16:00:00	IWM	ETF	89.02	90.44	88.86	88.96	2598232.0
2013-02-25 17:00:00	IWM	ETF	88.92	89.01	88.89	89.01	31896.0
2013-02-25 18:00:00	IWM	ETF	89.09	89.2	89.04	89.16	15000.0
2013-02-25 19:00:00	IWM	ETF	89.16	89.31	89.16	89.3	7250.0
2013-02-25 04:00:00	DIA	ETF	139.93	139.93	139.91	139.91	300.0
2013-02-25 05:00:00	DIA	ETF	139.95	140.15	139.95	140.15	200.0
2013-02-25 06:00:00	DIA	ETF	140.3	140.3	140.3	140.3	100.0
2013-02-25 07:00:00	DIA	ETF	140.26	140.41	140.26	140.4	13700.0
2013-02-25 08:00:00	DIA	ETF	140.38	140.4	140.25	140.3	4457.0

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

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