PREVIEW / etf_30min / 2016-12-05

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-12-05.parquet
  size:    434 KB
  rows:    14,759

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-12-05 04:00:00	SPY	ETF	220.54	221.0	220.04	220.65	16984.0
2016-12-05 04:30:00	SPY	ETF	220.7	220.79	220.7	220.72	5479.0
2016-12-05 05:00:00	SPY	ETF	220.7	220.7	220.65	220.66	1035.0
2016-12-05 05:30:00	SPY	ETF	220.59	220.59	220.45	220.51	10567.0
2016-12-05 06:00:00	SPY	ETF	220.6	220.71	220.56	220.71	6442.0
2016-12-05 06:30:00	SPY	ETF	220.66	220.76	220.66	220.7	42137.0
2016-12-05 07:00:00	SPY	ETF	220.72	220.76	220.58	220.58	129872.0
2016-12-05 07:30:00	SPY	ETF	220.5	220.58	220.44	220.57	79000.0
2016-12-05 08:00:00	SPY	ETF	220.53	220.75	220.37	220.44	75023.0
2016-12-05 08:30:00	SPY	ETF	220.44	220.63	220.38	220.55	146336.0
2016-12-05 09:00:00	SPY	ETF	220.55	220.66	220.51	220.65	248085.0
2016-12-05 09:30:00	SPY	ETF	220.65	221.18	220.42	221.1	7785008.0
2016-12-05 10:00:00	SPY	ETF	221.11	221.4	221.0	221.1035	5975167.0
2016-12-05 10:30:00	SPY	ETF	221.1	221.26	220.99	221.195	3061429.0
2016-12-05 11:00:00	SPY	ETF	221.19	221.3	221.05	221.11	2916698.0
2016-12-05 11:30:00	SPY	ETF	221.1	221.2	220.87	220.99	2591535.0
2016-12-05 12:00:00	SPY	ETF	220.9989	221.03	220.75	220.85	2904271.0
2016-12-05 12:30:00	SPY	ETF	220.85	220.96	220.72	220.935	3187047.0
2016-12-05 13:00:00	SPY	ETF	220.94	221.03	220.83	220.8908	1886637.0
2016-12-05 13:30:00	SPY	ETF	220.8987	220.96	220.77	220.795	1855577.0
2016-12-05 14:00:00	SPY	ETF	220.8	220.82	220.56	220.6697	3266828.0
2016-12-05 14:30:00	SPY	ETF	220.65	220.78	220.5	220.72	6251142.0
2016-12-05 15:00:00	SPY	ETF	220.72	220.94	220.72	220.9	5874844.0
2016-12-05 15:30:00	SPY	ETF	220.9	220.97	220.81	220.92	10600717.0
2016-12-05 16:00:00	SPY	ETF	220.92	221.04	220.7726	221.04	4006656.0
2016-12-05 16:30:00	SPY	ETF	221.02	221.15	221.0	221.1	603478.0
2016-12-05 17:00:00	SPY	ETF	221.09	221.15	221.0	221.11	95666.0
2016-12-05 17:30:00	SPY	ETF	221.14	221.15	221.08	221.13	29760.0
2016-12-05 18:00:00	SPY	ETF	221.13	221.13	220.87	220.96	164619.0
2016-12-05 18:30:00	SPY	ETF	220.98	221.11	220.96	221.08	41360.0
2016-12-05 19:00:00	SPY	ETF	221.11	221.14	221.06	221.08	12748.0
2016-12-05 19:30:00	SPY	ETF	221.08	221.08	220.99	221.02	22882.0
2016-12-05 04:00:00	QQQ	ETF	116.43	116.44	116.22	116.22	38775.0
2016-12-05 04:30:00	QQQ	ETF	116.28	116.35	116.28	116.31	15218.0
2016-12-05 05:00:00	QQQ	ETF	116.31	116.32	116.3	116.32	10139.0
2016-12-05 05:30:00	QQQ	ETF	116.17	116.2	116.17	116.2	14998.0
2016-12-05 06:00:00	QQQ	ETF	116.13	116.25	116.13	116.25	15494.0
2016-12-05 06:30:00	QQQ	ETF	116.2	116.24	116.19	116.19	860.0
2016-12-05 07:00:00	QQQ	ETF	116.24	116.31	116.2	116.2	90986.0
2016-12-05 07:30:00	QQQ	ETF	116.15	116.16	116.11	116.16	7954.0
2016-12-05 08:00:00	QQQ	ETF	116.19	116.3	116.08	116.09	39375.0
2016-12-05 08:30:00	QQQ	ETF	116.13	116.2	116.08	116.17	100273.0
2016-12-05 09:00:00	QQQ	ETF	116.18	116.31	116.13	116.31	62466.0
2016-12-05 09:30:00	QQQ	ETF	116.32	116.62	115.77	116.54	3374032.0
2016-12-05 10:00:00	QQQ	ETF	116.55	116.86	116.5319	116.771	2580720.0
2016-12-05 10:30:00	QQQ	ETF	116.77	117.06	116.65	116.92	1824032.0
2016-12-05 11:00:00	QQQ	ETF	116.93	116.98	116.71	116.76	1033046.0
2016-12-05 11:30:00	QQQ	ETF	116.75	116.83	116.5443	116.61	702804.0
2016-12-05 12:00:00	QQQ	ETF	116.63	116.72	116.34	116.47	1022062.0
2016-12-05 12:30:00	QQQ	ETF	116.47	116.69	116.44	116.68	765581.0

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

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