PREVIEW / etf_1hour / 2014-01-16

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-01-16.parquet
  size:    215 KB
  rows:    6,791

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
2014-01-16 04:00:00	SPY	ETF	184.42	184.42	184.25	184.33	42008.0
2014-01-16 05:00:00	SPY	ETF	184.36	184.41	184.25	184.41	7369.0
2014-01-16 06:00:00	SPY	ETF	184.41	184.41	184.26	184.29	181350.0
2014-01-16 07:00:00	SPY	ETF	184.32	184.44	184.13	184.22	646800.0
2014-01-16 08:00:00	SPY	ETF	184.24	184.39	184.08	184.19	1354602.0
2014-01-16 09:00:00	SPY	ETF	184.19	184.48	184.03	184.31	11132475.0
2014-01-16 10:00:00	SPY	ETF	184.31	184.46	183.89	183.95	11422924.0
2014-01-16 11:00:00	SPY	ETF	183.95	184.6618	183.83	184.28	8932160.0
2014-01-16 12:00:00	SPY	ETF	184.27	184.31	184.03	184.28	4608092.0
2014-01-16 13:00:00	SPY	ETF	184.28	184.5	184.15	184.27	5506713.0
2014-01-16 14:00:00	SPY	ETF	184.27	184.39	184.16	184.33	5784205.0
2014-01-16 15:00:00	SPY	ETF	184.331	184.43	184.07	184.4	15097735.0
2014-01-16 16:00:00	SPY	ETF	184.4	184.42	183.96	184.08	4714664.0
2014-01-16 17:00:00	SPY	ETF	184.11	184.39	184.11	184.2	203741.0
2014-01-16 18:00:00	SPY	ETF	184.19	184.2	183.99	184.02	129671.0
2014-01-16 19:00:00	SPY	ETF	184.07	184.12	184.06	184.12	65599.0
2014-01-16 04:00:00	QQQ	ETF	88.27	88.27	88.27	88.27	896.0
2014-01-16 06:00:00	QQQ	ETF	88.26	88.27	88.26	88.27	450.0
2014-01-16 07:00:00	QQQ	ETF	88.3	88.3	88.21	88.24	94460.0
2014-01-16 08:00:00	QQQ	ETF	88.22	88.25	88.18	88.21	150331.0
2014-01-16 09:00:00	QQQ	ETF	88.21	88.42	88.16	88.33	3591829.0
2014-01-16 10:00:00	QQQ	ETF	88.32	88.47	88.2	88.24	2809287.0
2014-01-16 11:00:00	QQQ	ETF	88.235	88.41	88.17	88.39	2963237.0
2014-01-16 12:00:00	QQQ	ETF	88.39	88.41	88.225	88.395	1899071.0
2014-01-16 13:00:00	QQQ	ETF	88.4	88.51	88.35	88.391	1303562.0
2014-01-16 14:00:00	QQQ	ETF	88.39	88.45	88.31	88.411	2011740.0
2014-01-16 15:00:00	QQQ	ETF	88.415	88.44	88.24	88.4	4651637.0
2014-01-16 16:00:00	QQQ	ETF	88.4	88.46	88.17	88.2	3544391.0
2014-01-16 17:00:00	QQQ	ETF	88.25	88.3	88.25	88.28	88616.0
2014-01-16 18:00:00	QQQ	ETF	88.25	88.26	88.12	88.15	75803.0
2014-01-16 19:00:00	QQQ	ETF	88.16	88.25	88.16	88.25	16950.0
2014-01-16 06:00:00	IWM	ETF	116.06	116.06	116.0	116.0	1000.0
2014-01-16 07:00:00	IWM	ETF	116.06	116.11	115.95	116.04	65412.0
2014-01-16 08:00:00	IWM	ETF	116.04	116.04	115.91	115.96	68575.0
2014-01-16 09:00:00	IWM	ETF	115.95	116.35	115.92	116.19	2400630.0
2014-01-16 10:00:00	IWM	ETF	116.19	116.36	115.86	115.95	4719155.0
2014-01-16 11:00:00	IWM	ETF	115.95	116.22	115.83	116.165	2876967.0
2014-01-16 12:00:00	IWM	ETF	116.18	116.225	116.05	116.12	1281202.0
2014-01-16 13:00:00	IWM	ETF	116.13	116.24	116.04	116.14	1115227.0
2014-01-16 14:00:00	IWM	ETF	116.135	116.3	116.07	116.25	1534553.0
2014-01-16 15:00:00	IWM	ETF	116.255	116.38	116.21	116.35	3883512.0
2014-01-16 16:00:00	IWM	ETF	116.35	116.36	116.11	116.24	3273550.0
2014-01-16 17:00:00	IWM	ETF	116.24	116.29	116.16	116.22	29604.0
2014-01-16 18:00:00	IWM	ETF	116.21	116.21	116.21	116.21	2732.0
2014-01-16 08:00:00	DIA	ETF	164.4	164.4	164.01	164.11	7561.0
2014-01-16 09:00:00	DIA	ETF	164.11	164.33	163.88	164.15	1452397.0
2014-01-16 10:00:00	DIA	ETF	164.13	164.2601	163.635	163.68	844835.0
2014-01-16 11:00:00	DIA	ETF	163.67	163.97	163.52	163.93	761861.0
2014-01-16 12:00:00	DIA	ETF	163.93	163.94	163.71	163.86	334512.0
2014-01-16 13:00:00	DIA	ETF	163.87	164.07	163.75	163.91	285051.0

> showing 50 of 6,791 rows — these rows as CSV

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