PREVIEW / etf_1hour / 2014-02-25

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-02-25.parquet
  size:    217 KB
  rows:    6,820

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
2014-02-25 04:00:00	SPY	ETF	184.78	184.87	184.73	184.73	6590.0
2014-02-25 05:00:00	SPY	ETF	184.73	184.84	184.73	184.79	44984.0
2014-02-25 06:00:00	SPY	ETF	184.78	184.78	184.61	184.73	89046.0
2014-02-25 07:00:00	SPY	ETF	184.71	184.81	184.6	184.68	206256.0
2014-02-25 08:00:00	SPY	ETF	184.69	185.04	184.61	184.93	1374537.0
2014-02-25 09:00:00	SPY	ETF	184.93	185.26	184.285	184.46	14477009.0
2014-02-25 10:00:00	SPY	ETF	184.44	185.1	184.23	184.999	17608567.0
2014-02-25 11:00:00	SPY	ETF	185.0	185.59	184.82	185.03	13947604.0
2014-02-25 12:00:00	SPY	ETF	185.02	185.2	184.9	185.13	9981511.0
2014-02-25 13:00:00	SPY	ETF	185.13	185.39	185.02	185.091	7462395.0
2014-02-25 14:00:00	SPY	ETF	185.09	185.2	184.74	184.9	9998851.0
2014-02-25 15:00:00	SPY	ETF	184.905	184.91	184.48	184.8	24867274.0
2014-02-25 16:00:00	SPY	ETF	184.79	185.23	184.773	185.23	13524968.0
2014-02-25 17:00:00	SPY	ETF	185.2	185.35	185.2	185.26	142045.0
2014-02-25 18:00:00	SPY	ETF	185.26	185.29	185.2	185.2	138459.0
2014-02-25 19:00:00	SPY	ETF	185.21	185.38	185.21	185.3	255669.0
2014-02-25 04:00:00	QQQ	ETF	90.37	90.37	90.36	90.36	1600.0
2014-02-25 05:00:00	QQQ	ETF	90.34	90.34	90.34	90.34	2000.0
2014-02-25 06:00:00	QQQ	ETF	90.31	90.35	90.28	90.35	11000.0
2014-02-25 07:00:00	QQQ	ETF	90.35	90.38	90.31	90.34	16039.0
2014-02-25 08:00:00	QQQ	ETF	90.34	90.52	90.33	90.47	170153.0
2014-02-25 09:00:00	QQQ	ETF	90.47	90.6	90.11	90.16	4021511.0
2014-02-25 10:00:00	QQQ	ETF	90.15	90.47	90.02	90.41	3838123.0
2014-02-25 11:00:00	QQQ	ETF	90.405	90.72	90.385	90.46	2763946.0
2014-02-25 12:00:00	QQQ	ETF	90.48	90.5	90.2899	90.41	1758177.0
2014-02-25 13:00:00	QQQ	ETF	90.41	90.52	90.295	90.319	1842758.0
2014-02-25 14:00:00	QQQ	ETF	90.31	90.38	90.175	90.25	2104830.0
2014-02-25 15:00:00	QQQ	ETF	90.251	90.3	90.0823	90.3	5579936.0
2014-02-25 16:00:00	QQQ	ETF	90.3	90.53	90.1888	90.53	1655181.0
2014-02-25 17:00:00	QQQ	ETF	90.53	90.62	90.52	90.57	39300.0
2014-02-25 18:00:00	QQQ	ETF	90.58	90.58	90.2614	90.53	678500.0
2014-02-25 19:00:00	QQQ	ETF	90.56	90.6	90.55	90.55	14000.0
2014-02-25 07:00:00	IWM	ETF	116.4	116.42	116.31	116.37	8100.0
2014-02-25 08:00:00	IWM	ETF	116.35	116.68	116.34	116.55	198679.0
2014-02-25 09:00:00	IWM	ETF	116.58	116.91	116.29	116.29	4235220.0
2014-02-25 10:00:00	IWM	ETF	116.32	116.82	116.18	116.77	5045075.0
2014-02-25 11:00:00	IWM	ETF	116.77	117.24	116.625	116.82	4110393.0
2014-02-25 12:00:00	IWM	ETF	116.82	116.84	116.52	116.755	2651629.0
2014-02-25 13:00:00	IWM	ETF	116.75	116.9	116.625	116.688	1724745.0
2014-02-25 14:00:00	IWM	ETF	116.69	116.77	116.44	116.6	2194673.0
2014-02-25 15:00:00	IWM	ETF	116.6	116.68	116.34	116.62	4419026.0
2014-02-25 16:00:00	IWM	ETF	116.61	116.9571	116.61	116.78	748125.0
2014-02-25 17:00:00	IWM	ETF	116.81	116.88	116.81	116.82	42538.0
2014-02-25 18:00:00	IWM	ETF	116.82	116.82	116.82	116.82	220.0
2014-02-25 19:00:00	IWM	ETF	116.82	116.87	116.78	116.78	7165.0
2014-02-25 06:00:00	DIA	ETF	161.75	161.75	161.75	161.75	1000.0
2014-02-25 07:00:00	DIA	ETF	161.65	161.65	161.49	161.5	8600.0
2014-02-25 08:00:00	DIA	ETF	161.55	161.66	161.55	161.66	700.0
2014-02-25 09:00:00	DIA	ETF	161.64	162.01	161.15	161.27	1006311.0
2014-02-25 10:00:00	DIA	ETF	161.27	161.85	161.13	161.77	1149862.0

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

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