PREVIEW / etf_1hour / 2015-09-01

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-09-01.parquet
  size:    262 KB
  rows:    8,454

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
2015-09-01 04:00:00	SPY	ETF	193.47	193.65	192.8	192.93	133754.0
2015-09-01 05:00:00	SPY	ETF	192.89	193.6	192.81	193.33	220812.0
2015-09-01 06:00:00	SPY	ETF	193.35	194.06	193.35	193.82	428819.0
2015-09-01 07:00:00	SPY	ETF	193.81	194.26	193.51	193.7	1004940.0
2015-09-01 08:00:00	SPY	ETF	193.72	194.23	192.25	192.32	3662459.0
2015-09-01 09:00:00	SPY	ETF	192.33	194.77	192.25	193.91	41547941.0
2015-09-01 10:00:00	SPY	ETF	193.89	194.67	193.0	193.8	38028511.0
2015-09-01 11:00:00	SPY	ETF	193.8	194.475	193.37	193.79	16863272.0
2015-09-01 12:00:00	SPY	ETF	193.78	194.01	192.44	192.4864	18925237.0
2015-09-01 13:00:00	SPY	ETF	192.49	193.26	192.25	193.21	25071187.0
2015-09-01 14:00:00	SPY	ETF	193.21	193.45	192.17	192.515	23355252.0
2015-09-01 15:00:00	SPY	ETF	192.57	192.75	190.73	191.61	66527591.0
2015-09-01 16:00:00	SPY	ETF	191.6	194.0	191.17	192.14	11950393.0
2015-09-01 17:00:00	SPY	ETF	192.05	192.22	191.77	192.13	1769668.0
2015-09-01 18:00:00	SPY	ETF	192.13	192.34	191.57	192.17	844890.0
2015-09-01 19:00:00	SPY	ETF	192.19	192.86	191.78	192.74	102328.0
2015-09-01 04:00:00	QQQ	ETF	101.96	102.0	101.1	101.67	65941.0
2015-09-01 05:00:00	QQQ	ETF	101.83	102.09	101.76	102.09	62600.0
2015-09-01 06:00:00	QQQ	ETF	101.96	102.26	101.96	102.14	66728.0
2015-09-01 07:00:00	QQQ	ETF	102.17	102.38	102.0	102.14	231273.0
2015-09-01 08:00:00	QQQ	ETF	102.12	102.18	101.35	101.42	499107.0
2015-09-01 09:00:00	QQQ	ETF	101.4	103.18	101.37	102.65	12351102.0
2015-09-01 10:00:00	QQQ	ETF	102.65	103.29	102.2	102.83	9740373.0
2015-09-01 11:00:00	QQQ	ETF	102.83	103.19	102.53	102.755	4004301.0
2015-09-01 12:00:00	QQQ	ETF	102.75	102.87	101.75	101.81	4757812.0
2015-09-01 13:00:00	QQQ	ETF	101.82	102.32	101.63	102.25	5410218.0
2015-09-01 14:00:00	QQQ	ETF	102.25	102.26	101.43	101.64	5755978.0
2015-09-01 15:00:00	QQQ	ETF	101.64	101.76	100.63	101.12	14886802.0
2015-09-01 16:00:00	QQQ	ETF	101.12	102.1043	100.91	101.44	4816777.0
2015-09-01 17:00:00	QQQ	ETF	101.45	101.45	101.2	101.31	75604.0
2015-09-01 18:00:00	QQQ	ETF	101.32	101.52	101.08	101.39	103502.0
2015-09-01 19:00:00	QQQ	ETF	101.5	101.88	101.31	101.78	46379.0
2015-09-01 04:00:00	IWM	ETF	113.32	113.32	112.72	112.86	5832.0
2015-09-01 05:00:00	IWM	ETF	112.88	113.15	112.88	113.15	2000.0
2015-09-01 06:00:00	IWM	ETF	112.73	113.46	112.73	113.25	55690.0
2015-09-01 07:00:00	IWM	ETF	113.26	113.5	113.19	113.36	122300.0
2015-09-01 08:00:00	IWM	ETF	113.35	113.4	112.62	112.63	454945.0
2015-09-01 09:00:00	IWM	ETF	112.61	115.2	112.53	113.61	6189309.0
2015-09-01 10:00:00	IWM	ETF	113.59	113.82	112.89	113.34	6540492.0
2015-09-01 11:00:00	IWM	ETF	113.35	113.76	113.125	113.288	2495298.0
2015-09-01 12:00:00	IWM	ETF	113.29	113.42	112.59	112.63	3773540.0
2015-09-01 13:00:00	IWM	ETF	112.63	113.0399	112.35	112.92	4462090.0
2015-09-01 14:00:00	IWM	ETF	112.92	112.97	112.37	112.56	3948355.0
2015-09-01 15:00:00	IWM	ETF	112.55	112.67	111.6	112.07	10393984.0
2015-09-01 16:00:00	IWM	ETF	112.07	112.75	111.9	112.3	2963969.0
2015-09-01 17:00:00	IWM	ETF	112.4	112.41	111.9	112.39	90240.0
2015-09-01 18:00:00	IWM	ETF	112.31	112.54	111.96	112.2	32896.0
2015-09-01 19:00:00	IWM	ETF	112.2	112.33	112.15	112.33	2700.0
2015-09-01 04:00:00	DIA	ETF	161.35	161.35	161.27	161.27	9500.0
2015-09-01 05:00:00	DIA	ETF	161.4	161.55	161.29	161.55	26700.0

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

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