PREVIEW / etf_30min / 2013-05-03

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-03.parquet
  size:    323 KB
  rows:    10,890

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
2013-05-03 04:00:00	SPY	ETF	159.62	159.62	159.56	159.59	1660.0
2013-05-03 04:30:00	SPY	ETF	159.55	159.55	159.51	159.54	3300.0
2013-05-03 05:00:00	SPY	ETF	159.46	159.54	159.46	159.5	15100.0
2013-05-03 05:30:00	SPY	ETF	159.54	159.66	159.54	159.66	6629.0
2013-05-03 06:00:00	SPY	ETF	159.64	159.64	159.61	159.61	1600.0
2013-05-03 06:30:00	SPY	ETF	159.59	159.64	159.57	159.58	4600.0
2013-05-03 07:00:00	SPY	ETF	159.59	159.69	159.56	159.65	90012.0
2013-05-03 07:30:00	SPY	ETF	159.65	159.65	159.48	159.59	137588.0
2013-05-03 08:00:00	SPY	ETF	159.64	159.72	159.52	159.63	754446.0
2013-05-03 08:30:00	SPY	ETF	159.87	161.05	159.68	160.91	6511495.0
2013-05-03 09:00:00	SPY	ETF	160.92	161.19	160.92	161.15	2456297.0
2013-05-03 09:30:00	SPY	ETF	161.14	161.66	161.04	161.44	21156127.0
2013-05-03 10:00:00	SPY	ETF	161.445	161.85	161.3	161.82	12436513.0
2013-05-03 10:30:00	SPY	ETF	161.82	161.88	161.72	161.77	8217634.0
2013-05-03 11:00:00	SPY	ETF	161.77	161.88	161.6	161.63	7249926.0
2013-05-03 11:30:00	SPY	ETF	161.63	161.74	161.57	161.601	6125178.0
2013-05-03 12:00:00	SPY	ETF	161.6	161.72	161.58	161.699	4290178.0
2013-05-03 12:30:00	SPY	ETF	161.6997	161.77	161.62	161.745	5502387.0
2013-05-03 13:00:00	SPY	ETF	161.74	161.8	161.58	161.59	7218455.0
2013-05-03 13:30:00	SPY	ETF	161.591	161.7	161.51	161.5171	5162792.0
2013-05-03 14:00:00	SPY	ETF	161.53	161.62	161.505	161.585	4043634.0
2013-05-03 14:30:00	SPY	ETF	161.58	161.6	161.33	161.415	6304956.0
2013-05-03 15:00:00	SPY	ETF	161.42	161.47	161.305	161.45	7695658.0
2013-05-03 15:30:00	SPY	ETF	161.45	161.67	161.36	161.38	20997565.0
2013-05-03 16:00:00	SPY	ETF	161.37	161.5691	159.782	161.37	12139949.0
2013-05-03 16:30:00	SPY	ETF	161.38	161.44	161.35	161.41	275891.0
2013-05-03 17:00:00	SPY	ETF	161.41	161.45	161.35	161.36	2662835.0
2013-05-03 17:30:00	SPY	ETF	161.38	161.42	161.38	161.42	105270.0
2013-05-03 18:00:00	SPY	ETF	161.42	161.57	161.42	161.51	81251.0
2013-05-03 18:30:00	SPY	ETF	161.5	161.5	161.3	161.3	82145.0
2013-05-03 19:00:00	SPY	ETF	161.3	161.31	161.22	161.31	46640.0
2013-05-03 19:30:00	SPY	ETF	161.3	161.33	161.29	161.3	12946.0
2013-05-03 05:00:00	QQQ	ETF	71.21	71.21	71.21	71.21	100.0
2013-05-03 05:30:00	QQQ	ETF	71.23	71.23	71.23	71.23	100.0
2013-05-03 06:30:00	QQQ	ETF	71.23	71.23	71.23	71.23	200.0
2013-05-03 07:00:00	QQQ	ETF	71.26	71.26	71.26	71.26	800.0
2013-05-03 07:30:00	QQQ	ETF	71.26	71.26	71.22	71.22	7200.0
2013-05-03 08:00:00	QQQ	ETF	71.26	71.29	71.22	71.28	109450.0
2013-05-03 08:30:00	QQQ	ETF	71.29	71.82	71.29	71.76	514312.0
2013-05-03 09:00:00	QQQ	ETF	71.77	71.98	71.77	71.95	395742.0
2013-05-03 09:30:00	QQQ	ETF	71.94	72.26	71.91	72.19	4833473.0
2013-05-03 10:00:00	QQQ	ETF	72.19	72.27	72.1	72.249	2355451.0
2013-05-03 10:30:00	QQQ	ETF	72.25	72.32	72.2161	72.23	2719477.0
2013-05-03 11:00:00	QQQ	ETF	72.24	72.2899	72.2	72.22	1709219.0
2013-05-03 11:30:00	QQQ	ETF	72.22	72.28	72.22	72.2201	1990851.0
2013-05-03 12:00:00	QQQ	ETF	72.222	72.26	72.2	72.25	1534132.0
2013-05-03 12:30:00	QQQ	ETF	72.25	72.27	72.21	72.27	917167.0
2013-05-03 13:00:00	QQQ	ETF	72.27	72.34	72.22	72.22	2675595.0
2013-05-03 13:30:00	QQQ	ETF	72.22	72.25	72.16	72.18	1410528.0
2013-05-03 14:00:00	QQQ	ETF	72.18	72.22	72.15	72.2196	1081910.0

> showing 50 of 10,890 rows — these rows as CSV

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