PREVIEW / etf_30min / 2014-11-19

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-11-19.parquet
  size:    359 KB
  rows:    12,155

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-11-19 04:00:00	SPY	ETF	205.07	205.1	205.07	205.1	3764.0
2014-11-19 04:30:00	SPY	ETF	205.15	205.15	205.15	205.15	100.0
2014-11-19 05:00:00	SPY	ETF	205.15	205.23	205.15	205.23	6100.0
2014-11-19 05:30:00	SPY	ETF	205.19	205.19	205.18	205.18	9200.0
2014-11-19 06:00:00	SPY	ETF	205.15	205.21	205.15	205.19	9100.0
2014-11-19 06:30:00	SPY	ETF	205.22	205.32	205.2	205.25	16601.0
2014-11-19 07:00:00	SPY	ETF	205.23	205.42	205.23	205.4	41835.0
2014-11-19 07:30:00	SPY	ETF	205.34	205.44	205.15	205.18	91421.0
2014-11-19 08:00:00	SPY	ETF	205.19	205.36	205.06	205.19	269679.0
2014-11-19 08:30:00	SPY	ETF	205.2	205.55	205.04	205.14	308937.0
2014-11-19 09:00:00	SPY	ETF	205.16	205.32	205.15	205.31	372202.0
2014-11-19 09:30:00	SPY	ETF	205.31	205.32	204.71	204.89	12445227.0
2014-11-19 10:00:00	SPY	ETF	204.88	204.89	204.53	204.6	6513972.0
2014-11-19 10:30:00	SPY	ETF	204.6	204.73	204.39	204.47	7042767.0
2014-11-19 11:00:00	SPY	ETF	204.47	204.715	204.3	204.645	5100735.0
2014-11-19 11:30:00	SPY	ETF	204.65	204.96	204.62	204.86	3477597.0
2014-11-19 12:00:00	SPY	ETF	204.87	205.03	204.86	204.97	2385627.0
2014-11-19 12:30:00	SPY	ETF	204.97	205.12	204.83	205.11	2513161.0
2014-11-19 13:00:00	SPY	ETF	205.1101	205.18	204.98	205.06	2170334.0
2014-11-19 13:30:00	SPY	ETF	205.06	205.18	205.01	205.055	1716045.0
2014-11-19 14:00:00	SPY	ETF	205.05	205.55	204.82	204.93	9557358.0
2014-11-19 14:30:00	SPY	ETF	204.93	205.09	204.68	204.94	4590752.0
2014-11-19 15:00:00	SPY	ETF	204.945	205.31	204.82	205.105	7855009.0
2014-11-19 15:30:00	SPY	ETF	205.11	205.29	204.92	205.19	9874580.0
2014-11-19 16:00:00	SPY	ETF	205.2	205.37	205.1	205.23	2999425.0
2014-11-19 16:30:00	SPY	ETF	205.24	205.25	205.22	205.23	637352.0
2014-11-19 17:00:00	SPY	ETF	205.24	205.24	205.17	205.2	49566.0
2014-11-19 17:30:00	SPY	ETF	205.2	205.22	205.18	205.22	13922.0
2014-11-19 18:00:00	SPY	ETF	205.2	205.2	205.11	205.18	42532.0
2014-11-19 18:30:00	SPY	ETF	205.17	205.26	205.17	205.26	20537.0
2014-11-19 19:00:00	SPY	ETF	205.27	205.31	205.2	205.2	36706.0
2014-11-19 19:30:00	SPY	ETF	205.23	205.23	205.18	205.2	40120.0
2014-11-19 05:00:00	QQQ	ETF	103.54	103.54	103.54	103.54	300.0
2014-11-19 06:00:00	QQQ	ETF	103.54	103.54	103.54	103.54	300.0
2014-11-19 06:30:00	QQQ	ETF	103.56	103.57	103.56	103.57	900.0
2014-11-19 07:00:00	QQQ	ETF	103.6	103.66	103.6	103.65	11200.0
2014-11-19 07:30:00	QQQ	ETF	103.61	103.63	103.51	103.51	3900.0
2014-11-19 08:00:00	QQQ	ETF	103.53	103.54	103.47	103.52	35381.0
2014-11-19 08:30:00	QQQ	ETF	103.49	103.68	103.48	103.51	28623.0
2014-11-19 09:00:00	QQQ	ETF	103.53	103.58	103.52	103.58	54741.0
2014-11-19 09:30:00	QQQ	ETF	103.57	103.57	103.01	103.085	3958061.0
2014-11-19 10:00:00	QQQ	ETF	103.08	103.095	102.85	102.95	2561632.0
2014-11-19 10:30:00	QQQ	ETF	102.95	103.1001	102.83	102.85	1696938.0
2014-11-19 11:00:00	QQQ	ETF	102.86	103.0	102.73	102.945	1790348.0
2014-11-19 11:30:00	QQQ	ETF	102.95	103.13	102.91	103.08	1192241.0
2014-11-19 12:00:00	QQQ	ETF	103.09	103.27	103.09	103.23	608664.0
2014-11-19 12:30:00	QQQ	ETF	103.23	103.3	103.15	103.291	505228.0
2014-11-19 13:00:00	QQQ	ETF	103.3	103.3698	103.25	103.29	605109.0
2014-11-19 13:30:00	QQQ	ETF	103.29	103.34	103.22	103.221	462899.0
2014-11-19 14:00:00	QQQ	ETF	103.23	103.51	103.03	103.14	2398092.0

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

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