PREVIEW / etf_30min / 2013-09-19

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-09-19.parquet
  size:    340 KB
  rows:    11,330

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
2013-09-19 04:00:00	SPY	ETF	173.46	173.51	173.45	173.45	25500.0
2013-09-19 04:30:00	SPY	ETF	173.48	173.54	173.45	173.51	36601.0
2013-09-19 05:00:00	SPY	ETF	173.57	173.69	173.56	173.66	13600.0
2013-09-19 05:30:00	SPY	ETF	173.68	173.86	173.68	173.78	16700.0
2013-09-19 06:00:00	SPY	ETF	173.76	173.85	173.73	173.81	31475.0
2013-09-19 06:30:00	SPY	ETF	173.8	173.83	173.7	173.7	33040.0
2013-09-19 07:00:00	SPY	ETF	173.72	173.79	173.58	173.6	95095.0
2013-09-19 07:30:00	SPY	ETF	173.59	173.59	173.4	173.51	188530.0
2013-09-19 08:00:00	SPY	ETF	173.5	173.75	173.34	173.39	308207.0
2013-09-19 08:30:00	SPY	ETF	173.4	173.53	173.35	173.39	766041.0
2013-09-19 09:00:00	SPY	ETF	173.39	173.56	173.39	173.51	1061827.0
2013-09-19 09:30:00	SPY	ETF	173.52	173.6	173.06	173.4	21959600.0
2013-09-19 10:00:00	SPY	ETF	173.39	173.49	173.01	173.22	13004389.0
2013-09-19 10:30:00	SPY	ETF	173.22	173.3354	173.04	173.19	12403235.0
2013-09-19 11:00:00	SPY	ETF	173.19	173.2	172.98	173.06	5813155.0
2013-09-19 11:30:00	SPY	ETF	173.055	173.08	172.79	172.911	10795832.0
2013-09-19 12:00:00	SPY	ETF	172.92	173.11	172.88	173.05	8882825.0
2013-09-19 12:30:00	SPY	ETF	173.045	173.045	172.84	172.849	5103949.0
2013-09-19 13:00:00	SPY	ETF	172.84	172.93	172.63	172.82	5802570.0
2013-09-19 13:30:00	SPY	ETF	172.82	172.83	172.6	172.6199	5473312.0
2013-09-19 14:00:00	SPY	ETF	172.62	172.88	172.585	172.73	6953406.0
2013-09-19 14:30:00	SPY	ETF	172.73	172.82	172.645	172.8	5912793.0
2013-09-19 15:00:00	SPY	ETF	172.8	172.99	172.8	172.92	6421449.0
2013-09-19 15:30:00	SPY	ETF	172.92	172.93	172.71	172.81	14616577.0
2013-09-19 16:00:00	SPY	ETF	172.81	173.1098	172.75	172.95	13943913.0
2013-09-19 16:30:00	SPY	ETF	172.96	172.96	172.81	172.9	4057431.0
2013-09-19 17:00:00	SPY	ETF	172.9	173.0915	172.82	172.9	938141.0
2013-09-19 17:30:00	SPY	ETF	172.91	172.96	172.9	172.92	53325.0
2013-09-19 18:00:00	SPY	ETF	172.94	172.94	172.83	172.9	110020.0
2013-09-19 18:30:00	SPY	ETF	172.9	172.91	172.89	172.89	24668.0
2013-09-19 19:00:00	SPY	ETF	172.9	172.9	172.82	172.84	7200.0
2013-09-19 19:30:00	SPY	ETF	172.84	172.87	172.82	172.82	33025.0
2013-09-19 04:30:00	QQQ	ETF	79.46	79.5	79.46	79.5	800.0
2013-09-19 05:00:00	QQQ	ETF	79.5	79.55	79.48	79.55	19000.0
2013-09-19 05:30:00	QQQ	ETF	79.57	79.61	79.57	79.59	8400.0
2013-09-19 06:00:00	QQQ	ETF	79.59	79.61	79.59	79.61	2600.0
2013-09-19 06:30:00	QQQ	ETF	79.61	79.61	79.57	79.57	6950.0
2013-09-19 07:00:00	QQQ	ETF	79.57	79.59	79.55	79.56	5600.0
2013-09-19 07:30:00	QQQ	ETF	79.53	79.53	79.47	79.47	42880.0
2013-09-19 08:00:00	QQQ	ETF	79.48	79.57	79.44	79.49	168800.0
2013-09-19 08:30:00	QQQ	ETF	79.48	79.53	79.45	79.48	139112.0
2013-09-19 09:00:00	QQQ	ETF	79.49	79.6	79.46	79.53	164513.0
2013-09-19 09:30:00	QQQ	ETF	79.54	79.685	79.41	79.64	3930563.0
2013-09-19 10:00:00	QQQ	ETF	79.635	79.67	79.36	79.49	2601129.0
2013-09-19 10:30:00	QQQ	ETF	79.5	79.54	79.39	79.52	1117469.0
2013-09-19 11:00:00	QQQ	ETF	79.52	79.53	79.41	79.48	844957.0
2013-09-19 11:30:00	QQQ	ETF	79.48	79.49	79.37	79.42	1688613.0
2013-09-19 12:00:00	QQQ	ETF	79.41	79.54	79.4	79.531	979196.0
2013-09-19 12:30:00	QQQ	ETF	79.53	79.53	79.4507	79.46	683378.0
2013-09-19 13:00:00	QQQ	ETF	79.46	79.56	79.42	79.485	3984244.0

> showing 50 of 11,330 rows — these rows as CSV

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