PREVIEW / etf_30min / 2012-08-29

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-29.parquet
  size:    268 KB
  rows:    9,047

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-29 04:00:00	SPY	ETF	141.31	141.31	141.3	141.3	200.0
2012-08-29 04:30:00	SPY	ETF	141.35	141.35	141.35	141.35	200.0
2012-08-29 05:30:00	SPY	ETF	141.3	141.3	141.27	141.27	2500.0
2012-08-29 06:00:00	SPY	ETF	141.28	141.41	141.28	141.4	7600.0
2012-08-29 06:30:00	SPY	ETF	141.33	141.37	141.33	141.35	2150.0
2012-08-29 07:00:00	SPY	ETF	141.37	141.45	141.34	141.36	14593.0
2012-08-29 07:30:00	SPY	ETF	141.36	141.38	141.29	141.34	72605.0
2012-08-29 08:00:00	SPY	ETF	141.33	141.54	141.33	141.45	161854.0
2012-08-29 08:30:00	SPY	ETF	141.51	141.72	141.43	141.63	384816.0
2012-08-29 09:00:00	SPY	ETF	141.63	141.65	141.51	141.53	406572.0
2012-08-29 09:30:00	SPY	ETF	141.52	141.68	141.32	141.405	8308760.0
2012-08-29 10:00:00	SPY	ETF	141.41	141.62	141.31	141.54	8203803.0
2012-08-29 10:30:00	SPY	ETF	141.55	141.58	141.12	141.21	6191675.0
2012-08-29 11:00:00	SPY	ETF	141.2	141.32	141.18	141.28	4773910.0
2012-08-29 11:30:00	SPY	ETF	141.29	141.58	141.28	141.501	4387628.0
2012-08-29 12:00:00	SPY	ETF	141.51	141.555	141.45	141.53	1816483.0
2012-08-29 12:30:00	SPY	ETF	141.53	141.65	141.47	141.59	2196940.0
2012-08-29 13:00:00	SPY	ETF	141.59	141.79	141.58	141.73	3298523.0
2012-08-29 13:30:00	SPY	ETF	141.73	141.89	141.69	141.81	5032579.0
2012-08-29 14:00:00	SPY	ETF	141.81	141.82	141.7	141.81	2801708.0
2012-08-29 14:30:00	SPY	ETF	141.81	141.82	141.62	141.63	3436401.0
2012-08-29 15:00:00	SPY	ETF	141.64	141.73	141.56	141.71	3229866.0
2012-08-29 15:30:00	SPY	ETF	141.71	141.73	141.48	141.52	7382507.0
2012-08-29 16:00:00	SPY	ETF	141.5	141.5736	141.2	141.38	2378377.0
2012-08-29 16:30:00	SPY	ETF	141.37	141.37	141.3	141.33	143414.0
2012-08-29 17:00:00	SPY	ETF	141.33	141.37	141.33	141.35	19384.0
2012-08-29 17:30:00	SPY	ETF	141.35	141.4	141.35	141.4	36270.0
2012-08-29 18:00:00	SPY	ETF	141.37	141.39	141.36	141.39	15850.0
2012-08-29 18:30:00	SPY	ETF	141.37	141.37	141.33	141.34	5964.0
2012-08-29 19:00:00	SPY	ETF	141.34	141.35	141.3	141.35	3800.0
2012-08-29 19:30:00	SPY	ETF	141.36	141.36	141.31	141.34	10800.0
2012-08-29 04:30:00	QQQ	ETF	68.3	68.3	68.3	68.3	400.0
2012-08-29 06:30:00	QQQ	ETF	68.33	68.33	68.33	68.33	2000.0
2012-08-29 07:00:00	QQQ	ETF	68.34	68.35	68.31	68.33	4000.0
2012-08-29 07:30:00	QQQ	ETF	68.33	68.33	68.28	68.28	1700.0
2012-08-29 08:00:00	QQQ	ETF	68.33	68.39	68.33	68.39	46015.0
2012-08-29 08:30:00	QQQ	ETF	68.4	68.52	68.37	68.47	72013.0
2012-08-29 09:00:00	QQQ	ETF	68.46	68.47	68.4	68.42	38284.0
2012-08-29 09:30:00	QQQ	ETF	68.41	68.56	68.38	68.39	2200509.0
2012-08-29 10:00:00	QQQ	ETF	68.39	68.51	68.37	68.4081	2262861.0
2012-08-29 10:30:00	QQQ	ETF	68.4	68.42	68.11	68.15	1701058.0
2012-08-29 11:00:00	QQQ	ETF	68.15	68.26	68.15	68.25	1434395.0
2012-08-29 11:30:00	QQQ	ETF	68.25	68.38	68.25	68.32	1002989.0
2012-08-29 12:00:00	QQQ	ETF	68.33	68.35	68.3	68.3401	364256.0
2012-08-29 12:30:00	QQQ	ETF	68.35	68.43	68.32	68.39	616043.0
2012-08-29 13:00:00	QQQ	ETF	68.385	68.51	68.38	68.48	1024411.0
2012-08-29 13:30:00	QQQ	ETF	68.4717	68.57	68.455	68.55	1920600.0
2012-08-29 14:00:00	QQQ	ETF	68.55	68.56	68.48	68.54	593804.0
2012-08-29 14:30:00	QQQ	ETF	68.54	68.54	68.44	68.46	917560.0
2012-08-29 15:00:00	QQQ	ETF	68.46	68.49	68.41	68.47	705590.0

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

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