PREVIEW / etf_1hour / 2013-02-11

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-02-11.parquet
  size:    191 KB
  rows:    6,044

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-11 04:00:00	SPY	ETF	151.75	152.05	151.75	152.05	15900.0
2013-02-11 05:00:00	SPY	ETF	152.03	152.03	151.94	151.94	1600.0
2013-02-11 06:00:00	SPY	ETF	151.93	151.97	151.88	151.93	16799.0
2013-02-11 07:00:00	SPY	ETF	151.93	152.04	151.89	152.03	110461.0
2013-02-11 08:00:00	SPY	ETF	152.03	152.04	151.67	151.74	696190.0
2013-02-11 09:00:00	SPY	ETF	151.74	151.84	151.49	151.6	11135164.0
2013-02-11 10:00:00	SPY	ETF	151.61	151.78	151.3938	151.76	14033783.0
2013-02-11 11:00:00	SPY	ETF	151.76	151.86	151.7	151.785	6889363.0
2013-02-11 12:00:00	SPY	ETF	151.789	151.795	151.5	151.64	5445000.0
2013-02-11 13:00:00	SPY	ETF	151.64	151.76	151.55	151.61	4391450.0
2013-02-11 14:00:00	SPY	ETF	151.605	151.74	151.58	151.6	4718974.0
2013-02-11 15:00:00	SPY	ETF	151.605	151.9	151.595	151.76	10639679.0
2013-02-11 16:00:00	SPY	ETF	151.77	151.845	151.635	151.78	7434186.0
2013-02-11 17:00:00	SPY	ETF	151.77	151.78	151.69	151.69	60388.0
2013-02-11 18:00:00	SPY	ETF	151.69	151.73	151.67	151.7	70261.0
2013-02-11 19:00:00	SPY	ETF	151.69	151.7	151.66	151.68	30731.0
2013-02-11 04:00:00	QQQ	ETF	68.11	68.19	68.11	68.19	998.0
2013-02-11 05:00:00	QQQ	ETF	68.19	68.19	68.13	68.13	400.0
2013-02-11 07:00:00	QQQ	ETF	68.11	68.12	68.1	68.11	1108.0
2013-02-11 08:00:00	QQQ	ETF	68.11	68.12	68.02	68.06	83730.0
2013-02-11 09:00:00	QQQ	ETF	68.05	68.06	67.8	67.85	3155077.0
2013-02-11 10:00:00	QQQ	ETF	67.86	68.0	67.78	68.0	4088720.0
2013-02-11 11:00:00	QQQ	ETF	67.99	68.06	67.967	68.01	2022738.0
2013-02-11 12:00:00	QQQ	ETF	68.01	68.01	67.8205	67.905	1585321.0
2013-02-11 13:00:00	QQQ	ETF	67.91	67.96	67.85	67.88	1183406.0
2013-02-11 14:00:00	QQQ	ETF	67.88	67.951	67.86	67.88	1146345.0
2013-02-11 15:00:00	QQQ	ETF	67.87	68.06	67.87	67.99	3146736.0
2013-02-11 16:00:00	QQQ	ETF	68.01	68.03	67.9599	67.99	479738.0
2013-02-11 17:00:00	QQQ	ETF	67.99	68.0	67.97	67.97	9900.0
2013-02-11 18:00:00	QQQ	ETF	67.96	67.97	67.95	67.96	37250.0
2013-02-11 19:00:00	QQQ	ETF	67.95	67.98	67.95	67.98	72600.0
2013-02-11 07:00:00	IWM	ETF	90.84	90.84	90.84	90.84	300.0
2013-02-11 08:00:00	IWM	ETF	90.85	90.85	90.62	90.69	379345.0
2013-02-11 09:00:00	IWM	ETF	90.7	90.75	90.4399	90.53	2030327.0
2013-02-11 10:00:00	IWM	ETF	90.53	90.57	90.26	90.5	2759817.0
2013-02-11 11:00:00	IWM	ETF	90.5	90.62	90.45	90.5	1732244.0
2013-02-11 12:00:00	IWM	ETF	90.5045	90.51	90.37	90.455	739503.0
2013-02-11 13:00:00	IWM	ETF	90.46	90.54	90.44	90.46	855930.0
2013-02-11 14:00:00	IWM	ETF	90.46	90.5	90.39	90.42	977798.0
2013-02-11 15:00:00	IWM	ETF	90.42	90.71	90.415	90.69	4704940.0
2013-02-11 16:00:00	IWM	ETF	90.69	90.77	90.67	90.72	736214.0
2013-02-11 17:00:00	IWM	ETF	90.72	90.72	90.69	90.7	25898.0
2013-02-11 18:00:00	IWM	ETF	90.7	90.71	90.7	90.7	2200.0
2013-02-11 19:00:00	IWM	ETF	90.7	90.71	90.7	90.7	2750.0
2013-02-11 07:00:00	DIA	ETF	139.87	139.88	139.85	139.88	350.0
2013-02-11 08:00:00	DIA	ETF	139.86	139.88	139.58	139.58	10947.0
2013-02-11 09:00:00	DIA	ETF	139.67	139.67	139.26	139.37	539246.0
2013-02-11 10:00:00	DIA	ETF	139.35	139.54	139.21	139.53	498638.0
2013-02-11 11:00:00	DIA	ETF	139.55	139.6201	139.5	139.57	247669.0
2013-02-11 12:00:00	DIA	ETF	139.57	139.58	139.32	139.41	328086.0

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

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