PREVIEW / etf_30min / 2014-02-25

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-02-25.parquet
  size:    339 KB
  rows:    11,396

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-25 04:00:00	SPY	ETF	184.78	184.87	184.77	184.8	2650.0
2014-02-25 04:30:00	SPY	ETF	184.81	184.82	184.73	184.73	3940.0
2014-02-25 05:00:00	SPY	ETF	184.73	184.78	184.73	184.78	25924.0
2014-02-25 05:30:00	SPY	ETF	184.77	184.84	184.76	184.79	19060.0
2014-02-25 06:00:00	SPY	ETF	184.78	184.78	184.61	184.69	17558.0
2014-02-25 06:30:00	SPY	ETF	184.72	184.76	184.62	184.73	71488.0
2014-02-25 07:00:00	SPY	ETF	184.71	184.81	184.65	184.65	86475.0
2014-02-25 07:30:00	SPY	ETF	184.66	184.74	184.6	184.68	119781.0
2014-02-25 08:00:00	SPY	ETF	184.69	184.91	184.61	184.77	661106.0
2014-02-25 08:30:00	SPY	ETF	184.76	185.04	184.75	184.93	713431.0
2014-02-25 09:00:00	SPY	ETF	184.93	185.06	184.9	185.02	424435.0
2014-02-25 09:30:00	SPY	ETF	185.03	185.26	184.285	184.46	14052574.0
2014-02-25 10:00:00	SPY	ETF	184.44	185.055	184.23	184.62	11885416.0
2014-02-25 10:30:00	SPY	ETF	184.64	185.1	184.582	184.999	5723151.0
2014-02-25 11:00:00	SPY	ETF	185.0	185.56	184.82	185.5577	6607682.0
2014-02-25 11:30:00	SPY	ETF	185.56	185.59	184.991	185.03	7339922.0
2014-02-25 12:00:00	SPY	ETF	185.02	185.15	184.9	185.05	5410793.0
2014-02-25 12:30:00	SPY	ETF	185.04	185.2	184.96	185.13	4570718.0
2014-02-25 13:00:00	SPY	ETF	185.13	185.345	185.07	185.27	3035302.0
2014-02-25 13:30:00	SPY	ETF	185.26	185.39	185.02	185.091	4427093.0
2014-02-25 14:00:00	SPY	ETF	185.09	185.2	184.74	185.04	5924401.0
2014-02-25 14:30:00	SPY	ETF	185.05	185.06	184.82	184.9	4074450.0
2014-02-25 15:00:00	SPY	ETF	184.905	184.91	184.48	184.53	8177670.0
2014-02-25 15:30:00	SPY	ETF	184.53	184.85	184.48	184.8	16689604.0
2014-02-25 16:00:00	SPY	ETF	184.79	185.17	184.773	185.15	8282125.0
2014-02-25 16:30:00	SPY	ETF	185.16	185.23	185.12	185.23	5242843.0
2014-02-25 17:00:00	SPY	ETF	185.2	185.35	185.2	185.34	118313.0
2014-02-25 17:30:00	SPY	ETF	185.3	185.31	185.26	185.26	23732.0
2014-02-25 18:00:00	SPY	ETF	185.26	185.29	185.23	185.26	121229.0
2014-02-25 18:30:00	SPY	ETF	185.26	185.28	185.2	185.2	17230.0
2014-02-25 19:00:00	SPY	ETF	185.21	185.37	185.21	185.37	191585.0
2014-02-25 19:30:00	SPY	ETF	185.34	185.38	185.29	185.3	64084.0
2014-02-25 04:00:00	QQQ	ETF	90.37	90.37	90.37	90.37	100.0
2014-02-25 04:30:00	QQQ	ETF	90.37	90.37	90.36	90.36	1500.0
2014-02-25 05:30:00	QQQ	ETF	90.34	90.34	90.34	90.34	2000.0
2014-02-25 06:00:00	QQQ	ETF	90.31	90.33	90.28	90.33	4850.0
2014-02-25 06:30:00	QQQ	ETF	90.34	90.35	90.29	90.35	6150.0
2014-02-25 07:00:00	QQQ	ETF	90.35	90.38	90.32	90.32	5339.0
2014-02-25 07:30:00	QQQ	ETF	90.32	90.35	90.31	90.34	10700.0
2014-02-25 08:00:00	QQQ	ETF	90.34	90.41	90.33	90.41	71098.0
2014-02-25 08:30:00	QQQ	ETF	90.42	90.52	90.41	90.47	99055.0
2014-02-25 09:00:00	QQQ	ETF	90.47	90.54	90.46	90.51	103915.0
2014-02-25 09:30:00	QQQ	ETF	90.53	90.6	90.11	90.16	3917596.0
2014-02-25 10:00:00	QQQ	ETF	90.15	90.44	90.02	90.26	2562498.0
2014-02-25 10:30:00	QQQ	ETF	90.27	90.47	90.215	90.41	1275625.0
2014-02-25 11:00:00	QQQ	ETF	90.405	90.71	90.385	90.71	1393812.0
2014-02-25 11:30:00	QQQ	ETF	90.7099	90.72	90.45	90.46	1370134.0
2014-02-25 12:00:00	QQQ	ETF	90.48	90.5	90.2899	90.34	980211.0
2014-02-25 12:30:00	QQQ	ETF	90.335	90.43	90.291	90.41	777966.0
2014-02-25 13:00:00	QQQ	ETF	90.41	90.52	90.39	90.46	504885.0

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

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