PREVIEW / etf_30min / 2012-11-13

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-11-13.parquet
  size:    290 KB
  rows:    9,718

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-11-13 04:00:00	SPY	ETF	137.4	137.76	137.4	137.76	318528.0
2012-11-13 04:30:00	SPY	ETF	137.76	137.76	137.7	137.7	92276.0
2012-11-13 05:00:00	SPY	ETF	137.6	137.6	137.44	137.48	29000.0
2012-11-13 05:30:00	SPY	ETF	137.48	137.58	137.46	137.46	37525.0
2012-11-13 06:00:00	SPY	ETF	137.45	137.46	137.24	137.44	97136.0
2012-11-13 06:30:00	SPY	ETF	137.45	137.9	137.45	137.89	147780.0
2012-11-13 07:00:00	SPY	ETF	137.89	138.14	137.67	137.8	296700.0
2012-11-13 07:30:00	SPY	ETF	137.76	137.98	137.67	137.74	446958.0
2012-11-13 08:00:00	SPY	ETF	137.77	137.93	137.72	137.76	291291.0
2012-11-13 08:30:00	SPY	ETF	137.78	137.82	137.6	137.65	327425.0
2012-11-13 09:00:00	SPY	ETF	137.65	137.66	137.39	137.54	818270.0
2012-11-13 09:30:00	SPY	ETF	137.54	138.43	137.36	138.33	18966424.0
2012-11-13 10:00:00	SPY	ETF	138.34	138.74	138.07	138.43	11836518.0
2012-11-13 10:30:00	SPY	ETF	138.435	139.09	138.33	139.06	10731208.0
2012-11-13 11:00:00	SPY	ETF	139.06	139.25	138.96	139.0101	7074957.0
2012-11-13 11:30:00	SPY	ETF	139.02	139.14	138.85	139.02	5205074.0
2012-11-13 12:00:00	SPY	ETF	139.03	139.07	138.72	138.75	4617601.0
2012-11-13 12:30:00	SPY	ETF	138.755	138.77	138.51	138.635	5455147.0
2012-11-13 13:00:00	SPY	ETF	138.635	138.97	138.5	138.76	4349397.0
2012-11-13 13:30:00	SPY	ETF	138.77	138.9396	138.6	138.92	4816901.0
2012-11-13 14:00:00	SPY	ETF	138.92	139.005	138.75	138.8199	4437967.0
2012-11-13 14:30:00	SPY	ETF	138.81	138.83	138.45	138.6	7102108.0
2012-11-13 15:00:00	SPY	ETF	138.605	138.7001	137.97	138.1	9732275.0
2012-11-13 15:30:00	SPY	ETF	138.1	138.26	137.73	137.83	15968749.0
2012-11-13 16:00:00	SPY	ETF	137.82	138.514	137.6164	137.96	7602270.0
2012-11-13 16:30:00	SPY	ETF	137.96	138.19	137.96	138.14	1304500.0
2012-11-13 17:00:00	SPY	ETF	138.13	138.14	137.7	138.1	90286.0
2012-11-13 17:30:00	SPY	ETF	138.14	138.14	138.08	138.12	39144.0
2012-11-13 18:00:00	SPY	ETF	138.11	138.11	137.91	137.95	122695.0
2012-11-13 18:30:00	SPY	ETF	137.97	137.99	137.89	137.95	15484.0
2012-11-13 19:00:00	SPY	ETF	137.95	138.1	137.95	138.1	16684.0
2012-11-13 19:30:00	SPY	ETF	138.07	138.1	138.0	138.08	44355.0
2012-11-13 04:00:00	QQQ	ETF	63.06	63.11	63.06	63.11	807.0
2012-11-13 05:00:00	QQQ	ETF	63.04	63.04	62.98	62.98	200.0
2012-11-13 05:30:00	QQQ	ETF	63.05	63.05	63.04	63.04	2000.0
2012-11-13 06:00:00	QQQ	ETF	62.98	62.98	62.97	62.97	600.0
2012-11-13 06:30:00	QQQ	ETF	63.09	63.19	63.09	63.15	3000.0
2012-11-13 07:00:00	QQQ	ETF	63.2	63.25	63.08	63.14	10373.0
2012-11-13 07:30:00	QQQ	ETF	63.1	63.12	63.06	63.06	14015.0
2012-11-13 08:00:00	QQQ	ETF	63.05	63.09	63.03	63.04	66420.0
2012-11-13 08:30:00	QQQ	ETF	63.04	63.05	62.97	62.98	99998.0
2012-11-13 09:00:00	QQQ	ETF	62.98	62.98	62.87	62.92	262132.0
2012-11-13 09:30:00	QQQ	ETF	62.91	63.35	62.7801	63.3	5802043.0
2012-11-13 10:00:00	QQQ	ETF	63.31	63.44	63.13	63.26	3513792.0
2012-11-13 10:30:00	QQQ	ETF	63.25	63.5	63.14	63.4769	2958962.0
2012-11-13 11:00:00	QQQ	ETF	63.47	63.58	63.44	63.48	1743014.0
2012-11-13 11:30:00	QQQ	ETF	63.48	63.57	63.39	63.54	2310135.0
2012-11-13 12:00:00	QQQ	ETF	63.54	63.5599	63.36	63.39	1319896.0
2012-11-13 12:30:00	QQQ	ETF	63.39	63.398	63.26	63.31	1109452.0
2012-11-13 13:00:00	QQQ	ETF	63.31	63.45	63.25	63.38	1054873.0

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

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