PREVIEW / etf_30min / 2016-12-14

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-12-14.parquet
  size:    442 KB
  rows:    15,048

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-12-14 04:00:00	SPY	ETF	227.83	227.86	227.76	227.86	2803.0
2016-12-14 04:30:00	SPY	ETF	227.83	227.86	227.72	227.75	4401.0
2016-12-14 05:00:00	SPY	ETF	227.75	227.75	227.68	227.68	4101.0
2016-12-14 05:30:00	SPY	ETF	227.8	227.81	227.77	227.81	1633.0
2016-12-14 06:00:00	SPY	ETF	227.76	227.76	227.62	227.62	10921.0
2016-12-14 06:30:00	SPY	ETF	227.66	227.84	227.65	227.84	7968.0
2016-12-14 07:00:00	SPY	ETF	227.86	227.92	227.82	227.84	24038.0
2016-12-14 07:30:00	SPY	ETF	227.83	227.85	227.72	227.78	99951.0
2016-12-14 08:00:00	SPY	ETF	227.8	227.91	227.61	227.62	94406.0
2016-12-14 08:30:00	SPY	ETF	227.61	227.7	227.47	227.61	336889.0
2016-12-14 09:00:00	SPY	ETF	227.59	227.62	227.34	227.42	370846.0
2016-12-14 09:30:00	SPY	ETF	227.41	227.81	227.4	227.54	5562000.0
2016-12-14 10:00:00	SPY	ETF	227.55	227.57	227.21	227.43	5066270.0
2016-12-14 10:30:00	SPY	ETF	227.45	227.62	227.25	227.4	4209354.0
2016-12-14 11:00:00	SPY	ETF	227.4	227.49	227.235	227.39	3983056.0
2016-12-14 11:30:00	SPY	ETF	227.399	227.399	227.06	227.235	4011526.0
2016-12-14 12:00:00	SPY	ETF	227.245	227.56	227.24	227.52	5206147.0
2016-12-14 12:30:00	SPY	ETF	227.52	227.67	227.491	227.63	4872222.0
2016-12-14 13:00:00	SPY	ETF	227.63	227.76	227.56	227.75	9419599.0
2016-12-14 13:30:00	SPY	ETF	227.75	227.86	227.625	227.82	5005424.0
2016-12-14 14:00:00	SPY	ETF	227.8287	228.23	226.25	226.35	22714168.0
2016-12-14 14:30:00	SPY	ETF	226.35	227.23	226.26	226.33	13310942.0
2016-12-14 15:00:00	SPY	ETF	226.33	226.72	225.365	226.05	17075524.0
2016-12-14 15:30:00	SPY	ETF	226.06	227.03	225.59	225.92	27423638.0
2016-12-14 16:00:00	SPY	ETF	225.92	226.34	225.88	226.24	8843680.0
2016-12-14 16:30:00	SPY	ETF	226.22	226.37	226.21	226.23	743433.0
2016-12-14 17:00:00	SPY	ETF	226.21	226.31	225.88	226.31	260915.0
2016-12-14 17:30:00	SPY	ETF	226.29	226.33	226.22	226.23	589980.0
2016-12-14 18:00:00	SPY	ETF	226.22	226.24	225.99	226.03	127609.0
2016-12-14 18:30:00	SPY	ETF	226.02	226.29	225.9	226.29	83149.0
2016-12-14 19:00:00	SPY	ETF	226.29	226.64	226.29	226.39	93251.0
2016-12-14 19:30:00	SPY	ETF	226.39	226.5	226.33	226.38	82896.0
2016-12-14 04:30:00	QQQ	ETF	120.62	120.62	120.62	120.62	1800.0
2016-12-14 05:00:00	QQQ	ETF	120.58	120.58	120.54	120.54	2199.0
2016-12-14 05:30:00	QQQ	ETF	120.54	120.6	120.54	120.57	2100.0
2016-12-14 06:00:00	QQQ	ETF	120.56	120.56	120.5	120.54	2400.0
2016-12-14 06:30:00	QQQ	ETF	120.58	120.61	120.58	120.61	699.0
2016-12-14 07:00:00	QQQ	ETF	120.55	120.61	120.55	120.57	13400.0
2016-12-14 07:30:00	QQQ	ETF	120.61	120.61	120.56	120.56	50413.0
2016-12-14 08:00:00	QQQ	ETF	120.6	120.62	120.55	120.55	13065.0
2016-12-14 08:30:00	QQQ	ETF	120.55	120.59	120.47	120.58	52407.0
2016-12-14 09:00:00	QQQ	ETF	120.58	120.62	120.47	120.6	94561.0
2016-12-14 09:30:00	QQQ	ETF	120.56	120.849	120.56	120.77	2011432.0
2016-12-14 10:00:00	QQQ	ETF	120.77	120.9	120.62	120.81	876270.0
2016-12-14 10:30:00	QQQ	ETF	120.81	120.86	120.66	120.69	1049482.0
2016-12-14 11:00:00	QQQ	ETF	120.68	120.69	120.445	120.56	717049.0
2016-12-14 11:30:00	QQQ	ETF	120.56	120.72	120.48	120.6365	695136.0
2016-12-14 12:00:00	QQQ	ETF	120.63	120.725	120.61	120.71	492091.0
2016-12-14 12:30:00	QQQ	ETF	120.7153	120.79	120.66	120.76	418302.0
2016-12-14 13:00:00	QQQ	ETF	120.75	120.83	120.6901	120.79	567130.0

> showing 50 of 15,048 rows — these rows as CSV

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