PREVIEW / etf_30min / 2011-09-13

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-09-13.parquet
  size:    277 KB
  rows:    9,381

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-09-13 04:00:00	SPY	ETF	116.0	116.1	115.2	115.5	25715.0
2011-09-13 04:30:00	SPY	ETF	115.38	115.64	115.19	115.64	3801.0
2011-09-13 05:00:00	SPY	ETF	115.8	115.84	115.52	115.65	26420.0
2011-09-13 05:30:00	SPY	ETF	115.86	115.99	115.39	115.39	31355.0
2011-09-13 06:00:00	SPY	ETF	115.4	115.54	115.18	115.39	32800.0
2011-09-13 06:30:00	SPY	ETF	115.36	116.0	115.36	115.69	100400.0
2011-09-13 07:00:00	SPY	ETF	115.77	116.58	115.77	116.52	1034453.0
2011-09-13 07:30:00	SPY	ETF	116.57	117.11	115.8	116.28	2384312.0
2011-09-13 08:00:00	SPY	ETF	116.27	116.858	115.85	116.31	3997951.0
2011-09-13 08:30:00	SPY	ETF	116.3	117.06	116.29	116.68	1593067.0
2011-09-13 09:00:00	SPY	ETF	116.67	117.16	116.45	117.05	3325437.0
2011-09-13 09:30:00	SPY	ETF	117.05	117.55	116.22	117.46	34490094.0
2011-09-13 10:00:00	SPY	ETF	117.46	117.96	117.35	117.49	29574504.0
2011-09-13 10:30:00	SPY	ETF	117.49	117.68	116.92	117.09	19490046.0
2011-09-13 11:00:00	SPY	ETF	117.1	117.27	116.55	116.85	14483439.0
2011-09-13 11:30:00	SPY	ETF	116.84	117.33	116.74	116.97	13870642.0
2011-09-13 12:00:00	SPY	ETF	116.9628	117.27	116.6	117.14	13236402.0
2011-09-13 12:30:00	SPY	ETF	117.13	117.43	116.96	117.32	8458512.0
2011-09-13 13:00:00	SPY	ETF	117.33	117.68	117.33	117.52	8912348.0
2011-09-13 13:30:00	SPY	ETF	117.51	117.93	117.32	117.73	13200409.0
2011-09-13 14:00:00	SPY	ETF	117.73	118.15	117.53	118.14	10986964.0
2011-09-13 14:30:00	SPY	ETF	118.14	118.18	117.45	117.66	21427458.0
2011-09-13 15:00:00	SPY	ETF	117.65	117.82	117.03	117.59	25044340.0
2011-09-13 15:30:00	SPY	ETF	117.6	118.08	117.56	117.74	29860741.0
2011-09-13 16:00:00	SPY	ETF	117.73	117.83	116.458	117.7	13149658.0
2011-09-13 16:30:00	SPY	ETF	117.71	117.71	117.35	117.54	995544.0
2011-09-13 17:00:00	SPY	ETF	117.52	117.65	117.42	117.61	129762.0
2011-09-13 17:30:00	SPY	ETF	117.58	117.69	117.55	117.63	92593.0
2011-09-13 18:00:00	SPY	ETF	117.63	117.63	117.28	117.3	194723.0
2011-09-13 18:30:00	SPY	ETF	117.32	117.59	117.32	117.54	83073.0
2011-09-13 19:00:00	SPY	ETF	117.55	117.58	117.53	117.54	40367.0
2011-09-13 19:30:00	SPY	ETF	117.56	117.56	117.21	117.3	107406.0
2011-09-13 04:00:00	QQQ	ETF	53.95	53.95	53.41	53.41	6843.0
2011-09-13 04:30:00	QQQ	ETF	53.34	53.45	53.34	53.45	2000.0
2011-09-13 05:00:00	QQQ	ETF	53.46	53.55	53.46	53.48	6200.0
2011-09-13 05:30:00	QQQ	ETF	53.49	53.49	53.49	53.49	500.0
2011-09-13 06:00:00	QQQ	ETF	53.42	53.45	53.42	53.45	1000.0
2011-09-13 06:30:00	QQQ	ETF	53.44	53.61	53.44	53.6	5400.0
2011-09-13 07:00:00	QQQ	ETF	53.59	53.94	53.59	53.94	90000.0
2011-09-13 07:30:00	QQQ	ETF	53.89	54.15	53.69	53.9	356472.0
2011-09-13 08:00:00	QQQ	ETF	53.86	53.9	53.54	53.8	659102.0
2011-09-13 08:30:00	QQQ	ETF	53.82	54.13	53.82	53.97	345992.0
2011-09-13 09:00:00	QQQ	ETF	53.96	54.12	53.85	54.08	317174.0
2011-09-13 09:30:00	QQQ	ETF	54.08	54.26	53.8	54.22	8611132.0
2011-09-13 10:00:00	QQQ	ETF	54.22	54.43	54.15	54.29	5402262.0
2011-09-13 10:30:00	QQQ	ETF	54.29	54.38	53.97	54.07	4168839.0
2011-09-13 11:00:00	QQQ	ETF	54.06	54.15	53.88	53.99	2987455.0
2011-09-13 11:30:00	QQQ	ETF	53.99	54.17	53.93	54.07	2391517.0
2011-09-13 12:00:00	QQQ	ETF	54.07	54.23	53.9	54.17	2656761.0
2011-09-13 12:30:00	QQQ	ETF	54.17	54.28	54.1	54.23	1583101.0

> showing 50 of 9,381 rows — these rows as CSV

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