PREVIEW / etf_1hour / 2014-11-06

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-11-06.parquet
  size:    231 KB
  rows:    7,337

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-11-06 04:00:00	SPY	ETF	202.08	202.12	201.9	201.98	51184.0
2014-11-06 05:00:00	SPY	ETF	202.04	202.22	202.04	202.21	13238.0
2014-11-06 06:00:00	SPY	ETF	202.26	202.31	202.13	202.15	28020.0
2014-11-06 07:00:00	SPY	ETF	202.2	202.22	201.92	201.97	213303.0
2014-11-06 08:00:00	SPY	ETF	201.98	203.3	201.96	202.94	3093128.0
2014-11-06 09:00:00	SPY	ETF	202.94	203.03	202.13	202.28	15348557.0
2014-11-06 10:00:00	SPY	ETF	202.29	202.48	201.64	202.405	15546108.0
2014-11-06 11:00:00	SPY	ETF	202.4	202.87	202.36	202.64	14168029.0
2014-11-06 12:00:00	SPY	ETF	202.65	202.83	202.5	202.77	7157245.0
2014-11-06 13:00:00	SPY	ETF	202.78	203.01	202.7	202.98	10686884.0
2014-11-06 14:00:00	SPY	ETF	202.98	203.08	202.76	203.02	5592026.0
2014-11-06 15:00:00	SPY	ETF	203.01	203.26	202.8	203.18	14720087.0
2014-11-06 16:00:00	SPY	ETF	203.19	203.45	203.15	203.4	9894700.0
2014-11-06 17:00:00	SPY	ETF	203.4	203.43	203.3	203.3	126839.0
2014-11-06 18:00:00	SPY	ETF	203.3	203.39	203.23	203.39	148642.0
2014-11-06 19:00:00	SPY	ETF	203.4	203.44	202.402	203.44	197718.0
2014-11-06 04:00:00	QQQ	ETF	101.06	101.06	101.06	101.06	1000.0
2014-11-06 06:00:00	QQQ	ETF	101.26	101.26	101.16	101.23	8800.0
2014-11-06 07:00:00	QQQ	ETF	101.24	101.24	101.08	101.08	116712.0
2014-11-06 08:00:00	QQQ	ETF	101.17	101.7	101.1	101.58	582584.0
2014-11-06 09:00:00	QQQ	ETF	101.6	101.62	101.16	101.35	5198305.0
2014-11-06 10:00:00	QQQ	ETF	101.35	101.43	100.921	101.22	4657142.0
2014-11-06 11:00:00	QQQ	ETF	101.22	101.48	101.19	101.315	2439450.0
2014-11-06 12:00:00	QQQ	ETF	101.315	101.36	101.21	101.29	1572001.0
2014-11-06 13:00:00	QQQ	ETF	101.29	101.46	101.285	101.45	1102897.0
2014-11-06 14:00:00	QQQ	ETF	101.46	101.55	101.33	101.51	1861747.0
2014-11-06 15:00:00	QQQ	ETF	101.51	101.72	101.405	101.68	3408470.0
2014-11-06 16:00:00	QQQ	ETF	101.68	101.82	101.2528	101.8	1101386.0
2014-11-06 17:00:00	QQQ	ETF	101.79	101.83	101.75	101.75	16285.0
2014-11-06 18:00:00	QQQ	ETF	101.75	101.79	101.72	101.77	5923.0
2014-11-06 19:00:00	QQQ	ETF	101.79	101.8	101.76	101.8	8599.0
2014-11-06 04:00:00	IWM	ETF	115.9	115.9	115.9	115.9	100.0
2014-11-06 06:00:00	IWM	ETF	116.1	116.1	116.0	116.08	5100.0
2014-11-06 07:00:00	IWM	ETF	116.0	116.0	115.79	115.95	98280.0
2014-11-06 08:00:00	IWM	ETF	115.93	116.64	115.86	116.5	717119.0
2014-11-06 09:00:00	IWM	ETF	116.53	116.54	115.7	115.87	6201146.0
2014-11-06 10:00:00	IWM	ETF	115.88	116.11	115.56	115.83	5632843.0
2014-11-06 11:00:00	IWM	ETF	115.83	116.24	115.81	115.95	2531507.0
2014-11-06 12:00:00	IWM	ETF	115.95	116.35	115.855	116.3161	2219959.0
2014-11-06 13:00:00	IWM	ETF	116.32	116.36	116.05	116.2	1316169.0
2014-11-06 14:00:00	IWM	ETF	116.2	116.33	116.06	116.31	1610961.0
2014-11-06 15:00:00	IWM	ETF	116.3	116.52	115.9802	116.52	5269737.0
2014-11-06 16:00:00	IWM	ETF	116.53	116.69	116.47	116.68	2340498.0
2014-11-06 17:00:00	IWM	ETF	116.62	116.7	116.45	116.7	48703.0
2014-11-06 18:00:00	IWM	ETF	116.69	116.69	116.69	116.69	440.0
2014-11-06 19:00:00	IWM	ETF	116.61	116.66	116.61	116.65	5000.0
2014-11-06 08:00:00	DIA	ETF	174.68	175.25	174.68	175.2	66850.0
2014-11-06 09:00:00	DIA	ETF	175.24	175.47	174.65	174.79	2940054.0
2014-11-06 10:00:00	DIA	ETF	174.78	174.97	174.1802	174.87	1177376.0
2014-11-06 11:00:00	DIA	ETF	174.86	175.18	174.84	175.0099	685089.0

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

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