PREVIEW / etf_30min / 2016-09-07

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-09-07.parquet
  size:    393 KB
  rows:    13,425

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-07 04:00:00	SPY	ETF	219.03	219.03	218.97	218.97	1239.0
2016-09-07 04:30:00	SPY	ETF	219.05	219.15	219.0	219.0	3346.0
2016-09-07 05:00:00	SPY	ETF	218.97	219.06	218.93	219.05	5661.0
2016-09-07 05:30:00	SPY	ETF	219.02	219.02	218.93	218.93	1804.0
2016-09-07 06:00:00	SPY	ETF	218.92	218.92	218.9	218.9	800.0
2016-09-07 06:30:00	SPY	ETF	218.9	218.93	218.86	218.86	1254.0
2016-09-07 07:00:00	SPY	ETF	218.85	218.86	218.76	218.77	17446.0
2016-09-07 07:30:00	SPY	ETF	218.77	218.82	218.77	218.77	36506.0
2016-09-07 08:00:00	SPY	ETF	218.79	219.011	218.7	218.71	95373.0
2016-09-07 08:30:00	SPY	ETF	218.71	218.89	218.67	218.88	258338.0
2016-09-07 09:00:00	SPY	ETF	218.86	218.88	218.81	218.82	79694.0
2016-09-07 09:30:00	SPY	ETF	218.84	219.09	218.69	218.962	5771776.0
2016-09-07 10:00:00	SPY	ETF	218.96	219.2	218.9	219.18	6352692.0
2016-09-07 10:30:00	SPY	ETF	219.19	219.22	218.68	218.79	5273246.0
2016-09-07 11:00:00	SPY	ETF	218.78	218.87	218.51	218.585	6796055.0
2016-09-07 11:30:00	SPY	ETF	218.59	218.69	218.51	218.685	3391623.0
2016-09-07 12:00:00	SPY	ETF	218.69	218.76	218.3	218.45	6292208.0
2016-09-07 12:30:00	SPY	ETF	218.45	218.65	218.39	218.52	3217312.0
2016-09-07 13:00:00	SPY	ETF	218.52	218.75	218.46	218.67	4264497.0
2016-09-07 13:30:00	SPY	ETF	218.67	218.81	218.635	218.71	3436425.0
2016-09-07 14:00:00	SPY	ETF	218.72	218.95	218.67	218.86	4621684.0
2016-09-07 14:30:00	SPY	ETF	218.86	218.97	218.74	218.895	4180833.0
2016-09-07 15:00:00	SPY	ETF	218.895	219.04	218.88	218.94	3798491.0
2016-09-07 15:30:00	SPY	ETF	218.945	219.07	218.87	219.06	12122180.0
2016-09-07 16:00:00	SPY	ETF	219.08	219.1529	218.98	219.03	3430394.0
2016-09-07 16:30:00	SPY	ETF	219.03	219.04	218.99	219.03	453156.0
2016-09-07 17:00:00	SPY	ETF	219.04	219.04	219.0	219.04	89795.0
2016-09-07 17:30:00	SPY	ETF	219.02	219.1	219.02	219.05	155294.0
2016-09-07 18:00:00	SPY	ETF	219.05	219.07	219.02	219.05	68094.0
2016-09-07 18:30:00	SPY	ETF	219.05	219.05	218.98	218.98	24066.0
2016-09-07 19:00:00	SPY	ETF	218.98	219.0	218.96	218.96	25071.0
2016-09-07 19:30:00	SPY	ETF	218.96	218.98	218.96	218.98	13170.0
2016-09-07 04:30:00	QQQ	ETF	117.98	118.03	117.98	118.03	610.0
2016-09-07 05:00:00	QQQ	ETF	117.97	117.97	117.97	117.97	100.0
2016-09-07 06:30:00	QQQ	ETF	117.98	117.99	117.94	117.94	10520.0
2016-09-07 07:00:00	QQQ	ETF	117.92	117.93	117.92	117.92	10987.0
2016-09-07 07:30:00	QQQ	ETF	117.92	117.93	117.92	117.93	1709.0
2016-09-07 08:00:00	QQQ	ETF	117.9	117.92	117.89	117.9	4259.0
2016-09-07 08:30:00	QQQ	ETF	117.9	117.94	117.88	117.94	10806.0
2016-09-07 09:00:00	QQQ	ETF	117.96	117.98	117.93	117.96	28489.0
2016-09-07 09:30:00	QQQ	ETF	117.95	118.086	117.85	117.95	2296299.0
2016-09-07 10:00:00	QQQ	ETF	117.94	118.115	117.88	118.09	1595576.0
2016-09-07 10:30:00	QQQ	ETF	118.1	118.12	117.79	117.84	1017852.0
2016-09-07 11:00:00	QQQ	ETF	117.83	117.9	117.7	117.75	640778.0
2016-09-07 11:30:00	QQQ	ETF	117.75	117.8	117.69	117.7899	733621.0
2016-09-07 12:00:00	QQQ	ETF	117.79	117.8	117.47	117.57	956622.0
2016-09-07 12:30:00	QQQ	ETF	117.56	117.64	117.51	117.6	517853.0
2016-09-07 13:00:00	QQQ	ETF	117.6	117.72	117.57	117.64	547808.0
2016-09-07 13:30:00	QQQ	ETF	117.66	117.73	117.63	117.675	488790.0
2016-09-07 14:00:00	QQQ	ETF	117.68	117.79	117.6365	117.7	564589.0

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

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