PREVIEW / etf_30min / 2017-10-25

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-10-25.parquet
  size:    458 KB
  rows:    15,679

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-10-25 04:00:00	SPY	ETF	256.25	256.25	256.15	256.15	800.0
2017-10-25 04:30:00	SPY	ETF	256.17	256.17	256.13	256.17	400.0
2017-10-25 05:00:00	SPY	ETF	256.2	256.2	256.05	256.05	320.0
2017-10-25 05:30:00	SPY	ETF	256.18	256.18	256.18	256.18	306.0
2017-10-25 06:00:00	SPY	ETF	256.19	256.35	256.19	256.35	3006.0
2017-10-25 06:30:00	SPY	ETF	256.3	256.3	256.25	256.29	2005.0
2017-10-25 07:00:00	SPY	ETF	256.34	256.44	256.15	256.18	18142.0
2017-10-25 07:30:00	SPY	ETF	256.2	256.22	256.08	256.15	36953.0
2017-10-25 08:00:00	SPY	ETF	256.12	256.31	256.1	256.28	96924.0
2017-10-25 08:30:00	SPY	ETF	256.28	256.32	256.12	256.23	150334.0
2017-10-25 09:00:00	SPY	ETF	256.2	256.25	256.11	256.19	229684.0
2017-10-25 09:30:00	SPY	ETF	256.18	256.31	255.75	255.805	4998438.0
2017-10-25 10:00:00	SPY	ETF	255.8	256.02	255.43	255.62	4533348.0
2017-10-25 10:30:00	SPY	ETF	255.62	255.64	255.06	255.26	4126629.0
2017-10-25 11:00:00	SPY	ETF	255.25	255.26	254.46	254.8	9534815.0
2017-10-25 11:30:00	SPY	ETF	254.8	255.05	254.55	254.725	9488219.0
2017-10-25 12:00:00	SPY	ETF	254.72	254.73	254.04	254.0611	7396331.0
2017-10-25 12:30:00	SPY	ETF	254.06	254.68	254.0	254.645	6499938.0
2017-10-25 13:00:00	SPY	ETF	254.645	254.83	254.45	254.579	3550844.0
2017-10-25 13:30:00	SPY	ETF	254.58	255.14	254.57	255.09	4663841.0
2017-10-25 14:00:00	SPY	ETF	255.08	255.44	255.07	255.35	5071190.0
2017-10-25 14:30:00	SPY	ETF	255.35	255.36	254.95	255.15	4917293.0
2017-10-25 15:00:00	SPY	ETF	255.15	255.57	255.06	255.51	4784111.0
2017-10-25 15:30:00	SPY	ETF	255.51	255.52	254.9	255.3	13233675.0
2017-10-25 16:00:00	SPY	ETF	255.3	255.66	255.29	255.64	15195759.0
2017-10-25 16:30:00	SPY	ETF	255.64	255.74	255.3113	255.71	2960651.0
2017-10-25 17:00:00	SPY	ETF	255.68	255.7	255.66	255.67	39515.0
2017-10-25 17:30:00	SPY	ETF	255.69	255.72	255.68	255.72	81516.0
2017-10-25 18:00:00	SPY	ETF	255.71	255.71	255.63	255.69	73603.0
2017-10-25 18:30:00	SPY	ETF	255.67	255.67	255.63	255.63	17659.0
2017-10-25 19:00:00	SPY	ETF	255.63	255.63	255.56	255.56	46826.0
2017-10-25 19:30:00	SPY	ETF	255.58	255.61	255.56	255.6	31540.0
2017-10-25 04:00:00	QQQ	ETF	147.81	147.81	147.68	147.71	10800.0
2017-10-25 04:30:00	QQQ	ETF	147.68	147.68	147.68	147.68	200.0
2017-10-25 05:00:00	QQQ	ETF	147.61	147.64	147.58	147.58	15197.0
2017-10-25 05:30:00	QQQ	ETF	147.74	147.78	147.74	147.78	3300.0
2017-10-25 06:00:00	QQQ	ETF	147.75	147.79	147.75	147.79	24900.0
2017-10-25 06:30:00	QQQ	ETF	147.8	147.8	147.79	147.79	5199.0
2017-10-25 07:00:00	QQQ	ETF	147.88	147.88	147.68	147.71	13105.0
2017-10-25 07:30:00	QQQ	ETF	147.72	147.75	147.69	147.72	18499.0
2017-10-25 08:00:00	QQQ	ETF	147.71	147.79	147.66	147.78	102547.0
2017-10-25 08:30:00	QQQ	ETF	147.78	147.8	147.62	147.72	32595.0
2017-10-25 09:00:00	QQQ	ETF	147.7	147.74	147.63	147.71	139257.0
2017-10-25 09:30:00	QQQ	ETF	147.71	148.18	147.5847	147.68	2857650.0
2017-10-25 10:00:00	QQQ	ETF	147.68	147.93	147.56	147.8901	1898011.0
2017-10-25 10:30:00	QQQ	ETF	147.9	147.92	147.41	147.57	1420410.0
2017-10-25 11:00:00	QQQ	ETF	147.58	147.58	146.45	146.76	4090655.0
2017-10-25 11:30:00	QQQ	ETF	146.76	147.02	146.64	146.78	2459603.0
2017-10-25 12:00:00	QQQ	ETF	146.78	146.98	146.38	146.3801	2339508.0
2017-10-25 12:30:00	QQQ	ETF	146.38	147.04	146.33	146.99	2369243.0

> showing 50 of 15,679 rows — these rows as CSV

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