PREVIEW / etf_30min / 2014-08-04

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-08-04.parquet
  size:    352 KB
  rows:    11,702

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-08-04 04:00:00	SPY	ETF	192.99	193.02	192.84	192.84	22223.0
2014-08-04 04:30:00	SPY	ETF	192.77	192.85	192.73	192.84	2498.0
2014-08-04 05:00:00	SPY	ETF	192.9	193.05	192.85	193.05	12487.0
2014-08-04 05:30:00	SPY	ETF	192.99	193.05	192.93	193.03	6364.0
2014-08-04 06:00:00	SPY	ETF	193.03	193.14	193.03	193.13	13773.0
2014-08-04 06:30:00	SPY	ETF	193.13	193.17	193.01	193.07	80683.0
2014-08-04 07:00:00	SPY	ETF	193.05	193.21	193.03	193.17	113482.0
2014-08-04 07:30:00	SPY	ETF	193.17	193.2	193.01	193.1	158429.0
2014-08-04 08:00:00	SPY	ETF	193.08	193.15	192.27	192.96	434623.0
2014-08-04 08:30:00	SPY	ETF	192.98	193.02	192.88	192.89	254475.0
2014-08-04 09:00:00	SPY	ETF	192.88	193.0	192.77	192.88	599091.0
2014-08-04 09:30:00	SPY	ETF	192.87	193.05	192.63	192.96	11675948.0
2014-08-04 10:00:00	SPY	ETF	192.96	193.09	192.56	192.8	7009091.0
2014-08-04 10:30:00	SPY	ETF	192.8	192.91	192.05	192.15	6840284.0
2014-08-04 11:00:00	SPY	ETF	192.15	192.74	192.09	192.7135	6064123.0
2014-08-04 11:30:00	SPY	ETF	192.71	192.8	192.42	192.62	3808965.0
2014-08-04 12:00:00	SPY	ETF	192.62	193.0	192.51	192.96	5043783.0
2014-08-04 12:30:00	SPY	ETF	192.96	193.03	192.8	192.945	3427412.0
2014-08-04 13:00:00	SPY	ETF	192.95	193.07	192.8	192.95	2719647.0
2014-08-04 13:30:00	SPY	ETF	192.96	193.41	192.95	193.2875	4931865.0
2014-08-04 14:00:00	SPY	ETF	193.29	193.4	193.28	193.31	3704348.0
2014-08-04 14:30:00	SPY	ETF	193.31	193.91	193.29	193.805	5751726.0
2014-08-04 15:00:00	SPY	ETF	193.8075	194.1	193.75	194.0	5975583.0
2014-08-04 15:30:00	SPY	ETF	194.003	194.3	193.86	193.88	13192993.0
2014-08-04 16:00:00	SPY	ETF	193.88	193.9	192.4987	193.72	3377489.0
2014-08-04 16:30:00	SPY	ETF	193.74	193.89	193.67	193.72	947576.0
2014-08-04 17:00:00	SPY	ETF	193.72	193.73	193.61	193.64	3168205.0
2014-08-04 17:30:00	SPY	ETF	193.64	193.89	193.61	193.68	424776.0
2014-08-04 18:00:00	SPY	ETF	193.68	193.68	193.47	193.66	178164.0
2014-08-04 18:30:00	SPY	ETF	193.65	193.65	193.55	193.59	12849.0
2014-08-04 19:00:00	SPY	ETF	193.59	193.69	193.59	193.67	17238.0
2014-08-04 19:30:00	SPY	ETF	193.67	193.71	193.66	193.66	46505.0
2014-08-04 04:00:00	QQQ	ETF	94.78	94.78	94.78	94.78	500.0
2014-08-04 06:00:00	QQQ	ETF	94.96	94.98	94.96	94.96	575.0
2014-08-04 06:30:00	QQQ	ETF	94.99	95.01	94.91	94.93	18227.0
2014-08-04 07:00:00	QQQ	ETF	94.96	95.02	94.95	94.95	3800.0
2014-08-04 07:30:00	QQQ	ETF	94.96	95.01	94.94	94.99	20573.0
2014-08-04 08:00:00	QQQ	ETF	94.99	95.03	94.92	94.96	181911.0
2014-08-04 08:30:00	QQQ	ETF	94.97	94.99	94.92	94.93	38474.0
2014-08-04 09:00:00	QQQ	ETF	94.92	94.99	94.65	94.9	254001.0
2014-08-04 09:30:00	QQQ	ETF	94.9	95.18	94.76	95.12	3613102.0
2014-08-04 10:00:00	QQQ	ETF	95.12	95.18	94.85	94.97	2765350.0
2014-08-04 10:30:00	QQQ	ETF	94.97	95.04	94.52	94.59	3059235.0
2014-08-04 11:00:00	QQQ	ETF	94.58	94.98	94.533	94.97	1923360.0
2014-08-04 11:30:00	QQQ	ETF	94.97	95.06	94.865	95.02	1268754.0
2014-08-04 12:00:00	QQQ	ETF	95.02	95.2045	94.95	95.18	1193029.0
2014-08-04 12:30:00	QQQ	ETF	95.18	95.24	95.08	95.1855	1101108.0
2014-08-04 13:00:00	QQQ	ETF	95.18	95.22	95.05	95.08	834658.0
2014-08-04 13:30:00	QQQ	ETF	95.089	95.26	95.0802	95.175	887967.0
2014-08-04 14:00:00	QQQ	ETF	95.175	95.26	95.17	95.22	888692.0

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

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