PREVIEW / etf_1hour / 2015-02-04

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-02-04.parquet
  size:    243 KB
  rows:    7,769

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-02-04 04:00:00	SPY	ETF	204.48	204.55	204.01	204.03	265454.0
2015-02-04 05:00:00	SPY	ETF	204.05	204.6	203.8	204.26	189179.0
2015-02-04 06:00:00	SPY	ETF	204.23	204.41	204.16	204.35	56701.0
2015-02-04 07:00:00	SPY	ETF	204.33	204.48	203.88	204.16	344182.0
2015-02-04 08:00:00	SPY	ETF	204.4	204.4	203.86	204.0	897295.0
2015-02-04 09:00:00	SPY	ETF	204.0	204.37	203.64	204.26	11817678.0
2015-02-04 10:00:00	SPY	ETF	204.28	204.73	203.8	204.4	15772413.0
2015-02-04 11:00:00	SPY	ETF	204.4	205.07	204.18	204.85	12029827.0
2015-02-04 12:00:00	SPY	ETF	204.86	204.93	204.08	204.36	9200707.0
2015-02-04 13:00:00	SPY	ETF	204.37	204.73	204.26	204.431	8174050.0
2015-02-04 14:00:00	SPY	ETF	204.44	204.755	204.06	204.6	10500774.0
2015-02-04 15:00:00	SPY	ETF	204.6	205.38	203.51	204.07	46958610.0
2015-02-04 16:00:00	SPY	ETF	204.07	204.3726	202.79	203.0	13405723.0
2015-02-04 17:00:00	SPY	ETF	203.0	204.06	202.88	203.0	3447126.0
2015-02-04 18:00:00	SPY	ETF	203.05	203.14	202.71	202.74	217716.0
2015-02-04 19:00:00	SPY	ETF	202.75	203.14	202.75	203.05	115596.0
2015-02-04 20:00:00	SPY	ETF	204.0379	204.0727	204.0379	204.0727	339460.0
2015-02-04 04:00:00	QQQ	ETF	102.74	102.74	102.6	102.6	15000.0
2015-02-04 05:00:00	QQQ	ETF	102.6	102.73	102.52	102.64	11600.0
2015-02-04 06:00:00	QQQ	ETF	102.68	102.74	102.64	102.73	8700.0
2015-02-04 07:00:00	QQQ	ETF	102.73	102.79	102.49	102.62	64483.0
2015-02-04 08:00:00	QQQ	ETF	102.61	102.72	102.5	102.54	61070.0
2015-02-04 09:00:00	QQQ	ETF	102.54	102.75	102.39	102.645	3846335.0
2015-02-04 10:00:00	QQQ	ETF	102.645	102.88	102.31	102.67	4559883.0
2015-02-04 11:00:00	QQQ	ETF	102.669	103.29	102.59	103.22	3785634.0
2015-02-04 12:00:00	QQQ	ETF	103.22	103.25	102.83	103.01	4331862.0
2015-02-04 13:00:00	QQQ	ETF	103.005	103.28	102.95	103.13	3614385.0
2015-02-04 14:00:00	QQQ	ETF	103.14	103.35	103.0	103.26	2284324.0
2015-02-04 15:00:00	QQQ	ETF	103.25	103.55	102.59	102.87	9498359.0
2015-02-04 16:00:00	QQQ	ETF	102.87	102.994	102.22	102.35	928477.0
2015-02-04 17:00:00	QQQ	ETF	102.31	102.41	102.28	102.38	32559.0
2015-02-04 18:00:00	QQQ	ETF	102.33	102.4	102.14	102.19	33843.0
2015-02-04 19:00:00	QQQ	ETF	102.2	102.4	102.2	102.33	20456.0
2015-02-04 04:00:00	IWM	ETF	118.86	118.86	118.86	118.86	300.0
2015-02-04 07:00:00	IWM	ETF	118.52	118.56	118.33	118.48	104607.0
2015-02-04 08:00:00	IWM	ETF	118.44	118.56	118.38	118.42	98573.0
2015-02-04 09:00:00	IWM	ETF	118.48	118.62	118.14	118.57	3723175.0
2015-02-04 10:00:00	IWM	ETF	118.58	118.83	118.14	118.56	3636387.0
2015-02-04 11:00:00	IWM	ETF	118.55	119.24	118.43	118.915	3628217.0
2015-02-04 12:00:00	IWM	ETF	118.93	118.94	118.37	118.471	1892474.0
2015-02-04 13:00:00	IWM	ETF	118.48	118.66	118.2999	118.355	1360115.0
2015-02-04 14:00:00	IWM	ETF	118.36	118.73	118.21	118.64	1902662.0
2015-02-04 15:00:00	IWM	ETF	118.63	119.015	118.1	118.38	7369696.0
2015-02-04 16:00:00	IWM	ETF	118.37	118.41	117.66	117.83	1371444.0
2015-02-04 17:00:00	IWM	ETF	117.82	117.83	117.8	117.83	4609.0
2015-02-04 19:00:00	IWM	ETF	117.94	118.12	117.94	118.12	2600.0
2015-02-04 06:00:00	DIA	ETF	176.11	176.11	176.11	176.11	200.0
2015-02-04 07:00:00	DIA	ETF	176.06	176.06	175.8	176.0	600.0
2015-02-04 08:00:00	DIA	ETF	175.97	176.07	175.8	175.85	8800.0
2015-02-04 09:00:00	DIA	ETF	175.8	176.58	175.62	176.42	826936.0

> showing 50 of 7,769 rows — these rows as CSV

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