PREVIEW / etf_1hour / 2014-04-22

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-04-22.parquet
  size:    213 KB
  rows:    6,838

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-04-22 04:00:00	SPY	ETF	186.76	187.25	186.76	187.25	1003.0
2014-04-22 05:00:00	SPY	ETF	187.07	187.07	186.92	186.99	15305.0
2014-04-22 06:00:00	SPY	ETF	186.99	187.13	186.98	187.03	22400.0
2014-04-22 07:00:00	SPY	ETF	187.02	187.12	186.92	186.99	171092.0
2014-04-22 08:00:00	SPY	ETF	187.01	187.18	186.88	187.16	383890.0
2014-04-22 09:00:00	SPY	ETF	187.18	187.67	187.11	187.66	12622933.0
2014-04-22 10:00:00	SPY	ETF	187.66	187.95	187.57	187.92	15569697.0
2014-04-22 11:00:00	SPY	ETF	187.92	188.18	187.9	188.06	10248398.0
2014-04-22 12:00:00	SPY	ETF	188.06	188.34	188.04	188.268	9273941.0
2014-04-22 13:00:00	SPY	ETF	188.27	188.4	188.18	188.32	6179922.0
2014-04-22 14:00:00	SPY	ETF	188.31	188.4	188.19	188.22	7125651.0
2014-04-22 15:00:00	SPY	ETF	188.23	188.27	187.81	187.86	16229614.0
2014-04-22 16:00:00	SPY	ETF	187.86	188.0637	187.3	187.89	4238061.0
2014-04-22 17:00:00	SPY	ETF	187.87	187.95	187.83	187.88	2103360.0
2014-04-22 18:00:00	SPY	ETF	187.88	187.88	187.76	187.86	73470.0
2014-04-22 19:00:00	SPY	ETF	187.88	187.93	187.86	187.88	25010.0
2014-04-22 05:00:00	QQQ	ETF	86.66	86.96	86.66	86.96	1190.0
2014-04-22 06:00:00	QQQ	ETF	86.97	87.08	86.97	87.02	5310.0
2014-04-22 07:00:00	QQQ	ETF	86.97	86.99	86.97	86.99	700.0
2014-04-22 08:00:00	QQQ	ETF	86.96	87.07	86.87	87.05	719668.0
2014-04-22 09:00:00	QQQ	ETF	87.05	87.31	86.9898	87.27	5683612.0
2014-04-22 10:00:00	QQQ	ETF	87.28	87.5	87.2	87.48	5254343.0
2014-04-22 11:00:00	QQQ	ETF	87.47	87.66	87.46	87.56	3690217.0
2014-04-22 12:00:00	QQQ	ETF	87.56	87.72	87.55	87.6304	2033346.0
2014-04-22 13:00:00	QQQ	ETF	87.635	87.7299	87.56	87.71	2215112.0
2014-04-22 14:00:00	QQQ	ETF	87.71	87.745	87.62	87.66	2123792.0
2014-04-22 15:00:00	QQQ	ETF	87.65	87.67	87.46	87.54	6083789.0
2014-04-22 16:00:00	QQQ	ETF	87.54	87.75	87.474	87.68	9185987.0
2014-04-22 17:00:00	QQQ	ETF	87.63	87.67	87.6	87.66	47800.0
2014-04-22 18:00:00	QQQ	ETF	87.62	87.63	87.59	87.6	4730.0
2014-04-22 19:00:00	QQQ	ETF	87.62	87.64	87.61	87.61	9950.0
2014-04-22 08:00:00	IWM	ETF	113.41	113.57	113.33	113.57	116433.0
2014-04-22 09:00:00	IWM	ETF	113.57	114.1	113.47	114.0	4813127.0
2014-04-22 10:00:00	IWM	ETF	113.98	114.47	113.82	114.25	6082056.0
2014-04-22 11:00:00	IWM	ETF	114.25	114.81	114.23	114.64	4250618.0
2014-04-22 12:00:00	IWM	ETF	114.65	115.01	114.64	114.87	2911175.0
2014-04-22 13:00:00	IWM	ETF	114.875	115.01	114.8	114.95	1485259.0
2014-04-22 14:00:00	IWM	ETF	114.95	115.02	114.79	114.9375	2048155.0
2014-04-22 15:00:00	IWM	ETF	114.92	114.95	114.51	114.62	6981691.0
2014-04-22 16:00:00	IWM	ETF	114.64	114.72	113.4221	114.6	5249071.0
2014-04-22 17:00:00	IWM	ETF	114.59	114.62	114.5	114.5	2245989.0
2014-04-22 18:00:00	IWM	ETF	114.64	114.64	114.53	114.53	1300.0
2014-04-22 19:00:00	IWM	ETF	114.61	114.62	114.55	114.59	7275.0
2014-04-22 08:00:00	DIA	ETF	164.03	164.14	164.03	164.14	650.0
2014-04-22 09:00:00	DIA	ETF	164.16	164.67	164.16	164.65	557083.0
2014-04-22 10:00:00	DIA	ETF	164.66	164.94	164.55	164.92	717094.0
2014-04-22 11:00:00	DIA	ETF	164.91	165.13	164.9	165.05	458180.0
2014-04-22 12:00:00	DIA	ETF	165.08	165.26	165.03	165.23	372488.0
2014-04-22 13:00:00	DIA	ETF	165.24	165.3	165.15	165.18	306653.0
2014-04-22 14:00:00	DIA	ETF	165.187	165.23	165.06	165.11	366891.0

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

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