PREVIEW / etf_30min / 2016-06-16

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-06-16.parquet
  size:    404 KB
  rows:    13,663

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-06-16 04:00:00	SPY	ETF	207.12	207.12	206.81	206.92	7949.0
2016-06-16 04:30:00	SPY	ETF	207.07	207.07	206.92	207.01	2585.0
2016-06-16 05:00:00	SPY	ETF	207.02	207.14	207.0	207.01	4138.0
2016-06-16 05:30:00	SPY	ETF	207.05	207.2	207.0	207.2	14411.0
2016-06-16 06:00:00	SPY	ETF	207.18	207.2	207.1	207.2	32971.0
2016-06-16 06:30:00	SPY	ETF	207.2	207.2	207.01	207.06	43702.0
2016-06-16 07:00:00	SPY	ETF	207.1	207.1	206.74	206.75	351338.0
2016-06-16 07:30:00	SPY	ETF	206.72	206.95	206.71	206.85	200849.0
2016-06-16 08:00:00	SPY	ETF	206.88	207.75	206.64	206.69	631951.0
2016-06-16 08:30:00	SPY	ETF	206.68	206.98	206.61	206.79	685269.0
2016-06-16 09:00:00	SPY	ETF	206.79	206.81	206.58	206.72	618855.0
2016-06-16 09:30:00	SPY	ETF	206.73	206.84	205.9	205.901	11909885.0
2016-06-16 10:00:00	SPY	ETF	205.9	206.375	205.7	206.025	13231023.0
2016-06-16 10:30:00	SPY	ETF	206.025	206.12	205.59	206.11	8892436.0
2016-06-16 11:00:00	SPY	ETF	206.1	206.87	206.05	206.83	10160052.0
2016-06-16 11:30:00	SPY	ETF	206.83	206.95	206.22	206.26	6771465.0
2016-06-16 12:00:00	SPY	ETF	206.255	207.3	206.13	207.15	10513378.0
2016-06-16 12:30:00	SPY	ETF	207.15	207.7	206.98	207.34	10032074.0
2016-06-16 13:00:00	SPY	ETF	207.35	207.72	207.2825	207.365	9531546.0
2016-06-16 13:30:00	SPY	ETF	207.36	207.51	206.99	207.085	6653315.0
2016-06-16 14:00:00	SPY	ETF	207.09	208.01	207.03	207.64	8747781.0
2016-06-16 14:30:00	SPY	ETF	207.64	208.1628	207.58	207.845	8523559.0
2016-06-16 15:00:00	SPY	ETF	207.85	208.42	207.776	208.33	11007613.0
2016-06-16 15:30:00	SPY	ETF	208.33	208.57	208.25	208.42	16932744.0
2016-06-16 16:00:00	SPY	ETF	208.42	208.54	207.6581	208.45	8716327.0
2016-06-16 16:30:00	SPY	ETF	208.43	208.47	208.33	208.36	328499.0
2016-06-16 17:00:00	SPY	ETF	208.35	208.41	208.23	208.28	187465.0
2016-06-16 17:30:00	SPY	ETF	208.29	208.3	207.61	208.27	207701.0
2016-06-16 18:00:00	SPY	ETF	208.27	208.52	208.26	208.5	178245.0
2016-06-16 18:30:00	SPY	ETF	208.5	208.54	208.44	208.48	61948.0
2016-06-16 19:00:00	SPY	ETF	208.5	208.58	208.45	208.54	28352.0
2016-06-16 19:30:00	SPY	ETF	208.58	208.73	208.56	208.73	37501.0
2016-06-16 04:00:00	QQQ	ETF	107.2	107.26	107.15	107.26	17313.0
2016-06-16 04:30:00	QQQ	ETF	107.28	107.29	107.24	107.27	4100.0
2016-06-16 05:00:00	QQQ	ETF	107.27	107.35	107.25	107.25	11925.0
2016-06-16 05:30:00	QQQ	ETF	107.3	107.36	107.3	107.36	4600.0
2016-06-16 06:00:00	QQQ	ETF	107.35	107.36	107.35	107.36	200.0
2016-06-16 06:30:00	QQQ	ETF	107.4	107.4	107.35	107.4	2200.0
2016-06-16 07:00:00	QQQ	ETF	107.35	107.36	107.19	107.19	5700.0
2016-06-16 07:30:00	QQQ	ETF	107.19	107.31	107.17	107.26	44500.0
2016-06-16 08:00:00	QQQ	ETF	107.25	107.27	107.16	107.16	104001.0
2016-06-16 08:30:00	QQQ	ETF	107.17	107.31	107.15	107.29	51760.0
2016-06-16 09:00:00	QQQ	ETF	107.26	107.28	107.15	107.16	91092.0
2016-06-16 09:30:00	QQQ	ETF	107.17	107.27	106.77	106.8	2753783.0
2016-06-16 10:00:00	QQQ	ETF	106.79	106.89	106.61	106.695	2259323.0
2016-06-16 10:30:00	QQQ	ETF	106.69	106.73	106.5	106.6785	1924905.0
2016-06-16 11:00:00	QQQ	ETF	106.67	107.0132	106.64	106.99	2270584.0
2016-06-16 11:30:00	QQQ	ETF	106.985	107.07	106.7	106.72	1420914.0
2016-06-16 12:00:00	QQQ	ETF	106.73	107.37	106.66	107.28	1993242.0
2016-06-16 12:30:00	QQQ	ETF	107.29	107.58	107.19	107.46	1944022.0

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

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