PREVIEW / etf_30min / 2013-06-21

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-06-21.parquet
  size:    352 KB
  rows:    11,562

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-06-21 04:00:00	SPY	ETF	159.97	159.97	159.55	159.7	15564.0
2013-06-21 04:30:00	SPY	ETF	159.65	159.72	159.6	159.65	1250.0
2013-06-21 05:00:00	SPY	ETF	159.7	159.91	159.7	159.88	34950.0
2013-06-21 05:30:00	SPY	ETF	159.9	160.12	159.9	160.05	51345.0
2013-06-21 06:00:00	SPY	ETF	160.05	160.1	160.01	160.09	20058.0
2013-06-21 06:30:00	SPY	ETF	160.04	160.11	160.0	160.04	123051.0
2013-06-21 07:00:00	SPY	ETF	160.02	160.03	159.73	159.83	256475.0
2013-06-21 07:30:00	SPY	ETF	159.82	159.82	159.65	159.76	610021.0
2013-06-21 08:00:00	SPY	ETF	159.76	160.88	159.42	159.47	888828.0
2013-06-21 08:30:00	SPY	ETF	159.46	159.47	159.06	159.25	1972185.0
2013-06-21 09:00:00	SPY	ETF	159.24	159.83	159.2	159.65	3296575.0
2013-06-21 09:30:00	SPY	ETF	159.64	159.76	159.07	159.082	28855043.0
2013-06-21 10:00:00	SPY	ETF	159.09	159.7423	158.67	158.79	19633712.0
2013-06-21 10:30:00	SPY	ETF	158.8	159.62	158.25	158.779	21971786.0
2013-06-21 11:00:00	SPY	ETF	158.775	158.9	157.79	157.85	21743745.0
2013-06-21 11:30:00	SPY	ETF	157.845	157.955	157.47	157.72	20469394.0
2013-06-21 12:00:00	SPY	ETF	157.72	158.19	157.585	157.7999	15575284.0
2013-06-21 12:30:00	SPY	ETF	157.795	158.9101	157.7	158.9	17875461.0
2013-06-21 13:00:00	SPY	ETF	158.8965	159.27	158.54	158.86	14063493.0
2013-06-21 13:30:00	SPY	ETF	158.865	159.11	158.32	158.45	8874624.0
2013-06-21 14:00:00	SPY	ETF	158.45	158.89	158.25	158.82	10845280.0
2013-06-21 14:30:00	SPY	ETF	158.83	159.1	158.67	159.099	13064913.0
2013-06-21 15:00:00	SPY	ETF	159.09	159.59	158.98	159.5399	15605715.0
2013-06-21 15:30:00	SPY	ETF	159.54	159.59	158.83	158.985	23558795.0
2013-06-21 16:00:00	SPY	ETF	159.07	159.5	158.3829	158.76	12393984.0
2013-06-21 16:30:00	SPY	ETF	158.77	159.05	158.61	158.72	6161503.0
2013-06-21 17:00:00	SPY	ETF	158.73	158.9	158.73	158.9	4542358.0
2013-06-21 17:30:00	SPY	ETF	158.88	158.9851	158.84	158.89	1131408.0
2013-06-21 18:00:00	SPY	ETF	158.9	158.98	158.86	158.88	411063.0
2013-06-21 18:30:00	SPY	ETF	158.86	158.89	158.85	158.85	91975.0
2013-06-21 19:00:00	SPY	ETF	158.85	158.87	158.82	158.82	18495.0
2013-06-21 19:30:00	SPY	ETF	158.83	158.85	158.83	158.84	10413.0
2013-06-21 04:00:00	QQQ	ETF	70.95	70.96	70.85	70.85	4420.0
2013-06-21 04:30:00	QQQ	ETF	70.88	70.93	70.88	70.93	785.0
2013-06-21 05:00:00	QQQ	ETF	70.94	71.03	70.94	71.03	1675.0
2013-06-21 05:30:00	QQQ	ETF	71.04	71.12	71.04	71.12	6217.0
2013-06-21 06:00:00	QQQ	ETF	71.09	71.09	71.06	71.06	800.0
2013-06-21 07:00:00	QQQ	ETF	71.05	71.08	71.0	71.08	24000.0
2013-06-21 07:30:00	QQQ	ETF	71.08	71.12	71.05	71.08	44696.0
2013-06-21 08:00:00	QQQ	ETF	71.1	71.1	70.96	70.97	69985.0
2013-06-21 08:30:00	QQQ	ETF	70.96	70.96	70.77	70.77	105256.0
2013-06-21 09:00:00	QQQ	ETF	70.77	70.93	70.75	70.78	491040.0
2013-06-21 09:30:00	QQQ	ETF	70.78	70.97	70.54	70.55	7780063.0
2013-06-21 10:00:00	QQQ	ETF	70.55	70.71	70.39	70.42	3779859.0
2013-06-21 10:30:00	QQQ	ETF	70.43	70.53	70.22	70.42	4354053.0
2013-06-21 11:00:00	QQQ	ETF	70.42	70.44	70.04	70.086	2985104.0
2013-06-21 11:30:00	QQQ	ETF	70.07	70.07	69.84	69.961	4419646.0
2013-06-21 12:00:00	QQQ	ETF	69.965	70.19	69.94	70.02	2467742.0
2013-06-21 12:30:00	QQQ	ETF	70.025	70.45	70.01	70.45	3393329.0
2013-06-21 13:00:00	QQQ	ETF	70.455	70.59	70.32	70.391	2561588.0

> showing 50 of 11,562 rows — these rows as CSV

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