PREVIEW / etf_30min / 2012-11-28

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-11-28.parquet
  size:    292 KB
  rows:    9,713

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-11-28 04:00:00	SPY	ETF	140.26	140.26	140.12	140.12	6237.0
2012-11-28 04:30:00	SPY	ETF	140.13	140.13	140.13	140.13	200.0
2012-11-28 05:00:00	SPY	ETF	140.11	140.26	140.11	140.26	37500.0
2012-11-28 05:30:00	SPY	ETF	140.24	140.24	140.2	140.24	21100.0
2012-11-28 06:00:00	SPY	ETF	140.13	140.17	140.13	140.17	3400.0
2012-11-28 06:30:00	SPY	ETF	140.13	140.13	139.91	139.91	292350.0
2012-11-28 07:00:00	SPY	ETF	139.91	140.08	139.89	140.01	365186.0
2012-11-28 07:30:00	SPY	ETF	140.04	140.09	139.87	139.89	204512.0
2012-11-28 08:00:00	SPY	ETF	139.9	140.01	139.83	139.96	602173.0
2012-11-28 08:30:00	SPY	ETF	139.95	140.0	139.75	139.82	782588.0
2012-11-28 09:00:00	SPY	ETF	139.82	140.38	139.69	139.76	1032845.0
2012-11-28 09:30:00	SPY	ETF	139.76	139.77	139.41	139.56	16512378.0
2012-11-28 10:00:00	SPY	ETF	139.56	139.83	139.0	139.61	22447569.0
2012-11-28 10:30:00	SPY	ETF	139.61	140.34	139.58	140.09	16773287.0
2012-11-28 11:00:00	SPY	ETF	140.1	140.62	140.03	140.51	11452066.0
2012-11-28 11:30:00	SPY	ETF	140.5	140.54	140.22	140.3001	7577345.0
2012-11-28 12:00:00	SPY	ETF	140.3	140.86	139.95	140.78	16980448.0
2012-11-28 12:30:00	SPY	ETF	140.78	141.08	140.775	140.96	8851388.0
2012-11-28 13:00:00	SPY	ETF	140.95	140.95	140.67	140.829	5537901.0
2012-11-28 13:30:00	SPY	ETF	140.83	141.11	140.79	140.94	6910719.0
2012-11-28 14:00:00	SPY	ETF	140.93	141.04	140.75	140.79	5600930.0
2012-11-28 14:30:00	SPY	ETF	140.79	141.06	140.75	140.977	6520707.0
2012-11-28 15:00:00	SPY	ETF	140.975	141.32	140.92	141.3	8257971.0
2012-11-28 15:30:00	SPY	ETF	141.31	141.54	141.26	141.46	22670418.0
2012-11-28 16:00:00	SPY	ETF	141.48	141.5	140.3911	141.35	9597269.0
2012-11-28 16:30:00	SPY	ETF	141.34	141.477	140.391	140.3911	4178498.0
2012-11-28 17:00:00	SPY	ETF	141.36	141.38	141.315	141.34	1128219.0
2012-11-28 17:30:00	SPY	ETF	141.37	141.37	141.19	141.29	256739.0
2012-11-28 18:00:00	SPY	ETF	141.29	141.33	141.12	141.21	470182.0
2012-11-28 18:30:00	SPY	ETF	141.21	141.48	141.13	141.19	30237.0
2012-11-28 19:00:00	SPY	ETF	141.18	141.25	141.18	141.24	59010.0
2012-11-28 19:30:00	SPY	ETF	141.25	141.32	141.23	141.3	60185.0
2012-11-28 04:00:00	QQQ	ETF	64.88	64.88	64.82	64.82	1656.0
2012-11-28 06:00:00	QQQ	ETF	64.85	64.85	64.85	64.85	100.0
2012-11-28 07:00:00	QQQ	ETF	64.8	64.85	64.79	64.85	3400.0
2012-11-28 07:30:00	QQQ	ETF	64.85	64.85	64.77	64.77	53500.0
2012-11-28 08:00:00	QQQ	ETF	64.79	64.82	64.75	64.8	76034.0
2012-11-28 08:30:00	QQQ	ETF	64.79	64.825	64.71	64.75	68898.0
2012-11-28 09:00:00	QQQ	ETF	64.74	64.78	64.63	64.67	157180.0
2012-11-28 09:30:00	QQQ	ETF	64.66	64.68	64.44	64.54	4297901.0
2012-11-28 10:00:00	QQQ	ETF	64.54	64.75	64.25	64.67	4333211.0
2012-11-28 10:30:00	QQQ	ETF	64.6699	64.97	64.66	64.848	3596606.0
2012-11-28 11:00:00	QQQ	ETF	64.85	65.1	64.82	65.0	2877063.0
2012-11-28 11:30:00	QQQ	ETF	65.0	65.01	64.9	64.96	1213528.0
2012-11-28 12:00:00	QQQ	ETF	64.95	65.16	64.78	65.13	2856113.0
2012-11-28 12:30:00	QQQ	ETF	65.135	65.29	65.13	65.23	1704982.0
2012-11-28 13:00:00	QQQ	ETF	65.24	65.24	65.1201	65.19	872317.0
2012-11-28 13:30:00	QQQ	ETF	65.19	65.39	65.182	65.27	1683152.0
2012-11-28 14:00:00	QQQ	ETF	65.27	65.32	65.162	65.2	1567359.0
2012-11-28 14:30:00	QQQ	ETF	65.206	65.32	65.19	65.28	1312334.0

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

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