PREVIEW / etf_1hour / 2014-05-06

all etf 1-hour files

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

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-05-06 04:00:00	SPY	ETF	188.5	188.62	188.25	188.32	1794.0
2014-05-06 05:00:00	SPY	ETF	188.53	188.53	188.53	188.53	424.0
2014-05-06 06:00:00	SPY	ETF	188.42	188.42	188.26	188.26	5265.0
2014-05-06 07:00:00	SPY	ETF	188.27	188.27	188.1	188.22	45101.0
2014-05-06 08:00:00	SPY	ETF	188.2	188.21	187.81	187.84	555937.0
2014-05-06 09:00:00	SPY	ETF	187.85	188.03	187.51	187.87	13062556.0
2014-05-06 10:00:00	SPY	ETF	187.87	188.13	187.54	187.59	12027539.0
2014-05-06 11:00:00	SPY	ETF	187.56	187.87	187.43	187.84	6311060.0
2014-05-06 12:00:00	SPY	ETF	187.83	187.87	187.5	187.6651	3839365.0
2014-05-06 13:00:00	SPY	ETF	187.66	187.7	187.0	187.03	9936082.0
2014-05-06 14:00:00	SPY	ETF	187.04	187.18	186.82	186.96	9267113.0
2014-05-06 15:00:00	SPY	ETF	186.965	187.25	186.74	186.82	17401211.0
2014-05-06 16:00:00	SPY	ETF	186.82	188.4499	186.7601	187.0	10968335.0
2014-05-06 17:00:00	SPY	ETF	187.0	187.03	186.9	186.93	591516.0
2014-05-06 18:00:00	SPY	ETF	186.93	187.02	186.88	186.92	63231.0
2014-05-06 19:00:00	SPY	ETF	186.9	186.96	186.86	186.91	27056.0
2014-05-06 04:00:00	QQQ	ETF	88.03	88.03	87.85	87.85	1100.0
2014-05-06 05:00:00	QQQ	ETF	88.0	88.1	88.0	88.1	6850.0
2014-05-06 06:00:00	QQQ	ETF	88.02	88.02	87.96	87.96	2200.0
2014-05-06 07:00:00	QQQ	ETF	88.0	88.0	87.8	87.8	1500.0
2014-05-06 08:00:00	QQQ	ETF	87.95	87.95	87.63	87.69	194068.0
2014-05-06 09:00:00	QQQ	ETF	87.67	87.84	87.51	87.81	4885204.0
2014-05-06 10:00:00	QQQ	ETF	87.82	87.86	87.43	87.46	4501348.0
2014-05-06 11:00:00	QQQ	ETF	87.45	87.6	87.36	87.59	2656879.0
2014-05-06 12:00:00	QQQ	ETF	87.59	87.6	87.43	87.527	1217031.0
2014-05-06 13:00:00	QQQ	ETF	87.53	87.54	87.02	87.0399	3713667.0
2014-05-06 14:00:00	QQQ	ETF	87.03	87.1	86.89	86.955	3050468.0
2014-05-06 15:00:00	QQQ	ETF	86.95	87.13	86.77	86.81	6711391.0
2014-05-06 16:00:00	QQQ	ETF	86.82	87.9727	86.74	86.86	2533715.0
2014-05-06 17:00:00	QQQ	ETF	86.85	86.88	86.81	86.83	386427.0
2014-05-06 18:00:00	QQQ	ETF	86.84	86.87	86.8	86.8	8540.0
2014-05-06 19:00:00	QQQ	ETF	86.8	86.83	86.78	86.82	12550.0
2014-05-06 08:00:00	IWM	ETF	111.67	111.67	111.15	111.2	136197.0
2014-05-06 09:00:00	IWM	ETF	111.24	111.43	110.77	111.4	4656908.0
2014-05-06 10:00:00	IWM	ETF	111.4014	111.71	110.84	110.88	5443114.0
2014-05-06 11:00:00	IWM	ETF	110.87	111.24	110.77	111.19	2813090.0
2014-05-06 12:00:00	IWM	ETF	111.2	111.28	110.95	111.12	1680834.0
2014-05-06 13:00:00	IWM	ETF	111.12	111.22	110.25	110.31	4913310.0
2014-05-06 14:00:00	IWM	ETF	110.32	110.37	109.99	110.17	6502044.0
2014-05-06 15:00:00	IWM	ETF	110.17	110.53	110.01	110.09	9037456.0
2014-05-06 16:00:00	IWM	ETF	110.09	111.8738	110.01	110.09	2224251.0
2014-05-06 17:00:00	IWM	ETF	110.09	110.13	109.99	110.13	37300.0
2014-05-06 18:00:00	IWM	ETF	110.06	110.06	110.06	110.06	100.0
2014-05-06 19:00:00	IWM	ETF	110.02	110.02	110.02	110.02	200.0
2014-05-06 08:00:00	DIA	ETF	164.7	164.7	164.62	164.62	3400.0
2014-05-06 09:00:00	DIA	ETF	164.58	164.68	164.07	164.25	683417.0
2014-05-06 10:00:00	DIA	ETF	164.27	164.44	164.03	164.06	1633517.0
2014-05-06 11:00:00	DIA	ETF	164.06	164.34	163.94	164.32	429662.0
2014-05-06 12:00:00	DIA	ETF	164.31	164.33	164.04	164.2	177812.0
2014-05-06 13:00:00	DIA	ETF	164.1987	164.2399	163.78	163.82	331453.0

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

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