PREVIEW / etf_30min / 2015-09-29

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-09-29.parquet
  size:    385 KB
  rows:    13,143

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
2015-09-29 04:00:00	SPY	ETF	188.35	188.7	188.24	188.55	6170.0
2015-09-29 04:30:00	SPY	ETF	188.5	189.35	188.5	189.06	89231.0
2015-09-29 05:00:00	SPY	ETF	189.08	189.11	188.61	188.7	13106.0
2015-09-29 05:30:00	SPY	ETF	188.66	188.89	188.4	188.49	31230.0
2015-09-29 06:00:00	SPY	ETF	188.67	188.9	188.64	188.81	25075.0
2015-09-29 06:30:00	SPY	ETF	188.81	189.03	188.53	189.02	26742.0
2015-09-29 07:00:00	SPY	ETF	188.98	189.06	188.77	188.9	129193.0
2015-09-29 07:30:00	SPY	ETF	188.89	188.9	188.59	188.85	296447.0
2015-09-29 08:00:00	SPY	ETF	188.81	189.32	187.73	189.22	497945.0
2015-09-29 08:30:00	SPY	ETF	189.23	189.26	189.01	189.1	420025.0
2015-09-29 09:00:00	SPY	ETF	189.1	189.13	188.26	188.28	1430375.0
2015-09-29 09:30:00	SPY	ETF	188.27	188.73	187.37	188.63	19673043.0
2015-09-29 10:00:00	SPY	ETF	188.67	189.63	188.32	189.62	15789301.0
2015-09-29 10:30:00	SPY	ETF	189.63	189.74	188.49	188.99	11164809.0
2015-09-29 11:00:00	SPY	ETF	188.99	189.3	188.21	188.6401	7187154.0
2015-09-29 11:30:00	SPY	ETF	188.65	188.95	188.12	188.44	5725594.0
2015-09-29 12:00:00	SPY	ETF	188.43	188.545	187.82	188.37	7486106.0
2015-09-29 12:30:00	SPY	ETF	188.37	188.48	187.65	187.7	6278163.0
2015-09-29 13:00:00	SPY	ETF	187.71	188.63	187.66	188.47	6961962.0
2015-09-29 13:30:00	SPY	ETF	188.475	188.92	188.4	188.68	6552597.0
2015-09-29 14:00:00	SPY	ETF	188.68	188.72	188.02	188.57	6530728.0
2015-09-29 14:30:00	SPY	ETF	188.56	188.69	187.61	187.62	10634581.0
2015-09-29 15:00:00	SPY	ETF	187.62	187.74	186.93	187.01	13828596.0
2015-09-29 15:30:00	SPY	ETF	187.0	188.46	186.99	188.05	25813511.0
2015-09-29 16:00:00	SPY	ETF	188.06	188.58	188.02	188.27	5052385.0
2015-09-29 16:30:00	SPY	ETF	188.26	188.26	187.94	188.21	5225657.0
2015-09-29 17:00:00	SPY	ETF	188.22	188.24	188.12	188.12	236172.0
2015-09-29 17:30:00	SPY	ETF	188.15	188.35	188.15	188.34	410572.0
2015-09-29 18:00:00	SPY	ETF	188.29	188.55	188.22	188.41	142200.0
2015-09-29 18:30:00	SPY	ETF	188.39	188.48	188.35	188.41	77100.0
2015-09-29 19:00:00	SPY	ETF	188.36	188.53	188.35	188.35	7112.0
2015-09-29 19:30:00	SPY	ETF	188.38	188.38	188.26	188.3	21743.0
2015-09-29 04:00:00	QQQ	ETF	100.3	100.35	100.3	100.35	1080.0
2015-09-29 04:30:00	QQQ	ETF	100.48	100.8	100.48	100.75	17400.0
2015-09-29 05:00:00	QQQ	ETF	100.68	100.68	100.52	100.52	1050.0
2015-09-29 05:30:00	QQQ	ETF	100.63	100.63	100.49	100.49	200.0
2015-09-29 06:00:00	QQQ	ETF	100.56	100.61	100.56	100.61	500.0
2015-09-29 06:30:00	QQQ	ETF	100.52	100.6	100.38	100.6	9121.0
2015-09-29 07:00:00	QQQ	ETF	100.64	100.64	100.53	100.58	25189.0
2015-09-29 07:30:00	QQQ	ETF	100.47	100.52	100.44	100.5	6630.0
2015-09-29 08:00:00	QQQ	ETF	100.5	100.77	99.79	100.76	208999.0
2015-09-29 08:30:00	QQQ	ETF	100.73	100.78	100.59	100.65	88023.0
2015-09-29 09:00:00	QQQ	ETF	100.65	100.66	100.24	100.25	175486.0
2015-09-29 09:30:00	QQQ	ETF	100.24	100.53	99.52	100.48	6776867.0
2015-09-29 10:00:00	QQQ	ETF	100.49	101.1701	100.29	101.169	5976426.0
2015-09-29 10:30:00	QQQ	ETF	101.17	101.26	100.431	100.75	3354914.0
2015-09-29 11:00:00	QQQ	ETF	100.75	100.95	100.23	100.59	2670304.0
2015-09-29 11:30:00	QQQ	ETF	100.6	100.78	100.24	100.38	2078334.0
2015-09-29 12:00:00	QQQ	ETF	100.38	100.46	99.92	100.2	2263708.0
2015-09-29 12:30:00	QQQ	ETF	100.22	100.26	99.67	99.68	1861984.0

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

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