PREVIEW / etf_30min / 2016-08-04

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-08-04.parquet
  size:    384 KB
  rows:    13,053

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-08-04 04:00:00	SPY	ETF	216.03	216.2	216.03	216.2	9201.0
2016-08-04 04:30:00	SPY	ETF	216.19	216.19	216.08	216.08	6906.0
2016-08-04 05:00:00	SPY	ETF	216.03	216.14	216.03	216.11	1058.0
2016-08-04 05:30:00	SPY	ETF	216.09	216.19	216.09	216.19	8803.0
2016-08-04 06:00:00	SPY	ETF	216.16	216.19	216.05	216.05	10154.0
2016-08-04 06:30:00	SPY	ETF	216.03	216.22	216.01	216.22	8313.0
2016-08-04 07:00:00	SPY	ETF	216.22	216.82	216.22	216.71	304301.0
2016-08-04 07:30:00	SPY	ETF	216.73	216.76	216.54	216.63	139601.0
2016-08-04 08:00:00	SPY	ETF	216.73	216.79	216.179	216.26	416529.0
2016-08-04 08:30:00	SPY	ETF	216.2	216.44	216.18	216.26	233464.0
2016-08-04 09:00:00	SPY	ETF	216.27	216.42	216.23	216.28	386424.0
2016-08-04 09:30:00	SPY	ETF	216.31	216.62	216.08	216.1	5360450.0
2016-08-04 10:00:00	SPY	ETF	216.09	216.175	215.83	216.11	4651724.0
2016-08-04 10:30:00	SPY	ETF	216.13	216.58	216.13	216.52	3337695.0
2016-08-04 11:00:00	SPY	ETF	216.501	216.56	214.25	216.39	3114936.0
2016-08-04 11:30:00	SPY	ETF	216.38	216.65	216.37	216.64	3289192.0
2016-08-04 12:00:00	SPY	ETF	216.638	216.78	216.57	216.6	2573564.0
2016-08-04 12:30:00	SPY	ETF	216.6	216.61	216.41	216.425	1897266.0
2016-08-04 13:00:00	SPY	ETF	216.43	216.45	216.22	216.3311	2171191.0
2016-08-04 13:30:00	SPY	ETF	216.33	216.38	216.26	216.35	1569224.0
2016-08-04 14:00:00	SPY	ETF	216.36	216.46	216.11	216.213	2438777.0
2016-08-04 14:30:00	SPY	ETF	216.21	216.31	216.15	216.3	1511271.0
2016-08-04 15:00:00	SPY	ETF	216.305	216.325	216.17	216.27	2239809.0
2016-08-04 15:30:00	SPY	ETF	216.275	216.5	216.27	216.41	5653200.0
2016-08-04 16:00:00	SPY	ETF	216.41	216.44	216.29	216.32	3373100.0
2016-08-04 16:30:00	SPY	ETF	216.32	216.45	216.32	216.42	460111.0
2016-08-04 17:00:00	SPY	ETF	216.4	216.4	216.29	216.36	141075.0
2016-08-04 17:30:00	SPY	ETF	216.39	216.39	216.35	216.36	785764.0
2016-08-04 18:00:00	SPY	ETF	216.36	216.42	216.36	216.4	50274.0
2016-08-04 18:30:00	SPY	ETF	216.39	216.42	216.39	216.39	6800.0
2016-08-04 19:00:00	SPY	ETF	216.4	216.47	216.39	216.46	16034.0
2016-08-04 19:30:00	SPY	ETF	216.46	216.5	216.45	216.5	27697.0
2016-08-04 04:00:00	QQQ	ETF	115.22	115.22	115.15	115.15	500.0
2016-08-04 05:30:00	QQQ	ETF	115.19	115.19	115.19	115.19	1600.0
2016-08-04 06:30:00	QQQ	ETF	115.22	115.22	115.22	115.22	1600.0
2016-08-04 07:00:00	QQQ	ETF	115.23	115.55	115.23	115.52	36486.0
2016-08-04 07:30:00	QQQ	ETF	115.5	115.51	115.43	115.48	57735.0
2016-08-04 08:00:00	QQQ	ETF	115.52	115.52	115.34	115.34	21097.0
2016-08-04 08:30:00	QQQ	ETF	115.32	115.39	115.3	115.32	13510.0
2016-08-04 09:00:00	QQQ	ETF	115.29	115.36	115.28	115.32	67459.0
2016-08-04 09:30:00	QQQ	ETF	115.32	115.585	115.23	115.255	2182408.0
2016-08-04 10:00:00	QQQ	ETF	115.255	115.315	115.03	115.23	1363128.0
2016-08-04 10:30:00	QQQ	ETF	115.24	115.71	115.24	115.69	1293102.0
2016-08-04 11:00:00	QQQ	ETF	115.69	115.71	115.48	115.54	967784.0
2016-08-04 11:30:00	QQQ	ETF	115.54	115.68	115.54	115.68	452778.0
2016-08-04 12:00:00	QQQ	ETF	115.68	115.78	115.63	115.66	691865.0
2016-08-04 12:30:00	QQQ	ETF	115.66	115.6999	115.55	115.5505	454385.0
2016-08-04 13:00:00	QQQ	ETF	115.56	115.57	115.44	115.57	471995.0
2016-08-04 13:30:00	QQQ	ETF	115.57	115.66	115.5369	115.65	356882.0
2016-08-04 14:00:00	QQQ	ETF	115.65	115.72	115.47	115.555	351499.0

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

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