PREVIEW / etf_30min / 2012-06-26

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-06-26.parquet
  size:    282 KB
  rows:    9,452

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-06-26 04:00:00	SPY	ETF	131.67	131.81	131.67	131.71	1950.0
2012-06-26 04:30:00	SPY	ETF	131.63	131.63	131.44	131.47	2656.0
2012-06-26 05:00:00	SPY	ETF	131.4	131.4	131.3	131.3	200.0
2012-06-26 05:30:00	SPY	ETF	131.45	131.7	131.45	131.7	14200.0
2012-06-26 06:00:00	SPY	ETF	131.7	131.75	131.6	131.71	19565.0
2012-06-26 06:30:00	SPY	ETF	131.6	131.65	131.52	131.64	19960.0
2012-06-26 07:00:00	SPY	ETF	131.62	131.7	131.57	131.61	33394.0
2012-06-26 07:30:00	SPY	ETF	131.58	131.62	131.26	131.37	232121.0
2012-06-26 08:00:00	SPY	ETF	131.38	131.45	131.23	131.25	320900.0
2012-06-26 08:30:00	SPY	ETF	131.27	131.51	131.26	131.46	446657.0
2012-06-26 09:00:00	SPY	ETF	131.48	131.72	131.4	131.69	2278297.0
2012-06-26 09:30:00	SPY	ETF	131.7	131.97	131.56	131.67	13277910.0
2012-06-26 10:00:00	SPY	ETF	131.67	131.96	131.34	131.37	13853819.0
2012-06-26 10:30:00	SPY	ETF	131.37	131.52	131.14	131.38	10701516.0
2012-06-26 11:00:00	SPY	ETF	131.37	131.65	130.93	131.27	17297214.0
2012-06-26 11:30:00	SPY	ETF	131.27	131.72	131.25	131.59	6425282.0
2012-06-26 12:00:00	SPY	ETF	131.6	131.87	131.595	131.7299	10475713.0
2012-06-26 12:30:00	SPY	ETF	131.725	132.06	131.72	131.86	7331116.0
2012-06-26 13:00:00	SPY	ETF	131.86	131.93	131.78	131.8	3314194.0
2012-06-26 13:30:00	SPY	ETF	131.8	131.98	131.64	131.88	4698575.0
2012-06-26 14:00:00	SPY	ETF	131.88	132.38	131.88	132.3	9886154.0
2012-06-26 14:30:00	SPY	ETF	132.3	132.3125	131.85	132.13	12349196.0
2012-06-26 15:00:00	SPY	ETF	132.12	132.34	132.06	132.18	5547171.0
2012-06-26 15:30:00	SPY	ETF	132.19	132.345	131.95	131.97	15378205.0
2012-06-26 16:00:00	SPY	ETF	131.98	132.2	131.3235	132.14	4699010.0
2012-06-26 16:30:00	SPY	ETF	132.15	132.18	132.09	132.15	2311941.0
2012-06-26 17:00:00	SPY	ETF	132.15	132.16	132.12	132.14	35414.0
2012-06-26 17:30:00	SPY	ETF	132.12	132.12	132.09	132.1	13000.0
2012-06-26 18:00:00	SPY	ETF	132.1	132.2	132.1	132.18	34069.0
2012-06-26 18:30:00	SPY	ETF	132.13	132.16	132.07	132.07	7923.0
2012-06-26 19:00:00	SPY	ETF	132.08	132.08	132.03	132.04	104268.0
2012-06-26 19:30:00	SPY	ETF	132.04	132.06	131.98	131.98	101491.0
2012-06-26 04:00:00	QQQ	ETF	61.95	62.28	61.95	62.28	371.0
2012-06-26 05:00:00	QQQ	ETF	62.17	62.17	62.17	62.17	150.0
2012-06-26 06:00:00	QQQ	ETF	62.33	62.33	62.33	62.33	4400.0
2012-06-26 07:00:00	QQQ	ETF	62.3	62.3	62.27	62.27	790.0
2012-06-26 07:30:00	QQQ	ETF	62.3	62.31	62.15	62.18	22300.0
2012-06-26 08:00:00	QQQ	ETF	62.2	62.21	62.12	62.14	14001.0
2012-06-26 08:30:00	QQQ	ETF	62.2	62.23	62.15	62.23	30043.0
2012-06-26 09:00:00	QQQ	ETF	62.22	62.35	62.18	62.32	685960.0
2012-06-26 09:30:00	QQQ	ETF	62.33	62.56	62.28	62.42	2978516.0
2012-06-26 10:00:00	QQQ	ETF	62.43	62.6501	62.24	62.31	3309301.0
2012-06-26 10:30:00	QQQ	ETF	62.3	62.43	62.16	62.27	2742741.0
2012-06-26 11:00:00	QQQ	ETF	62.26	62.4301	62.0575	62.2	3120432.0
2012-06-26 11:30:00	QQQ	ETF	62.21	62.45	62.21	62.37	1875472.0
2012-06-26 12:00:00	QQQ	ETF	62.38	62.48	62.34	62.37	1040549.0
2012-06-26 12:30:00	QQQ	ETF	62.375	62.535	62.375	62.445	1422450.0
2012-06-26 13:00:00	QQQ	ETF	62.45	62.48	62.39	62.39	657743.0
2012-06-26 13:30:00	QQQ	ETF	62.38	62.45	62.26	62.395	1372892.0
2012-06-26 14:00:00	QQQ	ETF	62.39	62.7	62.3899	62.65	2673905.0

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

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