PREVIEW / etf_30min / 2014-02-13

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-02-13.parquet
  size:    348 KB
  rows:    11,486

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-02-13 04:00:00	SPY	ETF	181.6	181.6	181.25	181.4	41710.0
2014-02-13 04:30:00	SPY	ETF	181.4	181.51	181.38	181.4	19707.0
2014-02-13 05:00:00	SPY	ETF	181.44	181.56	181.35	181.5	64632.0
2014-02-13 05:30:00	SPY	ETF	181.55	181.61	181.36	181.42	29118.0
2014-02-13 06:00:00	SPY	ETF	181.35	181.39	181.15	181.18	58712.0
2014-02-13 06:30:00	SPY	ETF	181.19	181.31	181.17	181.29	150672.0
2014-02-13 07:00:00	SPY	ETF	181.29	181.49	181.29	181.41	125767.0
2014-02-13 07:30:00	SPY	ETF	181.41	181.44	181.25	181.34	215801.0
2014-02-13 08:00:00	SPY	ETF	181.34	181.44	181.08	181.13	692364.0
2014-02-13 08:30:00	SPY	ETF	181.12	181.24	180.75	181.13	1763339.0
2014-02-13 09:00:00	SPY	ETF	181.11	181.21	180.85	180.86	667945.0
2014-02-13 09:30:00	SPY	ETF	180.84	181.61	180.83	181.55	11966534.0
2014-02-13 10:00:00	SPY	ETF	181.55	182.11	181.46	181.8802	10750921.0
2014-02-13 10:30:00	SPY	ETF	181.89	182.44	181.76	182.34	8122244.0
2014-02-13 11:00:00	SPY	ETF	182.345	182.64	182.21	182.5	6323040.0
2014-02-13 11:30:00	SPY	ETF	182.51	182.65	182.37	182.44	4593784.0
2014-02-13 12:00:00	SPY	ETF	182.45	182.47	182.31	182.446	3228448.0
2014-02-13 12:30:00	SPY	ETF	182.441	182.66	182.43	182.59	3994247.0
2014-02-13 13:00:00	SPY	ETF	182.59	182.93	182.55	182.92	4317801.0
2014-02-13 13:30:00	SPY	ETF	182.93	183.08	182.85	183.079	4884559.0
2014-02-13 14:00:00	SPY	ETF	183.07	183.2	182.87	182.91	6430938.0
2014-02-13 14:30:00	SPY	ETF	182.919	183.18	182.88	183.13	4334749.0
2014-02-13 15:00:00	SPY	ETF	183.13	183.16	182.95	183.01	4427545.0
2014-02-13 15:30:00	SPY	ETF	183.01	183.18	182.96	183.05	13781214.0
2014-02-13 16:00:00	SPY	ETF	183.04	183.1385	182.0838	182.94	6419774.0
2014-02-13 16:30:00	SPY	ETF	182.94	183.03	182.94	183.01	207454.0
2014-02-13 17:00:00	SPY	ETF	183.0	183.0	182.87	182.94	105609.0
2014-02-13 17:30:00	SPY	ETF	182.93	183.14	182.91	182.96	1313729.0
2014-02-13 18:00:00	SPY	ETF	182.94	182.95	182.72	182.79	182979.0
2014-02-13 18:30:00	SPY	ETF	182.79	182.87	182.77	182.87	91996.0
2014-02-13 19:00:00	SPY	ETF	182.85	183.04	182.84	182.98	81962.0
2014-02-13 19:30:00	SPY	ETF	182.97	182.98	182.92	182.96	53805.0
2014-02-13 04:00:00	QQQ	ETF	88.53	88.53	88.53	88.53	2300.0
2014-02-13 04:30:00	QQQ	ETF	88.55	88.55	88.55	88.55	2300.0
2014-02-13 05:00:00	QQQ	ETF	88.57	88.57	88.52	88.57	2146.0
2014-02-13 05:30:00	QQQ	ETF	88.58	88.62	88.58	88.62	1400.0
2014-02-13 06:00:00	QQQ	ETF	88.55	88.55	88.44	88.44	15500.0
2014-02-13 06:30:00	QQQ	ETF	88.43	88.5	88.43	88.49	17900.0
2014-02-13 07:00:00	QQQ	ETF	88.54	88.6	88.54	88.58	13375.0
2014-02-13 07:30:00	QQQ	ETF	88.53	88.53	88.47	88.47	23500.0
2014-02-13 08:00:00	QQQ	ETF	88.5	88.6	88.43	88.46	57359.0
2014-02-13 08:30:00	QQQ	ETF	88.46	88.49	88.28	88.41	401178.0
2014-02-13 09:00:00	QQQ	ETF	88.43	88.46	88.29	88.32	381350.0
2014-02-13 09:30:00	QQQ	ETF	88.31	88.89	88.3	88.84	5134190.0
2014-02-13 10:00:00	QQQ	ETF	88.84	89.19	88.79	89.06	4321495.0
2014-02-13 10:30:00	QQQ	ETF	89.07	89.4	89.01	89.34	3449509.0
2014-02-13 11:00:00	QQQ	ETF	89.35	89.45	89.3	89.35	2021544.0
2014-02-13 11:30:00	QQQ	ETF	89.35	89.395	89.27	89.319	1189179.0
2014-02-13 12:00:00	QQQ	ETF	89.31	89.37	89.2799	89.36	1204204.0
2014-02-13 12:30:00	QQQ	ETF	89.3599	89.45	89.34	89.41	1095110.0

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

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