PREVIEW / etf_30min / 2011-12-05

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-12-05.parquet
  size:    289 KB
  rows:    9,563

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
2011-12-05 04:00:00	SPY	ETF	125.72	126.1	125.72	125.91	10166.0
2011-12-05 04:30:00	SPY	ETF	125.89	126.37	125.89	126.37	22150.0
2011-12-05 05:00:00	SPY	ETF	126.26	126.3	126.2	126.3	84116.0
2011-12-05 05:30:00	SPY	ETF	126.3	126.3	126.2	126.26	2190.0
2011-12-05 06:00:00	SPY	ETF	126.2	126.2	125.95	126.15	144300.0
2011-12-05 06:30:00	SPY	ETF	126.11	126.24	126.09	126.12	62040.0
2011-12-05 07:00:00	SPY	ETF	126.1	126.56	126.06	126.46	1138798.0
2011-12-05 07:30:00	SPY	ETF	126.49	126.58	126.42	126.47	429899.0
2011-12-05 08:00:00	SPY	ETF	126.43	126.69	125.75	126.62	2290576.0
2011-12-05 08:30:00	SPY	ETF	126.61	126.75	126.53	126.69	923435.0
2011-12-05 09:00:00	SPY	ETF	126.7	126.88	126.41	126.83	2870347.0
2011-12-05 09:30:00	SPY	ETF	126.84	126.89	126.47	126.86	23329476.0
2011-12-05 10:00:00	SPY	ETF	126.85	127.1	126.54	126.995	22820788.0
2011-12-05 10:30:00	SPY	ETF	127.0	127.15	126.87	126.881	13035024.0
2011-12-05 11:00:00	SPY	ETF	126.88	127.0	126.72	126.85	9303571.0
2011-12-05 11:30:00	SPY	ETF	126.855	126.93	126.73	126.81	7396629.0
2011-12-05 12:00:00	SPY	ETF	126.81	127.0	126.76	126.86	6270472.0
2011-12-05 12:30:00	SPY	ETF	126.86	127.18	126.85	127.0589	7453839.0
2011-12-05 13:00:00	SPY	ETF	127.05	127.1	126.88	126.95	4632386.0
2011-12-05 13:30:00	SPY	ETF	126.945	127.06	126.17	126.29	23765304.0
2011-12-05 14:00:00	SPY	ETF	126.3	126.3	125.86	126.14	15027050.0
2011-12-05 14:30:00	SPY	ETF	126.15	126.34	125.95	126.28	8859210.0
2011-12-05 15:00:00	SPY	ETF	126.27	126.4	125.44	125.55	25337918.0
2011-12-05 15:30:00	SPY	ETF	125.55	126.25	125.47	126.21	28317100.0
2011-12-05 16:00:00	SPY	ETF	126.21	126.41	124.9109	125.93	14123457.0
2011-12-05 16:30:00	SPY	ETF	125.93	126.4316	125.78	125.84	1165523.0
2011-12-05 17:00:00	SPY	ETF	125.82	125.98	125.78	125.95	194105.0
2011-12-05 17:30:00	SPY	ETF	125.97	126.21	125.93	125.95	88512.0
2011-12-05 18:00:00	SPY	ETF	125.91	126.21	125.75	125.85	271408.0
2011-12-05 18:30:00	SPY	ETF	125.89	125.89	125.71	125.8	94050.0
2011-12-05 19:00:00	SPY	ETF	125.79	125.9	125.73	125.79	62524.0
2011-12-05 19:30:00	SPY	ETF	125.77	125.88	125.74	125.86	74564.0
2011-12-05 04:00:00	QQQ	ETF	56.96	57.18	56.96	57.1	6130.0
2011-12-05 05:00:00	QQQ	ETF	57.16	57.16	57.16	57.16	200.0
2011-12-05 05:30:00	QQQ	ETF	57.15	57.16	57.15	57.16	1200.0
2011-12-05 06:00:00	QQQ	ETF	57.15	57.15	57.06	57.06	2700.0
2011-12-05 06:30:00	QQQ	ETF	57.12	57.16	57.1	57.1	33100.0
2011-12-05 07:00:00	QQQ	ETF	57.1	57.32	57.1	57.28	49334.0
2011-12-05 07:30:00	QQQ	ETF	57.32	57.42	57.32	57.34	201600.0
2011-12-05 08:00:00	QQQ	ETF	57.32	57.39	57.2	57.39	155042.0
2011-12-05 08:30:00	QQQ	ETF	57.38	57.44	57.35	57.41	120531.0
2011-12-05 09:00:00	QQQ	ETF	57.42	57.5	57.32	57.47	472481.0
2011-12-05 09:30:00	QQQ	ETF	57.48	57.5	57.07	57.29	5337296.0
2011-12-05 10:00:00	QQQ	ETF	57.28	57.57	57.17	57.515	6189977.0
2011-12-05 10:30:00	QQQ	ETF	57.52	57.62	57.49	57.5	2828839.0
2011-12-05 11:00:00	QQQ	ETF	57.5	57.54	57.42	57.47	1566265.0
2011-12-05 11:30:00	QQQ	ETF	57.47	57.51	57.4	57.47	1018422.0
2011-12-05 12:00:00	QQQ	ETF	57.48	57.55	57.45	57.455	1070933.0
2011-12-05 12:30:00	QQQ	ETF	57.46	57.61	57.45	57.565	970298.0
2011-12-05 13:00:00	QQQ	ETF	57.56	57.59	57.48	57.5	758730.0

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

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