PREVIEW / etf_30min / 2014-07-28

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-07-28.parquet
  size:    347 KB
  rows:    11,951

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
2014-07-28 04:00:00	SPY	ETF	197.49	197.49	197.49	197.49	100.0
2014-07-28 04:30:00	SPY	ETF	197.51	197.51	197.42	197.42	1395.0
2014-07-28 05:00:00	SPY	ETF	197.43	197.6	197.43	197.6	472.0
2014-07-28 05:30:00	SPY	ETF	197.53	197.56	197.48	197.56	756.0
2014-07-28 06:00:00	SPY	ETF	197.52	197.61	197.48	197.61	1132.0
2014-07-28 06:30:00	SPY	ETF	197.68	197.68	197.53	197.59	25778.0
2014-07-28 07:00:00	SPY	ETF	197.58	197.63	197.4	197.5	85716.0
2014-07-28 07:30:00	SPY	ETF	197.44	197.5	197.39	197.46	39277.0
2014-07-28 08:00:00	SPY	ETF	197.47	197.72	197.44	197.64	208421.0
2014-07-28 08:30:00	SPY	ETF	197.65	197.95	197.3	197.87	475424.0
2014-07-28 09:00:00	SPY	ETF	197.86	197.89	197.68	197.76	360343.0
2014-07-28 09:30:00	SPY	ETF	197.76	197.8	196.9199	197.2	10368754.0
2014-07-28 10:00:00	SPY	ETF	197.21	197.21	196.62	196.831	10082501.0
2014-07-28 10:30:00	SPY	ETF	196.83	197.11	196.68	196.93	5244275.0
2014-07-28 11:00:00	SPY	ETF	196.939	197.4801	196.89	197.48	4631974.0
2014-07-28 11:30:00	SPY	ETF	197.48	197.57	197.34	197.385	3981979.0
2014-07-28 12:00:00	SPY	ETF	197.38	197.45	197.23	197.24	2186641.0
2014-07-28 12:30:00	SPY	ETF	197.25	197.5	197.21	197.43	2313740.0
2014-07-28 13:00:00	SPY	ETF	197.44	197.7	197.34	197.67	2427527.0
2014-07-28 13:30:00	SPY	ETF	197.68	198.09	197.68	197.96	4572238.0
2014-07-28 14:00:00	SPY	ETF	197.955	198.06	197.82	197.86	3039690.0
2014-07-28 14:30:00	SPY	ETF	197.855	197.96	197.67	197.93	3945395.0
2014-07-28 15:00:00	SPY	ETF	197.93	197.96	197.8	197.82	2460527.0
2014-07-28 15:30:00	SPY	ETF	197.82	197.89	197.72	197.79	8353213.0
2014-07-28 16:00:00	SPY	ETF	197.79	197.8	197.39	197.76	2483696.0
2014-07-28 16:30:00	SPY	ETF	197.79	197.8	197.64	197.7	765137.0
2014-07-28 17:00:00	SPY	ETF	197.7	197.73	197.64	197.65	133592.0
2014-07-28 17:30:00	SPY	ETF	197.69	197.81	197.69	197.76	66365.0
2014-07-28 18:00:00	SPY	ETF	197.76	197.83	197.7	197.83	64535.0
2014-07-28 18:30:00	SPY	ETF	197.81	197.81	197.79	197.8	20504.0
2014-07-28 19:00:00	SPY	ETF	197.82	197.82	197.79	197.8	26050.0
2014-07-28 19:30:00	SPY	ETF	197.8	197.82	197.79	197.81	7601.0
2014-07-28 04:00:00	QQQ	ETF	96.63	96.63	96.63	96.63	2000.0
2014-07-28 05:00:00	QQQ	ETF	96.71	96.71	96.71	96.71	2000.0
2014-07-28 07:00:00	QQQ	ETF	96.71	96.71	96.56	96.58	2710.0
2014-07-28 07:30:00	QQQ	ETF	96.59	96.64	96.57	96.64	2600.0
2014-07-28 08:00:00	QQQ	ETF	96.62	96.75	96.62	96.74	14550.0
2014-07-28 08:30:00	QQQ	ETF	96.75	96.9	96.75	96.85	227210.0
2014-07-28 09:00:00	QQQ	ETF	96.85	96.86	96.77	96.8	113005.0
2014-07-28 09:30:00	QQQ	ETF	96.8	96.84	96.31	96.47	3547603.0
2014-07-28 10:00:00	QQQ	ETF	96.47	96.47	96.02	96.11	2992294.0
2014-07-28 10:30:00	QQQ	ETF	96.12	96.405	96.06	96.26	1749768.0
2014-07-28 11:00:00	QQQ	ETF	96.26	96.68	96.24	96.68	2289778.0
2014-07-28 11:30:00	QQQ	ETF	96.68	96.71	96.5	96.525	1275971.0
2014-07-28 12:00:00	QQQ	ETF	96.53	96.6	96.43	96.46	917941.0
2014-07-28 12:30:00	QQQ	ETF	96.4501	96.66	96.4501	96.615	727941.0
2014-07-28 13:00:00	QQQ	ETF	96.62	96.7831	96.56	96.76	638489.0
2014-07-28 13:30:00	QQQ	ETF	96.779	97.02	96.77	96.91	1921937.0
2014-07-28 14:00:00	QQQ	ETF	96.9116	96.95	96.78	96.835	1409038.0
2014-07-28 14:30:00	QQQ	ETF	96.835	96.9	96.75	96.88	684656.0

> showing 50 of 11,951 rows — these rows as CSV

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