PREVIEW / etf_30min / 2017-01-05

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-01-05.parquet
  size:    441 KB
  rows:    14,966

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
2017-01-05 04:00:00	SPY	ETF	226.3	226.36	226.1	226.36	11899.0
2017-01-05 04:30:00	SPY	ETF	226.38	226.44	226.35	226.44	10203.0
2017-01-05 05:00:00	SPY	ETF	226.42	226.46	226.23	226.25	9803.0
2017-01-05 05:30:00	SPY	ETF	226.23	226.42	226.15	226.42	8716.0
2017-01-05 06:00:00	SPY	ETF	226.4	226.4	226.3	226.3	12547.0
2017-01-05 06:30:00	SPY	ETF	226.31	226.39	226.29	226.35	21821.0
2017-01-05 07:00:00	SPY	ETF	226.36	226.37	226.02	226.05	79537.0
2017-01-05 07:30:00	SPY	ETF	226.04	226.08	225.98	226.02	47001.0
2017-01-05 08:00:00	SPY	ETF	226.03	226.37	226.01	226.15	2485207.0
2017-01-05 08:30:00	SPY	ETF	226.16	226.35	226.14	226.25	149897.0
2017-01-05 09:00:00	SPY	ETF	226.27	226.5238	226.15	226.27	437015.0
2017-01-05 09:30:00	SPY	ETF	226.27	226.55	226.11	226.36	5162389.0
2017-01-05 10:00:00	SPY	ETF	226.37	226.58	226.31	226.52	5551235.0
2017-01-05 10:30:00	SPY	ETF	226.51	226.54	226.18	226.34	4982424.0
2017-01-05 11:00:00	SPY	ETF	226.34	226.37	225.74	225.92	7140670.0
2017-01-05 11:30:00	SPY	ETF	225.92	225.98	225.48	225.69	5825156.0
2017-01-05 12:00:00	SPY	ETF	225.69	225.95	225.59	225.8942	3604224.0
2017-01-05 12:30:00	SPY	ETF	225.9	225.9901	225.77	225.93	3082703.0
2017-01-05 13:00:00	SPY	ETF	225.93	226.15	225.89	226.02	4218328.0
2017-01-05 13:30:00	SPY	ETF	226.01	226.09	225.93	226.02	3406515.0
2017-01-05 14:00:00	SPY	ETF	226.02	226.3	226.015	226.18	2794041.0
2017-01-05 14:30:00	SPY	ETF	226.17	226.21	226.01	226.01	1877715.0
2017-01-05 15:00:00	SPY	ETF	226.01	226.33	225.98	226.3	2459432.0
2017-01-05 15:30:00	SPY	ETF	226.29	226.49	226.2	226.36	7823035.0
2017-01-05 16:00:00	SPY	ETF	226.39	226.52	226.2929	226.45	10714571.0
2017-01-05 16:30:00	SPY	ETF	226.45	226.51	226.2472	226.51	202128.0
2017-01-05 17:00:00	SPY	ETF	226.5261	226.5261	226.45	226.45	537216.0
2017-01-05 17:30:00	SPY	ETF	226.46	226.47	226.44	226.45	6684.0
2017-01-05 18:00:00	SPY	ETF	226.45	226.5	226.45	226.49	41200.0
2017-01-05 18:30:00	SPY	ETF	226.52	226.52	226.41	226.43	16095.0
2017-01-05 19:00:00	SPY	ETF	226.41	226.41	226.38	226.4	9230.0
2017-01-05 19:30:00	SPY	ETF	226.4	226.44	226.34	226.43	15165.0
2017-01-05 04:00:00	QQQ	ETF	120.03	120.03	120.03	120.03	300.0
2017-01-05 06:30:00	QQQ	ETF	120.07	120.07	120.07	120.07	400.0
2017-01-05 07:00:00	QQQ	ETF	120.08	120.09	119.95	119.95	23840.0
2017-01-05 07:30:00	QQQ	ETF	119.92	119.94	119.87	119.91	9764.0
2017-01-05 08:00:00	QQQ	ETF	119.9	119.99	119.89	119.95	38565.0
2017-01-05 08:30:00	QQQ	ETF	120.0	120.1	120.0	120.07	6334.0
2017-01-05 09:00:00	QQQ	ETF	120.02	120.17	120.02	120.17	156105.0
2017-01-05 09:30:00	QQQ	ETF	120.16	120.78	120.1	120.65	2166856.0
2017-01-05 10:00:00	QQQ	ETF	120.66	120.82	120.55	120.725	1896100.0
2017-01-05 10:30:00	QQQ	ETF	120.72	120.74	120.52	120.6993	864368.0
2017-01-05 11:00:00	QQQ	ETF	120.69	120.75	120.35	120.515	1035730.0
2017-01-05 11:30:00	QQQ	ETF	120.51	120.58	120.3601	120.5657	949722.0
2017-01-05 12:00:00	QQQ	ETF	120.57	120.68	120.49	120.61	512672.0
2017-01-05 12:30:00	QQQ	ETF	120.61	120.72	120.55	120.68	413323.0
2017-01-05 13:00:00	QQQ	ETF	120.68	120.75	120.6422	120.6775	871688.0
2017-01-05 13:30:00	QQQ	ETF	120.68	120.73	120.63	120.65	623871.0
2017-01-05 14:00:00	QQQ	ETF	120.65	120.79	120.64	120.7399	869464.0
2017-01-05 14:30:00	QQQ	ETF	120.73	120.78	120.665	120.6953	752386.0

> showing 50 of 14,966 rows — these rows as CSV

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