PREVIEW / etf_30min / 2011-08-08

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-08.parquet
  size:    347 KB
  rows:    11,541

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-08 04:00:00	SPY	ETF	118.1	118.77	118.1	118.45	25431.0
2011-08-08 04:30:00	SPY	ETF	118.49	118.55	117.78	117.78	6700.0
2011-08-08 05:00:00	SPY	ETF	117.85	118.08	116.98	117.42	35060.0
2011-08-08 05:30:00	SPY	ETF	117.45	117.7	117.0	117.34	78400.0
2011-08-08 06:00:00	SPY	ETF	117.34	117.47	116.84	117.1	107905.0
2011-08-08 06:30:00	SPY	ETF	117.17	117.91	117.17	117.28	244682.0
2011-08-08 07:00:00	SPY	ETF	117.32	118.01	117.17	117.74	2593448.0
2011-08-08 07:30:00	SPY	ETF	117.74	117.85	117.3	117.8	980037.0
2011-08-08 08:00:00	SPY	ETF	117.8	119.216	116.76	117.86	4940028.0
2011-08-08 08:30:00	SPY	ETF	117.85	119.216	117.02	117.1	3676964.0
2011-08-08 09:00:00	SPY	ETF	117.11	120.12	116.89	116.92	8023628.0
2011-08-08 09:30:00	SPY	ETF	116.91	118.35	116.74	117.56	63709684.0
2011-08-08 10:00:00	SPY	ETF	117.56	117.83	115.64	115.79	50388187.0
2011-08-08 10:30:00	SPY	ETF	115.79	116.48	115.27	115.8101	54465505.0
2011-08-08 11:00:00	SPY	ETF	115.81	117.33	115.5333	116.4015	42475063.0
2011-08-08 11:30:00	SPY	ETF	116.42	116.65	115.97	116.31	26039947.0
2011-08-08 12:00:00	SPY	ETF	116.31	116.31	115.45	115.55	21196354.0
2011-08-08 12:30:00	SPY	ETF	115.55	120.1218	115.39	115.61	22239524.0
2011-08-08 13:00:00	SPY	ETF	115.61	116.01	115.02	115.5	25156810.0
2011-08-08 13:30:00	SPY	ETF	115.5	115.57	114.08	114.13	39888985.0
2011-08-08 14:00:00	SPY	ETF	114.13	114.84	112.02	113.19	64317127.0
2011-08-08 14:30:00	SPY	ETF	113.19	114.04	112.9	113.19	45422940.0
2011-08-08 15:00:00	SPY	ETF	113.18	115.47	113.12	114.05	62307843.0
2011-08-08 15:30:00	SPY	ETF	114.05	114.22	112.25	112.28	86361046.0
2011-08-08 16:00:00	SPY	ETF	112.22	117.45	111.48	111.75	22444151.0
2011-08-08 16:30:00	SPY	ETF	111.75	115.1238	111.65	111.88	15959897.0
2011-08-08 17:00:00	SPY	ETF	111.88	120.1218	111.55	111.56	22411026.0
2011-08-08 17:30:00	SPY	ETF	111.57	120.1218	111.25	111.58	9862864.0
2011-08-08 18:00:00	SPY	ETF	111.55	112.26	110.6	110.91	1181692.0
2011-08-08 18:30:00	SPY	ETF	110.91	111.09	110.6	110.72	250792.0
2011-08-08 19:00:00	SPY	ETF	110.78	111.23	110.77	111.2	350840.0
2011-08-08 19:30:00	SPY	ETF	111.22	111.23	110.93	111.15	238441.0
2011-08-08 04:00:00	QQQ	ETF	53.36	53.36	52.8	52.8	1250.0
2011-08-08 04:30:00	QQQ	ETF	52.82	52.82	52.66	52.66	6200.0
2011-08-08 05:00:00	QQQ	ETF	52.55	52.55	52.3	52.3	2000.0
2011-08-08 05:30:00	QQQ	ETF	52.49	52.5	52.3	52.34	10500.0
2011-08-08 06:00:00	QQQ	ETF	52.38	52.41	52.18	52.28	6120.0
2011-08-08 06:30:00	QQQ	ETF	52.29	52.5	52.29	52.3	9100.0
2011-08-08 07:00:00	QQQ	ETF	52.42	52.7	52.35	52.59	259440.0
2011-08-08 07:30:00	QQQ	ETF	52.58	52.63	52.41	52.63	217238.0
2011-08-08 08:00:00	QQQ	ETF	52.39	52.75	52.39	52.64	2158995.0
2011-08-08 08:30:00	QQQ	ETF	52.62	52.68	52.35	52.38	486761.0
2011-08-08 09:00:00	QQQ	ETF	52.38	52.59	52.2	52.21	2699006.0
2011-08-08 09:30:00	QQQ	ETF	52.21	53.12	52.18	52.69	24513896.0
2011-08-08 10:00:00	QQQ	ETF	52.7	52.78	51.7	51.77	19141145.0
2011-08-08 10:30:00	QQQ	ETF	51.77	52.2378	51.57	51.92	19095261.0
2011-08-08 11:00:00	QQQ	ETF	51.92	52.62	51.82	52.25	12390894.0
2011-08-08 11:30:00	QQQ	ETF	52.25	52.37	52.01	52.2107	11160180.0
2011-08-08 12:00:00	QQQ	ETF	52.21	52.22	51.84	51.91	6796042.0
2011-08-08 12:30:00	QQQ	ETF	51.917	52.21	51.86	52.01	4888946.0

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

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