PREVIEW / etf_30min / 2014-05-02

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-05-02.parquet
  size:    324 KB
  rows:    11,058

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
2014-05-02 04:00:00	SPY	ETF	188.58	188.58	188.5	188.5	250.0
2014-05-02 05:30:00	SPY	ETF	188.29	188.52	188.29	188.52	1844.0
2014-05-02 06:00:00	SPY	ETF	188.5	188.53	188.5	188.53	856.0
2014-05-02 06:30:00	SPY	ETF	188.58	188.6	188.38	188.42	48875.0
2014-05-02 07:00:00	SPY	ETF	188.4	188.54	188.4	188.44	42298.0
2014-05-02 07:30:00	SPY	ETF	188.46	188.49	188.42	188.49	216500.0
2014-05-02 08:00:00	SPY	ETF	188.48	188.54	188.38	188.53	270414.0
2014-05-02 08:30:00	SPY	ETF	188.53	189.3	188.13	188.2	4560926.0
2014-05-02 09:00:00	SPY	ETF	188.19	188.54	188.13	188.3	1923633.0
2014-05-02 09:30:00	SPY	ETF	188.31	188.93	188.09	188.69	13661801.0
2014-05-02 10:00:00	SPY	ETF	188.69	189.14	188.53	188.88	9688783.0
2014-05-02 10:30:00	SPY	ETF	188.89	189.05	187.98	188.2	11562526.0
2014-05-02 11:00:00	SPY	ETF	188.2	188.5	188.05	188.11	6597496.0
2014-05-02 11:30:00	SPY	ETF	188.11	188.6	188.11	188.5	4288220.0
2014-05-02 12:00:00	SPY	ETF	188.5	188.52	188.3	188.3859	2491050.0
2014-05-02 12:30:00	SPY	ETF	188.38	188.54	188.35	188.4404	2675630.0
2014-05-02 13:00:00	SPY	ETF	188.441	188.53	188.071	188.11	2960505.0
2014-05-02 13:30:00	SPY	ETF	188.11	188.25	188.0	188.02	3418698.0
2014-05-02 14:00:00	SPY	ETF	188.0	188.11	187.78	187.96	5458245.0
2014-05-02 14:30:00	SPY	ETF	187.95	188.21	187.94	188.06	5230557.0
2014-05-02 15:00:00	SPY	ETF	188.06	188.33	188.05	188.06	4757819.0
2014-05-02 15:30:00	SPY	ETF	188.06	188.18	187.89	188.07	8613245.0
2014-05-02 16:00:00	SPY	ETF	188.08	188.13	187.96	188.02	5839813.0
2014-05-02 16:30:00	SPY	ETF	188.02	188.02	187.93	187.96	2673642.0
2014-05-02 17:00:00	SPY	ETF	187.97	187.98	187.85	187.91	74595.0
2014-05-02 17:30:00	SPY	ETF	187.93	187.95	187.81	187.94	544347.0
2014-05-02 18:00:00	SPY	ETF	187.95	188.09	187.91	188.09	89235.0
2014-05-02 18:30:00	SPY	ETF	188.05	188.05	188.03	188.03	5525.0
2014-05-02 19:00:00	SPY	ETF	188.01	188.02	187.98	187.98	2600.0
2014-05-02 19:30:00	SPY	ETF	188.0	188.02	187.98	188.01	16556.0
2014-05-02 07:00:00	QQQ	ETF	87.73	87.74	87.73	87.73	600.0
2014-05-02 07:30:00	QQQ	ETF	87.73	87.74	87.72	87.74	6900.0
2014-05-02 08:00:00	QQQ	ETF	87.74	87.78	87.72	87.75	33946.0
2014-05-02 08:30:00	QQQ	ETF	87.75	88.14	87.71	87.78	847366.0
2014-05-02 09:00:00	QQQ	ETF	87.75	88.01	87.75	87.92	622363.0
2014-05-02 09:30:00	QQQ	ETF	87.94	88.11	87.49	87.66	6649858.0
2014-05-02 10:00:00	QQQ	ETF	87.665	87.97	87.54	87.77	3994259.0
2014-05-02 10:30:00	QQQ	ETF	87.77	87.93	87.28	87.42	4590948.0
2014-05-02 11:00:00	QQQ	ETF	87.42	87.65	87.39	87.49	2058748.0
2014-05-02 11:30:00	QQQ	ETF	87.5	87.84	87.5	87.78	1871911.0
2014-05-02 12:00:00	QQQ	ETF	87.79	87.79	87.641	87.7044	819702.0
2014-05-02 12:30:00	QQQ	ETF	87.71	87.84	87.69	87.74	599572.0
2014-05-02 13:00:00	QQQ	ETF	87.731	87.79	87.54	87.561	1153341.0
2014-05-02 13:30:00	QQQ	ETF	87.565	87.6	87.47	87.47	769127.0
2014-05-02 14:00:00	QQQ	ETF	87.47	87.56	87.41	87.49	1642425.0
2014-05-02 14:30:00	QQQ	ETF	87.49	87.65	87.48	87.56	1522299.0
2014-05-02 15:00:00	QQQ	ETF	87.56	87.73	87.56	87.59	1125673.0
2014-05-02 15:30:00	QQQ	ETF	87.6	87.62	87.47	87.49	5878585.0
2014-05-02 16:00:00	QQQ	ETF	87.49	87.8	87.4565	87.5	1393019.0
2014-05-02 16:30:00	QQQ	ETF	87.5	87.51	87.48	87.51	75300.0

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

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