PREVIEW / etf_30min / 2014-05-08

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-05-08.parquet
  size:    340 KB
  rows:    11,404

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-05-08 04:00:00	SPY	ETF	188.13	188.13	187.99	188.02	1236.0
2014-05-08 04:30:00	SPY	ETF	188.08	188.09	188.01	188.09	1127.0
2014-05-08 05:00:00	SPY	ETF	188.05	188.05	187.98	187.98	600.0
2014-05-08 05:30:00	SPY	ETF	188.02	188.15	187.98	188.03	8398.0
2014-05-08 06:00:00	SPY	ETF	187.99	188.06	187.94	188.01	3553.0
2014-05-08 06:30:00	SPY	ETF	188.02	188.05	188.0	188.0	3936.0
2014-05-08 07:00:00	SPY	ETF	188.03	188.2	188.01	188.1	36085.0
2014-05-08 07:30:00	SPY	ETF	188.08	188.13	187.71	187.8	160195.0
2014-05-08 08:00:00	SPY	ETF	187.75	188.14	187.62	187.67	360897.0
2014-05-08 08:30:00	SPY	ETF	187.66	187.89	187.39	187.64	962932.0
2014-05-08 09:00:00	SPY	ETF	187.65	187.72	187.48	187.68	603953.0
2014-05-08 09:30:00	SPY	ETF	187.67	188.65	187.54	188.55	12570942.0
2014-05-08 10:00:00	SPY	ETF	188.55	188.84	188.55	188.641	8884789.0
2014-05-08 10:30:00	SPY	ETF	188.65	188.7	188.38	188.5464	6006149.0
2014-05-08 11:00:00	SPY	ETF	188.55	188.83	188.48	188.73	3852007.0
2014-05-08 11:30:00	SPY	ETF	188.73	189.05	188.73	188.9299	4593760.0
2014-05-08 12:00:00	SPY	ETF	188.921	188.96	188.8	188.91	2467599.0
2014-05-08 12:30:00	SPY	ETF	188.91	188.96	188.54	188.62	3576976.0
2014-05-08 13:00:00	SPY	ETF	188.62	188.73	188.145	188.4	5754581.0
2014-05-08 13:30:00	SPY	ETF	188.41	188.51	188.12	188.27	4575390.0
2014-05-08 14:00:00	SPY	ETF	188.27	188.28	187.71	188.02	8695818.0
2014-05-08 14:30:00	SPY	ETF	188.02	188.0799	187.4	187.471	6879648.0
2014-05-08 15:00:00	SPY	ETF	187.48	187.73	187.08	187.69	11394665.0
2014-05-08 15:30:00	SPY	ETF	187.69	187.79	187.47	187.69	9177470.0
2014-05-08 16:00:00	SPY	ETF	187.69	188.7067	187.62	187.74	2251411.0
2014-05-08 16:30:00	SPY	ETF	187.74	187.8	187.59	187.6	296790.0
2014-05-08 17:00:00	SPY	ETF	187.61	187.63	187.56	187.6	37593.0
2014-05-08 17:30:00	SPY	ETF	187.6	187.6	187.58	187.6	8385.0
2014-05-08 18:00:00	SPY	ETF	187.58	187.58	187.41	187.43	31963.0
2014-05-08 18:30:00	SPY	ETF	187.43	187.52	187.42	187.52	45369.0
2014-05-08 19:00:00	SPY	ETF	187.53	187.53	187.47	187.47	5205.0
2014-05-08 19:30:00	SPY	ETF	187.51	187.56	187.49	187.53	47074.0
2014-05-08 05:30:00	QQQ	ETF	86.61	86.61	86.61	86.61	200.0
2014-05-08 06:00:00	QQQ	ETF	86.56	86.6	86.56	86.6	5400.0
2014-05-08 07:00:00	QQQ	ETF	86.57	86.66	86.57	86.65	3850.0
2014-05-08 07:30:00	QQQ	ETF	86.6	86.64	86.42	86.48	14200.0
2014-05-08 08:00:00	QQQ	ETF	86.48	86.48	86.29	86.32	66400.0
2014-05-08 08:30:00	QQQ	ETF	86.38	86.4	86.16	86.21	326782.0
2014-05-08 09:00:00	QQQ	ETF	86.25	86.27	86.06	86.25	174913.0
2014-05-08 09:30:00	QQQ	ETF	86.26	86.93	86.05	86.87	7513460.0
2014-05-08 10:00:00	QQQ	ETF	86.87	87.41	86.87	87.34	4609326.0
2014-05-08 10:30:00	QQQ	ETF	87.35	87.36	87.06	87.18	3804730.0
2014-05-08 11:00:00	QQQ	ETF	87.19	87.46	87.15	87.39	2551774.0
2014-05-08 11:30:00	QQQ	ETF	87.4	87.53	87.38	87.43	2078625.0
2014-05-08 12:00:00	QQQ	ETF	87.43	87.4701	87.38	87.4499	1978779.0
2014-05-08 12:30:00	QQQ	ETF	87.45	87.5	87.11	87.17	2043833.0
2014-05-08 13:00:00	QQQ	ETF	87.175	87.3	86.91	87.0256	2732565.0
2014-05-08 13:30:00	QQQ	ETF	87.03	87.08	86.82	86.86	1720356.0
2014-05-08 14:00:00	QQQ	ETF	86.87	86.88	86.5501	86.74	3516938.0
2014-05-08 14:30:00	QQQ	ETF	86.74	86.8	86.25	86.36	3397523.0

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

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