PREVIEW / etf_1hour / 2016-09-14

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-09-14.parquet
  size:    253 KB
  rows:    8,094

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
2016-09-14 04:00:00	SPY	ETF	213.67	214.19	213.55	214.03	48644.0
2016-09-14 05:00:00	SPY	ETF	213.95	213.95	213.5	213.76	44108.0
2016-09-14 06:00:00	SPY	ETF	213.73	213.78	213.6	213.6	69901.0
2016-09-14 07:00:00	SPY	ETF	213.62	214.07	213.62	213.87	270378.0
2016-09-14 08:00:00	SPY	ETF	213.89	214.03	213.66	213.85	381351.0
2016-09-14 09:00:00	SPY	ETF	213.87	213.87	213.0	213.54	14379135.0
2016-09-14 10:00:00	SPY	ETF	213.54	214.7	213.445	213.77	21725004.0
2016-09-14 11:00:00	SPY	ETF	213.76	214.2	213.4801	214.025	13621960.0
2016-09-14 12:00:00	SPY	ETF	214.03	214.24	213.63	213.79	11056717.0
2016-09-14 13:00:00	SPY	ETF	213.79	213.99	213.28	213.402	9290587.0
2016-09-14 14:00:00	SPY	ETF	213.4	213.54	212.79	213.35	17994252.0
2016-09-14 15:00:00	SPY	ETF	213.35	213.43	212.5	213.14	34677754.0
2016-09-14 16:00:00	SPY	ETF	213.14	213.44	212.4	212.86	8461053.0
2016-09-14 17:00:00	SPY	ETF	212.86	213.15	212.8	212.81	1091085.0
2016-09-14 18:00:00	SPY	ETF	212.81	212.96	212.8	212.92	128873.0
2016-09-14 19:00:00	SPY	ETF	212.92	213.08	212.9	213.07	27227.0
2016-09-14 04:00:00	QQQ	ETF	115.6	115.8	115.6	115.8	10000.0
2016-09-14 05:00:00	QQQ	ETF	115.65	115.65	115.52	115.59	4800.0
2016-09-14 06:00:00	QQQ	ETF	115.63	115.63	115.63	115.63	2100.0
2016-09-14 07:00:00	QQQ	ETF	115.63	115.85	115.62	115.74	77441.0
2016-09-14 08:00:00	QQQ	ETF	115.59	115.83	115.59	115.79	57737.0
2016-09-14 09:00:00	QQQ	ETF	115.76	115.89	115.33	115.841	4026440.0
2016-09-14 10:00:00	QQQ	ETF	115.84	116.47	115.75	116.1107	4893455.0
2016-09-14 11:00:00	QQQ	ETF	116.11	116.4368	115.94	116.32	2568846.0
2016-09-14 12:00:00	QQQ	ETF	116.32	116.47	116.13	116.18	1841633.0
2016-09-14 13:00:00	QQQ	ETF	116.18	116.33	115.82	115.93	2643588.0
2016-09-14 14:00:00	QQQ	ETF	115.93	116.07	115.6	116.0	2735061.0
2016-09-14 15:00:00	QQQ	ETF	116.0	116.03	115.47	115.86	4752306.0
2016-09-14 16:00:00	QQQ	ETF	115.85	115.87	115.49	115.63	871968.0
2016-09-14 17:00:00	QQQ	ETF	115.7	115.84	115.59	115.65	45926.0
2016-09-14 18:00:00	QQQ	ETF	115.63	115.68	115.59	115.66	8135.0
2016-09-14 19:00:00	QQQ	ETF	115.66	115.76	115.66	115.75	20742.0
2016-09-14 04:00:00	IWM	ETF	121.16	121.16	121.16	121.16	100.0
2016-09-14 07:00:00	IWM	ETF	120.93	121.13	120.93	120.99	83320.0
2016-09-14 08:00:00	IWM	ETF	120.99	121.14	120.87	121.07	56294.0
2016-09-14 09:00:00	IWM	ETF	121.07	121.07	120.29	120.64	3962052.0
2016-09-14 10:00:00	IWM	ETF	120.63	121.47	120.53	120.675	5830468.0
2016-09-14 11:00:00	IWM	ETF	120.67	121.11	120.49	120.95	3452358.0
2016-09-14 12:00:00	IWM	ETF	120.94	121.13	120.71	120.82	2385722.0
2016-09-14 13:00:00	IWM	ETF	120.815	121.01	120.605	120.625	2322183.0
2016-09-14 14:00:00	IWM	ETF	120.625	120.99	120.41	120.81	2715786.0
2016-09-14 15:00:00	IWM	ETF	120.81	120.86	120.34	120.59	4823170.0
2016-09-14 16:00:00	IWM	ETF	120.6	120.62	120.24	120.49	1107925.0
2016-09-14 17:00:00	IWM	ETF	120.48	120.48	120.44	120.45	10434.0
2016-09-14 18:00:00	IWM	ETF	120.33	120.53	120.33	120.53	3147.0
2016-09-14 04:00:00	DIA	ETF	181.3	181.43	181.3	181.43	200.0
2016-09-14 06:00:00	DIA	ETF	181.11	181.11	181.11	181.11	100.0
2016-09-14 07:00:00	DIA	ETF	181.41	181.41	181.39	181.41	10000.0
2016-09-14 08:00:00	DIA	ETF	181.22	181.39	181.12	181.39	2805.0
2016-09-14 09:00:00	DIA	ETF	181.16	181.16	180.55	180.93	463379.0

> showing 50 of 8,094 rows — these rows as CSV

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