PREVIEW / etf_30min / 2016-05-04

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-05-04.parquet
  size:    394 KB
  rows:    13,460

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-05-04 04:00:00	SPY	ETF	206.23	206.24	205.86	205.89	33966.0
2016-05-04 04:30:00	SPY	ETF	205.87	205.87	205.45	205.45	10036.0
2016-05-04 05:00:00	SPY	ETF	205.42	205.45	205.19	205.35	8266.0
2016-05-04 05:30:00	SPY	ETF	205.27	205.3	204.6	204.6	91230.0
2016-05-04 06:00:00	SPY	ETF	204.61	204.75	204.57	204.67	171350.0
2016-05-04 06:30:00	SPY	ETF	204.67	204.84	204.63	204.73	54667.0
2016-05-04 07:00:00	SPY	ETF	204.73	204.99	204.73	204.95	306373.0
2016-05-04 07:30:00	SPY	ETF	204.91	205.03	204.9	204.96	327927.0
2016-05-04 08:00:00	SPY	ETF	204.98	206.249	204.75	204.82	975072.0
2016-05-04 08:30:00	SPY	ETF	204.8	205.01	204.67	204.67	568596.0
2016-05-04 09:00:00	SPY	ETF	204.69	205.01	204.67	205.0	446370.0
2016-05-04 09:30:00	SPY	ETF	204.99	205.44	204.72	205.35	11421106.0
2016-05-04 10:00:00	SPY	ETF	205.36	205.85	205.19	205.48	11364347.0
2016-05-04 10:30:00	SPY	ETF	205.48	205.58	204.92	205.09	7178079.0
2016-05-04 11:00:00	SPY	ETF	205.08	205.285	204.62	204.74	5153200.0
2016-05-04 11:30:00	SPY	ETF	204.74	205.04	204.62	204.9286	4440194.0
2016-05-04 12:00:00	SPY	ETF	204.92	205.27	204.86	205.09	3040199.0
2016-05-04 12:30:00	SPY	ETF	205.0825	205.17	204.67	204.6701	3112760.0
2016-05-04 13:00:00	SPY	ETF	204.68	205.03	204.6	205.03	3683433.0
2016-05-04 13:30:00	SPY	ETF	205.03	205.055	204.64	204.67	3335791.0
2016-05-04 14:00:00	SPY	ETF	204.675	205.01	204.42	204.991	5774794.0
2016-05-04 14:30:00	SPY	ETF	205.0	205.1	204.85	204.86	4479771.0
2016-05-04 15:00:00	SPY	ETF	204.87	205.08	204.69	204.89	4566531.0
2016-05-04 15:30:00	SPY	ETF	204.89	205.33	204.87	204.99	11846738.0
2016-05-04 16:00:00	SPY	ETF	204.99	205.22	204.95	205.15	6435594.0
2016-05-04 16:30:00	SPY	ETF	205.14	205.2	204.96	205.15	612322.0
2016-05-04 17:00:00	SPY	ETF	205.15	205.16	204.96	205.11	88218.0
2016-05-04 17:30:00	SPY	ETF	205.1	205.18	205.09	205.13	20768.0
2016-05-04 18:00:00	SPY	ETF	205.14	205.37	205.14	205.36	141907.0
2016-05-04 18:30:00	SPY	ETF	205.3	205.33	205.27	205.33	14178.0
2016-05-04 19:00:00	SPY	ETF	205.35	205.43	205.32	205.43	13714.0
2016-05-04 19:30:00	SPY	ETF	205.39	205.4	205.33	205.36	39495.0
2016-05-04 04:00:00	QQQ	ETF	105.68	105.68	105.61	105.61	250.0
2016-05-04 04:30:00	QQQ	ETF	105.59	105.59	105.4	105.41	1602.0
2016-05-04 05:00:00	QQQ	ETF	105.37	105.37	105.29	105.36	2498.0
2016-05-04 05:30:00	QQQ	ETF	105.23	105.23	105.01	105.01	6957.0
2016-05-04 06:00:00	QQQ	ETF	105.01	105.07	104.99	105.02	1300.0
2016-05-04 06:30:00	QQQ	ETF	105.04	105.11	105.04	105.08	3047.0
2016-05-04 07:00:00	QQQ	ETF	105.07	105.11	105.01	105.08	67994.0
2016-05-04 07:30:00	QQQ	ETF	105.05	105.1	105.05	105.08	21050.0
2016-05-04 08:00:00	QQQ	ETF	105.1	105.17	104.97	105.02	78763.0
2016-05-04 08:30:00	QQQ	ETF	105.0	105.1	104.99	104.99	34264.0
2016-05-04 09:00:00	QQQ	ETF	105.03	105.15	104.99	105.13	208468.0
2016-05-04 09:30:00	QQQ	ETF	105.13	105.34	104.97	105.3138	3497988.0
2016-05-04 10:00:00	QQQ	ETF	105.32	105.4811	105.22	105.28	2740890.0
2016-05-04 10:30:00	QQQ	ETF	105.27	105.405	105.08	105.24	1778100.0
2016-05-04 11:00:00	QQQ	ETF	105.25	105.38	104.93	104.99	1521148.0
2016-05-04 11:30:00	QQQ	ETF	105.0	105.17	104.905	105.1	1176869.0
2016-05-04 12:00:00	QQQ	ETF	105.11	105.35	105.06	105.2	705561.0
2016-05-04 12:30:00	QQQ	ETF	105.18	105.22	104.94	104.94	1082107.0

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

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