PREVIEW / etf_30min / 2012-02-21

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-02-21.parquet
  size:    301 KB
  rows:    10,060

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-02-21 04:00:00	SPY	ETF	136.79	137.1	136.78	137.1	2686.0
2012-02-21 04:30:00	SPY	ETF	137.03	137.03	136.8	136.8	9100.0
2012-02-21 05:00:00	SPY	ETF	136.86	136.86	136.66	136.73	21000.0
2012-02-21 05:30:00	SPY	ETF	136.79	136.86	136.69	136.71	18500.0
2012-02-21 06:00:00	SPY	ETF	136.65	136.73	136.6	136.69	86545.0
2012-02-21 06:30:00	SPY	ETF	136.71	136.71	136.53	136.61	63650.0
2012-02-21 07:00:00	SPY	ETF	136.59	136.76	136.54	136.6	150421.0
2012-02-21 07:30:00	SPY	ETF	136.65	136.8	136.65	136.66	79125.0
2012-02-21 08:00:00	SPY	ETF	136.65	136.7	136.5	136.67	1939335.0
2012-02-21 08:30:00	SPY	ETF	136.67	137.3	136.61	136.79	662683.0
2012-02-21 09:00:00	SPY	ETF	136.79	136.89	136.72	136.74	841275.0
2012-02-21 09:30:00	SPY	ETF	136.73	136.82	136.35	136.43	16233101.0
2012-02-21 10:00:00	SPY	ETF	136.4287	136.63	136.37	136.6	10102686.0
2012-02-21 10:30:00	SPY	ETF	136.6	136.95	136.59	136.93	9483111.0
2012-02-21 11:00:00	SPY	ETF	136.939	136.97	136.85	136.93	5202371.0
2012-02-21 11:30:00	SPY	ETF	136.9285	136.93	136.78	136.82	4538734.0
2012-02-21 12:00:00	SPY	ETF	136.82	137.05	136.81	136.88	7694166.0
2012-02-21 12:30:00	SPY	ETF	136.89	136.91	136.82	136.83	3318788.0
2012-02-21 13:00:00	SPY	ETF	136.82	136.92	136.78	136.895	7353751.0
2012-02-21 13:30:00	SPY	ETF	136.9	136.93	136.64	136.69	5687355.0
2012-02-21 14:00:00	SPY	ETF	136.7	136.73	136.41	136.49	6691330.0
2012-02-21 14:30:00	SPY	ETF	136.49	136.5	136.05	136.19	8751938.0
2012-02-21 15:00:00	SPY	ETF	136.18	136.32	136.07	136.194	9039008.0
2012-02-21 15:30:00	SPY	ETF	136.19	136.48	136.06	136.47	18790259.0
2012-02-21 16:00:00	SPY	ETF	136.48	136.52	136.3736	136.47	7468523.0
2012-02-21 16:30:00	SPY	ETF	136.45	136.57	136.37	136.53	4468061.0
2012-02-21 17:00:00	SPY	ETF	136.53	136.54	136.48	136.52	28282.0
2012-02-21 17:30:00	SPY	ETF	136.51	136.53	136.4	136.51	47087.0
2012-02-21 18:00:00	SPY	ETF	136.53	136.56	136.51	136.55	32663.0
2012-02-21 18:30:00	SPY	ETF	136.54	136.55	136.42	136.45	61894.0
2012-02-21 19:00:00	SPY	ETF	136.43	136.46	136.39	136.4	25870.0
2012-02-21 19:30:00	SPY	ETF	136.41	136.45	136.38	136.41	25876.0
2012-02-21 04:00:00	QQQ	ETF	63.5	63.5	63.5	63.5	100.0
2012-02-21 05:00:00	QQQ	ETF	63.46	63.48	63.44	63.48	3600.0
2012-02-21 05:30:00	QQQ	ETF	63.5	63.55	63.45	63.45	20300.0
2012-02-21 06:00:00	QQQ	ETF	63.4	63.45	63.4	63.42	2600.0
2012-02-21 06:30:00	QQQ	ETF	63.45	63.45	63.41	63.41	1300.0
2012-02-21 07:00:00	QQQ	ETF	63.43	63.48	63.4	63.44	40000.0
2012-02-21 07:30:00	QQQ	ETF	63.47	63.49	63.44	63.44	62800.0
2012-02-21 08:00:00	QQQ	ETF	63.45	63.5	63.36	63.47	103660.0
2012-02-21 08:30:00	QQQ	ETF	63.46	63.51	63.44	63.51	86958.0
2012-02-21 09:00:00	QQQ	ETF	63.52	63.55	63.49	63.51	414775.0
2012-02-21 09:30:00	QQQ	ETF	63.51	63.7	63.42	63.49	5144551.0
2012-02-21 10:00:00	QQQ	ETF	63.5	63.64	63.49	63.62	2628392.0
2012-02-21 10:30:00	QQQ	ETF	63.62	63.82	63.611	63.82	2950999.0
2012-02-21 11:00:00	QQQ	ETF	63.8186	63.83	63.77	63.8	1630460.0
2012-02-21 11:30:00	QQQ	ETF	63.8	63.82	63.77	63.806	1865757.0
2012-02-21 12:00:00	QQQ	ETF	63.81	63.89	63.65	63.7	3460859.0
2012-02-21 12:30:00	QQQ	ETF	63.696	63.71	63.61	63.63	1428045.0
2012-02-21 13:00:00	QQQ	ETF	63.63	63.68	63.58	63.67	1177361.0

> showing 50 of 10,060 rows — these rows as CSV

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