PREVIEW / etf_30min / 2017-08-08

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-08-08.parquet
  size:    443 KB
  rows:    15,249

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-08 04:00:00	SPY	ETF	247.81	247.81	247.81	247.81	632.0
2017-08-08 04:30:00	SPY	ETF	247.65	247.65	247.65	247.65	1000.0
2017-08-08 05:00:00	SPY	ETF	247.65	247.65	247.65	247.65	100.0
2017-08-08 05:30:00	SPY	ETF	247.71	247.71	247.71	247.71	1000.0
2017-08-08 06:00:00	SPY	ETF	247.71	247.71	247.71	247.71	4100.0
2017-08-08 06:30:00	SPY	ETF	247.67	247.71	247.67	247.71	2100.0
2017-08-08 07:00:00	SPY	ETF	247.73	247.74	247.57	247.57	61986.0
2017-08-08 07:30:00	SPY	ETF	247.52	247.54	247.45	247.51	291170.0
2017-08-08 08:00:00	SPY	ETF	247.53	247.59	247.5	247.55	156830.0
2017-08-08 08:30:00	SPY	ETF	247.54	247.55	247.47	247.53	131824.0
2017-08-08 09:00:00	SPY	ETF	247.53	247.55	247.48	247.51	253578.0
2017-08-08 09:30:00	SPY	ETF	247.51	247.65	247.33	247.61	3684519.0
2017-08-08 10:00:00	SPY	ETF	247.61	247.85	247.5701	247.8	2547769.0
2017-08-08 10:30:00	SPY	ETF	247.795	248.32	247.69	248.3	3422209.0
2017-08-08 11:00:00	SPY	ETF	248.3	248.41	248.25	248.3311	3171465.0
2017-08-08 11:30:00	SPY	ETF	248.3305	248.81	248.31	248.78	3494264.0
2017-08-08 12:00:00	SPY	ETF	248.79	248.91	248.64	248.65	3600707.0
2017-08-08 12:30:00	SPY	ETF	248.66	248.715	248.28	248.29	2332647.0
2017-08-08 13:00:00	SPY	ETF	248.29	248.36	248.04	248.05	2261298.0
2017-08-08 13:30:00	SPY	ETF	248.0499	248.18	247.8625	248.12	2477212.0
2017-08-08 14:00:00	SPY	ETF	248.12	248.14	247.93	248.06	1212557.0
2017-08-08 14:30:00	SPY	ETF	248.06	248.1	247.74	247.79	2896484.0
2017-08-08 15:00:00	SPY	ETF	247.79	247.83	247.15	247.36	5396216.0
2017-08-08 15:30:00	SPY	ETF	247.365	247.38	246.83	247.291	13759344.0
2017-08-08 16:00:00	SPY	ETF	247.29	247.43	247.21	247.39	7470442.0
2017-08-08 16:30:00	SPY	ETF	247.39	247.9958	247.21	247.24	1279532.0
2017-08-08 17:00:00	SPY	ETF	247.22	247.32	247.17	247.26	121301.0
2017-08-08 17:30:00	SPY	ETF	247.27	247.3	247.08	247.08	109972.0
2017-08-08 18:00:00	SPY	ETF	247.06	247.09	246.87	246.93	85247.0
2017-08-08 18:30:00	SPY	ETF	246.94	247.11	246.94	246.99	28321.0
2017-08-08 19:00:00	SPY	ETF	246.98	247.0	246.91	246.95	18311.0
2017-08-08 19:30:00	SPY	ETF	246.93	246.93	246.74	246.84	65937.0
2017-08-08 04:30:00	QQQ	ETF	144.49	144.49	144.49	144.49	700.0
2017-08-08 05:00:00	QQQ	ETF	144.46	144.46	144.46	144.46	100.0
2017-08-08 05:30:00	QQQ	ETF	144.52	144.55	144.52	144.55	15000.0
2017-08-08 06:00:00	QQQ	ETF	144.54	144.54	144.54	144.54	100.0
2017-08-08 06:30:00	QQQ	ETF	144.52	144.54	144.52	144.54	10000.0
2017-08-08 07:00:00	QQQ	ETF	144.5	144.5	144.38	144.38	10700.0
2017-08-08 07:30:00	QQQ	ETF	144.35	144.41	144.33	144.41	224560.0
2017-08-08 08:00:00	QQQ	ETF	144.37	144.42	144.34	144.37	28068.0
2017-08-08 08:30:00	QQQ	ETF	144.35	144.35	144.21	144.25	24231.0
2017-08-08 09:00:00	QQQ	ETF	144.25	144.31	144.24	144.24	81355.0
2017-08-08 09:30:00	QQQ	ETF	144.27	144.36	144.0	144.3	2597896.0
2017-08-08 10:00:00	QQQ	ETF	144.305	144.425	144.24	144.33	1155268.0
2017-08-08 10:30:00	QQQ	ETF	144.33	144.7	144.26	144.69	1664022.0
2017-08-08 11:00:00	QQQ	ETF	144.68	144.7654	144.6	144.7354	1105497.0
2017-08-08 11:30:00	QQQ	ETF	144.74	145.34	144.725	145.3	2391460.0
2017-08-08 12:00:00	QQQ	ETF	145.3	145.47	145.22	145.37	2012183.0
2017-08-08 12:30:00	QQQ	ETF	145.37	145.378	145.16	145.17	1334567.0
2017-08-08 13:00:00	QQQ	ETF	145.165	145.26	144.99	144.99	907798.0

> showing 50 of 15,249 rows — these rows as CSV

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