PREVIEW / etf_1hour / 2012-03-20

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-03-20.parquet
  size:    186 KB
  rows:    5,770

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-03-20 04:00:00	SPY	ETF	140.57	140.58	140.43	140.43	17382.0
2012-03-20 05:00:00	SPY	ETF	140.63	140.63	140.01	140.13	32247.0
2012-03-20 06:00:00	SPY	ETF	140.12	140.14	139.99	140.06	60555.0
2012-03-20 07:00:00	SPY	ETF	140.03	140.21	140.02	140.06	327950.0
2012-03-20 08:00:00	SPY	ETF	140.07	140.13	139.9	140.02	2629472.0
2012-03-20 09:00:00	SPY	ETF	140.02	140.16	139.64	139.955	21793955.0
2012-03-20 10:00:00	SPY	ETF	139.95	140.25	139.87	140.12	19526513.0
2012-03-20 11:00:00	SPY	ETF	140.13	140.27	139.96	140.109	16338497.0
2012-03-20 12:00:00	SPY	ETF	140.1	140.24	140.07	140.21	10908456.0
2012-03-20 13:00:00	SPY	ETF	140.21	140.43	140.18	140.4	10888893.0
2012-03-20 14:00:00	SPY	ETF	140.4	140.56	140.31	140.4575	10827576.0
2012-03-20 15:00:00	SPY	ETF	140.46	140.61	140.28	140.42	22432137.0
2012-03-20 16:00:00	SPY	ETF	140.42	140.6	139.91	140.54	4468255.0
2012-03-20 17:00:00	SPY	ETF	140.54	140.55	140.47	140.49	76291.0
2012-03-20 18:00:00	SPY	ETF	140.5	140.51	140.44	140.45	35852.0
2012-03-20 19:00:00	SPY	ETF	140.45	140.47	140.35	140.45	66554.0
2012-03-20 05:00:00	QQQ	ETF	66.75	66.75	66.66	66.69	11103.0
2012-03-20 06:00:00	QQQ	ETF	66.71	66.71	66.65	66.65	26300.0
2012-03-20 07:00:00	QQQ	ETF	66.67	66.75	66.66	66.69	46200.0
2012-03-20 08:00:00	QQQ	ETF	66.68	66.73	66.62	66.65	1237217.0
2012-03-20 09:00:00	QQQ	ETF	66.65	66.7	66.46	66.54	5088196.0
2012-03-20 10:00:00	QQQ	ETF	66.55	66.68	66.47	66.63	4938544.0
2012-03-20 11:00:00	QQQ	ETF	66.62	66.75	66.55	66.65	4169080.0
2012-03-20 12:00:00	QQQ	ETF	66.64	66.76	66.61	66.73	4346268.0
2012-03-20 13:00:00	QQQ	ETF	66.725	66.94	66.7	66.92	4356980.0
2012-03-20 14:00:00	QQQ	ETF	66.93	67.08	66.89	67.02	5948177.0
2012-03-20 15:00:00	QQQ	ETF	67.02	67.185	67.02	67.11	9060609.0
2012-03-20 16:00:00	QQQ	ETF	67.12	67.23	67.09	67.23	1166871.0
2012-03-20 17:00:00	QQQ	ETF	67.2	67.2	67.13	67.15	113955.0
2012-03-20 18:00:00	QQQ	ETF	67.11	67.15	67.11	67.14	8950.0
2012-03-20 19:00:00	QQQ	ETF	67.11	67.12	67.08	67.12	14743.0
2012-03-20 07:00:00	IWM	ETF	83.04	83.16	82.99	83.1	19770.0
2012-03-20 08:00:00	IWM	ETF	83.06	83.12	82.95	83.04	1125992.0
2012-03-20 09:00:00	IWM	ETF	83.01	83.21	82.71	82.89	6708988.0
2012-03-20 10:00:00	IWM	ETF	82.89	83.1499	82.7	83.05	5204825.0
2012-03-20 11:00:00	IWM	ETF	83.05	83.17	82.58	82.719	4715749.0
2012-03-20 12:00:00	IWM	ETF	82.71	82.95	82.59	82.739	4184258.0
2012-03-20 13:00:00	IWM	ETF	82.74	83.13	82.69	82.985	3680630.0
2012-03-20 14:00:00	IWM	ETF	82.995	83.29	82.92	83.175	4578763.0
2012-03-20 15:00:00	IWM	ETF	83.16	83.3	82.88	82.94	7327551.0
2012-03-20 16:00:00	IWM	ETF	82.94	83.01	82.89	83.01	531276.0
2012-03-20 17:00:00	IWM	ETF	82.96	83.7714	82.94	82.94	502630.0
2012-03-20 18:00:00	IWM	ETF	82.9	82.9	82.9	82.9	200.0
2012-03-20 19:00:00	IWM	ETF	82.95	82.95	82.95	82.95	852.0
2012-03-20 05:00:00	DIA	ETF	131.53	131.53	131.53	131.53	100.0
2012-03-20 08:00:00	DIA	ETF	131.48	131.48	131.3	131.35	26775.0
2012-03-20 09:00:00	DIA	ETF	131.33	131.41	130.92	131.1699	817288.0
2012-03-20 10:00:00	DIA	ETF	131.17	131.46	131.11	131.37	730215.0
2012-03-20 11:00:00	DIA	ETF	131.37	131.48	131.29	131.3901	692921.0
2012-03-20 12:00:00	DIA	ETF	131.39	131.48	131.33	131.41	364993.0

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

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