PREVIEW / etf_30min / 2012-12-28

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-12-28.parquet
  size:    303 KB
  rows:    10,278

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-12-28 04:00:00	SPY	ETF	141.94	141.94	141.33	141.38	3200.0
2012-12-28 04:30:00	SPY	ETF	141.32	141.32	141.3	141.3	5900.0
2012-12-28 05:00:00	SPY	ETF	141.2	141.24	141.2	141.24	600.0
2012-12-28 05:30:00	SPY	ETF	141.1	141.1	141.03	141.03	10400.0
2012-12-28 06:00:00	SPY	ETF	141.05	141.05	141.0	141.04	8700.0
2012-12-28 06:30:00	SPY	ETF	140.89	140.95	140.83	140.95	11100.0
2012-12-28 07:00:00	SPY	ETF	140.92	140.93	140.75	140.82	58390.0
2012-12-28 07:30:00	SPY	ETF	140.85	140.85	140.5	140.58	178058.0
2012-12-28 08:00:00	SPY	ETF	140.59	140.89	140.31	140.53	926448.0
2012-12-28 08:30:00	SPY	ETF	140.53	140.71	140.52	140.59	1102835.0
2012-12-28 09:00:00	SPY	ETF	140.57	140.68	140.41	140.61	1147454.0
2012-12-28 09:30:00	SPY	ETF	140.64	140.89	140.47	140.6801	11292361.0
2012-12-28 10:00:00	SPY	ETF	140.68	140.94	140.35	140.68	11042267.0
2012-12-28 10:30:00	SPY	ETF	140.68	141.42	140.64	141.04	16613117.0
2012-12-28 11:00:00	SPY	ETF	141.03	141.17	140.82	140.84	7174671.0
2012-12-28 11:30:00	SPY	ETF	140.83	140.97	140.73	140.91	6898544.0
2012-12-28 12:00:00	SPY	ETF	140.92	141.12	140.87	141.07	4883570.0
2012-12-28 12:30:00	SPY	ETF	141.06	141.12	140.88	140.9	3221663.0
2012-12-28 13:00:00	SPY	ETF	140.91	141.04	140.89	140.93	2848736.0
2012-12-28 13:30:00	SPY	ETF	140.94	141.04	140.76	140.82	3835582.0
2012-12-28 14:00:00	SPY	ETF	140.81	140.86	140.62	140.68	4642571.0
2012-12-28 14:30:00	SPY	ETF	140.68	140.775	140.58	140.665	4262367.0
2012-12-28 15:00:00	SPY	ETF	140.65	140.87	140.54	140.711	8859549.0
2012-12-28 15:30:00	SPY	ETF	140.715	140.86	139.91	139.95	34142227.0
2012-12-28 16:00:00	SPY	ETF	139.94	141.5899	138.55	138.87	13302308.0
2012-12-28 16:30:00	SPY	ETF	138.86	139.09	138.79	138.83	5489768.0
2012-12-28 17:00:00	SPY	ETF	138.83	141.5899	138.83	139.11	1618930.0
2012-12-28 17:30:00	SPY	ETF	139.14	139.32	139.03	139.3	972263.0
2012-12-28 18:00:00	SPY	ETF	139.29	139.34	139.23	139.29	317007.0
2012-12-28 18:30:00	SPY	ETF	139.29	139.29	139.23	139.23	151177.0
2012-12-28 19:00:00	SPY	ETF	139.23	139.25	139.1	139.2	121344.0
2012-12-28 19:30:00	SPY	ETF	139.22	139.3	139.18	139.3	60291.0
2012-12-28 04:00:00	QQQ	ETF	64.28	64.28	64.28	64.28	100.0
2012-12-28 06:00:00	QQQ	ETF	64.17	64.17	64.1	64.1	600.0
2012-12-28 06:30:00	QQQ	ETF	64.06	64.06	64.06	64.06	1100.0
2012-12-28 07:00:00	QQQ	ETF	64.02	64.08	64.02	64.08	12100.0
2012-12-28 07:30:00	QQQ	ETF	64.12	64.12	63.93	63.98	21199.0
2012-12-28 08:00:00	QQQ	ETF	63.99	63.99	63.89	63.95	30000.0
2012-12-28 08:30:00	QQQ	ETF	63.95	64.4441	63.94	63.95	349860.0
2012-12-28 09:00:00	QQQ	ETF	63.95	63.97	63.9	63.92	196943.0
2012-12-28 09:30:00	QQQ	ETF	63.94	64.2	63.91	64.1	4343975.0
2012-12-28 10:00:00	QQQ	ETF	64.1	64.22	63.94	64.11	2566829.0
2012-12-28 10:30:00	QQQ	ETF	64.118	64.43	64.09	64.3	3824578.0
2012-12-28 11:00:00	QQQ	ETF	64.3	64.37	64.18	64.19	1618963.0
2012-12-28 11:30:00	QQQ	ETF	64.19	64.22	64.13	64.1716	1094100.0
2012-12-28 12:00:00	QQQ	ETF	64.17	64.28	64.15	64.26	1058494.0
2012-12-28 12:30:00	QQQ	ETF	64.26	64.2799	64.161	64.18	934918.0
2012-12-28 13:00:00	QQQ	ETF	64.1761	64.24	64.16	64.21	756766.0
2012-12-28 13:30:00	QQQ	ETF	64.2	64.26	64.125	64.155	1735864.0
2012-12-28 14:00:00	QQQ	ETF	64.16	64.178	64.06	64.08	2827718.0

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

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