PREVIEW / etf_30min / 2016-10-19

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-10-19.parquet
  size:    395 KB
  rows:    13,432

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-10-19 04:00:00	SPY	ETF	213.32	213.32	213.22	213.28	168423.0
2016-10-19 04:30:00	SPY	ETF	213.36	213.48	213.32	213.48	41317.0
2016-10-19 05:00:00	SPY	ETF	213.53	213.53	213.38	213.4	7296.0
2016-10-19 05:30:00	SPY	ETF	213.47	213.51	213.45	213.5	1061.0
2016-10-19 06:00:00	SPY	ETF	213.47	213.62	213.47	213.62	1009.0
2016-10-19 06:30:00	SPY	ETF	213.65	213.71	213.6	213.62	6748.0
2016-10-19 07:00:00	SPY	ETF	213.68	213.79	213.65	213.7	53239.0
2016-10-19 07:30:00	SPY	ETF	213.67	213.69	213.53	213.64	369832.0
2016-10-19 08:00:00	SPY	ETF	213.56	213.93	213.508	213.9	335678.0
2016-10-19 08:30:00	SPY	ETF	213.9	214.05	213.8	213.97	495682.0
2016-10-19 09:00:00	SPY	ETF	214.01	214.04	213.88	214.01	536420.0
2016-10-19 09:30:00	SPY	ETF	214.02	214.08	213.65	213.76	7294293.0
2016-10-19 10:00:00	SPY	ETF	213.76	214.15	213.6	214.1	4791740.0
2016-10-19 10:30:00	SPY	ETF	214.1	214.484	214.05	214.42	7649448.0
2016-10-19 11:00:00	SPY	ETF	214.42	214.44	214.16	214.26	3369730.0
2016-10-19 11:30:00	SPY	ETF	214.27	214.38	214.19	214.24	2887779.0
2016-10-19 12:00:00	SPY	ETF	214.23	214.41	214.17	214.37	1659507.0
2016-10-19 12:30:00	SPY	ETF	214.36	214.51	214.33	214.43	2026590.0
2016-10-19 13:00:00	SPY	ETF	214.43	214.56	214.41	214.52	2457901.0
2016-10-19 13:30:00	SPY	ETF	214.52	214.61	214.47	214.52	2226752.0
2016-10-19 14:00:00	SPY	ETF	214.515	214.64	214.44	214.4701	2309005.0
2016-10-19 14:30:00	SPY	ETF	214.47	214.5	214.3	214.43	2620373.0
2016-10-19 15:00:00	SPY	ETF	214.42	214.59	214.42	214.47	3903477.0
2016-10-19 15:30:00	SPY	ETF	214.465	214.49	214.19	214.25	9070574.0
2016-10-19 16:00:00	SPY	ETF	214.26	214.33	214.16	214.26	5484678.0
2016-10-19 16:30:00	SPY	ETF	214.25	214.3	214.18	214.19	1235683.0
2016-10-19 17:00:00	SPY	ETF	214.2	214.22	214.13	214.16	32588.0
2016-10-19 17:30:00	SPY	ETF	214.15	214.18	214.15	214.15	13444.0
2016-10-19 18:00:00	SPY	ETF	214.15	214.21	214.06	214.16	70135.0
2016-10-19 18:30:00	SPY	ETF	214.15	214.21	214.14	214.2	19956.0
2016-10-19 19:00:00	SPY	ETF	214.19	214.35	214.19	214.27	53296.0
2016-10-19 19:30:00	SPY	ETF	214.23	214.31	214.2128	214.3	421878.0
2016-10-19 04:00:00	QQQ	ETF	117.45	117.45	117.41	117.41	3599.0
2016-10-19 04:30:00	QQQ	ETF	117.45	117.51	117.45	117.49	22598.0
2016-10-19 05:00:00	QQQ	ETF	117.48	117.48	117.48	117.48	500.0
2016-10-19 05:30:00	QQQ	ETF	117.5	117.5	117.5	117.5	500.0
2016-10-19 06:00:00	QQQ	ETF	117.48	117.59	117.48	117.59	11298.0
2016-10-19 06:30:00	QQQ	ETF	117.59	117.59	117.59	117.59	3500.0
2016-10-19 07:00:00	QQQ	ETF	117.58	117.66	117.58	117.64	35499.0
2016-10-19 07:30:00	QQQ	ETF	117.62	117.62	117.55	117.61	47997.0
2016-10-19 08:00:00	QQQ	ETF	117.6	117.74	117.58	117.74	25829.0
2016-10-19 08:30:00	QQQ	ETF	117.73	117.84	117.68	117.78	83842.0
2016-10-19 09:00:00	QQQ	ETF	117.79	117.79	117.7	117.78	109778.0
2016-10-19 09:30:00	QQQ	ETF	117.77	117.89	117.64	117.75	2423060.0
2016-10-19 10:00:00	QQQ	ETF	117.76	117.945	117.69	117.91	1435920.0
2016-10-19 10:30:00	QQQ	ETF	117.92	118.02	117.82	117.96	1768213.0
2016-10-19 11:00:00	QQQ	ETF	117.9656	117.9656	117.735	117.78	950291.0
2016-10-19 11:30:00	QQQ	ETF	117.79	117.86	117.71	117.71	683410.0
2016-10-19 12:00:00	QQQ	ETF	117.7	117.84	117.65	117.805	779381.0
2016-10-19 12:30:00	QQQ	ETF	117.79	117.88	117.77	117.86	302777.0

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

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