PREVIEW / etf_30min / 2017-12-19

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-12-19.parquet
  size:    458 KB
  rows:    16,016

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-12-19 04:00:00	SPY	ETF	268.51	268.55	268.41	268.54	16230.0
2017-12-19 04:30:00	SPY	ETF	268.57	268.57	268.46	268.46	8488.0
2017-12-19 05:00:00	SPY	ETF	268.46	268.46	268.45	268.45	5300.0
2017-12-19 05:30:00	SPY	ETF	268.46	268.49	268.4	268.49	24002.0
2017-12-19 06:00:00	SPY	ETF	268.48	268.48	268.35	268.41	8293.0
2017-12-19 06:30:00	SPY	ETF	268.41	268.45	268.35	268.39	8507.0
2017-12-19 07:00:00	SPY	ETF	268.44	268.45	268.35	268.39	212782.0
2017-12-19 07:30:00	SPY	ETF	268.39	268.52	268.38	268.5	56155.0
2017-12-19 08:00:00	SPY	ETF	268.48	268.57	268.38	268.54	107286.0
2017-12-19 08:30:00	SPY	ETF	268.53	268.58	268.45	268.47	130604.0
2017-12-19 09:00:00	SPY	ETF	268.45	268.51	268.42	268.47	244115.0
2017-12-19 09:30:00	SPY	ETF	268.48	268.53	267.75	267.8885	5877182.0
2017-12-19 10:00:00	SPY	ETF	267.87	268.51	267.7	267.8041	4598237.0
2017-12-19 10:30:00	SPY	ETF	267.81	267.935	267.57	267.74	8131748.0
2017-12-19 11:00:00	SPY	ETF	267.73	267.88	267.57	267.7999	3743987.0
2017-12-19 11:30:00	SPY	ETF	267.8	267.86	267.44	267.44	3116205.0
2017-12-19 12:00:00	SPY	ETF	267.445	267.56	267.33	267.43	2468368.0
2017-12-19 12:30:00	SPY	ETF	267.429	267.635	267.33	267.625	2700268.0
2017-12-19 13:00:00	SPY	ETF	267.62	267.76	267.53	267.61	2957923.0
2017-12-19 13:30:00	SPY	ETF	267.61	267.765	267.55	267.6337	2185947.0
2017-12-19 14:00:00	SPY	ETF	267.64	267.81	267.4738	267.7175	2464159.0
2017-12-19 14:30:00	SPY	ETF	267.71	267.72	267.28	267.39	4317644.0
2017-12-19 15:00:00	SPY	ETF	267.39	267.55	267.11	267.445	7381697.0
2017-12-19 15:30:00	SPY	ETF	267.45	267.54	267.09	267.22	11875080.0
2017-12-19 16:00:00	SPY	ETF	267.19	267.43	267.15	267.21	10657115.0
2017-12-19 16:30:00	SPY	ETF	267.23	268.0705	267.06	267.25	993932.0
2017-12-19 17:00:00	SPY	ETF	267.25	267.4707	267.14	267.14	248205.0
2017-12-19 17:30:00	SPY	ETF	267.2	267.27	267.18	267.27	3410091.0
2017-12-19 18:00:00	SPY	ETF	267.29	267.37	267.17	267.33	883872.0
2017-12-19 18:30:00	SPY	ETF	267.34	267.57	267.34	267.57	23348.0
2017-12-19 19:00:00	SPY	ETF	267.57	267.64	267.53	267.64	50869.0
2017-12-19 19:30:00	SPY	ETF	267.62	267.69	267.6	267.67	12578.0
2017-12-19 04:00:00	QQQ	ETF	158.79	158.79	158.75	158.78	680.0
2017-12-19 06:00:00	QQQ	ETF	158.68	158.69	158.66	158.66	2000.0
2017-12-19 06:30:00	QQQ	ETF	158.66	158.66	158.66	158.66	2000.0
2017-12-19 07:00:00	QQQ	ETF	158.65	158.65	158.61	158.63	2700.0
2017-12-19 07:30:00	QQQ	ETF	158.62	158.67	158.62	158.64	16899.0
2017-12-19 08:00:00	QQQ	ETF	158.63	158.65	158.53	158.54	9823.0
2017-12-19 08:30:00	QQQ	ETF	158.56	158.57	158.42	158.42	22063.0
2017-12-19 09:00:00	QQQ	ETF	158.43	158.47	158.24	158.31	183254.0
2017-12-19 09:30:00	QQQ	ETF	158.34	158.5	157.822	157.925	3740347.0
2017-12-19 10:00:00	QQQ	ETF	157.91	158.155	157.69	157.85	2197186.0
2017-12-19 10:30:00	QQQ	ETF	157.84	157.94	157.56	157.65	2240344.0
2017-12-19 11:00:00	QQQ	ETF	157.64	157.9363	157.55	157.905	1154850.0
2017-12-19 11:30:00	QQQ	ETF	157.91	157.931	157.4	157.45	1351172.0
2017-12-19 12:00:00	QQQ	ETF	157.45	157.5184	157.26	157.36	1114968.0
2017-12-19 12:30:00	QQQ	ETF	157.35	157.59	157.33	157.587	894994.0
2017-12-19 13:00:00	QQQ	ETF	157.589	157.66	157.53	157.62	500085.0
2017-12-19 13:30:00	QQQ	ETF	157.625	157.829	157.59	157.75	973628.0
2017-12-19 14:00:00	QQQ	ETF	157.745	157.85	157.63	157.8	1140678.0

> showing 50 of 16,016 rows — these rows as CSV

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