PREVIEW / etf_30min / 2014-02-20

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-02-20.parquet
  size:    335 KB
  rows:    11,318

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-20 04:00:00	SPY	ETF	182.7	182.86	182.7	182.85	2863.0
2014-02-20 04:30:00	SPY	ETF	182.77	182.82	182.73	182.73	4060.0
2014-02-20 05:00:00	SPY	ETF	182.73	182.83	182.73	182.76	10450.0
2014-02-20 05:30:00	SPY	ETF	182.95	183.07	182.89	182.91	10091.0
2014-02-20 06:00:00	SPY	ETF	182.93	182.93	182.79	182.85	25586.0
2014-02-20 06:30:00	SPY	ETF	182.83	182.9	182.75	182.9	32070.0
2014-02-20 07:00:00	SPY	ETF	182.9	183.0	182.47	182.5	244207.0
2014-02-20 07:30:00	SPY	ETF	182.53	182.63	182.45	182.59	117055.0
2014-02-20 08:00:00	SPY	ETF	182.57	183.0807	182.46	182.51	889214.0
2014-02-20 08:30:00	SPY	ETF	182.57	183.46	182.53	183.26	1240962.0
2014-02-20 09:00:00	SPY	ETF	183.25	183.42	183.16	183.27	2126547.0
2014-02-20 09:30:00	SPY	ETF	183.27	183.64	182.85	182.96	12312071.0
2014-02-20 10:00:00	SPY	ETF	182.94	183.48	182.6	183.36	14332660.0
2014-02-20 10:30:00	SPY	ETF	183.36	183.87	183.355	183.7	7503143.0
2014-02-20 11:00:00	SPY	ETF	183.71	183.94	183.54	183.63	8155998.0
2014-02-20 11:30:00	SPY	ETF	183.63	183.87	183.595	183.75	4200068.0
2014-02-20 12:00:00	SPY	ETF	183.75	184.21	183.695	184.17	4896795.0
2014-02-20 12:30:00	SPY	ETF	184.1627	184.28	184.105	184.14	5333638.0
2014-02-20 13:00:00	SPY	ETF	184.15	184.27	184.12	184.16	2456360.0
2014-02-20 13:30:00	SPY	ETF	184.16	184.27	184.11	184.21	2892157.0
2014-02-20 14:00:00	SPY	ETF	184.21	184.37	183.98	184.2	4468678.0
2014-02-20 14:30:00	SPY	ETF	184.2	184.35	184.07	184.34	5016014.0
2014-02-20 15:00:00	SPY	ETF	184.34	184.44	184.22	184.33	4888881.0
2014-02-20 15:30:00	SPY	ETF	184.325	184.52	184.16	184.16	13303064.0
2014-02-20 16:00:00	SPY	ETF	184.16	184.3	183.1124	184.11	6939639.0
2014-02-20 16:30:00	SPY	ETF	184.11	184.2	183.1124	184.06	1541760.0
2014-02-20 17:00:00	SPY	ETF	184.07	184.09	184.04	184.05	48481.0
2014-02-20 17:30:00	SPY	ETF	184.09	184.1	184.09	184.09	2845.0
2014-02-20 18:00:00	SPY	ETF	184.1	184.11	184.07	184.08	14335.0
2014-02-20 18:30:00	SPY	ETF	184.07	184.15	184.06	184.15	7600.0
2014-02-20 19:00:00	SPY	ETF	184.15	184.38	184.15	184.38	46405.0
2014-02-20 19:30:00	SPY	ETF	184.37	184.42	184.35	184.39	88222.0
2014-02-20 04:00:00	QQQ	ETF	89.54	89.56	89.54	89.56	3700.0
2014-02-20 04:30:00	QQQ	ETF	89.56	89.61	89.56	89.61	3500.0
2014-02-20 05:00:00	QQQ	ETF	89.58	89.58	89.56	89.56	2400.0
2014-02-20 05:30:00	QQQ	ETF	89.58	89.58	89.58	89.58	818.0
2014-02-20 06:00:00	QQQ	ETF	89.55	89.55	89.52	89.52	13700.0
2014-02-20 06:30:00	QQQ	ETF	89.5	89.53	89.45	89.51	31500.0
2014-02-20 07:00:00	QQQ	ETF	89.5	89.5	89.3	89.3	35800.0
2014-02-20 07:30:00	QQQ	ETF	89.3	89.35	89.28	89.3	33150.0
2014-02-20 08:00:00	QQQ	ETF	89.31	89.38	89.31	89.35	145656.0
2014-02-20 08:30:00	QQQ	ETF	89.37	89.72	89.35	89.62	147059.0
2014-02-20 09:00:00	QQQ	ETF	89.63	89.7	89.6	89.68	103786.0
2014-02-20 09:30:00	QQQ	ETF	89.69	89.94	89.38	89.44	5042091.0
2014-02-20 10:00:00	QQQ	ETF	89.44	89.77	89.31	89.67	3542602.0
2014-02-20 10:30:00	QQQ	ETF	89.67	89.88	89.67	89.757	2541115.0
2014-02-20 11:00:00	QQQ	ETF	89.76	89.8201	89.62	89.68	1553255.0
2014-02-20 11:30:00	QQQ	ETF	89.685	89.8	89.645	89.75	2020157.0
2014-02-20 12:00:00	QQQ	ETF	89.745	89.96	89.72	89.95	1125133.0
2014-02-20 12:30:00	QQQ	ETF	89.945	90.0	89.871	89.9099	1099113.0

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

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