PREVIEW / etf_30min / 2011-08-11

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-11.parquet
  size:    319 KB
  rows:    10,407

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
2011-08-11 04:00:00	SPY	ETF	114.45	115.0	114.45	114.74	12091.0
2011-08-11 04:30:00	SPY	ETF	115.05	115.15	114.86	114.9	4155.0
2011-08-11 05:00:00	SPY	ETF	114.82	114.9	114.45	114.81	9400.0
2011-08-11 05:30:00	SPY	ETF	114.65	114.65	113.69	113.69	77100.0
2011-08-11 06:00:00	SPY	ETF	113.64	114.07	113.16	113.9	116731.0
2011-08-11 06:30:00	SPY	ETF	113.9	114.25	113.51	114.06	168583.0
2011-08-11 07:00:00	SPY	ETF	114.1	114.15	111.76	112.78	1393162.0
2011-08-11 07:30:00	SPY	ETF	112.76	112.86	111.14	111.59	5274530.0
2011-08-11 08:00:00	SPY	ETF	111.59	113.7	110.89	111.09	8223835.0
2011-08-11 08:30:00	SPY	ETF	111.37	113.14	110.84	112.81	9429003.0
2011-08-11 09:00:00	SPY	ETF	112.81	113.93	112.51	113.25	11544165.0
2011-08-11 09:30:00	SPY	ETF	113.26	114.53	112.85	113.58	55671010.0
2011-08-11 10:00:00	SPY	ETF	113.59	115.14	113.47	114.64	39929115.0
2011-08-11 10:30:00	SPY	ETF	114.64	115.96	114.52	115.331	32807577.0
2011-08-11 11:00:00	SPY	ETF	115.3377	115.8	114.79	115.31	25355369.0
2011-08-11 11:30:00	SPY	ETF	115.31	115.78	114.85	115.34	17400294.0
2011-08-11 12:00:00	SPY	ETF	115.35	115.67	115.06	115.24	15023612.0
2011-08-11 12:30:00	SPY	ETF	115.24	117.01	115.2	116.83	21106600.0
2011-08-11 13:00:00	SPY	ETF	116.83	116.84	116.0	116.6	28814132.0
2011-08-11 13:30:00	SPY	ETF	116.6	116.87	115.9	116.66	16492739.0
2011-08-11 14:00:00	SPY	ETF	116.66	117.45	116.46	117.37	20229071.0
2011-08-11 14:30:00	SPY	ETF	117.37	117.62	116.7	117.47	21795984.0
2011-08-11 15:00:00	SPY	ETF	117.48	118.43	117.35	118.2	33205113.0
2011-08-11 15:30:00	SPY	ETF	118.2	118.92	117.13	117.33	76932177.0
2011-08-11 16:00:00	SPY	ETF	117.34	117.5229	116.99	117.42	16926772.0
2011-08-11 16:30:00	SPY	ETF	117.41	117.5229	112.3374	117.5	15251896.0
2011-08-11 17:00:00	SPY	ETF	117.47	117.5	116.96	117.23	8593602.0
2011-08-11 17:30:00	SPY	ETF	117.22	117.28	116.99	117.1	248729.0
2011-08-11 18:00:00	SPY	ETF	117.1	117.3	116.77	117.16	500651.0
2011-08-11 18:30:00	SPY	ETF	117.16	117.25	117.01	117.13	219208.0
2011-08-11 19:00:00	SPY	ETF	117.13	117.21	117.09	117.14	34359.0
2011-08-11 19:30:00	SPY	ETF	117.13	117.22	117.09	117.18	160015.0
2011-08-11 04:00:00	QQQ	ETF	51.88	52.2	51.88	52.04	2409.0
2011-08-11 04:30:00	QQQ	ETF	52.18	52.35	52.18	52.35	200.0
2011-08-11 05:00:00	QQQ	ETF	52.11	52.11	52.11	52.11	100.0
2011-08-11 06:00:00	QQQ	ETF	51.6	51.78	51.6	51.75	700.0
2011-08-11 06:30:00	QQQ	ETF	51.7	51.8	51.65	51.78	6200.0
2011-08-11 07:00:00	QQQ	ETF	51.79	51.88	51.4	51.4	43200.0
2011-08-11 07:30:00	QQQ	ETF	51.42	51.44	50.76	51.03	426373.0
2011-08-11 08:00:00	QQQ	ETF	51.59	51.59	50.6	50.72	2010252.0
2011-08-11 08:30:00	QQQ	ETF	50.82	51.53	50.62	51.43	1829640.0
2011-08-11 09:00:00	QQQ	ETF	51.42	51.81	51.26	51.56	3093751.0
2011-08-11 09:30:00	QQQ	ETF	51.57	52.06	51.34	51.71	17922542.0
2011-08-11 10:00:00	QQQ	ETF	51.73	52.47	51.6716	52.24	12644039.0
2011-08-11 10:30:00	QQQ	ETF	52.24	52.81	52.16	52.512	8940367.0
2011-08-11 11:00:00	QQQ	ETF	52.513	52.68	52.24	52.48	6147220.0
2011-08-11 11:30:00	QQQ	ETF	52.48	52.66	52.33	52.5119	4537291.0
2011-08-11 12:00:00	QQQ	ETF	52.52	52.61	52.32	52.4	5643820.0
2011-08-11 12:30:00	QQQ	ETF	52.4	53.12	52.383	53.05	7613225.0
2011-08-11 13:00:00	QQQ	ETF	53.05	53.06	52.75	52.96	8462247.0

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

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