PREVIEW / etf_30min / 2014-04-25

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-04-25.parquet
  size:    330 KB
  rows:    11,296

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-04-25 04:00:00	SPY	ETF	187.74	187.74	187.5	187.64	11744.0
2014-04-25 04:30:00	SPY	ETF	187.7	187.7	187.48	187.64	14148.0
2014-04-25 05:00:00	SPY	ETF	187.72	187.72	187.49	187.49	4527.0
2014-04-25 05:30:00	SPY	ETF	187.55	187.65	187.54	187.59	2358.0
2014-04-25 06:00:00	SPY	ETF	187.6	187.65	187.58	187.65	2129.0
2014-04-25 06:30:00	SPY	ETF	187.6	187.6	187.25	187.27	66125.0
2014-04-25 07:00:00	SPY	ETF	187.26	187.28	187.18	187.19	108526.0
2014-04-25 07:30:00	SPY	ETF	187.2	187.35	187.11	187.32	238058.0
2014-04-25 08:00:00	SPY	ETF	187.34	187.34	187.17	187.31	473971.0
2014-04-25 08:30:00	SPY	ETF	187.33	187.39	187.15	187.39	415623.0
2014-04-25 09:00:00	SPY	ETF	187.39	187.39	187.1	187.22	606364.0
2014-04-25 09:30:00	SPY	ETF	187.21	187.33	186.73	186.83	12816724.0
2014-04-25 10:00:00	SPY	ETF	186.82	187.12	186.64	186.83	9154023.0
2014-04-25 10:30:00	SPY	ETF	186.83	186.83	186.29	186.34	10230694.0
2014-04-25 11:00:00	SPY	ETF	186.34	186.58	186.06	186.57	7829033.0
2014-04-25 11:30:00	SPY	ETF	186.56	186.81	186.37	186.6579	6702379.0
2014-04-25 12:00:00	SPY	ETF	186.66	186.83	186.55	186.7	3542766.0
2014-04-25 12:30:00	SPY	ETF	186.71	186.74	186.44	186.52	3623627.0
2014-04-25 13:00:00	SPY	ETF	186.52	186.52	186.24	186.39	3758353.0
2014-04-25 13:30:00	SPY	ETF	186.39	186.485	186.17	186.36	3912215.0
2014-04-25 14:00:00	SPY	ETF	186.36	186.4	185.95	186.03	5360871.0
2014-04-25 14:30:00	SPY	ETF	186.025	186.33	185.87	186.13	5143129.0
2014-04-25 15:00:00	SPY	ETF	186.12	186.419	186.03	186.37	5595365.0
2014-04-25 15:30:00	SPY	ETF	186.38	186.59	186.2	186.31	13351534.0
2014-04-25 16:00:00	SPY	ETF	186.32	187.797	186.2696	186.57	4849428.0
2014-04-25 16:30:00	SPY	ETF	186.57	186.6	186.3	186.56	1574515.0
2014-04-25 17:00:00	SPY	ETF	186.55	186.62	186.51	186.51	99271.0
2014-04-25 17:30:00	SPY	ETF	186.52	186.52	186.45	186.49	50020.0
2014-04-25 18:00:00	SPY	ETF	186.5	186.55	186.5	186.53	7653.0
2014-04-25 18:30:00	SPY	ETF	186.55	186.56	186.5	186.54	16382.0
2014-04-25 19:00:00	SPY	ETF	186.54	186.56	186.54	186.54	4175.0
2014-04-25 19:30:00	SPY	ETF	186.54	186.6	186.54	186.59	27775.0
2014-04-25 04:30:00	QQQ	ETF	87.54	87.54	87.54	87.54	2500.0
2014-04-25 05:00:00	QQQ	ETF	87.52	87.52	87.48	87.48	600.0
2014-04-25 05:30:00	QQQ	ETF	87.5	87.51	87.5	87.51	10000.0
2014-04-25 06:30:00	QQQ	ETF	87.48	87.48	87.21	87.21	20980.0
2014-04-25 07:00:00	QQQ	ETF	87.21	87.3	87.2	87.25	15200.0
2014-04-25 07:30:00	QQQ	ETF	87.23	87.36	87.19	87.34	26100.0
2014-04-25 08:00:00	QQQ	ETF	87.31	87.35	87.18	87.21	104380.0
2014-04-25 08:30:00	QQQ	ETF	87.21	87.26	87.12	87.25	157631.0
2014-04-25 09:00:00	QQQ	ETF	87.24	87.25	87.01	87.06	165731.0
2014-04-25 09:30:00	QQQ	ETF	87.08	87.17	86.77	86.801	6301639.0
2014-04-25 10:00:00	QQQ	ETF	86.8	86.82	86.56	86.6	3693808.0
2014-04-25 10:30:00	QQQ	ETF	86.59	86.59	86.14	86.23	5616796.0
2014-04-25 11:00:00	QQQ	ETF	86.23	86.5	86.03	86.48	3734932.0
2014-04-25 11:30:00	QQQ	ETF	86.49	86.61	86.34	86.46	2712652.0
2014-04-25 12:00:00	QQQ	ETF	86.46	86.62	86.44	86.51	1166863.0
2014-04-25 12:30:00	QQQ	ETF	86.51	86.53	86.31	86.36	1442019.0
2014-04-25 13:00:00	QQQ	ETF	86.355	86.38	86.24	86.3	1203042.0
2014-04-25 13:30:00	QQQ	ETF	86.3	86.41	86.18	86.285	1481722.0

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

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