PREVIEW / etf_30min / 2014-07-07

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-07-07.parquet
  size:    346 KB
  rows:    12,160

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
2014-07-07 04:00:00	SPY	ETF	197.95	198.08	197.85	197.95	8174.0
2014-07-07 04:30:00	SPY	ETF	197.88	197.91	197.84	197.9	12823.0
2014-07-07 05:00:00	SPY	ETF	197.88	197.95	197.88	197.95	454.0
2014-07-07 05:30:00	SPY	ETF	197.96	198.02	197.96	197.97	1400.0
2014-07-07 06:00:00	SPY	ETF	197.94	198.04	197.94	198.02	2243.0
2014-07-07 06:30:00	SPY	ETF	198.01	198.01	197.86	197.86	59079.0
2014-07-07 07:00:00	SPY	ETF	197.87	197.92	197.84	197.91	130411.0
2014-07-07 07:30:00	SPY	ETF	197.91	197.95	197.74	197.79	88410.0
2014-07-07 08:00:00	SPY	ETF	197.77	197.82	197.61	197.74	218238.0
2014-07-07 08:30:00	SPY	ETF	197.71	198.25	197.66	197.74	505000.0
2014-07-07 09:00:00	SPY	ETF	197.71	197.89	197.7	197.81	871193.0
2014-07-07 09:30:00	SPY	ETF	197.82	197.86	197.54	197.71	8750901.0
2014-07-07 10:00:00	SPY	ETF	197.71	197.98	197.61	197.87	5067630.0
2014-07-07 10:30:00	SPY	ETF	197.87	197.87	197.44	197.49	4123428.0
2014-07-07 11:00:00	SPY	ETF	197.49	197.55	197.37	197.44	4374036.0
2014-07-07 11:30:00	SPY	ETF	197.43	197.497	197.26	197.37	3153567.0
2014-07-07 12:00:00	SPY	ETF	197.37	197.59	197.34	197.46	2475275.0
2014-07-07 12:30:00	SPY	ETF	197.47	197.48	197.28	197.38	2359112.0
2014-07-07 13:00:00	SPY	ETF	197.38	197.48	197.35	197.43	2561417.0
2014-07-07 13:30:00	SPY	ETF	197.42	197.68	197.4	197.565	2305728.0
2014-07-07 14:00:00	SPY	ETF	197.57	197.62	197.44	197.45	2477147.0
2014-07-07 14:30:00	SPY	ETF	197.45	197.49	197.22	197.4	4083607.0
2014-07-07 15:00:00	SPY	ETF	197.4	197.48	197.31	197.41	2000128.0
2014-07-07 15:30:00	SPY	ETF	197.415	197.55	197.34	197.54	7563995.0
2014-07-07 16:00:00	SPY	ETF	197.53	197.61	197.5	197.6	3209601.0
2014-07-07 16:30:00	SPY	ETF	197.58	197.6	197.52	197.54	532367.0
2014-07-07 17:00:00	SPY	ETF	197.55	197.57	197.48	197.52	95332.0
2014-07-07 17:30:00	SPY	ETF	197.48	197.52	197.48	197.51	12290.0
2014-07-07 18:00:00	SPY	ETF	197.52	197.53	197.51	197.52	27174.0
2014-07-07 18:30:00	SPY	ETF	197.54	197.54	197.48	197.48	7525.0
2014-07-07 19:00:00	SPY	ETF	197.5	197.5	197.5	197.5	2100.0
2014-07-07 19:30:00	SPY	ETF	197.51	197.51	197.42	197.5	11898.0
2014-07-07 04:00:00	QQQ	ETF	95.64	95.64	95.53	95.53	1100.0
2014-07-07 04:30:00	QQQ	ETF	95.53	95.53	95.53	95.53	1700.0
2014-07-07 05:00:00	QQQ	ETF	95.57	95.57	95.57	95.57	2000.0
2014-07-07 06:00:00	QQQ	ETF	95.58	95.62	95.58	95.62	2100.0
2014-07-07 06:30:00	QQQ	ETF	95.6	95.6	95.52	95.54	1350.0
2014-07-07 07:00:00	QQQ	ETF	95.57	95.57	95.5	95.5	2300.0
2014-07-07 07:30:00	QQQ	ETF	95.52	95.54	95.47	95.51	12054.0
2014-07-07 08:00:00	QQQ	ETF	95.53	95.53	95.45	95.5	14080.0
2014-07-07 08:30:00	QQQ	ETF	95.48	95.52	95.45	95.51	14950.0
2014-07-07 09:00:00	QQQ	ETF	95.5	95.58	95.49	95.58	68135.0
2014-07-07 09:30:00	QQQ	ETF	95.59	95.62	95.49	95.6	2538391.0
2014-07-07 10:00:00	QQQ	ETF	95.6	95.71	95.545	95.68	1992643.0
2014-07-07 10:30:00	QQQ	ETF	95.68	95.68	95.392	95.455	2577186.0
2014-07-07 11:00:00	QQQ	ETF	95.45	95.47	95.35	95.4	2075186.0
2014-07-07 11:30:00	QQQ	ETF	95.41	95.45	95.28	95.3059	1124716.0
2014-07-07 12:00:00	QQQ	ETF	95.3	95.4	95.29	95.35	900604.0
2014-07-07 12:30:00	QQQ	ETF	95.35	95.36	95.26	95.35	962563.0
2014-07-07 13:00:00	QQQ	ETF	95.35	95.375	95.31	95.33	915728.0

> showing 50 of 12,160 rows — these rows as CSV

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