PREVIEW / etf_30min / 2014-04-16

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-04-16.parquet
  size:    338 KB
  rows:    11,522

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-04-16 04:00:00	SPY	ETF	185.07	185.31	185.0	185.23	21610.0
2014-04-16 04:30:00	SPY	ETF	185.22	185.39	185.22	185.35	15900.0
2014-04-16 05:00:00	SPY	ETF	185.38	185.46	185.37	185.46	6085.0
2014-04-16 05:30:00	SPY	ETF	185.4	185.49	185.38	185.43	7709.0
2014-04-16 06:00:00	SPY	ETF	185.41	185.46	185.35	185.35	41084.0
2014-04-16 06:30:00	SPY	ETF	185.33	185.38	185.3	185.32	25354.0
2014-04-16 07:00:00	SPY	ETF	185.3	185.45	185.27	185.41	169185.0
2014-04-16 07:30:00	SPY	ETF	185.35	185.47	185.27	185.33	306254.0
2014-04-16 08:00:00	SPY	ETF	185.44	185.45	185.23	185.43	390394.0
2014-04-16 08:30:00	SPY	ETF	185.43	185.45	185.16	185.28	350394.0
2014-04-16 09:00:00	SPY	ETF	185.27	185.48	185.27	185.47	897421.0
2014-04-16 09:30:00	SPY	ETF	185.47	185.66	184.78	185.07	13480336.0
2014-04-16 10:00:00	SPY	ETF	185.07	185.29	184.83	185.0101	7882314.0
2014-04-16 10:30:00	SPY	ETF	185.02	185.13	184.68	184.805	7046160.0
2014-04-16 11:00:00	SPY	ETF	184.8	185.31	184.65	185.25	6134782.0
2014-04-16 11:30:00	SPY	ETF	185.26	185.461	185.13	185.42	4444354.0
2014-04-16 12:00:00	SPY	ETF	185.42	185.78	185.39	185.67	8061540.0
2014-04-16 12:30:00	SPY	ETF	185.68	185.75	185.29	185.295	5994013.0
2014-04-16 13:00:00	SPY	ETF	185.29	185.58	185.055	185.47	5407736.0
2014-04-16 13:30:00	SPY	ETF	185.47	185.52	185.14	185.51	3174710.0
2014-04-16 14:00:00	SPY	ETF	185.52	185.55	185.14	185.372	4225067.0
2014-04-16 14:30:00	SPY	ETF	185.37	185.84	185.35	185.775	5742558.0
2014-04-16 15:00:00	SPY	ETF	185.77	185.87	185.59	185.84	3797641.0
2014-04-16 15:30:00	SPY	ETF	185.84	186.14	185.71	186.13	14692895.0
2014-04-16 16:00:00	SPY	ETF	186.12	186.22	184.2081	185.71	7857232.0
2014-04-16 16:30:00	SPY	ETF	185.71	186.145	185.61	185.71	880524.0
2014-04-16 17:00:00	SPY	ETF	185.71	185.85	185.71	185.83	206407.0
2014-04-16 17:30:00	SPY	ETF	185.83	185.89	185.78	185.8	104454.0
2014-04-16 18:00:00	SPY	ETF	185.79	185.79	185.43	185.47	842163.0
2014-04-16 18:30:00	SPY	ETF	185.47	185.48	185.31	185.39	151500.0
2014-04-16 19:00:00	SPY	ETF	185.37	185.48	185.36	185.48	34388.0
2014-04-16 19:30:00	SPY	ETF	185.45	185.5	185.44	185.47	41320.0
2014-04-16 04:00:00	QQQ	ETF	85.78	85.78	85.75	85.78	14925.0
2014-04-16 04:30:00	QQQ	ETF	85.8	85.87	85.8	85.83	2550.0
2014-04-16 05:00:00	QQQ	ETF	85.88	85.89	85.85	85.88	2900.0
2014-04-16 05:30:00	QQQ	ETF	85.87	85.91	85.84	85.87	44200.0
2014-04-16 06:00:00	QQQ	ETF	85.89	85.9	85.85	85.85	900.0
2014-04-16 06:30:00	QQQ	ETF	85.84	85.85	85.81	85.83	71665.0
2014-04-16 07:00:00	QQQ	ETF	85.83	85.9	85.82	85.85	31587.0
2014-04-16 07:30:00	QQQ	ETF	85.83	85.89	85.77	85.79	35665.0
2014-04-16 08:00:00	QQQ	ETF	85.8	85.89	85.75	85.81	167907.0
2014-04-16 08:30:00	QQQ	ETF	85.81	85.81	85.66	85.73	64722.0
2014-04-16 09:00:00	QQQ	ETF	85.74	85.9	85.72	85.83	346196.0
2014-04-16 09:30:00	QQQ	ETF	85.83	85.9	85.23	85.475	7034031.0
2014-04-16 10:00:00	QQQ	ETF	85.49	85.76	85.35	85.5299	3957569.0
2014-04-16 10:30:00	QQQ	ETF	85.54	85.56	85.12	85.22	3750634.0
2014-04-16 11:00:00	QQQ	ETF	85.22	85.59	85.091	85.57	2274092.0
2014-04-16 11:30:00	QQQ	ETF	85.56	85.73	85.43	85.72	1595007.0
2014-04-16 12:00:00	QQQ	ETF	85.7289	86.045	85.71	85.98	2654188.0
2014-04-16 12:30:00	QQQ	ETF	85.99	86.04	85.62	85.62	2031743.0

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

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