PREVIEW / etf_30min / 2018-07-17

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-07-17.parquet
  size:    460 KB
  rows:    15,929

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
2018-07-17 04:00:00	SPY	ETF	278.8	278.97	278.8	278.85	8390.0
2018-07-17 04:30:00	SPY	ETF	278.83	278.96	278.83	278.93	4594.0
2018-07-17 05:00:00	SPY	ETF	278.96	278.96	278.88	278.92	1450.0
2018-07-17 05:30:00	SPY	ETF	278.94	278.97	278.89	278.89	14609.0
2018-07-17 06:00:00	SPY	ETF	278.91	278.91	278.53	278.62	35429.0
2018-07-17 06:30:00	SPY	ETF	278.5	278.65	278.46	278.65	46063.0
2018-07-17 07:00:00	SPY	ETF	278.68	278.79	278.54	278.79	179317.0
2018-07-17 07:30:00	SPY	ETF	278.75	278.84	278.7	278.71	47481.0
2018-07-17 08:00:00	SPY	ETF	278.7301	278.85	278.46	278.68	139610.0
2018-07-17 08:30:00	SPY	ETF	278.69	278.72	278.52	278.56	266716.0
2018-07-17 09:00:00	SPY	ETF	278.56	278.56	278.35	278.47	234929.0
2018-07-17 09:30:00	SPY	ETF	278.47	278.96	278.41	278.89	4506506.0
2018-07-17 10:00:00	SPY	ETF	278.93	279.26	278.92	279.22	3358338.0
2018-07-17 10:30:00	SPY	ETF	279.23	279.82	279.23	279.72	3649354.0
2018-07-17 11:00:00	SPY	ETF	279.72	279.98	279.66	279.8565	3773521.0
2018-07-17 11:30:00	SPY	ETF	279.86	280.2	279.72	280.18	2663791.0
2018-07-17 12:00:00	SPY	ETF	280.185	280.625	280.03	280.6	4479755.0
2018-07-17 12:30:00	SPY	ETF	280.6	280.6199	280.365	280.5132	3285983.0
2018-07-17 13:00:00	SPY	ETF	280.52	280.75	280.41	280.52	2783211.0
2018-07-17 13:30:00	SPY	ETF	280.51	280.75	280.49	280.55	1875388.0
2018-07-17 14:00:00	SPY	ETF	280.56	280.62	280.35	280.57	2301852.0
2018-07-17 14:30:00	SPY	ETF	280.56	280.65	280.33	280.36	2655084.0
2018-07-17 15:00:00	SPY	ETF	280.35	280.89	280.29	280.74	2296645.0
2018-07-17 15:30:00	SPY	ETF	280.75	280.91	280.41	280.5	8840641.0
2018-07-17 16:00:00	SPY	ETF	280.5	280.56	280.38	280.52	3007219.0
2018-07-17 16:30:00	SPY	ETF	280.53	280.78	280.47	280.66	418589.0
2018-07-17 17:00:00	SPY	ETF	280.65	280.65	280.47	280.64	75343.0
2018-07-17 17:30:00	SPY	ETF	280.6	280.68	280.47	280.66	311537.0
2018-07-17 18:00:00	SPY	ETF	280.69	280.81	280.47	280.77	52182.0
2018-07-17 18:30:00	SPY	ETF	280.77	280.91	280.77	280.85	43365.0
2018-07-17 19:00:00	SPY	ETF	280.8	280.87	280.8	280.81	7775.0
2018-07-17 19:30:00	SPY	ETF	280.83	280.94	280.74	280.84	32009.0
2018-07-17 04:00:00	QQQ	ETF	177.7	177.7	177.66	177.69	844.0
2018-07-17 04:30:00	QQQ	ETF	177.74	177.8	177.74	177.74	11710.0
2018-07-17 05:00:00	QQQ	ETF	177.75	177.78	177.74	177.75	1500.0
2018-07-17 05:30:00	QQQ	ETF	177.77	177.79	177.74	177.77	5934.0
2018-07-17 06:00:00	QQQ	ETF	177.8	177.8	177.55	177.55	3978.0
2018-07-17 06:30:00	QQQ	ETF	177.5	177.6	177.43	177.56	6551.0
2018-07-17 07:00:00	QQQ	ETF	177.63	177.76	177.56	177.75	100476.0
2018-07-17 07:30:00	QQQ	ETF	177.73	177.92	177.72	177.88	33225.0
2018-07-17 08:00:00	QQQ	ETF	179.18	179.18	177.27	177.77	119770.0
2018-07-17 08:30:00	QQQ	ETF	177.76	177.78	177.57	177.59	159727.0
2018-07-17 09:00:00	QQQ	ETF	177.59	177.59	177.19	177.28	464375.0
2018-07-17 09:30:00	QQQ	ETF	177.3	178.361	177.28	178.34	3822630.0
2018-07-17 10:00:00	QQQ	ETF	178.35	178.68	178.26	178.609	2184478.0
2018-07-17 10:30:00	QQQ	ETF	178.61	179.18	178.6	179.07	2281348.0
2018-07-17 11:00:00	QQQ	ETF	179.08	179.37	179.054	179.22	1540973.0
2018-07-17 11:30:00	QQQ	ETF	179.225	179.65	179.16	179.65	1291695.0
2018-07-17 12:00:00	QQQ	ETF	179.65	180.335	179.49	180.3	1919943.0
2018-07-17 12:30:00	QQQ	ETF	180.3	180.33	180.02	180.06	1615443.0

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

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