PREVIEW / etf_1hour / 2017-02-23

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-02-23.parquet
  size:    274 KB
  rows:    8,894

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
2017-02-23 04:00:00	SPY	ETF	236.27	236.58	236.27	236.58	3813.0
2017-02-23 05:00:00	SPY	ETF	236.49	236.52	236.44	236.47	2400.0
2017-02-23 06:00:00	SPY	ETF	236.38	236.45	236.37	236.45	28200.0
2017-02-23 07:00:00	SPY	ETF	236.46	236.7	236.36	236.64	111710.0
2017-02-23 08:00:00	SPY	ETF	236.44	236.75	236.42	236.72	336982.0
2017-02-23 09:00:00	SPY	ETF	236.73	236.99	236.52	236.68	7864128.0
2017-02-23 10:00:00	SPY	ETF	236.69	236.71	235.76	235.91	13818332.0
2017-02-23 11:00:00	SPY	ETF	235.92	236.22	235.56	236.04	11378675.0
2017-02-23 12:00:00	SPY	ETF	236.04	236.6	235.995	236.375	7651724.0
2017-02-23 13:00:00	SPY	ETF	236.37	236.46	236.2	236.45	5621476.0
2017-02-23 14:00:00	SPY	ETF	236.4401	236.68	236.37	236.62	5807104.0
2017-02-23 15:00:00	SPY	ETF	236.62	236.71	236.25	236.45	14347544.0
2017-02-23 16:00:00	SPY	ETF	236.45	236.63	236.35	236.48	4980186.0
2017-02-23 17:00:00	SPY	ETF	236.46	236.5	236.41	236.41	191428.0
2017-02-23 18:00:00	SPY	ETF	236.41	236.41	236.26	236.26	1700187.0
2017-02-23 19:00:00	SPY	ETF	236.25	236.39	236.23	236.37	36641.0
2017-02-23 04:00:00	QQQ	ETF	130.57	130.57	130.57	130.57	1000.0
2017-02-23 05:00:00	QQQ	ETF	130.48	130.48	130.48	130.48	1000.0
2017-02-23 07:00:00	QQQ	ETF	130.56	130.59	130.52	130.56	12728.0
2017-02-23 08:00:00	QQQ	ETF	130.59	130.61	130.54	130.59	64014.0
2017-02-23 09:00:00	QQQ	ETF	130.6	130.73	130.2	130.36	1958423.0
2017-02-23 10:00:00	QQQ	ETF	130.37	130.38	129.71	129.78	3458914.0
2017-02-23 11:00:00	QQQ	ETF	129.7847	129.9	129.49	129.8	3100827.0
2017-02-23 12:00:00	QQQ	ETF	129.81	130.03	129.76	129.93	1583416.0
2017-02-23 13:00:00	QQQ	ETF	129.93	130.01	129.8456	129.96	1090835.0
2017-02-23 14:00:00	QQQ	ETF	129.96	130.11	129.91	130.07	846685.0
2017-02-23 15:00:00	QQQ	ETF	130.07	130.14	129.85	130.02	2481202.0
2017-02-23 16:00:00	QQQ	ETF	130.02	130.06	129.93	129.98	907206.0
2017-02-23 17:00:00	QQQ	ETF	129.98	130.02	129.94	129.94	6991.0
2017-02-23 18:00:00	QQQ	ETF	129.91	129.93	129.82	129.82	5823.0
2017-02-23 19:00:00	QQQ	ETF	129.82	129.91	129.79	129.9	10356.0
2017-02-23 06:00:00	IWM	ETF	139.51	139.51	139.51	139.51	100.0
2017-02-23 07:00:00	IWM	ETF	139.67	139.79	139.49	139.75	50898.0
2017-02-23 08:00:00	IWM	ETF	139.76	139.82	139.69	139.75	49127.0
2017-02-23 09:00:00	IWM	ETF	139.81	140.02	139.13	139.27	1887898.0
2017-02-23 10:00:00	IWM	ETF	139.29	139.32	137.87	138.0645	4966870.0
2017-02-23 11:00:00	IWM	ETF	138.06	138.215	137.69	138.0	3128018.0
2017-02-23 12:00:00	IWM	ETF	137.995	139.02	137.95	138.65	3558035.0
2017-02-23 13:00:00	IWM	ETF	138.65	138.75	138.33	138.545	1512880.0
2017-02-23 14:00:00	IWM	ETF	138.55	138.595	138.36	138.55	1400335.0
2017-02-23 15:00:00	IWM	ETF	138.545	138.805	138.4	138.72	3804547.0
2017-02-23 16:00:00	IWM	ETF	138.72	138.83	138.0143	138.65	1469928.0
2017-02-23 17:00:00	IWM	ETF	138.65	138.65	138.54	138.55	21196.0
2017-02-23 18:00:00	IWM	ETF	138.54	138.58	138.45	138.45	7262.0
2017-02-23 19:00:00	IWM	ETF	138.51	138.62	138.51	138.62	638.0
2017-02-23 07:00:00	DIA	ETF	207.61	207.7	207.61	207.7	396.0
2017-02-23 08:00:00	DIA	ETF	207.7	207.82	207.7	207.8	3104.0
2017-02-23 09:00:00	DIA	ETF	207.81	208.08	207.67	207.81	307133.0
2017-02-23 10:00:00	DIA	ETF	207.85	207.93	207.34	207.4216	697215.0
2017-02-23 11:00:00	DIA	ETF	207.45	207.78	207.21	207.67	493514.0

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

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