PREVIEW / etf_30min / 2012-07-06

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-07-06.parquet
  size:    278 KB
  rows:    9,235

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-07-06 04:00:00	SPY	ETF	136.69	136.69	136.69	136.69	1992.0
2012-07-06 04:30:00	SPY	ETF	136.68	136.7	136.59	136.7	10900.0
2012-07-06 05:00:00	SPY	ETF	136.54	136.54	136.5	136.5	6282.0
2012-07-06 05:30:00	SPY	ETF	136.47	136.5	136.41	136.45	8539.0
2012-07-06 06:00:00	SPY	ETF	136.46	136.46	136.46	136.46	135.0
2012-07-06 06:30:00	SPY	ETF	136.48	136.55	136.48	136.55	12439.0
2012-07-06 07:00:00	SPY	ETF	136.54	136.63	136.37	136.52	66110.0
2012-07-06 07:30:00	SPY	ETF	136.56	136.57	136.47	136.48	87911.0
2012-07-06 08:00:00	SPY	ETF	136.48	136.57	136.24	136.24	2063744.0
2012-07-06 08:30:00	SPY	ETF	136.24	136.24	135.57	135.67	5253248.0
2012-07-06 09:00:00	SPY	ETF	135.66	135.86	135.43	135.47	1797639.0
2012-07-06 09:30:00	SPY	ETF	135.47	135.77	135.37	135.59	16488774.0
2012-07-06 10:00:00	SPY	ETF	135.59	135.65	135.26	135.51	14333691.0
2012-07-06 10:30:00	SPY	ETF	135.515	135.58	135.22	135.2688	9751900.0
2012-07-06 11:00:00	SPY	ETF	135.27	135.41	135.08	135.0813	7056166.0
2012-07-06 11:30:00	SPY	ETF	135.08	135.25	135.02	135.06	9456978.0
2012-07-06 12:00:00	SPY	ETF	135.07	135.13	134.93	135.06	6750115.0
2012-07-06 12:30:00	SPY	ETF	135.06	135.33	135.03	135.32	6489032.0
2012-07-06 13:00:00	SPY	ETF	135.32	135.39	135.17	135.193	6248334.0
2012-07-06 13:30:00	SPY	ETF	135.19	135.2	134.98	135.051	4323727.0
2012-07-06 14:00:00	SPY	ETF	135.0531	135.06	134.85	134.93	5693716.0
2012-07-06 14:30:00	SPY	ETF	134.93	135.18	134.91	135.12	4836563.0
2012-07-06 15:00:00	SPY	ETF	135.11	135.48	135.06	135.479	8472332.0
2012-07-06 15:30:00	SPY	ETF	135.48	135.7	135.35	135.52	23090619.0
2012-07-06 16:00:00	SPY	ETF	135.52	136.8185	135.04	135.76	15820775.0
2012-07-06 16:30:00	SPY	ETF	135.77	136.03	135.76	135.91	1226605.0
2012-07-06 17:00:00	SPY	ETF	135.91	135.94	135.8	135.82	154445.0
2012-07-06 17:30:00	SPY	ETF	135.82	135.87	135.81	135.87	41790.0
2012-07-06 18:00:00	SPY	ETF	135.87	135.9	135.84	135.86	25800.0
2012-07-06 18:30:00	SPY	ETF	135.85	135.88	135.84	135.87	7700.0
2012-07-06 19:00:00	SPY	ETF	135.86	135.91	135.83	135.83	16196.0
2012-07-06 19:30:00	SPY	ETF	135.84	135.93	135.82	135.93	21830.0
2012-07-06 07:00:00	QQQ	ETF	64.84	64.88	64.81	64.87	10800.0
2012-07-06 07:30:00	QQQ	ETF	64.85	64.87	64.82	64.87	53200.0
2012-07-06 08:00:00	QQQ	ETF	64.86	64.87	64.78	64.78	43085.0
2012-07-06 08:30:00	QQQ	ETF	64.78	64.78	64.52	64.55	3567314.0
2012-07-06 09:00:00	QQQ	ETF	64.57	64.73	64.5693	64.65	3251262.0
2012-07-06 09:30:00	QQQ	ETF	64.65	64.69	64.16	64.301	5063090.0
2012-07-06 10:00:00	QQQ	ETF	64.3	64.3199	64.1	64.13	2588566.0
2012-07-06 10:30:00	QQQ	ETF	64.13	64.15	63.915	63.98	2828043.0
2012-07-06 11:00:00	QQQ	ETF	63.98	64.01	63.84	63.84	1611567.0
2012-07-06 11:30:00	QQQ	ETF	63.84	63.92	63.8	63.83	1366905.0
2012-07-06 12:00:00	QQQ	ETF	63.83	63.83	63.72	63.7574	1929668.0
2012-07-06 12:30:00	QQQ	ETF	63.75	63.88	63.74	63.88	1702304.0
2012-07-06 13:00:00	QQQ	ETF	63.8795	63.95	63.81	63.84	1179382.0
2012-07-06 13:30:00	QQQ	ETF	63.84	63.84	63.73	63.7682	837033.0
2012-07-06 14:00:00	QQQ	ETF	63.76	63.77	63.65	63.691	1145495.0
2012-07-06 14:30:00	QQQ	ETF	63.7	63.849	63.691	63.83	1118415.0
2012-07-06 15:00:00	QQQ	ETF	63.82	64.02	63.77	64.01	2543771.0
2012-07-06 15:30:00	QQQ	ETF	64.01	64.1	63.94	64.09	7045145.0

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

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