PREVIEW / etf_30min / 2012-04-12

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-04-12.parquet
  size:    285 KB
  rows:    9,573

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-04-12 04:00:00	SPY	ETF	137.41	137.6	137.41	137.59	8102.0
2012-04-12 04:30:00	SPY	ETF	137.6	137.72	137.49	137.49	4758.0
2012-04-12 05:00:00	SPY	ETF	137.39	137.39	137.15	137.15	26475.0
2012-04-12 05:30:00	SPY	ETF	137.3	137.38	137.2	137.22	15340.0
2012-04-12 06:00:00	SPY	ETF	137.16	137.37	137.16	137.37	7400.0
2012-04-12 06:30:00	SPY	ETF	137.4	137.52	137.4	137.45	53879.0
2012-04-12 07:00:00	SPY	ETF	137.45	137.5	137.36	137.49	296926.0
2012-04-12 07:30:00	SPY	ETF	137.48	137.69	137.45	137.57	210586.0
2012-04-12 08:00:00	SPY	ETF	137.56	137.64	137.35	137.4	766778.0
2012-04-12 08:30:00	SPY	ETF	137.38	137.84	136.86	137.08	2144251.0
2012-04-12 09:00:00	SPY	ETF	137.06	137.16	136.96	137.13	894617.0
2012-04-12 09:30:00	SPY	ETF	137.13	137.87	137.03	137.815	23499407.0
2012-04-12 10:00:00	SPY	ETF	137.81	137.91	137.66	137.79	13317937.0
2012-04-12 10:30:00	SPY	ETF	137.79	138.32	137.78	138.23	13843887.0
2012-04-12 11:00:00	SPY	ETF	138.23	138.46	138.23	138.33	12016797.0
2012-04-12 11:30:00	SPY	ETF	138.33	138.41	138.2	138.37	7243866.0
2012-04-12 12:00:00	SPY	ETF	138.38	138.56	138.29	138.46	9036806.0
2012-04-12 12:30:00	SPY	ETF	138.47	138.72	138.46	138.66	8319748.0
2012-04-12 13:00:00	SPY	ETF	138.66	138.76	138.58	138.6007	5333238.0
2012-04-12 13:30:00	SPY	ETF	138.61	138.65	138.45	138.5	5744273.0
2012-04-12 14:00:00	SPY	ETF	138.5	138.68	138.49	138.62	5010127.0
2012-04-12 14:30:00	SPY	ETF	138.63	138.84	138.58	138.75	7999595.0
2012-04-12 15:00:00	SPY	ETF	138.76	138.78	138.63	138.655	7093546.0
2012-04-12 15:30:00	SPY	ETF	138.66	138.9	138.62	138.83	20923508.0
2012-04-12 16:00:00	SPY	ETF	138.81	139.12	138.2781	139.11	4951918.0
2012-04-12 16:30:00	SPY	ETF	139.08	139.11	138.827	138.98	1898929.0
2012-04-12 17:00:00	SPY	ETF	138.98	139.04	138.87	138.9	205302.0
2012-04-12 17:30:00	SPY	ETF	138.87	138.94	138.86	138.9	98296.0
2012-04-12 18:00:00	SPY	ETF	138.9	138.95	138.87	138.95	37538.0
2012-04-12 18:30:00	SPY	ETF	138.95	138.98	138.85	138.9	27170.0
2012-04-12 19:00:00	SPY	ETF	138.92	138.97	138.86	138.91	19297.0
2012-04-12 19:30:00	SPY	ETF	138.92	139.05	138.92	139.05	633640.0
2012-04-12 06:30:00	QQQ	ETF	66.73	66.73	66.73	66.73	10000.0
2012-04-12 07:00:00	QQQ	ETF	66.69	66.72	66.67	66.71	25925.0
2012-04-12 07:30:00	QQQ	ETF	66.72	66.83	66.72	66.82	8000.0
2012-04-12 08:00:00	QQQ	ETF	66.81	66.82	66.68	66.7	90281.0
2012-04-12 08:30:00	QQQ	ETF	66.7	66.75	66.46	66.57	418055.0
2012-04-12 09:00:00	QQQ	ETF	66.55	66.58	66.51	66.56	466037.0
2012-04-12 09:30:00	QQQ	ETF	66.56	66.921	66.4807	66.85	7326937.0
2012-04-12 10:00:00	QQQ	ETF	66.86	67.0	66.762	66.97	4400892.0
2012-04-12 10:30:00	QQQ	ETF	66.97	67.24	66.95	67.13	6323293.0
2012-04-12 11:00:00	QQQ	ETF	67.1329	67.26	67.13	67.18	5832598.0
2012-04-12 11:30:00	QQQ	ETF	67.18	67.22	67.095	67.1957	2117390.0
2012-04-12 12:00:00	QQQ	ETF	67.2	67.24	67.05	67.13	2431491.0
2012-04-12 12:30:00	QQQ	ETF	67.128	67.23	67.11	67.199	3756081.0
2012-04-12 13:00:00	QQQ	ETF	67.199	67.23	67.05	67.0875	1666325.0
2012-04-12 13:30:00	QQQ	ETF	67.09	67.125	66.96	67.02	3487116.0
2012-04-12 14:00:00	QQQ	ETF	67.01	67.13	67.01	67.09	1649625.0
2012-04-12 14:30:00	QQQ	ETF	67.09	67.26	67.065	67.2	2199155.0
2012-04-12 15:00:00	QQQ	ETF	67.2	67.2291	67.15	67.16	1305755.0

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

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