PREVIEW / etf_30min / 2016-07-26

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-07-26.parquet
  size:    392 KB
  rows:    13,368

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-26 04:00:00	SPY	ETF	216.42	216.42	216.28	216.31	17747.0
2016-07-26 04:30:00	SPY	ETF	216.33	216.56	216.3	216.5	31322.0
2016-07-26 05:00:00	SPY	ETF	216.46	216.59	216.43	216.43	8729.0
2016-07-26 05:30:00	SPY	ETF	216.45	216.51	216.37	216.37	17205.0
2016-07-26 06:00:00	SPY	ETF	216.34	216.38	216.34	216.38	5009.0
2016-07-26 06:30:00	SPY	ETF	216.46	216.54	216.46	216.53	2817.0
2016-07-26 07:00:00	SPY	ETF	216.49	216.61	216.49	216.5	63579.0
2016-07-26 07:30:00	SPY	ETF	216.52	216.55	216.4	216.45	170871.0
2016-07-26 08:00:00	SPY	ETF	216.49	216.669	216.44	216.65	256936.0
2016-07-26 08:30:00	SPY	ETF	216.65	216.68	216.53	216.53	179957.0
2016-07-26 09:00:00	SPY	ETF	216.53	216.62	216.5	216.54	307454.0
2016-07-26 09:30:00	SPY	ETF	216.53	217.17	216.53	216.9411	6825264.0
2016-07-26 10:00:00	SPY	ETF	216.95	217.09	216.795	216.945	5412618.0
2016-07-26 10:30:00	SPY	ETF	216.94	216.99	215.88	215.88	8327038.0
2016-07-26 11:00:00	SPY	ETF	215.885	216.185	215.76	216.16	8189338.0
2016-07-26 11:30:00	SPY	ETF	216.16	216.56	216.09	216.47	3945709.0
2016-07-26 12:00:00	SPY	ETF	216.48	216.75	216.405	216.655	3208883.0
2016-07-26 12:30:00	SPY	ETF	216.655	216.68	216.49	216.501	3458508.0
2016-07-26 13:00:00	SPY	ETF	216.5099	216.575	216.08	216.15	3489327.0
2016-07-26 13:30:00	SPY	ETF	216.14	216.28	216.08	216.205	3249189.0
2016-07-26 14:00:00	SPY	ETF	216.205	216.49	216.0	216.36	4254928.0
2016-07-26 14:30:00	SPY	ETF	216.36	216.56	216.34	216.34	3097837.0
2016-07-26 15:00:00	SPY	ETF	216.34	216.6	216.34	216.6	3442630.0
2016-07-26 15:30:00	SPY	ETF	216.6	216.75	216.53	216.73	6925648.0
2016-07-26 16:00:00	SPY	ETF	216.73	216.76	216.54	216.76	3179885.0
2016-07-26 16:30:00	SPY	ETF	216.72	217.01	216.7	217.0	523621.0
2016-07-26 17:00:00	SPY	ETF	217.02	217.09	216.87	217.01	95725.0
2016-07-26 17:30:00	SPY	ETF	217.0	217.05	216.95	216.97	45085.0
2016-07-26 18:00:00	SPY	ETF	216.96	216.96	216.75	216.84	275803.0
2016-07-26 18:30:00	SPY	ETF	216.84	216.9	216.82	216.85	18279.0
2016-07-26 19:00:00	SPY	ETF	216.83	216.89	216.83	216.85	3742.0
2016-07-26 19:30:00	SPY	ETF	216.89	217.03	216.88	217.0	66844.0
2016-07-26 04:00:00	QQQ	ETF	113.53	113.53	113.45	113.47	400.0
2016-07-26 04:30:00	QQQ	ETF	113.53	113.53	113.53	113.53	100.0
2016-07-26 05:00:00	QQQ	ETF	113.57	113.58	113.57	113.58	300.0
2016-07-26 06:30:00	QQQ	ETF	113.56	113.56	113.56	113.56	100.0
2016-07-26 07:00:00	QQQ	ETF	113.56	113.61	113.56	113.59	29303.0
2016-07-26 07:30:00	QQQ	ETF	113.59	113.63	113.57	113.63	27437.0
2016-07-26 08:00:00	QQQ	ETF	113.64	113.71	113.64	113.71	11880.0
2016-07-26 08:30:00	QQQ	ETF	113.72	113.72	113.65	113.65	7665.0
2016-07-26 09:00:00	QQQ	ETF	113.65	113.69	113.635	113.64	109713.0
2016-07-26 09:30:00	QQQ	ETF	113.63	114.129	113.61	114.11	1921301.0
2016-07-26 10:00:00	QQQ	ETF	114.115	114.2	113.97	114.06	1475807.0
2016-07-26 10:30:00	QQQ	ETF	114.055	114.09	113.29	113.29	1708009.0
2016-07-26 11:00:00	QQQ	ETF	113.28	113.5	113.22	113.49	1489237.0
2016-07-26 11:30:00	QQQ	ETF	113.49	113.69	113.45	113.65	737021.0
2016-07-26 12:00:00	QQQ	ETF	113.65	113.83	113.6	113.74	718086.0
2016-07-26 12:30:00	QQQ	ETF	113.74	113.76	113.6689	113.7	544317.0
2016-07-26 13:00:00	QQQ	ETF	113.69	113.73	113.38	113.44	707796.0
2016-07-26 13:30:00	QQQ	ETF	113.43	113.53	113.4	113.5	477346.0

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

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