PREVIEW / etf_1hour / 2014-11-18

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-11-18.parquet
  size:    231 KB
  rows:    7,388

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-11-18 04:00:00	SPY	ETF	204.3	204.51	204.24	204.46	13100.0
2014-11-18 05:00:00	SPY	ETF	204.61	204.61	204.14	204.24	22000.0
2014-11-18 06:00:00	SPY	ETF	204.31	204.46	204.24	204.46	14298.0
2014-11-18 07:00:00	SPY	ETF	204.43	204.58	204.4	204.57	123252.0
2014-11-18 08:00:00	SPY	ETF	204.49	204.56	204.33	204.43	657504.0
2014-11-18 09:00:00	SPY	ETF	204.44	205.2	204.41	205.15	9969084.0
2014-11-18 10:00:00	SPY	ETF	205.16	205.3	204.91	205.21	12761054.0
2014-11-18 11:00:00	SPY	ETF	205.211	205.36	205.14	205.33	7360447.0
2014-11-18 12:00:00	SPY	ETF	205.34	205.5	205.22	205.47	7410560.0
2014-11-18 13:00:00	SPY	ETF	205.48	205.63	205.43	205.5599	5479576.0
2014-11-18 14:00:00	SPY	ETF	205.554	205.9	205.54	205.73	8065146.0
2014-11-18 15:00:00	SPY	ETF	205.73	205.92	205.46	205.55	16870562.0
2014-11-18 16:00:00	SPY	ETF	205.55	205.57	205.29	205.34	5987134.0
2014-11-18 17:00:00	SPY	ETF	205.35	205.55	205.34	205.44	689421.0
2014-11-18 18:00:00	SPY	ETF	205.42	205.42	205.21	205.25	136303.0
2014-11-18 19:00:00	SPY	ETF	205.26	205.33	205.26	205.3	23998.0
2014-11-18 04:00:00	QQQ	ETF	102.96	103.02	102.93	103.02	4100.0
2014-11-18 05:00:00	QQQ	ETF	103.04	103.04	102.78	102.78	2200.0
2014-11-18 06:00:00	QQQ	ETF	102.81	102.82	102.79	102.81	11200.0
2014-11-18 07:00:00	QQQ	ETF	102.87	102.95	102.87	102.95	7934.0
2014-11-18 08:00:00	QQQ	ETF	102.93	102.97	102.86	102.94	65908.0
2014-11-18 09:00:00	QQQ	ETF	102.96	103.48	102.96	103.44	3443805.0
2014-11-18 10:00:00	QQQ	ETF	103.44	103.6	103.34	103.45	2818356.0
2014-11-18 11:00:00	QQQ	ETF	103.459	103.54	103.3001	103.53	1807182.0
2014-11-18 12:00:00	QQQ	ETF	103.5399	103.64	103.475	103.62	1533839.0
2014-11-18 13:00:00	QQQ	ETF	103.6153	103.7	103.51	103.62	1775411.0
2014-11-18 14:00:00	QQQ	ETF	103.615	103.82	103.615	103.72	3160119.0
2014-11-18 15:00:00	QQQ	ETF	103.72	103.819	103.61	103.67	5074478.0
2014-11-18 16:00:00	QQQ	ETF	103.67	103.6831	103.4424	103.57	1445187.0
2014-11-18 17:00:00	QQQ	ETF	103.58	103.59	103.51	103.59	4180.0
2014-11-18 18:00:00	QQQ	ETF	103.56	103.68	103.5	103.53	13968.0
2014-11-18 19:00:00	QQQ	ETF	103.56	103.59	103.52	103.53	9477.0
2014-11-18 07:00:00	IWM	ETF	116.11	116.34	116.11	116.31	45750.0
2014-11-18 08:00:00	IWM	ETF	116.3	116.33	116.13	116.18	136306.0
2014-11-18 09:00:00	IWM	ETF	116.22	116.99	116.11	116.85	4742783.0
2014-11-18 10:00:00	IWM	ETF	116.86	117.12	116.28	116.5	4726245.0
2014-11-18 11:00:00	IWM	ETF	116.5	116.59	116.29	116.5	2468792.0
2014-11-18 12:00:00	IWM	ETF	116.49	116.85	116.41	116.83	2440669.0
2014-11-18 13:00:00	IWM	ETF	116.83	116.88	116.54	116.62	1850438.0
2014-11-18 14:00:00	IWM	ETF	116.63	116.75	116.41	116.48	2890979.0
2014-11-18 15:00:00	IWM	ETF	116.48	116.635	116.31	116.39	4519379.0
2014-11-18 16:00:00	IWM	ETF	116.39	116.5639	116.18	116.23	780151.0
2014-11-18 17:00:00	IWM	ETF	116.26	116.27	116.19	116.19	1425.0
2014-11-18 18:00:00	IWM	ETF	116.19	116.19	116.19	116.19	700.0
2014-11-18 19:00:00	IWM	ETF	116.25	116.26	116.25	116.26	350.0
2014-11-18 08:00:00	DIA	ETF	176.59	176.59	176.5	176.5	300.0
2014-11-18 09:00:00	DIA	ETF	176.56	176.92	176.45	176.88	529144.0
2014-11-18 10:00:00	DIA	ETF	176.89	176.97	176.641	176.85	843326.0
2014-11-18 11:00:00	DIA	ETF	176.85	176.97	176.7801	176.92	417598.0
2014-11-18 12:00:00	DIA	ETF	176.915	176.97	176.806	176.94	480701.0

> showing 50 of 7,388 rows — these rows as CSV

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