PREVIEW / etf_30min / 2016-07-18

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-07-18.parquet
  size:    395 KB
  rows:    13,447

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-07-18 04:00:00	SPY	ETF	216.2	216.39	216.02	216.16	43640.0
2016-07-18 04:30:00	SPY	ETF	216.24	216.47	216.21	216.47	17008.0
2016-07-18 05:00:00	SPY	ETF	216.43	216.47	216.19	216.23	79728.0
2016-07-18 05:30:00	SPY	ETF	216.22	216.22	215.96	215.96	22216.0
2016-07-18 06:00:00	SPY	ETF	216.06	216.2	216.05	216.05	13687.0
2016-07-18 06:30:00	SPY	ETF	215.95	216.13	215.87	216.12	22024.0
2016-07-18 07:00:00	SPY	ETF	216.06	216.14	216.02	216.07	155189.0
2016-07-18 07:30:00	SPY	ETF	216.05	216.37	216.04	216.37	155096.0
2016-07-18 08:00:00	SPY	ETF	216.37	216.38	216.03	216.2	542090.0
2016-07-18 08:30:00	SPY	ETF	216.2	216.22	215.92	215.95	896669.0
2016-07-18 09:00:00	SPY	ETF	215.95	216.1	215.88	215.97	784725.0
2016-07-18 09:30:00	SPY	ETF	215.97	216.09	215.67	215.97	6033134.0
2016-07-18 10:00:00	SPY	ETF	215.97	216.35	215.94	216.31	3830924.0
2016-07-18 10:30:00	SPY	ETF	216.305	216.525	216.3	216.4699	3979802.0
2016-07-18 11:00:00	SPY	ETF	216.47	216.55	216.35	216.37	7234408.0
2016-07-18 11:30:00	SPY	ETF	216.37	216.54	216.28	216.43	2140096.0
2016-07-18 12:00:00	SPY	ETF	216.43	216.46	216.24	216.3	2166996.0
2016-07-18 12:30:00	SPY	ETF	216.31	216.32	216.15	216.295	2657031.0
2016-07-18 13:00:00	SPY	ETF	216.295	216.37	216.12	216.29	3664506.0
2016-07-18 13:30:00	SPY	ETF	216.295	216.495	216.27	216.435	1780132.0
2016-07-18 14:00:00	SPY	ETF	216.44	216.49	216.3	216.465	1869109.0
2016-07-18 14:30:00	SPY	ETF	216.465	216.56	216.3944	216.555	2278018.0
2016-07-18 15:00:00	SPY	ETF	216.555	216.6	216.4	216.48	2700618.0
2016-07-18 15:30:00	SPY	ETF	216.48	216.59	216.4	216.4	6531181.0
2016-07-18 16:00:00	SPY	ETF	216.4	216.45	216.21	216.34	3916338.0
2016-07-18 16:30:00	SPY	ETF	216.35	216.45	216.3	216.38	2222434.0
2016-07-18 17:00:00	SPY	ETF	216.35	216.45	216.35	216.43	783475.0
2016-07-18 17:30:00	SPY	ETF	216.4	216.57	216.34	216.36	188264.0
2016-07-18 18:00:00	SPY	ETF	216.4	216.45	216.33	216.44	120849.0
2016-07-18 18:30:00	SPY	ETF	216.45	216.46	216.41	216.42	26727.0
2016-07-18 19:00:00	SPY	ETF	216.43	216.44	216.36	216.38	31091.0
2016-07-18 19:30:00	SPY	ETF	216.37	216.44	216.37	216.41	33446.0
2016-07-18 04:00:00	QQQ	ETF	111.7	112.0	111.7	111.85	7604.0
2016-07-18 04:30:00	QQQ	ETF	111.94	111.97	111.94	111.97	5362.0
2016-07-18 05:00:00	QQQ	ETF	112.04	112.04	111.9	111.9	1134.0
2016-07-18 05:30:00	QQQ	ETF	111.94	111.94	111.8	111.84	7109.0
2016-07-18 06:00:00	QQQ	ETF	111.84	111.87	111.84	111.87	1280.0
2016-07-18 06:30:00	QQQ	ETF	111.78	111.86	111.76	111.86	2248.0
2016-07-18 07:00:00	QQQ	ETF	111.82	111.88	111.82	111.82	24666.0
2016-07-18 07:30:00	QQQ	ETF	111.85	112.01	111.84	112.0	21229.0
2016-07-18 08:00:00	QQQ	ETF	111.99	112.01	111.85	111.98	35839.0
2016-07-18 08:30:00	QQQ	ETF	111.98	111.99	111.86	111.86	32310.0
2016-07-18 09:00:00	QQQ	ETF	111.87	111.95	111.85	111.87	139391.0
2016-07-18 09:30:00	QQQ	ETF	111.87	112.055	111.85	112.05	2031374.0
2016-07-18 10:00:00	QQQ	ETF	112.04	112.44	112.04	112.41	1510811.0
2016-07-18 10:30:00	QQQ	ETF	112.41	112.58	112.41	112.52	1046403.0
2016-07-18 11:00:00	QQQ	ETF	112.53	112.7225	112.525	112.63	1718055.0
2016-07-18 11:30:00	QQQ	ETF	112.63	112.74	112.57	112.65	805398.0
2016-07-18 12:00:00	QQQ	ETF	112.65	112.66	112.54	112.55	483805.0
2016-07-18 12:30:00	QQQ	ETF	112.555	112.56	112.45	112.53	698703.0

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

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