PREVIEW / etf_30min / 2012-07-03

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-07-03.parquet
  size:    187 KB
  rows:    5,851

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-07-03 04:00:00	SPY	ETF	136.31	136.31	136.15	136.15	800.0
2012-07-03 04:30:00	SPY	ETF	136.15	136.33	136.15	136.31	2300.0
2012-07-03 05:30:00	SPY	ETF	136.43	136.43	136.43	136.43	120.0
2012-07-03 06:00:00	SPY	ETF	136.36	136.36	136.32	136.32	11600.0
2012-07-03 06:30:00	SPY	ETF	136.24	136.25	136.22	136.22	1400.0
2012-07-03 07:00:00	SPY	ETF	136.3	136.42	136.3	136.35	82970.0
2012-07-03 07:30:00	SPY	ETF	136.38	136.5	136.38	136.44	130212.0
2012-07-03 08:00:00	SPY	ETF	136.43	136.48	136.34	136.41	167548.0
2012-07-03 08:30:00	SPY	ETF	136.39	136.51	136.35	136.47	288172.0
2012-07-03 09:00:00	SPY	ETF	136.49	136.51	136.35	136.48	525188.0
2012-07-03 09:30:00	SPY	ETF	136.48	136.87	136.34	136.79	11275271.0
2012-07-03 10:00:00	SPY	ETF	136.79	137.03	136.79	136.918	10018468.0
2012-07-03 10:30:00	SPY	ETF	136.92	137.16	136.895	137.095	6832783.0
2012-07-03 11:00:00	SPY	ETF	137.09	137.4801	137.09	137.47	9734705.0
2012-07-03 11:30:00	SPY	ETF	137.46	137.51	137.32	137.36	7449865.0
2012-07-03 12:00:00	SPY	ETF	137.35	137.41	137.13	137.21	7756574.0
2012-07-03 12:30:00	SPY	ETF	137.21	137.43	136.98	137.42	19259204.0
2012-07-03 13:00:00	SPY	ETF	137.42	137.52	136.5649	137.49	4471585.0
2012-07-03 13:30:00	SPY	ETF	137.49	137.6	137.43	137.44	205038.0
2012-07-03 14:00:00	SPY	ETF	137.44	137.55	137.43	137.51	121100.0
2012-07-03 14:30:00	SPY	ETF	137.52	137.56	137.51	137.54	56330.0
2012-07-03 15:00:00	SPY	ETF	137.51	137.54	137.48	137.5	6783.0
2012-07-03 15:30:00	SPY	ETF	137.52	137.53	137.37	137.38	43539.0
2012-07-03 16:00:00	SPY	ETF	137.36	137.39	137.34	137.35	3290.0
2012-07-03 16:30:00	SPY	ETF	137.33	137.43	137.26	137.37	16110.0
2012-07-03 05:00:00	QQQ	ETF	64.34	64.34	64.3	64.3	264.0
2012-07-03 06:30:00	QQQ	ETF	64.28	64.28	64.28	64.28	300.0
2012-07-03 07:00:00	QQQ	ETF	64.31	64.34	64.31	64.34	16330.0
2012-07-03 07:30:00	QQQ	ETF	64.34	64.38	64.34	64.35	25275.0
2012-07-03 08:00:00	QQQ	ETF	64.34	64.36	64.33	64.34	33391.0
2012-07-03 08:30:00	QQQ	ETF	64.35	64.42	64.33	64.4	44366.0
2012-07-03 09:00:00	QQQ	ETF	64.39	64.39	64.33	64.37	39485.0
2012-07-03 09:30:00	QQQ	ETF	64.38	64.47	64.29	64.43	2454819.0
2012-07-03 10:00:00	QQQ	ETF	64.44	64.57	64.43	64.5511	1738480.0
2012-07-03 10:30:00	QQQ	ETF	64.55	64.67	64.54	64.64	1636394.0
2012-07-03 11:00:00	QQQ	ETF	64.64	64.83	64.64	64.82	2523259.0
2012-07-03 11:30:00	QQQ	ETF	64.82	64.85	64.74	64.7692	1507939.0
2012-07-03 12:00:00	QQQ	ETF	64.77	64.81	64.72	64.78	1479329.0
2012-07-03 12:30:00	QQQ	ETF	64.77	64.89	64.69	64.88	3249350.0
2012-07-03 13:00:00	QQQ	ETF	64.88	64.92	64.84	64.92	364926.0
2012-07-03 13:30:00	QQQ	ETF	64.88	64.96	64.88	64.93	26726.0
2012-07-03 14:00:00	QQQ	ETF	64.91	64.94	64.91	64.92	4520.0
2012-07-03 14:30:00	QQQ	ETF	64.92	64.96	64.89	64.9	8955.0
2012-07-03 15:00:00	QQQ	ETF	64.88	64.92	64.88	64.91	687.0
2012-07-03 15:30:00	QQQ	ETF	64.92	64.92	64.88	64.9	5513.0
2012-07-03 16:30:00	QQQ	ETF	64.85	64.92	64.85	64.92	5100.0
2012-07-03 07:00:00	IWM	ETF	80.52	80.52	80.52	80.52	1000.0
2012-07-03 07:30:00	IWM	ETF	80.52	80.59	80.52	80.59	7400.0
2012-07-03 08:00:00	IWM	ETF	80.54	80.56	80.46	80.51	64190.0
2012-07-03 08:30:00	IWM	ETF	80.48	80.6	80.47	80.53	100530.0

> showing 50 of 5,851 rows — these rows as CSV

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