PREVIEW / etf_30min / 2015-11-17

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-11-17.parquet
  size:    387 KB
  rows:    12,929

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-11-17 04:00:00	SPY	ETF	205.75	206.0	205.6	206.0	8818.0
2015-11-17 04:30:00	SPY	ETF	206.07	206.42	206.07	206.27	16978.0
2015-11-17 05:00:00	SPY	ETF	206.34	206.38	206.23	206.26	3225.0
2015-11-17 05:30:00	SPY	ETF	206.38	206.54	206.19	206.41	30578.0
2015-11-17 06:00:00	SPY	ETF	206.46	206.61	206.43	206.48	45719.0
2015-11-17 06:30:00	SPY	ETF	206.51	206.52	206.23	206.26	72345.0
2015-11-17 07:00:00	SPY	ETF	206.24	206.37	206.15	206.2	158700.0
2015-11-17 07:30:00	SPY	ETF	206.2	206.24	206.01	206.19	157677.0
2015-11-17 08:00:00	SPY	ETF	206.18	206.33	205.97	206.07	387373.0
2015-11-17 08:30:00	SPY	ETF	206.01	206.42	206.01	206.33	623470.0
2015-11-17 09:00:00	SPY	ETF	206.31	206.32	205.62	205.99	590973.0
2015-11-17 09:30:00	SPY	ETF	205.99	206.01	205.26	205.755	12698442.0
2015-11-17 10:00:00	SPY	ETF	205.76	205.91	205.42	205.88	7280969.0
2015-11-17 10:30:00	SPY	ETF	205.89	206.74	205.82	206.54	10122241.0
2015-11-17 11:00:00	SPY	ETF	206.54	206.73	206.32	206.69	5635261.0
2015-11-17 11:30:00	SPY	ETF	206.69	207.04	206.62	206.75	5909714.0
2015-11-17 12:00:00	SPY	ETF	206.76	206.98	206.43	206.48	4254292.0
2015-11-17 12:30:00	SPY	ETF	206.48	206.6	205.97	206.34	6449834.0
2015-11-17 13:00:00	SPY	ETF	206.34	206.57	205.72	205.78	5329357.0
2015-11-17 13:30:00	SPY	ETF	205.77	206.35	205.6968	206.32	5050518.0
2015-11-17 14:00:00	SPY	ETF	206.31	206.52	205.545	205.55	7528389.0
2015-11-17 14:30:00	SPY	ETF	205.555	205.68	205.04	205.65	12046189.0
2015-11-17 15:00:00	SPY	ETF	205.64	205.65	204.88	205.33	12628626.0
2015-11-17 15:30:00	SPY	ETF	205.33	206.1566	205.116	205.38	13608398.0
2015-11-17 16:00:00	SPY	ETF	205.38	205.69	205.38	205.68	4684849.0
2015-11-17 16:30:00	SPY	ETF	205.66	205.9	205.3791	205.69	4885105.0
2015-11-17 17:00:00	SPY	ETF	205.71	205.72	205.65	205.71	39395.0
2015-11-17 17:30:00	SPY	ETF	205.7	205.73	205.65	205.65	132697.0
2015-11-17 18:00:00	SPY	ETF	205.69	205.7	205.57	205.58	34812.0
2015-11-17 18:30:00	SPY	ETF	205.59	205.62	205.5	205.5	37190.0
2015-11-17 19:00:00	SPY	ETF	205.5	205.6	205.48	205.5	41205.0
2015-11-17 19:30:00	SPY	ETF	205.48	205.5	205.32	205.45	43106.0
2015-11-17 04:00:00	QQQ	ETF	111.22	111.6	111.22	111.6	6650.0
2015-11-17 04:30:00	QQQ	ETF	111.66	111.77	111.66	111.77	12450.0
2015-11-17 05:00:00	QQQ	ETF	111.84	111.84	111.82	111.82	424.0
2015-11-17 05:30:00	QQQ	ETF	111.88	111.93	111.87	111.87	6650.0
2015-11-17 06:00:00	QQQ	ETF	111.98	111.98	111.92	111.94	570.0
2015-11-17 06:30:00	QQQ	ETF	111.81	111.85	111.81	111.85	911.0
2015-11-17 07:00:00	QQQ	ETF	111.79	111.84	111.76	111.8	17420.0
2015-11-17 07:30:00	QQQ	ETF	111.78	111.78	111.71	111.78	15176.0
2015-11-17 08:00:00	QQQ	ETF	111.8	111.8	111.68	111.7	52963.0
2015-11-17 08:30:00	QQQ	ETF	111.69	111.86	111.69	111.75	41485.0
2015-11-17 09:00:00	QQQ	ETF	111.75	111.75	111.59	111.6	140304.0
2015-11-17 09:30:00	QQQ	ETF	111.61	111.6323	111.33	111.59	3912674.0
2015-11-17 10:00:00	QQQ	ETF	111.59	111.689	111.34	111.65	2082714.0
2015-11-17 10:30:00	QQQ	ETF	111.66	112.06	111.63	111.97	2631166.0
2015-11-17 11:00:00	QQQ	ETF	111.97	112.09	111.79	112.08	1818647.0
2015-11-17 11:30:00	QQQ	ETF	112.09	112.29	112.0694	112.13	1325586.0
2015-11-17 12:00:00	QQQ	ETF	112.13	112.23	111.91	111.9507	1711365.0
2015-11-17 12:30:00	QQQ	ETF	111.95	112.02	111.7366	111.99	1618061.0

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

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