PREVIEW / etf_30min / 2016-07-08

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-07-08.parquet
  size:    410 KB
  rows:    13,894

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-07-08 04:00:00	SPY	ETF	209.93	210.11	209.93	210.01	4409.0
2016-07-08 04:30:00	SPY	ETF	209.99	209.99	209.64	209.79	13458.0
2016-07-08 05:00:00	SPY	ETF	209.77	209.82	209.49	209.69	7111.0
2016-07-08 05:30:00	SPY	ETF	209.73	210.05	209.73	210.02	9997.0
2016-07-08 06:00:00	SPY	ETF	210.04	210.09	209.89	210.02	8041.0
2016-07-08 06:30:00	SPY	ETF	209.97	210.18	209.97	210.11	9869.0
2016-07-08 07:00:00	SPY	ETF	210.14	210.29	210.05	210.18	67172.0
2016-07-08 07:30:00	SPY	ETF	210.26	210.3	210.17	210.22	205273.0
2016-07-08 08:00:00	SPY	ETF	210.2	210.24	209.519	210.11	306029.0
2016-07-08 08:30:00	SPY	ETF	210.44	211.41	210.17	211.24	3615229.0
2016-07-08 09:00:00	SPY	ETF	211.23	211.31	210.79	211.06	1992706.0
2016-07-08 09:30:00	SPY	ETF	211.05	211.49	210.7785	211.3501	14983617.0
2016-07-08 10:00:00	SPY	ETF	211.355	211.78	211.32	211.59	11797296.0
2016-07-08 10:30:00	SPY	ETF	211.585	211.98	211.46	211.91	7993148.0
2016-07-08 11:00:00	SPY	ETF	211.91	212.26	211.84	212.18	12447380.0
2016-07-08 11:30:00	SPY	ETF	212.18	212.24	212.05	212.14	4665378.0
2016-07-08 12:00:00	SPY	ETF	212.14	212.24	212.04	212.05	6826760.0
2016-07-08 12:30:00	SPY	ETF	212.06	212.225	212.01	212.1759	3325132.0
2016-07-08 13:00:00	SPY	ETF	212.17	212.395	212.17	212.371	4632480.0
2016-07-08 13:30:00	SPY	ETF	212.3799	212.47	212.33	212.4	3602664.0
2016-07-08 14:00:00	SPY	ETF	212.4	212.69	212.335	212.655	7172935.0
2016-07-08 14:30:00	SPY	ETF	212.655	212.94	212.62	212.71	9328729.0
2016-07-08 15:00:00	SPY	ETF	212.72	212.78	212.51	212.525	7623525.0
2016-07-08 15:30:00	SPY	ETF	212.52	212.79	212.39	212.65	17542419.0
2016-07-08 16:00:00	SPY	ETF	212.64	212.7115	212.4	212.46	11886589.0
2016-07-08 16:30:00	SPY	ETF	212.46	212.65	212.41	212.49	986860.0
2016-07-08 17:00:00	SPY	ETF	212.51	212.7	212.49	212.58	175239.0
2016-07-08 17:30:00	SPY	ETF	212.58	212.6	212.47	212.56	92773.0
2016-07-08 18:00:00	SPY	ETF	212.55	212.6	212.53	212.54	19406.0
2016-07-08 18:30:00	SPY	ETF	212.57	212.58	212.51	212.56	10057.0
2016-07-08 19:00:00	SPY	ETF	212.53	212.56	212.51	212.53	10761.0
2016-07-08 19:30:00	SPY	ETF	212.51	212.55	212.43	212.55	15668.0
2016-07-08 04:00:00	QQQ	ETF	108.89	108.89	108.89	108.89	486.0
2016-07-08 04:30:00	QQQ	ETF	108.57	108.57	108.57	108.57	299.0
2016-07-08 05:00:00	QQQ	ETF	108.52	108.52	108.45	108.45	1200.0
2016-07-08 05:30:00	QQQ	ETF	108.68	108.68	108.68	108.68	100.0
2016-07-08 06:00:00	QQQ	ETF	108.73	108.76	108.73	108.76	200.0
2016-07-08 06:30:00	QQQ	ETF	108.82	108.82	108.82	108.82	100.0
2016-07-08 07:00:00	QQQ	ETF	108.84	108.85	108.83	108.83	5200.0
2016-07-08 07:30:00	QQQ	ETF	108.85	108.85	108.8	108.83	82340.0
2016-07-08 08:00:00	QQQ	ETF	108.82	108.83	108.75	108.77	78092.0
2016-07-08 08:30:00	QQQ	ETF	108.81	109.35	108.5	109.24	499339.0
2016-07-08 09:00:00	QQQ	ETF	109.25	109.25	109.02	109.17	347715.0
2016-07-08 09:30:00	QQQ	ETF	109.17	109.705	109.02	109.5993	4215229.0
2016-07-08 10:00:00	QQQ	ETF	109.6	109.77	109.56	109.71	2665110.0
2016-07-08 10:30:00	QQQ	ETF	109.7099	109.965	109.65	109.9415	1953948.0
2016-07-08 11:00:00	QQQ	ETF	109.95	110.13	109.91	110.07	1739272.0
2016-07-08 11:30:00	QQQ	ETF	110.075	110.1	109.955	110.0227	970247.0
2016-07-08 12:00:00	QQQ	ETF	110.0239	110.07	109.96	109.97	743726.0
2016-07-08 12:30:00	QQQ	ETF	109.975	110.06	109.93	110.0	848857.0

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

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