PREVIEW / etf_30min / 2017-07-11

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-07-11.parquet
  size:    423 KB
  rows:    14,751

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-07-11 04:00:00	SPY	ETF	242.15	242.15	242.15	242.15	150.0
2017-07-11 05:30:00	SPY	ETF	242.24	242.25	242.14	242.15	2983.0
2017-07-11 06:00:00	SPY	ETF	242.06	242.15	242.02	242.15	4907.0
2017-07-11 06:30:00	SPY	ETF	242.1	242.14	242.08	242.14	5525.0
2017-07-11 07:00:00	SPY	ETF	242.1	242.1	242.02	242.05	22049.0
2017-07-11 07:30:00	SPY	ETF	242.05	242.05	241.99	242.02	22106.0
2017-07-11 08:00:00	SPY	ETF	242.01	242.13	242.0	242.1	59542.0
2017-07-11 08:30:00	SPY	ETF	242.1	242.12	242.06	242.12	31006.0
2017-07-11 09:00:00	SPY	ETF	242.09	242.2	242.05	242.17	129644.0
2017-07-11 09:30:00	SPY	ETF	242.16	242.265	241.89	242.0211	3133819.0
2017-07-11 10:00:00	SPY	ETF	242.03	242.32	241.96	242.275	2515979.0
2017-07-11 10:30:00	SPY	ETF	242.28	242.4	242.25	242.37	2212234.0
2017-07-11 11:00:00	SPY	ETF	242.37	242.4	240.85	241.27	8773071.0
2017-07-11 11:30:00	SPY	ETF	241.27	241.9	241.2	241.81	5260606.0
2017-07-11 12:00:00	SPY	ETF	241.81	241.93	241.47	241.65	2222705.0
2017-07-11 12:30:00	SPY	ETF	241.65	241.95	241.57	241.82	1865147.0
2017-07-11 13:00:00	SPY	ETF	241.825	241.9001	241.69	241.71	864058.0
2017-07-11 13:30:00	SPY	ETF	241.72	242.2799	241.63	242.22	2132128.0
2017-07-11 14:00:00	SPY	ETF	242.23	242.375	242.06	242.23	3183691.0
2017-07-11 14:30:00	SPY	ETF	242.225	242.27	242.07	242.145	1678803.0
2017-07-11 15:00:00	SPY	ETF	242.15	242.36	242.04	242.27	2325727.0
2017-07-11 15:30:00	SPY	ETF	242.27	242.55	242.14	242.16	9166008.0
2017-07-11 16:00:00	SPY	ETF	242.17	242.33	242.1402	242.27	3651182.0
2017-07-11 16:30:00	SPY	ETF	242.28	242.35	242.19	242.35	425028.0
2017-07-11 17:00:00	SPY	ETF	242.34	242.36	242.3	242.3	33440.0
2017-07-11 17:30:00	SPY	ETF	242.33	242.35	242.32	242.32	25591.0
2017-07-11 18:00:00	SPY	ETF	242.31	242.39	242.3	242.37	24126.0
2017-07-11 18:30:00	SPY	ETF	242.37	242.42	242.32	242.42	30133.0
2017-07-11 19:00:00	SPY	ETF	242.42	242.48	242.38	242.38	17201.0
2017-07-11 19:30:00	SPY	ETF	242.38	242.39	242.33	242.35	33924.0
2017-07-11 04:00:00	QQQ	ETF	138.51	138.51	138.49	138.5	1298.0
2017-07-11 04:30:00	QQQ	ETF	138.53	138.53	138.53	138.53	600.0
2017-07-11 05:00:00	QQQ	ETF	138.45	138.55	138.45	138.55	2900.0
2017-07-11 05:30:00	QQQ	ETF	138.5	138.5	138.5	138.5	1200.0
2017-07-11 06:00:00	QQQ	ETF	138.43	138.43	138.4	138.42	1530.0
2017-07-11 06:30:00	QQQ	ETF	138.5	138.53	138.5	138.53	2500.0
2017-07-11 07:00:00	QQQ	ETF	138.53	138.53	138.43	138.43	25380.0
2017-07-11 07:30:00	QQQ	ETF	138.45	138.45	138.31	138.33	10582.0
2017-07-11 08:00:00	QQQ	ETF	138.35	138.41	138.32	138.32	70182.0
2017-07-11 08:30:00	QQQ	ETF	138.31	138.38	138.31	138.33	28945.0
2017-07-11 09:00:00	QQQ	ETF	138.3	138.47	138.23	138.44	70895.0
2017-07-11 09:30:00	QQQ	ETF	138.44	138.7	138.26	138.6768	2047514.0
2017-07-11 10:00:00	QQQ	ETF	138.68	139.13	138.57	139.04	1886553.0
2017-07-11 10:30:00	QQQ	ETF	139.05	139.15	138.9	138.94	1246916.0
2017-07-11 11:00:00	QQQ	ETF	138.94	139.0401	137.94	138.2799	3282336.0
2017-07-11 11:30:00	QQQ	ETF	138.27	138.72	138.2382	138.61	2640890.0
2017-07-11 12:00:00	QQQ	ETF	138.615	138.68	138.26	138.45	1190102.0
2017-07-11 12:30:00	QQQ	ETF	138.44	138.69	138.36	138.6	1305262.0
2017-07-11 13:00:00	QQQ	ETF	138.61	138.66	138.525	138.55	758223.0
2017-07-11 13:30:00	QQQ	ETF	138.555	138.96	138.52	138.94	1233898.0

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

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