PREVIEW / etf_30min / 2012-04-26

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-04-26.parquet
  size:    285 KB
  rows:    9,503

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.42	139.54	5628.0
2012-04-26 04:30:00	SPY	ETF	139.65	139.65	139.4	139.4	600.0
2012-04-26 05:00:00	SPY	ETF	139.39	139.43	139.37	139.43	1300.0
2012-04-26 05:30:00	SPY	ETF	139.19	139.19	139.06	139.12	2900.0
2012-04-26 06:00:00	SPY	ETF	139.08	139.12	138.98	139.03	27580.0
2012-04-26 06:30:00	SPY	ETF	138.96	139.07	138.89	139.07	27100.0
2012-04-26 07:00:00	SPY	ETF	139.07	139.09	138.98	139.04	67832.0
2012-04-26 07:30:00	SPY	ETF	139.01	139.19	139.01	139.19	106029.0
2012-04-26 08:00:00	SPY	ETF	139.19	139.24	138.92	139.0	771774.0
2012-04-26 08:30:00	SPY	ETF	138.9	139.07	138.62	138.86	1661969.0
2012-04-26 09:00:00	SPY	ETF	138.85	138.94	138.75	138.9	1894471.0
2012-04-26 09:30:00	SPY	ETF	138.89	139.19	138.81	139.13	14720415.0
2012-04-26 10:00:00	SPY	ETF	139.13	139.44	139.059	139.209	13295856.0
2012-04-26 10:30:00	SPY	ETF	139.21	139.39	139.07	139.151	9801771.0
2012-04-26 11:00:00	SPY	ETF	139.15	139.44	139.12	139.43	6395992.0
2012-04-26 11:30:00	SPY	ETF	139.42	139.48	139.34	139.39	5303300.0
2012-04-26 12:00:00	SPY	ETF	139.39	139.46	139.32	139.37	3798642.0
2012-04-26 12:30:00	SPY	ETF	139.37	139.43	139.26	139.42	3765135.0
2012-04-26 13:00:00	SPY	ETF	139.415	139.69	139.37	139.65	5504785.0
2012-04-26 13:30:00	SPY	ETF	139.65	139.98	139.64	139.9435	8033671.0
2012-04-26 14:00:00	SPY	ETF	139.95	140.2	139.94	140.16	7041261.0
2012-04-26 14:30:00	SPY	ETF	140.15	140.23	140.072	140.16	6058356.0
2012-04-26 15:00:00	SPY	ETF	140.17	140.32	140.11	140.25	9008852.0
2012-04-26 15:30:00	SPY	ETF	140.25	140.26	140.02	140.14	21420546.0
2012-04-26 16:00:00	SPY	ETF	140.15	140.25	139.1662	140.19	6857209.0
2012-04-26 16:30:00	SPY	ETF	140.19	140.41	139.98	140.01	5659245.0
2012-04-26 17:00:00	SPY	ETF	140.01	140.01	139.59	139.65	1444194.0
2012-04-26 17:30:00	SPY	ETF	139.65	139.66	139.56	139.65	141164.0
2012-04-26 18:00:00	SPY	ETF	139.62	139.64	139.46	139.48	254285.0
2012-04-26 18:30:00	SPY	ETF	139.49	139.59	139.48	139.57	146655.0
2012-04-26 19:00:00	SPY	ETF	139.55	139.67	139.55	139.62	134141.0
2012-04-26 19:30:00	SPY	ETF	139.63	139.64	139.5	139.55	310040.0
2012-04-26 04:00:00	QQQ	ETF	66.6	66.62	66.56	66.56	400.0
2012-04-26 04:30:00	QQQ	ETF	66.62	66.62	66.52	66.52	4800.0
2012-04-26 05:00:00	QQQ	ETF	66.51	66.51	66.46	66.46	300.0
2012-04-26 05:30:00	QQQ	ETF	66.36	66.36	66.36	66.36	4000.0
2012-04-26 06:00:00	QQQ	ETF	66.33	66.33	66.31	66.31	5400.0
2012-04-26 06:30:00	QQQ	ETF	66.28	66.28	66.28	66.28	2000.0
2012-04-26 07:00:00	QQQ	ETF	66.34	66.34	66.31	66.33	64000.0
2012-04-26 07:30:00	QQQ	ETF	66.33	66.39	66.33	66.39	142656.0
2012-04-26 08:00:00	QQQ	ETF	66.41	66.47	66.33	66.33	244395.0
2012-04-26 08:30:00	QQQ	ETF	66.28	66.34	66.21	66.34	532462.0
2012-04-26 09:00:00	QQQ	ETF	66.33	66.45	66.29	66.43	569654.0
2012-04-26 09:30:00	QQQ	ETF	66.42	66.68	66.37	66.48	8184483.0
2012-04-26 10:00:00	QQQ	ETF	66.49	66.66	66.48	66.56	3736674.0
2012-04-26 10:30:00	QQQ	ETF	66.55	66.6013	66.37	66.41	2940235.0
2012-04-26 11:00:00	QQQ	ETF	66.41	66.55	66.35	66.55	3008180.0
2012-04-26 11:30:00	QQQ	ETF	66.54	66.56	66.45	66.47	1451724.0
2012-04-26 12:00:00	QQQ	ETF	66.47	66.49	66.41	66.4301	1106035.0
2012-04-26 12:30:00	QQQ	ETF	66.43	66.46	66.4	66.445	691605.0

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

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