PREVIEW / etf_30min / 2012-07-17

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-07-17.parquet
  size:    279 KB
  rows:    9,241

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-07-17 04:00:00	SPY	ETF	135.93	136.04	135.93	136.0	1330.0
2012-07-17 04:30:00	SPY	ETF	136.0	136.01	135.95	135.95	1800.0
2012-07-17 05:00:00	SPY	ETF	135.89	136.01	135.85	136.01	2200.0
2012-07-17 05:30:00	SPY	ETF	135.91	135.91	135.84	135.84	6500.0
2012-07-17 06:00:00	SPY	ETF	135.8	135.8	135.8	135.8	175.0
2012-07-17 06:30:00	SPY	ETF	135.78	135.89	135.78	135.81	3150.0
2012-07-17 07:00:00	SPY	ETF	135.74	135.95	135.74	135.92	219625.0
2012-07-17 07:30:00	SPY	ETF	135.9	136.05	135.82	136.0	298651.0
2012-07-17 08:00:00	SPY	ETF	136.0	136.16	135.75	135.78	1027599.0
2012-07-17 08:30:00	SPY	ETF	135.84	135.98	135.8	135.89	1179292.0
2012-07-17 09:00:00	SPY	ETF	135.88	136.01	135.82	135.98	429183.0
2012-07-17 09:30:00	SPY	ETF	135.97	136.24	135.61	135.76	16757040.0
2012-07-17 10:00:00	SPY	ETF	135.76	135.79	135.05	135.29	18344239.0
2012-07-17 10:30:00	SPY	ETF	135.29	135.32	134.55	134.84	14715834.0
2012-07-17 11:00:00	SPY	ETF	134.84	135.23	134.79	135.07	6900535.0
2012-07-17 11:30:00	SPY	ETF	135.06	135.78	135.03	135.7613	10523521.0
2012-07-17 12:00:00	SPY	ETF	135.77	136.12	135.77	136.03	6781018.0
2012-07-17 12:30:00	SPY	ETF	136.03	136.18	135.91	135.925	5023148.0
2012-07-17 13:00:00	SPY	ETF	135.925	136.4	135.9	136.32	4953572.0
2012-07-17 13:30:00	SPY	ETF	136.31	136.53	136.31	136.33	5156204.0
2012-07-17 14:00:00	SPY	ETF	136.33	136.51	136.32	136.44	4596730.0
2012-07-17 14:30:00	SPY	ETF	136.44	136.64	136.36	136.501	4786262.0
2012-07-17 15:00:00	SPY	ETF	136.5	136.53	136.26	136.27	5849949.0
2012-07-17 15:30:00	SPY	ETF	136.27	136.53	136.13	136.39	16638507.0
2012-07-17 16:00:00	SPY	ETF	136.39	136.5	135.2915	136.46	8859899.0
2012-07-17 16:30:00	SPY	ETF	136.45	136.49	135.4457	136.36	1108290.0
2012-07-17 17:00:00	SPY	ETF	136.39	136.4	135.4457	136.38	783278.0
2012-07-17 17:30:00	SPY	ETF	136.4	136.41	136.37	136.38	12500.0
2012-07-17 18:00:00	SPY	ETF	136.38	136.38	136.33	136.34	30517.0
2012-07-17 18:30:00	SPY	ETF	136.37	136.39	136.34	136.34	6820.0
2012-07-17 19:00:00	SPY	ETF	136.36	136.36	136.34	136.36	3350.0
2012-07-17 19:30:00	SPY	ETF	136.37	136.42	136.36	136.42	245230.0
2012-07-17 04:00:00	QQQ	ETF	63.5	63.5	63.5	63.5	153.0
2012-07-17 05:30:00	QQQ	ETF	63.45	63.45	63.45	63.45	100.0
2012-07-17 06:00:00	QQQ	ETF	63.44	63.44	63.44	63.44	500.0
2012-07-17 06:30:00	QQQ	ETF	63.47	63.47	63.46	63.46	2400.0
2012-07-17 07:00:00	QQQ	ETF	63.47	63.53	63.45	63.5	81500.0
2012-07-17 07:30:00	QQQ	ETF	63.5	63.56	63.5	63.53	33474.0
2012-07-17 08:00:00	QQQ	ETF	63.53	63.54	63.45	63.46	951754.0
2012-07-17 08:30:00	QQQ	ETF	63.46	63.57	63.46	63.53	988550.0
2012-07-17 09:00:00	QQQ	ETF	63.53	63.6	63.53	63.59	38446.0
2012-07-17 09:30:00	QQQ	ETF	63.58	63.72	63.28	63.41	4771453.0
2012-07-17 10:00:00	QQQ	ETF	63.42	63.43	62.98	63.08	4255330.0
2012-07-17 10:30:00	QQQ	ETF	63.07	63.08	62.63	62.799	5294643.0
2012-07-17 11:00:00	QQQ	ETF	62.8	62.99	62.77	62.91	1579161.0
2012-07-17 11:30:00	QQQ	ETF	62.9	63.31	62.89	63.31	1624635.0
2012-07-17 12:00:00	QQQ	ETF	63.32	63.54	63.32	63.51	2030944.0
2012-07-17 12:30:00	QQQ	ETF	63.5	63.59	63.3699	63.37	1315843.0
2012-07-17 13:00:00	QQQ	ETF	63.37	63.63	63.35	63.57	1281019.0
2012-07-17 13:30:00	QQQ	ETF	63.57	63.66	63.52	63.53	1240723.0

> showing 50 of 9,241 rows — these rows as CSV

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