PREVIEW / etf_1hour / 2014-07-07

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-07-07.parquet
  size:    229 KB
  rows:    7,530

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-07 04:00:00	SPY	ETF	197.95	198.08	197.84	197.9	20997.0
2014-07-07 05:00:00	SPY	ETF	197.88	198.02	197.88	197.97	1854.0
2014-07-07 06:00:00	SPY	ETF	197.94	198.04	197.86	197.86	61322.0
2014-07-07 07:00:00	SPY	ETF	197.87	197.95	197.74	197.79	218821.0
2014-07-07 08:00:00	SPY	ETF	197.77	198.25	197.61	197.74	723238.0
2014-07-07 09:00:00	SPY	ETF	197.71	197.89	197.54	197.71	9622094.0
2014-07-07 10:00:00	SPY	ETF	197.71	197.98	197.44	197.49	9191058.0
2014-07-07 11:00:00	SPY	ETF	197.49	197.55	197.26	197.37	7527603.0
2014-07-07 12:00:00	SPY	ETF	197.37	197.59	197.28	197.38	4834387.0
2014-07-07 13:00:00	SPY	ETF	197.38	197.68	197.35	197.565	4867145.0
2014-07-07 14:00:00	SPY	ETF	197.57	197.62	197.22	197.4	6560754.0
2014-07-07 15:00:00	SPY	ETF	197.4	197.55	197.31	197.54	9564123.0
2014-07-07 16:00:00	SPY	ETF	197.53	197.61	197.5	197.54	3741968.0
2014-07-07 17:00:00	SPY	ETF	197.55	197.57	197.48	197.51	107622.0
2014-07-07 18:00:00	SPY	ETF	197.52	197.54	197.48	197.48	34699.0
2014-07-07 19:00:00	SPY	ETF	197.5	197.51	197.42	197.5	13998.0
2014-07-07 04:00:00	QQQ	ETF	95.64	95.64	95.53	95.53	2800.0
2014-07-07 05:00:00	QQQ	ETF	95.57	95.57	95.57	95.57	2000.0
2014-07-07 06:00:00	QQQ	ETF	95.58	95.62	95.52	95.54	3450.0
2014-07-07 07:00:00	QQQ	ETF	95.57	95.57	95.47	95.51	14354.0
2014-07-07 08:00:00	QQQ	ETF	95.53	95.53	95.45	95.51	29030.0
2014-07-07 09:00:00	QQQ	ETF	95.5	95.62	95.49	95.6	2606526.0
2014-07-07 10:00:00	QQQ	ETF	95.6	95.71	95.392	95.455	4569829.0
2014-07-07 11:00:00	QQQ	ETF	95.45	95.47	95.28	95.3059	3199902.0
2014-07-07 12:00:00	QQQ	ETF	95.3	95.4	95.26	95.35	1863167.0
2014-07-07 13:00:00	QQQ	ETF	95.35	95.47	95.31	95.41	1775102.0
2014-07-07 14:00:00	QQQ	ETF	95.42	95.46	95.23	95.3399	1668361.0
2014-07-07 15:00:00	QQQ	ETF	95.33	95.4	95.25	95.4	3620313.0
2014-07-07 16:00:00	QQQ	ETF	95.4	95.6922	95.3862	95.43	2204204.0
2014-07-07 17:00:00	QQQ	ETF	95.43	95.45	95.42	95.44	4950.0
2014-07-07 18:00:00	QQQ	ETF	95.43	95.43	95.41	95.41	14699.0
2014-07-07 19:00:00	QQQ	ETF	95.41	95.41	95.39	95.39	5125.0
2014-07-07 07:00:00	IWM	ETF	119.45	119.47	119.38	119.47	2999.0
2014-07-07 08:00:00	IWM	ETF	119.43	119.43	119.25	119.27	56768.0
2014-07-07 09:00:00	IWM	ETF	119.3	119.47	118.77	118.92	4693512.0
2014-07-07 10:00:00	IWM	ETF	118.91	119.11	118.34	118.37	4565851.0
2014-07-07 11:00:00	IWM	ETF	118.38	118.411	118.03	118.11	4506695.0
2014-07-07 12:00:00	IWM	ETF	118.11	118.4	118.095	118.23	2258126.0
2014-07-07 13:00:00	IWM	ETF	118.24	118.31	118.08	118.2	2933168.0
2014-07-07 14:00:00	IWM	ETF	118.2	118.2	117.79	117.92	3277803.0
2014-07-07 15:00:00	IWM	ETF	117.91	118.0	117.7	117.76	4845558.0
2014-07-07 16:00:00	IWM	ETF	117.76	117.9	117.72	117.75	2275666.0
2014-07-07 17:00:00	IWM	ETF	117.76	117.76	117.65	117.65	9600.0
2014-07-07 18:00:00	IWM	ETF	117.63	117.73	117.63	117.7	14619.0
2014-07-07 19:00:00	IWM	ETF	117.69	117.7	117.67	117.7	2246.0
2014-07-07 07:00:00	DIA	ETF	169.81	169.81	169.81	169.81	2000.0
2014-07-07 08:00:00	DIA	ETF	170.0	170.0	169.77	169.89	18391.0
2014-07-07 09:00:00	DIA	ETF	169.85	169.91	169.57	169.75	579169.0
2014-07-07 10:00:00	DIA	ETF	169.74	170.01	169.63	169.68	820037.0
2014-07-07 11:00:00	DIA	ETF	169.67	169.77	169.5524	169.69	333290.0

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

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