PREVIEW / etf_30min / 2016-06-08

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-06-08.parquet
  size:    389 KB
  rows:    13,319

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
2016-06-08 04:00:00	SPY	ETF	211.49	211.6	211.49	211.57	1507.0
2016-06-08 04:30:00	SPY	ETF	211.58	211.6	211.55	211.6	836.0
2016-06-08 05:00:00	SPY	ETF	211.66	211.73	211.66	211.69	1676.0
2016-06-08 05:30:00	SPY	ETF	211.74	211.74	211.7	211.7	704.0
2016-06-08 06:00:00	SPY	ETF	211.75	211.87	211.75	211.86	10513.0
2016-06-08 06:30:00	SPY	ETF	211.9	211.93	211.87	211.9	7330.0
2016-06-08 07:00:00	SPY	ETF	211.86	212.0	211.83	212.0	81697.0
2016-06-08 07:30:00	SPY	ETF	211.97	212.0	211.9	212.0	91371.0
2016-06-08 08:00:00	SPY	ETF	211.99	212.03	211.415	211.93	183733.0
2016-06-08 08:30:00	SPY	ETF	211.91	212.02	211.88	211.98	176829.0
2016-06-08 09:00:00	SPY	ETF	211.99	212.03	211.81	211.83	295790.0
2016-06-08 09:30:00	SPY	ETF	211.84	212.42	211.8	212.4	7466579.0
2016-06-08 10:00:00	SPY	ETF	212.39	212.42	211.76	211.97	6757129.0
2016-06-08 10:30:00	SPY	ETF	211.96	212.1701	211.85	211.94	3860649.0
2016-06-08 11:00:00	SPY	ETF	211.93	211.97	211.6899	211.87	4358514.0
2016-06-08 11:30:00	SPY	ETF	211.87	212.19	211.87	212.09	3253045.0
2016-06-08 12:00:00	SPY	ETF	212.095	212.3	212.08	212.25	2336516.0
2016-06-08 12:30:00	SPY	ETF	212.25	212.33	212.06	212.18	3884260.0
2016-06-08 13:00:00	SPY	ETF	212.19	212.25	212.02	212.03	1957664.0
2016-06-08 13:30:00	SPY	ETF	212.03	212.155	211.98	212.1392	1757237.0
2016-06-08 14:00:00	SPY	ETF	212.14	212.38	212.03	212.365	3409550.0
2016-06-08 14:30:00	SPY	ETF	212.37	212.52	212.325	212.41	4393674.0
2016-06-08 15:00:00	SPY	ETF	212.42	212.49	212.26	212.2825	4729943.0
2016-06-08 15:30:00	SPY	ETF	212.28	212.43	212.21	212.34	8508503.0
2016-06-08 16:00:00	SPY	ETF	212.34	212.39	212.1902	212.38	6774596.0
2016-06-08 16:30:00	SPY	ETF	212.37	212.37	212.3	212.31	156978.0
2016-06-08 17:00:00	SPY	ETF	212.3	212.36	212.28	212.3	85910.0
2016-06-08 17:30:00	SPY	ETF	212.3	212.33	212.27	212.33	13948.0
2016-06-08 18:00:00	SPY	ETF	212.33	212.37	212.33	212.36	34228.0
2016-06-08 18:30:00	SPY	ETF	212.36	212.38	212.27	212.31	24628.0
2016-06-08 19:00:00	SPY	ETF	212.31	212.31	212.27	212.29	4140.0
2016-06-08 19:30:00	SPY	ETF	212.31	212.31	212.24	212.27	33846.0
2016-06-08 05:30:00	QQQ	ETF	110.24	110.24	110.24	110.24	25000.0
2016-06-08 07:00:00	QQQ	ETF	110.31	110.34	110.28	110.34	1798.0
2016-06-08 07:30:00	QQQ	ETF	110.35	110.42	110.35	110.42	17290.0
2016-06-08 08:00:00	QQQ	ETF	110.41	110.43	110.38	110.38	73009.0
2016-06-08 08:30:00	QQQ	ETF	110.39	110.48	110.36	110.45	102044.0
2016-06-08 09:00:00	QQQ	ETF	110.46	110.47	110.36	110.36	153165.0
2016-06-08 09:30:00	QQQ	ETF	110.37	110.6	110.31	110.5593	1979187.0
2016-06-08 10:00:00	QQQ	ETF	110.555	110.56	109.96	110.1	2490480.0
2016-06-08 10:30:00	QQQ	ETF	110.1	110.2491	110.06	110.082	843957.0
2016-06-08 11:00:00	QQQ	ETF	110.081	110.27	110.01	110.23	1288660.0
2016-06-08 11:30:00	QQQ	ETF	110.23	110.43	110.23	110.31	928820.0
2016-06-08 12:00:00	QQQ	ETF	110.32	110.47	110.3	110.44	463685.0
2016-06-08 12:30:00	QQQ	ETF	110.44	110.49	110.3101	110.4101	324550.0
2016-06-08 13:00:00	QQQ	ETF	110.42	110.48	110.29	110.2901	531966.0
2016-06-08 13:30:00	QQQ	ETF	110.2934	110.35	110.28	110.33	375054.0
2016-06-08 14:00:00	QQQ	ETF	110.33	110.47	110.25	110.46	642206.0
2016-06-08 14:30:00	QQQ	ETF	110.47	110.53	110.43	110.46	735454.0
2016-06-08 15:00:00	QQQ	ETF	110.46	110.509	110.351	110.36	1002977.0

> showing 50 of 13,319 rows — these rows as CSV

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