PREVIEW / etf_30min / 2016-09-16

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-09-16.parquet
  size:    387 KB
  rows:    13,302

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-09-16 04:00:00	SPY	ETF	213.74	213.74	213.5	213.55	38679.0
2016-09-16 04:30:00	SPY	ETF	213.5	213.5	213.21	213.39	9106.0
2016-09-16 05:00:00	SPY	ETF	213.43	213.62	213.39	213.48	5972.0
2016-09-16 05:30:00	SPY	ETF	213.47	213.56	213.47	213.56	300.0
2016-09-16 06:00:00	SPY	ETF	213.43	213.47	213.0	213.09	173723.0
2016-09-16 06:30:00	SPY	ETF	213.0	213.17	212.91	213.17	95073.0
2016-09-16 07:00:00	SPY	ETF	213.15	213.27	213.0	213.15	169950.0
2016-09-16 07:30:00	SPY	ETF	213.17	213.26	213.11	213.15	300652.0
2016-09-16 08:00:00	SPY	ETF	213.15	213.79	213.06	213.62	546048.0
2016-09-16 08:30:00	SPY	ETF	213.48	214.1979	213.25	213.72	1774793.0
2016-09-16 09:00:00	SPY	ETF	213.75	213.93	213.38	213.47	2062525.0
2016-09-16 09:30:00	SPY	ETF	213.48	213.51	212.97	213.23	17776394.0
2016-09-16 10:00:00	SPY	ETF	213.22	213.26	212.61	212.86	20318091.0
2016-09-16 10:30:00	SPY	ETF	212.865	213.52	212.7989	213.04	17897480.0
2016-09-16 11:00:00	SPY	ETF	213.03	213.16	212.84	212.945	8835165.0
2016-09-16 11:30:00	SPY	ETF	212.945	213.39	212.86	213.2	6666838.0
2016-09-16 12:00:00	SPY	ETF	213.2	213.46	213.1525	213.36	4628201.0
2016-09-16 12:30:00	SPY	ETF	213.36	213.44	213.09	213.09	6225605.0
2016-09-16 13:00:00	SPY	ETF	213.08	213.23	212.93	212.96	4510449.0
2016-09-16 13:30:00	SPY	ETF	212.96	213.02	212.57	212.79	7553263.0
2016-09-16 14:00:00	SPY	ETF	212.78	213.16	212.64	213.065	11752779.0
2016-09-16 14:30:00	SPY	ETF	213.08	213.37	213.0	213.03	7445984.0
2016-09-16 15:00:00	SPY	ETF	213.03	213.35	212.99	213.245	6626031.0
2016-09-16 15:30:00	SPY	ETF	213.25	213.69	213.25	213.34	16927689.0
2016-09-16 16:00:00	SPY	ETF	213.34	213.59	213.3	213.52	7657824.0
2016-09-16 16:30:00	SPY	ETF	213.53	213.58	213.45	213.5	1060690.0
2016-09-16 17:00:00	SPY	ETF	213.51	213.52	213.37	213.48	317936.0
2016-09-16 17:30:00	SPY	ETF	213.51	213.6	213.47	213.57	66801.0
2016-09-16 18:00:00	SPY	ETF	213.57	213.57	213.5	213.53	26237.0
2016-09-16 18:30:00	SPY	ETF	213.52	213.54	213.37	213.53	18618.0
2016-09-16 19:00:00	SPY	ETF	213.51	213.55	213.5	213.51	11329.0
2016-09-16 19:30:00	SPY	ETF	213.52	213.59	213.52	213.57	11443.0
2016-09-16 04:30:00	QQQ	ETF	117.03	117.03	116.98	116.99	6400.0
2016-09-16 05:00:00	QQQ	ETF	117.1	117.1	117.1	117.1	2296.0
2016-09-16 05:30:00	QQQ	ETF	117.08	117.09	117.08	117.09	2200.0
2016-09-16 06:00:00	QQQ	ETF	117.02	117.05	116.88	116.9	20300.0
2016-09-16 06:30:00	QQQ	ETF	116.84	116.9	116.8	116.87	18377.0
2016-09-16 07:00:00	QQQ	ETF	116.94	116.99	116.91	116.96	29001.0
2016-09-16 07:30:00	QQQ	ETF	116.96	116.98	116.87	116.9	20076.0
2016-09-16 08:00:00	QQQ	ETF	116.9	117.15	116.84	117.06	146263.0
2016-09-16 08:30:00	QQQ	ETF	117.06	117.13	116.9	117.13	67120.0
2016-09-16 09:00:00	QQQ	ETF	117.15	117.44	117.14	117.22	1116178.0
2016-09-16 09:30:00	QQQ	ETF	117.22	117.39	116.94	117.0499	3579558.0
2016-09-16 10:00:00	QQQ	ETF	117.05	117.08	116.71	116.9062	2153179.0
2016-09-16 10:30:00	QQQ	ETF	116.9	117.3	116.86	117.0	1520970.0
2016-09-16 11:00:00	QQQ	ETF	117.0001	117.0964	116.85	116.97	1136050.0
2016-09-16 11:30:00	QQQ	ETF	116.97	117.185	116.915	117.065	661810.0
2016-09-16 12:00:00	QQQ	ETF	117.07	117.289	117.03	117.22	646253.0
2016-09-16 12:30:00	QQQ	ETF	117.24	117.265	117.02	117.05	547978.0
2016-09-16 13:00:00	QQQ	ETF	117.04	117.14	116.97	116.98	781487.0

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

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