PREVIEW / etf_30min / 2016-02-26

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-02-26.parquet
  size:    388 KB
  rows:    13,084

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-02-26 04:00:00	SPY	ETF	196.5	196.88	196.5	196.88	37876.0
2016-02-26 04:30:00	SPY	ETF	196.88	197.26	196.84	197.26	20413.0
2016-02-26 05:00:00	SPY	ETF	197.29	197.45	197.19	197.19	60381.0
2016-02-26 05:30:00	SPY	ETF	197.16	197.25	197.1	197.21	24216.0
2016-02-26 06:00:00	SPY	ETF	197.18	197.18	196.94	197.1	89695.0
2016-02-26 06:30:00	SPY	ETF	197.05	197.07	196.55	196.57	249379.0
2016-02-26 07:00:00	SPY	ETF	196.64	196.75	196.4	196.57	211714.0
2016-02-26 07:30:00	SPY	ETF	196.54	196.61	196.29	196.41	294047.0
2016-02-26 08:00:00	SPY	ETF	196.72	197.1	195.46	196.74	813848.0
2016-02-26 08:30:00	SPY	ETF	196.8	197.15	196.6	196.66	1096588.0
2016-02-26 09:00:00	SPY	ETF	196.65	196.83	196.46	196.56	601602.0
2016-02-26 09:30:00	SPY	ETF	196.57	196.68	196.09	196.16	13146294.0
2016-02-26 10:00:00	SPY	ETF	196.16	196.21	195.52	195.7034	10057663.0
2016-02-26 10:30:00	SPY	ETF	195.7	196.43	195.69	196.4011	9654092.0
2016-02-26 11:00:00	SPY	ETF	196.4	196.49	195.75	195.76	6049212.0
2016-02-26 11:30:00	SPY	ETF	195.76	196.45	195.535	195.83	8444956.0
2016-02-26 12:00:00	SPY	ETF	195.83	195.93	195.36	195.81	6036137.0
2016-02-26 12:30:00	SPY	ETF	195.81	196.26	195.68	196.09	6762557.0
2016-02-26 13:00:00	SPY	ETF	196.08	196.219	195.73	195.77	6912015.0
2016-02-26 13:30:00	SPY	ETF	195.77	195.93	195.26	195.49	5495185.0
2016-02-26 14:00:00	SPY	ETF	195.49	195.67	195.3	195.5401	4737662.0
2016-02-26 14:30:00	SPY	ETF	195.54	195.54	194.9	194.9901	7146704.0
2016-02-26 15:00:00	SPY	ETF	194.99	195.52	194.95	195.19	11744752.0
2016-02-26 15:30:00	SPY	ETF	195.185	195.45	195.07	195.13	16054864.0
2016-02-26 16:00:00	SPY	ETF	195.13	195.5124	194.8	194.93	9138392.0
2016-02-26 16:30:00	SPY	ETF	194.93	195.2124	194.77	194.77	885358.0
2016-02-26 17:00:00	SPY	ETF	194.78	195.1	194.77	194.78	85413.0
2016-02-26 17:30:00	SPY	ETF	194.79	195.0892	194.78	194.8	474341.0
2016-02-26 18:00:00	SPY	ETF	194.85	194.88	194.81	194.81	10270.0
2016-02-26 18:30:00	SPY	ETF	194.81	194.86	194.8	194.8	15869.0
2016-02-26 19:00:00	SPY	ETF	194.78	194.84	194.77	194.83	6010.0
2016-02-26 19:30:00	SPY	ETF	194.83	194.87	194.76	194.87	9969.0
2016-02-26 04:00:00	QQQ	ETF	104.33	104.5	104.33	104.43	1060.0
2016-02-26 04:30:00	QQQ	ETF	104.55	104.66	104.55	104.66	700.0
2016-02-26 05:00:00	QQQ	ETF	104.75	104.76	104.69	104.69	15097.0
2016-02-26 05:30:00	QQQ	ETF	104.64	104.64	104.64	104.64	500.0
2016-02-26 06:00:00	QQQ	ETF	104.58	104.58	104.49	104.52	4197.0
2016-02-26 06:30:00	QQQ	ETF	104.54	104.54	104.25	104.29	5953.0
2016-02-26 07:00:00	QQQ	ETF	104.31	104.31	104.2	104.27	25034.0
2016-02-26 07:30:00	QQQ	ETF	104.26	104.3	104.16	104.2	14719.0
2016-02-26 08:00:00	QQQ	ETF	104.21	104.42	104.17	104.39	79601.0
2016-02-26 08:30:00	QQQ	ETF	104.42	104.59	104.3	104.31	214600.0
2016-02-26 09:00:00	QQQ	ETF	104.31	104.43	104.22	104.3	116265.0
2016-02-26 09:30:00	QQQ	ETF	104.28	104.3659	103.9799	104.01	4473712.0
2016-02-26 10:00:00	QQQ	ETF	104.01	104.03	103.54	103.65	2419389.0
2016-02-26 10:30:00	QQQ	ETF	103.66	103.99	103.65	103.95	1469472.0
2016-02-26 11:00:00	QQQ	ETF	103.94	104.01	103.59	103.59	1270009.0
2016-02-26 11:30:00	QQQ	ETF	103.58	103.635	103.43	103.54	2142487.0
2016-02-26 12:00:00	QQQ	ETF	103.54	103.54	103.1835	103.36	1522954.0
2016-02-26 12:30:00	QQQ	ETF	103.38	103.675	103.3	103.58	1429566.0

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

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