PREVIEW / etf_30min / 2015-07-31

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-07-31.parquet
  size:    373 KB
  rows:    12,579

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
2015-07-31 04:00:00	SPY	ETF	210.92	210.98	210.88	210.88	4550.0
2015-07-31 04:30:00	SPY	ETF	210.94	211.15	210.94	211.06	3530.0
2015-07-31 05:00:00	SPY	ETF	210.98	211.03	210.93	210.95	34300.0
2015-07-31 05:30:00	SPY	ETF	210.95	210.98	210.66	210.72	8537.0
2015-07-31 06:00:00	SPY	ETF	210.72	210.75	210.69	210.75	2279.0
2015-07-31 06:30:00	SPY	ETF	210.81	210.85	210.71	210.74	33105.0
2015-07-31 07:00:00	SPY	ETF	210.75	210.75	210.52	210.6	99982.0
2015-07-31 07:30:00	SPY	ETF	210.63	210.67	210.58	210.63	47209.0
2015-07-31 08:00:00	SPY	ETF	210.6	210.82	210.39	210.45	336429.0
2015-07-31 08:30:00	SPY	ETF	210.46	211.39	210.45	211.32	1731408.0
2015-07-31 09:00:00	SPY	ETF	211.33	211.52	211.15	211.43	711105.0
2015-07-31 09:30:00	SPY	ETF	211.42	211.45	210.51	210.62	10781310.0
2015-07-31 10:00:00	SPY	ETF	210.615	211.19	210.54	211.015	7495672.0
2015-07-31 10:30:00	SPY	ETF	211.015	211.34	210.91	211.21	4874023.0
2015-07-31 11:00:00	SPY	ETF	211.2	211.24	211.01	211.18	4510837.0
2015-07-31 11:30:00	SPY	ETF	211.18	211.33	211.16	211.19	2912270.0
2015-07-31 12:00:00	SPY	ETF	211.19	211.38	211.175	211.24	2949848.0
2015-07-31 12:30:00	SPY	ETF	211.25	211.25	211.02	211.065	4013672.0
2015-07-31 13:00:00	SPY	ETF	211.06	211.18	210.78	210.82	2294627.0
2015-07-31 13:30:00	SPY	ETF	210.8134	211.0342	210.6	210.6601	4563581.0
2015-07-31 14:00:00	SPY	ETF	210.67	210.83	210.37	210.565	6489032.0
2015-07-31 14:30:00	SPY	ETF	210.56	210.7	210.29	210.54	8989241.0
2015-07-31 15:00:00	SPY	ETF	210.54	210.645	210.17	210.19	8175957.0
2015-07-31 15:30:00	SPY	ETF	210.2	210.54	210.16	210.47	19235651.0
2015-07-31 16:00:00	SPY	ETF	210.47	210.8026	210.3629	210.64	8057790.0
2015-07-31 16:30:00	SPY	ETF	210.65	210.7	210.62	210.64	2629153.0
2015-07-31 17:00:00	SPY	ETF	210.65	210.68	210.55	210.57	124669.0
2015-07-31 17:30:00	SPY	ETF	210.57	210.64	210.41	210.54	576614.0
2015-07-31 18:00:00	SPY	ETF	210.5	210.58	210.5	210.54	1641.0
2015-07-31 18:30:00	SPY	ETF	210.54	210.58	210.43	210.46	40064.0
2015-07-31 19:00:00	SPY	ETF	210.46	210.5	210.42	210.45	30644.0
2015-07-31 19:30:00	SPY	ETF	210.45	210.45	210.42	210.45	11213.0
2015-07-31 04:00:00	QQQ	ETF	112.15	112.15	112.15	112.15	1000.0
2015-07-31 04:30:00	QQQ	ETF	112.24	112.24	112.24	112.24	2500.0
2015-07-31 06:30:00	QQQ	ETF	112.14	112.14	112.14	112.14	500.0
2015-07-31 07:00:00	QQQ	ETF	111.87	111.87	111.84	111.84	10000.0
2015-07-31 07:30:00	QQQ	ETF	112.03	112.03	111.98	112.02	3300.0
2015-07-31 08:00:00	QQQ	ETF	111.98	112.01	111.9	111.92	70876.0
2015-07-31 08:30:00	QQQ	ETF	111.92	112.493	111.92	112.493	299860.0
2015-07-31 09:00:00	QQQ	ETF	112.49	112.49	112.39	112.44	114080.0
2015-07-31 09:30:00	QQQ	ETF	112.43	112.49	111.91	111.92	3448744.0
2015-07-31 10:00:00	QQQ	ETF	111.92	112.31	111.87	112.24	1694052.0
2015-07-31 10:30:00	QQQ	ETF	112.24	112.45	112.16	112.39	1652587.0
2015-07-31 11:00:00	QQQ	ETF	112.38	112.385	112.13	112.19	965757.0
2015-07-31 11:30:00	QQQ	ETF	112.2	112.35	112.185	112.22	727713.0
2015-07-31 12:00:00	QQQ	ETF	112.23	112.3767	112.21	112.349	543077.0
2015-07-31 12:30:00	QQQ	ETF	112.35	112.35	112.169	112.169	956759.0
2015-07-31 13:00:00	QQQ	ETF	112.16	112.225	111.99	112.02	540001.0
2015-07-31 13:30:00	QQQ	ETF	112.03	112.04	111.91	111.95	918452.0
2015-07-31 14:00:00	QQQ	ETF	111.96	112.065	111.7665	111.9	989730.0

> showing 50 of 12,579 rows — these rows as CSV

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