PREVIEW / etf_30min / 2016-05-17

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-05-17.parquet
  size:    392 KB
  rows:    13,226

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-17 04:00:00	SPY	ETF	207.2	207.27	207.0	207.0	2007.0
2016-05-17 04:30:00	SPY	ETF	207.1	207.24	207.04	207.04	4740.0
2016-05-17 05:00:00	SPY	ETF	206.82	206.84	206.67	206.84	6234.0
2016-05-17 05:30:00	SPY	ETF	206.83	206.97	206.83	206.97	1900.0
2016-05-17 06:00:00	SPY	ETF	206.87	207.07	206.87	206.94	14294.0
2016-05-17 06:30:00	SPY	ETF	206.83	206.92	206.64	206.64	16099.0
2016-05-17 07:00:00	SPY	ETF	206.67	206.77	206.51	206.59	156297.0
2016-05-17 07:30:00	SPY	ETF	206.59	206.74	206.51	206.73	95405.0
2016-05-17 08:00:00	SPY	ETF	206.67	206.75	206.53	206.56	263590.0
2016-05-17 08:30:00	SPY	ETF	206.54	206.59	206.22	206.32	612271.0
2016-05-17 09:00:00	SPY	ETF	206.32	206.5	206.25	206.46	485060.0
2016-05-17 09:30:00	SPY	ETF	206.46	206.8	205.91	206.28	11825412.0
2016-05-17 10:00:00	SPY	ETF	206.27	206.29	205.76	206.01	7351118.0
2016-05-17 10:30:00	SPY	ETF	206.0	206.52	205.825	206.465	5650134.0
2016-05-17 11:00:00	SPY	ETF	206.45	206.48	206.03	206.065	4027670.0
2016-05-17 11:30:00	SPY	ETF	206.06	206.57	206.06	206.44	2827178.0
2016-05-17 12:00:00	SPY	ETF	206.45	206.45	205.87	205.98	3623430.0
2016-05-17 12:30:00	SPY	ETF	205.98	206.04	205.65	205.77	3680101.0
2016-05-17 13:00:00	SPY	ETF	205.77	205.91	205.675	205.855	3054589.0
2016-05-17 13:30:00	SPY	ETF	205.855	206.01	205.26	205.26	3387481.0
2016-05-17 14:00:00	SPY	ETF	205.26	205.33	204.33	204.6267	13664224.0
2016-05-17 14:30:00	SPY	ETF	204.63	204.87	204.46	204.84	10610703.0
2016-05-17 15:00:00	SPY	ETF	204.84	205.12	204.23	204.46	13030229.0
2016-05-17 15:30:00	SPY	ETF	204.46	204.94	204.38	204.88	20859431.0
2016-05-17 16:00:00	SPY	ETF	204.89	205.0	204.783	204.95	5857335.0
2016-05-17 16:30:00	SPY	ETF	204.96	205.05	204.96	205.0	1372737.0
2016-05-17 17:00:00	SPY	ETF	204.98	204.98	204.9	204.93	110704.0
2016-05-17 17:30:00	SPY	ETF	204.93	204.94	204.82	204.85	317070.0
2016-05-17 18:00:00	SPY	ETF	204.88	204.99	204.78	204.99	254717.0
2016-05-17 18:30:00	SPY	ETF	204.99	205.03	204.94	204.94	60738.0
2016-05-17 19:00:00	SPY	ETF	204.96	205.04	204.96	204.97	26300.0
2016-05-17 19:30:00	SPY	ETF	204.96	204.98	204.86	204.95	23777.0
2016-05-17 04:00:00	QQQ	ETF	107.15	107.17	107.15	107.17	360.0
2016-05-17 04:30:00	QQQ	ETF	107.16	107.16	107.16	107.16	200.0
2016-05-17 05:30:00	QQQ	ETF	106.98	106.98	106.98	106.98	800.0
2016-05-17 06:00:00	QQQ	ETF	106.98	107.06	106.98	106.98	8700.0
2016-05-17 06:30:00	QQQ	ETF	106.94	106.94	106.88	106.93	6171.0
2016-05-17 07:00:00	QQQ	ETF	106.89	106.89	106.76	106.81	2536.0
2016-05-17 07:30:00	QQQ	ETF	106.75	106.87	106.75	106.86	15710.0
2016-05-17 08:00:00	QQQ	ETF	106.86	106.86	106.75	106.78	22388.0
2016-05-17 08:30:00	QQQ	ETF	106.72	106.72	106.6	106.62	15407.0
2016-05-17 09:00:00	QQQ	ETF	106.67	106.78	106.62	106.75	164540.0
2016-05-17 09:30:00	QQQ	ETF	106.74	107.04	106.38	106.6	3283744.0
2016-05-17 10:00:00	QQQ	ETF	106.6	106.6	106.22	106.25	1704235.0
2016-05-17 10:30:00	QQQ	ETF	106.242	106.51	106.1	106.45	1125380.0
2016-05-17 11:00:00	QQQ	ETF	106.44	106.54	106.28	106.3	838508.0
2016-05-17 11:30:00	QQQ	ETF	106.301	106.63	106.301	106.53	936288.0
2016-05-17 12:00:00	QQQ	ETF	106.53	106.58	106.211	106.3	596876.0
2016-05-17 12:30:00	QQQ	ETF	106.301	106.3899	106.12	106.2	677947.0
2016-05-17 13:00:00	QQQ	ETF	106.2	106.28	106.13	106.22	558801.0

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

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