PREVIEW / etf_30min / 2012-08-21

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-21.parquet
  size:    293 KB
  rows:    9,678

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-08-21 04:00:00	SPY	ETF	142.3	142.48	142.3	142.48	2034.0
2012-08-21 05:00:00	SPY	ETF	142.41	142.41	142.36	142.36	418.0
2012-08-21 05:30:00	SPY	ETF	142.4	142.42	142.33	142.33	1608.0
2012-08-21 06:00:00	SPY	ETF	142.42	142.42	142.42	142.42	200.0
2012-08-21 06:30:00	SPY	ETF	142.41	142.45	142.4	142.42	3750.0
2012-08-21 07:00:00	SPY	ETF	142.42	142.42	142.33	142.36	8800.0
2012-08-21 07:30:00	SPY	ETF	142.38	142.47	142.37	142.47	23255.0
2012-08-21 08:00:00	SPY	ETF	142.45	142.47	142.35	142.39	165760.0
2012-08-21 08:30:00	SPY	ETF	142.39	142.67	142.38	142.6	488451.0
2012-08-21 09:00:00	SPY	ETF	142.59	142.6	142.51	142.53	405603.0
2012-08-21 09:30:00	SPY	ETF	142.54	142.76	142.46	142.74	10092244.0
2012-08-21 10:00:00	SPY	ETF	142.74	142.95	142.74	142.94	7655437.0
2012-08-21 10:30:00	SPY	ETF	142.949	143.09	142.88	142.92	8241676.0
2012-08-21 11:00:00	SPY	ETF	142.91	142.96	142.58	142.65	8983026.0
2012-08-21 11:30:00	SPY	ETF	142.65	142.68	142.385	142.45	9605207.0
2012-08-21 12:00:00	SPY	ETF	142.44	142.53	142.32	142.4135	4377897.0
2012-08-21 12:30:00	SPY	ETF	142.41	142.48	142.24	142.33	3351916.0
2012-08-21 13:00:00	SPY	ETF	142.34	142.34	142.15	142.16	3528948.0
2012-08-21 13:30:00	SPY	ETF	142.1602	142.19	141.89	142.0715	4807904.0
2012-08-21 14:00:00	SPY	ETF	142.08	142.15	141.93	141.98	4541630.0
2012-08-21 14:30:00	SPY	ETF	141.98	142.06	141.79	141.87	5227124.0
2012-08-21 15:00:00	SPY	ETF	141.875	141.88	141.45	141.58	7776762.0
2012-08-21 15:30:00	SPY	ETF	141.585	141.81	141.54	141.77	13826002.0
2012-08-21 16:00:00	SPY	ETF	141.78	142.59	141.68	141.89	5255316.0
2012-08-21 16:30:00	SPY	ETF	141.9	141.9973	141.82	141.85	1628084.0
2012-08-21 17:00:00	SPY	ETF	141.85	141.87	141.7823	141.86	5062148.0
2012-08-21 17:30:00	SPY	ETF	141.88	141.88	141.82	141.86	4926.0
2012-08-21 18:00:00	SPY	ETF	141.85	141.85	141.72	141.76	46653.0
2012-08-21 18:30:00	SPY	ETF	141.74	141.77	141.69	141.72	56612.0
2012-08-21 19:00:00	SPY	ETF	141.75	141.75	141.73	141.73	6100.0
2012-08-21 19:30:00	SPY	ETF	141.75	141.75	141.67	141.74	81320.0
2012-08-21 04:00:00	QQQ	ETF	68.43	68.49	68.43	68.49	600.0
2012-08-21 05:30:00	QQQ	ETF	68.5	68.5	68.5	68.5	1000.0
2012-08-21 06:30:00	QQQ	ETF	68.51	68.53	68.51	68.53	700.0
2012-08-21 07:00:00	QQQ	ETF	68.51	68.51	68.5	68.51	1150.0
2012-08-21 07:30:00	QQQ	ETF	68.5	68.53	68.48	68.53	2750.0
2012-08-21 08:00:00	QQQ	ETF	68.52	68.54	68.49	68.52	49703.0
2012-08-21 08:30:00	QQQ	ETF	68.53	68.66	68.53	68.6	117308.0
2012-08-21 09:00:00	QQQ	ETF	68.61	68.63	68.58	68.63	209012.0
2012-08-21 09:30:00	QQQ	ETF	68.63	68.76	68.56	68.73	4261842.0
2012-08-21 10:00:00	QQQ	ETF	68.73	68.86	68.73	68.84	1834598.0
2012-08-21 10:30:00	QQQ	ETF	68.85	68.88	68.55	68.59	4346971.0
2012-08-21 11:00:00	QQQ	ETF	68.59	68.64	68.37	68.42	3040203.0
2012-08-21 11:30:00	QQQ	ETF	68.42	68.49	68.33	68.34	1547418.0
2012-08-21 12:00:00	QQQ	ETF	68.34	68.37	68.21	68.3	2212541.0
2012-08-21 12:30:00	QQQ	ETF	68.3	68.37	68.14	68.195	1687651.0
2012-08-21 13:00:00	QQQ	ETF	68.195	68.2	68.03	68.06	2301658.0
2012-08-21 13:30:00	QQQ	ETF	68.0555	68.09	67.89	68.06	2429694.0
2012-08-21 14:00:00	QQQ	ETF	68.06	68.23	68.04	68.18	2328189.0
2012-08-21 14:30:00	QQQ	ETF	68.18	68.22	68.06	68.1	1916840.0

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

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