PREVIEW / etf_1hour / 2014-09-03

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-09-03.parquet
  size:    230 KB
  rows:    7,360

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
2014-09-03 04:00:00	SPY	ETF	200.8	201.71	200.8	201.0	53025.0
2014-09-03 05:00:00	SPY	ETF	201.35	201.38	201.18	201.25	36170.0
2014-09-03 06:00:00	SPY	ETF	201.26	201.44	201.26	201.38	56232.0
2014-09-03 07:00:00	SPY	ETF	201.41	201.44	201.08	201.15	412804.0
2014-09-03 08:00:00	SPY	ETF	201.15	201.41	200.61	201.28	1232761.0
2014-09-03 09:00:00	SPY	ETF	201.29	201.46	201.07	201.13	9242619.0
2014-09-03 10:00:00	SPY	ETF	201.12	201.24	200.86	201.03	7722054.0
2014-09-03 11:00:00	SPY	ETF	201.03	201.099	200.38	200.4064	7749110.0
2014-09-03 12:00:00	SPY	ETF	200.4	201.15	200.32	200.775	7703914.0
2014-09-03 13:00:00	SPY	ETF	200.78	200.89	200.58	200.74	4192447.0
2014-09-03 14:00:00	SPY	ETF	200.7338	200.77	200.35	200.36	4905907.0
2014-09-03 15:00:00	SPY	ETF	200.35	200.56	200.22	200.51	10057670.0
2014-09-03 16:00:00	SPY	ETF	200.52	200.67	200.43	200.48	3558329.0
2014-09-03 17:00:00	SPY	ETF	200.48	200.5	200.43	200.47	62978.0
2014-09-03 18:00:00	SPY	ETF	200.48	200.52	200.48	200.52	40312.0
2014-09-03 19:00:00	SPY	ETF	200.52	200.52	200.44	200.44	42025.0
2014-09-03 04:00:00	QQQ	ETF	100.25	100.53	100.25	100.52	39720.0
2014-09-03 05:00:00	QQQ	ETF	100.35	100.35	100.34	100.34	45700.0
2014-09-03 06:00:00	QQQ	ETF	100.4	100.43	100.39	100.42	10200.0
2014-09-03 07:00:00	QQQ	ETF	100.44	100.44	100.28	100.32	52606.0
2014-09-03 08:00:00	QQQ	ETF	100.44	100.44	100.07	100.34	323411.0
2014-09-03 09:00:00	QQQ	ETF	100.34	100.41	99.95	100.03	4777301.0
2014-09-03 10:00:00	QQQ	ETF	100.01	100.12	99.83	99.88	3169482.0
2014-09-03 11:00:00	QQQ	ETF	99.89	99.92	99.36	99.4	4852760.0
2014-09-03 12:00:00	QQQ	ETF	99.41	99.7099	99.34	99.67	3356062.0
2014-09-03 13:00:00	QQQ	ETF	99.67	99.75	99.551	99.665	1601700.0
2014-09-03 14:00:00	QQQ	ETF	99.665	99.7	99.38	99.3901	2034724.0
2014-09-03 15:00:00	QQQ	ETF	99.39	99.52	99.3	99.48	3552867.0
2014-09-03 16:00:00	QQQ	ETF	99.48	99.7802	99.45	99.51	1711985.0
2014-09-03 17:00:00	QQQ	ETF	99.52	99.53	99.48	99.53	3814.0
2014-09-03 18:00:00	QQQ	ETF	99.52	99.56	99.52	99.56	7899.0
2014-09-03 19:00:00	QQQ	ETF	99.54	99.55	99.5	99.5	11460.0
2014-09-03 04:00:00	IWM	ETF	117.62	117.97	117.62	117.97	4156.0
2014-09-03 06:00:00	IWM	ETF	117.77	117.85	117.71	117.8	16200.0
2014-09-03 07:00:00	IWM	ETF	117.77	117.86	117.68	117.86	17500.0
2014-09-03 08:00:00	IWM	ETF	117.62	117.98	117.2	117.77	1598388.0
2014-09-03 09:00:00	IWM	ETF	117.78	117.92	117.5	117.61	5344431.0
2014-09-03 10:00:00	IWM	ETF	117.615	117.72	117.27	117.3	4882240.0
2014-09-03 11:00:00	IWM	ETF	117.31	117.37	116.67	116.68	3939903.0
2014-09-03 12:00:00	IWM	ETF	116.68	117.05	116.581	116.95	2698979.0
2014-09-03 13:00:00	IWM	ETF	116.95	117.02	116.66	116.79	1687726.0
2014-09-03 14:00:00	IWM	ETF	116.78	116.81	116.41	116.41	2833108.0
2014-09-03 15:00:00	IWM	ETF	116.42	116.57	116.27	116.47	6629857.0
2014-09-03 16:00:00	IWM	ETF	116.46	116.9544	116.37	116.42	1899069.0
2014-09-03 17:00:00	IWM	ETF	116.4	116.4	116.32	116.32	1301.0
2014-09-03 18:00:00	IWM	ETF	116.41	116.41	116.35	116.35	300.0
2014-09-03 19:00:00	IWM	ETF	116.55	116.55	116.55	116.55	100.0
2014-09-03 04:00:00	DIA	ETF	171.03	171.47	171.03	171.11	6800.0
2014-09-03 06:00:00	DIA	ETF	171.22	171.24	171.22	171.24	1400.0
2014-09-03 07:00:00	DIA	ETF	171.3	171.3	171.2	171.2	1500.0

> showing 50 of 7,360 rows — these rows as CSV

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