PREVIEW / etf_30min / 2011-08-22

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-22.parquet
  size:    294 KB
  rows:    9,935

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-22 04:00:00	SPY	ETF	113.5	114.02	113.5	113.72	4378.0
2011-08-22 04:30:00	SPY	ETF	113.77	113.93	113.75	113.93	13676.0
2011-08-22 05:00:00	SPY	ETF	114.0	114.08	113.9	113.9	3000.0
2011-08-22 05:30:00	SPY	ETF	113.93	114.0	113.8	113.8	2113.0
2011-08-22 06:00:00	SPY	ETF	113.67	114.03	113.62	114.0	32290.0
2011-08-22 06:30:00	SPY	ETF	114.08	114.24	113.9	114.13	29350.0
2011-08-22 07:00:00	SPY	ETF	114.13	114.45	114.08	114.42	259525.0
2011-08-22 07:30:00	SPY	ETF	114.43	114.85	114.34	114.73	1215441.0
2011-08-22 08:00:00	SPY	ETF	112.8	114.76	112.8	114.31	2003620.0
2011-08-22 08:30:00	SPY	ETF	114.32	114.89	114.32	114.76	2118297.0
2011-08-22 09:00:00	SPY	ETF	114.77	115.19	114.75	115.16	3503083.0
2011-08-22 09:30:00	SPY	ETF	115.17	115.23	114.08	114.17	29878421.0
2011-08-22 10:00:00	SPY	ETF	114.16	114.42	113.73	114.23	23368464.0
2011-08-22 10:30:00	SPY	ETF	114.23	114.41	113.41	113.43	17351874.0
2011-08-22 11:00:00	SPY	ETF	113.44	113.66	113.05	113.34	22398001.0
2011-08-22 11:30:00	SPY	ETF	113.34	113.44	112.46	112.7199	18047155.0
2011-08-22 12:00:00	SPY	ETF	112.7178	113.6	112.67	112.98	14043760.0
2011-08-22 12:30:00	SPY	ETF	112.98	113.78	112.67	113.75	13435111.0
2011-08-22 13:00:00	SPY	ETF	113.72	113.94	113.48	113.5299	13346666.0
2011-08-22 13:30:00	SPY	ETF	113.53	113.71	112.95	113.3401	11523666.0
2011-08-22 14:00:00	SPY	ETF	113.33	113.71	112.6847	113.3	17335115.0
2011-08-22 14:30:00	SPY	ETF	113.3	113.3	112.8	112.81	12158112.0
2011-08-22 15:00:00	SPY	ETF	112.82	113.35	112.76	113.18	17695690.0
2011-08-22 15:30:00	SPY	ETF	113.18	113.35	112.41	112.77	36260689.0
2011-08-22 16:00:00	SPY	ETF	112.76	113.03	112.67	112.87	7928340.0
2011-08-22 16:30:00	SPY	ETF	112.89	113.4654	112.8	112.88	5048621.0
2011-08-22 17:00:00	SPY	ETF	112.87	112.94	112.82	112.89	134546.0
2011-08-22 17:30:00	SPY	ETF	112.89	112.95	112.86	112.88	83125.0
2011-08-22 18:00:00	SPY	ETF	112.88	112.9	112.73	112.84	87708.0
2011-08-22 18:30:00	SPY	ETF	112.85	112.87	112.8	112.86	18017.0
2011-08-22 19:00:00	SPY	ETF	112.86	112.87	112.7	112.81	118490.0
2011-08-22 19:30:00	SPY	ETF	112.8	112.83	112.6	112.73	160642.0
2011-08-22 04:00:00	QQQ	ETF	50.67	50.76	50.6	50.76	1442.0
2011-08-22 04:30:00	QQQ	ETF	50.7	50.7	50.7	50.7	100.0
2011-08-22 05:00:00	QQQ	ETF	50.73	50.76	50.71	50.76	517.0
2011-08-22 05:30:00	QQQ	ETF	50.69	50.69	50.65	50.65	559.0
2011-08-22 06:00:00	QQQ	ETF	50.78	50.78	50.78	50.78	2000.0
2011-08-22 06:30:00	QQQ	ETF	50.78	50.84	50.72	50.84	2700.0
2011-08-22 07:00:00	QQQ	ETF	50.8	50.96	50.78	50.95	25120.0
2011-08-22 07:30:00	QQQ	ETF	50.97	51.13	50.94	51.11	186698.0
2011-08-22 08:00:00	QQQ	ETF	51.08	51.11	50.86	50.91	238282.0
2011-08-22 08:30:00	QQQ	ETF	50.92	51.14	50.92	51.1	223206.0
2011-08-22 09:00:00	QQQ	ETF	51.09	51.25	51.09	51.21	675033.0
2011-08-22 09:30:00	QQQ	ETF	51.21	51.24	50.78	50.82	7454481.0
2011-08-22 10:00:00	QQQ	ETF	50.82	51.04	50.6	50.97	7313103.0
2011-08-22 10:30:00	QQQ	ETF	50.98	51.08	50.54	50.55	4511719.0
2011-08-22 11:00:00	QQQ	ETF	50.55	50.65	50.27	50.41	5295511.0
2011-08-22 11:30:00	QQQ	ETF	50.4	50.48	50.06	50.14	7791791.0
2011-08-22 12:00:00	QQQ	ETF	50.13	50.54	50.1	50.39	5082712.0
2011-08-22 12:30:00	QQQ	ETF	50.381	50.74	50.2137	50.7	4499241.0

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

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