PREVIEW / etf_30min / 2016-04-26

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-04-26.parquet
  size:    389 KB
  rows:    13,229

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-04-26 04:00:00	SPY	ETF	209.29	209.43	209.19	209.28	60217.0
2016-04-26 04:30:00	SPY	ETF	209.26	209.31	209.16	209.18	63133.0
2016-04-26 05:00:00	SPY	ETF	209.05	209.31	209.05	209.31	1063.0
2016-04-26 05:30:00	SPY	ETF	209.31	209.34	209.03	209.06	12189.0
2016-04-26 06:00:00	SPY	ETF	209.01	209.1	208.95	209.09	45368.0
2016-04-26 06:30:00	SPY	ETF	209.07	209.07	208.9	208.9	26646.0
2016-04-26 07:00:00	SPY	ETF	208.95	209.08	208.94	208.94	33700.0
2016-04-26 07:30:00	SPY	ETF	208.94	209.2	208.93	209.16	105524.0
2016-04-26 08:00:00	SPY	ETF	209.18	209.27	209.14	209.16	213405.0
2016-04-26 08:30:00	SPY	ETF	209.16	209.16	208.95	209.12	239209.0
2016-04-26 09:00:00	SPY	ETF	209.12	209.15	209.0	209.04	121812.0
2016-04-26 09:30:00	SPY	ETF	209.04	209.46	208.81	209.4492	7017301.0
2016-04-26 10:00:00	SPY	ETF	209.46	209.52	208.71	208.73	7951570.0
2016-04-26 10:30:00	SPY	ETF	208.73	208.82	208.465	208.5	5189686.0
2016-04-26 11:00:00	SPY	ETF	208.49	208.81	208.36	208.77	4471956.0
2016-04-26 11:30:00	SPY	ETF	208.76	209.01	208.64	208.92	3414240.0
2016-04-26 12:00:00	SPY	ETF	208.91	209.14	208.91	209.0464	3416014.0
2016-04-26 12:30:00	SPY	ETF	209.04	209.08	208.76	208.8	3453511.0
2016-04-26 13:00:00	SPY	ETF	208.8	208.84	208.6	208.775	5106517.0
2016-04-26 13:30:00	SPY	ETF	208.775	208.88	208.5	208.64	2932878.0
2016-04-26 14:00:00	SPY	ETF	208.65	208.89	208.56	208.58	2937756.0
2016-04-26 14:30:00	SPY	ETF	208.58	208.93	208.5499	208.67	4164164.0
2016-04-26 15:00:00	SPY	ETF	208.67	208.81	208.39	208.64	4219243.0
2016-04-26 15:30:00	SPY	ETF	208.65	209.0	208.64	208.97	10563785.0
2016-04-26 16:00:00	SPY	ETF	208.98	209.33	208.8293	209.27	5483768.0
2016-04-26 16:30:00	SPY	ETF	209.19	209.19	208.5767	208.83	1332594.0
2016-04-26 17:00:00	SPY	ETF	208.76	208.76	208.48	208.53	472124.0
2016-04-26 17:30:00	SPY	ETF	208.53	208.62	208.49	208.61	156862.0
2016-04-26 18:00:00	SPY	ETF	208.62	208.72	208.48	208.72	181581.0
2016-04-26 18:30:00	SPY	ETF	208.69	208.75	208.69	208.75	40714.0
2016-04-26 19:00:00	SPY	ETF	208.75	208.82	208.73	208.82	12397.0
2016-04-26 19:30:00	SPY	ETF	208.82	208.87	208.75	208.77	41651.0
2016-04-26 04:00:00	QQQ	ETF	109.36	109.36	109.36	109.36	420.0
2016-04-26 05:00:00	QQQ	ETF	109.33	109.33	109.33	109.33	200.0
2016-04-26 07:00:00	QQQ	ETF	109.14	109.19	109.11	109.11	8548.0
2016-04-26 07:30:00	QQQ	ETF	109.1	109.26	109.1	109.25	800.0
2016-04-26 08:00:00	QQQ	ETF	109.22	109.26	109.21	109.24	13287.0
2016-04-26 08:30:00	QQQ	ETF	109.22	109.27	109.18	109.26	29906.0
2016-04-26 09:00:00	QQQ	ETF	109.24	109.27	109.19	109.2	24944.0
2016-04-26 09:30:00	QQQ	ETF	109.2	109.39	108.97	109.315	2046119.0
2016-04-26 10:00:00	QQQ	ETF	109.32	109.38	108.66	108.67	1683891.0
2016-04-26 10:30:00	QQQ	ETF	108.67	108.81	108.41	108.47	1180740.0
2016-04-26 11:00:00	QQQ	ETF	108.47	108.62	108.41	108.58	913450.0
2016-04-26 11:30:00	QQQ	ETF	108.59	108.7085	108.49	108.63	636739.0
2016-04-26 12:00:00	QQQ	ETF	108.64	108.79	108.64	108.7099	994384.0
2016-04-26 12:30:00	QQQ	ETF	108.71	108.7276	108.46	108.46	426216.0
2016-04-26 13:00:00	QQQ	ETF	108.468	108.559	108.36	108.52	488204.0
2016-04-26 13:30:00	QQQ	ETF	108.52	108.605	108.35	108.45	473395.0
2016-04-26 14:00:00	QQQ	ETF	108.45	108.5	108.24	108.25	822019.0
2016-04-26 14:30:00	QQQ	ETF	108.25	108.49	108.23	108.28	805227.0

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

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