PREVIEW / etf_30min / 2014-12-10

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-12-10.parquet
  size:    378 KB
  rows:    12,581

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-12-10 04:00:00	SPY	ETF	206.24	206.28	206.2	206.2	1000.0
2014-12-10 04:30:00	SPY	ETF	206.21	206.21	206.21	206.21	100.0
2014-12-10 05:00:00	SPY	ETF	206.2	206.3	206.14	206.17	5300.0
2014-12-10 05:30:00	SPY	ETF	206.21	206.23	206.21	206.23	5120.0
2014-12-10 06:00:00	SPY	ETF	206.25	206.25	206.17	206.17	1755.0
2014-12-10 06:30:00	SPY	ETF	206.14	206.18	206.12	206.15	115155.0
2014-12-10 07:00:00	SPY	ETF	206.15	206.32	206.09	206.09	138848.0
2014-12-10 07:30:00	SPY	ETF	206.09	206.12	205.7	205.88	189717.0
2014-12-10 08:00:00	SPY	ETF	205.89	206.47	205.76	205.95	383368.0
2014-12-10 08:30:00	SPY	ETF	205.94	206.04	205.83	205.89	342585.0
2014-12-10 09:00:00	SPY	ETF	205.88	205.94	205.74	205.92	620962.0
2014-12-10 09:30:00	SPY	ETF	205.91	205.98	205.14	205.37	13223328.0
2014-12-10 10:00:00	SPY	ETF	205.37	205.5	204.99	205.256	8429930.0
2014-12-10 10:30:00	SPY	ETF	205.25	205.45	204.69	205.45	9614632.0
2014-12-10 11:00:00	SPY	ETF	205.45	205.465	204.92	204.95	5594319.0
2014-12-10 11:30:00	SPY	ETF	204.94	205.36	204.76	205.2799	7112136.0
2014-12-10 12:00:00	SPY	ETF	205.29	205.295	204.7	204.82	4684288.0
2014-12-10 12:30:00	SPY	ETF	204.82	205.16	204.62	204.9768	4332868.0
2014-12-10 13:00:00	SPY	ETF	204.96	205.23	204.9	205.09	4659832.0
2014-12-10 13:30:00	SPY	ETF	205.09	205.14	203.99	204.01	10358414.0
2014-12-10 14:00:00	SPY	ETF	204.0	204.27	203.615	203.74	10958176.0
2014-12-10 14:30:00	SPY	ETF	203.74	203.78	203.06	203.065	15303870.0
2014-12-10 15:00:00	SPY	ETF	203.06	203.96	202.93	203.87	19680751.0
2014-12-10 15:30:00	SPY	ETF	203.865	204.11	202.99	203.17	29993711.0
2014-12-10 16:00:00	SPY	ETF	203.18	205.35	203.05	203.25	6461540.0
2014-12-10 16:30:00	SPY	ETF	203.25	203.46	203.16	203.2	3868084.0
2014-12-10 17:00:00	SPY	ETF	203.21	204.2748	203.08	203.12	425236.0
2014-12-10 17:30:00	SPY	ETF	203.11	203.16	203.0	203.13	332777.0
2014-12-10 18:00:00	SPY	ETF	203.13	203.34	203.0	203.07	287745.0
2014-12-10 18:30:00	SPY	ETF	203.07	203.26	203.06	203.15	43521.0
2014-12-10 19:00:00	SPY	ETF	203.16	203.16	202.97	203.04	44538.0
2014-12-10 19:30:00	SPY	ETF	203.08	203.36	203.07	203.29	100283.0
2014-12-10 05:30:00	QQQ	ETF	104.79	104.79	104.79	104.79	2500.0
2014-12-10 06:00:00	QQQ	ETF	104.81	104.81	104.81	104.81	200.0
2014-12-10 06:30:00	QQQ	ETF	104.78	104.8	104.77	104.8	2100.0
2014-12-10 07:00:00	QQQ	ETF	104.84	104.9	104.81	104.81	25795.0
2014-12-10 07:30:00	QQQ	ETF	104.8	104.81	104.65	104.7	26326.0
2014-12-10 08:00:00	QQQ	ETF	104.88	104.88	104.66	104.77	23396.0
2014-12-10 08:30:00	QQQ	ETF	104.8	104.88	104.73	104.73	54327.0
2014-12-10 09:00:00	QQQ	ETF	104.72	104.8	104.69	104.79	155668.0
2014-12-10 09:30:00	QQQ	ETF	104.79	105.03	104.4743	104.65	5540651.0
2014-12-10 10:00:00	QQQ	ETF	104.65	104.71	104.42	104.44	2971241.0
2014-12-10 10:30:00	QQQ	ETF	104.44	104.68	104.16	104.68	2914199.0
2014-12-10 11:00:00	QQQ	ETF	104.675	104.68	104.43	104.47	1423742.0
2014-12-10 11:30:00	QQQ	ETF	104.47	104.69	104.315	104.66	1764969.0
2014-12-10 12:00:00	QQQ	ETF	104.66	104.66	104.23	104.28	1070723.0
2014-12-10 12:30:00	QQQ	ETF	104.28	104.4303	104.19	104.325	817096.0
2014-12-10 13:00:00	QQQ	ETF	104.33	104.52	104.28	104.51	826930.0
2014-12-10 13:30:00	QQQ	ETF	104.51	104.52	103.78	103.8	2057212.0
2014-12-10 14:00:00	QQQ	ETF	103.81	103.9	103.47	103.5972	3163103.0

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

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