PREVIEW / etf_30min / 2012-10-08

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-10-08.parquet
  size:    267 KB
  rows:    9,139

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-10-08 04:00:00	SPY	ETF	145.7	145.7	145.65	145.65	675.0
2012-10-08 04:30:00	SPY	ETF	145.52	145.6	145.51	145.57	800.0
2012-10-08 05:00:00	SPY	ETF	145.62	145.62	145.59	145.61	6000.0
2012-10-08 05:30:00	SPY	ETF	145.59	145.63	145.56	145.56	14000.0
2012-10-08 06:00:00	SPY	ETF	145.54	145.57	145.42	145.42	8450.0
2012-10-08 06:30:00	SPY	ETF	145.43	145.57	145.43	145.57	18443.0
2012-10-08 07:00:00	SPY	ETF	145.57	145.57	145.46	145.48	48432.0
2012-10-08 07:30:00	SPY	ETF	145.49	145.6	145.49	145.59	51681.0
2012-10-08 08:00:00	SPY	ETF	145.56	145.62	145.54	145.55	247089.0
2012-10-08 08:30:00	SPY	ETF	145.55	145.75	145.53	145.57	254642.0
2012-10-08 09:00:00	SPY	ETF	145.57	145.67	145.51	145.62	2067842.0
2012-10-08 09:30:00	SPY	ETF	145.6	146.1231	145.37	145.55	11078599.0
2012-10-08 10:00:00	SPY	ETF	145.54	145.73	145.41	145.43	6267711.0
2012-10-08 10:30:00	SPY	ETF	145.425	145.8	145.38	145.61	6849231.0
2012-10-08 11:00:00	SPY	ETF	145.62	145.72	145.43	145.519	5262707.0
2012-10-08 11:30:00	SPY	ETF	145.52	145.54	145.31	145.5	5274662.0
2012-10-08 12:00:00	SPY	ETF	145.49	145.59	145.43	145.515	5289916.0
2012-10-08 12:30:00	SPY	ETF	145.51	145.63	145.48	145.62	4068025.0
2012-10-08 13:00:00	SPY	ETF	145.62	145.68	145.49	145.59	3403016.0
2012-10-08 13:30:00	SPY	ETF	145.585	145.67	145.52	145.56	4229897.0
2012-10-08 14:00:00	SPY	ETF	145.55	145.66	145.52	145.61	3149013.0
2012-10-08 14:30:00	SPY	ETF	145.61	145.64	145.53	145.58	2479615.0
2012-10-08 15:00:00	SPY	ETF	145.59	145.885	145.5819	145.72	5234023.0
2012-10-08 15:30:00	SPY	ETF	145.73	145.785	145.58	145.64	8169774.0
2012-10-08 16:00:00	SPY	ETF	145.64	146.1232	145.49	145.49	3067362.0
2012-10-08 16:30:00	SPY	ETF	145.49	145.52	145.45	145.48	302404.0
2012-10-08 17:00:00	SPY	ETF	145.5	145.53	145.49	145.52	258698.0
2012-10-08 17:30:00	SPY	ETF	145.5	145.52	145.45	145.52	17280.0
2012-10-08 18:00:00	SPY	ETF	145.52	145.52	145.45	145.48	22025.0
2012-10-08 18:30:00	SPY	ETF	145.48	145.52	145.48	145.51	11125.0
2012-10-08 19:00:00	SPY	ETF	145.51	145.62	145.5	145.62	44704.0
2012-10-08 19:30:00	SPY	ETF	145.62	145.7	145.57	145.67	79939.0
2012-10-08 04:00:00	QQQ	ETF	68.8	68.8	68.61	68.61	1230.0
2012-10-08 04:30:00	QQQ	ETF	68.6	68.62	68.59	68.62	3128.0
2012-10-08 06:00:00	QQQ	ETF	68.56	68.57	68.53	68.53	1300.0
2012-10-08 07:00:00	QQQ	ETF	68.59	68.59	68.53	68.53	8550.0
2012-10-08 07:30:00	QQQ	ETF	68.58	68.61	68.57	68.6	14400.0
2012-10-08 08:00:00	QQQ	ETF	68.59	68.63	68.53	68.6	48120.0
2012-10-08 08:30:00	QQQ	ETF	68.6	68.66	68.54	68.56	75220.0
2012-10-08 09:00:00	QQQ	ETF	68.57	68.63	68.52	68.59	164015.0
2012-10-08 09:30:00	QQQ	ETF	68.59	68.6499	68.33	68.6	3793138.0
2012-10-08 10:00:00	QQQ	ETF	68.6	68.72	68.36	68.37	2631146.0
2012-10-08 10:30:00	QQQ	ETF	68.36	68.54	68.32	68.46	2238910.0
2012-10-08 11:00:00	QQQ	ETF	68.46	68.5	68.24	68.32	3639261.0
2012-10-08 11:30:00	QQQ	ETF	68.32	68.36	68.19	68.35	2715955.0
2012-10-08 12:00:00	QQQ	ETF	68.36	68.41	68.26	68.32	1542490.0
2012-10-08 12:30:00	QQQ	ETF	68.315	68.35	68.25	68.32	1127122.0
2012-10-08 13:00:00	QQQ	ETF	68.3299	68.37	68.23	68.3	1301984.0
2012-10-08 13:30:00	QQQ	ETF	68.301	68.4	68.27	68.28	1887405.0
2012-10-08 14:00:00	QQQ	ETF	68.27	68.34	68.23	68.27	1043244.0

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

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