PREVIEW / etf_30min / 2016-10-28

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-10-28.parquet
  size:    402 KB
  rows:    13,694

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-28 04:00:00	SPY	ETF	212.51	212.56	212.2	212.2	99604.0
2016-10-28 04:30:00	SPY	ETF	212.18	212.58	212.06	212.58	11253.0
2016-10-28 05:00:00	SPY	ETF	212.61	212.89	212.59	212.89	10348.0
2016-10-28 05:30:00	SPY	ETF	212.89	212.89	212.79	212.83	5711.0
2016-10-28 06:00:00	SPY	ETF	212.86	212.96	212.82	212.96	25197.0
2016-10-28 06:30:00	SPY	ETF	213.0	213.14	213.0	213.1	24186.0
2016-10-28 07:00:00	SPY	ETF	213.14	213.24	213.13	213.18	60070.0
2016-10-28 07:30:00	SPY	ETF	213.18	213.22	213.07	213.2	139467.0
2016-10-28 08:00:00	SPY	ETF	213.17	213.19	213.03	213.14	251634.0
2016-10-28 08:30:00	SPY	ETF	213.07	213.38	212.78	213.17	795547.0
2016-10-28 09:00:00	SPY	ETF	213.17	213.3	213.05	213.14	479399.0
2016-10-28 09:30:00	SPY	ETF	213.14	213.515	212.61	213.24	9995997.0
2016-10-28 10:00:00	SPY	ETF	213.24	213.37	212.79	213.27	7057405.0
2016-10-28 10:30:00	SPY	ETF	213.28	213.88	213.28	213.7	7949104.0
2016-10-28 11:00:00	SPY	ETF	213.705	213.8144	213.58	213.64	3297918.0
2016-10-28 11:30:00	SPY	ETF	213.65	213.79	213.55	213.57	2094264.0
2016-10-28 12:00:00	SPY	ETF	213.57	213.925	213.51	213.82	4131124.0
2016-10-28 12:30:00	SPY	ETF	213.82	213.93	213.71	213.805	2210945.0
2016-10-28 13:00:00	SPY	ETF	213.8	213.9	212.4	212.71	21212913.0
2016-10-28 13:30:00	SPY	ETF	212.715	212.72	211.81	211.855	21565001.0
2016-10-28 14:00:00	SPY	ETF	211.87	212.69	211.71	212.51	16053044.0
2016-10-28 14:30:00	SPY	ETF	212.53	213.04	212.2807	212.935	9055126.0
2016-10-28 15:00:00	SPY	ETF	212.93	213.17	212.36	213.0001	9950810.0
2016-10-28 15:30:00	SPY	ETF	213.0	213.005	212.32	212.52	14904030.0
2016-10-28 16:00:00	SPY	ETF	212.52	212.92	212.4758	212.78	5504445.0
2016-10-28 16:30:00	SPY	ETF	212.78	212.88	212.475	212.78	2025875.0
2016-10-28 17:00:00	SPY	ETF	212.76	212.94	212.7	212.8	357216.0
2016-10-28 17:30:00	SPY	ETF	212.8	212.88	212.8	212.83	33360.0
2016-10-28 18:00:00	SPY	ETF	212.86	212.89	212.78	212.78	19842.0
2016-10-28 18:30:00	SPY	ETF	212.8	212.99	212.77	212.94	53768.0
2016-10-28 19:00:00	SPY	ETF	212.93	212.94	212.86	212.87	16847.0
2016-10-28 19:30:00	SPY	ETF	212.88	212.94	212.84	212.94	21134.0
2016-10-28 04:00:00	QQQ	ETF	117.11	117.11	117.0	117.02	46444.0
2016-10-28 04:30:00	QQQ	ETF	116.86	116.86	116.86	116.86	100.0
2016-10-28 05:30:00	QQQ	ETF	117.21	117.21	117.21	117.21	200.0
2016-10-28 06:00:00	QQQ	ETF	117.18	117.26	117.18	117.26	9400.0
2016-10-28 06:30:00	QQQ	ETF	117.3	117.36	117.3	117.34	4500.0
2016-10-28 07:00:00	QQQ	ETF	117.38	117.48	117.37	117.44	10214.0
2016-10-28 07:30:00	QQQ	ETF	117.44	117.45	117.41	117.45	7600.0
2016-10-28 08:00:00	QQQ	ETF	117.45	117.51	117.42	117.43	74424.0
2016-10-28 08:30:00	QQQ	ETF	117.5	117.61	117.28	117.5	86862.0
2016-10-28 09:00:00	QQQ	ETF	117.54	117.57	117.42	117.46	144287.0
2016-10-28 09:30:00	QQQ	ETF	117.47	117.85	117.06	117.7	3016835.0
2016-10-28 10:00:00	QQQ	ETF	117.7	117.77	117.38	117.72	2002213.0
2016-10-28 10:30:00	QQQ	ETF	117.72	118.11	117.7101	117.96	1796205.0
2016-10-28 11:00:00	QQQ	ETF	117.97	117.98	117.8065	117.83	747603.0
2016-10-28 11:30:00	QQQ	ETF	117.825	117.93	117.798	117.8	506439.0
2016-10-28 12:00:00	QQQ	ETF	117.81	118.09	117.7	117.99	865952.0
2016-10-28 12:30:00	QQQ	ETF	118.0	118.0	117.88	117.91	459276.0
2016-10-28 13:00:00	QQQ	ETF	117.91	117.96	117.2	117.38	3254050.0

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

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