PREVIEW / etf_30min / 2017-08-02

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-08-02.parquet
  size:    433 KB
  rows:    14,969

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
2017-08-02 04:00:00	SPY	ETF	247.46	247.46	247.38	247.38	3090.0
2017-08-02 04:30:00	SPY	ETF	247.34	247.34	247.34	247.34	100.0
2017-08-02 05:30:00	SPY	ETF	247.46	247.47	247.41	247.43	3701.0
2017-08-02 06:00:00	SPY	ETF	247.45	247.55	247.43	247.55	27900.0
2017-08-02 06:30:00	SPY	ETF	247.54	247.54	247.35	247.35	8073.0
2017-08-02 07:00:00	SPY	ETF	247.3	247.32	247.29	247.29	14575.0
2017-08-02 07:30:00	SPY	ETF	247.28	247.32	247.26	247.32	38064.0
2017-08-02 08:00:00	SPY	ETF	247.32	247.45	247.28	247.45	60418.0
2017-08-02 08:30:00	SPY	ETF	247.46	247.52	247.43	247.48	69013.0
2017-08-02 09:00:00	SPY	ETF	247.5	247.55	247.42	247.47	297933.0
2017-08-02 09:30:00	SPY	ETF	247.47	247.6	247.1276	247.18	4683289.0
2017-08-02 10:00:00	SPY	ETF	247.18	247.48	246.635	246.69	4579008.0
2017-08-02 10:30:00	SPY	ETF	246.69	246.88	246.37	246.48	4864502.0
2017-08-02 11:00:00	SPY	ETF	246.48	246.88	246.39	246.88	3096469.0
2017-08-02 11:30:00	SPY	ETF	246.885	247.0	246.74	246.805	2462848.0
2017-08-02 12:00:00	SPY	ETF	246.82	246.85	246.65	246.66	1825278.0
2017-08-02 12:30:00	SPY	ETF	246.65	246.78	246.625	246.725	1204992.0
2017-08-02 13:00:00	SPY	ETF	246.73	246.96	246.6	246.93	1895721.0
2017-08-02 13:30:00	SPY	ETF	246.93	247.21	246.87	247.17	2322186.0
2017-08-02 14:00:00	SPY	ETF	247.18	247.24	247.09	247.15	1487970.0
2017-08-02 14:30:00	SPY	ETF	247.15	247.42	247.14	247.34	2021681.0
2017-08-02 15:00:00	SPY	ETF	247.34	247.43	247.18	247.24	2151001.0
2017-08-02 15:30:00	SPY	ETF	247.24	247.5	247.14	247.44	6718290.0
2017-08-02 16:00:00	SPY	ETF	247.43	247.51	247.34	247.35	5429501.0
2017-08-02 16:30:00	SPY	ETF	247.36	247.44	247.0881	247.4	591212.0
2017-08-02 17:00:00	SPY	ETF	247.38	247.38	247.31	247.32	45053.0
2017-08-02 17:30:00	SPY	ETF	247.32	247.4882	247.32	247.32	275340.0
2017-08-02 18:00:00	SPY	ETF	247.31	247.35	247.31	247.33	13915.0
2017-08-02 18:30:00	SPY	ETF	247.3	247.36	247.3	247.32	16775.0
2017-08-02 19:00:00	SPY	ETF	247.32	247.35	247.28	247.28	8041.0
2017-08-02 19:30:00	SPY	ETF	247.27	247.28	247.23	247.27	18940.0
2017-08-02 04:00:00	QQQ	ETF	144.54	144.54	144.54	144.54	1500.0
2017-08-02 04:30:00	QQQ	ETF	144.48	144.5	144.45	144.45	5300.0
2017-08-02 05:00:00	QQQ	ETF	144.49	144.54	144.49	144.54	550.0
2017-08-02 05:30:00	QQQ	ETF	144.55	144.55	144.55	144.55	100.0
2017-08-02 06:00:00	QQQ	ETF	144.52	144.63	144.52	144.63	4895.0
2017-08-02 06:30:00	QQQ	ETF	144.66	144.66	144.48	144.48	3800.0
2017-08-02 07:00:00	QQQ	ETF	144.47	144.49	144.41	144.41	12384.0
2017-08-02 07:30:00	QQQ	ETF	144.35	144.37	144.28	144.35	108606.0
2017-08-02 08:00:00	QQQ	ETF	144.34	144.48	144.3	144.48	138481.0
2017-08-02 08:30:00	QQQ	ETF	144.48	144.52	144.38	144.47	70682.0
2017-08-02 09:00:00	QQQ	ETF	144.45	144.52	144.43	144.45	203445.0
2017-08-02 09:30:00	QQQ	ETF	144.45	144.52	143.82	143.89	5182870.0
2017-08-02 10:00:00	QQQ	ETF	143.9017	144.15	143.08	143.16	4535497.0
2017-08-02 10:30:00	QQQ	ETF	143.165	143.49	142.72	142.85	4659519.0
2017-08-02 11:00:00	QQQ	ETF	142.86	143.17	142.61	143.115	3372961.0
2017-08-02 11:30:00	QQQ	ETF	143.115	143.33	142.97	143.18	1903858.0
2017-08-02 12:00:00	QQQ	ETF	143.19	143.32	143.1	143.15	1457650.0
2017-08-02 12:30:00	QQQ	ETF	143.1446	143.26	143.03	143.15	962785.0
2017-08-02 13:00:00	QQQ	ETF	143.15	143.38	142.93	143.36	1201870.0

> showing 50 of 14,969 rows — these rows as CSV

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