PREVIEW / etf_1hour / 2016-01-15

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-01-15.parquet
  size:    265 KB
  rows:    8,504

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-01-15 04:00:00	SPY	ETF	190.99	190.99	188.87	188.9	62789.0
2016-01-15 05:00:00	SPY	ETF	189.15	189.39	188.33	188.59	93942.0
2016-01-15 06:00:00	SPY	ETF	188.5	189.17	188.22	188.94	195076.0
2016-01-15 07:00:00	SPY	ETF	188.93	189.37	188.65	189.05	967042.0
2016-01-15 08:00:00	SPY	ETF	188.65	191.54	186.88	187.55	6531225.0
2016-01-15 09:00:00	SPY	ETF	187.56	188.69	186.62	187.55	43113147.0
2016-01-15 10:00:00	SPY	ETF	187.56	188.76	186.99	187.58	50112280.0
2016-01-15 11:00:00	SPY	ETF	187.58	187.97	186.99	187.18	35130259.0
2016-01-15 12:00:00	SPY	ETF	187.18	187.35	185.52	186.68	46598237.0
2016-01-15 13:00:00	SPY	ETF	186.68	187.49	186.24	187.16	28070447.0
2016-01-15 14:00:00	SPY	ETF	187.16	188.25	186.43	188.2089	31457339.0
2016-01-15 15:00:00	SPY	ETF	188.2	188.39	187.03	187.78	56215444.0
2016-01-15 16:00:00	SPY	ETF	187.77	191.9752	187.75	188.23	20023346.0
2016-01-15 17:00:00	SPY	ETF	188.27	188.5	188.09	188.33	2506934.0
2016-01-15 18:00:00	SPY	ETF	188.3	188.55	187.81	188.31	786965.0
2016-01-15 19:00:00	SPY	ETF	188.35	188.35	188.14	188.26	61929.0
2016-01-15 04:00:00	QQQ	ETF	102.73	102.73	102.03	102.17	78963.0
2016-01-15 05:00:00	QQQ	ETF	102.1	102.1	101.8	101.8	29350.0
2016-01-15 06:00:00	QQQ	ETF	101.81	102.18	101.73	102.09	22360.0
2016-01-15 07:00:00	QQQ	ETF	102.05	102.29	101.9	102.17	153184.0
2016-01-15 08:00:00	QQQ	ETF	102.17	102.19	100.79	101.13	1118464.0
2016-01-15 09:00:00	QQQ	ETF	101.13	101.94	100.44	101.13	13182173.0
2016-01-15 10:00:00	QQQ	ETF	101.13	101.83	100.72	100.795	13623548.0
2016-01-15 11:00:00	QQQ	ETF	100.8	101.0856	100.46	100.61	9792620.0
2016-01-15 12:00:00	QQQ	ETF	100.62	100.7	99.51	100.37	11080199.0
2016-01-15 13:00:00	QQQ	ETF	100.36	100.94	100.13	100.685	8355771.0
2016-01-15 14:00:00	QQQ	ETF	100.68	101.23	100.06	101.2	9257069.0
2016-01-15 15:00:00	QQQ	ETF	101.2	101.35	100.42	100.84	12773642.0
2016-01-15 16:00:00	QQQ	ETF	100.83	101.28	100.81	101.21	2635806.0
2016-01-15 17:00:00	QQQ	ETF	101.2	101.26	101.01	101.03	340832.0
2016-01-15 18:00:00	QQQ	ETF	101.11	101.14	101.01	101.01	7476.0
2016-01-15 19:00:00	QQQ	ETF	101.01	101.09	100.9	101.0	7903.0
2016-01-15 04:00:00	IWM	ETF	101.0	101.0	100.08	100.1	2408.0
2016-01-15 05:00:00	IWM	ETF	100.3	100.3	99.85	100.0	18297.0
2016-01-15 06:00:00	IWM	ETF	99.83	100.17	99.83	100.1	5300.0
2016-01-15 07:00:00	IWM	ETF	100.0	100.24	99.93	100.17	207603.0
2016-01-15 08:00:00	IWM	ETF	100.03	100.22	99.05	99.3	601216.0
2016-01-15 09:00:00	IWM	ETF	99.28	99.95	98.93	99.2	9384554.0
2016-01-15 10:00:00	IWM	ETF	99.21	99.65	98.74	98.813	12346793.0
2016-01-15 11:00:00	IWM	ETF	98.82	99.02	98.34	98.55	9865905.0
2016-01-15 12:00:00	IWM	ETF	98.54	98.66	97.51	98.42	10899180.0
2016-01-15 13:00:00	IWM	ETF	98.41	99.21	97.94	99.0375	8393904.0
2016-01-15 14:00:00	IWM	ETF	99.03	100.03	98.74	100.023	6906609.0
2016-01-15 15:00:00	IWM	ETF	100.02	100.29	99.19	100.11	13040119.0
2016-01-15 16:00:00	IWM	ETF	100.09	100.45	100.08	100.33	2123543.0
2016-01-15 17:00:00	IWM	ETF	100.34	100.4	100.25	100.27	610640.0
2016-01-15 18:00:00	IWM	ETF	100.3	100.4	100.27	100.27	8092.0
2016-01-15 19:00:00	IWM	ETF	100.27	100.27	100.2	100.2	17923.0
2016-01-15 04:00:00	DIA	ETF	161.07	161.07	161.07	161.07	100.0
2016-01-15 07:00:00	DIA	ETF	161.0	161.1	160.61	160.61	1600.0

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

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