PREVIEW / etf_1hour / 2014-12-11

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-11.parquet
  size:    237 KB
  rows:    7,506

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-11 04:00:00	SPY	ETF	203.9	204.04	203.87	203.96	45898.0
2014-12-11 05:00:00	SPY	ETF	203.97	204.04	203.6	203.64	70939.0
2014-12-11 06:00:00	SPY	ETF	203.65	203.76	203.35	203.36	92100.0
2014-12-11 07:00:00	SPY	ETF	203.33	203.99	203.33	203.92	331038.0
2014-12-11 08:00:00	SPY	ETF	203.65	204.19	203.34	204.08	2470078.0
2014-12-11 09:00:00	SPY	ETF	204.09	205.47	203.87	205.25	22825559.0
2014-12-11 10:00:00	SPY	ETF	205.24	206.08	205.14	205.73	25616654.0
2014-12-11 11:00:00	SPY	ETF	205.725	206.18	205.64	206.14	17146710.0
2014-12-11 12:00:00	SPY	ETF	206.13	206.19	205.83	206.01	10087027.0
2014-12-11 13:00:00	SPY	ETF	206.02	206.05	205.31	205.32	10346513.0
2014-12-11 14:00:00	SPY	ETF	205.31	205.45	204.13	204.23	24755254.0
2014-12-11 15:00:00	SPY	ETF	204.23	205.23	203.71	204.17	32196639.0
2014-12-11 16:00:00	SPY	ETF	204.16	206.067	202.89	203.32	8058312.0
2014-12-11 17:00:00	SPY	ETF	203.3	203.59	203.29	203.55	479565.0
2014-12-11 18:00:00	SPY	ETF	203.54	203.7	203.45	203.49	213957.0
2014-12-11 19:00:00	SPY	ETF	203.53	203.62	203.23	203.55	169831.0
2014-12-11 05:00:00	QQQ	ETF	103.53	103.53	103.49	103.49	1200.0
2014-12-11 06:00:00	QQQ	ETF	103.42	103.43	103.28	103.28	51260.0
2014-12-11 07:00:00	QQQ	ETF	103.22	103.56	103.21	103.52	95062.0
2014-12-11 08:00:00	QQQ	ETF	103.55	103.7	103.31	103.69	358584.0
2014-12-11 09:00:00	QQQ	ETF	103.67	104.41	103.6	104.38	6197704.0
2014-12-11 10:00:00	QQQ	ETF	104.38	104.92	104.23	104.78	7827959.0
2014-12-11 11:00:00	QQQ	ETF	104.785	105.04	104.71	104.98	3589349.0
2014-12-11 12:00:00	QQQ	ETF	104.98	105.01	104.73	104.87	2672541.0
2014-12-11 13:00:00	QQQ	ETF	104.88	104.92	104.6	104.61	2288253.0
2014-12-11 14:00:00	QQQ	ETF	104.61	104.69	103.92	103.97	4455418.0
2014-12-11 15:00:00	QQQ	ETF	103.975	104.51	103.59	103.82	7983138.0
2014-12-11 16:00:00	QQQ	ETF	103.81	104.6918	103.18	103.34	1674204.0
2014-12-11 17:00:00	QQQ	ETF	103.34	103.51	103.34	103.47	31784.0
2014-12-11 18:00:00	QQQ	ETF	103.49	103.56	103.43	103.47	31099.0
2014-12-11 19:00:00	QQQ	ETF	103.47	103.55	103.35	103.52	121529.0
2014-12-11 04:00:00	IWM	ETF	116.05	116.06	116.02	116.03	400.0
2014-12-11 05:00:00	IWM	ETF	116.0	116.0	116.0	116.0	400.0
2014-12-11 06:00:00	IWM	ETF	116.0	116.0	115.8	115.8	25600.0
2014-12-11 07:00:00	IWM	ETF	115.8	116.15	115.6	116.15	1649.0
2014-12-11 08:00:00	IWM	ETF	116.15	116.45	115.83	116.38	422737.0
2014-12-11 09:00:00	IWM	ETF	116.39	117.3162	116.18	117.08	6189366.0
2014-12-11 10:00:00	IWM	ETF	117.08	117.68	116.85	117.24	6813184.0
2014-12-11 11:00:00	IWM	ETF	117.24	117.43	116.94	117.41	4680989.0
2014-12-11 12:00:00	IWM	ETF	117.41	117.525	117.04	117.09	1837316.0
2014-12-11 13:00:00	IWM	ETF	117.09	117.125	116.67	116.67	2676676.0
2014-12-11 14:00:00	IWM	ETF	116.67	116.87	116.03	116.13	3889121.0
2014-12-11 15:00:00	IWM	ETF	116.125	116.8	115.87	116.15	6650684.0
2014-12-11 16:00:00	IWM	ETF	116.14	116.18	115.25	115.47	1132429.0
2014-12-11 17:00:00	IWM	ETF	115.48	115.68	115.47	115.59	30260.0
2014-12-11 18:00:00	IWM	ETF	115.67	115.67	115.65	115.65	5440.0
2014-12-11 19:00:00	IWM	ETF	115.66	115.72	115.6	115.65	8572.0
2014-12-11 05:00:00	DIA	ETF	176.0	176.0	175.0	176.0	600.0
2014-12-11 08:00:00	DIA	ETF	175.7	176.0	175.7	176.0	8150.0
2014-12-11 09:00:00	DIA	ETF	175.96	177.19	175.83	176.9701	1061552.0

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

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