PREVIEW / etf_30min / 2015-01-23

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-01-23.parquet
  size:    381 KB
  rows:    13,066

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-01-23 04:00:00	SPY	ETF	206.05	206.32	205.86	205.86	500.0
2015-01-23 04:30:00	SPY	ETF	206.15	206.15	206.07	206.12	6700.0
2015-01-23 05:00:00	SPY	ETF	206.22	206.22	206.1	206.14	36862.0
2015-01-23 05:30:00	SPY	ETF	206.13	206.13	205.91	205.93	30737.0
2015-01-23 06:00:00	SPY	ETF	206.06	206.2	206.0	206.19	35765.0
2015-01-23 06:30:00	SPY	ETF	206.2	206.36	206.13	206.22	66448.0
2015-01-23 07:00:00	SPY	ETF	206.12	206.35	206.05	206.25	226635.0
2015-01-23 07:30:00	SPY	ETF	206.21	206.62	206.21	206.46	365570.0
2015-01-23 08:00:00	SPY	ETF	206.45	206.5	206.3	206.38	461290.0
2015-01-23 08:30:00	SPY	ETF	206.35	206.35	205.74	205.77	1042566.0
2015-01-23 09:00:00	SPY	ETF	205.76	206.08	205.47	205.76	1248273.0
2015-01-23 09:30:00	SPY	ETF	205.79	205.9	205.26	205.54	16280120.0
2015-01-23 10:00:00	SPY	ETF	205.54	205.88	205.4	205.67	8047069.0
2015-01-23 10:30:00	SPY	ETF	205.661	205.88	205.02	205.68	9579897.0
2015-01-23 11:00:00	SPY	ETF	205.68	205.91	205.41	205.85	5586695.0
2015-01-23 11:30:00	SPY	ETF	205.86	205.89	205.55	205.64	4295872.0
2015-01-23 12:00:00	SPY	ETF	205.63	205.97	205.51	205.75	4038803.0
2015-01-23 12:30:00	SPY	ETF	205.76	206.1	205.7532	205.92	3732274.0
2015-01-23 13:00:00	SPY	ETF	205.925	205.97	205.57	205.71	4895739.0
2015-01-23 13:30:00	SPY	ETF	205.71	206.07	205.67	205.91	4364729.0
2015-01-23 14:00:00	SPY	ETF	205.92	206.02	205.629	205.81	4310574.0
2015-01-23 14:30:00	SPY	ETF	205.8	205.84	205.38	205.396	5229468.0
2015-01-23 15:00:00	SPY	ETF	205.398	205.48	205.17	205.4	10532062.0
2015-01-23 15:30:00	SPY	ETF	205.39	205.4	204.81	204.95	19287024.0
2015-01-23 16:00:00	SPY	ETF	204.96	205.092	204.76	204.78	8754244.0
2015-01-23 16:30:00	SPY	ETF	204.78	205.0	204.69	204.75	938734.0
2015-01-23 17:00:00	SPY	ETF	204.73	204.97	204.6	204.6	754436.0
2015-01-23 17:30:00	SPY	ETF	204.6	204.66	204.54	204.66	37790.0
2015-01-23 18:00:00	SPY	ETF	204.66	204.71	204.45	204.57	114608.0
2015-01-23 18:30:00	SPY	ETF	204.58	204.6	204.52	204.54	8006.0
2015-01-23 19:00:00	SPY	ETF	204.56	204.61	204.52	204.61	6523.0
2015-01-23 19:30:00	SPY	ETF	204.58	204.63	204.52	204.52	25604.0
2015-01-23 04:30:00	QQQ	ETF	104.1	104.1	104.0	104.0	900.0
2015-01-23 05:30:00	QQQ	ETF	103.98	103.98	103.96	103.96	300.0
2015-01-23 06:00:00	QQQ	ETF	104.03	104.13	104.02	104.12	2000.0
2015-01-23 06:30:00	QQQ	ETF	104.14	104.15	104.13	104.13	10000.0
2015-01-23 07:00:00	QQQ	ETF	104.03	104.14	104.03	104.14	5900.0
2015-01-23 07:30:00	QQQ	ETF	104.12	104.29	104.12	104.19	52743.0
2015-01-23 08:00:00	QQQ	ETF	104.2	104.25	104.16	104.25	28793.0
2015-01-23 08:30:00	QQQ	ETF	104.22	104.22	103.97	104.06	59733.0
2015-01-23 09:00:00	QQQ	ETF	103.99	104.05	103.86	104.03	414780.0
2015-01-23 09:30:00	QQQ	ETF	104.02	104.2099	103.72	104.17	4923871.0
2015-01-23 10:00:00	QQQ	ETF	104.16	104.31	103.97	104.04	2214154.0
2015-01-23 10:30:00	QQQ	ETF	104.0493	104.23	103.75	104.108	1987103.0
2015-01-23 11:00:00	QQQ	ETF	104.1	104.32	103.99	104.29	1079082.0
2015-01-23 11:30:00	QQQ	ETF	104.29	104.3	104.08	104.1632	1125569.0
2015-01-23 12:00:00	QQQ	ETF	104.17	104.38	104.08	104.22	1569311.0
2015-01-23 12:30:00	QQQ	ETF	104.22	104.44	104.22	104.39	985397.0
2015-01-23 13:00:00	QQQ	ETF	104.38	104.44	104.26	104.3699	977174.0
2015-01-23 13:30:00	QQQ	ETF	104.37	104.58	104.36	104.52	1407434.0

> showing 50 of 13,066 rows — these rows as CSV

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