PREVIEW / etf_30min / 2011-06-28

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-06-28.parquet
  size:    277 KB
  rows:    9,142

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-06-28 04:00:00	SPY	ETF	128.18	128.25	128.05	128.07	4100.0
2011-06-28 04:30:00	SPY	ETF	128.08	128.08	128.0	128.0	400.0
2011-06-28 05:00:00	SPY	ETF	127.89	127.95	127.81	127.85	1800.0
2011-06-28 05:30:00	SPY	ETF	127.85	127.87	127.75	127.75	15650.0
2011-06-28 06:00:00	SPY	ETF	127.8	127.93	127.8	127.88	8300.0
2011-06-28 06:30:00	SPY	ETF	127.88	127.95	127.77	127.83	8500.0
2011-06-28 07:00:00	SPY	ETF	127.87	127.89	127.61	127.67	104058.0
2011-06-28 07:30:00	SPY	ETF	127.7	128.09	127.7	127.94	546464.0
2011-06-28 08:00:00	SPY	ETF	127.94	128.29	127.78	128.19	710805.0
2011-06-28 08:30:00	SPY	ETF	128.2	128.7	128.2	128.61	1851843.0
2011-06-28 09:00:00	SPY	ETF	128.61	128.78	128.43	128.43	1575915.0
2011-06-28 09:30:00	SPY	ETF	128.45	128.83	128.27	128.71	21306938.0
2011-06-28 10:00:00	SPY	ETF	128.71	129.06	128.66	129.06	13644381.0
2011-06-28 10:30:00	SPY	ETF	129.06	129.23	128.98	128.98	13116832.0
2011-06-28 11:00:00	SPY	ETF	128.98	129.09	128.89	128.98	6540732.0
2011-06-28 11:30:00	SPY	ETF	128.99	129.14	128.95	129.08	6503895.0
2011-06-28 12:00:00	SPY	ETF	129.08	129.27	129.06	129.14	5883651.0
2011-06-28 12:30:00	SPY	ETF	129.13	129.29	129.09	129.23	5670024.0
2011-06-28 13:00:00	SPY	ETF	129.23	129.4	129.19	129.33	6697346.0
2011-06-28 13:30:00	SPY	ETF	129.33	129.39	129.16	129.33	8027596.0
2011-06-28 14:00:00	SPY	ETF	129.339	129.49	129.25	129.47	7465628.0
2011-06-28 14:30:00	SPY	ETF	129.48	129.605	129.4	129.48	10763544.0
2011-06-28 15:00:00	SPY	ETF	129.47	129.57	129.33	129.4	10804326.0
2011-06-28 15:30:00	SPY	ETF	129.4	129.63	129.27	129.6	23575551.0
2011-06-28 16:00:00	SPY	ETF	129.6	129.93	129.1518	129.6156	15043090.0
2011-06-28 16:30:00	SPY	ETF	129.79	129.88	127.9595	129.86	1698806.0
2011-06-28 17:00:00	SPY	ETF	129.86	129.94	129.81	129.93	171374.0
2011-06-28 17:30:00	SPY	ETF	129.84	129.93	129.84	129.9	53035.0
2011-06-28 18:00:00	SPY	ETF	129.88	129.89	129.61	129.78	217820.0
2011-06-28 18:30:00	SPY	ETF	129.79	129.84	129.76	129.76	21180.0
2011-06-28 19:00:00	SPY	ETF	129.76	129.77	129.73	129.76	61185.0
2011-06-28 19:30:00	SPY	ETF	129.77	129.92	129.74	129.92	66292.0
2011-06-28 04:00:00	QQQ	ETF	55.22	55.27	55.22	55.27	300.0
2011-06-28 05:00:00	QQQ	ETF	55.22	55.22	55.14	55.14	800.0
2011-06-28 06:00:00	QQQ	ETF	55.19	55.19	55.19	55.19	100.0
2011-06-28 06:30:00	QQQ	ETF	55.2	55.2	55.17	55.17	700.0
2011-06-28 07:00:00	QQQ	ETF	55.16	55.17	55.11	55.11	17075.0
2011-06-28 07:30:00	QQQ	ETF	55.13	55.27	55.13	55.25	21700.0
2011-06-28 08:00:00	QQQ	ETF	55.22	55.35	55.17	55.33	136597.0
2011-06-28 08:30:00	QQQ	ETF	55.33	55.51	55.33	55.46	182450.0
2011-06-28 09:00:00	QQQ	ETF	55.47	55.52	55.37	55.37	373418.0
2011-06-28 09:30:00	QQQ	ETF	55.37	55.64	55.29	55.56	6492023.0
2011-06-28 10:00:00	QQQ	ETF	55.5684	55.75	55.54	55.74	3602467.0
2011-06-28 10:30:00	QQQ	ETF	55.75	55.83	55.685	55.76	4171768.0
2011-06-28 11:00:00	QQQ	ETF	55.76	55.86	55.71	55.8	1962164.0
2011-06-28 11:30:00	QQQ	ETF	55.8	55.86	55.74	55.83	1477645.0
2011-06-28 12:00:00	QQQ	ETF	55.83	55.91	55.81	55.85	1311234.0
2011-06-28 12:30:00	QQQ	ETF	55.85	55.905	55.83	55.88	1286651.0
2011-06-28 13:00:00	QQQ	ETF	55.875	55.96	55.86	55.9	1842456.0
2011-06-28 13:30:00	QQQ	ETF	55.89	55.97	55.85	55.945	1603008.0

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

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