PREVIEW / etf_30min / 2013-02-06

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-02-06.parquet
  size:    309 KB
  rows:    10,502

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-06 04:00:00	SPY	ETF	151.29	151.29	151.29	151.29	100.0
2013-02-06 04:30:00	SPY	ETF	151.26	151.26	151.24	151.24	2600.0
2013-02-06 05:00:00	SPY	ETF	151.19	151.25	151.13	151.13	75362.0
2013-02-06 05:30:00	SPY	ETF	151.02	151.08	151.02	151.08	36600.0
2013-02-06 06:00:00	SPY	ETF	151.09	151.15	151.07	151.14	19127.0
2013-02-06 06:30:00	SPY	ETF	151.2	151.2	151.0	151.05	43278.0
2013-02-06 07:00:00	SPY	ETF	151.09	151.13	150.84	150.86	822324.0
2013-02-06 07:30:00	SPY	ETF	150.86	150.95	150.7	150.7	781753.0
2013-02-06 08:00:00	SPY	ETF	150.73	151.02	150.45	150.61	1047679.0
2013-02-06 08:30:00	SPY	ETF	150.61	150.62	150.31	150.35	1057041.0
2013-02-06 09:00:00	SPY	ETF	150.36	150.54	150.35	150.5	683253.0
2013-02-06 09:30:00	SPY	ETF	150.52	150.9	150.41	150.83	17845271.0
2013-02-06 10:00:00	SPY	ETF	150.82	150.93	150.66	150.86	9124215.0
2013-02-06 10:30:00	SPY	ETF	150.87	151.01	150.64	150.92	7280670.0
2013-02-06 11:00:00	SPY	ETF	150.92	151.18	150.92	151.12	6611964.0
2013-02-06 11:30:00	SPY	ETF	151.105	151.11	150.96	151.098	3972873.0
2013-02-06 12:00:00	SPY	ETF	151.1	151.21	151.03	151.16	4789791.0
2013-02-06 12:30:00	SPY	ETF	151.14	151.26	150.96	150.96	18785529.0
2013-02-06 13:00:00	SPY	ETF	150.97	150.99	150.66	150.675	6728713.0
2013-02-06 13:30:00	SPY	ETF	150.675	150.79	150.57	150.66	4643373.0
2013-02-06 14:00:00	SPY	ETF	150.66	150.87	150.62	150.75	4375761.0
2013-02-06 14:30:00	SPY	ETF	150.74	150.95	150.72	150.94	3511023.0
2013-02-06 15:00:00	SPY	ETF	150.94	151.09	150.87	151.08	7001586.0
2013-02-06 15:30:00	SPY	ETF	151.07	151.18	150.96	151.17	18660303.0
2013-02-06 16:00:00	SPY	ETF	151.16	151.2015	150.9032	151.12	11920527.0
2013-02-06 16:30:00	SPY	ETF	151.12	151.1985	151.07	151.15	8004597.0
2013-02-06 17:00:00	SPY	ETF	151.15	151.15	151.05	151.05	103473.0
2013-02-06 17:30:00	SPY	ETF	151.05	151.08	151.03	151.07	54045.0
2013-02-06 18:00:00	SPY	ETF	151.07	151.11	151.04	151.09	103168.0
2013-02-06 18:30:00	SPY	ETF	151.06	151.1	151.03	151.03	1797.0
2013-02-06 19:00:00	SPY	ETF	151.02	151.05	151.02	151.04	3250.0
2013-02-06 19:30:00	SPY	ETF	151.03	151.1	151.02	151.1	17666.0
2013-02-06 04:00:00	QQQ	ETF	67.58	67.58	67.58	67.58	155.0
2013-02-06 05:30:00	QQQ	ETF	67.41	67.41	67.41	67.41	4000.0
2013-02-06 07:00:00	QQQ	ETF	67.43	67.43	67.3	67.3	73000.0
2013-02-06 07:30:00	QQQ	ETF	67.3	67.3	67.21	67.21	95548.0
2013-02-06 08:00:00	QQQ	ETF	67.3	67.41	67.14	67.19	1225987.0
2013-02-06 08:30:00	QQQ	ETF	67.18	67.23	67.09	67.18	115295.0
2013-02-06 09:00:00	QQQ	ETF	67.19	67.22	67.17	67.2	189553.0
2013-02-06 09:30:00	QQQ	ETF	67.21	67.43	67.17	67.38	7442615.0
2013-02-06 10:00:00	QQQ	ETF	67.37	67.419	67.22	67.26	3745774.0
2013-02-06 10:30:00	QQQ	ETF	67.27	67.41	67.1	67.375	3295329.0
2013-02-06 11:00:00	QQQ	ETF	67.37	67.55	67.37	67.49	2532717.0
2013-02-06 11:30:00	QQQ	ETF	67.48	67.5	67.37	67.46	1566509.0
2013-02-06 12:00:00	QQQ	ETF	67.46	67.48	67.37	67.44	794141.0
2013-02-06 12:30:00	QQQ	ETF	67.4348	67.48	67.3	67.31	2074430.0
2013-02-06 13:00:00	QQQ	ETF	67.31	67.32	67.08	67.11	2755553.0
2013-02-06 13:30:00	QQQ	ETF	67.11	67.19	67.04	67.13	1128844.0
2013-02-06 14:00:00	QQQ	ETF	67.13	67.2	67.07	67.08	2789937.0
2013-02-06 14:30:00	QQQ	ETF	67.08	67.19	67.06	67.18	1183156.0

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

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