PREVIEW / etf_30min / 2013-04-25

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-25.parquet
  size:    315 KB
  rows:    10,634

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-04-25 04:00:00	SPY	ETF	157.94	157.96	157.89	157.96	500.0
2013-04-25 04:30:00	SPY	ETF	157.99	158.02	157.94	157.98	600.0
2013-04-25 05:00:00	SPY	ETF	158.1	158.19	158.1	158.17	29350.0
2013-04-25 05:30:00	SPY	ETF	158.14	158.3	158.14	158.17	50800.0
2013-04-25 06:00:00	SPY	ETF	158.2	158.3	158.2	158.25	17539.0
2013-04-25 06:30:00	SPY	ETF	158.25	158.33	158.22	158.32	9200.0
2013-04-25 07:00:00	SPY	ETF	158.3	158.54	158.27	158.48	216404.0
2013-04-25 07:30:00	SPY	ETF	158.46	158.54	158.42	158.44	306791.0
2013-04-25 08:00:00	SPY	ETF	158.44	158.65	158.08	158.53	610548.0
2013-04-25 08:30:00	SPY	ETF	158.57	158.72	158.45	158.53	980029.0
2013-04-25 09:00:00	SPY	ETF	158.51	158.55	158.32	158.32	859915.0
2013-04-25 09:30:00	SPY	ETF	158.34	158.49	158.1	158.39	15271309.0
2013-04-25 10:00:00	SPY	ETF	158.39	158.9	158.34	158.82	13924966.0
2013-04-25 10:30:00	SPY	ETF	158.82	159.03	158.77	158.9599	11190314.0
2013-04-25 11:00:00	SPY	ETF	158.95	159.04	158.84	158.86	7889482.0
2013-04-25 11:30:00	SPY	ETF	158.86	159.02	158.77	158.8	6165271.0
2013-04-25 12:00:00	SPY	ETF	158.81	158.91	158.77	158.809	4917498.0
2013-04-25 12:30:00	SPY	ETF	158.81	159.0	158.8	158.99	2953473.0
2013-04-25 13:00:00	SPY	ETF	158.99	159.17	158.9	159.1312	4828813.0
2013-04-25 13:30:00	SPY	ETF	159.13	159.24	158.9392	159.181	5968848.0
2013-04-25 14:00:00	SPY	ETF	159.185	159.27	159.05	159.06	4429275.0
2013-04-25 14:30:00	SPY	ETF	159.055	159.08	158.64	158.74	8367792.0
2013-04-25 15:00:00	SPY	ETF	158.74	158.745	158.27	158.42	13457388.0
2013-04-25 15:30:00	SPY	ETF	158.42	158.7	158.325	158.55	14481081.0
2013-04-25 16:00:00	SPY	ETF	158.54	158.8117	158.3821	158.65	9030961.0
2013-04-25 16:30:00	SPY	ETF	158.65	158.65	158.54	158.55	336058.0
2013-04-25 17:00:00	SPY	ETF	158.54	158.63	158.52	158.63	716235.0
2013-04-25 17:30:00	SPY	ETF	158.6	158.64	158.56	158.6	580580.0
2013-04-25 18:00:00	SPY	ETF	158.59	158.65	158.56	158.59	73000.0
2013-04-25 18:30:00	SPY	ETF	158.59	158.65	158.58	158.58	16514.0
2013-04-25 19:00:00	SPY	ETF	158.58	158.58	158.52	158.52	36159.0
2013-04-25 19:30:00	SPY	ETF	158.53	158.55	158.42	158.47	86487.0
2013-04-25 04:00:00	QQQ	ETF	69.38	69.38	69.38	69.38	100.0
2013-04-25 04:30:00	QQQ	ETF	69.42	69.42	69.42	69.42	200.0
2013-04-25 05:00:00	QQQ	ETF	69.47	69.47	69.47	69.47	2000.0
2013-04-25 05:30:00	QQQ	ETF	69.57	69.57	69.53	69.53	6400.0
2013-04-25 06:00:00	QQQ	ETF	69.58	69.58	69.53	69.53	1600.0
2013-04-25 06:30:00	QQQ	ETF	69.54	69.58	69.54	69.58	28870.0
2013-04-25 07:00:00	QQQ	ETF	69.58	69.65	69.56	69.62	45840.0
2013-04-25 07:30:00	QQQ	ETF	69.59	69.65	69.59	69.6	15800.0
2013-04-25 08:00:00	QQQ	ETF	69.6	69.75	69.58	69.72	100122.0
2013-04-25 08:30:00	QQQ	ETF	69.7	69.8	69.67	69.72	133346.0
2013-04-25 09:00:00	QQQ	ETF	69.71	69.71	69.6	69.63	381180.0
2013-04-25 09:30:00	QQQ	ETF	69.63	69.89	69.59	69.78	3823516.0
2013-04-25 10:00:00	QQQ	ETF	69.79	70.0	69.74	69.94	3378799.0
2013-04-25 10:30:00	QQQ	ETF	69.95	70.05	69.87	69.96	1817941.0
2013-04-25 11:00:00	QQQ	ETF	69.96	70.02	69.91	69.95	1233559.0
2013-04-25 11:30:00	QQQ	ETF	69.95	70.025	69.83	69.87	1009569.0
2013-04-25 12:00:00	QQQ	ETF	69.869	69.93	69.835	69.89	1002090.0
2013-04-25 12:30:00	QQQ	ETF	69.89	69.96	69.88	69.93	836906.0

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

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