PREVIEW / etf_30min / 2013-02-25

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-02-25.parquet
  size:    336 KB
  rows:    11,051

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
2013-02-25 04:00:00	SPY	ETF	152.0	152.06	152.0	152.06	19150.0
2013-02-25 04:30:00	SPY	ETF	152.06	152.14	152.06	152.14	3200.0
2013-02-25 05:00:00	SPY	ETF	152.11	152.33	152.11	152.31	27557.0
2013-02-25 05:30:00	SPY	ETF	152.32	152.51	152.31	152.49	11582.0
2013-02-25 06:00:00	SPY	ETF	152.39	152.55	152.39	152.46	28600.0
2013-02-25 06:30:00	SPY	ETF	152.48	152.65	152.48	152.52	118500.0
2013-02-25 07:00:00	SPY	ETF	152.51	152.77	152.49	152.64	197379.0
2013-02-25 07:30:00	SPY	ETF	152.65	152.73	152.59	152.66	202694.0
2013-02-25 08:00:00	SPY	ETF	152.64	152.7088	152.5	152.6	715139.0
2013-02-25 08:30:00	SPY	ETF	152.59	152.59	152.45	152.56	1248412.0
2013-02-25 09:00:00	SPY	ETF	152.56	152.76	152.55	152.62	1333008.0
2013-02-25 09:30:00	SPY	ETF	152.63	152.69	152.36	152.615	12992098.0
2013-02-25 10:00:00	SPY	ETF	152.61	152.86	152.0	152.03	15611864.0
2013-02-25 10:30:00	SPY	ETF	152.02	152.28	151.63	151.87	18871644.0
2013-02-25 11:00:00	SPY	ETF	151.86	152.14	151.65	151.97	15286742.0
2013-02-25 11:30:00	SPY	ETF	151.98	152.08	151.06	151.18	13784942.0
2013-02-25 12:00:00	SPY	ETF	151.175	151.41	151.07	151.36	9861177.0
2013-02-25 12:30:00	SPY	ETF	151.36	151.65	151.21	151.6	5701054.0
2013-02-25 13:00:00	SPY	ETF	151.61	151.67	151.29	151.32	4553142.0
2013-02-25 13:30:00	SPY	ETF	151.32	151.325	150.63	150.73	10876759.0
2013-02-25 14:00:00	SPY	ETF	150.72	150.89	150.4	150.8	10903197.0
2013-02-25 14:30:00	SPY	ETF	150.7913	150.94	150.56	150.79	7731111.0
2013-02-25 15:00:00	SPY	ETF	150.79	150.89	150.0	150.09	11790593.0
2013-02-25 15:30:00	SPY	ETF	150.095	150.18	149.0	149.01	46082918.0
2013-02-25 16:00:00	SPY	ETF	149.01	152.7136	148.88	148.93	32758891.0
2013-02-25 16:30:00	SPY	ETF	148.93	152.72	148.61	148.77	6714730.0
2013-02-25 17:00:00	SPY	ETF	148.76	151.8065	148.69	148.83	7181305.0
2013-02-25 17:30:00	SPY	ETF	148.83	148.96	148.83	148.95	86846.0
2013-02-25 18:00:00	SPY	ETF	148.97	151.8065	148.96	149.18	6223168.0
2013-02-25 18:30:00	SPY	ETF	149.18	149.3	149.14	149.21	137446.0
2013-02-25 19:00:00	SPY	ETF	149.22	149.4	149.22	149.37	77353.0
2013-02-25 19:30:00	SPY	ETF	149.36	149.44	149.35	149.44	87459.0
2013-02-25 05:00:00	QQQ	ETF	67.4	67.4	67.4	67.4	100.0
2013-02-25 05:30:00	QQQ	ETF	67.49	67.49	67.49	67.49	840.0
2013-02-25 06:00:00	QQQ	ETF	67.5	67.5	67.49	67.49	1100.0
2013-02-25 06:30:00	QQQ	ETF	67.56	67.56	67.51	67.51	1700.0
2013-02-25 07:00:00	QQQ	ETF	67.51	67.65	67.51	67.63	16700.0
2013-02-25 07:30:00	QQQ	ETF	67.63	67.65	67.61	67.63	11165.0
2013-02-25 08:00:00	QQQ	ETF	67.62	67.64	67.53	67.57	37873.0
2013-02-25 08:30:00	QQQ	ETF	67.56	67.57	67.53	67.54	36164.0
2013-02-25 09:00:00	QQQ	ETF	67.56	67.61	67.53	67.6	175086.0
2013-02-25 09:30:00	QQQ	ETF	67.6	67.74	67.53	67.7	5098557.0
2013-02-25 10:00:00	QQQ	ETF	67.7	67.81	67.49	67.5	3998140.0
2013-02-25 10:30:00	QQQ	ETF	67.51	67.61	67.29	67.38	3314363.0
2013-02-25 11:00:00	QQQ	ETF	67.3799	67.49	67.29	67.43	2742965.0
2013-02-25 11:30:00	QQQ	ETF	67.425	67.47	67.0	67.07	2667672.0
2013-02-25 12:00:00	QQQ	ETF	67.07	67.22	67.02	67.19	1661983.0
2013-02-25 12:30:00	QQQ	ETF	67.19	67.36	67.1	67.31	1432122.0
2013-02-25 13:00:00	QQQ	ETF	67.31	67.36	67.18	67.21	899856.0
2013-02-25 13:30:00	QQQ	ETF	67.22	67.22	66.93	67.0	1833198.0

> showing 50 of 11,051 rows — these rows as CSV

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