PREVIEW / etf_30min / 2012-06-11

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-06-11.parquet
  size:    288 KB
  rows:    9,586

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-06-11 04:00:00	SPY	ETF	134.5	134.93	134.5	134.93	8152.0
2012-06-11 04:30:00	SPY	ETF	134.66	134.7	134.59	134.59	54355.0
2012-06-11 05:00:00	SPY	ETF	134.69	134.71	134.56	134.64	19987.0
2012-06-11 05:30:00	SPY	ETF	134.58	134.58	134.38	134.38	18293.0
2012-06-11 06:00:00	SPY	ETF	134.44	134.48	134.31	134.41	11655.0
2012-06-11 06:30:00	SPY	ETF	134.36	134.55	134.31	134.33	90300.0
2012-06-11 07:00:00	SPY	ETF	134.32	134.35	133.95	134.0	491221.0
2012-06-11 07:30:00	SPY	ETF	133.99	134.08	133.81	134.0	451923.0
2012-06-11 08:00:00	SPY	ETF	134.0	134.9	133.84	133.9	1112516.0
2012-06-11 08:30:00	SPY	ETF	133.92	134.96	133.86	134.11	1188775.0
2012-06-11 09:00:00	SPY	ETF	134.14	134.21	134.04	134.17	2074103.0
2012-06-11 09:30:00	SPY	ETF	134.17	134.25	133.18	133.26	23117921.0
2012-06-11 10:00:00	SPY	ETF	133.25	133.48	132.87	133.012	17606602.0
2012-06-11 10:30:00	SPY	ETF	133.02	133.19	132.62	132.74	12832077.0
2012-06-11 11:00:00	SPY	ETF	132.74	132.82	132.52	132.69	11900053.0
2012-06-11 11:30:00	SPY	ETF	132.7	133.01	132.61	132.9	8990369.0
2012-06-11 12:00:00	SPY	ETF	132.89	133.03	132.66	132.7015	5312547.0
2012-06-11 12:30:00	SPY	ETF	132.702	132.94	132.69	132.88	5111758.0
2012-06-11 13:00:00	SPY	ETF	132.88	133.16	132.81	132.99	7495978.0
2012-06-11 13:30:00	SPY	ETF	132.99	132.99	132.64	132.73	6673828.0
2012-06-11 14:00:00	SPY	ETF	132.725	132.73	132.26	132.37	9075581.0
2012-06-11 14:30:00	SPY	ETF	132.36	132.56	132.28	132.38	6047821.0
2012-06-11 15:00:00	SPY	ETF	132.38	132.43	131.79	131.905	9502510.0
2012-06-11 15:30:00	SPY	ETF	131.91	132.23	131.28	131.47	24449736.0
2012-06-11 16:00:00	SPY	ETF	131.47	131.65	131.23	131.3	7892658.0
2012-06-11 16:30:00	SPY	ETF	131.3	131.37	131.19	131.27	4518076.0
2012-06-11 17:00:00	SPY	ETF	131.29	131.29	131.11	131.27	59250.0
2012-06-11 17:30:00	SPY	ETF	131.27	131.31	131.2	131.3	63750.0
2012-06-11 18:00:00	SPY	ETF	131.32	131.35	130.96	131.16	139277.0
2012-06-11 18:30:00	SPY	ETF	131.17	131.44	131.16	131.33	39756.0
2012-06-11 19:00:00	SPY	ETF	131.35	131.37	131.29	131.32	42502.0
2012-06-11 19:30:00	SPY	ETF	131.32	131.34	131.12	131.32	77535.0
2012-06-11 04:00:00	QQQ	ETF	63.58	63.63	63.58	63.63	785.0
2012-06-11 05:30:00	QQQ	ETF	63.45	63.45	63.45	63.45	852.0
2012-06-11 06:00:00	QQQ	ETF	63.45	63.45	63.43	63.43	10300.0
2012-06-11 06:30:00	QQQ	ETF	63.41	63.48	63.4	63.48	3500.0
2012-06-11 07:00:00	QQQ	ETF	63.38	63.42	63.26	63.26	29718.0
2012-06-11 07:30:00	QQQ	ETF	63.26	63.29	63.16	63.24	99700.0
2012-06-11 08:00:00	QQQ	ETF	63.25	63.29	63.2	63.21	273296.0
2012-06-11 08:30:00	QQQ	ETF	63.21	63.34	63.19	63.3	242387.0
2012-06-11 09:00:00	QQQ	ETF	63.31	63.34	63.25	63.32	149647.0
2012-06-11 09:30:00	QQQ	ETF	63.33	63.38	62.83	62.88	6326209.0
2012-06-11 10:00:00	QQQ	ETF	62.88	63.0	62.69	62.7605	3386157.0
2012-06-11 10:30:00	QQQ	ETF	62.76	62.89	62.57	62.66	2917607.0
2012-06-11 11:00:00	QQQ	ETF	62.66	62.77	62.58	62.73	2947346.0
2012-06-11 11:30:00	QQQ	ETF	62.73	62.85	62.64	62.76	3469336.0
2012-06-11 12:00:00	QQQ	ETF	62.76	62.82	62.67	62.69	2913100.0
2012-06-11 12:30:00	QQQ	ETF	62.6991	62.77	62.68	62.72	1774272.0
2012-06-11 13:00:00	QQQ	ETF	62.72	62.86	62.6501	62.78	1951111.0
2012-06-11 13:30:00	QQQ	ETF	62.77	62.78	62.53	62.608	2696889.0

> showing 50 of 9,586 rows — these rows as CSV

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