PREVIEW / etf_1hour / 2013-04-16

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-04-16.parquet
  size:    206 KB
  rows:    6,417

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-04-16 04:00:00	SPY	ETF	155.57	155.57	155.26	155.26	39511.0
2013-04-16 05:00:00	SPY	ETF	155.32	155.82	155.31	155.7	72485.0
2013-04-16 06:00:00	SPY	ETF	155.69	155.7	155.43	155.47	269216.0
2013-04-16 07:00:00	SPY	ETF	155.5	156.11	155.49	155.975	993797.0
2013-04-16 08:00:00	SPY	ETF	155.975	156.39	155.15	156.26	3122000.0
2013-04-16 09:00:00	SPY	ETF	156.26	156.57	155.17	156.372	23137372.0
2013-04-16 10:00:00	SPY	ETF	156.38	156.56	155.91	156.17	24210339.0
2013-04-16 11:00:00	SPY	ETF	156.16	156.99	156.08	156.878	21530862.0
2013-04-16 12:00:00	SPY	ETF	156.88	157.23	156.75	157.18	11472601.0
2013-04-16 13:00:00	SPY	ETF	157.18	157.28	156.99	157.03	9179470.0
2013-04-16 14:00:00	SPY	ETF	157.03	157.14	156.68	156.725	12608019.0
2013-04-16 15:00:00	SPY	ETF	156.715	157.49	156.69	157.39	27853959.0
2013-04-16 16:00:00	SPY	ETF	157.4	157.43	155.1869	157.35	8954624.0
2013-04-16 17:00:00	SPY	ETF	157.34	157.42	155.1869	157.4	1107205.0
2013-04-16 18:00:00	SPY	ETF	157.38	157.38	156.96	157.06	225532.0
2013-04-16 19:00:00	SPY	ETF	157.08	157.15	157.02	157.05	68774.0
2013-04-16 04:00:00	QQQ	ETF	68.71	68.73	68.62	68.64	38000.0
2013-04-16 05:00:00	QQQ	ETF	68.62	68.82	68.62	68.82	17000.0
2013-04-16 06:00:00	QQQ	ETF	68.77	68.77	68.66	68.69	15800.0
2013-04-16 07:00:00	QQQ	ETF	68.71	68.92	68.71	68.9	215185.0
2013-04-16 08:00:00	QQQ	ETF	68.89	69.02	68.7	68.98	599603.0
2013-04-16 09:00:00	QQQ	ETF	68.98	69.1	68.84	68.9365	4093125.0
2013-04-16 10:00:00	QQQ	ETF	68.94	69.069	68.81	68.9593	3455593.0
2013-04-16 11:00:00	QQQ	ETF	68.95	69.43	68.91	69.37	5233855.0
2013-04-16 12:00:00	QQQ	ETF	69.37	69.49	69.29	69.47	1943079.0
2013-04-16 13:00:00	QQQ	ETF	69.47	69.495	69.38	69.41	1401456.0
2013-04-16 14:00:00	QQQ	ETF	69.4099	69.45	69.26	69.27	1760904.0
2013-04-16 15:00:00	QQQ	ETF	69.27	69.55	69.26	69.49	5766487.0
2013-04-16 16:00:00	QQQ	ETF	69.49	69.56	69.37	69.44	2677165.0
2013-04-16 17:00:00	QQQ	ETF	69.44	69.49	69.43	69.48	11157.0
2013-04-16 18:00:00	QQQ	ETF	69.47	69.47	69.29	69.3	28080.0
2013-04-16 19:00:00	QQQ	ETF	69.31	69.36	69.31	69.33	19079.0
2013-04-16 05:00:00	IWM	ETF	90.5	90.56	90.5	90.5	2850.0
2013-04-16 06:00:00	IWM	ETF	90.39	90.39	90.39	90.39	100.0
2013-04-16 07:00:00	IWM	ETF	90.36	90.73	90.36	90.73	399785.0
2013-04-16 08:00:00	IWM	ETF	90.71	90.99	90.4	90.95	403559.0
2013-04-16 09:00:00	IWM	ETF	90.94	91.06	90.11	90.567	7486768.0
2013-04-16 10:00:00	IWM	ETF	90.56	90.92	90.49	90.79	7666736.0
2013-04-16 11:00:00	IWM	ETF	90.7701	91.5201	90.77	91.41	7100772.0
2013-04-16 12:00:00	IWM	ETF	91.43	91.525	91.24	91.48	5314677.0
2013-04-16 13:00:00	IWM	ETF	91.48	91.55	91.31	91.35	3030001.0
2013-04-16 14:00:00	IWM	ETF	91.35	91.428	91.1	91.16	2836616.0
2013-04-16 15:00:00	IWM	ETF	91.16	91.8	91.14	91.66	9591383.0
2013-04-16 16:00:00	IWM	ETF	91.66	91.77	90.0914	91.67	3536442.0
2013-04-16 17:00:00	IWM	ETF	91.68	91.7	91.67	91.7	23853.0
2013-04-16 18:00:00	IWM	ETF	91.61	91.61	91.54	91.54	950.0
2013-04-16 19:00:00	IWM	ETF	91.55	91.6	91.55	91.55	1158.0
2013-04-16 06:00:00	DIA	ETF	146.2	146.2	146.2	146.2	100.0
2013-04-16 07:00:00	DIA	ETF	146.23	146.67	146.2	146.58	3999.0
2013-04-16 08:00:00	DIA	ETF	146.6	147.02	146.58	146.87	16016.0

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

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