PREVIEW / etf_1hour / 2014-08-29

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-08-29.parquet
  size:    217 KB
  rows:    6,887

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-08-29 04:00:00	SPY	ETF	200.69	200.97	200.69	200.69	13516.0
2014-08-29 05:00:00	SPY	ETF	200.79	200.79	200.54	200.63	13265.0
2014-08-29 06:00:00	SPY	ETF	200.6	200.84	200.57	200.76	149739.0
2014-08-29 07:00:00	SPY	ETF	200.75	200.85	200.63	200.64	82454.0
2014-08-29 08:00:00	SPY	ETF	200.65	200.78	200.41	200.45	477333.0
2014-08-29 09:00:00	SPY	ETF	200.45	200.56	200.01	200.17	7669082.0
2014-08-29 10:00:00	SPY	ETF	200.16	200.27	199.82	200.26	8907161.0
2014-08-29 11:00:00	SPY	ETF	200.27	200.68	200.27	200.64	6329032.0
2014-08-29 12:00:00	SPY	ETF	200.64	200.725	200.4	200.515	3898570.0
2014-08-29 13:00:00	SPY	ETF	200.51	200.54	200.35	200.41	3033663.0
2014-08-29 14:00:00	SPY	ETF	200.419	200.49	200.31	200.38	2989536.0
2014-08-29 15:00:00	SPY	ETF	200.385	200.73	200.28	200.7	18336342.0
2014-08-29 16:00:00	SPY	ETF	200.69	200.729	200.42	200.46	10836353.0
2014-08-29 17:00:00	SPY	ETF	200.46	200.71	200.43	200.55	249360.0
2014-08-29 18:00:00	SPY	ETF	200.57	200.57	200.55	200.55	10800.0
2014-08-29 19:00:00	SPY	ETF	200.55	200.57	200.5	200.51	9271.0
2014-08-29 04:00:00	QQQ	ETF	99.61	99.84	99.61	99.84	3700.0
2014-08-29 05:00:00	QQQ	ETF	99.63	99.63	99.63	99.63	6500.0
2014-08-29 06:00:00	QQQ	ETF	99.67	99.72	99.67	99.72	5700.0
2014-08-29 07:00:00	QQQ	ETF	99.71	99.76	99.67	99.67	69660.0
2014-08-29 08:00:00	QQQ	ETF	99.7	99.74	99.55	99.56	183799.0
2014-08-29 09:00:00	QQQ	ETF	99.57	99.71	99.425	99.49	2371694.0
2014-08-29 10:00:00	QQQ	ETF	99.48	99.6	99.2701	99.599	3058592.0
2014-08-29 11:00:00	QQQ	ETF	99.595	99.795	99.595	99.751	2567162.0
2014-08-29 12:00:00	QQQ	ETF	99.76	99.78	99.612	99.675	1173949.0
2014-08-29 13:00:00	QQQ	ETF	99.68	99.6907	99.53	99.604	790398.0
2014-08-29 14:00:00	QQQ	ETF	99.6	99.66	99.58	99.62	884625.0
2014-08-29 15:00:00	QQQ	ETF	99.61	99.79	99.56	99.78	3574616.0
2014-08-29 16:00:00	QQQ	ETF	99.78	99.78	99.4578	99.7	1231614.0
2014-08-29 17:00:00	QQQ	ETF	99.68	99.78	99.68	99.78	775592.0
2014-08-29 18:00:00	QQQ	ETF	99.74	99.75	99.74	99.74	3600.0
2014-08-29 19:00:00	QQQ	ETF	99.75	99.75	99.7	99.73	4893.0
2014-08-29 07:00:00	IWM	ETF	116.37	116.39	116.3	116.3	12300.0
2014-08-29 08:00:00	IWM	ETF	116.34	116.34	116.12	116.12	35060.0
2014-08-29 09:00:00	IWM	ETF	116.15	116.28	115.73	115.91	3277764.0
2014-08-29 10:00:00	IWM	ETF	115.9	116.3251	115.65	116.31	3855406.0
2014-08-29 11:00:00	IWM	ETF	116.32	116.585	116.235	116.52	3856048.0
2014-08-29 12:00:00	IWM	ETF	116.53	116.56	116.29	116.39	1997864.0
2014-08-29 13:00:00	IWM	ETF	116.39	116.45	116.33	116.44	954284.0
2014-08-29 14:00:00	IWM	ETF	116.44	116.56	116.42	116.5	1989565.0
2014-08-29 15:00:00	IWM	ETF	116.49	116.81	116.45	116.57	5640810.0
2014-08-29 16:00:00	IWM	ETF	116.57	116.72	116.52	116.58	2598562.0
2014-08-29 17:00:00	IWM	ETF	116.63	116.63	115.91	116.56	750020.0
2014-08-29 18:00:00	IWM	ETF	116.56	116.61	116.55	116.61	1736.0
2014-08-29 19:00:00	IWM	ETF	116.63	116.63	116.54	116.54	1493.0
2014-08-29 08:00:00	DIA	ETF	170.89	170.89	170.89	170.89	100.0
2014-08-29 09:00:00	DIA	ETF	170.77	171.0	170.48	170.61	526477.0
2014-08-29 10:00:00	DIA	ETF	170.61	170.61	170.25	170.5	495487.0
2014-08-29 11:00:00	DIA	ETF	170.51	170.91	170.51	170.87	443397.0
2014-08-29 12:00:00	DIA	ETF	170.89	170.95	170.67	170.75	184470.0

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

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