PREVIEW / etf_1hour / 2016-06-24

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-06-24.parquet
  size:    283 KB
  rows:    9,186

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-06-24 04:00:00	SPY	ETF	204.6	204.79	203.33	203.33	381977.0
2016-06-24 05:00:00	SPY	ETF	203.33	204.35	203.27	203.52	523156.0
2016-06-24 06:00:00	SPY	ETF	203.59	203.75	202.09	203.17	1830338.0
2016-06-24 07:00:00	SPY	ETF	203.14	203.77	202.71	203.09	2727157.0
2016-06-24 08:00:00	SPY	ETF	203.09	209.85	200.25	203.8	7243281.0
2016-06-24 09:00:00	SPY	ETF	203.8	206.199	203.12	205.9999	55053954.0
2016-06-24 10:00:00	SPY	ETF	205.99	206.905	205.5	205.53	53313738.0
2016-06-24 11:00:00	SPY	ETF	205.53	210.8463	204.76	205.33	35769885.0
2016-06-24 12:00:00	SPY	ETF	205.3397	205.46	204.08	204.28	25406421.0
2016-06-24 13:00:00	SPY	ETF	204.28	204.96	204.08	204.61	21351954.0
2016-06-24 14:00:00	SPY	ETF	204.61	205.95	203.48	203.95	29617940.0
2016-06-24 15:00:00	SPY	ETF	203.95	204.45	202.72	203.22	68918687.0
2016-06-24 16:00:00	SPY	ETF	203.25	203.35	202.17	202.37	23044295.0
2016-06-24 17:00:00	SPY	ETF	202.35	203.13	202.35	202.44	1109676.0
2016-06-24 18:00:00	SPY	ETF	202.44	202.44	202.16	202.2	159035.0
2016-06-24 19:00:00	SPY	ETF	202.2	202.27	201.95	202.0	190124.0
2016-06-24 04:00:00	QQQ	ETF	105.6	105.6	104.98	104.98	71343.0
2016-06-24 05:00:00	QQQ	ETF	104.97	105.35	104.91	105.11	37247.0
2016-06-24 06:00:00	QQQ	ETF	105.1	105.12	104.32	104.82	277450.0
2016-06-24 07:00:00	QQQ	ETF	104.82	105.12	104.65	104.83	607654.0
2016-06-24 08:00:00	QQQ	ETF	104.84	105.36	104.6	105.06	1225700.0
2016-06-24 09:00:00	QQQ	ETF	105.08	106.22	104.54	106.09	10928841.0
2016-06-24 10:00:00	QQQ	ETF	106.08	106.5	105.58	105.6	9316990.0
2016-06-24 11:00:00	QQQ	ETF	105.6	105.69	105.2	105.5	5830471.0
2016-06-24 12:00:00	QQQ	ETF	105.51	105.56	104.66	104.77	5673645.0
2016-06-24 13:00:00	QQQ	ETF	104.775	105.1	104.71	104.86	3913258.0
2016-06-24 14:00:00	QQQ	ETF	104.865	104.99	104.32	104.58	6047553.0
2016-06-24 15:00:00	QQQ	ETF	104.58	104.98	104.06	104.35	11679603.0
2016-06-24 16:00:00	QQQ	ETF	104.35	104.49	103.96	103.98	1887604.0
2016-06-24 17:00:00	QQQ	ETF	103.96	104.02	103.93	104.0	433514.0
2016-06-24 18:00:00	QQQ	ETF	104.02	104.02	103.84	103.9	23334.0
2016-06-24 19:00:00	QQQ	ETF	103.9	103.9	103.78	103.82	9806.0
2016-06-24 04:00:00	IWM	ETF	112.31	112.31	111.5	111.69	55163.0
2016-06-24 05:00:00	IWM	ETF	111.5	112.0	111.43	111.5	90482.0
2016-06-24 06:00:00	IWM	ETF	111.55	111.55	110.64	111.27	209668.0
2016-06-24 07:00:00	IWM	ETF	111.28	112.1	111.14	111.88	522250.0
2016-06-24 08:00:00	IWM	ETF	111.85	112.12	109.8	111.68	1041932.0
2016-06-24 09:00:00	IWM	ETF	111.68	113.4699	111.5	113.33	11515271.0
2016-06-24 10:00:00	IWM	ETF	113.32	114.035	113.12	113.5485	11796029.0
2016-06-24 11:00:00	IWM	ETF	113.56	113.65	113.14	113.3	6423713.0
2016-06-24 12:00:00	IWM	ETF	113.305	113.34	112.42	112.54	5233920.0
2016-06-24 13:00:00	IWM	ETF	112.535	112.758	112.38	112.7	4678469.0
2016-06-24 14:00:00	IWM	ETF	112.695	112.759	111.86	112.44	5992686.0
2016-06-24 15:00:00	IWM	ETF	112.43	112.83	112.04	112.39	13810548.0
2016-06-24 16:00:00	IWM	ETF	112.43	112.55	111.57	111.85	3410464.0
2016-06-24 17:00:00	IWM	ETF	111.87	112.14	111.82	111.88	140740.0
2016-06-24 18:00:00	IWM	ETF	111.83	112.55	111.77	111.77	4110.0
2016-06-24 19:00:00	IWM	ETF	111.85	111.95	111.85	111.95	827.0
2016-06-24 04:00:00	DIA	ETF	175.8	175.8	175.2	175.2	2100.0
2016-06-24 05:00:00	DIA	ETF	174.91	174.91	174.91	174.91	100.0

> showing 50 of 9,186 rows — these rows as CSV

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