PREVIEW / etf_30min / 2012-03-09

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-03-09.parquet
  size:    282 KB
  rows:    9,464

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
2012-03-09 04:00:00	SPY	ETF	137.0	137.06	137.0	137.06	5445.0
2012-03-09 04:30:00	SPY	ETF	137.0	137.0	136.95	136.95	200.0
2012-03-09 05:00:00	SPY	ETF	136.97	136.97	136.9	136.92	11300.0
2012-03-09 05:30:00	SPY	ETF	137.03	137.03	137.01	137.01	4100.0
2012-03-09 06:00:00	SPY	ETF	136.96	136.99	136.92	136.98	5245.0
2012-03-09 06:30:00	SPY	ETF	137.05	137.09	137.02	137.09	6674.0
2012-03-09 07:00:00	SPY	ETF	137.07	137.12	137.03	137.08	277064.0
2012-03-09 07:30:00	SPY	ETF	137.09	137.1	136.98	137.06	109925.0
2012-03-09 08:00:00	SPY	ETF	137.06	137.29	137.02	137.26	818472.0
2012-03-09 08:30:00	SPY	ETF	137.27	137.74	137.2	137.46	5060791.0
2012-03-09 09:00:00	SPY	ETF	137.45	137.45	137.25	137.31	851362.0
2012-03-09 09:30:00	SPY	ETF	137.3	137.52	137.13	137.235	13732601.0
2012-03-09 10:00:00	SPY	ETF	137.24	137.72	137.21	137.68	12939182.0
2012-03-09 10:30:00	SPY	ETF	137.69	137.93	137.68	137.86	12918756.0
2012-03-09 11:00:00	SPY	ETF	137.86	137.9	137.75	137.76	6455796.0
2012-03-09 11:30:00	SPY	ETF	137.75	137.87	137.69	137.8401	4959230.0
2012-03-09 12:00:00	SPY	ETF	137.85	137.87	137.73	137.8	2896031.0
2012-03-09 12:30:00	SPY	ETF	137.79	137.84	137.72	137.8	3393293.0
2012-03-09 13:00:00	SPY	ETF	137.79	137.89	137.73	137.76	3406756.0
2012-03-09 13:30:00	SPY	ETF	137.765	137.88	137.76	137.84	2913002.0
2012-03-09 14:00:00	SPY	ETF	137.86	137.9	137.75	137.76	2919221.0
2012-03-09 14:30:00	SPY	ETF	137.76	137.88	137.35	137.47	12652662.0
2012-03-09 15:00:00	SPY	ETF	137.47	137.63	137.45	137.54	7805787.0
2012-03-09 15:30:00	SPY	ETF	137.535	137.62	137.35	137.56	17022450.0
2012-03-09 16:00:00	SPY	ETF	137.56	137.78	137.25	137.71	7485406.0
2012-03-09 16:30:00	SPY	ETF	137.71	137.758	137.64	137.68	3502472.0
2012-03-09 17:00:00	SPY	ETF	137.67	137.71	137.64	137.65	103693.0
2012-03-09 17:30:00	SPY	ETF	137.64	137.67	137.57	137.65	97737.0
2012-03-09 18:00:00	SPY	ETF	137.66	137.67	137.59	137.67	6937.0
2012-03-09 18:30:00	SPY	ETF	137.67	137.69	137.64	137.68	8800.0
2012-03-09 19:00:00	SPY	ETF	137.69	137.69	137.66	137.66	4949.0
2012-03-09 19:30:00	SPY	ETF	137.66	137.7	137.65	137.7	7113.0
2012-03-09 06:30:00	QQQ	ETF	64.75	64.75	64.75	64.75	100.0
2012-03-09 07:00:00	QQQ	ETF	64.75	64.78	64.75	64.78	7456.0
2012-03-09 07:30:00	QQQ	ETF	64.74	64.79	64.72	64.76	14970.0
2012-03-09 08:00:00	QQQ	ETF	64.76	64.83	64.75	64.82	111815.0
2012-03-09 08:30:00	QQQ	ETF	64.86	64.99	64.78	64.91	602672.0
2012-03-09 09:00:00	QQQ	ETF	64.9	64.9	64.8	64.84	163984.0
2012-03-09 09:30:00	QQQ	ETF	64.83	65.03	64.82	64.84	4925492.0
2012-03-09 10:00:00	QQQ	ETF	64.8387	65.005	64.83	64.9932	5041861.0
2012-03-09 10:30:00	QQQ	ETF	65.0	65.09	64.9801	65.06	4120022.0
2012-03-09 11:00:00	QQQ	ETF	65.06	65.069	64.99	65.0021	1652635.0
2012-03-09 11:30:00	QQQ	ETF	65.005	65.07	64.99	65.048	1464748.0
2012-03-09 12:00:00	QQQ	ETF	65.045	65.07	65.0	65.05	1201030.0
2012-03-09 12:30:00	QQQ	ETF	65.055	65.07	65.03	65.0586	631793.0
2012-03-09 13:00:00	QQQ	ETF	65.05	65.12	65.0216	65.0401	2117785.0
2012-03-09 13:30:00	QQQ	ETF	65.05	65.11	65.03	65.09	1553151.0
2012-03-09 14:00:00	QQQ	ETF	65.0938	65.1	65.06	65.08	1670898.0
2012-03-09 14:30:00	QQQ	ETF	65.09	65.14	64.93	64.97	4759236.0
2012-03-09 15:00:00	QQQ	ETF	64.97	65.04	64.92	64.97	2541269.0

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

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