PREVIEW / etf_1hour / 2014-12-08

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-08.parquet
  size:    238 KB
  rows:    7,522

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-12-08 04:00:00	SPY	ETF	207.81	207.81	207.45	207.54	13757.0
2014-12-08 05:00:00	SPY	ETF	207.51	207.6	207.36	207.5	40064.0
2014-12-08 06:00:00	SPY	ETF	207.55	207.63	207.48	207.49	123603.0
2014-12-08 07:00:00	SPY	ETF	207.5	207.58	207.41	207.56	59299.0
2014-12-08 08:00:00	SPY	ETF	207.56	208.07	207.42	207.48	439562.0
2014-12-08 09:00:00	SPY	ETF	207.49	207.95	207.33	207.89	9034399.0
2014-12-08 10:00:00	SPY	ETF	207.89	208.12	207.765	207.965	9248932.0
2014-12-08 11:00:00	SPY	ETF	207.965	208.04	207.79	207.865	6744554.0
2014-12-08 12:00:00	SPY	ETF	207.8602	207.9499	206.97	207.1	15108575.0
2014-12-08 13:00:00	SPY	ETF	207.1	207.6	206.15	206.23	13608730.0
2014-12-08 14:00:00	SPY	ETF	206.23	207.49	205.93	206.63	14327649.0
2014-12-08 15:00:00	SPY	ETF	206.63	207.52	206.33	206.62	18295900.0
2014-12-08 16:00:00	SPY	ETF	206.62	208.0574	206.48	206.6	8415033.0
2014-12-08 17:00:00	SPY	ETF	206.58	206.63	206.56	206.57	117985.0
2014-12-08 18:00:00	SPY	ETF	206.57	206.72	206.57	206.67	73572.0
2014-12-08 19:00:00	SPY	ETF	206.69	206.74	206.62	206.67	45127.0
2014-12-08 04:00:00	QQQ	ETF	105.11	105.11	105.01	105.01	300.0
2014-12-08 05:00:00	QQQ	ETF	105.0	105.03	104.99	105.03	7100.0
2014-12-08 06:00:00	QQQ	ETF	105.07	105.1	105.07	105.08	9250.0
2014-12-08 07:00:00	QQQ	ETF	105.06	105.09	105.06	105.09	14000.0
2014-12-08 08:00:00	QQQ	ETF	105.07	105.12	105.0	105.05	83270.0
2014-12-08 09:00:00	QQQ	ETF	105.03	105.57	104.97	105.5	5082504.0
2014-12-08 10:00:00	QQQ	ETF	105.51	105.57	105.28	105.47	3481557.0
2014-12-08 11:00:00	QQQ	ETF	105.47	105.48	105.3	105.37	2467751.0
2014-12-08 12:00:00	QQQ	ETF	105.36	105.39	104.575	104.66	4666489.0
2014-12-08 13:00:00	QQQ	ETF	104.67	104.84	104.1532	104.22	4239822.0
2014-12-08 14:00:00	QQQ	ETF	104.23	104.59	104.075	104.495	3948320.0
2014-12-08 15:00:00	QQQ	ETF	104.49	104.6299	104.35	104.61	5962929.0
2014-12-08 16:00:00	QQQ	ETF	104.61	105.3787	104.55	105.3787	1350976.0
2014-12-08 17:00:00	QQQ	ETF	104.63	104.68	104.63	104.68	27782.0
2014-12-08 18:00:00	QQQ	ETF	104.67	104.71	104.65	104.7	7682.0
2014-12-08 19:00:00	QQQ	ETF	104.71	104.74	104.66	104.69	6323.0
2014-12-08 08:00:00	IWM	ETF	117.68	117.68	117.13	117.19	56703.0
2014-12-08 09:00:00	IWM	ETF	117.19	117.86	117.13	117.67	2047969.0
2014-12-08 10:00:00	IWM	ETF	117.66	118.37	117.65	118.11	3765360.0
2014-12-08 11:00:00	IWM	ETF	118.105	118.29	117.68	117.72	2608242.0
2014-12-08 12:00:00	IWM	ETF	117.71	117.71	116.63	116.72	4577140.0
2014-12-08 13:00:00	IWM	ETF	116.72	116.91	116.3	116.37	4292830.0
2014-12-08 14:00:00	IWM	ETF	116.37	116.52	115.85	116.35	3729648.0
2014-12-08 15:00:00	IWM	ETF	116.34	116.46	116.03	116.23	4318419.0
2014-12-08 16:00:00	IWM	ETF	116.22	116.28	116.09	116.22	1809273.0
2014-12-08 17:00:00	IWM	ETF	116.24	116.27	116.24	116.24	68900.0
2014-12-08 18:00:00	IWM	ETF	116.24	116.24	116.24	116.24	3000.0
2014-12-08 19:00:00	IWM	ETF	116.24	116.24	116.23	116.24	9609.0
2014-12-08 08:00:00	DIA	ETF	179.45	179.45	178.98	178.98	19200.0
2014-12-08 09:00:00	DIA	ETF	178.94	179.42	178.94	179.38	580383.0
2014-12-08 10:00:00	DIA	ETF	179.39	179.54	179.29	179.46	737525.0
2014-12-08 11:00:00	DIA	ETF	179.46	179.53	179.28	179.385	754876.0
2014-12-08 12:00:00	DIA	ETF	179.39	179.46	178.78	178.86	679850.0
2014-12-08 13:00:00	DIA	ETF	178.87	179.0	178.1601	178.21	722212.0

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

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