PREVIEW / etf_30min / 2014-05-12

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-05-12.parquet
  size:    336 KB
  rows:    11,593

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
2014-05-12 04:00:00	SPY	ETF	188.2	188.22	188.19	188.22	2751.0
2014-05-12 04:30:00	SPY	ETF	188.19	188.19	188.19	188.19	400.0
2014-05-12 05:00:00	SPY	ETF	188.23	188.25	188.21	188.23	9206.0
2014-05-12 05:30:00	SPY	ETF	188.14	188.34	188.14	188.34	6179.0
2014-05-12 06:00:00	SPY	ETF	188.34	188.5	188.27	188.5	15964.0
2014-05-12 06:30:00	SPY	ETF	188.51	188.68	188.51	188.68	47049.0
2014-05-12 07:00:00	SPY	ETF	188.69	188.73	188.59	188.63	93613.0
2014-05-12 07:30:00	SPY	ETF	188.61	188.65	188.54	188.56	60521.0
2014-05-12 08:00:00	SPY	ETF	188.55	188.73	188.5	188.58	128997.0
2014-05-12 08:30:00	SPY	ETF	188.56	188.62	188.41	188.62	147555.0
2014-05-12 09:00:00	SPY	ETF	188.61	188.78	188.57	188.76	358682.0
2014-05-12 09:30:00	SPY	ETF	188.76	189.39	188.75	189.33	13856474.0
2014-05-12 10:00:00	SPY	ETF	189.34	189.53	189.26	189.37	9582183.0
2014-05-12 10:30:00	SPY	ETF	189.38	189.525	189.24	189.32	5010157.0
2014-05-12 11:00:00	SPY	ETF	189.32	189.45	189.3	189.415	3560400.0
2014-05-12 11:30:00	SPY	ETF	189.43	189.55	189.4	189.4301	3652220.0
2014-05-12 12:00:00	SPY	ETF	189.43	189.65	189.4	189.535	2862171.0
2014-05-12 12:30:00	SPY	ETF	189.53	189.57	189.39	189.41	1759449.0
2014-05-12 13:00:00	SPY	ETF	189.41	189.55	189.38	189.55	4215932.0
2014-05-12 13:30:00	SPY	ETF	189.55	189.65	189.49	189.61	3414052.0
2014-05-12 14:00:00	SPY	ETF	189.6073	189.725	189.48	189.5879	4578983.0
2014-05-12 14:30:00	SPY	ETF	189.585	189.755	189.58	189.74	2879343.0
2014-05-12 15:00:00	SPY	ETF	189.73	189.835	189.66	189.66	4769633.0
2014-05-12 15:30:00	SPY	ETF	189.661	189.88	189.63	189.78	11357567.0
2014-05-12 16:00:00	SPY	ETF	189.77	189.91	187.9992	189.9	6856015.0
2014-05-12 16:30:00	SPY	ETF	189.9	189.92	189.785	189.91	941216.0
2014-05-12 17:00:00	SPY	ETF	189.91	189.95	189.9	189.95	37251.0
2014-05-12 17:30:00	SPY	ETF	189.91	189.94	189.91	189.92	2008983.0
2014-05-12 18:00:00	SPY	ETF	189.92	189.92	189.8	189.83	25668.0
2014-05-12 18:30:00	SPY	ETF	189.87	189.92	189.87	189.89	6400.0
2014-05-12 19:00:00	SPY	ETF	189.9	189.95	189.9	189.92	10205.0
2014-05-12 19:30:00	SPY	ETF	189.92	189.97	189.92	189.96	24941.0
2014-05-12 04:00:00	QQQ	ETF	86.92	86.98	86.92	86.98	5490.0
2014-05-12 06:00:00	QQQ	ETF	87.0	87.07	87.0	87.07	5180.0
2014-05-12 06:30:00	QQQ	ETF	87.1	87.27	87.1	87.27	7070.0
2014-05-12 07:00:00	QQQ	ETF	87.28	87.33	87.22	87.27	27380.0
2014-05-12 07:30:00	QQQ	ETF	87.27	87.28	87.22	87.22	29150.0
2014-05-12 08:00:00	QQQ	ETF	87.22	87.25	87.18	87.2	76192.0
2014-05-12 08:30:00	QQQ	ETF	87.24	87.25	87.22	87.24	25026.0
2014-05-12 09:00:00	QQQ	ETF	87.25	87.34	87.23	87.32	136568.0
2014-05-12 09:30:00	QQQ	ETF	87.31	87.83	87.24	87.83	6363228.0
2014-05-12 10:00:00	QQQ	ETF	87.83	87.98	87.74	87.91	4618196.0
2014-05-12 10:30:00	QQQ	ETF	87.92	88.03	87.86	87.95	1963191.0
2014-05-12 11:00:00	QQQ	ETF	87.94	87.98	87.872	87.93	1333983.0
2014-05-12 11:30:00	QQQ	ETF	87.93	88.01	87.92	87.93	2168755.0
2014-05-12 12:00:00	QQQ	ETF	87.93	88.12	87.92	88.05	1392731.0
2014-05-12 12:30:00	QQQ	ETF	88.0499	88.09	87.94	87.9601	806493.0
2014-05-12 13:00:00	QQQ	ETF	87.96	87.99	87.9335	87.98	714412.0
2014-05-12 13:30:00	QQQ	ETF	87.97	88.06	87.95	88.035	784737.0
2014-05-12 14:00:00	QQQ	ETF	88.04	88.12	87.95	88.06	1219645.0

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

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