PREVIEW / etf_1hour / 2014-07-08

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-07-08.parquet
  size:    228 KB
  rows:    7,478

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-07-08 04:00:00	SPY	ETF	197.35	197.35	197.28	197.31	733.0
2014-07-08 05:00:00	SPY	ETF	197.36	197.36	197.24	197.25	2000.0
2014-07-08 06:00:00	SPY	ETF	197.21	197.32	197.2	197.3	21258.0
2014-07-08 07:00:00	SPY	ETF	197.37	197.5	197.25	197.3	95571.0
2014-07-08 08:00:00	SPY	ETF	197.36	197.36	197.16	197.22	218434.0
2014-07-08 09:00:00	SPY	ETF	197.22	197.22	196.47	196.72	12938766.0
2014-07-08 10:00:00	SPY	ETF	196.73	196.73	196.07	196.38	20651944.0
2014-07-08 11:00:00	SPY	ETF	196.38	196.395	195.84	196.04	12303394.0
2014-07-08 12:00:00	SPY	ETF	196.04	196.2	195.76	196.16	10374816.0
2014-07-08 13:00:00	SPY	ETF	196.15	196.61	196.02	196.5	8718356.0
2014-07-08 14:00:00	SPY	ETF	196.5	196.52	196.26	196.28	7827020.0
2014-07-08 15:00:00	SPY	ETF	196.28	196.35	196.08	196.27	16760755.0
2014-07-08 16:00:00	SPY	ETF	196.27	196.56	196.1105	196.49	7864961.0
2014-07-08 17:00:00	SPY	ETF	196.5	196.51	196.2026	196.51	374102.0
2014-07-08 18:00:00	SPY	ETF	196.5	196.56	196.49	196.49	64073.0
2014-07-08 19:00:00	SPY	ETF	196.5	196.56	196.49	196.51	23053.0
2014-07-08 04:00:00	QQQ	ETF	95.3	95.34	95.3	95.34	2200.0
2014-07-08 06:00:00	QQQ	ETF	95.3	95.3	95.3	95.3	200.0
2014-07-08 08:00:00	QQQ	ETF	95.37	95.37	95.27	95.3	46839.0
2014-07-08 09:00:00	QQQ	ETF	95.28	95.3	94.7	94.799	4860631.0
2014-07-08 10:00:00	QQQ	ETF	94.795	94.8	94.201	94.4	8177031.0
2014-07-08 11:00:00	QQQ	ETF	94.4	94.4	93.87	94.03	5469666.0
2014-07-08 12:00:00	QQQ	ETF	94.02	94.23	93.9	94.2	4493027.0
2014-07-08 13:00:00	QQQ	ETF	94.2	94.47	94.08	94.418	3426683.0
2014-07-08 14:00:00	QQQ	ETF	94.4	94.41	94.22	94.23	2335100.0
2014-07-08 15:00:00	QQQ	ETF	94.24	94.36	94.11	94.28	5353163.0
2014-07-08 16:00:00	QQQ	ETF	94.28	94.6621	94.2583	94.39	1731329.0
2014-07-08 17:00:00	QQQ	ETF	94.39	94.43	94.37	94.4	36009.0
2014-07-08 18:00:00	QQQ	ETF	94.4	94.42	94.4	94.4	13468.0
2014-07-08 19:00:00	QQQ	ETF	94.39	94.42	94.39	94.42	3400.0
2014-07-08 04:00:00	IWM	ETF	117.57	117.57	117.57	117.57	100.0
2014-07-08 05:00:00	IWM	ETF	117.51	117.51	117.51	117.51	200.0
2014-07-08 07:00:00	IWM	ETF	117.47	117.54	117.47	117.48	2000.0
2014-07-08 08:00:00	IWM	ETF	117.54	117.58	117.38	117.55	76533.0
2014-07-08 09:00:00	IWM	ETF	117.52	117.7	116.53	116.7	8710109.0
2014-07-08 10:00:00	IWM	ETF	116.69	116.695	115.85	116.27	8914797.0
2014-07-08 11:00:00	IWM	ETF	116.26	116.28	115.7	115.84	6357246.0
2014-07-08 12:00:00	IWM	ETF	115.84	116.36	115.76	116.26	3309088.0
2014-07-08 13:00:00	IWM	ETF	116.25	116.73	116.14	116.6	4697712.0
2014-07-08 14:00:00	IWM	ETF	116.605	116.605	116.305	116.31	2891424.0
2014-07-08 15:00:00	IWM	ETF	116.32	116.4199	116.125	116.37	9208389.0
2014-07-08 16:00:00	IWM	ETF	116.35	116.68	116.2	116.59	1905830.0
2014-07-08 17:00:00	IWM	ETF	116.59	116.61	116.57	116.61	8407.0
2014-07-08 18:00:00	IWM	ETF	116.51	116.6	116.51	116.6	300.0
2014-07-08 19:00:00	IWM	ETF	116.53	116.53	116.53	116.53	300.0
2014-07-08 08:00:00	DIA	ETF	169.75	169.75	169.75	169.75	100.0
2014-07-08 09:00:00	DIA	ETF	169.65	169.65	168.8826	169.14	889235.0
2014-07-08 10:00:00	DIA	ETF	169.14	169.14	168.6	168.93	1638778.0
2014-07-08 11:00:00	DIA	ETF	168.92	168.92	168.44	168.67	536023.0
2014-07-08 12:00:00	DIA	ETF	168.66	168.77	168.46	168.75	616681.0

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

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