PREVIEW / etf_1hour / 2015-12-24

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-12-24.parquet
  size:    152 KB
  rows:    4,668

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
2015-12-24 04:00:00	SPY	ETF	205.5	205.5	205.29	205.47	3464.0
2015-12-24 05:00:00	SPY	ETF	205.37	205.55	205.33	205.45	25550.0
2015-12-24 06:00:00	SPY	ETF	205.5	205.64	205.48	205.64	7410.0
2015-12-24 07:00:00	SPY	ETF	205.68	205.77	205.61	205.66	37036.0
2015-12-24 08:00:00	SPY	ETF	205.7	205.8	205.57	205.65	151966.0
2015-12-24 09:00:00	SPY	ETF	205.65	206.08	205.57	205.59	5681755.0
2015-12-24 10:00:00	SPY	ETF	205.58	205.81	205.42	205.7751	7438019.0
2015-12-24 11:00:00	SPY	ETF	205.78	206.08	205.66	206.06	8107080.0
2015-12-24 12:00:00	SPY	ETF	206.06	206.33	205.55	205.57	14181976.0
2015-12-24 13:00:00	SPY	ETF	205.57	205.71	205.35	205.52	6247484.0
2015-12-24 14:00:00	SPY	ETF	205.54	205.54	205.42	205.51	36953.0
2015-12-24 15:00:00	SPY	ETF	205.52	205.52	205.47	205.49	7437.0
2015-12-24 16:00:00	SPY	ETF	205.49	205.52	205.48	205.49	6729.0
2015-12-24 05:00:00	QQQ	ETF	112.29	112.29	112.28	112.28	200.0
2015-12-24 06:00:00	QQQ	ETF	112.3	112.36	112.3	112.36	290.0
2015-12-24 07:00:00	QQQ	ETF	112.52	112.52	112.52	112.52	400.0
2015-12-24 08:00:00	QQQ	ETF	112.5	112.57	112.43	112.46	45741.0
2015-12-24 09:00:00	QQQ	ETF	112.5	112.86	112.5	112.65	2375515.0
2015-12-24 10:00:00	QQQ	ETF	112.64	112.75	112.54	112.72	1928547.0
2015-12-24 11:00:00	QQQ	ETF	112.72	112.89	112.6	112.8899	2003564.0
2015-12-24 12:00:00	QQQ	ETF	112.88	112.9	112.56	112.56	2843803.0
2015-12-24 13:00:00	QQQ	ETF	112.57	112.59	112.39	112.54	366148.0
2015-12-24 14:00:00	QQQ	ETF	112.5	112.5	112.5	112.5	200.0
2015-12-24 15:00:00	QQQ	ETF	112.5	112.5	112.45	112.45	700.0
2015-12-24 16:00:00	QQQ	ETF	112.46	112.55	112.46	112.51	800.0
2015-12-24 04:00:00	IWM	ETF	114.45	114.45	114.07	114.07	201.0
2015-12-24 05:00:00	IWM	ETF	114.23	114.24	114.23	114.24	520.0
2015-12-24 07:00:00	IWM	ETF	114.46	114.46	114.35	114.35	1900.0
2015-12-24 08:00:00	IWM	ETF	114.36	114.41	114.3	114.3	1550.0
2015-12-24 09:00:00	IWM	ETF	114.38	114.78	114.1701	114.19	2476523.0
2015-12-24 10:00:00	IWM	ETF	114.18	114.64	114.15	114.63	2142440.0
2015-12-24 11:00:00	IWM	ETF	114.625	114.7	114.4701	114.69	1771277.0
2015-12-24 12:00:00	IWM	ETF	114.69	115.16	114.46	114.48	3019868.0
2015-12-24 13:00:00	IWM	ETF	114.48	114.53	114.15	114.4	1072379.0
2015-12-24 15:00:00	IWM	ETF	114.16	114.16	114.16	114.16	300.0
2015-12-24 07:00:00	DIA	ETF	175.54	175.54	175.54	175.54	200.0
2015-12-24 08:00:00	DIA	ETF	175.63	175.63	175.49	175.5	1400.0
2015-12-24 09:00:00	DIA	ETF	175.5	175.72	175.33	175.33	345071.0
2015-12-24 10:00:00	DIA	ETF	175.31	175.49	175.18	175.42	455558.0
2015-12-24 11:00:00	DIA	ETF	175.43	175.62	175.29	175.62	266304.0
2015-12-24 12:00:00	DIA	ETF	175.61	175.82	175.23	175.23	569466.0
2015-12-24 13:00:00	DIA	ETF	175.24	175.27	174.9999	175.22	33721.0
2015-12-24 14:00:00	DIA	ETF	175.0	175.0	175.0	175.0	100.0
2015-12-24 07:00:00	GLD	ETF	102.56	102.56	102.56	102.56	280.0
2015-12-24 08:00:00	GLD	ETF	102.7	102.72	102.63	102.65	1118.0
2015-12-24 09:00:00	GLD	ETF	102.74	102.99	102.73	102.82	468070.0
2015-12-24 10:00:00	GLD	ETF	102.82	102.91	102.8	102.88	323744.0
2015-12-24 11:00:00	GLD	ETF	102.89	103.02	102.86	102.955	229478.0
2015-12-24 12:00:00	GLD	ETF	102.96	103.03	102.93	103.01	562221.0
2015-12-24 13:00:00	GLD	ETF	103.03	103.05	102.99	103.05	60558.0

> showing 50 of 4,668 rows — these rows as CSV

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