PREVIEW / etf_1hour / 2012-04-26

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-04-26.parquet
  size:    185 KB
  rows:    5,696

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-04-26 04:00:00	SPY	ETF	139.42	139.66	139.4	139.4	6228.0
2012-04-26 05:00:00	SPY	ETF	139.39	139.43	139.06	139.12	4200.0
2012-04-26 06:00:00	SPY	ETF	139.08	139.12	138.89	139.07	54680.0
2012-04-26 07:00:00	SPY	ETF	139.07	139.19	138.98	139.19	173861.0
2012-04-26 08:00:00	SPY	ETF	139.19	139.24	138.62	138.86	2433743.0
2012-04-26 09:00:00	SPY	ETF	138.85	139.19	138.75	139.13	16614886.0
2012-04-26 10:00:00	SPY	ETF	139.13	139.44	139.059	139.151	23097627.0
2012-04-26 11:00:00	SPY	ETF	139.15	139.48	139.12	139.39	11699292.0
2012-04-26 12:00:00	SPY	ETF	139.39	139.46	139.26	139.42	7563777.0
2012-04-26 13:00:00	SPY	ETF	139.415	139.98	139.37	139.9435	13538456.0
2012-04-26 14:00:00	SPY	ETF	139.95	140.23	139.94	140.16	13099617.0
2012-04-26 15:00:00	SPY	ETF	140.17	140.32	140.02	140.14	30429398.0
2012-04-26 16:00:00	SPY	ETF	140.15	140.41	139.1662	140.01	12516454.0
2012-04-26 17:00:00	SPY	ETF	140.01	140.01	139.56	139.65	1585358.0
2012-04-26 18:00:00	SPY	ETF	139.62	139.64	139.46	139.57	400940.0
2012-04-26 19:00:00	SPY	ETF	139.55	139.67	139.5	139.55	444181.0
2012-04-26 04:00:00	QQQ	ETF	66.6	66.62	66.52	66.52	5200.0
2012-04-26 05:00:00	QQQ	ETF	66.51	66.51	66.36	66.36	4300.0
2012-04-26 06:00:00	QQQ	ETF	66.33	66.33	66.28	66.28	7400.0
2012-04-26 07:00:00	QQQ	ETF	66.34	66.39	66.31	66.39	206656.0
2012-04-26 08:00:00	QQQ	ETF	66.41	66.47	66.21	66.34	776857.0
2012-04-26 09:00:00	QQQ	ETF	66.33	66.68	66.29	66.48	8754137.0
2012-04-26 10:00:00	QQQ	ETF	66.49	66.66	66.37	66.41	6676909.0
2012-04-26 11:00:00	QQQ	ETF	66.41	66.56	66.35	66.47	4459904.0
2012-04-26 12:00:00	QQQ	ETF	66.47	66.49	66.4	66.445	1797640.0
2012-04-26 13:00:00	QQQ	ETF	66.45	66.82	66.45	66.79	4640655.0
2012-04-26 14:00:00	QQQ	ETF	66.8	66.97	66.77	66.94	3177789.0
2012-04-26 15:00:00	QQQ	ETF	66.94	66.99	66.77	66.83	8524516.0
2012-04-26 16:00:00	QQQ	ETF	66.83	67.06	66.6835	66.9	1770708.0
2012-04-26 17:00:00	QQQ	ETF	66.9	66.91	66.71	66.74	156685.0
2012-04-26 18:00:00	QQQ	ETF	66.74	66.74	66.7	66.72	45264.0
2012-04-26 19:00:00	QQQ	ETF	66.72	66.77	66.7	66.72	16396.0
2012-04-26 04:00:00	IWM	ETF	81.49	81.49	81.43	81.43	582.0
2012-04-26 06:00:00	IWM	ETF	80.95	80.95	80.95	80.95	10000.0
2012-04-26 07:00:00	IWM	ETF	81.06	81.15	81.01	81.14	15700.0
2012-04-26 08:00:00	IWM	ETF	81.12	81.16	80.65	80.79	860592.0
2012-04-26 09:00:00	IWM	ETF	80.79	81.28	80.72	81.11	4825852.0
2012-04-26 10:00:00	IWM	ETF	81.11	81.44	81.099	81.199	5958782.0
2012-04-26 11:00:00	IWM	ETF	81.19	81.46	81.16	81.38	3070483.0
2012-04-26 12:00:00	IWM	ETF	81.39	81.52	81.35	81.45	2369345.0
2012-04-26 13:00:00	IWM	ETF	81.445	81.7	81.355	81.68	4971173.0
2012-04-26 14:00:00	IWM	ETF	81.673	81.86	81.61	81.72	3331532.0
2012-04-26 15:00:00	IWM	ETF	81.72	81.87	81.6	81.69	9852529.0
2012-04-26 16:00:00	IWM	ETF	81.69	81.82	81.54	81.55	1939735.0
2012-04-26 17:00:00	IWM	ETF	81.55	81.55	81.35	81.35	162431.0
2012-04-26 18:00:00	IWM	ETF	81.3	81.3	81.22	81.22	853.0
2012-04-26 19:00:00	IWM	ETF	81.31	81.31	81.31	81.31	1891.0
2012-04-26 06:00:00	DIA	ETF	130.53	130.55	130.53	130.55	2000.0
2012-04-26 07:00:00	DIA	ETF	130.6	130.6	130.56	130.56	1000.0
2012-04-26 08:00:00	DIA	ETF	130.68	130.7	130.28	130.47	14900.0

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

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