PREVIEW / etf_30min / 2016-09-15

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-09-15.parquet
  size:    397 KB
  rows:    13,381

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-09-15 04:00:00	SPY	ETF	212.75	213.02	212.75	212.88	8794.0
2016-09-15 04:30:00	SPY	ETF	212.84	213.04	212.73	213.04	7835.0
2016-09-15 05:00:00	SPY	ETF	213.01	213.11	212.94	213.08	8487.0
2016-09-15 05:30:00	SPY	ETF	213.13	213.39	213.13	213.31	10098.0
2016-09-15 06:00:00	SPY	ETF	213.31	213.32	213.16	213.32	9462.0
2016-09-15 06:30:00	SPY	ETF	213.26	213.62	213.26	213.53	89298.0
2016-09-15 07:00:00	SPY	ETF	213.52	213.53	213.04	213.14	83434.0
2016-09-15 07:30:00	SPY	ETF	213.14	213.39	213.07	213.39	226588.0
2016-09-15 08:00:00	SPY	ETF	213.36	213.59	212.38	213.56	310305.0
2016-09-15 08:30:00	SPY	ETF	213.55	213.75	212.9	212.93	1213715.0
2016-09-15 09:00:00	SPY	ETF	212.94	213.03	212.63	212.97	1459931.0
2016-09-15 09:30:00	SPY	ETF	212.96	213.6	212.75	213.39	15600843.0
2016-09-15 10:00:00	SPY	ETF	213.39	214.1	213.13	213.9	10906117.0
2016-09-15 10:30:00	SPY	ETF	213.91	214.45	213.7	214.4392	7250004.0
2016-09-15 11:00:00	SPY	ETF	214.43	214.94	214.4	214.88	12008391.0
2016-09-15 11:30:00	SPY	ETF	214.88	215.08	214.68	214.72	11267849.0
2016-09-15 12:00:00	SPY	ETF	214.71	214.96	214.66	214.72	4333734.0
2016-09-15 12:30:00	SPY	ETF	214.72	214.795	214.33	214.5	5044100.0
2016-09-15 13:00:00	SPY	ETF	214.5	214.841	214.44	214.7	4497356.0
2016-09-15 13:30:00	SPY	ETF	214.71	215.35	214.7	215.35	6482823.0
2016-09-15 14:00:00	SPY	ETF	215.35	215.73	215.28	215.6	8051645.0
2016-09-15 14:30:00	SPY	ETF	215.61	215.67	215.42	215.52	10069154.0
2016-09-15 15:00:00	SPY	ETF	215.53	215.7	215.16	215.33	10160376.0
2016-09-15 15:30:00	SPY	ETF	215.325	215.59	215.2	215.29	16286431.0
2016-09-15 16:00:00	SPY	ETF	215.29	215.299	214.7842	215.06	15208952.0
2016-09-15 16:30:00	SPY	ETF	215.06	215.55	214.96	215.0	575261.0
2016-09-15 17:00:00	SPY	ETF	214.97	215.3001	214.94	215.0	834276.0
2016-09-15 17:30:00	SPY	ETF	215.0	215.28	214.99	215.01	440153.0
2016-09-15 18:00:00	SPY	ETF	215.01	215.05	213.1207	214.64	774068.0
2016-09-15 18:30:00	SPY	ETF	214.72	214.8	214.64	214.75	41439.0
2016-09-15 19:00:00	SPY	ETF	214.74	214.87	214.74	214.84	11039.0
2016-09-15 19:30:00	SPY	ETF	214.86	214.86	214.67	214.67	51479.0
2016-09-15 04:00:00	QQQ	ETF	115.68	115.68	115.68	115.68	2500.0
2016-09-15 05:00:00	QQQ	ETF	115.82	115.82	115.82	115.82	100.0
2016-09-15 05:30:00	QQQ	ETF	115.8	115.81	115.8	115.81	1600.0
2016-09-15 06:00:00	QQQ	ETF	115.91	115.91	115.91	115.91	100.0
2016-09-15 06:30:00	QQQ	ETF	115.89	115.96	115.88	115.96	30189.0
2016-09-15 07:00:00	QQQ	ETF	115.96	115.96	115.82	115.82	13797.0
2016-09-15 07:30:00	QQQ	ETF	115.84	115.95	115.78	115.95	56170.0
2016-09-15 08:00:00	QQQ	ETF	115.95	116.08	115.82	116.07	108213.0
2016-09-15 08:30:00	QQQ	ETF	116.0	116.17	115.78	115.89	222508.0
2016-09-15 09:00:00	QQQ	ETF	115.86	115.94	115.72	115.91	223833.0
2016-09-15 09:30:00	QQQ	ETF	115.89	116.37	115.86	116.29	3500329.0
2016-09-15 10:00:00	QQQ	ETF	116.29	116.81	116.13	116.76	2425131.0
2016-09-15 10:30:00	QQQ	ETF	116.78	117.1139	116.67	117.1	1953547.0
2016-09-15 11:00:00	QQQ	ETF	117.1	117.26	117.06	117.23	1846326.0
2016-09-15 11:30:00	QQQ	ETF	117.22	117.3665	117.13	117.18	1571216.0
2016-09-15 12:00:00	QQQ	ETF	117.1723	117.41	117.16	117.2807	1233019.0
2016-09-15 12:30:00	QQQ	ETF	117.28	117.3399	117.09	117.15	1508445.0
2016-09-15 13:00:00	QQQ	ETF	117.16	117.33	117.1	117.23	1551878.0

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

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