PREVIEW / etf_1hour / 2016-06-14

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-06-14.parquet
  size:    254 KB
  rows:    8,226

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-14 04:00:00	SPY	ETF	208.1	208.12	207.54	207.76	21830.0
2016-06-14 05:00:00	SPY	ETF	207.74	207.88	207.64	207.87	36003.0
2016-06-14 06:00:00	SPY	ETF	207.89	208.18	207.87	207.99	76305.0
2016-06-14 07:00:00	SPY	ETF	208.0	208.08	207.76	207.8	889973.0
2016-06-14 08:00:00	SPY	ETF	207.81	208.536	207.66	207.97	1143411.0
2016-06-14 09:00:00	SPY	ETF	207.97	208.74	207.74	208.4299	13512453.0
2016-06-14 10:00:00	SPY	ETF	208.42	208.64	207.07	207.16	20938756.0
2016-06-14 11:00:00	SPY	ETF	207.17	207.58	206.94	207.205	17435534.0
2016-06-14 12:00:00	SPY	ETF	207.2	208.04	207.14	207.62	13601313.0
2016-06-14 13:00:00	SPY	ETF	207.61	207.72	207.19	207.21	10677413.0
2016-06-14 14:00:00	SPY	ETF	207.22	207.74	207.02	207.09	10014139.0
2016-06-14 15:00:00	SPY	ETF	207.1	208.21	206.9199	208.08	26656058.0
2016-06-14 16:00:00	SPY	ETF	208.08	208.16	207.57	207.91	8600114.0
2016-06-14 17:00:00	SPY	ETF	207.85	207.96	207.8	207.92	143863.0
2016-06-14 18:00:00	SPY	ETF	207.93	207.96	207.42	207.59	163510.0
2016-06-14 19:00:00	SPY	ETF	207.57	207.69	207.48	207.69	62832.0
2016-06-14 04:00:00	QQQ	ETF	107.66	107.66	107.58	107.58	1950.0
2016-06-14 05:00:00	QQQ	ETF	107.62	107.68	107.62	107.68	800.0
2016-06-14 06:00:00	QQQ	ETF	107.74	107.81	107.74	107.8	4198.0
2016-06-14 07:00:00	QQQ	ETF	107.8	107.83	107.7	107.72	55548.0
2016-06-14 08:00:00	QQQ	ETF	107.74	107.79	107.63	107.79	85613.0
2016-06-14 09:00:00	QQQ	ETF	107.74	108.39	107.67	108.28	4065911.0
2016-06-14 10:00:00	QQQ	ETF	108.27	108.415	107.36	107.42	4117889.0
2016-06-14 11:00:00	QQQ	ETF	107.43	107.57	107.24	107.42	3867790.0
2016-06-14 12:00:00	QQQ	ETF	107.41	107.9	107.38	107.72	2415416.0
2016-06-14 13:00:00	QQQ	ETF	107.72	107.78	107.46	107.49	1343972.0
2016-06-14 14:00:00	QQQ	ETF	107.48	107.8	107.44	107.51	1666987.0
2016-06-14 15:00:00	QQQ	ETF	107.52	108.09	107.41	108.03	4635662.0
2016-06-14 16:00:00	QQQ	ETF	108.03	108.13	107.94	108.01	412560.0
2016-06-14 17:00:00	QQQ	ETF	108.01	108.01	107.9	107.99	2034.0
2016-06-14 18:00:00	QQQ	ETF	108.0	108.03	107.77	107.8	45489.0
2016-06-14 19:00:00	QQQ	ETF	107.85	107.9	107.8	107.88	23728.0
2016-06-14 04:00:00	IWM	ETF	114.38	114.38	114.0	114.11	9466.0
2016-06-14 05:00:00	IWM	ETF	114.17	114.18	114.09	114.18	3470.0
2016-06-14 06:00:00	IWM	ETF	114.22	114.26	114.19	114.24	6250.0
2016-06-14 07:00:00	IWM	ETF	114.25	114.3	114.13	114.13	16000.0
2016-06-14 08:00:00	IWM	ETF	114.25	114.28	114.1	114.24	95888.0
2016-06-14 09:00:00	IWM	ETF	114.21	115.11	114.16	114.83	3575176.0
2016-06-14 10:00:00	IWM	ETF	114.83	114.91	113.83	113.835	5991732.0
2016-06-14 11:00:00	IWM	ETF	113.84	114.21	113.67	113.91	3855375.0
2016-06-14 12:00:00	IWM	ETF	113.92	114.58	113.89	114.04	2939070.0
2016-06-14 13:00:00	IWM	ETF	114.04	114.16	113.81	113.835	2089636.0
2016-06-14 14:00:00	IWM	ETF	113.84	114.32	113.83	113.9	2860268.0
2016-06-14 15:00:00	IWM	ETF	113.91	114.575	113.82	114.46	6637595.0
2016-06-14 16:00:00	IWM	ETF	114.46	114.58	114.34	114.38	455748.0
2016-06-14 17:00:00	IWM	ETF	114.41	114.44	114.25	114.42	18665.0
2016-06-14 18:00:00	IWM	ETF	114.33	114.33	114.2	114.3	10416.0
2016-06-14 19:00:00	IWM	ETF	114.31	114.31	114.2	114.25	738.0
2016-06-14 07:00:00	DIA	ETF	177.1	177.13	177.0	177.0	415.0
2016-06-14 08:00:00	DIA	ETF	177.0	177.16	176.9	177.01	4171.0

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

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