PREVIEW / etf_30min / 2016-11-23

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-11-23.parquet
  size:    429 KB
  rows:    14,646

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
2016-11-23 04:00:00	SPY	ETF	220.71	220.88	220.68	220.83	4300.0
2016-11-23 04:30:00	SPY	ETF	220.83	220.86	220.68	220.68	12700.0
2016-11-23 05:00:00	SPY	ETF	220.58	220.59	220.52	220.52	3171.0
2016-11-23 05:30:00	SPY	ETF	220.45	220.5	220.33	220.48	5395.0
2016-11-23 06:00:00	SPY	ETF	220.48	220.54	220.48	220.54	1134.0
2016-11-23 06:30:00	SPY	ETF	220.49	220.49	220.32	220.37	61572.0
2016-11-23 07:00:00	SPY	ETF	220.46	220.56	220.42	220.55	6762.0
2016-11-23 07:30:00	SPY	ETF	220.55	220.6	220.5	220.6	28519.0
2016-11-23 08:00:00	SPY	ETF	220.58	220.62	220.39	220.49	143434.0
2016-11-23 08:30:00	SPY	ETF	220.45	220.46	220.12	220.2	308467.0
2016-11-23 09:00:00	SPY	ETF	220.22	220.26	219.86	219.98	844490.0
2016-11-23 09:30:00	SPY	ETF	219.98	220.22	219.75	219.88	8128804.0
2016-11-23 10:00:00	SPY	ETF	219.88	220.31	219.88	220.265	6498222.0
2016-11-23 10:30:00	SPY	ETF	220.27	220.45	220.1491	220.3	3287953.0
2016-11-23 11:00:00	SPY	ETF	220.3	220.35	219.98	220.03	3200655.0
2016-11-23 11:30:00	SPY	ETF	220.025	220.35	220.0	220.34	2599929.0
2016-11-23 12:00:00	SPY	ETF	220.34	220.43	220.28	220.38	2399591.0
2016-11-23 12:30:00	SPY	ETF	220.38	220.61	220.305	220.46	2674606.0
2016-11-23 13:00:00	SPY	ETF	220.47	220.52	220.38	220.4256	1742287.0
2016-11-23 13:30:00	SPY	ETF	220.4299	220.55	220.35	220.365	1905517.0
2016-11-23 14:00:00	SPY	ETF	220.36	220.58	220.36	220.5268	3065188.0
2016-11-23 14:30:00	SPY	ETF	220.52	220.6	220.37	220.47	2125176.0
2016-11-23 15:00:00	SPY	ETF	220.46	220.54	220.45	220.5	2103005.0
2016-11-23 15:30:00	SPY	ETF	220.5	220.76	220.48	220.73	9579878.0
2016-11-23 16:00:00	SPY	ETF	220.71	220.7554	220.55	220.61	4235818.0
2016-11-23 16:30:00	SPY	ETF	220.58	220.62	220.57	220.61	158855.0
2016-11-23 17:00:00	SPY	ETF	220.7	220.7	220.55	220.6	467912.0
2016-11-23 17:30:00	SPY	ETF	220.61	220.67	220.61	220.67	57524.0
2016-11-23 18:00:00	SPY	ETF	220.66	220.68	220.62	220.62	18948.0
2016-11-23 18:30:00	SPY	ETF	220.61	220.64	220.57	220.61	18273.0
2016-11-23 19:00:00	SPY	ETF	220.59	220.6	220.54	220.58	18958.0
2016-11-23 19:30:00	SPY	ETF	220.58	220.58	220.54	220.56	10474.0
2016-11-23 04:00:00	QQQ	ETF	119.03	119.13	119.03	119.13	2471.0
2016-11-23 05:00:00	QQQ	ETF	118.93	118.93	118.93	118.93	1000.0
2016-11-23 05:30:00	QQQ	ETF	118.91	118.93	118.9	118.93	1305.0
2016-11-23 06:00:00	QQQ	ETF	118.88	118.89	118.88	118.89	200.0
2016-11-23 07:00:00	QQQ	ETF	118.86	118.9	118.86	118.89	3110.0
2016-11-23 07:30:00	QQQ	ETF	118.92	118.93	118.9	118.91	12000.0
2016-11-23 08:00:00	QQQ	ETF	118.92	118.96	118.83	118.85	64854.0
2016-11-23 08:30:00	QQQ	ETF	118.82	118.82	118.63	118.63	47261.0
2016-11-23 09:00:00	QQQ	ETF	118.63	118.66	118.43	118.49	350002.0
2016-11-23 09:30:00	QQQ	ETF	118.51	118.64	118.05	118.18	3692809.0
2016-11-23 10:00:00	QQQ	ETF	118.185	118.37	118.17	118.252	1826576.0
2016-11-23 10:30:00	QQQ	ETF	118.26	118.33	118.07	118.17	1633416.0
2016-11-23 11:00:00	QQQ	ETF	118.18	118.2	117.97	117.98	1250070.0
2016-11-23 11:30:00	QQQ	ETF	117.98	118.21	117.9	118.21	1127387.0
2016-11-23 12:00:00	QQQ	ETF	118.2	118.3	118.16	118.2485	547125.0
2016-11-23 12:30:00	QQQ	ETF	118.25	118.34	118.18	118.25	623354.0
2016-11-23 13:00:00	QQQ	ETF	118.25	118.29	118.14	118.1565	553745.0
2016-11-23 13:30:00	QQQ	ETF	118.15	118.27	118.06	118.09	640069.0

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

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