PREVIEW / etf_1hour / 2015-07-06

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-07-06.parquet
  size:    252 KB
  rows:    8,060

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
2015-07-06 04:00:00	SPY	ETF	206.26	206.26	205.77	206.0	27280.0
2015-07-06 05:00:00	SPY	ETF	205.97	206.5	205.87	206.43	62219.0
2015-07-06 06:00:00	SPY	ETF	206.46	206.51	206.13	206.18	72147.0
2015-07-06 07:00:00	SPY	ETF	206.2	206.35	205.48	205.57	614335.0
2015-07-06 08:00:00	SPY	ETF	205.57	206.22	204.5228	205.75	1176301.0
2015-07-06 09:00:00	SPY	ETF	205.76	206.59	205.53	206.39	14490212.0
2015-07-06 10:00:00	SPY	ETF	206.38	207.65	206.24	207.1956	20889188.0
2015-07-06 11:00:00	SPY	ETF	207.2	207.4303	206.64	206.95	11989027.0
2015-07-06 12:00:00	SPY	ETF	206.95	207.09	206.67	206.8	5425796.0
2015-07-06 13:00:00	SPY	ETF	206.79	206.91	205.98	206.0657	15911119.0
2015-07-06 14:00:00	SPY	ETF	206.06	206.19	205.68	205.9	13829988.0
2015-07-06 15:00:00	SPY	ETF	205.9	206.72	205.84	206.7	20590055.0
2015-07-06 16:00:00	SPY	ETF	206.71	207.35	206.474	207.29	6359460.0
2015-07-06 17:00:00	SPY	ETF	207.29	207.51	207.29	207.41	554406.0
2015-07-06 18:00:00	SPY	ETF	207.44	207.86	207.44	207.7	176430.0
2015-07-06 19:00:00	SPY	ETF	207.69	207.7	207.46	207.52	172059.0
2015-07-06 04:00:00	QQQ	ETF	107.14	107.2	107.1	107.2	2150.0
2015-07-06 06:00:00	QQQ	ETF	107.44	107.44	107.27	107.27	2000.0
2015-07-06 07:00:00	QQQ	ETF	107.3	107.34	107.04	107.05	44734.0
2015-07-06 08:00:00	QQQ	ETF	107.11	107.33	107.09	107.23	139196.0
2015-07-06 09:00:00	QQQ	ETF	107.26	107.7	107.04	107.6161	4518366.0
2015-07-06 10:00:00	QQQ	ETF	107.61	108.32	107.4838	108.03	4048924.0
2015-07-06 11:00:00	QQQ	ETF	108.04	108.09	107.65	107.8	2457598.0
2015-07-06 12:00:00	QQQ	ETF	107.8	107.89	107.66	107.77	1298220.0
2015-07-06 13:00:00	QQQ	ETF	107.77	107.81	107.3	107.36	2544251.0
2015-07-06 14:00:00	QQQ	ETF	107.36	107.44	107.13	107.22	3395626.0
2015-07-06 15:00:00	QQQ	ETF	107.22	107.71	107.19	107.71	3893566.0
2015-07-06 16:00:00	QQQ	ETF	107.71	108.09	107.69	108.07	493806.0
2015-07-06 17:00:00	QQQ	ETF	108.07	108.14	107.7	108.11	221082.0
2015-07-06 18:00:00	QQQ	ETF	108.13	108.3	108.13	108.27	28908.0
2015-07-06 19:00:00	QQQ	ETF	108.23	108.23	108.13	108.16	24097.0
2015-07-06 06:00:00	IWM	ETF	123.05	123.3	123.04	123.1	1300.0
2015-07-06 07:00:00	IWM	ETF	123.25	123.25	122.55	122.74	50756.0
2015-07-06 08:00:00	IWM	ETF	122.81	122.98	122.77	122.82	133588.0
2015-07-06 09:00:00	IWM	ETF	122.94	123.5	122.82	123.47	3304629.0
2015-07-06 10:00:00	IWM	ETF	123.46	124.51	123.34	123.885	5541876.0
2015-07-06 11:00:00	IWM	ETF	123.89	123.95	123.41	123.68	2719355.0
2015-07-06 12:00:00	IWM	ETF	123.67	123.83	123.46	123.53	1527390.0
2015-07-06 13:00:00	IWM	ETF	123.54	123.59	122.99	123.09	3197169.0
2015-07-06 14:00:00	IWM	ETF	123.06	123.215	122.87	123.11	2106716.0
2015-07-06 15:00:00	IWM	ETF	123.1	123.81	123.04	123.76	5209604.0
2015-07-06 16:00:00	IWM	ETF	123.75	124.19	123.65	124.12	5426802.0
2015-07-06 17:00:00	IWM	ETF	124.2	124.27	124.17	124.17	14442.0
2015-07-06 18:00:00	IWM	ETF	124.17	124.26	124.17	124.2	11400.0
2015-07-06 19:00:00	IWM	ETF	124.27	124.27	124.2	124.2	4112.0
2015-07-06 04:00:00	DIA	ETF	175.77	175.77	175.76	175.76	200.0
2015-07-06 06:00:00	DIA	ETF	176.06	176.06	175.93	175.93	600.0
2015-07-06 07:00:00	DIA	ETF	175.9	176.05	175.5	175.5	7555.0
2015-07-06 08:00:00	DIA	ETF	175.59	175.787	175.54	175.647	2756.0
2015-07-06 09:00:00	DIA	ETF	175.66	176.21	175.34	176.07	909146.0

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

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