PREVIEW / etf_30min / 2015-11-04

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-11-04.parquet
  size:    382 KB
  rows:    12,911

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
2015-11-04 04:00:00	SPY	ETF	211.27	211.4	211.21	211.21	3090.0
2015-11-04 04:30:00	SPY	ETF	211.11	211.21	211.1	211.21	1225.0
2015-11-04 05:00:00	SPY	ETF	211.06	211.06	210.9	210.94	4055.0
2015-11-04 05:30:00	SPY	ETF	210.99	211.13	210.99	211.07	5236.0
2015-11-04 06:00:00	SPY	ETF	211.07	211.26	211.07	211.26	15211.0
2015-11-04 06:30:00	SPY	ETF	211.2	211.26	211.13	211.15	30700.0
2015-11-04 07:00:00	SPY	ETF	211.2	211.34	211.17	211.23	70627.0
2015-11-04 07:30:00	SPY	ETF	211.24	211.35	211.2	211.35	67933.0
2015-11-04 08:00:00	SPY	ETF	211.11	211.51	209.95	211.43	391424.0
2015-11-04 08:30:00	SPY	ETF	211.45	211.63	211.35	211.56	242870.0
2015-11-04 09:00:00	SPY	ETF	211.5535	211.5535	211.25	211.36	544161.0
2015-11-04 09:30:00	SPY	ETF	211.35	211.5	210.41	210.669	12577170.0
2015-11-04 10:00:00	SPY	ETF	210.67	211.02	210.35	210.93	10299198.0
2015-11-04 10:30:00	SPY	ETF	210.94	211.17	210.46	210.5299	8662736.0
2015-11-04 11:00:00	SPY	ETF	210.53	210.53	210.06	210.2	7387064.0
2015-11-04 11:30:00	SPY	ETF	210.19	210.4263	210.01	210.251	4995777.0
2015-11-04 12:00:00	SPY	ETF	210.25	210.7	210.141	210.45	3752250.0
2015-11-04 12:30:00	SPY	ETF	210.44	210.52	210.12	210.34	3182481.0
2015-11-04 13:00:00	SPY	ETF	210.34	210.37	209.7201	209.98	6152795.0
2015-11-04 13:30:00	SPY	ETF	209.99	210.15	209.87	210.109	5481276.0
2015-11-04 14:00:00	SPY	ETF	210.1	210.45	210.03	210.28	4310516.0
2015-11-04 14:30:00	SPY	ETF	210.28	210.66	210.265	210.43	4505878.0
2015-11-04 15:00:00	SPY	ETF	210.43	210.48	210.05	210.29	4455432.0
2015-11-04 15:30:00	SPY	ETF	210.28	210.38	209.95	210.38	10877045.0
2015-11-04 16:00:00	SPY	ETF	210.35	210.4	209.8667	210.18	6927924.0
2015-11-04 16:30:00	SPY	ETF	210.19	210.36	210.19	210.28	278851.0
2015-11-04 17:00:00	SPY	ETF	210.27	210.33	210.2	210.28	71573.0
2015-11-04 17:30:00	SPY	ETF	210.33	210.34	210.23	210.23	62600.0
2015-11-04 18:00:00	SPY	ETF	210.21	210.36	210.04	210.08	421641.0
2015-11-04 18:30:00	SPY	ETF	210.06	210.06	209.98	210.02	15459.0
2015-11-04 19:00:00	SPY	ETF	210.02	210.13	209.98	210.06	22442.0
2015-11-04 19:30:00	SPY	ETF	210.03	210.1	209.99	210.08	43557.0
2015-11-04 04:00:00	QQQ	ETF	115.3	115.3	115.28	115.28	7100.0
2015-11-04 04:30:00	QQQ	ETF	115.22	115.23	115.22	115.23	300.0
2015-11-04 05:00:00	QQQ	ETF	115.17	115.18	115.12	115.18	1300.0
2015-11-04 05:30:00	QQQ	ETF	115.2	115.21	115.2	115.21	1100.0
2015-11-04 06:00:00	QQQ	ETF	115.26	115.31	115.26	115.3	600.0
2015-11-04 06:30:00	QQQ	ETF	115.29	115.31	115.27	115.27	15500.0
2015-11-04 07:00:00	QQQ	ETF	115.3	115.36	115.3	115.31	7375.0
2015-11-04 07:30:00	QQQ	ETF	115.33	115.36	115.33	115.36	10100.0
2015-11-04 08:00:00	QQQ	ETF	115.36	115.41	115.01	115.4	35670.0
2015-11-04 08:30:00	QQQ	ETF	115.41	115.48	115.38	115.46	32293.0
2015-11-04 09:00:00	QQQ	ETF	115.46	115.46	115.33	115.38	140626.0
2015-11-04 09:30:00	QQQ	ETF	115.39	115.47	114.9065	115.0046	5318378.0
2015-11-04 10:00:00	QQQ	ETF	115.01	115.17	114.83	115.13	4073049.0
2015-11-04 10:30:00	QQQ	ETF	115.15	115.26	114.756	114.76	2284944.0
2015-11-04 11:00:00	QQQ	ETF	114.7672	114.8589	114.54	114.69	2134165.0
2015-11-04 11:30:00	QQQ	ETF	114.68	114.9162	114.64	114.8	1371214.0
2015-11-04 12:00:00	QQQ	ETF	114.8	115.093	114.73	115.005	1062346.0
2015-11-04 12:30:00	QQQ	ETF	115.0	115.05	114.84	114.95	734143.0

> showing 50 of 12,911 rows — these rows as CSV

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