PREVIEW / etf_30min / 2013-06-26

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-06-26.parquet
  size:    328 KB
  rows:    11,062

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-06-26 04:00:00	SPY	ETF	158.59	158.92	158.59	158.91	28788.0
2013-06-26 04:30:00	SPY	ETF	158.95	159.1	158.9	158.92	15123.0
2013-06-26 05:00:00	SPY	ETF	158.95	159.15	158.93	159.1	60613.0
2013-06-26 05:30:00	SPY	ETF	159.15	159.27	159.02	159.27	51840.0
2013-06-26 06:00:00	SPY	ETF	159.26	159.37	159.2	159.29	96042.0
2013-06-26 06:30:00	SPY	ETF	159.3	159.31	159.14	159.15	44550.0
2013-06-26 07:00:00	SPY	ETF	159.15	159.36	159.1	159.33	202092.0
2013-06-26 07:30:00	SPY	ETF	159.34	159.57	159.33	159.54	373940.0
2013-06-26 08:00:00	SPY	ETF	159.2	159.55	158.0	159.4	1756533.0
2013-06-26 08:30:00	SPY	ETF	159.4	159.55	159.18	159.53	1386139.0
2013-06-26 09:00:00	SPY	ETF	159.53	159.91	159.42	159.87	1791165.0
2013-06-26 09:30:00	SPY	ETF	159.87	160.16	159.78	159.96	20039890.0
2013-06-26 10:00:00	SPY	ETF	159.96	160.11	159.57	159.65	11425737.0
2013-06-26 10:30:00	SPY	ETF	159.64	159.88	159.475	159.57	8340282.0
2013-06-26 11:00:00	SPY	ETF	159.56	159.72	159.25	159.46	10911170.0
2013-06-26 11:30:00	SPY	ETF	159.45	159.62	159.3101	159.4	6160387.0
2013-06-26 12:00:00	SPY	ETF	159.4	159.85	159.38	159.82	5062496.0
2013-06-26 12:30:00	SPY	ETF	159.83	159.91	159.64	159.72	4151869.0
2013-06-26 13:00:00	SPY	ETF	159.72	160.17	159.64	160.14	6498983.0
2013-06-26 13:30:00	SPY	ETF	160.14	160.22	159.94	160.05	6098388.0
2013-06-26 14:00:00	SPY	ETF	160.05	160.2699	159.95	160.241	5099833.0
2013-06-26 14:30:00	SPY	ETF	160.24	160.35	160.09	160.24	5709922.0
2013-06-26 15:00:00	SPY	ETF	160.24	160.5	160.23	160.36	11471821.0
2013-06-26 15:30:00	SPY	ETF	160.36	160.46	160.08	160.14	20843945.0
2013-06-26 16:00:00	SPY	ETF	160.14	160.17	159.85	159.93	3917924.0
2013-06-26 16:30:00	SPY	ETF	159.95	160.186	158.5913	160.03	1403714.0
2013-06-26 17:00:00	SPY	ETF	160.02	160.1	160.02	160.06	104765.0
2013-06-26 17:30:00	SPY	ETF	160.08	160.11	160.07	160.08	41673.0
2013-06-26 18:00:00	SPY	ETF	160.07	160.07	159.91	159.94	46171.0
2013-06-26 18:30:00	SPY	ETF	159.97	160.0	159.95	159.98	15925.0
2013-06-26 19:00:00	SPY	ETF	159.98	160.02	159.93	159.93	26604.0
2013-06-26 19:30:00	SPY	ETF	159.92	160.0	159.88	159.93	46305.0
2013-06-26 04:00:00	QQQ	ETF	70.31	70.4	70.3	70.4	4100.0
2013-06-26 04:30:00	QQQ	ETF	70.42	70.48	70.38	70.38	8940.0
2013-06-26 05:00:00	QQQ	ETF	70.4	70.48	70.4	70.48	2800.0
2013-06-26 05:30:00	QQQ	ETF	70.5	70.54	70.48	70.54	2000.0
2013-06-26 06:00:00	QQQ	ETF	70.56	70.61	70.54	70.56	6141.0
2013-06-26 06:30:00	QQQ	ETF	70.56	70.56	70.52	70.52	3000.0
2013-06-26 07:00:00	QQQ	ETF	70.51	70.57	70.5	70.57	4000.0
2013-06-26 07:30:00	QQQ	ETF	70.58	70.68	70.58	70.68	7300.0
2013-06-26 08:00:00	QQQ	ETF	70.68	70.68	69.97	70.6	31555.0
2013-06-26 08:30:00	QQQ	ETF	70.6	70.67	70.52	70.65	131062.0
2013-06-26 09:00:00	QQQ	ETF	70.66	70.86	70.62	70.83	141461.0
2013-06-26 09:30:00	QQQ	ETF	70.82	70.95	70.65	70.82	3068506.0
2013-06-26 10:00:00	QQQ	ETF	70.83	70.91	70.605	70.73	2059814.0
2013-06-26 10:30:00	QQQ	ETF	70.72	70.93	70.67	70.74	1283958.0
2013-06-26 11:00:00	QQQ	ETF	70.74	70.79	70.61	70.66	1829624.0
2013-06-26 11:30:00	QQQ	ETF	70.66	70.76	70.59	70.64	1517951.0
2013-06-26 12:00:00	QQQ	ETF	70.63	70.82	70.63	70.781	562386.0
2013-06-26 12:30:00	QQQ	ETF	70.79	70.83	70.7	70.71	1610828.0

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

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