PREVIEW / etf_1hour / 2012-12-24

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-12-24.parquet
  size:    120 KB
  rows:    3,613

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
2012-12-24 04:00:00	SPY	ETF	142.1	142.19	142.06	142.19	64854.0
2012-12-24 05:00:00	SPY	ETF	142.22	142.27	142.22	142.27	389.0
2012-12-24 06:00:00	SPY	ETF	142.27	142.43	142.25	142.43	187041.0
2012-12-24 07:00:00	SPY	ETF	142.41	142.44	142.33	142.41	147567.0
2012-12-24 08:00:00	SPY	ETF	142.42	142.6	142.42	142.6	4951641.0
2012-12-24 09:00:00	SPY	ETF	142.6	142.72	142.24	142.26	9431338.0
2012-12-24 10:00:00	SPY	ETF	142.27	142.56	142.25	142.3	9366575.0
2012-12-24 11:00:00	SPY	ETF	142.3	142.4	142.24	142.3525	6853996.0
2012-12-24 12:00:00	SPY	ETF	142.35	142.455	142.19	142.35	13705408.0
2012-12-24 13:00:00	SPY	ETF	142.35	142.7529	142.12	142.16	4677273.0
2012-12-24 14:00:00	SPY	ETF	142.18	142.18	142.07	142.14	130715.0
2012-12-24 15:00:00	SPY	ETF	142.14	142.23	142.14	142.23	12460.0
2012-12-24 16:00:00	SPY	ETF	142.24	142.24	142.17	142.2	9138.0
2012-12-24 04:00:00	QQQ	ETF	64.91	64.91	64.91	64.91	19923.0
2012-12-24 06:00:00	QQQ	ETF	65.09	65.09	64.95	65.0	5800.0
2012-12-24 07:00:00	QQQ	ETF	64.98	65.01	64.95	64.98	17000.0
2012-12-24 08:00:00	QQQ	ETF	65.01	65.14	64.99	65.14	66669.0
2012-12-24 09:00:00	QQQ	ETF	65.13	65.19	64.97	64.97	3715296.0
2012-12-24 10:00:00	QQQ	ETF	64.975	65.13	64.92	64.94	1644098.0
2012-12-24 11:00:00	QQQ	ETF	64.95	65.05	64.9359	65.02	1266690.0
2012-12-24 12:00:00	QQQ	ETF	65.02	65.0585	64.96	65.04	2776667.0
2012-12-24 13:00:00	QQQ	ETF	65.035	65.2044	64.98	65.04	1516434.0
2012-12-24 14:00:00	QQQ	ETF	64.98	64.98	64.9	64.98	10350.0
2012-12-24 04:00:00	IWM	ETF	83.83	83.83	83.83	83.83	757.0
2012-12-24 05:00:00	IWM	ETF	83.85	83.9	83.85	83.9	969.0
2012-12-24 06:00:00	IWM	ETF	83.9	84.04	83.9	84.04	1600.0
2012-12-24 07:00:00	IWM	ETF	84.05	84.1	84.05	84.1	1100.0
2012-12-24 08:00:00	IWM	ETF	84.13	84.23	84.05	84.14	16159.0
2012-12-24 09:00:00	IWM	ETF	84.15	84.18	83.51	83.66	3052414.0
2012-12-24 10:00:00	IWM	ETF	83.659	83.97	83.64	83.81	2459878.0
2012-12-24 11:00:00	IWM	ETF	83.8001	83.88	83.73	83.75	1011731.0
2012-12-24 12:00:00	IWM	ETF	83.75	83.78	83.62	83.77	2631595.0
2012-12-24 13:00:00	IWM	ETF	83.78	83.81	83.55	83.64	581718.0
2012-12-24 14:00:00	IWM	ETF	83.61	83.68	83.52	83.68	22100.0
2012-12-24 15:00:00	IWM	ETF	83.61	83.68	83.61	83.68	2120.0
2012-12-24 08:00:00	DIA	ETF	131.33	131.53	131.33	131.49	1300.0
2012-12-24 09:00:00	DIA	ETF	131.45	131.51	131.12	131.22	313756.0
2012-12-24 10:00:00	DIA	ETF	131.19	131.42	131.16	131.16	335448.0
2012-12-24 11:00:00	DIA	ETF	131.17	131.27	131.12	131.185	278760.0
2012-12-24 12:00:00	DIA	ETF	131.199	131.2	130.995	131.08	778241.0
2012-12-24 13:00:00	DIA	ETF	131.07	131.21	130.97	130.98	266736.0
2012-12-24 16:00:00	DIA	ETF	130.93	130.93	130.93	130.93	100.0
2012-12-24 04:00:00	GLD	ETF	160.95	161.11	160.95	161.11	1713.0
2012-12-24 05:00:00	GLD	ETF	161.11	161.11	161.11	161.11	100.0
2012-12-24 06:00:00	GLD	ETF	161.14	161.14	161.14	161.14	300.0
2012-12-24 07:00:00	GLD	ETF	161.16	161.16	161.03	161.03	1317.0
2012-12-24 08:00:00	GLD	ETF	160.96	161.02	160.73	160.9	92292.0
2012-12-24 09:00:00	GLD	ETF	160.82	160.96	160.63	160.83	890298.0
2012-12-24 10:00:00	GLD	ETF	160.83	160.96	160.62	160.84	959333.0
2012-12-24 11:00:00	GLD	ETF	160.85	160.85	160.62	160.795	607778.0

> showing 50 of 3,613 rows — these rows as CSV

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