PREVIEW / etf_1hour / 2016-02-02

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-02-02.parquet
  size:    254 KB
  rows:    8,170

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-02-02 04:00:00	SPY	ETF	192.25	192.41	191.55	191.96	63801.0
2016-02-02 05:00:00	SPY	ETF	192.03	192.29	191.7	192.18	26247.0
2016-02-02 06:00:00	SPY	ETF	192.17	192.56	192.12	192.21	148401.0
2016-02-02 07:00:00	SPY	ETF	192.23	192.58	192.19	192.55	254585.0
2016-02-02 08:00:00	SPY	ETF	192.58	193.65	191.72	191.81	1158884.0
2016-02-02 09:00:00	SPY	ETF	191.8	192.02	190.87	191.19	19896080.0
2016-02-02 10:00:00	SPY	ETF	191.2	191.58	190.75	191.0	29267693.0
2016-02-02 11:00:00	SPY	ETF	191.0	191.73	190.87	190.9699	17483179.0
2016-02-02 12:00:00	SPY	ETF	190.96	191.06	190.3	190.8	21945105.0
2016-02-02 13:00:00	SPY	ETF	190.8	190.89	190.06	190.085	15249972.0
2016-02-02 14:00:00	SPY	ETF	190.085	190.65	189.86	189.98	24571050.0
2016-02-02 15:00:00	SPY	ETF	189.98	190.54	189.54	190.13	34896017.0
2016-02-02 16:00:00	SPY	ETF	190.13	190.51	190.04	190.22	11542505.0
2016-02-02 17:00:00	SPY	ETF	190.25	190.27	190.14	190.15	3645323.0
2016-02-02 18:00:00	SPY	ETF	190.13	190.22	189.91	190.01	155722.0
2016-02-02 19:00:00	SPY	ETF	190.06	190.16	189.78	189.95	89224.0
2016-02-02 04:00:00	QQQ	ETF	103.86	103.89	103.41	103.57	36230.0
2016-02-02 05:00:00	QQQ	ETF	103.61	103.85	103.61	103.77	1800.0
2016-02-02 06:00:00	QQQ	ETF	103.8	104.12	103.78	104.0	4700.0
2016-02-02 07:00:00	QQQ	ETF	103.96	104.16	103.95	104.16	34200.0
2016-02-02 08:00:00	QQQ	ETF	104.17	104.41	103.72	103.77	174389.0
2016-02-02 09:00:00	QQQ	ETF	103.71	103.98	103.18	103.44	7382015.0
2016-02-02 10:00:00	QQQ	ETF	103.44	103.74	103.29	103.4	6103431.0
2016-02-02 11:00:00	QQQ	ETF	103.4	103.7	103.18	103.18	3707591.0
2016-02-02 12:00:00	QQQ	ETF	103.18	103.225	102.72	103.06	4074642.0
2016-02-02 13:00:00	QQQ	ETF	103.06	103.065	102.35	102.37	3476057.0
2016-02-02 14:00:00	QQQ	ETF	102.37	102.52	102.0199	102.02	4489231.0
2016-02-02 15:00:00	QQQ	ETF	102.01	102.47	101.84	102.16	7908616.0
2016-02-02 16:00:00	QQQ	ETF	102.18	102.43	102.15	102.25	1097108.0
2016-02-02 17:00:00	QQQ	ETF	102.23	102.35	102.21	102.25	16894.0
2016-02-02 18:00:00	QQQ	ETF	102.23	102.32	102.11	102.2	39186.0
2016-02-02 19:00:00	QQQ	ETF	102.26	102.26	101.97	102.08	70942.0
2016-02-02 04:00:00	IWM	ETF	101.19	101.19	101.19	101.19	190.0
2016-02-02 05:00:00	IWM	ETF	101.27	101.3	101.27	101.3	3000.0
2016-02-02 06:00:00	IWM	ETF	101.3	101.3	101.3	101.3	100.0
2016-02-02 07:00:00	IWM	ETF	101.3	101.53	101.26	101.44	26138.0
2016-02-02 08:00:00	IWM	ETF	101.3	101.57	101.08	101.1	169372.0
2016-02-02 09:00:00	IWM	ETF	101.08	101.47	100.56	100.77	4910123.0
2016-02-02 10:00:00	IWM	ETF	100.76	101.08	100.36	100.46	5683222.0
2016-02-02 11:00:00	IWM	ETF	100.46	100.93	100.39	100.395	3751822.0
2016-02-02 12:00:00	IWM	ETF	100.4	100.6	99.94	100.53	3967250.0
2016-02-02 13:00:00	IWM	ETF	100.53	100.585	100.005	100.03	2963380.0
2016-02-02 14:00:00	IWM	ETF	100.03	100.39	99.96	100.02	4122488.0
2016-02-02 15:00:00	IWM	ETF	100.01	100.355	99.77	100.27	7190156.0
2016-02-02 16:00:00	IWM	ETF	100.27	100.48	100.25	100.38	1175671.0
2016-02-02 17:00:00	IWM	ETF	100.38	100.38	100.28	100.28	28225.0
2016-02-02 18:00:00	IWM	ETF	100.28	100.28	100.28	100.28	420.0
2016-02-02 19:00:00	IWM	ETF	100.1	100.1	100.05	100.05	800.0
2016-02-02 20:00:00	IWM	ETF	100.2147	100.2147	100.2147	100.2147	500000.0
2016-02-02 04:00:00	DIA	ETF	163.06	163.06	163.06	163.06	100.0

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

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