PREVIEW / etf_30min / 2012-02-13

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-02-13.parquet
  size:    288 KB
  rows:    9,679

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-02-13 04:00:00	SPY	ETF	135.27	135.58	135.27	135.3	26511.0
2012-02-13 04:30:00	SPY	ETF	135.29	135.38	135.29	135.38	80090.0
2012-02-13 05:00:00	SPY	ETF	135.35	135.35	135.22	135.22	1300.0
2012-02-13 05:30:00	SPY	ETF	135.37	135.46	135.32	135.34	6900.0
2012-02-13 06:00:00	SPY	ETF	135.48	135.48	135.39	135.39	2800.0
2012-02-13 06:30:00	SPY	ETF	135.35	135.46	135.32	135.34	42625.0
2012-02-13 07:00:00	SPY	ETF	135.35	135.46	135.31	135.45	159455.0
2012-02-13 07:30:00	SPY	ETF	135.47	135.55	135.39	135.5	216372.0
2012-02-13 08:00:00	SPY	ETF	135.52	135.55	135.3	135.39	445432.0
2012-02-13 08:30:00	SPY	ETF	135.37	135.43	135.25	135.33	820549.0
2012-02-13 09:00:00	SPY	ETF	135.32	135.41	134.43	135.32	783885.0
2012-02-13 09:30:00	SPY	ETF	135.32	135.45	135.04	135.17	16672151.0
2012-02-13 10:00:00	SPY	ETF	135.17	135.27	134.89	134.98	10458715.0
2012-02-13 10:30:00	SPY	ETF	134.98	135.07	134.74	135.0374	11749212.0
2012-02-13 11:00:00	SPY	ETF	135.04	135.13	134.98	135.03	8740689.0
2012-02-13 11:30:00	SPY	ETF	135.04	135.21	135.01	135.14	5568464.0
2012-02-13 12:00:00	SPY	ETF	135.14	135.22	135.08	135.08	3190767.0
2012-02-13 12:30:00	SPY	ETF	135.08	135.19	134.955	135.17	3946284.0
2012-02-13 13:00:00	SPY	ETF	135.18	135.35	135.17	135.27	6412374.0
2012-02-13 13:30:00	SPY	ETF	135.27	135.41	135.24	135.32	4432980.0
2012-02-13 14:00:00	SPY	ETF	135.32	135.44	135.3	135.39	3517273.0
2012-02-13 14:30:00	SPY	ETF	135.3999	135.52	135.37	135.42	6039973.0
2012-02-13 15:00:00	SPY	ETF	135.42	135.46	135.33	135.4	5662201.0
2012-02-13 15:30:00	SPY	ETF	135.39	135.43	135.22	135.33	16393589.0
2012-02-13 16:00:00	SPY	ETF	135.35	135.44	134.4272	135.38	7881005.0
2012-02-13 16:30:00	SPY	ETF	135.38	135.41	135.2765	135.36	353918.0
2012-02-13 17:00:00	SPY	ETF	135.36	135.4	135.35	135.35	141075.0
2012-02-13 17:30:00	SPY	ETF	135.36	135.38	135.26	135.28	144955.0
2012-02-13 18:00:00	SPY	ETF	135.28	135.28	135.05	135.09	403787.0
2012-02-13 18:30:00	SPY	ETF	135.08	135.13	135.01	135.08	91890.0
2012-02-13 19:00:00	SPY	ETF	135.07	135.2	135.06	135.19	91605.0
2012-02-13 19:30:00	SPY	ETF	135.19	135.23	135.17	135.21	63540.0
2012-02-13 04:30:00	QQQ	ETF	62.95	62.95	62.95	62.95	500.0
2012-02-13 05:00:00	QQQ	ETF	62.9	62.9	62.9	62.9	100.0
2012-02-13 05:30:00	QQQ	ETF	62.95	62.95	62.95	62.95	100.0
2012-02-13 06:00:00	QQQ	ETF	62.98	62.98	62.98	62.98	900.0
2012-02-13 06:30:00	QQQ	ETF	62.97	62.98	62.94	62.94	15600.0
2012-02-13 07:00:00	QQQ	ETF	62.94	63.03	62.93	63.03	31925.0
2012-02-13 07:30:00	QQQ	ETF	63.02	63.05	62.99	63.01	35035.0
2012-02-13 08:00:00	QQQ	ETF	63.03	63.05	62.94	62.96	75802.0
2012-02-13 08:30:00	QQQ	ETF	62.95	62.99	62.9	62.95	274128.0
2012-02-13 09:00:00	QQQ	ETF	62.94	62.97	62.9	62.94	369443.0
2012-02-13 09:30:00	QQQ	ETF	62.93	63.0	62.84	62.961	4379002.0
2012-02-13 10:00:00	QQQ	ETF	62.97	63.04	62.79	62.81	3621759.0
2012-02-13 10:30:00	QQQ	ETF	62.8178	62.82	62.65	62.78	3115511.0
2012-02-13 11:00:00	QQQ	ETF	62.785	62.88	62.77	62.806	3053047.0
2012-02-13 11:30:00	QQQ	ETF	62.8098	62.98	62.806	62.93	2730192.0
2012-02-13 12:00:00	QQQ	ETF	62.92	62.99	62.85	62.8501	1079218.0
2012-02-13 12:30:00	QQQ	ETF	62.85	62.9	62.78	62.89	1648276.0
2012-02-13 13:00:00	QQQ	ETF	62.9	62.98	62.9	62.9305	1047452.0

> showing 50 of 9,679 rows — these rows as CSV

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