PREVIEW / etf_1hour / 2014-07-17

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-07-17.parquet
  size:    237 KB
  rows:    7,653

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-07-17 04:00:00	SPY	ETF	197.68	197.7	197.49	197.5	10344.0
2014-07-17 05:00:00	SPY	ETF	197.42	197.5	197.23	197.25	9673.0
2014-07-17 06:00:00	SPY	ETF	197.24	197.25	196.75	196.82	73411.0
2014-07-17 07:00:00	SPY	ETF	196.83	197.14	196.7	196.96	583365.0
2014-07-17 08:00:00	SPY	ETF	196.93	197.96	196.93	197.18	974779.0
2014-07-17 09:00:00	SPY	ETF	197.18	197.9	197.12	197.84	10417153.0
2014-07-17 10:00:00	SPY	ETF	197.85	198.1	197.698	197.78	10451841.0
2014-07-17 11:00:00	SPY	ETF	197.78	197.82	196.68	196.86	25462438.0
2014-07-17 12:00:00	SPY	ETF	196.87	197.19	196.46	197.1	14753117.0
2014-07-17 13:00:00	SPY	ETF	197.11	197.53	196.84	196.97	10423491.0
2014-07-17 14:00:00	SPY	ETF	196.98	196.98	196.56	196.69	12349502.0
2014-07-17 15:00:00	SPY	ETF	196.69	196.71	195.43	195.72	38136334.0
2014-07-17 16:00:00	SPY	ETF	195.71	198.0539	195.38	195.44	16372797.0
2014-07-17 17:00:00	SPY	ETF	195.43	195.48	195.31	195.4	1152166.0
2014-07-17 18:00:00	SPY	ETF	195.41	195.55	194.81	194.86	668846.0
2014-07-17 19:00:00	SPY	ETF	194.91	195.39	194.85	195.38	311193.0
2014-07-17 04:00:00	QQQ	ETF	95.8	95.8	95.7	95.7	900.0
2014-07-17 05:00:00	QQQ	ETF	95.6	95.62	95.59	95.59	7600.0
2014-07-17 06:00:00	QQQ	ETF	95.58	95.58	95.27	95.27	20720.0
2014-07-17 07:00:00	QQQ	ETF	95.29	95.42	95.19	95.27	85735.0
2014-07-17 08:00:00	QQQ	ETF	95.27	95.55	95.27	95.52	497320.0
2014-07-17 09:00:00	QQQ	ETF	95.53	95.95	95.51	95.85	3726496.0
2014-07-17 10:00:00	QQQ	ETF	95.85	95.97	95.67	95.75	4605482.0
2014-07-17 11:00:00	QQQ	ETF	95.74	95.77	95.0	95.14	7323091.0
2014-07-17 12:00:00	QQQ	ETF	95.14	95.29	94.9	95.23	4736169.0
2014-07-17 13:00:00	QQQ	ETF	95.23	95.47	95.12	95.19	2926333.0
2014-07-17 14:00:00	QQQ	ETF	95.19	95.19	94.95	95.06	2973951.0
2014-07-17 15:00:00	QQQ	ETF	95.06	95.06	94.32	94.62	11075866.0
2014-07-17 16:00:00	QQQ	ETF	94.63	95.5063	94.48	94.51	1923583.0
2014-07-17 17:00:00	QQQ	ETF	94.54	95.9268	94.44	94.59	754272.0
2014-07-17 18:00:00	QQQ	ETF	94.57	94.57	94.22	94.31	33433.0
2014-07-17 19:00:00	QQQ	ETF	94.24	94.52	94.23	94.51	46257.0
2014-07-17 05:00:00	IWM	ETF	113.76	113.76	113.76	113.76	100.0
2014-07-17 06:00:00	IWM	ETF	113.6	113.63	113.1	113.13	28875.0
2014-07-17 07:00:00	IWM	ETF	113.18	113.48	113.15	113.27	304205.0
2014-07-17 08:00:00	IWM	ETF	113.28	113.65	113.27	113.59	223526.0
2014-07-17 09:00:00	IWM	ETF	113.61	114.14	113.3	113.99	6517611.0
2014-07-17 10:00:00	IWM	ETF	114.0	114.266	113.66	113.88	7146139.0
2014-07-17 11:00:00	IWM	ETF	113.87	113.93	113.07	113.23	10791896.0
2014-07-17 12:00:00	IWM	ETF	113.23	113.5	112.99	113.38	5028843.0
2014-07-17 13:00:00	IWM	ETF	113.39	113.77	113.205	113.3	3698720.0
2014-07-17 14:00:00	IWM	ETF	113.305	113.305	113.02	113.11	3492284.0
2014-07-17 15:00:00	IWM	ETF	113.115	113.13	112.2	112.51	15433250.0
2014-07-17 16:00:00	IWM	ETF	112.5	112.53	111.91	111.93	3533954.0
2014-07-17 17:00:00	IWM	ETF	111.97	112.07	111.9	112.01	61189.0
2014-07-17 18:00:00	IWM	ETF	112.02	112.02	111.86	111.89	53605.0
2014-07-17 19:00:00	IWM	ETF	111.94	112.2	111.82	112.2	5963.0
2014-07-17 04:00:00	DIA	ETF	170.96	170.96	170.96	170.96	200.0
2014-07-17 06:00:00	DIA	ETF	170.49	170.49	170.39	170.39	550.0
2014-07-17 07:00:00	DIA	ETF	170.5	170.55	170.5	170.5	6500.0

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

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