PREVIEW / etf_1hour / 2012-05-01

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-01.parquet
  size:    185 KB
  rows:    5,686

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-05-01 04:00:00	SPY	ETF	140.0	140.0	139.93	139.93	800.0
2012-05-01 05:00:00	SPY	ETF	139.9	139.9	139.76	139.76	25400.0
2012-05-01 06:00:00	SPY	ETF	139.75	139.95	139.7	139.92	119400.0
2012-05-01 07:00:00	SPY	ETF	139.94	140.1	139.91	139.99	190864.0
2012-05-01 08:00:00	SPY	ETF	140.0	140.15	139.77	139.91	992050.0
2012-05-01 09:00:00	SPY	ETF	139.9	140.08	139.63	139.7	13302526.0
2012-05-01 10:00:00	SPY	ETF	139.7	141.27	139.7	141.19	32105451.0
2012-05-01 11:00:00	SPY	ETF	141.19	141.66	141.16	141.53	13593514.0
2012-05-01 12:00:00	SPY	ETF	141.53	141.56	141.45	141.47	7205707.0
2012-05-01 13:00:00	SPY	ETF	141.47	141.48	141.235	141.33	10727222.0
2012-05-01 14:00:00	SPY	ETF	141.34	141.39	141.12	141.191	14854277.0
2012-05-01 15:00:00	SPY	ETF	141.2	141.28	140.61	140.72	24355558.0
2012-05-01 16:00:00	SPY	ETF	140.72	141.48	139.8917	140.63	16069994.0
2012-05-01 17:00:00	SPY	ETF	140.61	140.74	140.51	140.59	224143.0
2012-05-01 18:00:00	SPY	ETF	140.6	140.67	140.56	140.61	43131.0
2012-05-01 19:00:00	SPY	ETF	140.61	140.68	140.57	140.67	47230.0
2012-05-01 06:00:00	QQQ	ETF	66.76	66.76	66.76	66.76	2000.0
2012-05-01 07:00:00	QQQ	ETF	66.79	66.93	66.77	66.88	5025.0
2012-05-01 08:00:00	QQQ	ETF	66.76	66.9	66.76	66.82	940651.0
2012-05-01 09:00:00	QQQ	ETF	66.8	67.03	66.59	66.8	5763678.0
2012-05-01 10:00:00	QQQ	ETF	66.79	67.5	66.79	67.39	9466719.0
2012-05-01 11:00:00	QQQ	ETF	67.39	67.63	67.38	67.54	3047076.0
2012-05-01 12:00:00	QQQ	ETF	67.53	67.5504	67.41	67.44	1868229.0
2012-05-01 13:00:00	QQQ	ETF	67.45	67.45	67.18	67.23	2526348.0
2012-05-01 14:00:00	QQQ	ETF	67.23	67.32	67.09	67.18	4082232.0
2012-05-01 15:00:00	QQQ	ETF	67.18	67.25	66.86	66.88	6581621.0
2012-05-01 16:00:00	QQQ	ETF	66.87	67.2583	66.75	66.79	831678.0
2012-05-01 17:00:00	QQQ	ETF	66.81	66.81	66.75	66.76	20171.0
2012-05-01 18:00:00	QQQ	ETF	66.78	66.83	66.78	66.8	16385.0
2012-05-01 19:00:00	QQQ	ETF	66.8	66.83	66.8	66.83	24124.0
2012-05-01 06:00:00	IWM	ETF	81.4	81.47	81.39	81.47	7100.0
2012-05-01 07:00:00	IWM	ETF	81.59	81.76	81.59	81.76	6790.0
2012-05-01 08:00:00	IWM	ETF	81.68	81.68	81.43	81.47	535473.0
2012-05-01 09:00:00	IWM	ETF	81.64	81.71	81.29	81.36	5134188.0
2012-05-01 10:00:00	IWM	ETF	81.37	82.82	81.36	82.72	12522592.0
2012-05-01 11:00:00	IWM	ETF	82.72	82.97	82.67	82.88	3730668.0
2012-05-01 12:00:00	IWM	ETF	82.88	82.9	82.6	82.62	2285379.0
2012-05-01 13:00:00	IWM	ETF	82.62	82.64	82.39	82.56	2746676.0
2012-05-01 14:00:00	IWM	ETF	82.56	82.56	82.16	82.23	4809029.0
2012-05-01 15:00:00	IWM	ETF	82.24	82.32	81.46	81.54	11063178.0
2012-05-01 16:00:00	IWM	ETF	81.54	81.55	81.143	81.33	6490420.0
2012-05-01 17:00:00	IWM	ETF	81.35	81.35	81.26	81.32	17460.0
2012-05-01 18:00:00	IWM	ETF	81.32	81.4	81.32	81.38	5590.0
2012-05-01 19:00:00	IWM	ETF	81.39	81.39	81.35	81.37	10400.0
2012-05-01 07:00:00	DIA	ETF	132.05	132.05	132.05	132.05	109.0
2012-05-01 08:00:00	DIA	ETF	131.92	132.01	131.92	132.01	2300.0
2012-05-01 09:00:00	DIA	ETF	131.92	131.94	131.4	131.57	396553.0
2012-05-01 10:00:00	DIA	ETF	131.57	132.83	131.54	132.78	2079635.0
2012-05-01 11:00:00	DIA	ETF	132.78	133.14	132.7601	133.05	799422.0
2012-05-01 12:00:00	DIA	ETF	133.05	133.08	133.0	133.03	260364.0

> showing 50 of 5,686 rows — these rows as CSV

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