PREVIEW / etf_30min / 2014-03-24

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-03-24.parquet
  size:    344 KB
  rows:    11,443

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-03-24 04:00:00	SPY	ETF	186.47	186.92	186.47	186.74	23300.0
2014-03-24 04:30:00	SPY	ETF	186.72	186.72	186.54	186.69	27050.0
2014-03-24 05:00:00	SPY	ETF	186.66	186.66	186.42	186.5	8964.0
2014-03-24 05:30:00	SPY	ETF	186.5	186.59	186.45	186.58	15075.0
2014-03-24 06:00:00	SPY	ETF	186.57	186.72	186.54	186.66	32780.0
2014-03-24 06:30:00	SPY	ETF	186.62	186.66	186.42	186.54	39627.0
2014-03-24 07:00:00	SPY	ETF	186.53	186.64	186.5	186.64	51461.0
2014-03-24 07:30:00	SPY	ETF	186.62	186.66	186.57	186.59	253501.0
2014-03-24 08:00:00	SPY	ETF	186.53	186.73	186.32	186.54	221461.0
2014-03-24 08:30:00	SPY	ETF	186.55	186.74	186.55	186.67	313687.0
2014-03-24 09:00:00	SPY	ETF	186.67	186.86	186.565	186.82	597268.0
2014-03-24 09:30:00	SPY	ETF	186.82	187.07	186.19	186.3	13673917.0
2014-03-24 10:00:00	SPY	ETF	186.305	186.31	185.5	185.58	11705356.0
2014-03-24 10:30:00	SPY	ETF	185.57	185.61	185.16	185.2499	10062718.0
2014-03-24 11:00:00	SPY	ETF	185.2411	185.2411	184.73	185.1	9925740.0
2014-03-24 11:30:00	SPY	ETF	185.105	185.19	184.81	184.99	7967098.0
2014-03-24 12:00:00	SPY	ETF	184.99	185.18	184.79	184.86	5539010.0
2014-03-24 12:30:00	SPY	ETF	184.86	184.97	184.62	184.84	7212974.0
2014-03-24 13:00:00	SPY	ETF	184.84	185.1	184.83	185.06	4151689.0
2014-03-24 13:30:00	SPY	ETF	185.06	185.45	185.06	185.41	6225954.0
2014-03-24 14:00:00	SPY	ETF	185.41	185.59	185.2	185.52	7378343.0
2014-03-24 14:30:00	SPY	ETF	185.51	185.73	185.315	185.4629	6119152.0
2014-03-24 15:00:00	SPY	ETF	185.47	185.77	185.16	185.75	6624814.0
2014-03-24 15:30:00	SPY	ETF	185.75	185.95	185.41	185.41	14489811.0
2014-03-24 16:00:00	SPY	ETF	185.42	186.3398	185.37	185.43	6396318.0
2014-03-24 16:30:00	SPY	ETF	185.44	186.3398	185.34	185.43	1081251.0
2014-03-24 17:00:00	SPY	ETF	185.495	185.53	185.41	185.42	130374.0
2014-03-24 17:30:00	SPY	ETF	185.44	185.44	185.42	185.44	31651.0
2014-03-24 18:00:00	SPY	ETF	185.47	185.58	185.44	185.49	188209.0
2014-03-24 18:30:00	SPY	ETF	185.45	185.6	185.43	185.59	335374.0
2014-03-24 19:00:00	SPY	ETF	185.56	185.69	185.55	185.63	55704.0
2014-03-24 19:30:00	SPY	ETF	185.61	185.63	185.57	185.59	77286.0
2014-03-24 04:00:00	QQQ	ETF	89.22	89.34	89.2	89.22	38000.0
2014-03-24 05:00:00	QQQ	ETF	89.15	89.15	89.15	89.15	1000.0
2014-03-24 06:30:00	QQQ	ETF	89.23	89.24	89.13	89.14	57520.0
2014-03-24 07:00:00	QQQ	ETF	89.16	89.23	89.16	89.23	34100.0
2014-03-24 07:30:00	QQQ	ETF	89.24	89.26	89.24	89.26	25430.0
2014-03-24 08:00:00	QQQ	ETF	89.25	89.26	89.13	89.18	115940.0
2014-03-24 08:30:00	QQQ	ETF	89.23	89.27	89.22	89.25	53237.0
2014-03-24 09:00:00	QQQ	ETF	89.26	89.35	89.24	89.32	113607.0
2014-03-24 09:30:00	QQQ	ETF	89.32	89.39	88.5	88.73	8204207.0
2014-03-24 10:00:00	QQQ	ETF	88.73	88.7353	88.24	88.27	5588189.0
2014-03-24 10:30:00	QQQ	ETF	88.27	88.27	87.7	87.81	9669295.0
2014-03-24 11:00:00	QQQ	ETF	87.81	87.83	87.41	87.77	8640598.0
2014-03-24 11:30:00	QQQ	ETF	87.77	87.93	87.53	87.72	5595476.0
2014-03-24 12:00:00	QQQ	ETF	87.72	87.89	87.65	87.67	4005927.0
2014-03-24 12:30:00	QQQ	ETF	87.67	87.7351	87.52	87.61	4088466.0
2014-03-24 13:00:00	QQQ	ETF	87.61	87.86	87.605	87.82	3120991.0
2014-03-24 13:30:00	QQQ	ETF	87.83	88.09	87.83	88.06	2670525.0
2014-03-24 14:00:00	QQQ	ETF	88.06	88.3	88.0	88.2701	2205357.0

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

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