PREVIEW / etf_1hour / 2015-08-20

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-08-20.parquet
  size:    256 KB
  rows:    8,183

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-08-20 04:00:00	SPY	ETF	207.45	207.46	206.62	206.8	35931.0
2015-08-20 05:00:00	SPY	ETF	206.92	206.92	206.08	206.72	217482.0
2015-08-20 06:00:00	SPY	ETF	206.75	206.79	206.34	206.4	277285.0
2015-08-20 07:00:00	SPY	ETF	206.46	206.74	206.21	206.68	910714.0
2015-08-20 08:00:00	SPY	ETF	206.69	207.13	206.27	206.87	1493685.0
2015-08-20 09:00:00	SPY	ETF	206.9	208.2865	206.22	206.35	21260643.0
2015-08-20 10:00:00	SPY	ETF	206.35	206.48	205.47	206.12	30517140.0
2015-08-20 11:00:00	SPY	ETF	206.13	206.25	205.58	206.16	16371758.0
2015-08-20 12:00:00	SPY	ETF	206.16	206.19	204.97	205.1401	18273324.0
2015-08-20 13:00:00	SPY	ETF	205.15	205.8	204.99	205.725	18422881.0
2015-08-20 14:00:00	SPY	ETF	205.72	205.725	204.54	204.63	21188314.0
2015-08-20 15:00:00	SPY	ETF	204.63	205.21	203.91	203.91	41049769.0
2015-08-20 16:00:00	SPY	ETF	203.92	206.45	203.17	203.27	18677543.0
2015-08-20 17:00:00	SPY	ETF	203.27	203.35	203.14	203.32	443431.0
2015-08-20 18:00:00	SPY	ETF	203.32	203.44	203.23	203.39	285105.0
2015-08-20 19:00:00	SPY	ETF	203.36	203.5	203.26	203.457	179862.0
2015-08-20 04:00:00	QQQ	ETF	109.55	109.55	109.31	109.31	2200.0
2015-08-20 05:00:00	QQQ	ETF	109.15	109.34	109.0	109.31	7700.0
2015-08-20 06:00:00	QQQ	ETF	109.21	109.28	109.12	109.12	20472.0
2015-08-20 07:00:00	QQQ	ETF	109.2	109.3	109.1	109.3	75050.0
2015-08-20 08:00:00	QQQ	ETF	109.28	109.53	109.12	109.35	148249.0
2015-08-20 09:00:00	QQQ	ETF	109.38	109.46	108.85	108.91	7070816.0
2015-08-20 10:00:00	QQQ	ETF	108.91	109.0	107.92	108.315	11331486.0
2015-08-20 11:00:00	QQQ	ETF	108.31	108.43	107.9	108.25	4514453.0
2015-08-20 12:00:00	QQQ	ETF	108.25	108.27	107.5	107.565	4517840.0
2015-08-20 13:00:00	QQQ	ETF	107.56	107.97	107.46	107.89	5094921.0
2015-08-20 14:00:00	QQQ	ETF	107.88	107.9	107.33	107.4264	4383973.0
2015-08-20 15:00:00	QQQ	ETF	107.43	107.8301	107.07	107.08	9098391.0
2015-08-20 16:00:00	QQQ	ETF	107.07	107.16	106.49	106.58	2000478.0
2015-08-20 17:00:00	QQQ	ETF	106.58	106.7	106.5	106.7	109234.0
2015-08-20 18:00:00	QQQ	ETF	106.62	106.7	106.57	106.6	52321.0
2015-08-20 19:00:00	QQQ	ETF	106.55	106.66	106.55	106.61	41600.0
2015-08-20 04:00:00	IWM	ETF	118.81	118.81	118.69	118.69	300.0
2015-08-20 05:00:00	IWM	ETF	118.3	118.44	118.3	118.44	2100.0
2015-08-20 07:00:00	IWM	ETF	118.37	118.54	118.31	118.48	31731.0
2015-08-20 08:00:00	IWM	ETF	118.47	118.85	118.33	118.48	143100.0
2015-08-20 09:00:00	IWM	ETF	118.53	118.61	118.08	118.2	4131558.0
2015-08-20 10:00:00	IWM	ETF	118.22	118.41	117.7831	118.24	5809840.0
2015-08-20 11:00:00	IWM	ETF	118.24	118.3	117.82	118.28	3237495.0
2015-08-20 12:00:00	IWM	ETF	118.29	118.29	117.54	117.69	3399545.0
2015-08-20 13:00:00	IWM	ETF	117.68	117.8	117.4	117.72	3577650.0
2015-08-20 14:00:00	IWM	ETF	117.7	117.76	116.94	117.025	5699550.0
2015-08-20 15:00:00	IWM	ETF	117.02	117.32	116.41	116.41	9671406.0
2015-08-20 16:00:00	IWM	ETF	116.4	117.9886	115.86	116.18	4913369.0
2015-08-20 17:00:00	IWM	ETF	116.16	116.2	116.09	116.15	33583.0
2015-08-20 18:00:00	IWM	ETF	116.25	116.25	116.22	116.22	400.0
2015-08-20 19:00:00	IWM	ETF	116.07	116.27	116.06	116.2	5500.0
2015-08-20 04:00:00	DIA	ETF	172.5	172.5	172.5	172.5	100.0
2015-08-20 05:00:00	DIA	ETF	172.24	172.24	171.95	172.03	1450.0
2015-08-20 07:00:00	DIA	ETF	172.25	172.37	172.13	172.37	1700.0

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

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