PREVIEW / etf_30min / 2016-09-21

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-09-21.parquet
  size:    405 KB
  rows:    13,775

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-21 04:00:00	SPY	ETF	214.2	214.35	214.03	214.1	2105.0
2016-09-21 04:30:00	SPY	ETF	214.2	214.24	214.2	214.24	603.0
2016-09-21 05:00:00	SPY	ETF	214.2	214.27	214.09	214.16	9801.0
2016-09-21 05:30:00	SPY	ETF	214.16	214.21	214.13	214.13	16743.0
2016-09-21 06:00:00	SPY	ETF	214.18	214.25	214.17	214.25	7145.0
2016-09-21 06:30:00	SPY	ETF	214.27	214.34	214.22	214.28	23774.0
2016-09-21 07:00:00	SPY	ETF	214.3	214.37	214.26	214.3	144690.0
2016-09-21 07:30:00	SPY	ETF	214.3	214.31	214.1	214.15	89930.0
2016-09-21 08:00:00	SPY	ETF	214.22	214.33	214.02	214.15	292175.0
2016-09-21 08:30:00	SPY	ETF	214.13	214.15	213.93	213.93	196538.0
2016-09-21 09:00:00	SPY	ETF	213.93	214.24	213.9	214.22	337161.0
2016-09-21 09:30:00	SPY	ETF	214.24	214.57	214.22	214.565	7010688.0
2016-09-21 10:00:00	SPY	ETF	214.57	214.705	214.37	214.48	4093743.0
2016-09-21 10:30:00	SPY	ETF	214.48	214.641	214.2	214.21	4575060.0
2016-09-21 11:00:00	SPY	ETF	214.21	214.33	214.03	214.22	3268046.0
2016-09-21 11:30:00	SPY	ETF	214.22	214.25	214.0	214.1399	3694489.0
2016-09-21 12:00:00	SPY	ETF	214.135	214.2	213.5	213.64	6529606.0
2016-09-21 12:30:00	SPY	ETF	213.63	213.9	213.44	213.87	3776072.0
2016-09-21 13:00:00	SPY	ETF	213.87	214.025	213.64	213.7	3757889.0
2016-09-21 13:30:00	SPY	ETF	213.7	214.06	213.65	213.85	4217117.0
2016-09-21 14:00:00	SPY	ETF	213.88	214.91	213.58	213.979	20155719.0
2016-09-21 14:30:00	SPY	ETF	213.97	215.001	213.91	214.93	11163291.0
2016-09-21 15:00:00	SPY	ETF	214.93	215.4998	214.73	215.35	10469466.0
2016-09-21 15:30:00	SPY	ETF	215.35	216.03	215.35	215.79	18638512.0
2016-09-21 16:00:00	SPY	ETF	215.79	215.93	213.4772	215.83	5057752.0
2016-09-21 16:30:00	SPY	ETF	215.82	215.92	215.74	215.88	494224.0
2016-09-21 17:00:00	SPY	ETF	215.88	215.91	215.82	215.85	305370.0
2016-09-21 17:30:00	SPY	ETF	215.87	215.88	215.83	215.88	90955.0
2016-09-21 18:00:00	SPY	ETF	215.83	215.85	215.74	215.78	89390.0
2016-09-21 18:30:00	SPY	ETF	215.76	215.76	215.69	215.69	72263.0
2016-09-21 19:00:00	SPY	ETF	215.69	215.73	215.67	215.68	11436.0
2016-09-21 19:30:00	SPY	ETF	215.67	215.74	215.66	215.74	45999.0
2016-09-21 04:00:00	QQQ	ETF	117.51	117.59	117.43	117.47	1700.0
2016-09-21 04:30:00	QQQ	ETF	117.47	117.48	117.47	117.48	300.0
2016-09-21 05:30:00	QQQ	ETF	117.53	117.53	117.51	117.51	200.0
2016-09-21 06:00:00	QQQ	ETF	117.52	117.54	117.49	117.54	1200.0
2016-09-21 06:30:00	QQQ	ETF	117.55	117.61	117.55	117.58	51499.0
2016-09-21 07:00:00	QQQ	ETF	117.57	117.6	117.55	117.58	18257.0
2016-09-21 07:30:00	QQQ	ETF	117.55	117.58	117.46	117.46	31730.0
2016-09-21 08:00:00	QQQ	ETF	117.55	117.55	117.41	117.48	24650.0
2016-09-21 08:30:00	QQQ	ETF	117.48	117.48	117.4	117.41	11477.0
2016-09-21 09:00:00	QQQ	ETF	117.36	117.49	117.36	117.47	70393.0
2016-09-21 09:30:00	QQQ	ETF	117.49	117.62	117.37	117.61	1501141.0
2016-09-21 10:00:00	QQQ	ETF	117.6193	117.71	117.51	117.57	873210.0
2016-09-21 10:30:00	QQQ	ETF	117.58	117.7	117.398	117.398	1116054.0
2016-09-21 11:00:00	QQQ	ETF	117.41	117.45	117.18	117.27	768464.0
2016-09-21 11:30:00	QQQ	ETF	117.275	117.28	117.025	117.1	2668678.0
2016-09-21 12:00:00	QQQ	ETF	117.09	117.18	116.8199	116.91	1559962.0
2016-09-21 12:30:00	QQQ	ETF	116.9	117.1	116.81	117.09	835684.0
2016-09-21 13:00:00	QQQ	ETF	117.08	117.18	116.99	117.04	654617.0

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

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