PREVIEW / etf_30min / 2014-08-14

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-08-14.parquet
  size:    331 KB
  rows:    11,314

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-08-14 04:00:00	SPY	ETF	194.9	194.93	194.86	194.93	1065.0
2014-08-14 04:30:00	SPY	ETF	195.01	195.01	194.96	194.96	700.0
2014-08-14 05:00:00	SPY	ETF	194.89	194.93	194.88	194.93	4716.0
2014-08-14 05:30:00	SPY	ETF	194.87	194.87	194.87	194.87	1800.0
2014-08-14 06:00:00	SPY	ETF	194.98	195.4	194.98	195.4	20641.0
2014-08-14 06:30:00	SPY	ETF	195.35	195.4	195.27	195.28	46025.0
2014-08-14 07:00:00	SPY	ETF	195.36	195.36	195.2	195.21	63343.0
2014-08-14 07:30:00	SPY	ETF	195.2	195.3	195.2	195.29	69363.0
2014-08-14 08:00:00	SPY	ETF	195.26	195.33	195.14	195.21	152253.0
2014-08-14 08:30:00	SPY	ETF	195.17	195.23	194.81	194.98	603689.0
2014-08-14 09:00:00	SPY	ETF	194.98	195.18	194.96	195.18	469388.0
2014-08-14 09:30:00	SPY	ETF	195.16	195.33	195.06	195.2	7767985.0
2014-08-14 10:00:00	SPY	ETF	195.21	195.36	194.98	195.32	6291574.0
2014-08-14 10:30:00	SPY	ETF	195.32	195.49	195.22	195.24	4024240.0
2014-08-14 11:00:00	SPY	ETF	195.25	195.55	195.23	195.415	3233148.0
2014-08-14 11:30:00	SPY	ETF	195.42	195.5	195.3	195.49	2731751.0
2014-08-14 12:00:00	SPY	ETF	195.49	195.52	195.38	195.42	2836976.0
2014-08-14 12:30:00	SPY	ETF	195.425	195.56	195.42	195.48	2349570.0
2014-08-14 13:00:00	SPY	ETF	195.49	195.72	195.4	195.5901	3459914.0
2014-08-14 13:30:00	SPY	ETF	195.595	195.61	195.42	195.48	2795842.0
2014-08-14 14:00:00	SPY	ETF	195.48	195.538	195.401	195.52	3356240.0
2014-08-14 14:30:00	SPY	ETF	195.53	195.61	195.5	195.55	2023928.0
2014-08-14 15:00:00	SPY	ETF	195.55	195.64	195.54	195.61	3104453.0
2014-08-14 15:30:00	SPY	ETF	195.61	195.75	195.57	195.74	6793462.0
2014-08-14 16:00:00	SPY	ETF	195.73	195.94	195.2433	195.88	3641111.0
2014-08-14 16:30:00	SPY	ETF	195.88	196.01	195.88	195.95	513029.0
2014-08-14 17:00:00	SPY	ETF	195.95	196.04	195.93	195.98	81781.0
2014-08-14 17:30:00	SPY	ETF	195.98	195.98	195.95	195.96	38322.0
2014-08-14 18:00:00	SPY	ETF	195.97	195.97	195.89	195.92	60723.0
2014-08-14 18:30:00	SPY	ETF	195.91	195.92	195.86	195.88	50298.0
2014-08-14 19:00:00	SPY	ETF	195.89	195.91	195.89	195.89	14039.0
2014-08-14 19:30:00	SPY	ETF	195.89	195.89	195.82	195.82	40559.0
2014-08-14 04:00:00	QQQ	ETF	96.35	96.38	96.26	96.38	10520.0
2014-08-14 04:30:00	QQQ	ETF	96.44	96.44	96.44	96.44	100.0
2014-08-14 05:00:00	QQQ	ETF	96.39	96.39	96.39	96.39	120.0
2014-08-14 05:30:00	QQQ	ETF	96.36	96.36	96.36	96.36	5000.0
2014-08-14 06:00:00	QQQ	ETF	96.5	96.67	96.48	96.67	17750.0
2014-08-14 06:30:00	QQQ	ETF	96.62	96.67	96.55	96.55	25700.0
2014-08-14 07:00:00	QQQ	ETF	96.56	96.59	96.55	96.56	8885.0
2014-08-14 07:30:00	QQQ	ETF	96.54	96.6	96.54	96.58	27684.0
2014-08-14 08:00:00	QQQ	ETF	96.58	96.61	96.51	96.54	62577.0
2014-08-14 08:30:00	QQQ	ETF	96.54	96.56	96.4	96.46	118126.0
2014-08-14 09:00:00	QQQ	ETF	96.48	96.56	96.48	96.55	184610.0
2014-08-14 09:30:00	QQQ	ETF	96.54	96.65	96.43	96.6	3560126.0
2014-08-14 10:00:00	QQQ	ETF	96.61	96.65	96.45	96.6299	2152358.0
2014-08-14 10:30:00	QQQ	ETF	96.63	96.69	96.54	96.63	1431156.0
2014-08-14 11:00:00	QQQ	ETF	96.625	96.74	96.61	96.67	1104872.0
2014-08-14 11:30:00	QQQ	ETF	96.67	96.73	96.6	96.7299	649138.0
2014-08-14 12:00:00	QQQ	ETF	96.73	96.75	96.65	96.68	750081.0
2014-08-14 12:30:00	QQQ	ETF	96.68	96.75	96.66	96.701	665506.0

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

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