PREVIEW / etf_30min / 2014-07-15

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-07-15.parquet
  size:    345 KB
  rows:    11,858

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-15 04:00:00	SPY	ETF	197.54	197.54	197.5	197.53	900.0
2014-07-15 04:30:00	SPY	ETF	197.52	197.54	197.5	197.52	1386.0
2014-07-15 05:00:00	SPY	ETF	197.47	197.47	197.28	197.28	690.0
2014-07-15 05:30:00	SPY	ETF	197.32	197.32	197.31	197.31	367.0
2014-07-15 06:00:00	SPY	ETF	197.33	197.33	197.3	197.33	3649.0
2014-07-15 06:30:00	SPY	ETF	197.29	197.37	197.21	197.37	13749.0
2014-07-15 07:00:00	SPY	ETF	197.36	197.65	197.34	197.64	88807.0
2014-07-15 07:30:00	SPY	ETF	197.62	197.8	197.62	197.67	221818.0
2014-07-15 08:00:00	SPY	ETF	197.67	197.78	197.57	197.71	149005.0
2014-07-15 08:30:00	SPY	ETF	197.73	197.92	197.7	197.78	486004.0
2014-07-15 09:00:00	SPY	ETF	197.78	197.79	197.63	197.72	218504.0
2014-07-15 09:30:00	SPY	ETF	197.72	198.1	197.62	197.73	10080929.0
2014-07-15 10:00:00	SPY	ETF	197.73	197.96	197.33	197.515	12692604.0
2014-07-15 10:30:00	SPY	ETF	197.52	197.63	196.71	197.07	13795246.0
2014-07-15 11:00:00	SPY	ETF	197.06	197.38	196.89	197.18	7198032.0
2014-07-15 11:30:00	SPY	ETF	197.18	197.18	196.5	196.56	7417995.0
2014-07-15 12:00:00	SPY	ETF	196.5599	196.91	196.36	196.8201	6922433.0
2014-07-15 12:30:00	SPY	ETF	196.8276	197.9714	196.8	196.91	3534540.0
2014-07-15 13:00:00	SPY	ETF	196.91	197.41	196.87	197.21	5063652.0
2014-07-15 13:30:00	SPY	ETF	197.22	197.35	197.125	197.16	3831157.0
2014-07-15 14:00:00	SPY	ETF	197.17	197.5	197.12	197.4223	9783737.0
2014-07-15 14:30:00	SPY	ETF	197.4226	197.44	197.27	197.42	3197664.0
2014-07-15 15:00:00	SPY	ETF	197.41	197.45	197.06	197.22	5787188.0
2014-07-15 15:30:00	SPY	ETF	197.22	197.31	197.12	197.23	9420334.0
2014-07-15 16:00:00	SPY	ETF	197.23	197.29	197.18	197.25	5336968.0
2014-07-15 16:30:00	SPY	ETF	197.24	197.32	197.23	197.29	583843.0
2014-07-15 17:00:00	SPY	ETF	197.29	197.37	197.28	197.35	47604.0
2014-07-15 17:30:00	SPY	ETF	197.32	197.33	197.29	197.32	10355.0
2014-07-15 18:00:00	SPY	ETF	197.3	197.3	197.16	197.21	25591.0
2014-07-15 18:30:00	SPY	ETF	197.22	197.28	197.21	197.28	12606.0
2014-07-15 19:00:00	SPY	ETF	197.26	197.32	197.26	197.32	3325.0
2014-07-15 19:30:00	SPY	ETF	197.29	197.29	197.26	197.26	7100.0
2014-07-15 05:30:00	QQQ	ETF	95.78	95.78	95.78	95.78	100.0
2014-07-15 06:30:00	QQQ	ETF	95.71	95.76	95.71	95.76	2200.0
2014-07-15 07:00:00	QQQ	ETF	95.82	95.89	95.82	95.89	800.0
2014-07-15 07:30:00	QQQ	ETF	95.92	95.98	95.92	95.93	30600.0
2014-07-15 08:00:00	QQQ	ETF	95.95	95.95	95.91	95.93	20925.0
2014-07-15 08:30:00	QQQ	ETF	95.96	96.03	95.95	95.96	127960.0
2014-07-15 09:00:00	QQQ	ETF	95.98	96.02	95.95	95.98	40236.0
2014-07-15 09:30:00	QQQ	ETF	95.98	96.13	95.85	95.9524	2928796.0
2014-07-15 10:00:00	QQQ	ETF	95.96	96.04	95.59	95.73	4259352.0
2014-07-15 10:30:00	QQQ	ETF	95.74	95.78	95.21	95.37	4761265.0
2014-07-15 11:00:00	QQQ	ETF	95.37	95.58	95.24	95.45	2429279.0
2014-07-15 11:30:00	QQQ	ETF	95.45	95.45	94.92	94.9463	2971551.0
2014-07-15 12:00:00	QQQ	ETF	94.95	95.2799	94.83	95.24	3038012.0
2014-07-15 12:30:00	QQQ	ETF	95.235	95.47	95.2	95.34	1899340.0
2014-07-15 13:00:00	QQQ	ETF	95.34	95.61	95.28	95.51	1836232.0
2014-07-15 13:30:00	QQQ	ETF	95.52	95.58	95.42	95.465	956492.0
2014-07-15 14:00:00	QQQ	ETF	95.46	95.67	95.42	95.6	1444701.0
2014-07-15 14:30:00	QQQ	ETF	95.59	95.61	95.48	95.56	1252796.0

> showing 50 of 11,858 rows — these rows as CSV

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