PREVIEW / etf_30min / 2017-08-09

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-08-09.parquet
  size:    439 KB
  rows:    15,170

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-08-09 04:00:00	SPY	ETF	246.63	246.63	246.38	246.53	19200.0
2017-08-09 04:30:00	SPY	ETF	246.49	246.64	246.25	246.64	10617.0
2017-08-09 05:00:00	SPY	ETF	246.63	246.65	246.48	246.48	4100.0
2017-08-09 05:30:00	SPY	ETF	246.43	246.46	246.07	246.18	101750.0
2017-08-09 06:00:00	SPY	ETF	246.15	246.48	246.15	246.45	17192.0
2017-08-09 06:30:00	SPY	ETF	246.4	246.62	246.4	246.58	113677.0
2017-08-09 07:00:00	SPY	ETF	246.57	246.67	246.32	246.49	102625.0
2017-08-09 07:30:00	SPY	ETF	246.45	246.51	246.24	246.32	178364.0
2017-08-09 08:00:00	SPY	ETF	246.32	246.62	246.11	246.25	317648.0
2017-08-09 08:30:00	SPY	ETF	246.25	246.63	246.23	246.58	613883.0
2017-08-09 09:00:00	SPY	ETF	246.57	246.61	246.45	246.47	472801.0
2017-08-09 09:30:00	SPY	ETF	246.47	246.88	246.06	246.76	12297620.0
2017-08-09 10:00:00	SPY	ETF	246.76	246.78	246.315	246.6	4747921.0
2017-08-09 10:30:00	SPY	ETF	246.59	247.015	246.5601	246.89	4259046.0
2017-08-09 11:00:00	SPY	ETF	246.88	246.88	246.4499	246.57	3547122.0
2017-08-09 11:30:00	SPY	ETF	246.58	247.12	246.58	247.095	3596203.0
2017-08-09 12:00:00	SPY	ETF	247.1	247.16	246.95	247.01	1788805.0
2017-08-09 12:30:00	SPY	ETF	247.005	247.07	246.8	246.8105	1526844.0
2017-08-09 13:00:00	SPY	ETF	246.8105	247.0	246.75	246.83	1724863.0
2017-08-09 13:30:00	SPY	ETF	246.825	246.98	246.72	246.795	1305071.0
2017-08-09 14:00:00	SPY	ETF	246.79	246.8375	246.52	246.6167	2253878.0
2017-08-09 14:30:00	SPY	ETF	246.61	246.67	246.36	246.64	2898871.0
2017-08-09 15:00:00	SPY	ETF	246.64	246.88	246.49	246.81	4784186.0
2017-08-09 15:30:00	SPY	ETF	246.82	247.31	246.71	247.23	9736362.0
2017-08-09 16:00:00	SPY	ETF	247.22	247.48	246.7283	247.41	4351677.0
2017-08-09 16:30:00	SPY	ETF	247.42	247.52	247.37	247.49	347981.0
2017-08-09 17:00:00	SPY	ETF	247.49	247.5	247.44	247.46	41483.0
2017-08-09 17:30:00	SPY	ETF	247.47	247.49	247.44	247.48	39980.0
2017-08-09 18:00:00	SPY	ETF	247.48	247.48	247.29	247.35	183199.0
2017-08-09 18:30:00	SPY	ETF	247.36	247.37	247.32	247.32	16379.0
2017-08-09 19:00:00	SPY	ETF	247.33	247.35	247.24	247.26	59968.0
2017-08-09 19:30:00	SPY	ETF	247.29	247.34	247.29	247.32	39432.0
2017-08-09 04:00:00	QQQ	ETF	143.75	143.75	143.43	143.48	4726.0
2017-08-09 04:30:00	QQQ	ETF	143.37	143.52	143.25	143.52	6128.0
2017-08-09 05:00:00	QQQ	ETF	143.46	143.46	143.4	143.44	7254.0
2017-08-09 05:30:00	QQQ	ETF	143.4	143.4	143.14	143.2	36664.0
2017-08-09 06:00:00	QQQ	ETF	143.28	143.39	143.28	143.34	13100.0
2017-08-09 06:30:00	QQQ	ETF	143.35	143.49	143.33	143.42	17093.0
2017-08-09 07:00:00	QQQ	ETF	143.48	143.5	143.34	143.4	35607.0
2017-08-09 07:30:00	QQQ	ETF	143.42	143.42	143.2	143.24	93808.0
2017-08-09 08:00:00	QQQ	ETF	143.25	143.486	143.0	143.1	277776.0
2017-08-09 08:30:00	QQQ	ETF	143.11	143.37	143.05	143.26	161352.0
2017-08-09 09:00:00	QQQ	ETF	143.26	143.29	143.14	143.14	136646.0
2017-08-09 09:30:00	QQQ	ETF	143.14	143.55	142.795	143.45	9149298.0
2017-08-09 10:00:00	QQQ	ETF	143.46	143.58	143.17	143.41	3123096.0
2017-08-09 10:30:00	QQQ	ETF	143.4	143.8	143.4	143.66	2855692.0
2017-08-09 11:00:00	QQQ	ETF	143.66	143.75	143.44	143.54	1369991.0
2017-08-09 11:30:00	QQQ	ETF	143.55	144.0566	143.55	144.05	2000362.0
2017-08-09 12:00:00	QQQ	ETF	144.06	144.14	143.9	144.05	1247808.0
2017-08-09 12:30:00	QQQ	ETF	144.05	144.1	143.78	143.79	1070558.0

> showing 50 of 15,170 rows — these rows as CSV

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