PREVIEW / etf_1hour / 2014-11-17

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-11-17.parquet
  size:    229 KB
  rows:    7,293

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-17 04:00:00	SPY	ETF	203.89	203.89	203.32	203.48	22255.0
2014-11-17 05:00:00	SPY	ETF	203.52	203.85	203.48	203.74	17176.0
2014-11-17 06:00:00	SPY	ETF	203.74	203.88	203.66	203.77	268215.0
2014-11-17 07:00:00	SPY	ETF	203.72	203.93	203.63	203.85	208012.0
2014-11-17 08:00:00	SPY	ETF	203.85	204.24	203.46	203.91	669047.0
2014-11-17 09:00:00	SPY	ETF	203.9	204.13	203.69	204.03	11087308.0
2014-11-17 10:00:00	SPY	ETF	204.03	204.49	203.85	204.26	13683517.0
2014-11-17 11:00:00	SPY	ETF	204.265	204.28	203.65	203.94	7918468.0
2014-11-17 12:00:00	SPY	ETF	203.93	204.39	203.81	204.21	5159592.0
2014-11-17 13:00:00	SPY	ETF	204.219	204.58	204.2	204.412	7250830.0
2014-11-17 14:00:00	SPY	ETF	204.41	204.54	204.33	204.45	4644499.0
2014-11-17 15:00:00	SPY	ETF	204.45	204.5	204.23	204.38	11782640.0
2014-11-17 16:00:00	SPY	ETF	204.39	204.51	204.04	204.47	16808627.0
2014-11-17 17:00:00	SPY	ETF	204.48	204.5	204.4	204.44	38305.0
2014-11-17 18:00:00	SPY	ETF	204.44	204.44	204.37	204.4	41535.0
2014-11-17 19:00:00	SPY	ETF	204.41	204.46	204.39	204.42	23802.0
2014-11-17 04:00:00	QQQ	ETF	102.83	102.95	102.66	102.72	10000.0
2014-11-17 05:00:00	QQQ	ETF	102.8	102.97	102.8	102.91	16650.0
2014-11-17 06:00:00	QQQ	ETF	102.9	103.0	102.88	102.94	9647.0
2014-11-17 07:00:00	QQQ	ETF	102.96	103.05	102.88	103.03	90820.0
2014-11-17 08:00:00	QQQ	ETF	103.01	103.06	102.87	103.03	147750.0
2014-11-17 09:00:00	QQQ	ETF	103.01	103.17	102.881	103.125	3015001.0
2014-11-17 10:00:00	QQQ	ETF	103.13	103.21	102.73	102.901	3252420.0
2014-11-17 11:00:00	QQQ	ETF	102.9	102.919	102.42	102.6767	3690208.0
2014-11-17 12:00:00	QQQ	ETF	102.67	103.02	102.58	102.8	1788812.0
2014-11-17 13:00:00	QQQ	ETF	102.79	103.01	102.78	102.91	1492695.0
2014-11-17 14:00:00	QQQ	ETF	102.9	103.0251	102.85	102.99	936691.0
2014-11-17 15:00:00	QQQ	ETF	102.98	102.99	102.805	102.9	2542492.0
2014-11-17 16:00:00	QQQ	ETF	102.89	103.1805	102.88	102.94	1414152.0
2014-11-17 17:00:00	QQQ	ETF	102.94	102.94	102.86	102.9	40579.0
2014-11-17 18:00:00	QQQ	ETF	102.9	102.9	102.87	102.87	17609.0
2014-11-17 19:00:00	QQQ	ETF	102.94	102.94	102.91	102.94	3559.0
2014-11-17 04:00:00	IWM	ETF	116.45	116.45	116.45	116.45	182.0
2014-11-17 05:00:00	IWM	ETF	116.4	116.4	116.4	116.4	100.0
2014-11-17 07:00:00	IWM	ETF	116.34	116.6	116.34	116.59	36150.0
2014-11-17 08:00:00	IWM	ETF	116.52	116.69	116.43	116.64	48728.0
2014-11-17 09:00:00	IWM	ETF	116.65	116.93	116.51	116.71	2340268.0
2014-11-17 10:00:00	IWM	ETF	116.72	116.86	115.97	116.26	4773792.0
2014-11-17 11:00:00	IWM	ETF	116.25	116.2631	115.705	116.01	3900299.0
2014-11-17 12:00:00	IWM	ETF	116.0	116.3	115.88	116.06	1658599.0
2014-11-17 13:00:00	IWM	ETF	116.055	116.41	115.88	116.06	2117795.0
2014-11-17 14:00:00	IWM	ETF	116.05	116.175	115.98	116.06	1610074.0
2014-11-17 15:00:00	IWM	ETF	116.06	116.6995	115.68	115.71	4580578.0
2014-11-17 16:00:00	IWM	ETF	115.7	115.95	115.7	115.95	4913799.0
2014-11-17 17:00:00	IWM	ETF	115.92	115.92	115.88	115.89	5628.0
2014-11-17 18:00:00	IWM	ETF	115.94	115.94	115.94	115.94	100.0
2014-11-17 19:00:00	IWM	ETF	115.9	115.9	115.8999	115.9	700.0
2014-11-17 04:00:00	DIA	ETF	175.7	175.7	175.7	175.7	200.0
2014-11-17 09:00:00	DIA	ETF	176.02	176.3	176.0	176.2	748693.0
2014-11-17 10:00:00	DIA	ETF	176.2	176.6	176.13	176.47	831625.0

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

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