PREVIEW / etf_1hour / 2016-06-13

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-06-13.parquet
  size:    253 KB
  rows:    8,183

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-06-13 04:00:00	SPY	ETF	209.6	209.94	209.46	209.46	119242.0
2016-06-13 05:00:00	SPY	ETF	209.43	209.49	209.27	209.33	24619.0
2016-06-13 06:00:00	SPY	ETF	209.34	209.44	209.27	209.34	42648.0
2016-06-13 07:00:00	SPY	ETF	209.41	209.76	209.35	209.59	240831.0
2016-06-13 08:00:00	SPY	ETF	209.58	209.68	209.37	209.47	833921.0
2016-06-13 09:00:00	SPY	ETF	209.48	210.11	209.18	209.9659	12393758.0
2016-06-13 10:00:00	SPY	ETF	209.97	210.37	209.72	209.9789	17035881.0
2016-06-13 11:00:00	SPY	ETF	209.98	210.04	209.07	209.135	12348496.0
2016-06-13 12:00:00	SPY	ETF	209.14	209.73	209.05	209.6	10950846.0
2016-06-13 13:00:00	SPY	ETF	209.61	209.695	208.97	209.08	11123793.0
2016-06-13 14:00:00	SPY	ETF	209.09	209.59	208.98	209.09	8676655.0
2016-06-13 15:00:00	SPY	ETF	209.095	209.17	208.35	208.44	25425127.0
2016-06-13 16:00:00	SPY	ETF	208.46	209.34	208.12	208.19	15600735.0
2016-06-13 17:00:00	SPY	ETF	208.2	208.23	208.05	208.15	316583.0
2016-06-13 18:00:00	SPY	ETF	208.15	208.21	207.9	207.95	185374.0
2016-06-13 19:00:00	SPY	ETF	207.97	208.2	207.95	208.16	73962.0
2016-06-13 04:00:00	QQQ	ETF	108.5	108.83	108.5	108.83	9042.0
2016-06-13 05:00:00	QQQ	ETF	108.54	108.6	108.52	108.52	1200.0
2016-06-13 06:00:00	QQQ	ETF	108.51	108.55	108.51	108.52	4338.0
2016-06-13 07:00:00	QQQ	ETF	108.53	108.64	108.49	108.57	21882.0
2016-06-13 08:00:00	QQQ	ETF	108.55	108.61	108.35	108.43	522080.0
2016-06-13 09:00:00	QQQ	ETF	108.43	108.83	108.28	108.73	3630782.0
2016-06-13 10:00:00	QQQ	ETF	108.72	108.93	108.52	108.6451	3260199.0
2016-06-13 11:00:00	QQQ	ETF	108.65	108.75	108.1	108.125	2624957.0
2016-06-13 12:00:00	QQQ	ETF	108.12	108.54	108.07	108.45	2496901.0
2016-06-13 13:00:00	QQQ	ETF	108.45	108.49	108.16	108.21	1626180.0
2016-06-13 14:00:00	QQQ	ETF	108.205	108.55	108.14	108.33	1868278.0
2016-06-13 15:00:00	QQQ	ETF	108.33	108.39	107.89	108.03	5666099.0
2016-06-13 16:00:00	QQQ	ETF	108.04	108.9096	107.91	107.94	715908.0
2016-06-13 17:00:00	QQQ	ETF	107.95	108.05	107.9	108.0	17314.0
2016-06-13 18:00:00	QQQ	ETF	107.9	107.92	107.76	107.77	38764.0
2016-06-13 19:00:00	QQQ	ETF	107.79	107.95	107.79	107.95	6061.0
2016-06-13 05:00:00	IWM	ETF	115.61	115.63	115.6	115.63	1522.0
2016-06-13 06:00:00	IWM	ETF	115.67	115.73	115.66	115.73	1512.0
2016-06-13 07:00:00	IWM	ETF	115.67	115.81	115.65	115.8	27265.0
2016-06-13 08:00:00	IWM	ETF	115.79	115.83	115.66	115.7	151591.0
2016-06-13 09:00:00	IWM	ETF	115.74	116.14	115.51	115.93	6534133.0
2016-06-13 10:00:00	IWM	ETF	115.92	116.18	115.5	115.51	6069610.0
2016-06-13 11:00:00	IWM	ETF	115.51	115.54	115.06	115.1	3587750.0
2016-06-13 12:00:00	IWM	ETF	115.1	115.55	115.06	115.46	2566191.0
2016-06-13 13:00:00	IWM	ETF	115.46	115.505	114.96	115.0	2483126.0
2016-06-13 14:00:00	IWM	ETF	115.005	115.24	114.81	115.0	2521960.0
2016-06-13 15:00:00	IWM	ETF	114.995	115.045	114.59	114.78	5967347.0
2016-06-13 16:00:00	IWM	ETF	114.79	114.83	114.41	114.41	961071.0
2016-06-13 17:00:00	IWM	ETF	114.45	114.48	114.4	114.4	12170.0
2016-06-13 18:00:00	IWM	ETF	114.45	114.45	114.4	114.4	22595.0
2016-06-13 19:00:00	IWM	ETF	114.4	114.54	114.4	114.49	2500.0
2016-06-13 05:00:00	DIA	ETF	178.07	178.07	178.0	178.04	1400.0
2016-06-13 06:00:00	DIA	ETF	178.07	178.08	178.07	178.08	200.0
2016-06-13 07:00:00	DIA	ETF	178.08	178.26	178.08	178.23	1200.0

> showing 50 of 8,183 rows — these rows as CSV

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