PREVIEW / etf_1hour / 2016-07-11

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-07-11.parquet
  size:    262 KB
  rows:    8,428

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-07-11 04:00:00	SPY	ETF	213.0	213.27	212.94	212.94	36680.0
2016-07-11 05:00:00	SPY	ETF	212.9	213.31	212.73	213.19	56419.0
2016-07-11 06:00:00	SPY	ETF	213.24	213.24	212.8	213.14	92307.0
2016-07-11 07:00:00	SPY	ETF	213.2	213.35	213.14	213.24	158796.0
2016-07-11 08:00:00	SPY	ETF	213.24	213.37	212.592	213.32	428890.0
2016-07-11 09:00:00	SPY	ETF	213.31	213.67	213.15	213.45	10501880.0
2016-07-11 10:00:00	SPY	ETF	213.44	213.61	212.95	213.6	12932373.0
2016-07-11 11:00:00	SPY	ETF	213.6	213.88	213.59	213.76	9383807.0
2016-07-11 12:00:00	SPY	ETF	213.76	214.07	213.7	213.98	6013452.0
2016-07-11 13:00:00	SPY	ETF	213.99	214.015	213.76	213.7608	6627201.0
2016-07-11 14:00:00	SPY	ETF	213.76	213.89	213.69	213.725	5648683.0
2016-07-11 15:00:00	SPY	ETF	213.72	213.975	213.36	213.41	14848287.0
2016-07-11 16:00:00	SPY	ETF	213.4	213.53	213.31	213.5	4530895.0
2016-07-11 17:00:00	SPY	ETF	213.47	213.5	213.41	213.5	204989.0
2016-07-11 18:00:00	SPY	ETF	213.48	213.51	213.39	213.45	78737.0
2016-07-11 19:00:00	SPY	ETF	213.46	213.49	213.35	213.38	52997.0
2016-07-11 04:00:00	QQQ	ETF	110.56	110.72	110.54	110.64	2032.0
2016-07-11 05:00:00	QQQ	ETF	110.65	110.78	110.65	110.72	4527.0
2016-07-11 06:00:00	QQQ	ETF	110.78	110.78	110.59	110.68	2168.0
2016-07-11 07:00:00	QQQ	ETF	110.74	110.84	110.74	110.78	24187.0
2016-07-11 08:00:00	QQQ	ETF	110.79	110.81	110.73	110.79	56741.0
2016-07-11 09:00:00	QQQ	ETF	110.78	111.13	110.66	111.025	3398612.0
2016-07-11 10:00:00	QQQ	ETF	111.025	111.1	110.74	111.0805	3142770.0
2016-07-11 11:00:00	QQQ	ETF	111.09	111.2	111.0701	111.141	2400626.0
2016-07-11 12:00:00	QQQ	ETF	111.15	111.335	111.11	111.29	1986095.0
2016-07-11 13:00:00	QQQ	ETF	111.29	111.31	111.125	111.13	1624849.0
2016-07-11 14:00:00	QQQ	ETF	111.13	111.19	111.07	111.105	1791485.0
2016-07-11 15:00:00	QQQ	ETF	111.1	111.26	110.9	110.93	3582694.0
2016-07-11 16:00:00	QQQ	ETF	110.92	111.1032	110.9	111.04	559436.0
2016-07-11 17:00:00	QQQ	ETF	111.01	111.01	110.98	110.99	12103.0
2016-07-11 18:00:00	QQQ	ETF	111.02	111.04	110.98	111.02	5288.0
2016-07-11 19:00:00	QQQ	ETF	111.01	111.04	110.98	110.98	5271.0
2016-07-11 04:00:00	IWM	ETF	117.27	117.27	117.27	117.27	200.0
2016-07-11 05:00:00	IWM	ETF	117.04	117.41	117.04	117.41	425.0
2016-07-11 06:00:00	IWM	ETF	117.3	117.3	117.28	117.29	394.0
2016-07-11 07:00:00	IWM	ETF	117.34	117.61	117.34	117.48	139971.0
2016-07-11 08:00:00	IWM	ETF	117.53	117.65	117.45	117.62	113953.0
2016-07-11 09:00:00	IWM	ETF	117.63	117.74	117.47	117.68	3272613.0
2016-07-11 10:00:00	IWM	ETF	117.68	117.94	117.55	117.94	3373187.0
2016-07-11 11:00:00	IWM	ETF	117.94	118.3	117.93	118.16	3549185.0
2016-07-11 12:00:00	IWM	ETF	118.16	118.31	117.98	118.21	2158116.0
2016-07-11 13:00:00	IWM	ETF	118.2	118.32	118.12	118.15	1972659.0
2016-07-11 14:00:00	IWM	ETF	118.15	118.37	118.06	118.3099	2385357.0
2016-07-11 15:00:00	IWM	ETF	118.309	118.43	118.1	118.16	4487426.0
2016-07-11 16:00:00	IWM	ETF	118.14	118.32	118.11	118.32	682201.0
2016-07-11 17:00:00	IWM	ETF	118.29	118.3	118.25	118.26	726533.0
2016-07-11 18:00:00	IWM	ETF	118.27	118.27	118.21	118.24	1900.0
2016-07-11 19:00:00	IWM	ETF	118.25	118.28	118.24	118.24	5700.0
2016-07-11 04:00:00	DIA	ETF	181.66	181.66	181.66	181.66	119.0
2016-07-11 06:00:00	DIA	ETF	181.75	181.8	181.75	181.8	400.0

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

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