PREVIEW / etf_30min / 2012-08-28

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-28.parquet
  size:    267 KB
  rows:    9,199

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-08-28 05:00:00	SPY	ETF	141.72	141.72	141.72	141.72	100.0
2012-08-28 05:30:00	SPY	ETF	141.59	141.59	141.59	141.59	100.0
2012-08-28 06:00:00	SPY	ETF	141.6	141.64	141.6	141.64	33700.0
2012-08-28 06:30:00	SPY	ETF	141.64	141.65	141.55	141.55	32287.0
2012-08-28 07:00:00	SPY	ETF	141.54	141.54	141.42	141.45	70837.0
2012-08-28 07:30:00	SPY	ETF	141.47	141.48	141.38	141.44	66186.0
2012-08-28 08:00:00	SPY	ETF	141.4	141.49	141.26	141.29	422011.0
2012-08-28 08:30:00	SPY	ETF	141.29	141.29	141.07	141.12	437539.0
2012-08-28 09:00:00	SPY	ETF	141.12	141.36	141.06	141.18	1112249.0
2012-08-28 09:30:00	SPY	ETF	141.18	141.56	141.06	141.12	11532832.0
2012-08-28 10:00:00	SPY	ETF	141.14	141.76	140.97	141.68	12240766.0
2012-08-28 10:30:00	SPY	ETF	141.685	141.84	141.39	141.449	5882567.0
2012-08-28 11:00:00	SPY	ETF	141.45	141.5	141.28	141.445	4217447.0
2012-08-28 11:30:00	SPY	ETF	141.45	141.61	141.36	141.61	3646892.0
2012-08-28 12:00:00	SPY	ETF	141.6	141.75	141.6	141.66	3859687.0
2012-08-28 12:30:00	SPY	ETF	141.66	141.72	141.56	141.709	2462273.0
2012-08-28 13:00:00	SPY	ETF	141.71	141.72	141.47	141.495	2580242.0
2012-08-28 13:30:00	SPY	ETF	141.4989	141.59	141.41	141.449	2768405.0
2012-08-28 14:00:00	SPY	ETF	141.45	141.7	141.44	141.67	2686443.0
2012-08-28 14:30:00	SPY	ETF	141.679	141.72	141.48	141.56	2099278.0
2012-08-28 15:00:00	SPY	ETF	141.57	141.8001	141.47	141.51	5426351.0
2012-08-28 15:30:00	SPY	ETF	141.51	141.59	141.33	141.4	7513042.0
2012-08-28 16:00:00	SPY	ETF	141.415	141.489	141.34	141.39	5093815.0
2012-08-28 16:30:00	SPY	ETF	141.39	141.4684	141.36	141.38	173349.0
2012-08-28 17:00:00	SPY	ETF	141.37	141.51	141.37	141.51	53637.0
2012-08-28 17:30:00	SPY	ETF	141.5	141.53	141.44	141.47	32900.0
2012-08-28 18:00:00	SPY	ETF	141.46	141.57	141.45	141.57	46760.0
2012-08-28 18:30:00	SPY	ETF	141.55	141.57	141.55	141.56	9900.0
2012-08-28 19:00:00	SPY	ETF	141.53	141.54	141.52	141.54	3050.0
2012-08-28 19:30:00	SPY	ETF	141.52	141.55	141.51	141.53	7752.0
2012-08-28 06:00:00	QQQ	ETF	68.52	68.52	68.52	68.52	1000.0
2012-08-28 07:00:00	QQQ	ETF	68.44	68.46	68.42	68.46	12995.0
2012-08-28 07:30:00	QQQ	ETF	68.44	68.44	68.38	68.38	10300.0
2012-08-28 08:00:00	QQQ	ETF	68.42	68.42	68.33	68.35	71987.0
2012-08-28 08:30:00	QQQ	ETF	68.34	68.34	68.26	68.27	39799.0
2012-08-28 09:00:00	QQQ	ETF	68.31	68.42	68.29	68.33	172829.0
2012-08-28 09:30:00	QQQ	ETF	68.34	68.47	68.19	68.22	3669197.0
2012-08-28 10:00:00	QQQ	ETF	68.21	68.5	68.11	68.455	3694978.0
2012-08-28 10:30:00	QQQ	ETF	68.45	68.5199	68.27	68.3	2164200.0
2012-08-28 11:00:00	QQQ	ETF	68.31	68.36	68.22	68.33	1624426.0
2012-08-28 11:30:00	QQQ	ETF	68.33	68.491	68.29	68.48	1023448.0
2012-08-28 12:00:00	QQQ	ETF	68.49	68.585	68.485	68.53	1782117.0
2012-08-28 12:30:00	QQQ	ETF	68.53	68.53	68.46	68.5	1068656.0
2012-08-28 13:00:00	QQQ	ETF	68.51	68.52	68.4	68.425	937386.0
2012-08-28 13:30:00	QQQ	ETF	68.42	68.47	68.36	68.4	755886.0
2012-08-28 14:00:00	QQQ	ETF	68.4092	68.485	68.375	68.47	1257734.0
2012-08-28 14:30:00	QQQ	ETF	68.47	68.49	68.365	68.41	1118480.0
2012-08-28 15:00:00	QQQ	ETF	68.42	68.52	68.38	68.42	1390187.0
2012-08-28 15:30:00	QQQ	ETF	68.42	68.45	68.35	68.37	2444046.0
2012-08-28 16:00:00	QQQ	ETF	68.39	68.43	68.3365	68.41	1062687.0

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

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