PREVIEW / etf_30min / 2012-07-27

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-07-27.parquet
  size:    296 KB
  rows:    9,727

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-27 04:00:00	SPY	ETF	136.12	136.18	136.12	136.18	450.0
2012-07-27 04:30:00	SPY	ETF	136.17	136.2	136.0	136.1	14544.0
2012-07-27 05:00:00	SPY	ETF	136.0	136.1	135.97	136.04	11600.0
2012-07-27 05:30:00	SPY	ETF	135.97	136.52	135.96	136.15	3965.0
2012-07-27 06:00:00	SPY	ETF	136.23	136.44	136.22	136.44	3443.0
2012-07-27 06:30:00	SPY	ETF	136.5	136.59	136.38	136.56	18695.0
2012-07-27 07:00:00	SPY	ETF	136.57	136.78	136.54	136.54	385261.0
2012-07-27 07:30:00	SPY	ETF	136.53	136.67	136.44	136.45	129145.0
2012-07-27 08:00:00	SPY	ETF	136.48	136.87	136.42	136.74	564006.0
2012-07-27 08:30:00	SPY	ETF	136.81	137.02	136.47	136.74	1894064.0
2012-07-27 09:00:00	SPY	ETF	136.74	137.09	136.72	136.89	2187626.0
2012-07-27 09:30:00	SPY	ETF	136.89	137.17	136.65	137.14	14282238.0
2012-07-27 10:00:00	SPY	ETF	137.14	137.34	137.03	137.07	15875293.0
2012-07-27 10:30:00	SPY	ETF	137.075	137.59	137.02	137.54	13155525.0
2012-07-27 11:00:00	SPY	ETF	137.55	137.72	137.51	137.59	11102383.0
2012-07-27 11:30:00	SPY	ETF	137.59	137.72	137.54	137.65	8027607.0
2012-07-27 12:00:00	SPY	ETF	137.66	137.78	137.58	137.778	4936302.0
2012-07-27 12:30:00	SPY	ETF	137.77	137.9	137.76	137.8	6252568.0
2012-07-27 13:00:00	SPY	ETF	137.8	138.49	137.78	138.48	13970306.0
2012-07-27 13:30:00	SPY	ETF	138.485	139.01	138.46	138.668	28098961.0
2012-07-27 14:00:00	SPY	ETF	138.67	138.78	138.39	138.47	18531366.0
2012-07-27 14:30:00	SPY	ETF	138.4625	138.78	138.409	138.7	11036746.0
2012-07-27 15:00:00	SPY	ETF	138.7	138.98	138.66	138.95	10211856.0
2012-07-27 15:30:00	SPY	ETF	138.96	139.07	138.57	138.7	31214639.0
2012-07-27 16:00:00	SPY	ETF	138.69	138.92	136.7798	138.87	27956845.0
2012-07-27 16:30:00	SPY	ETF	138.85	138.93	136.1364	138.88	10730122.0
2012-07-27 17:00:00	SPY	ETF	138.87	138.89	138.82	138.82	2039180.0
2012-07-27 17:30:00	SPY	ETF	138.82	138.82	138.74	138.8	58393.0
2012-07-27 18:00:00	SPY	ETF	138.81	138.81	138.75	138.75	16010.0
2012-07-27 18:30:00	SPY	ETF	138.74	138.75	138.68	138.72	29044.0
2012-07-27 19:00:00	SPY	ETF	138.72	138.74	138.72	138.74	9060.0
2012-07-27 19:30:00	SPY	ETF	138.72	138.74	138.68	138.72	25089.0
2012-07-27 04:00:00	QQQ	ETF	63.38	63.38	63.38	63.38	400.0
2012-07-27 04:30:00	QQQ	ETF	63.36	63.36	63.36	63.36	251.0
2012-07-27 05:00:00	QQQ	ETF	63.29	63.29	63.29	63.29	300.0
2012-07-27 06:00:00	QQQ	ETF	63.45	63.48	63.4	63.48	900.0
2012-07-27 06:30:00	QQQ	ETF	63.41	63.41	63.41	63.41	300.0
2012-07-27 07:00:00	QQQ	ETF	63.5	63.58	63.5	63.5	59750.0
2012-07-27 07:30:00	QQQ	ETF	63.48	63.51	63.48	63.49	17200.0
2012-07-27 08:00:00	QQQ	ETF	63.5	63.61	63.46	63.57	62140.0
2012-07-27 08:30:00	QQQ	ETF	63.56	63.73	63.51	63.63	127251.0
2012-07-27 09:00:00	QQQ	ETF	63.63	63.88	63.62	63.81	1647520.0
2012-07-27 09:30:00	QQQ	ETF	63.83	63.92	63.64	63.9	5466119.0
2012-07-27 10:00:00	QQQ	ETF	63.9	63.98	63.8	63.92	2463920.0
2012-07-27 10:30:00	QQQ	ETF	63.92	64.18	63.92	64.131	2137542.0
2012-07-27 11:00:00	QQQ	ETF	64.1399	64.29	64.12	64.18	3313512.0
2012-07-27 11:30:00	QQQ	ETF	64.18	64.3	64.15	64.28	1777439.0
2012-07-27 12:00:00	QQQ	ETF	64.28	64.34	64.22	64.34	1355786.0
2012-07-27 12:30:00	QQQ	ETF	64.34	64.43	64.33	64.3899	1714850.0
2012-07-27 13:00:00	QQQ	ETF	64.39	64.7	64.36	64.7	2751745.0

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

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