PREVIEW / etf_30min / 2014-06-05

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-06-05.parquet
  size:    342 KB
  rows:    11,573

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-06-05 04:00:00	SPY	ETF	193.06	193.19	193.06	193.15	587.0
2014-06-05 04:30:00	SPY	ETF	193.25	193.25	193.14	193.14	5613.0
2014-06-05 05:00:00	SPY	ETF	193.14	193.15	193.1	193.11	6300.0
2014-06-05 05:30:00	SPY	ETF	193.11	193.11	193.07	193.09	2632.0
2014-06-05 06:00:00	SPY	ETF	193.09	193.11	193.09	193.11	2319.0
2014-06-05 06:30:00	SPY	ETF	193.13	193.14	193.1	193.1	24432.0
2014-06-05 07:00:00	SPY	ETF	193.1	193.38	193.07	193.32	128426.0
2014-06-05 07:30:00	SPY	ETF	193.33	193.55	192.99	193.33	634479.0
2014-06-05 08:00:00	SPY	ETF	193.5	193.5	193.26	193.47	473408.0
2014-06-05 08:30:00	SPY	ETF	193.48	194.01	193.42	193.53	2709492.0
2014-06-05 09:00:00	SPY	ETF	193.54	193.68	193.19	193.41	1275501.0
2014-06-05 09:30:00	SPY	ETF	193.41	193.5595	193.0	193.3	12937006.0
2014-06-05 10:00:00	SPY	ETF	193.3	193.33	192.7	193.29	9836631.0
2014-06-05 10:30:00	SPY	ETF	193.29	193.48	193.11	193.41	4793623.0
2014-06-05 11:00:00	SPY	ETF	193.4	193.87	193.365	193.78	7829551.0
2014-06-05 11:30:00	SPY	ETF	193.77	194.22	193.76	194.197	7215578.0
2014-06-05 12:00:00	SPY	ETF	194.2	194.41	194.19	194.38	5412009.0
2014-06-05 12:30:00	SPY	ETF	194.37	194.59	194.37	194.39	4588155.0
2014-06-05 13:00:00	SPY	ETF	194.395	194.54	194.32	194.36	2659441.0
2014-06-05 13:30:00	SPY	ETF	194.36	194.44	194.27	194.427	2059152.0
2014-06-05 14:00:00	SPY	ETF	194.43	194.65	194.365	194.55	3415942.0
2014-06-05 14:30:00	SPY	ETF	194.55	194.61	194.37	194.38	3030733.0
2014-06-05 15:00:00	SPY	ETF	194.38	194.52	194.27	194.34	2996507.0
2014-06-05 15:30:00	SPY	ETF	194.335	194.525	194.28	194.45	9044734.0
2014-06-05 16:00:00	SPY	ETF	194.44	194.51	193.2387	194.41	4327699.0
2014-06-05 16:30:00	SPY	ETF	194.4	194.47	194.39	194.42	124124.0
2014-06-05 17:00:00	SPY	ETF	194.45	194.52	194.42	194.49	41607.0
2014-06-05 17:30:00	SPY	ETF	194.51	194.51	194.39	194.4	75605.0
2014-06-05 18:00:00	SPY	ETF	194.4	194.45	194.38	194.44	64795.0
2014-06-05 18:30:00	SPY	ETF	194.44	194.47	194.44	194.47	2100.0
2014-06-05 19:00:00	SPY	ETF	194.45	194.48	194.45	194.48	4275.0
2014-06-05 19:30:00	SPY	ETF	194.49	194.53	194.48	194.53	27165.0
2014-06-05 04:00:00	QQQ	ETF	91.58	91.58	91.58	91.58	100.0
2014-06-05 04:30:00	QQQ	ETF	91.5	91.5	91.5	91.5	2000.0
2014-06-05 05:00:00	QQQ	ETF	91.47	91.47	91.47	91.47	100.0
2014-06-05 06:30:00	QQQ	ETF	91.5	91.5	91.5	91.5	558.0
2014-06-05 07:00:00	QQQ	ETF	91.5	91.56	91.5	91.5	2842.0
2014-06-05 07:30:00	QQQ	ETF	91.56	91.7	91.47	91.55	123688.0
2014-06-05 08:00:00	QQQ	ETF	91.68	91.68	91.58	91.64	29456.0
2014-06-05 08:30:00	QQQ	ETF	91.65	91.85	91.63	91.64	352527.0
2014-06-05 09:00:00	QQQ	ETF	91.64	91.7	91.58	91.61	267893.0
2014-06-05 09:30:00	QQQ	ETF	91.61	91.8	91.45	91.64	7082551.0
2014-06-05 10:00:00	QQQ	ETF	91.63	91.66	91.29	91.66	3756089.0
2014-06-05 10:30:00	QQQ	ETF	91.66	91.75	91.5401	91.71	1636274.0
2014-06-05 11:00:00	QQQ	ETF	91.7	91.86	91.68	91.81	2034495.0
2014-06-05 11:30:00	QQQ	ETF	91.82	92.13	91.815	92.085	3741484.0
2014-06-05 12:00:00	QQQ	ETF	92.08	92.25	92.08	92.18	2008774.0
2014-06-05 12:30:00	QQQ	ETF	92.18	92.38	92.18	92.27	1557838.0
2014-06-05 13:00:00	QQQ	ETF	92.27	92.36	92.21	92.221	893795.0
2014-06-05 13:30:00	QQQ	ETF	92.23	92.29	92.155	92.26	1337192.0

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

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