PREVIEW / etf_30min / 2017-01-20

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-01-20.parquet
  size:    426 KB
  rows:    14,380

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
2017-01-20 04:00:00	SPY	ETF	226.5	226.61	226.5	226.61	10879.0
2017-01-20 04:30:00	SPY	ETF	226.59	226.62	226.53	226.59	7419.0
2017-01-20 05:00:00	SPY	ETF	226.56	226.69	226.56	226.62	12728.0
2017-01-20 05:30:00	SPY	ETF	226.59	226.61	226.59	226.59	5401.0
2017-01-20 06:00:00	SPY	ETF	226.57	226.78	226.57	226.73	99156.0
2017-01-20 06:30:00	SPY	ETF	226.74	226.82	226.47	226.47	104810.0
2017-01-20 07:00:00	SPY	ETF	226.47	226.61	226.46	226.57	100003.0
2017-01-20 07:30:00	SPY	ETF	226.6	226.66	226.59	226.62	33009.0
2017-01-20 08:00:00	SPY	ETF	226.62	226.69	226.46	226.675	114566.0
2017-01-20 08:30:00	SPY	ETF	226.68	226.8	226.65	226.68	372113.0
2017-01-20 09:00:00	SPY	ETF	226.7	226.77	226.35	226.69	1910450.0
2017-01-20 09:30:00	SPY	ETF	226.7	227.31	226.67	227.105	11117589.0
2017-01-20 10:00:00	SPY	ETF	227.105	227.17	226.82	226.905	11001889.0
2017-01-20 10:30:00	SPY	ETF	226.91	227.02	226.84	226.985	7066076.0
2017-01-20 11:00:00	SPY	ETF	226.985	227.11	226.82	226.82	13663304.0
2017-01-20 11:30:00	SPY	ETF	226.82	227.05	226.82	226.97	2925332.0
2017-01-20 12:00:00	SPY	ETF	226.97	227.15	226.29	226.455	11029709.0
2017-01-20 12:30:00	SPY	ETF	226.47	226.51	226.05	226.3301	8226146.0
2017-01-20 13:00:00	SPY	ETF	226.34	226.66	226.24	226.625	3524716.0
2017-01-20 13:30:00	SPY	ETF	226.62	226.645	226.34	226.415	3247289.0
2017-01-20 14:00:00	SPY	ETF	226.42	226.5	226.11	226.2473	4593534.0
2017-01-20 14:30:00	SPY	ETF	226.24	226.4	226.13	226.335	3364499.0
2017-01-20 15:00:00	SPY	ETF	226.34	226.7	226.21	226.22	5991394.0
2017-01-20 15:30:00	SPY	ETF	226.23	226.74	226.14	226.7	15885867.0
2017-01-20 16:00:00	SPY	ETF	226.69	226.77	226.54	226.72	13584572.0
2017-01-20 16:30:00	SPY	ETF	226.71	226.74	226.64	226.71	1173577.0
2017-01-20 17:00:00	SPY	ETF	226.7	226.95	226.7	226.87	4200628.0
2017-01-20 17:30:00	SPY	ETF	226.86	227.5	226.64	226.87	2350074.0
2017-01-20 18:00:00	SPY	ETF	226.87	226.98	226.85	226.9	28890.0
2017-01-20 18:30:00	SPY	ETF	226.86	226.88	226.81	226.87	7632.0
2017-01-20 19:00:00	SPY	ETF	226.87	226.9	226.78	226.78	41375.0
2017-01-20 19:30:00	SPY	ETF	226.78	226.85	226.74	226.81	21715.0
2017-01-20 04:00:00	QQQ	ETF	123.37	123.37	123.37	123.37	250.0
2017-01-20 06:00:00	QQQ	ETF	123.44	123.44	123.44	123.44	500.0
2017-01-20 06:30:00	QQQ	ETF	123.46	123.46	123.4	123.4	55949.0
2017-01-20 07:00:00	QQQ	ETF	123.38	123.43	123.36	123.43	24853.0
2017-01-20 07:30:00	QQQ	ETF	123.41	123.46	123.41	123.46	22323.0
2017-01-20 08:00:00	QQQ	ETF	123.37	123.46	123.37	123.43	50538.0
2017-01-20 08:30:00	QQQ	ETF	123.44	123.49	123.41	123.41	28987.0
2017-01-20 09:00:00	QQQ	ETF	123.43	123.56	123.36	123.5	549970.0
2017-01-20 09:30:00	QQQ	ETF	123.51	123.83	123.44	123.709	2878696.0
2017-01-20 10:00:00	QQQ	ETF	123.71	123.73	123.34	123.39	1658822.0
2017-01-20 10:30:00	QQQ	ETF	123.4	123.49	123.28	123.33	927448.0
2017-01-20 11:00:00	QQQ	ETF	123.34	123.42	123.28	123.283	949870.0
2017-01-20 11:30:00	QQQ	ETF	123.29	123.47	123.2808	123.45	762834.0
2017-01-20 12:00:00	QQQ	ETF	123.44	123.52	123.0	123.18	2644665.0
2017-01-20 12:30:00	QQQ	ETF	123.18	123.2083	122.92	123.1	1320951.0
2017-01-20 13:00:00	QQQ	ETF	123.1	123.27	123.071	123.23	437692.0
2017-01-20 13:30:00	QQQ	ETF	123.2373	123.2657	123.1011	123.1199	298054.0
2017-01-20 14:00:00	QQQ	ETF	123.12	123.19	122.95	123.03	1005945.0

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

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