PREVIEW / etf_30min / 2013-01-07

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-01-07.parquet
  size:    307 KB
  rows:    10,589

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-01-07 04:00:00	SPY	ETF	146.03	146.03	145.9	145.94	2900.0
2013-01-07 04:30:00	SPY	ETF	146.01	146.01	145.92	145.92	3708.0
2013-01-07 05:00:00	SPY	ETF	145.94	145.94	145.94	145.94	100.0
2013-01-07 05:30:00	SPY	ETF	145.96	145.96	145.95	145.96	28450.0
2013-01-07 06:00:00	SPY	ETF	145.96	145.98	145.92	145.92	39950.0
2013-01-07 06:30:00	SPY	ETF	145.91	145.91	145.87	145.91	164249.0
2013-01-07 07:00:00	SPY	ETF	145.88	146.04	145.88	146.0	26719.0
2013-01-07 07:30:00	SPY	ETF	145.99	146.04	145.92	145.96	188540.0
2013-01-07 08:00:00	SPY	ETF	145.99	146.02	145.92	145.96	253508.0
2013-01-07 08:30:00	SPY	ETF	145.96	145.99	145.83	145.85	209835.0
2013-01-07 09:00:00	SPY	ETF	145.85	145.88	145.76	145.86	1198749.0
2013-01-07 09:30:00	SPY	ETF	145.85	145.89	145.59	145.75	13477689.0
2013-01-07 10:00:00	SPY	ETF	145.75	145.93	145.725	145.889	6802244.0
2013-01-07 10:30:00	SPY	ETF	145.889	145.98	145.8	145.811	5725635.0
2013-01-07 11:00:00	SPY	ETF	145.81	145.9	145.76	145.84	4185433.0
2013-01-07 11:30:00	SPY	ETF	145.84	145.91	145.54	145.58	5322963.0
2013-01-07 12:00:00	SPY	ETF	145.57	145.62	145.43	145.52	5457408.0
2013-01-07 12:30:00	SPY	ETF	145.515	145.62	145.49	145.5399	5783791.0
2013-01-07 13:00:00	SPY	ETF	145.54	145.68	145.54	145.68	4909213.0
2013-01-07 13:30:00	SPY	ETF	145.67	145.68	145.48	145.59	4719125.0
2013-01-07 14:00:00	SPY	ETF	145.59	145.8	145.58	145.789	4007776.0
2013-01-07 14:30:00	SPY	ETF	145.79	145.88	145.76	145.87	4390198.0
2013-01-07 15:00:00	SPY	ETF	145.87	146.4442	145.8	146.035	5218349.0
2013-01-07 15:30:00	SPY	ETF	146.04	146.4442	145.88	145.965	12151991.0
2013-01-07 16:00:00	SPY	ETF	145.97	146.4434	145.6184	145.94	17499570.0
2013-01-07 16:30:00	SPY	ETF	145.93	146.4442	145.92	145.99	2682030.0
2013-01-07 17:00:00	SPY	ETF	145.97	146.01	145.96	146.0	35108.0
2013-01-07 17:30:00	SPY	ETF	146.0	146.01	145.95	145.99	1043399.0
2013-01-07 18:00:00	SPY	ETF	146.0	146.01	145.96	145.96	70742.0
2013-01-07 18:30:00	SPY	ETF	145.96	145.96	145.93	145.93	5466.0
2013-01-07 19:00:00	SPY	ETF	145.92	145.93	145.87	145.89	31508.0
2013-01-07 19:30:00	SPY	ETF	145.9	146.0	145.89	146.0	31510.0
2013-01-07 04:00:00	QQQ	ETF	66.51	66.51	66.48	66.48	663.0
2013-01-07 05:30:00	QQQ	ETF	66.5	66.5	66.5	66.5	600.0
2013-01-07 07:00:00	QQQ	ETF	66.46	66.55	66.46	66.55	8100.0
2013-01-07 07:30:00	QQQ	ETF	66.5	66.5	66.42	66.42	6900.0
2013-01-07 08:00:00	QQQ	ETF	66.45	66.47	66.42	66.43	37215.0
2013-01-07 08:30:00	QQQ	ETF	66.41	66.41	66.36	66.4	102070.0
2013-01-07 09:00:00	QQQ	ETF	66.39	66.46	66.31	66.45	715767.0
2013-01-07 09:30:00	QQQ	ETF	66.45	66.46	66.25	66.3399	3708399.0
2013-01-07 10:00:00	QQQ	ETF	66.33	66.57	66.32	66.56	2142429.0
2013-01-07 10:30:00	QQQ	ETF	66.55	66.66	66.5	66.54	1589964.0
2013-01-07 11:00:00	QQQ	ETF	66.53	66.69	66.52	66.67	1705796.0
2013-01-07 11:30:00	QQQ	ETF	66.668	66.71	66.43	66.45	1946227.0
2013-01-07 12:00:00	QQQ	ETF	66.44	66.51	66.37	66.405	1063105.0
2013-01-07 12:30:00	QQQ	ETF	66.405	66.475	66.38	66.42	797794.0
2013-01-07 13:00:00	QQQ	ETF	66.43	66.5399	66.42	66.5205	607446.0
2013-01-07 13:30:00	QQQ	ETF	66.53	66.53	66.35	66.43	761529.0
2013-01-07 14:00:00	QQQ	ETF	66.42	66.58	66.42	66.57	944028.0
2013-01-07 14:30:00	QQQ	ETF	66.5637	66.6	66.51	66.57	827730.0

> showing 50 of 10,589 rows — these rows as CSV

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