PREVIEW / etf_30min / 2016-08-24

all etf 30-min files

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

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-08-24 04:00:00	SPY	ETF	218.94	219.03	218.87	218.9	5404.0
2016-08-24 04:30:00	SPY	ETF	218.9	219.1	218.87	219.1	3012.0
2016-08-24 05:00:00	SPY	ETF	219.1	219.19	219.1	219.19	504.0
2016-08-24 05:30:00	SPY	ETF	219.17	219.17	219.1	219.1	1019.0
2016-08-24 06:00:00	SPY	ETF	219.1	219.18	219.1	219.13	1302.0
2016-08-24 06:30:00	SPY	ETF	219.12	219.17	219.07	219.15	5493.0
2016-08-24 07:00:00	SPY	ETF	219.16	219.18	219.03	219.06	10838.0
2016-08-24 07:30:00	SPY	ETF	219.03	219.08	218.99	219.05	22943.0
2016-08-24 08:00:00	SPY	ETF	219.07	219.15	218.949	219.12	179601.0
2016-08-24 08:30:00	SPY	ETF	219.1	219.1	219.03	219.08	58075.0
2016-08-24 09:00:00	SPY	ETF	219.05	219.09	218.8	218.8	301519.0
2016-08-24 09:30:00	SPY	ETF	218.8	218.91	218.61	218.755	5030531.0
2016-08-24 10:00:00	SPY	ETF	218.75	218.85	218.54	218.6586	3419257.0
2016-08-24 10:30:00	SPY	ETF	218.64	218.68	218.29	218.47	4739276.0
2016-08-24 11:00:00	SPY	ETF	218.475	218.57	218.385	218.52	2501712.0
2016-08-24 11:30:00	SPY	ETF	218.52	218.57	218.34	218.435	2848567.0
2016-08-24 12:00:00	SPY	ETF	218.44	218.69	218.41	218.56	5333439.0
2016-08-24 12:30:00	SPY	ETF	218.56	218.77	218.555	218.72	3012225.0
2016-08-24 13:00:00	SPY	ETF	218.721	218.74	218.56	218.57	2616508.0
2016-08-24 13:30:00	SPY	ETF	218.56	218.6	218.49	218.5	2445837.0
2016-08-24 14:00:00	SPY	ETF	218.5	218.51	218.06	218.15	4512033.0
2016-08-24 14:30:00	SPY	ETF	218.15	218.25	218.05	218.225	2788905.0
2016-08-24 15:00:00	SPY	ETF	218.23	218.23	217.76	217.805	5969176.0
2016-08-24 15:30:00	SPY	ETF	217.805	217.89	217.36	217.88	14298440.0
2016-08-24 16:00:00	SPY	ETF	217.89	218.05	217.75	217.96	7236888.0
2016-08-24 16:30:00	SPY	ETF	217.96	218.97	217.88	217.95	497563.0
2016-08-24 17:00:00	SPY	ETF	217.95	217.96	217.93	217.93	486525.0
2016-08-24 17:30:00	SPY	ETF	217.94	217.96	217.94	217.94	13929.0
2016-08-24 18:00:00	SPY	ETF	217.93	217.96	217.83	217.92	70474.0
2016-08-24 18:30:00	SPY	ETF	217.92	217.92	217.85	217.91	41821.0
2016-08-24 19:00:00	SPY	ETF	217.92	217.95	217.89	217.92	14902.0
2016-08-24 19:30:00	SPY	ETF	217.93	217.94	217.9	217.94	37759.0
2016-08-24 04:00:00	QQQ	ETF	117.55	117.55	117.55	117.55	500.0
2016-08-24 04:30:00	QQQ	ETF	117.48	117.6	117.48	117.6	800.0
2016-08-24 05:00:00	QQQ	ETF	117.66	117.67	117.65	117.67	20000.0
2016-08-24 05:30:00	QQQ	ETF	117.66	117.66	117.65	117.65	14900.0
2016-08-24 06:00:00	QQQ	ETF	117.65	117.65	117.65	117.65	4999.0
2016-08-24 07:00:00	QQQ	ETF	117.58	117.62	117.57	117.61	15599.0
2016-08-24 07:30:00	QQQ	ETF	117.57	117.62	117.57	117.62	3815.0
2016-08-24 08:00:00	QQQ	ETF	117.62	117.66	117.62	117.65	18187.0
2016-08-24 08:30:00	QQQ	ETF	117.62	117.64	117.59	117.62	3652.0
2016-08-24 09:00:00	QQQ	ETF	117.62	117.62	117.48	117.5	86529.0
2016-08-24 09:30:00	QQQ	ETF	117.5	117.64	117.4101	117.53	1381507.0
2016-08-24 10:00:00	QQQ	ETF	117.53	117.6	117.38	117.45	720186.0
2016-08-24 10:30:00	QQQ	ETF	117.44	117.49	117.27	117.35	733048.0
2016-08-24 11:00:00	QQQ	ETF	117.35	117.4	117.29	117.37	358076.0
2016-08-24 11:30:00	QQQ	ETF	117.37	117.39	117.23	117.295	491958.0
2016-08-24 12:00:00	QQQ	ETF	117.29	117.425	117.27	117.34	830583.0
2016-08-24 12:30:00	QQQ	ETF	117.34	117.46	117.34	117.44	272975.0
2016-08-24 13:00:00	QQQ	ETF	117.4348	117.46	117.349	117.349	575708.0

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

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