PREVIEW / etf_30min / 2017-03-07

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-03-07.parquet
  size:    426 KB
  rows:    14,604

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-03-07 04:00:00	SPY	ETF	237.64	237.64	237.52	237.52	4710.0
2017-03-07 04:30:00	SPY	ETF	237.47	237.57	237.47	237.57	350.0
2017-03-07 05:00:00	SPY	ETF	237.57	237.57	237.54	237.54	1000.0
2017-03-07 05:30:00	SPY	ETF	237.49	237.49	237.4	237.44	3100.0
2017-03-07 06:00:00	SPY	ETF	237.37	237.47	237.37	237.47	1000.0
2017-03-07 06:30:00	SPY	ETF	237.47	237.49	237.42	237.42	9400.0
2017-03-07 07:00:00	SPY	ETF	237.38	237.42	237.38	237.4	60546.0
2017-03-07 07:30:00	SPY	ETF	237.46	237.55	237.45	237.45	70378.0
2017-03-07 08:00:00	SPY	ETF	237.39	237.55	237.28	237.35	121952.0
2017-03-07 08:30:00	SPY	ETF	237.35	237.54	237.34	237.51	145516.0
2017-03-07 09:00:00	SPY	ETF	237.51	237.7576	237.34	237.35	461039.0
2017-03-07 09:30:00	SPY	ETF	237.36	237.43	236.92	237.175	7046575.0
2017-03-07 10:00:00	SPY	ETF	237.17	237.64	237.11	237.5999	4731369.0
2017-03-07 10:30:00	SPY	ETF	237.6	237.77	237.45	237.48	4006443.0
2017-03-07 11:00:00	SPY	ETF	237.48	237.555	237.105	237.116	2311373.0
2017-03-07 11:30:00	SPY	ETF	237.11	237.28	237.02	237.24	2602781.0
2017-03-07 12:00:00	SPY	ETF	237.25	237.27	237.05	237.215	2039228.0
2017-03-07 12:30:00	SPY	ETF	237.21	237.34	237.12	237.33	1543665.0
2017-03-07 13:00:00	SPY	ETF	237.33	237.49	237.25	237.39	1673453.0
2017-03-07 13:30:00	SPY	ETF	237.39	237.41	237.16	237.18	1818084.0
2017-03-07 14:00:00	SPY	ETF	237.1847	237.335	237.15	237.29	1818259.0
2017-03-07 14:30:00	SPY	ETF	237.28	237.45	237.14	237.4	2442753.0
2017-03-07 15:00:00	SPY	ETF	237.4	237.44	237.16	237.211	2319864.0
2017-03-07 15:30:00	SPY	ETF	237.22	237.27	236.76	237.05	10675482.0
2017-03-07 16:00:00	SPY	ETF	237.055	237.07	236.85	236.895	6016773.0
2017-03-07 16:30:00	SPY	ETF	236.91	237.05	236.91	236.91	1233886.0
2017-03-07 17:00:00	SPY	ETF	236.94	237.71	236.89	236.9	5394103.0
2017-03-07 17:30:00	SPY	ETF	236.91	236.91	236.8	236.85	94869.0
2017-03-07 18:00:00	SPY	ETF	236.85	236.9	236.68	236.73	106588.0
2017-03-07 18:30:00	SPY	ETF	236.73	236.74	236.66	236.66	29075.0
2017-03-07 19:00:00	SPY	ETF	236.7	236.7	236.36	236.62	60375.0
2017-03-07 19:30:00	SPY	ETF	236.62	237.0673	236.58	236.64	310886.0
2017-03-07 04:00:00	QQQ	ETF	130.7	130.7	130.7	130.7	1000.0
2017-03-07 04:30:00	QQQ	ETF	130.63	130.63	130.63	130.63	200.0
2017-03-07 05:00:00	QQQ	ETF	130.66	130.66	130.61	130.61	800.0
2017-03-07 05:30:00	QQQ	ETF	130.56	130.56	130.56	130.56	100.0
2017-03-07 06:00:00	QQQ	ETF	130.53	130.53	130.53	130.53	500.0
2017-03-07 06:30:00	QQQ	ETF	130.56	130.56	130.56	130.56	100.0
2017-03-07 07:00:00	QQQ	ETF	130.56	130.59	130.56	130.56	9400.0
2017-03-07 07:30:00	QQQ	ETF	130.58	130.59	130.56	130.56	2311.0
2017-03-07 08:00:00	QQQ	ETF	130.61	130.61	130.49	130.5	13931.0
2017-03-07 08:30:00	QQQ	ETF	130.5	130.56	130.5	130.54	22790.0
2017-03-07 09:00:00	QQQ	ETF	130.53	130.53	130.44	130.45	21989.0
2017-03-07 09:30:00	QQQ	ETF	130.44	130.65	130.34	130.54	1314547.0
2017-03-07 10:00:00	QQQ	ETF	130.53	130.95	130.5	130.92	1308049.0
2017-03-07 10:30:00	QQQ	ETF	130.93	131.08	130.92	130.95	1628090.0
2017-03-07 11:00:00	QQQ	ETF	130.949	130.96	130.63	130.64	1274126.0
2017-03-07 11:30:00	QQQ	ETF	130.6364	130.65	130.55	130.62	773650.0
2017-03-07 12:00:00	QQQ	ETF	130.6242	130.64	130.43	130.539	623516.0
2017-03-07 12:30:00	QQQ	ETF	130.53	130.63	130.48	130.62	323061.0

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

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