PREVIEW / etf_1hour / 2014-02-27

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-02-27.parquet
  size:    216 KB
  rows:    6,771

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-02-27 04:00:00	SPY	ETF	185.1	185.1	184.21	184.21	43374.0
2014-02-27 05:00:00	SPY	ETF	184.17	184.38	183.84	183.93	46825.0
2014-02-27 06:00:00	SPY	ETF	183.93	184.2	183.87	184.15	67389.0
2014-02-27 07:00:00	SPY	ETF	184.12	184.4	184.06	184.39	379696.0
2014-02-27 08:00:00	SPY	ETF	184.29	184.76	183.99	184.58	1088566.0
2014-02-27 09:00:00	SPY	ETF	184.59	185.05	184.37	184.6899	10608332.0
2014-02-27 10:00:00	SPY	ETF	184.69	185.09	184.42	184.97	14694043.0
2014-02-27 11:00:00	SPY	ETF	184.97	185.45	184.87	185.23	12692921.0
2014-02-27 12:00:00	SPY	ETF	185.23	185.36	185.01	185.26	6431028.0
2014-02-27 13:00:00	SPY	ETF	185.25	185.81	185.21	185.65	9675964.0
2014-02-27 14:00:00	SPY	ETF	185.655	185.75	185.28	185.48	8777171.0
2014-02-27 15:00:00	SPY	ETF	185.48	185.84	185.32	185.84	18909325.0
2014-02-27 16:00:00	SPY	ETF	185.84	186.04	184.72	186.04	9117620.0
2014-02-27 17:00:00	SPY	ETF	186.03	186.07	185.96	185.96	176765.0
2014-02-27 18:00:00	SPY	ETF	185.95	185.95	184.9	185.85	100071.0
2014-02-27 19:00:00	SPY	ETF	185.82	185.92	185.8	185.84	59757.0
2014-02-27 04:00:00	QQQ	ETF	90.25	90.4	89.67	89.67	225576.0
2014-02-27 05:00:00	QQQ	ETF	89.64	89.65	89.5	89.58	259147.0
2014-02-27 06:00:00	QQQ	ETF	89.58	89.76	89.53	89.74	132090.0
2014-02-27 07:00:00	QQQ	ETF	89.73	89.76	89.62	89.76	14798.0
2014-02-27 08:00:00	QQQ	ETF	89.66	89.93	89.66	89.85	160204.0
2014-02-27 09:00:00	QQQ	ETF	89.87	90.05	89.73	89.88	3562933.0
2014-02-27 10:00:00	QQQ	ETF	89.89	90.15	89.74	90.07	5015226.0
2014-02-27 11:00:00	QQQ	ETF	90.06	90.25	90.03	90.0834	3158103.0
2014-02-27 12:00:00	QQQ	ETF	90.0844	90.25	90.0	90.21	1333751.0
2014-02-27 13:00:00	QQQ	ETF	90.21	90.51	90.16	90.49	2441836.0
2014-02-27 14:00:00	QQQ	ETF	90.5	90.53	90.22	90.33	1611968.0
2014-02-27 15:00:00	QQQ	ETF	90.3299	90.43	90.17	90.42	5097431.0
2014-02-27 16:00:00	QQQ	ETF	90.43	90.53	90.13	90.51	1633865.0
2014-02-27 17:00:00	QQQ	ETF	90.52	90.56	90.52	90.54	41374.0
2014-02-27 18:00:00	QQQ	ETF	90.45	90.45	90.39	90.39	6400.0
2014-02-27 19:00:00	QQQ	ETF	90.43	90.45	90.43	90.43	1421.0
2014-02-27 05:00:00	IWM	ETF	116.76	116.76	116.57	116.57	1300.0
2014-02-27 06:00:00	IWM	ETF	116.56	116.86	116.34	116.86	9200.0
2014-02-27 07:00:00	IWM	ETF	116.92	116.92	116.65	116.86	121452.0
2014-02-27 08:00:00	IWM	ETF	116.74	117.05	116.3482	116.82	328697.0
2014-02-27 09:00:00	IWM	ETF	116.82	117.46	116.81	117.28	4347410.0
2014-02-27 10:00:00	IWM	ETF	117.3	117.43	116.76	117.38	4340562.0
2014-02-27 11:00:00	IWM	ETF	117.38	117.755	117.31	117.56	2966175.0
2014-02-27 12:00:00	IWM	ETF	117.565	117.71	117.45	117.66	1374914.0
2014-02-27 13:00:00	IWM	ETF	117.66	117.97	117.62	117.87	1908389.0
2014-02-27 14:00:00	IWM	ETF	117.87	117.96	117.54	117.7597	2744908.0
2014-02-27 15:00:00	IWM	ETF	117.755	118.055	117.64	118.01	4689185.0
2014-02-27 16:00:00	IWM	ETF	118.01	118.11	117.5	118.11	2179848.0
2014-02-27 17:00:00	IWM	ETF	118.08	118.13	118.06	118.13	19875.0
2014-02-27 18:00:00	IWM	ETF	118.06	118.06	118.01	118.01	1750.0
2014-02-27 19:00:00	IWM	ETF	118.0	118.02	117.96	117.96	3100.0
2014-02-27 06:00:00	DIA	ETF	161.29	161.29	161.21	161.23	5000.0
2014-02-27 07:00:00	DIA	ETF	161.22	161.22	161.17	161.17	14500.0
2014-02-27 08:00:00	DIA	ETF	161.4	161.58	161.4	161.58	740.0

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

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