PREVIEW / etf_1hour / 2013-11-13

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-11-13.parquet
  size:    212 KB
  rows:    6,618

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-13 04:00:00	SPY	ETF	176.8	176.85	176.65	176.75	12030.0
2013-11-13 05:00:00	SPY	ETF	176.73	176.91	176.72	176.75	25183.0
2013-11-13 06:00:00	SPY	ETF	176.72	176.78	176.5	176.52	177005.0
2013-11-13 07:00:00	SPY	ETF	176.54	176.6	176.3	176.39	406474.0
2013-11-13 08:00:00	SPY	ETF	176.4	176.56	175.96	176.06	1475979.0
2013-11-13 09:00:00	SPY	ETF	176.07	176.71	176.03	176.68	10799635.0
2013-11-13 10:00:00	SPY	ETF	176.69	176.99	176.44	176.87	12221636.0
2013-11-13 11:00:00	SPY	ETF	176.875	176.92	176.6901	176.9	9858987.0
2013-11-13 12:00:00	SPY	ETF	176.9	177.51	176.79	177.46	11288070.0
2013-11-13 13:00:00	SPY	ETF	177.46	177.89	177.34	177.751	9143545.0
2013-11-13 14:00:00	SPY	ETF	177.7503	177.82	177.55	177.5905	7027036.0
2013-11-13 15:00:00	SPY	ETF	177.591	178.41	177.59	178.36	22701384.0
2013-11-13 16:00:00	SPY	ETF	178.37	178.73	176.9864	178.55	10248249.0
2013-11-13 17:00:00	SPY	ETF	178.55	178.63	178.3	178.46	3523428.0
2013-11-13 18:00:00	SPY	ETF	178.46	178.82	178.45	178.75	374222.0
2013-11-13 19:00:00	SPY	ETF	178.75	178.81	178.71	178.8	412488.0
2013-11-13 04:00:00	QQQ	ETF	82.38	82.41	82.31	82.37	28600.0
2013-11-13 05:00:00	QQQ	ETF	82.39	82.49	82.39	82.43	17600.0
2013-11-13 06:00:00	QQQ	ETF	82.41	82.47	82.35	82.35	20300.0
2013-11-13 07:00:00	QQQ	ETF	82.37	82.4	82.26	82.29	28598.0
2013-11-13 08:00:00	QQQ	ETF	82.3	82.3	81.97	82.01	314202.0
2013-11-13 09:00:00	QQQ	ETF	82.0	82.4299	81.99	82.39	3635433.0
2013-11-13 10:00:00	QQQ	ETF	82.395	82.65	82.29	82.6	4171194.0
2013-11-13 11:00:00	QQQ	ETF	82.59	82.65	82.51	82.61	2524455.0
2013-11-13 12:00:00	QQQ	ETF	82.6	83.03	82.55	82.99	4230521.0
2013-11-13 13:00:00	QQQ	ETF	82.9999	83.179	82.93	83.12	2824380.0
2013-11-13 14:00:00	QQQ	ETF	83.11	83.155	83.05	83.09	2130202.0
2013-11-13 15:00:00	QQQ	ETF	83.08	83.54	83.075	83.54	7044434.0
2013-11-13 16:00:00	QQQ	ETF	83.55	83.61	82.3531	83.46	2640085.0
2013-11-13 17:00:00	QQQ	ETF	83.46	83.48	83.21	83.27	909212.0
2013-11-13 18:00:00	QQQ	ETF	83.26	83.42	83.24	83.42	47379.0
2013-11-13 19:00:00	QQQ	ETF	83.4	83.42	83.4	83.42	29180.0
2013-11-13 06:00:00	IWM	ETF	109.16	109.16	109.16	109.16	100.0
2013-11-13 07:00:00	IWM	ETF	109.04	109.05	108.88	108.92	24817.0
2013-11-13 08:00:00	IWM	ETF	108.92	109.06	108.57	108.68	271661.0
2013-11-13 09:00:00	IWM	ETF	108.64	109.41	108.62	109.37	4064056.0
2013-11-13 10:00:00	IWM	ETF	109.37	109.63	109.15	109.55	5606964.0
2013-11-13 11:00:00	IWM	ETF	109.5501	109.59	109.33	109.473	2084068.0
2013-11-13 12:00:00	IWM	ETF	109.48	109.98	109.405	109.93	3629389.0
2013-11-13 13:00:00	IWM	ETF	109.93	110.3	109.87	110.181	4361098.0
2013-11-13 14:00:00	IWM	ETF	110.19	110.265	110.04	110.07	2436653.0
2013-11-13 15:00:00	IWM	ETF	110.0694	110.55	110.02	110.52	7582601.0
2013-11-13 16:00:00	IWM	ETF	110.51	110.68	109.515	110.58	1657934.0
2013-11-13 17:00:00	IWM	ETF	110.55	110.55	110.4	110.46	30405.0
2013-11-13 18:00:00	IWM	ETF	110.69	110.7	110.6	110.65	3140.0
2013-11-13 19:00:00	IWM	ETF	110.72	110.89	110.61	110.89	7446.0
2013-11-13 04:00:00	DIA	ETF	157.22	157.22	157.22	157.22	100.0
2013-11-13 07:00:00	DIA	ETF	157.07	157.07	156.79	156.82	7590.0
2013-11-13 08:00:00	DIA	ETF	156.8	156.8	156.45	156.5	58026.0
2013-11-13 09:00:00	DIA	ETF	156.56	156.95	156.5	156.91	671713.0

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

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