PREVIEW / etf_1hour / 2014-11-11

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-11-11.parquet
  size:    224 KB
  rows:    7,066

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-11-11 04:00:00	SPY	ETF	204.14	204.25	204.03	204.23	28031.0
2014-11-11 05:00:00	SPY	ETF	204.22	204.22	204.08	204.13	16525.0
2014-11-11 06:00:00	SPY	ETF	204.13	204.17	204.08	204.15	90526.0
2014-11-11 07:00:00	SPY	ETF	204.18	204.37	204.13	204.32	88524.0
2014-11-11 08:00:00	SPY	ETF	204.21	204.33	204.11	204.13	335240.0
2014-11-11 09:00:00	SPY	ETF	204.15	204.17	203.65	203.86	8103403.0
2014-11-11 10:00:00	SPY	ETF	203.87	204.25	203.85	204.19	8503320.0
2014-11-11 11:00:00	SPY	ETF	204.2	204.31	203.95	204.0	5864620.0
2014-11-11 12:00:00	SPY	ETF	204.0	204.03	203.83	203.894	4978130.0
2014-11-11 13:00:00	SPY	ETF	203.895	203.91	203.7	203.82	5814612.0
2014-11-11 14:00:00	SPY	ETF	203.83	204.007	203.79	203.9	4361795.0
2014-11-11 15:00:00	SPY	ETF	203.9	204.17	203.805	204.17	11558112.0
2014-11-11 16:00:00	SPY	ETF	204.18	204.25	203.9037	204.16	4239942.0
2014-11-11 17:00:00	SPY	ETF	204.16	204.18	204.12	204.16	77803.0
2014-11-11 18:00:00	SPY	ETF	204.14	204.15	204.07	204.08	67565.0
2014-11-11 19:00:00	SPY	ETF	204.07	204.08	204.0	204.02	128863.0
2014-11-11 04:00:00	QQQ	ETF	102.09	102.1	102.09	102.1	900.0
2014-11-11 05:00:00	QQQ	ETF	102.05	102.05	102.05	102.05	1750.0
2014-11-11 06:00:00	QQQ	ETF	102.03	102.04	102.03	102.04	600.0
2014-11-11 07:00:00	QQQ	ETF	102.06	102.14	102.05	102.1	29605.0
2014-11-11 08:00:00	QQQ	ETF	102.12	102.13	102.02	102.03	44002.0
2014-11-11 09:00:00	QQQ	ETF	102.04	102.04	101.7	101.76	2104782.0
2014-11-11 10:00:00	QQQ	ETF	101.77	102.13	101.77	102.0951	2279237.0
2014-11-11 11:00:00	QQQ	ETF	102.1	102.16	101.97	102.02	1926196.0
2014-11-11 12:00:00	QQQ	ETF	102.02	102.08	101.94	101.99	841387.0
2014-11-11 13:00:00	QQQ	ETF	102.0	102.0859	101.83	102.05	913915.0
2014-11-11 14:00:00	QQQ	ETF	102.05	102.125	102.0	102.11	1076213.0
2014-11-11 15:00:00	QQQ	ETF	102.105	102.27	102.05	102.26	2299181.0
2014-11-11 16:00:00	QQQ	ETF	102.26	102.29	101.996	102.24	711327.0
2014-11-11 17:00:00	QQQ	ETF	102.25	102.28	102.18	102.27	10509.0
2014-11-11 18:00:00	QQQ	ETF	102.22	102.23	102.2	102.2	2993.0
2014-11-11 19:00:00	QQQ	ETF	102.18	102.2	102.16	102.2	13380.0
2014-11-11 05:00:00	IWM	ETF	117.49	117.49	117.49	117.49	100.0
2014-11-11 07:00:00	IWM	ETF	117.48	117.49	117.45	117.45	2000.0
2014-11-11 08:00:00	IWM	ETF	117.46	117.47	117.16	117.19	93636.0
2014-11-11 09:00:00	IWM	ETF	117.2	117.22	116.87	117.0	1862401.0
2014-11-11 10:00:00	IWM	ETF	117.01	117.36	116.96	117.35	2739220.0
2014-11-11 11:00:00	IWM	ETF	117.3466	117.41	117.16	117.2063	1798806.0
2014-11-11 12:00:00	IWM	ETF	117.2	117.21	117.02	117.07	1367802.0
2014-11-11 13:00:00	IWM	ETF	117.081	117.17	116.94	117.12	999719.0
2014-11-11 14:00:00	IWM	ETF	117.13	117.23	117.08	117.17	927986.0
2014-11-11 15:00:00	IWM	ETF	117.17	117.435	117.11	117.36	2796942.0
2014-11-11 16:00:00	IWM	ETF	117.37	117.43	117.2704	117.41	1857824.0
2014-11-11 17:00:00	IWM	ETF	117.42	117.42	117.36	117.36	7693.0
2014-11-11 18:00:00	IWM	ETF	117.33	117.33	117.33	117.33	500.0
2014-11-11 19:00:00	IWM	ETF	117.3	117.3	117.08	117.08	700.0
2014-11-11 04:00:00	DIA	ETF	176.0	176.0	176.0	176.0	1200.0
2014-11-11 08:00:00	DIA	ETF	176.24	176.24	176.11	176.11	600.0
2014-11-11 09:00:00	DIA	ETF	176.0	176.06	175.69	175.8	930681.0
2014-11-11 10:00:00	DIA	ETF	175.82	176.16	175.82	176.1	603498.0

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

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