PREVIEW / etf_30min / 2012-06-07

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-06-07.parquet
  size:    288 KB
  rows:    9,812

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-06-07 04:00:00	SPY	ETF	132.3	132.3	132.24	132.24	500.0
2012-06-07 04:30:00	SPY	ETF	132.46	132.46	132.36	132.39	1300.0
2012-06-07 05:00:00	SPY	ETF	132.49	132.64	132.49	132.56	2863.0
2012-06-07 05:30:00	SPY	ETF	132.51	132.56	132.44	132.51	14434.0
2012-06-07 06:00:00	SPY	ETF	132.44	132.49	132.33	132.33	59881.0
2012-06-07 06:30:00	SPY	ETF	132.32	132.6	132.2	132.58	167014.0
2012-06-07 07:00:00	SPY	ETF	132.61	133.51	132.56	133.18	1727867.0
2012-06-07 07:30:00	SPY	ETF	133.15	133.26	133.0	133.2	562679.0
2012-06-07 08:00:00	SPY	ETF	133.18	133.3	132.48	133.1	1410766.0
2012-06-07 08:30:00	SPY	ETF	133.1	133.21	132.96	132.97	1442126.0
2012-06-07 09:00:00	SPY	ETF	133.01	133.53	132.97	133.48	3651014.0
2012-06-07 09:30:00	SPY	ETF	133.47	133.53	133.2	133.3	26130527.0
2012-06-07 10:00:00	SPY	ETF	133.29	133.39	132.46	132.92	28563415.0
2012-06-07 10:30:00	SPY	ETF	132.92	132.96	132.26	132.49	13516629.0
2012-06-07 11:00:00	SPY	ETF	132.49	132.67	132.28	132.45	11478058.0
2012-06-07 11:30:00	SPY	ETF	132.45	132.84	132.35	132.66	9159136.0
2012-06-07 12:00:00	SPY	ETF	132.655	132.96	132.46	132.77	12331866.0
2012-06-07 12:30:00	SPY	ETF	132.78	132.82	132.56	132.6909	7637628.0
2012-06-07 13:00:00	SPY	ETF	132.7	133.09	132.64	133.03	6206928.0
2012-06-07 13:30:00	SPY	ETF	133.03	133.07	132.73	132.77	8217016.0
2012-06-07 14:00:00	SPY	ETF	132.76	132.92	132.64	132.875	4404627.0
2012-06-07 14:30:00	SPY	ETF	132.87	132.92	132.74	132.84	5203335.0
2012-06-07 15:00:00	SPY	ETF	132.84	132.84	132.35	132.4299	9339987.0
2012-06-07 15:30:00	SPY	ETF	132.42	132.48	131.78	132.02	19756081.0
2012-06-07 16:00:00	SPY	ETF	132.02	132.7413	131.9603	132.2	9891086.0
2012-06-07 16:30:00	SPY	ETF	132.2	132.6212	132.0198	132.25	1287957.0
2012-06-07 17:00:00	SPY	ETF	132.25	132.35	132.22	132.22	188841.0
2012-06-07 17:30:00	SPY	ETF	132.24	132.34	132.17	132.21	47810.0
2012-06-07 18:00:00	SPY	ETF	132.21	132.28	132.18	132.24	31637.0
2012-06-07 18:30:00	SPY	ETF	132.24	132.32	132.24	132.29	29575.0
2012-06-07 19:00:00	SPY	ETF	132.29	132.34	132.28	132.34	62793.0
2012-06-07 19:30:00	SPY	ETF	132.32	132.35	132.22	132.23	51293.0
2012-06-07 04:00:00	QQQ	ETF	62.74	62.74	62.74	62.74	300.0
2012-06-07 04:30:00	QQQ	ETF	62.67	62.7	62.67	62.7	2700.0
2012-06-07 05:30:00	QQQ	ETF	62.79	62.79	62.79	62.79	100.0
2012-06-07 06:30:00	QQQ	ETF	62.77	62.84	62.71	62.84	9140.0
2012-06-07 07:00:00	QQQ	ETF	62.85	63.09	62.85	63.05	40908.0
2012-06-07 07:30:00	QQQ	ETF	63.06	63.12	63.02	63.1	16565.0
2012-06-07 08:00:00	QQQ	ETF	63.1	63.13	62.78	63.02	341686.0
2012-06-07 08:30:00	QQQ	ETF	63.05	63.07	62.96	62.97	162844.0
2012-06-07 09:00:00	QQQ	ETF	62.98	63.18	62.95	63.16	316475.0
2012-06-07 09:30:00	QQQ	ETF	63.15	63.18	62.93	63.01	5791697.0
2012-06-07 10:00:00	QQQ	ETF	63.005	63.04	62.68	62.87	6709218.0
2012-06-07 10:30:00	QQQ	ETF	62.87	62.9	62.479	62.59	2961897.0
2012-06-07 11:00:00	QQQ	ETF	62.5995	62.73	62.54	62.6	2238679.0
2012-06-07 11:30:00	QQQ	ETF	62.61	62.81	62.55	62.7	1543791.0
2012-06-07 12:00:00	QQQ	ETF	62.69	62.84	62.58	62.75	2542805.0
2012-06-07 12:30:00	QQQ	ETF	62.75	62.79	62.64	62.72	1441635.0
2012-06-07 13:00:00	QQQ	ETF	62.72	62.9	62.7	62.86	1413968.0
2012-06-07 13:30:00	QQQ	ETF	62.862	62.88	62.64	62.66	1270557.0

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

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