PREVIEW / etf_1hour / 2014-06-05

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-06-05.parquet
  size:    219 KB
  rows:    6,933

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-06-05 04:00:00	SPY	ETF	193.06	193.25	193.06	193.14	6200.0
2014-06-05 05:00:00	SPY	ETF	193.14	193.15	193.07	193.09	8932.0
2014-06-05 06:00:00	SPY	ETF	193.09	193.14	193.09	193.1	26751.0
2014-06-05 07:00:00	SPY	ETF	193.1	193.55	192.99	193.33	762905.0
2014-06-05 08:00:00	SPY	ETF	193.5	194.01	193.26	193.53	3182900.0
2014-06-05 09:00:00	SPY	ETF	193.54	193.68	193.0	193.3	14212507.0
2014-06-05 10:00:00	SPY	ETF	193.3	193.48	192.7	193.41	14630254.0
2014-06-05 11:00:00	SPY	ETF	193.4	194.22	193.365	194.197	15045129.0
2014-06-05 12:00:00	SPY	ETF	194.2	194.59	194.19	194.39	10000164.0
2014-06-05 13:00:00	SPY	ETF	194.395	194.54	194.27	194.427	4718593.0
2014-06-05 14:00:00	SPY	ETF	194.43	194.65	194.365	194.38	6446675.0
2014-06-05 15:00:00	SPY	ETF	194.38	194.525	194.27	194.45	12041241.0
2014-06-05 16:00:00	SPY	ETF	194.44	194.51	193.2387	194.42	4451823.0
2014-06-05 17:00:00	SPY	ETF	194.45	194.52	194.39	194.4	117212.0
2014-06-05 18:00:00	SPY	ETF	194.4	194.47	194.38	194.47	66895.0
2014-06-05 19:00:00	SPY	ETF	194.45	194.53	194.45	194.53	31440.0
2014-06-05 04:00:00	QQQ	ETF	91.58	91.58	91.5	91.5	2100.0
2014-06-05 05:00:00	QQQ	ETF	91.47	91.47	91.47	91.47	100.0
2014-06-05 06:00:00	QQQ	ETF	91.5	91.5	91.5	91.5	558.0
2014-06-05 07:00:00	QQQ	ETF	91.5	91.7	91.47	91.55	126530.0
2014-06-05 08:00:00	QQQ	ETF	91.68	91.85	91.58	91.64	381983.0
2014-06-05 09:00:00	QQQ	ETF	91.64	91.8	91.45	91.64	7350444.0
2014-06-05 10:00:00	QQQ	ETF	91.63	91.75	91.29	91.71	5392363.0
2014-06-05 11:00:00	QQQ	ETF	91.7	92.13	91.68	92.085	5775979.0
2014-06-05 12:00:00	QQQ	ETF	92.08	92.38	92.08	92.27	3566612.0
2014-06-05 13:00:00	QQQ	ETF	92.27	92.36	92.155	92.26	2230987.0
2014-06-05 14:00:00	QQQ	ETF	92.26	92.46	92.245	92.29	4159850.0
2014-06-05 15:00:00	QQQ	ETF	92.285	92.38	92.21	92.3	3280835.0
2014-06-05 16:00:00	QQQ	ETF	92.29	92.35	91.5127	92.33	1689724.0
2014-06-05 17:00:00	QQQ	ETF	92.32	92.37	92.32	92.37	7207.0
2014-06-05 18:00:00	QQQ	ETF	92.35	92.36	92.31	92.34	5722.0
2014-06-05 19:00:00	QQQ	ETF	92.36	92.39	92.33	92.38	18879.0
2014-06-05 07:00:00	IWM	ETF	112.5	112.95	112.5	112.75	203647.0
2014-06-05 08:00:00	IWM	ETF	112.73	113.3	112.65	112.88	1176014.0
2014-06-05 09:00:00	IWM	ETF	112.9	113.01	112.44	112.705	6593501.0
2014-06-05 10:00:00	IWM	ETF	112.71	112.785	112.09	112.555	6909554.0
2014-06-05 11:00:00	IWM	ETF	112.55	113.95	112.5	113.93	9064399.0
2014-06-05 12:00:00	IWM	ETF	113.93	114.7	113.925	114.37	9040811.0
2014-06-05 13:00:00	IWM	ETF	114.38	114.63	114.275	114.459	3832572.0
2014-06-05 14:00:00	IWM	ETF	114.45	114.88	114.43	114.59	5493714.0
2014-06-05 15:00:00	IWM	ETF	114.59	114.79	114.52	114.77	9704456.0
2014-06-05 16:00:00	IWM	ETF	114.78	114.85	112.5054	112.5054	4437134.0
2014-06-05 17:00:00	IWM	ETF	114.77	114.89	114.77	114.84	93270.0
2014-06-05 18:00:00	IWM	ETF	114.77	114.77	114.77	114.77	116.0
2014-06-05 19:00:00	IWM	ETF	114.87	114.88	114.86	114.86	3289.0
2014-06-05 07:00:00	DIA	ETF	167.16	167.53	167.16	167.53	10100.0
2014-06-05 08:00:00	DIA	ETF	167.55	167.83	167.51	167.64	54140.0
2014-06-05 09:00:00	DIA	ETF	167.55	167.67	167.21	167.45	1946737.0
2014-06-05 10:00:00	DIA	ETF	167.45	167.54	166.92	167.46	686686.0
2014-06-05 11:00:00	DIA	ETF	167.46	168.09	167.43	168.07	680220.0

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

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