PREVIEW / etf_30min / 2012-06-15

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-06-15.parquet
  size:    286 KB
  rows:    9,604

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-15 04:00:00	SPY	ETF	133.89	133.89	133.55	133.62	1300.0
2012-06-15 04:30:00	SPY	ETF	133.56	133.67	133.56	133.67	200.0
2012-06-15 05:00:00	SPY	ETF	133.74	133.76	133.62	133.7	2300.0
2012-06-15 05:30:00	SPY	ETF	133.76	133.76	133.67	133.73	4165.0
2012-06-15 06:00:00	SPY	ETF	133.61	133.61	133.38	133.49	26500.0
2012-06-15 06:30:00	SPY	ETF	133.49	133.62	133.45	133.6	43544.0
2012-06-15 07:00:00	SPY	ETF	133.59	133.7	133.55	133.59	118377.0
2012-06-15 07:30:00	SPY	ETF	133.61	133.66	133.41	133.44	185152.0
2012-06-15 08:00:00	SPY	ETF	133.43	133.91	133.26	133.26	594987.0
2012-06-15 08:30:00	SPY	ETF	133.25	133.44	133.2	133.22	959780.0
2012-06-15 09:00:00	SPY	ETF	133.23	133.42	133.13	133.39	2106254.0
2012-06-15 09:30:00	SPY	ETF	133.38	133.51	133.1	133.47	23414082.0
2012-06-15 10:00:00	SPY	ETF	133.48	133.66	133.28	133.44	12081465.0
2012-06-15 10:30:00	SPY	ETF	133.44	133.63	133.3	133.551	10489083.0
2012-06-15 11:00:00	SPY	ETF	133.55	133.66	133.45	133.62	7846716.0
2012-06-15 11:30:00	SPY	ETF	133.62	133.73	133.53	133.55	7957753.0
2012-06-15 12:00:00	SPY	ETF	133.55	133.6	133.43	133.4782	6510186.0
2012-06-15 12:30:00	SPY	ETF	133.4701	133.49	133.32	133.47	4971241.0
2012-06-15 13:00:00	SPY	ETF	133.46	133.76	133.46	133.57	8847521.0
2012-06-15 13:30:00	SPY	ETF	133.58	133.68	133.51	133.6414	4293816.0
2012-06-15 14:00:00	SPY	ETF	133.64	133.82	133.63	133.76	4674792.0
2012-06-15 14:30:00	SPY	ETF	133.76	133.96	133.72	133.7423	10002260.0
2012-06-15 15:00:00	SPY	ETF	133.74	133.95	133.72	133.93	9349914.0
2012-06-15 15:30:00	SPY	ETF	133.93	134.26	133.88	134.1	30143615.0
2012-06-15 16:00:00	SPY	ETF	134.09	134.43	133.55	134.42	19157894.0
2012-06-15 16:30:00	SPY	ETF	134.43	134.47	133.6	134.39	1690776.0
2012-06-15 17:00:00	SPY	ETF	134.1738	134.47	134.1738	134.47	1017132.0
2012-06-15 17:30:00	SPY	ETF	134.46	134.48	134.41	134.44	265205.0
2012-06-15 18:00:00	SPY	ETF	134.45	134.71	134.45	134.71	183943.0
2012-06-15 18:30:00	SPY	ETF	134.68	134.75	134.63	134.72	44986.0
2012-06-15 19:00:00	SPY	ETF	134.69	134.7	134.6	134.61	45426.0
2012-06-15 19:30:00	SPY	ETF	134.6	134.67	134.58	134.67	65554.0
2012-06-15 04:00:00	QQQ	ETF	62.51	62.53	62.5	62.53	935.0
2012-06-15 04:30:00	QQQ	ETF	62.49	62.49	62.49	62.49	259.0
2012-06-15 06:30:00	QQQ	ETF	62.5	62.5	62.5	62.5	200.0
2012-06-15 07:00:00	QQQ	ETF	62.51	62.6	62.51	62.55	3100.0
2012-06-15 07:30:00	QQQ	ETF	62.56	62.56	62.45	62.45	7300.0
2012-06-15 08:00:00	QQQ	ETF	62.46	62.46	62.36	62.41	67260.0
2012-06-15 08:30:00	QQQ	ETF	62.4	62.47	62.33	62.33	87130.0
2012-06-15 09:00:00	QQQ	ETF	62.35	62.44	62.25	62.39	325678.0
2012-06-15 09:30:00	QQQ	ETF	62.37	62.61	62.36	62.61	6418576.0
2012-06-15 10:00:00	QQQ	ETF	62.62	62.76	62.59	62.68	3616691.0
2012-06-15 10:30:00	QQQ	ETF	62.69	62.745	62.59	62.72	2678973.0
2012-06-15 11:00:00	QQQ	ETF	62.72	62.79	62.68	62.79	2007221.0
2012-06-15 11:30:00	QQQ	ETF	62.79	62.84	62.73	62.74	1549200.0
2012-06-15 12:00:00	QQQ	ETF	62.74	62.8	62.67	62.701	1154639.0
2012-06-15 12:30:00	QQQ	ETF	62.7043	62.73	62.65	62.73	1461273.0
2012-06-15 13:00:00	QQQ	ETF	62.73	62.83	62.72	62.73	1475173.0
2012-06-15 13:30:00	QQQ	ETF	62.7392	62.79	62.71	62.78	1307367.0
2012-06-15 14:00:00	QQQ	ETF	62.78	62.85	62.76	62.81	740660.0

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

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