PREVIEW / etf_1hour / 2014-04-25

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-04-25.parquet
  size:    214 KB
  rows:    6,783

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-04-25 04:00:00	SPY	ETF	187.74	187.74	187.48	187.64	25892.0
2014-04-25 05:00:00	SPY	ETF	187.72	187.72	187.49	187.59	6885.0
2014-04-25 06:00:00	SPY	ETF	187.6	187.65	187.25	187.27	68254.0
2014-04-25 07:00:00	SPY	ETF	187.26	187.35	187.11	187.32	346584.0
2014-04-25 08:00:00	SPY	ETF	187.34	187.39	187.15	187.39	889594.0
2014-04-25 09:00:00	SPY	ETF	187.39	187.39	186.73	186.83	13423088.0
2014-04-25 10:00:00	SPY	ETF	186.82	187.12	186.29	186.34	19384717.0
2014-04-25 11:00:00	SPY	ETF	186.34	186.81	186.06	186.6579	14531412.0
2014-04-25 12:00:00	SPY	ETF	186.66	186.83	186.44	186.52	7166393.0
2014-04-25 13:00:00	SPY	ETF	186.52	186.52	186.17	186.36	7670568.0
2014-04-25 14:00:00	SPY	ETF	186.36	186.4	185.87	186.13	10504000.0
2014-04-25 15:00:00	SPY	ETF	186.12	186.59	186.03	186.31	18946899.0
2014-04-25 16:00:00	SPY	ETF	186.32	187.797	186.2696	186.56	6423943.0
2014-04-25 17:00:00	SPY	ETF	186.55	186.62	186.45	186.49	149291.0
2014-04-25 18:00:00	SPY	ETF	186.5	186.56	186.5	186.54	24035.0
2014-04-25 19:00:00	SPY	ETF	186.54	186.6	186.54	186.59	31950.0
2014-04-25 04:00:00	QQQ	ETF	87.54	87.54	87.54	87.54	2500.0
2014-04-25 05:00:00	QQQ	ETF	87.52	87.52	87.48	87.51	10600.0
2014-04-25 06:00:00	QQQ	ETF	87.48	87.48	87.21	87.21	20980.0
2014-04-25 07:00:00	QQQ	ETF	87.21	87.36	87.19	87.34	41300.0
2014-04-25 08:00:00	QQQ	ETF	87.31	87.35	87.12	87.25	262011.0
2014-04-25 09:00:00	QQQ	ETF	87.24	87.25	86.77	86.801	6467370.0
2014-04-25 10:00:00	QQQ	ETF	86.8	86.82	86.14	86.23	9310604.0
2014-04-25 11:00:00	QQQ	ETF	86.23	86.61	86.03	86.46	6447584.0
2014-04-25 12:00:00	QQQ	ETF	86.46	86.62	86.31	86.36	2608882.0
2014-04-25 13:00:00	QQQ	ETF	86.355	86.41	86.18	86.285	2684764.0
2014-04-25 14:00:00	QQQ	ETF	86.29	86.3	85.98	86.165	3954244.0
2014-04-25 15:00:00	QQQ	ETF	86.16	86.37	86.09	86.175	6526197.0
2014-04-25 16:00:00	QQQ	ETF	86.18	86.4291	86.17	86.29	2385018.0
2014-04-25 17:00:00	QQQ	ETF	86.31	86.35	86.27	86.27	12534.0
2014-04-25 18:00:00	QQQ	ETF	86.27	86.3	86.27	86.3	2236.0
2014-04-25 19:00:00	QQQ	ETF	86.27	86.32	86.27	86.3	4341.0
2014-04-25 07:00:00	IWM	ETF	113.18	113.33	113.13	113.33	24275.0
2014-04-25 08:00:00	IWM	ETF	113.25	113.38	113.19	113.37	112388.0
2014-04-25 09:00:00	IWM	ETF	113.36	113.36	112.51	112.62	6858883.0
2014-04-25 10:00:00	IWM	ETF	112.63	112.94	111.85	111.93	8994964.0
2014-04-25 11:00:00	IWM	ETF	111.93	112.25	111.61	111.96	6512872.0
2014-04-25 12:00:00	IWM	ETF	111.96	112.14	111.65	111.71	3174984.0
2014-04-25 13:00:00	IWM	ETF	111.71	111.78	111.3	111.57	4778795.0
2014-04-25 14:00:00	IWM	ETF	111.56	111.66	111.21	111.39	4782417.0
2014-04-25 15:00:00	IWM	ETF	111.39	111.75	111.36	111.6	7940383.0
2014-04-25 16:00:00	IWM	ETF	111.6	113.633	111.43	111.6	6365236.0
2014-04-25 17:00:00	IWM	ETF	111.6	111.62	111.58	111.61	11720.0
2014-04-25 18:00:00	IWM	ETF	111.6	111.63	111.6	111.63	1100.0
2014-04-25 19:00:00	IWM	ETF	111.63	111.65	111.63	111.63	4300.0
2014-04-25 07:00:00	DIA	ETF	164.0	164.05	163.94	164.04	2450.0
2014-04-25 08:00:00	DIA	ETF	164.0	164.2	164.0	164.2	11640.0
2014-04-25 09:00:00	DIA	ETF	164.19	164.25	163.4501	163.56	854642.0
2014-04-25 10:00:00	DIA	ETF	163.53	163.81	163.23	163.25	885014.0
2014-04-25 11:00:00	DIA	ETF	163.25	163.58	163.06	163.52	684170.0

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

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