PREVIEW / etf_1hour / 2013-11-22

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-11-22.parquet
  size:    208 KB
  rows:    6,549

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
2013-11-22 04:00:00	SPY	ETF	180.01	180.02	179.82	179.85	33999.0
2013-11-22 05:00:00	SPY	ETF	179.81	179.98	179.76	179.76	58912.0
2013-11-22 06:00:00	SPY	ETF	179.81	179.89	179.75	179.8	58446.0
2013-11-22 07:00:00	SPY	ETF	179.79	179.93	179.76	179.89	111577.0
2013-11-22 08:00:00	SPY	ETF	179.88	180.16	179.79	179.95	639876.0
2013-11-22 09:00:00	SPY	ETF	179.94	180.08	179.77	180.0	9680679.0
2013-11-22 10:00:00	SPY	ETF	180.0	180.24	179.82	180.155	11047384.0
2013-11-22 11:00:00	SPY	ETF	180.16	180.55	180.09	180.49	9283620.0
2013-11-22 12:00:00	SPY	ETF	180.49	180.56	180.41	180.5	6826163.0
2013-11-22 13:00:00	SPY	ETF	180.495	180.56	180.33	180.3748	5463347.0
2013-11-22 14:00:00	SPY	ETF	180.37	180.68	180.35	180.665	7367678.0
2013-11-22 15:00:00	SPY	ETF	180.67	180.83	180.65	180.76	16990501.0
2013-11-22 16:00:00	SPY	ETF	180.77	180.82	179.9152	180.63	8186980.0
2013-11-22 17:00:00	SPY	ETF	180.63	180.81	180.58	180.62	1481750.0
2013-11-22 18:00:00	SPY	ETF	180.66	180.66	180.57	180.59	15094.0
2013-11-22 19:00:00	SPY	ETF	180.59	180.59	180.56	180.58	27644.0
2013-11-22 04:00:00	QQQ	ETF	83.62	83.62	83.56	83.56	7800.0
2013-11-22 05:00:00	QQQ	ETF	83.57	83.6	83.48	83.48	9848.0
2013-11-22 06:00:00	QQQ	ETF	83.51	83.54	83.51	83.51	5200.0
2013-11-22 07:00:00	QQQ	ETF	83.5	83.57	83.5	83.51	14840.0
2013-11-22 08:00:00	QQQ	ETF	83.53	83.7	83.5	83.64	81069.0
2013-11-22 09:00:00	QQQ	ETF	83.64	83.85	83.55	83.8	2954177.0
2013-11-22 10:00:00	QQQ	ETF	83.8	83.929	83.7	83.8	3229296.0
2013-11-22 11:00:00	QQQ	ETF	83.7999	83.9901	83.77	83.985	3824785.0
2013-11-22 12:00:00	QQQ	ETF	83.985	84.02	83.93	83.97	2158597.0
2013-11-22 13:00:00	QQQ	ETF	83.97	83.97	83.81	83.8337	1358938.0
2013-11-22 14:00:00	QQQ	ETF	83.83	84.01	83.82	84.0	1182712.0
2013-11-22 15:00:00	QQQ	ETF	83.99	84.02	83.921	83.99	4535670.0
2013-11-22 16:00:00	QQQ	ETF	83.99	84.0	83.541	83.99	1584944.0
2013-11-22 17:00:00	QQQ	ETF	83.99	84.01	83.97	83.99	85300.0
2013-11-22 18:00:00	QQQ	ETF	83.95	83.95	83.93	83.93	22779.0
2013-11-22 19:00:00	QQQ	ETF	83.93	83.93	83.93	83.93	2614.0
2013-11-22 06:00:00	IWM	ETF	111.2	111.26	111.2	111.2	2600.0
2013-11-22 07:00:00	IWM	ETF	111.2	111.32	111.2	111.25	22600.0
2013-11-22 08:00:00	IWM	ETF	111.25	111.5	111.25	111.3	126671.0
2013-11-22 09:00:00	IWM	ETF	111.29	111.39	111.1	111.28	2477159.0
2013-11-22 10:00:00	IWM	ETF	111.29	111.6458	111.105	111.48	3857920.0
2013-11-22 11:00:00	IWM	ETF	111.47	111.78	111.31	111.73	3569340.0
2013-11-22 12:00:00	IWM	ETF	111.74	111.78	111.62	111.73	2080771.0
2013-11-22 13:00:00	IWM	ETF	111.74	111.87	111.57	111.6001	1855414.0
2013-11-22 14:00:00	IWM	ETF	111.61	111.85	111.59	111.83	1839517.0
2013-11-22 15:00:00	IWM	ETF	111.82	111.97	111.8	111.84	5868676.0
2013-11-22 16:00:00	IWM	ETF	111.84	111.9194	111.2835	111.8	2898187.0
2013-11-22 17:00:00	IWM	ETF	111.79	111.84	111.79	111.84	1550.0
2013-11-22 19:00:00	IWM	ETF	111.8	111.8	111.8	111.8	1100.0
2013-11-22 08:00:00	DIA	ETF	159.86	160.0	159.83	159.95	10499.0
2013-11-22 09:00:00	DIA	ETF	159.91	159.92	159.4807	159.75	595597.0
2013-11-22 10:00:00	DIA	ETF	159.75	160.0	159.6	159.941	709669.0
2013-11-22 11:00:00	DIA	ETF	159.93	160.08	159.795	160.04	589170.0
2013-11-22 12:00:00	DIA	ETF	160.05	160.13	159.98	160.07	503288.0

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

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