PREVIEW / etf_30min / 2017-09-25

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-09-25.parquet
  size:    442 KB
  rows:    15,184

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-09-25 04:00:00	SPY	ETF	249.36	249.36	249.11	249.11	11275.0
2017-09-25 04:30:00	SPY	ETF	249.15	249.34	249.07	249.34	7434.0
2017-09-25 05:00:00	SPY	ETF	249.34	249.34	249.26	249.26	3606.0
2017-09-25 05:30:00	SPY	ETF	249.19	249.25	249.11	249.25	9609.0
2017-09-25 06:00:00	SPY	ETF	249.28	249.33	249.28	249.33	2001.0
2017-09-25 06:30:00	SPY	ETF	249.33	249.37	249.33	249.37	17122.0
2017-09-25 07:00:00	SPY	ETF	249.39	249.42	249.34	249.39	10107.0
2017-09-25 07:30:00	SPY	ETF	249.38	249.45	249.36	249.4	30746.0
2017-09-25 08:00:00	SPY	ETF	249.45	249.45	249.34	249.37	45410.0
2017-09-25 08:30:00	SPY	ETF	249.37	249.38	249.14	249.17	107594.0
2017-09-25 09:00:00	SPY	ETF	249.17	249.18	249.05	249.14	205735.0
2017-09-25 09:30:00	SPY	ETF	249.15	249.34	249.07	249.23	3757590.0
2017-09-25 10:00:00	SPY	ETF	249.2201	249.5532	249.14	249.435	3504942.0
2017-09-25 10:30:00	SPY	ETF	249.42	249.45	248.57	248.605	6617462.0
2017-09-25 11:00:00	SPY	ETF	248.6	248.82	248.08	248.79	6998248.0
2017-09-25 11:30:00	SPY	ETF	248.8	248.82	248.44	248.53	2099856.0
2017-09-25 12:00:00	SPY	ETF	248.54	248.55	248.16	248.51	3255084.0
2017-09-25 12:30:00	SPY	ETF	248.51	248.795	248.43	248.695	2295790.0
2017-09-25 13:00:00	SPY	ETF	248.69	248.78	248.63	248.65	1913064.0
2017-09-25 13:30:00	SPY	ETF	248.65	248.88	248.56	248.72	1774216.0
2017-09-25 14:00:00	SPY	ETF	248.73	248.85	248.52	248.58	1831998.0
2017-09-25 14:30:00	SPY	ETF	248.58	248.695	248.38	248.65	3947565.0
2017-09-25 15:00:00	SPY	ETF	248.66	248.9	248.53	248.82	3930112.0
2017-09-25 15:30:00	SPY	ETF	248.81	249.01	248.69	248.94	6801074.0
2017-09-25 16:00:00	SPY	ETF	248.94	249.28	248.93	249.26	5457386.0
2017-09-25 16:30:00	SPY	ETF	249.27	249.36	248.93	249.33	513225.0
2017-09-25 17:00:00	SPY	ETF	249.33	249.35	248.7074	249.3	100858.0
2017-09-25 17:30:00	SPY	ETF	249.32	249.34	249.29	249.33	24595.0
2017-09-25 18:00:00	SPY	ETF	249.34	249.37	249.28	249.31	51507.0
2017-09-25 18:30:00	SPY	ETF	249.31	249.32	249.28	249.3	13929.0
2017-09-25 19:00:00	SPY	ETF	249.3	249.32	249.15	249.2	41196.0
2017-09-25 19:30:00	SPY	ETF	249.18	249.26	249.18	249.23	37922.0
2017-09-25 04:00:00	QQQ	ETF	144.06	144.07	144.06	144.07	300.0
2017-09-25 04:30:00	QQQ	ETF	144.09	144.2	144.09	144.2	10997.0
2017-09-25 05:00:00	QQQ	ETF	144.2	144.2	144.13	144.13	3007.0
2017-09-25 05:30:00	QQQ	ETF	144.1	144.14	144.07	144.14	7007.0
2017-09-25 06:00:00	QQQ	ETF	144.12	144.2	144.12	144.2	2322.0
2017-09-25 06:30:00	QQQ	ETF	144.19	144.26	144.19	144.26	3400.0
2017-09-25 07:00:00	QQQ	ETF	144.25	144.29	144.2	144.22	16512.0
2017-09-25 07:30:00	QQQ	ETF	144.22	144.22	144.13	144.13	31153.0
2017-09-25 08:00:00	QQQ	ETF	144.23	144.25	144.01	144.01	46013.0
2017-09-25 08:30:00	QQQ	ETF	144.01	144.02	143.73	143.75	137959.0
2017-09-25 09:00:00	QQQ	ETF	143.72	143.76	143.59	143.75	183708.0
2017-09-25 09:30:00	QQQ	ETF	143.75	143.75	143.16	143.35	3782662.0
2017-09-25 10:00:00	QQQ	ETF	143.36	143.8299	143.19	143.42	2979249.0
2017-09-25 10:30:00	QQQ	ETF	143.41	143.42	142.53	142.61	5258348.0
2017-09-25 11:00:00	QQQ	ETF	142.6	142.91	142.34	142.87	3877887.0
2017-09-25 11:30:00	QQQ	ETF	142.88	142.89	142.45	142.58	2036434.0
2017-09-25 12:00:00	QQQ	ETF	142.59	142.62	142.17	142.41	2882174.0
2017-09-25 12:30:00	QQQ	ETF	142.42	142.78	142.39	142.67	4176160.0

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

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