PREVIEW / etf_30min / 2016-02-24

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-02-24.parquet
  size:    395 KB
  rows:    13,173

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-02-24 04:00:00	SPY	ETF	192.04	192.04	191.18	191.27	27022.0
2016-02-24 04:30:00	SPY	ETF	191.28	191.47	191.06	191.47	13430.0
2016-02-24 05:00:00	SPY	ETF	191.46	191.5	190.87	191.09	54571.0
2016-02-24 05:30:00	SPY	ETF	191.09	191.27	190.8	190.9	44398.0
2016-02-24 06:00:00	SPY	ETF	190.94	191.04	190.82	190.89	56200.0
2016-02-24 06:30:00	SPY	ETF	190.87	190.94	190.55	190.59	180560.0
2016-02-24 07:00:00	SPY	ETF	190.56	190.68	190.2	190.44	345073.0
2016-02-24 07:30:00	SPY	ETF	190.47	190.74	190.37	190.56	342777.0
2016-02-24 08:00:00	SPY	ETF	190.59	190.79	190.35	190.54	444992.0
2016-02-24 08:30:00	SPY	ETF	190.53	192.33	190.28	190.71	555732.0
2016-02-24 09:00:00	SPY	ETF	190.7	190.7	190.47	190.6	832606.0
2016-02-24 09:30:00	SPY	ETF	190.63	190.65	189.55	189.795	17712311.0
2016-02-24 10:00:00	SPY	ETF	189.8	190.03	189.43	189.66	11756676.0
2016-02-24 10:30:00	SPY	ETF	189.66	190.39	189.32	190.18	14539811.0
2016-02-24 11:00:00	SPY	ETF	190.18	190.25	189.59	189.885	7761606.0
2016-02-24 11:30:00	SPY	ETF	189.88	191.07	189.81	190.98	11311995.0
2016-02-24 12:00:00	SPY	ETF	190.98	191.43	190.86	190.87	8690738.0
2016-02-24 12:30:00	SPY	ETF	190.87	191.17	190.58	191.0201	5518988.0
2016-02-24 13:00:00	SPY	ETF	191.025	191.59	190.98	191.19	8272672.0
2016-02-24 13:30:00	SPY	ETF	191.17	191.49	190.97	191.24	6476571.0
2016-02-24 14:00:00	SPY	ETF	191.24	192.54	191.16	192.4	11220198.0
2016-02-24 14:30:00	SPY	ETF	192.4	192.66	192.25	192.32	8581226.0
2016-02-24 15:00:00	SPY	ETF	192.32	193.51	192.32	193.37	10595258.0
2016-02-24 15:30:00	SPY	ETF	193.37	193.53	192.88	193.22	13054684.0
2016-02-24 16:00:00	SPY	ETF	193.22	193.75	193.18	193.62	3579350.0
2016-02-24 16:30:00	SPY	ETF	193.62	193.95	193.62	193.95	258437.0
2016-02-24 17:00:00	SPY	ETF	193.91	193.94	193.82	193.85	136956.0
2016-02-24 17:30:00	SPY	ETF	193.83	193.9	193.82	193.86	83122.0
2016-02-24 18:00:00	SPY	ETF	193.86	193.86	193.6	193.76	160953.0
2016-02-24 18:30:00	SPY	ETF	193.78	194.24	193.68	194.2	208696.0
2016-02-24 19:00:00	SPY	ETF	194.18	194.43	193.96	194.03	244443.0
2016-02-24 19:30:00	SPY	ETF	194.07	194.12	193.93	194.03	112510.0
2016-02-24 04:00:00	QQQ	ETF	101.4	101.4	101.4	101.4	100.0
2016-02-24 04:30:00	QQQ	ETF	100.89	100.89	100.8	100.8	300.0
2016-02-24 05:00:00	QQQ	ETF	100.79	100.8	100.76	100.8	670.0
2016-02-24 05:30:00	QQQ	ETF	100.83	100.83	100.62	100.7	4200.0
2016-02-24 06:00:00	QQQ	ETF	100.75	100.75	100.66	100.67	4199.0
2016-02-24 06:30:00	QQQ	ETF	100.63	100.63	100.34	100.42	55966.0
2016-02-24 07:00:00	QQQ	ETF	100.36	100.43	100.16	100.25	44673.0
2016-02-24 07:30:00	QQQ	ETF	100.21	100.41	100.2	100.34	24696.0
2016-02-24 08:00:00	QQQ	ETF	100.37	100.48	100.21	100.37	87808.0
2016-02-24 08:30:00	QQQ	ETF	100.38	100.44	100.26	100.44	53206.0
2016-02-24 09:00:00	QQQ	ETF	100.39	100.45	100.32	100.45	148323.0
2016-02-24 09:30:00	QQQ	ETF	100.44	100.5	99.87	100.04	5150919.0
2016-02-24 10:00:00	QQQ	ETF	100.035	100.24	99.84	99.961	4193446.0
2016-02-24 10:30:00	QQQ	ETF	99.98	100.395	99.77	100.28	2829492.0
2016-02-24 11:00:00	QQQ	ETF	100.29	100.36	99.97	100.15	1594606.0
2016-02-24 11:30:00	QQQ	ETF	100.17	100.94	100.13	100.85	2842134.0
2016-02-24 12:00:00	QQQ	ETF	100.85	101.13	100.83	100.89	2058279.0
2016-02-24 12:30:00	QQQ	ETF	100.9	101.09	100.69	100.95	1562088.0

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

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