PREVIEW / etf_30min / 2012-06-28

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-06-28.parquet
  size:    283 KB
  rows:    9,468

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-28 04:00:00	SPY	ETF	132.66	132.66	132.29	132.35	9200.0
2012-06-28 04:30:00	SPY	ETF	132.3	132.4	132.24	132.4	1700.0
2012-06-28 05:00:00	SPY	ETF	132.4	132.58	132.4	132.5	2753.0
2012-06-28 05:30:00	SPY	ETF	132.39	132.4	132.23	132.28	24750.0
2012-06-28 06:00:00	SPY	ETF	132.15	132.54	132.15	132.54	17729.0
2012-06-28 06:30:00	SPY	ETF	132.55	132.59	132.45	132.5	91780.0
2012-06-28 07:00:00	SPY	ETF	132.48	133.09	132.44	132.72	488232.0
2012-06-28 07:30:00	SPY	ETF	132.75	132.83	132.35	132.45	550461.0
2012-06-28 08:00:00	SPY	ETF	132.45	132.75	132.27	132.3	999199.0
2012-06-28 08:30:00	SPY	ETF	132.27	133.17	132.27	132.38	824822.0
2012-06-28 09:00:00	SPY	ETF	132.38	133.17	132.2	132.3	1817508.0
2012-06-28 09:30:00	SPY	ETF	132.29	132.42	132.02	132.32	15545103.0
2012-06-28 10:00:00	SPY	ETF	132.31	132.47	131.81	132.03	21747423.0
2012-06-28 10:30:00	SPY	ETF	132.03	132.03	131.41	131.565	14419132.0
2012-06-28 11:00:00	SPY	ETF	131.57	131.88	131.42	131.85	10164988.0
2012-06-28 11:30:00	SPY	ETF	131.85	131.98	131.75	131.83	5786558.0
2012-06-28 12:00:00	SPY	ETF	131.82	131.95	131.63	131.75	8661457.0
2012-06-28 12:30:00	SPY	ETF	131.76	131.85	131.61	131.819	4718195.0
2012-06-28 13:00:00	SPY	ETF	131.82	131.91	131.65	131.74	6248125.0
2012-06-28 13:30:00	SPY	ETF	131.74	131.74	131.46	131.71	5771022.0
2012-06-28 14:00:00	SPY	ETF	131.71	131.75	131.3	131.37	7146927.0
2012-06-28 14:30:00	SPY	ETF	131.37	131.61	131.28	131.5899	5846489.0
2012-06-28 15:00:00	SPY	ETF	131.59	131.95	131.561	131.95	11582111.0
2012-06-28 15:30:00	SPY	ETF	131.95	132.99	131.91	132.79	37439373.0
2012-06-28 16:00:00	SPY	ETF	132.79	132.98	131.49	132.79	5595715.0
2012-06-28 16:30:00	SPY	ETF	132.79	132.8774	132.55	132.6	1170445.0
2012-06-28 17:00:00	SPY	ETF	132.59	133.1581	132.53	132.64	688531.0
2012-06-28 17:30:00	SPY	ETF	132.6	132.68	132.6	132.68	76628.0
2012-06-28 18:00:00	SPY	ETF	132.68	132.68	132.54	132.55	48811.0
2012-06-28 18:30:00	SPY	ETF	132.56	132.56	132.39	132.49	98807.0
2012-06-28 19:00:00	SPY	ETF	132.44	132.44	132.21	132.22	98393.0
2012-06-28 19:30:00	SPY	ETF	132.24	132.41	132.22	132.38	55332.0
2012-06-28 06:00:00	QQQ	ETF	62.46	62.46	62.46	62.46	100.0
2012-06-28 07:00:00	QQQ	ETF	62.54	62.78	62.54	62.71	23665.0
2012-06-28 07:30:00	QQQ	ETF	62.65	62.68	62.53	62.53	4700.0
2012-06-28 08:00:00	QQQ	ETF	62.56	62.56	62.49	62.5	68015.0
2012-06-28 08:30:00	QQQ	ETF	62.5	62.58	62.5	62.5	58575.0
2012-06-28 09:00:00	QQQ	ETF	62.49	62.5	62.4	62.44	124289.0
2012-06-28 09:30:00	QQQ	ETF	62.43	62.47	62.01	62.33	6121121.0
2012-06-28 10:00:00	QQQ	ETF	62.33	62.35	62.06	62.07	5254522.0
2012-06-28 10:30:00	QQQ	ETF	62.07	62.07	61.76	61.85	4777783.0
2012-06-28 11:00:00	QQQ	ETF	61.85	61.9799	61.77	61.95	2240555.0
2012-06-28 11:30:00	QQQ	ETF	61.95	62.0199	61.8818	61.92	1775004.0
2012-06-28 12:00:00	QQQ	ETF	61.91	61.99	61.82	61.88	1563079.0
2012-06-28 12:30:00	QQQ	ETF	61.87	61.91	61.79	61.87	1601453.0
2012-06-28 13:00:00	QQQ	ETF	61.8755	61.91	61.75	61.81	2699138.0
2012-06-28 13:30:00	QQQ	ETF	61.8	61.8	61.6335	61.76	1718974.0
2012-06-28 14:00:00	QQQ	ETF	61.77	61.8	61.55	61.5701	1487449.0
2012-06-28 14:30:00	QQQ	ETF	61.57	61.67	61.54	61.64	1332436.0
2012-06-28 15:00:00	QQQ	ETF	61.65	61.78	61.64	61.77	1582859.0

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

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