PREVIEW / etf_30min / 2012-03-26

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-03-26.parquet
  size:    290 KB
  rows:    9,816

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-03-26 04:00:00	SPY	ETF	140.03	140.03	139.88	139.88	640.0
2012-03-26 04:30:00	SPY	ETF	139.81	139.81	139.81	139.81	3500.0
2012-03-26 05:00:00	SPY	ETF	139.81	139.86	139.78	139.86	900.0
2012-03-26 05:30:00	SPY	ETF	139.95	140.11	139.95	140.11	20490.0
2012-03-26 06:00:00	SPY	ETF	140.07	140.23	140.07	140.22	5700.0
2012-03-26 06:30:00	SPY	ETF	140.26	140.33	140.2	140.2	12015.0
2012-03-26 07:00:00	SPY	ETF	140.2	140.46	140.2	140.28	203300.0
2012-03-26 07:30:00	SPY	ETF	140.27	140.41	140.27	140.28	93616.0
2012-03-26 08:00:00	SPY	ETF	140.28	140.85	140.27	140.79	1299899.0
2012-03-26 08:30:00	SPY	ETF	140.8	140.83	140.65	140.71	464841.0
2012-03-26 09:00:00	SPY	ETF	140.7	140.81	140.61	140.65	945889.0
2012-03-26 09:30:00	SPY	ETF	140.65	140.84	140.6	140.8	12910763.0
2012-03-26 10:00:00	SPY	ETF	140.81	141.11	140.71	141.01	11068494.0
2012-03-26 10:30:00	SPY	ETF	141.01	141.03	140.93	141.02	4528628.0
2012-03-26 11:00:00	SPY	ETF	141.015	141.03	140.9	140.95	7131761.0
2012-03-26 11:30:00	SPY	ETF	140.955	141.03	140.92	140.93	3583507.0
2012-03-26 12:00:00	SPY	ETF	140.93	140.97	140.82	140.85	3326177.0
2012-03-26 12:30:00	SPY	ETF	140.85	140.9	140.79	140.84	4331373.0
2012-03-26 13:00:00	SPY	ETF	140.84	140.97	140.82	140.94	3227667.0
2012-03-26 13:30:00	SPY	ETF	140.93	141.06	140.93	141.0	3589784.0
2012-03-26 14:00:00	SPY	ETF	140.999	141.23	140.99	141.16	5528868.0
2012-03-26 14:30:00	SPY	ETF	141.17	141.33	141.09	141.251	6527547.0
2012-03-26 15:00:00	SPY	ETF	141.255	141.5	141.21	141.385	11828553.0
2012-03-26 15:30:00	SPY	ETF	141.38	141.57	141.26	141.56	22560765.0
2012-03-26 16:00:00	SPY	ETF	141.56	141.99	139.5989	141.91	10903982.0
2012-03-26 16:30:00	SPY	ETF	141.91	141.94	141.86	141.91	2387843.0
2012-03-26 17:00:00	SPY	ETF	141.91	142.04	141.89	141.93	256084.0
2012-03-26 17:30:00	SPY	ETF	141.96	141.99	141.9	141.91	116198.0
2012-03-26 18:00:00	SPY	ETF	141.91	141.98	141.91	141.97	300610.0
2012-03-26 18:30:00	SPY	ETF	141.96	142.05	141.95	142.01	114055.0
2012-03-26 19:00:00	SPY	ETF	142.01	142.05	141.96	142.03	146206.0
2012-03-26 19:30:00	SPY	ETF	141.98	142.02	141.96	141.97	138749.0
2012-03-26 06:00:00	QQQ	ETF	67.2	67.27	67.2	67.27	985.0
2012-03-26 06:30:00	QQQ	ETF	67.28	67.28	67.28	67.28	1200.0
2012-03-26 07:00:00	QQQ	ETF	67.3	67.35	67.3	67.31	11450.0
2012-03-26 07:30:00	QQQ	ETF	67.3	67.36	67.28	67.28	32676.0
2012-03-26 08:00:00	QQQ	ETF	67.28	67.51	67.27	67.45	187160.0
2012-03-26 08:30:00	QQQ	ETF	67.46	67.47	67.41	67.42	133947.0
2012-03-26 09:00:00	QQQ	ETF	67.42	67.47	67.37	67.38	223956.0
2012-03-26 09:30:00	QQQ	ETF	67.37	67.47	67.33	67.46	5135856.0
2012-03-26 10:00:00	QQQ	ETF	67.45	67.6	67.4	67.54	3335100.0
2012-03-26 10:30:00	QQQ	ETF	67.54	67.6	67.5	67.59	2081785.0
2012-03-26 11:00:00	QQQ	ETF	67.58	67.65	67.54	67.62	3101394.0
2012-03-26 11:30:00	QQQ	ETF	67.63	67.68	67.62	67.64	1924582.0
2012-03-26 12:00:00	QQQ	ETF	67.64	67.66	67.59	67.61	1098759.0
2012-03-26 12:30:00	QQQ	ETF	67.62	67.67	67.58	67.6333	1805139.0
2012-03-26 13:00:00	QQQ	ETF	67.635	67.71	67.61	67.7	493875.0
2012-03-26 13:30:00	QQQ	ETF	67.6986	67.82	67.68	67.792	2265997.0
2012-03-26 14:00:00	QQQ	ETF	67.792	67.97	67.79	67.94	2444100.0
2012-03-26 14:30:00	QQQ	ETF	67.94	67.95	67.85	67.9179	2294542.0

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

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