PREVIEW / etf_30min / 2013-07-22

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-22.parquet
  size:    312 KB
  rows:    10,741

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
2013-07-22 04:00:00	SPY	ETF	169.35	169.49	169.35	169.48	1300.0
2013-07-22 04:30:00	SPY	ETF	169.5	169.7	169.5	169.67	7500.0
2013-07-22 05:00:00	SPY	ETF	169.64	169.65	169.58	169.65	3280.0
2013-07-22 05:30:00	SPY	ETF	169.61	169.64	169.59	169.59	1800.0
2013-07-22 06:00:00	SPY	ETF	169.63	169.63	169.52	169.52	74700.0
2013-07-22 06:30:00	SPY	ETF	169.55	169.58	169.42	169.48	22000.0
2013-07-22 07:00:00	SPY	ETF	169.48	169.54	169.44	169.54	55000.0
2013-07-22 07:30:00	SPY	ETF	169.55	169.65	169.47	169.49	149490.0
2013-07-22 08:00:00	SPY	ETF	169.52	169.62	169.33	169.44	196115.0
2013-07-22 08:30:00	SPY	ETF	169.44	169.5	169.35	169.4	275537.0
2013-07-22 09:00:00	SPY	ETF	169.4	169.44	169.21	169.4	536121.0
2013-07-22 09:30:00	SPY	ETF	169.41	169.48	169.06	169.09	11198065.0
2013-07-22 10:00:00	SPY	ETF	169.1	169.38	169.01	169.245	8132430.0
2013-07-22 10:30:00	SPY	ETF	169.25	169.44	169.15	169.37	6206579.0
2013-07-22 11:00:00	SPY	ETF	169.37	169.67	169.36	169.63	4965778.0
2013-07-22 11:30:00	SPY	ETF	169.63	169.74	169.46	169.48	6455049.0
2013-07-22 12:00:00	SPY	ETF	169.48	169.55	169.45	169.53	2791995.0
2013-07-22 12:30:00	SPY	ETF	169.54	169.62	169.46	169.54	2771752.0
2013-07-22 13:00:00	SPY	ETF	169.5366	169.58	169.35	169.39	3846090.0
2013-07-22 13:30:00	SPY	ETF	169.4	169.42	169.24	169.36	2347768.0
2013-07-22 14:00:00	SPY	ETF	169.355	169.49	169.31	169.4	2854041.0
2013-07-22 14:30:00	SPY	ETF	169.4	169.59	169.38	169.58	3386314.0
2013-07-22 15:00:00	SPY	ETF	169.58	169.59	169.48	169.53	3492237.0
2013-07-22 15:30:00	SPY	ETF	169.52	169.53	169.28	169.5	8151101.0
2013-07-22 16:00:00	SPY	ETF	169.5	169.55	169.03	169.46	4871516.0
2013-07-22 16:30:00	SPY	ETF	169.47	169.5	169.42	169.5	350878.0
2013-07-22 17:00:00	SPY	ETF	169.51	169.54	169.49	169.5	1323246.0
2013-07-22 17:30:00	SPY	ETF	169.5	169.55	169.49	169.52	4654.0
2013-07-22 18:00:00	SPY	ETF	169.5	169.6	169.49	169.6	49705.0
2013-07-22 18:30:00	SPY	ETF	169.58	169.66	169.58	169.64	61618.0
2013-07-22 19:00:00	SPY	ETF	169.61	169.63	169.6	169.6	2413.0
2013-07-22 19:30:00	SPY	ETF	169.6	169.61	169.58	169.6	7774.0
2013-07-22 04:00:00	QQQ	ETF	74.7	74.72	74.7	74.72	1200.0
2013-07-22 04:30:00	QQQ	ETF	74.74	74.84	74.74	74.82	4300.0
2013-07-22 05:00:00	QQQ	ETF	74.8	74.8	74.8	74.8	600.0
2013-07-22 05:30:00	QQQ	ETF	74.8	74.8	74.8	74.8	250.0
2013-07-22 06:00:00	QQQ	ETF	74.78	74.78	74.74	74.74	2300.0
2013-07-22 06:30:00	QQQ	ETF	74.76	74.76	74.7	74.7	2500.0
2013-07-22 07:00:00	QQQ	ETF	74.72	74.74	74.71	74.74	4495.0
2013-07-22 07:30:00	QQQ	ETF	74.75	74.78	74.74	74.74	12400.0
2013-07-22 08:00:00	QQQ	ETF	74.75	74.75	74.64	74.68	30600.0
2013-07-22 08:30:00	QQQ	ETF	74.7	74.72	74.67	74.7	14018.0
2013-07-22 09:00:00	QQQ	ETF	74.7	74.88	74.59	74.86	1448896.0
2013-07-22 09:30:00	QQQ	ETF	74.87	74.98	74.58	74.6	4358431.0
2013-07-22 10:00:00	QQQ	ETF	74.6	74.78	74.59	74.73	1744183.0
2013-07-22 10:30:00	QQQ	ETF	74.73	74.83	74.7	74.77	1201936.0
2013-07-22 11:00:00	QQQ	ETF	74.77	74.86	74.77	74.83	1180585.0
2013-07-22 11:30:00	QQQ	ETF	74.83	74.9	74.79	74.79	905439.0
2013-07-22 12:00:00	QQQ	ETF	74.79	74.87	74.78	74.86	998479.0
2013-07-22 12:30:00	QQQ	ETF	74.86	74.872	74.81	74.82	493289.0

> showing 50 of 10,741 rows — these rows as CSV

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