PREVIEW / etf_1hour / 2014-09-19

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-09-19.parquet
  size:    224 KB
  rows:    7,093

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-09-19 04:00:00	SPY	ETF	201.75	201.75	201.48	201.59	9780.0
2014-09-19 05:00:00	SPY	ETF	201.65	201.7	201.49	201.49	8325.0
2014-09-19 06:00:00	SPY	ETF	201.46	201.61	201.46	201.52	87305.0
2014-09-19 07:00:00	SPY	ETF	201.52	201.57	201.29	201.37	253393.0
2014-09-19 08:00:00	SPY	ETF	201.47	202.45	201.23	201.54	1135349.0
2014-09-19 09:00:00	SPY	ETF	201.54	201.82	201.3	201.46	18951971.0
2014-09-19 10:00:00	SPY	ETF	201.45	201.899	201.03	201.185	17895606.0
2014-09-19 11:00:00	SPY	ETF	201.19	201.33	200.88	200.99	10414682.0
2014-09-19 12:00:00	SPY	ETF	200.99	201.02	200.55	200.68	13180646.0
2014-09-19 13:00:00	SPY	ETF	200.68	200.79	200.29	200.69	11795326.0
2014-09-19 14:00:00	SPY	ETF	200.7	201.05	200.65	201.01	9437802.0
2014-09-19 15:00:00	SPY	ETF	201.015	201.09	200.68	200.73	19750098.0
2014-09-19 16:00:00	SPY	ETF	200.71	200.96	200.48	200.56	13243378.0
2014-09-19 17:00:00	SPY	ETF	200.55	200.6	200.3	200.38	993154.0
2014-09-19 18:00:00	SPY	ETF	200.35	200.43	200.3	200.3	162322.0
2014-09-19 19:00:00	SPY	ETF	200.34	200.35	200.28	200.28	30314.0
2014-09-19 04:00:00	QQQ	ETF	100.45	100.49	100.4	100.48	23098.0
2014-09-19 05:00:00	QQQ	ETF	100.49	100.49	100.44	100.45	3864.0
2014-09-19 06:00:00	QQQ	ETF	100.47	100.47	100.42	100.44	40575.0
2014-09-19 07:00:00	QQQ	ETF	100.44	100.46	100.33	100.34	96234.0
2014-09-19 08:00:00	QQQ	ETF	100.37	100.45	100.31	100.44	245280.0
2014-09-19 09:00:00	QQQ	ETF	100.44	100.47	100.23	100.3773	6228213.0
2014-09-19 10:00:00	QQQ	ETF	100.37	100.43	100.09	100.251	6360286.0
2014-09-19 11:00:00	QQQ	ETF	100.25	100.335	99.965	100.08	4551524.0
2014-09-19 12:00:00	QQQ	ETF	100.0801	100.0939	99.6	99.74	6737760.0
2014-09-19 13:00:00	QQQ	ETF	99.74	99.935	99.58	99.86	3867155.0
2014-09-19 14:00:00	QQQ	ETF	99.865	100.12	99.8	100.09	4034341.0
2014-09-19 15:00:00	QQQ	ETF	100.09	100.16	99.941	99.96	7623875.0
2014-09-19 16:00:00	QQQ	ETF	99.96	100.0758	99.85	99.87	3291486.0
2014-09-19 17:00:00	QQQ	ETF	99.88	99.99	99.8	99.8	218085.0
2014-09-19 18:00:00	QQQ	ETF	99.83	99.85	99.76	99.78	10145.0
2014-09-19 19:00:00	QQQ	ETF	99.83	99.85	99.76	99.76	2804.0
2014-09-19 04:00:00	IWM	ETF	115.68	115.81	115.68	115.81	300.0
2014-09-19 06:00:00	IWM	ETF	115.93	115.96	115.93	115.94	2300.0
2014-09-19 07:00:00	IWM	ETF	115.95	115.95	115.87	115.89	57300.0
2014-09-19 08:00:00	IWM	ETF	115.89	116.1	115.8	116.06	266246.0
2014-09-19 09:00:00	IWM	ETF	116.04	116.06	115.43	115.71	3946769.0
2014-09-19 10:00:00	IWM	ETF	115.72	115.85	115.0	115.08	5083955.0
2014-09-19 11:00:00	IWM	ETF	115.08	115.16	114.42	114.5601	5904285.0
2014-09-19 12:00:00	IWM	ETF	114.54	114.55	113.78	113.9	6980070.0
2014-09-19 13:00:00	IWM	ETF	113.9	113.94	113.61	113.88	5974752.0
2014-09-19 14:00:00	IWM	ETF	113.89	114.26	113.87	113.99	4510846.0
2014-09-19 15:00:00	IWM	ETF	113.99	114.13	113.85	114.0	7568874.0
2014-09-19 16:00:00	IWM	ETF	113.99	115.3123	113.64	113.79	3565546.0
2014-09-19 17:00:00	IWM	ETF	113.8	113.94	113.69	113.79	43606.0
2014-09-19 18:00:00	IWM	ETF	113.78	113.78	113.77	113.77	425.0
2014-09-19 07:00:00	DIA	ETF	172.9	172.9	172.9	172.9	300.0
2014-09-19 08:00:00	DIA	ETF	172.82	172.98	172.8	172.9	19045.0
2014-09-19 09:00:00	DIA	ETF	172.91	173.13	172.85	172.94	1876366.0
2014-09-19 10:00:00	DIA	ETF	172.93	173.03	172.68	172.8154	594507.0

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

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