PREVIEW / etf_30min / 2012-05-04

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-05-04.parquet
  size:    288 KB
  rows:    9,672

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-05-04 04:00:00	SPY	ETF	139.25	139.25	139.08	139.08	1750.0
2012-05-04 04:30:00	SPY	ETF	138.97	138.97	138.97	138.97	100.0
2012-05-04 05:00:00	SPY	ETF	138.89	139.08	138.89	139.07	5800.0
2012-05-04 05:30:00	SPY	ETF	139.06	139.06	138.95	138.95	950.0
2012-05-04 06:00:00	SPY	ETF	138.91	139.02	138.91	139.02	3450.0
2012-05-04 06:30:00	SPY	ETF	139.05	139.36	139.05	139.36	7600.0
2012-05-04 07:00:00	SPY	ETF	139.35	139.4	139.16	139.2	86700.0
2012-05-04 07:30:00	SPY	ETF	139.21	139.22	139.03	139.1	220061.0
2012-05-04 08:00:00	SPY	ETF	139.1	139.28	138.55	139.05	2909060.0
2012-05-04 08:30:00	SPY	ETF	139.05	139.43	138.36	138.77	6480376.0
2012-05-04 09:00:00	SPY	ETF	138.77	138.86	138.46	138.51	3048492.0
2012-05-04 09:30:00	SPY	ETF	138.515	138.66	137.97	138.08	22882158.0
2012-05-04 10:00:00	SPY	ETF	138.07	138.11	137.73	137.85	15004921.0
2012-05-04 10:30:00	SPY	ETF	137.85	137.87	137.51	137.825	14383813.0
2012-05-04 11:00:00	SPY	ETF	137.82	137.84	137.46	137.54	11269218.0
2012-05-04 11:30:00	SPY	ETF	137.54	137.7667	137.12	137.165	12815000.0
2012-05-04 12:00:00	SPY	ETF	137.16	137.4	137.09	137.185	8692262.0
2012-05-04 12:30:00	SPY	ETF	137.18	137.2	136.93	137.2	7731227.0
2012-05-04 13:00:00	SPY	ETF	137.2	139.3012	137.09	137.24	7918474.0
2012-05-04 13:30:00	SPY	ETF	137.24	137.39	137.2	137.344	8080376.0
2012-05-04 14:00:00	SPY	ETF	137.345	137.35	137.17	137.25	5740589.0
2012-05-04 14:30:00	SPY	ETF	137.2485	137.251	136.92	137.15	10372368.0
2012-05-04 15:00:00	SPY	ETF	137.16	137.32	137.09	137.13	8617818.0
2012-05-04 15:30:00	SPY	ETF	137.13	137.39	137.0	137.0	23619294.0
2012-05-04 16:00:00	SPY	ETF	137.02	139.3012	136.7	136.8	13275263.0
2012-05-04 16:30:00	SPY	ETF	136.81	139.3012	136.73	136.83	8632734.0
2012-05-04 17:00:00	SPY	ETF	136.85	136.86	136.78	136.78	302247.0
2012-05-04 17:30:00	SPY	ETF	136.78	136.79	136.62	136.65	323685.0
2012-05-04 18:00:00	SPY	ETF	136.64	136.68	136.48	136.5	175271.0
2012-05-04 18:30:00	SPY	ETF	136.5	136.55	136.32	136.32	153988.0
2012-05-04 19:00:00	SPY	ETF	136.32	136.45	136.27	136.4	66860.0
2012-05-04 19:30:00	SPY	ETF	136.4	136.51	136.4	136.48	38831.0
2012-05-04 07:00:00	QQQ	ETF	66.25	66.28	66.2	66.22	15500.0
2012-05-04 07:30:00	QQQ	ETF	66.21	66.21	66.1	66.12	139605.0
2012-05-04 08:00:00	QQQ	ETF	66.13	66.25	65.97	66.25	3736642.0
2012-05-04 08:30:00	QQQ	ETF	66.05	66.27	65.85	65.96	2710689.0
2012-05-04 09:00:00	QQQ	ETF	65.96	65.99	65.74	65.75	3046376.0
2012-05-04 09:30:00	QQQ	ETF	65.75	65.83	65.43	65.4896	14389359.0
2012-05-04 10:00:00	QQQ	ETF	65.48	65.4905	65.23	65.26	8221153.0
2012-05-04 10:30:00	QQQ	ETF	65.26	65.42	65.15	65.4	5662995.0
2012-05-04 11:00:00	QQQ	ETF	65.39	65.4099	65.07	65.12	6551057.0
2012-05-04 11:30:00	QQQ	ETF	65.115	65.14	64.94	65.02	5732948.0
2012-05-04 12:00:00	QQQ	ETF	65.01	65.12	64.89	64.913	3101843.0
2012-05-04 12:30:00	QQQ	ETF	64.91	64.98	64.79	64.94	3104693.0
2012-05-04 13:00:00	QQQ	ETF	64.94	64.98	64.84	64.92	2878365.0
2012-05-04 13:30:00	QQQ	ETF	64.93	65.01	64.908	64.96	4322660.0
2012-05-04 14:00:00	QQQ	ETF	64.96	64.96	64.86	64.91	3085676.0
2012-05-04 14:30:00	QQQ	ETF	64.911	64.94	64.735	64.83	3714183.0
2012-05-04 15:00:00	QQQ	ETF	64.839	64.91	64.7918	64.82	3228610.0
2012-05-04 15:30:00	QQQ	ETF	64.8285	64.97	64.7	64.71	8110486.0

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

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