PREVIEW / etf_30min / 2013-02-27

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-02-27.parquet
  size:    305 KB
  rows:    10,208

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-27 04:00:00	SPY	ETF	149.68	149.68	149.57	149.6	2402.0
2013-02-27 04:30:00	SPY	ETF	149.59	149.7	149.47	149.64	28700.0
2013-02-27 05:00:00	SPY	ETF	149.64	149.77	149.61	149.64	26680.0
2013-02-27 05:30:00	SPY	ETF	149.67	149.79	149.62	149.63	12200.0
2013-02-27 06:00:00	SPY	ETF	149.68	149.78	149.66	149.74	36130.0
2013-02-27 06:30:00	SPY	ETF	149.77	149.84	149.77	149.84	9750.0
2013-02-27 07:00:00	SPY	ETF	149.83	149.93	149.8	149.83	91975.0
2013-02-27 07:30:00	SPY	ETF	149.82	150.1	149.81	150.08	124957.0
2013-02-27 08:00:00	SPY	ETF	150.08	150.08	149.63	149.68	751998.0
2013-02-27 08:30:00	SPY	ETF	149.69	149.94	149.69	149.75	809832.0
2013-02-27 09:00:00	SPY	ETF	149.73	149.91	149.69	149.89	823122.0
2013-02-27 09:30:00	SPY	ETF	149.89	150.47	149.76	150.35	13217930.0
2013-02-27 10:00:00	SPY	ETF	150.37	150.9	150.32	150.78	11577571.0
2013-02-27 10:30:00	SPY	ETF	150.775	151.08	150.72	150.85	8139553.0
2013-02-27 11:00:00	SPY	ETF	150.85	151.28	150.84	151.19	8229631.0
2013-02-27 11:30:00	SPY	ETF	151.19	151.36	151.09	151.25	10340375.0
2013-02-27 12:00:00	SPY	ETF	151.245	151.64	151.22	151.565	5833982.0
2013-02-27 12:30:00	SPY	ETF	151.575	151.76	151.42	151.5801	11058500.0
2013-02-27 13:00:00	SPY	ETF	151.58	151.62	151.44	151.542	4893080.0
2013-02-27 13:30:00	SPY	ETF	151.54	151.72	151.53	151.6	3366272.0
2013-02-27 14:00:00	SPY	ETF	151.601	152.04	151.57	151.9	6820623.0
2013-02-27 14:30:00	SPY	ETF	151.91	152.12	151.84	152.09	7461570.0
2013-02-27 15:00:00	SPY	ETF	152.099	152.33	151.97	152.131	8926355.0
2013-02-27 15:30:00	SPY	ETF	152.131	152.3	151.88	151.91	20011998.0
2013-02-27 16:00:00	SPY	ETF	151.91	152.09	150.28	151.97	8068113.0
2013-02-27 16:30:00	SPY	ETF	151.98	152.1	150.004	152.07	11506959.0
2013-02-27 17:00:00	SPY	ETF	152.05	152.08	151.97	152.02	1062109.0
2013-02-27 17:30:00	SPY	ETF	152.03	152.07	152.0	152.02	1072286.0
2013-02-27 18:00:00	SPY	ETF	152.02	152.09	151.95	151.98	82352.0
2013-02-27 18:30:00	SPY	ETF	151.97	152.07	151.96	152.04	16400.0
2013-02-27 19:00:00	SPY	ETF	152.04	152.05	151.95	151.98	63486.0
2013-02-27 19:30:00	SPY	ETF	151.96	152.08	151.95	152.08	32067.0
2013-02-27 04:00:00	QQQ	ETF	66.39	66.39	66.37	66.37	200.0
2013-02-27 04:30:00	QQQ	ETF	66.37	66.37	66.37	66.37	200.0
2013-02-27 05:30:00	QQQ	ETF	66.36	66.36	66.36	66.36	200.0
2013-02-27 06:30:00	QQQ	ETF	66.47	66.5	66.47	66.5	1100.0
2013-02-27 07:00:00	QQQ	ETF	66.5	66.51	66.5	66.51	8100.0
2013-02-27 07:30:00	QQQ	ETF	66.48	66.6	66.48	66.6	415.0
2013-02-27 08:00:00	QQQ	ETF	66.58	66.6	66.47	66.48	13950.0
2013-02-27 08:30:00	QQQ	ETF	66.56	66.56	66.49	66.52	10907.0
2013-02-27 09:00:00	QQQ	ETF	66.52	66.58	66.5	66.56	106762.0
2013-02-27 09:30:00	QQQ	ETF	66.57	66.75	66.47	66.68	2906616.0
2013-02-27 10:00:00	QQQ	ETF	66.68	66.95	66.61	66.909	2874982.0
2013-02-27 10:30:00	QQQ	ETF	66.91	67.15	66.89	67.02	2692495.0
2013-02-27 11:00:00	QQQ	ETF	67.02	67.335	67.01	67.2601	3016435.0
2013-02-27 11:30:00	QQQ	ETF	67.26	67.3	67.17	67.23	1214496.0
2013-02-27 12:00:00	QQQ	ETF	67.22	67.485	67.19	67.38	2387779.0
2013-02-27 12:30:00	QQQ	ETF	67.38	67.48	67.18	67.3	3647373.0
2013-02-27 13:00:00	QQQ	ETF	67.3	67.33	67.17	67.27	1210492.0
2013-02-27 13:30:00	QQQ	ETF	67.28	67.38	67.24	67.27	610944.0

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

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