PREVIEW / etf_30min / 2016-06-28

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-06-28.parquet
  size:    423 KB
  rows:    14,436

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
2016-06-28 04:00:00	SPY	ETF	200.88	201.35	200.88	201.34	69074.0
2016-06-28 04:30:00	SPY	ETF	201.34	201.34	201.03	201.05	18748.0
2016-06-28 05:00:00	SPY	ETF	201.07	201.25	201.0	201.09	18643.0
2016-06-28 05:30:00	SPY	ETF	201.09	201.25	201.08	201.22	15470.0
2016-06-28 06:00:00	SPY	ETF	201.22	201.28	201.03	201.19	47044.0
2016-06-28 06:30:00	SPY	ETF	201.11	201.15	200.98	201.01	99979.0
2016-06-28 07:00:00	SPY	ETF	201.01	201.06	200.79	200.87	208037.0
2016-06-28 07:30:00	SPY	ETF	200.88	201.05	200.79	201.03	412747.0
2016-06-28 08:00:00	SPY	ETF	201.03	201.41	199.81	201.3	999407.0
2016-06-28 08:30:00	SPY	ETF	201.3	201.65	201.19	201.48	724639.0
2016-06-28 09:00:00	SPY	ETF	201.47	201.55	201.21	201.49	1334450.0
2016-06-28 09:30:00	SPY	ETF	201.48	202.29	201.25	202.12	23654582.0
2016-06-28 10:00:00	SPY	ETF	202.13	202.3	201.7	201.74	12650115.0
2016-06-28 10:30:00	SPY	ETF	201.74	202.02	201.51	201.61	10437609.0
2016-06-28 11:00:00	SPY	ETF	201.61	201.73	201.12	201.2	11187617.0
2016-06-28 11:30:00	SPY	ETF	201.2	201.89	201.17	201.8135	6222662.0
2016-06-28 12:00:00	SPY	ETF	201.82	201.87	201.54	201.635	5216145.0
2016-06-28 12:30:00	SPY	ETF	201.64	202.11	201.61	201.9198	6769581.0
2016-06-28 13:00:00	SPY	ETF	201.91	201.95	201.46	201.545	7734563.0
2016-06-28 13:30:00	SPY	ETF	201.5411	201.77	201.38	201.65	4519486.0
2016-06-28 14:00:00	SPY	ETF	201.65	201.76	201.35	201.6489	6584680.0
2016-06-28 14:30:00	SPY	ETF	201.65	202.97	201.61	202.75	12211089.0
2016-06-28 15:00:00	SPY	ETF	202.74	203.06	202.37	202.56	11038213.0
2016-06-28 15:30:00	SPY	ETF	202.55	203.2	202.42	203.1725	24792956.0
2016-06-28 16:00:00	SPY	ETF	203.16	203.37	203.11	203.31	8118962.0
2016-06-28 16:30:00	SPY	ETF	203.3	203.47	203.21	203.32	974126.0
2016-06-28 17:00:00	SPY	ETF	203.3	203.35	203.2	203.27	801525.0
2016-06-28 17:30:00	SPY	ETF	203.26	204.3308	201.9191	203.3	313724.0
2016-06-28 18:00:00	SPY	ETF	203.3	203.32	203.06	203.16	62312.0
2016-06-28 18:30:00	SPY	ETF	203.16	203.28	203.15	203.27	22036.0
2016-06-28 19:00:00	SPY	ETF	203.28	203.28	203.21	203.21	38242.0
2016-06-28 19:30:00	SPY	ETF	203.21	203.25	203.15	203.2	45273.0
2016-06-28 04:00:00	QQQ	ETF	103.09	103.3	103.09	103.27	116292.0
2016-06-28 04:30:00	QQQ	ETF	103.06	103.06	103.06	103.06	500.0
2016-06-28 05:00:00	QQQ	ETF	103.13	103.13	103.0	103.06	9585.0
2016-06-28 05:30:00	QQQ	ETF	103.13	103.17	103.12	103.15	3299.0
2016-06-28 06:00:00	QQQ	ETF	103.16	103.19	103.06	103.13	13699.0
2016-06-28 06:30:00	QQQ	ETF	103.04	103.12	103.04	103.04	6296.0
2016-06-28 07:00:00	QQQ	ETF	103.05	103.09	102.98	103.0	21957.0
2016-06-28 07:30:00	QQQ	ETF	102.99	103.12	102.96	103.09	66636.0
2016-06-28 08:00:00	QQQ	ETF	103.07	103.23	102.96	103.22	152201.0
2016-06-28 08:30:00	QQQ	ETF	103.2	103.36	103.14	103.31	110681.0
2016-06-28 09:00:00	QQQ	ETF	103.26	103.36	103.21	103.32	462662.0
2016-06-28 09:30:00	QQQ	ETF	103.33	104.0963	103.3	104.03	4557587.0
2016-06-28 10:00:00	QQQ	ETF	104.03	104.08	103.85	103.91	1869265.0
2016-06-28 10:30:00	QQQ	ETF	103.92	104.06	103.74	103.8	1411293.0
2016-06-28 11:00:00	QQQ	ETF	103.81	103.8865	103.41	103.4498	1684613.0
2016-06-28 11:30:00	QQQ	ETF	103.45	103.8414	103.445	103.79	1017465.0
2016-06-28 12:00:00	QQQ	ETF	103.81	103.85	103.62	103.67	594010.0
2016-06-28 12:30:00	QQQ	ETF	103.68	103.965	103.66	103.86	935536.0

> showing 50 of 14,436 rows — these rows as CSV

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