PREVIEW / etf_30min / 2016-01-07

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-01-07.parquet
  size:    432 KB
  rows:    14,578

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-01-07 04:00:00	SPY	ETF	194.27	195.45	193.75	194.0	285163.0
2016-01-07 04:30:00	SPY	ETF	194.01	194.6	193.98	194.51	142407.0
2016-01-07 05:00:00	SPY	ETF	194.49	194.87	193.83	193.85	96004.0
2016-01-07 05:30:00	SPY	ETF	193.89	194.6	193.83	194.35	59447.0
2016-01-07 06:00:00	SPY	ETF	194.35	194.97	194.35	194.68	57679.0
2016-01-07 06:30:00	SPY	ETF	194.65	195.08	194.56	194.75	58765.0
2016-01-07 07:00:00	SPY	ETF	194.73	195.04	194.5	194.99	399880.0
2016-01-07 07:30:00	SPY	ETF	194.99	195.22	194.7	194.91	394712.0
2016-01-07 08:00:00	SPY	ETF	194.91	196.95	193.68	194.61	1212962.0
2016-01-07 08:30:00	SPY	ETF	194.6	195.35	194.43	195.27	1006624.0
2016-01-07 09:00:00	SPY	ETF	195.26	195.45	195.03	195.33	2128881.0
2016-01-07 09:30:00	SPY	ETF	195.33	196.58	195.03	196.18	21608966.0
2016-01-07 10:00:00	SPY	ETF	196.18	196.45	195.66	196.27	11203348.0
2016-01-07 10:30:00	SPY	ETF	196.27	197.44	196.27	197.2	13192497.0
2016-01-07 11:00:00	SPY	ETF	197.19	197.37	196.4	196.65	8862418.0
2016-01-07 11:30:00	SPY	ETF	196.64	196.88	196.18	196.21	9443877.0
2016-01-07 12:00:00	SPY	ETF	196.21	196.49	196.03	196.09	6204275.0
2016-01-07 12:30:00	SPY	ETF	196.09	196.28	195.651	195.73	8526206.0
2016-01-07 13:00:00	SPY	ETF	195.72	195.77	194.49	194.81	16281707.0
2016-01-07 13:30:00	SPY	ETF	194.8	194.83	193.93	194.48	15528838.0
2016-01-07 14:00:00	SPY	ETF	194.48	194.64	194.05	194.1	11657315.0
2016-01-07 14:30:00	SPY	ETF	194.1	195.17	193.8	194.345	18840759.0
2016-01-07 15:00:00	SPY	ETF	194.34	194.72	193.61	193.61	20647349.0
2016-01-07 15:30:00	SPY	ETF	193.62	194.99	193.59	194.01	32234730.0
2016-01-07 16:00:00	SPY	ETF	194.02	196.27	193.42	193.72	8946313.0
2016-01-07 16:30:00	SPY	ETF	193.72	195.2238	193.69	193.96	1952915.0
2016-01-07 17:00:00	SPY	ETF	193.99	194.06	193.83	193.93	388717.0
2016-01-07 17:30:00	SPY	ETF	193.93	194.32	193.9	194.09	166032.0
2016-01-07 18:00:00	SPY	ETF	194.1	194.24	193.45	193.87	266381.0
2016-01-07 18:30:00	SPY	ETF	193.9	194.15	193.88	194.13	178067.0
2016-01-07 19:00:00	SPY	ETF	194.04	194.19	193.91	194.19	129012.0
2016-01-07 19:30:00	SPY	ETF	194.19	194.41	193.89	193.93	193879.0
2016-01-07 04:00:00	QQQ	ETF	105.51	106.1	105.03	105.15	23876.0
2016-01-07 04:30:00	QQQ	ETF	105.36	105.52	105.18	105.52	39209.0
2016-01-07 05:00:00	QQQ	ETF	105.63	105.66	104.99	104.99	46891.0
2016-01-07 05:30:00	QQQ	ETF	104.97	105.23	104.95	105.13	32050.0
2016-01-07 06:00:00	QQQ	ETF	105.12	105.49	105.12	105.29	22163.0
2016-01-07 06:30:00	QQQ	ETF	105.3	105.54	105.3	105.35	12300.0
2016-01-07 07:00:00	QQQ	ETF	105.36	105.63	105.21	105.62	203240.0
2016-01-07 07:30:00	QQQ	ETF	105.58	105.65	105.45	105.57	91374.0
2016-01-07 08:00:00	QQQ	ETF	105.55	106.68	105.22	105.4	256016.0
2016-01-07 08:30:00	QQQ	ETF	105.38	105.84	105.3	105.8	285320.0
2016-01-07 09:00:00	QQQ	ETF	105.85	105.99	105.68	105.96	689810.0
2016-01-07 09:30:00	QQQ	ETF	105.96	106.5878	105.72	106.32	7498476.0
2016-01-07 10:00:00	QQQ	ETF	106.31	106.61	105.94	106.52	3616290.0
2016-01-07 10:30:00	QQQ	ETF	106.52	107.27	106.52	107.17	4256465.0
2016-01-07 11:00:00	QQQ	ETF	107.165	107.29	106.645	106.689	2497455.0
2016-01-07 11:30:00	QQQ	ETF	106.68	108.26	106.5	106.54	1487081.0
2016-01-07 12:00:00	QQQ	ETF	106.52	106.72	106.43	106.45	1568022.0
2016-01-07 12:30:00	QQQ	ETF	106.46	106.56	106.15	106.18	1794202.0

> showing 50 of 14,578 rows — these rows as CSV

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