PREVIEW / etf_30min / 2012-11-08

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-11-08.parquet
  size:    304 KB
  rows:    10,159

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-11-08 04:00:00	SPY	ETF	139.89	140.01	139.89	140.01	1900.0
2012-11-08 04:30:00	SPY	ETF	139.75	139.75	139.46	139.46	12260.0
2012-11-08 05:00:00	SPY	ETF	139.45	139.55	139.38	139.47	12300.0
2012-11-08 05:30:00	SPY	ETF	139.58	139.73	139.58	139.65	77025.0
2012-11-08 06:00:00	SPY	ETF	139.59	139.66	139.49	139.61	37100.0
2012-11-08 06:30:00	SPY	ETF	139.65	139.78	139.64	139.75	120957.0
2012-11-08 07:00:00	SPY	ETF	139.75	139.88	139.69	139.76	111839.0
2012-11-08 07:30:00	SPY	ETF	139.75	140.17	139.72	140.1	249332.0
2012-11-08 08:00:00	SPY	ETF	140.09	140.1	139.69	139.95	588402.0
2012-11-08 08:30:00	SPY	ETF	139.95	140.31	139.77	139.99	766957.0
2012-11-08 09:00:00	SPY	ETF	139.97	140.02	139.66	139.7	1151359.0
2012-11-08 09:30:00	SPY	ETF	139.7	140.41	139.69	140.12	13829211.0
2012-11-08 10:00:00	SPY	ETF	140.12	140.18	139.42	139.59	12096863.0
2012-11-08 10:30:00	SPY	ETF	139.6	139.84	139.27	139.4899	16684951.0
2012-11-08 11:00:00	SPY	ETF	139.49	139.63	139.2	139.48	13602654.0
2012-11-08 11:30:00	SPY	ETF	139.48	139.51	139.11	139.49	8307521.0
2012-11-08 12:00:00	SPY	ETF	139.485	139.485	139.05	139.215	9062525.0
2012-11-08 12:30:00	SPY	ETF	139.22	139.25	138.89	139.14	8668695.0
2012-11-08 13:00:00	SPY	ETF	139.14	139.2	138.39	138.54	9861239.0
2012-11-08 13:30:00	SPY	ETF	138.53	139.08	138.42	139.06	9871972.0
2012-11-08 14:00:00	SPY	ETF	139.06	139.07	138.68	138.75	8901848.0
2012-11-08 14:30:00	SPY	ETF	138.76	138.91	138.58	138.77	6387274.0
2012-11-08 15:00:00	SPY	ETF	138.76	138.88	138.65	138.725	12061201.0
2012-11-08 15:30:00	SPY	ETF	138.71	138.73	138.01	138.04	29274732.0
2012-11-08 16:00:00	SPY	ETF	138.04	139.78	137.92	138.23	8547308.0
2012-11-08 16:30:00	SPY	ETF	138.24	140.3	138.04	138.25	6581906.0
2012-11-08 17:00:00	SPY	ETF	138.25	138.295	138.04	138.27	940405.0
2012-11-08 17:30:00	SPY	ETF	138.28	139.4	138.22	138.3	76120.0
2012-11-08 18:00:00	SPY	ETF	138.28	138.31	138.22	138.29	57944.0
2012-11-08 18:30:00	SPY	ETF	138.31	138.32	138.29	138.3	4200.0
2012-11-08 19:00:00	SPY	ETF	138.3	138.3	138.23	138.24	25610.0
2012-11-08 19:30:00	SPY	ETF	138.21	138.28	138.18	138.28	77923.0
2012-11-08 04:30:00	QQQ	ETF	64.27	64.27	64.26	64.26	200.0
2012-11-08 05:00:00	QQQ	ETF	64.2	64.2	64.2	64.2	200.0
2012-11-08 07:00:00	QQQ	ETF	64.32	64.34	64.29	64.29	3747.0
2012-11-08 07:30:00	QQQ	ETF	64.3	64.44	64.3	64.4	45980.0
2012-11-08 08:00:00	QQQ	ETF	64.4	64.41	64.33	64.39	69480.0
2012-11-08 08:30:00	QQQ	ETF	64.38	64.41	64.31	64.38	316740.0
2012-11-08 09:00:00	QQQ	ETF	64.39	64.43	64.32	64.34	237138.0
2012-11-08 09:30:00	QQQ	ETF	64.33	64.495	64.19	64.4	4271634.0
2012-11-08 10:00:00	QQQ	ETF	64.39	64.435	63.91	64.02	4207819.0
2012-11-08 10:30:00	QQQ	ETF	64.03	64.16	63.87	64.02	3885394.0
2012-11-08 11:00:00	QQQ	ETF	64.03	64.1	63.8	63.9101	4118451.0
2012-11-08 11:30:00	QQQ	ETF	63.91	64.02	63.74	64.0101	3560741.0
2012-11-08 12:00:00	QQQ	ETF	64.01	64.01	63.73	63.76	2414759.0
2012-11-08 12:30:00	QQQ	ETF	63.753	63.79	63.62	63.75	2466856.0
2012-11-08 13:00:00	QQQ	ETF	63.75	63.779	63.43	63.49	2707174.0
2012-11-08 13:30:00	QQQ	ETF	63.49	63.73	63.44	63.7225	2140971.0
2012-11-08 14:00:00	QQQ	ETF	63.725	63.73	63.48	63.5	1776472.0
2012-11-08 14:30:00	QQQ	ETF	63.5	63.58	63.35	63.51	4098797.0

> showing 50 of 10,159 rows — these rows as CSV

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