PREVIEW / etf_1hour / 2014-07-28

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-07-28.parquet
  size:    227 KB
  rows:    7,442

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-28 04:00:00	SPY	ETF	197.49	197.51	197.42	197.42	1495.0
2014-07-28 05:00:00	SPY	ETF	197.43	197.6	197.43	197.56	1228.0
2014-07-28 06:00:00	SPY	ETF	197.52	197.68	197.48	197.59	26910.0
2014-07-28 07:00:00	SPY	ETF	197.58	197.63	197.39	197.46	124993.0
2014-07-28 08:00:00	SPY	ETF	197.47	197.95	197.3	197.87	683845.0
2014-07-28 09:00:00	SPY	ETF	197.86	197.89	196.9199	197.2	10729097.0
2014-07-28 10:00:00	SPY	ETF	197.21	197.21	196.62	196.93	15326776.0
2014-07-28 11:00:00	SPY	ETF	196.939	197.57	196.89	197.385	8613953.0
2014-07-28 12:00:00	SPY	ETF	197.38	197.5	197.21	197.43	4500381.0
2014-07-28 13:00:00	SPY	ETF	197.44	198.09	197.34	197.96	6999765.0
2014-07-28 14:00:00	SPY	ETF	197.955	198.06	197.67	197.93	6985085.0
2014-07-28 15:00:00	SPY	ETF	197.93	197.96	197.72	197.79	10813740.0
2014-07-28 16:00:00	SPY	ETF	197.79	197.8	197.39	197.7	3248833.0
2014-07-28 17:00:00	SPY	ETF	197.7	197.81	197.64	197.76	199957.0
2014-07-28 18:00:00	SPY	ETF	197.76	197.83	197.7	197.8	85039.0
2014-07-28 19:00:00	SPY	ETF	197.82	197.82	197.79	197.81	33651.0
2014-07-28 04:00:00	QQQ	ETF	96.63	96.63	96.63	96.63	2000.0
2014-07-28 05:00:00	QQQ	ETF	96.71	96.71	96.71	96.71	2000.0
2014-07-28 07:00:00	QQQ	ETF	96.71	96.71	96.56	96.64	5310.0
2014-07-28 08:00:00	QQQ	ETF	96.62	96.9	96.62	96.85	241760.0
2014-07-28 09:00:00	QQQ	ETF	96.85	96.86	96.31	96.47	3660608.0
2014-07-28 10:00:00	QQQ	ETF	96.47	96.47	96.02	96.26	4742062.0
2014-07-28 11:00:00	QQQ	ETF	96.26	96.71	96.24	96.525	3565749.0
2014-07-28 12:00:00	QQQ	ETF	96.53	96.66	96.43	96.615	1645882.0
2014-07-28 13:00:00	QQQ	ETF	96.62	97.02	96.56	96.91	2560426.0
2014-07-28 14:00:00	QQQ	ETF	96.9116	96.95	96.75	96.88	2093694.0
2014-07-28 15:00:00	QQQ	ETF	96.88	96.9	96.74	96.76	2861660.0
2014-07-28 16:00:00	QQQ	ETF	96.77	96.8275	96.5206	96.77	3279395.0
2014-07-28 17:00:00	QQQ	ETF	96.73	96.77	96.73	96.77	2750.0
2014-07-28 18:00:00	QQQ	ETF	96.73	96.77	96.73	96.74	6117.0
2014-07-28 19:00:00	QQQ	ETF	96.75	96.76	96.73	96.76	22782.0
2014-07-28 07:00:00	IWM	ETF	113.53	113.61	113.51	113.6	25800.0
2014-07-28 08:00:00	IWM	ETF	113.63	114.01	113.63	113.9	286283.0
2014-07-28 09:00:00	IWM	ETF	113.89	113.92	112.76	113.058	4327246.0
2014-07-28 10:00:00	IWM	ETF	113.06	113.06	112.23	112.54	7485673.0
2014-07-28 11:00:00	IWM	ETF	112.55	112.96	112.49	112.74	2713017.0
2014-07-28 12:00:00	IWM	ETF	112.74	112.83	112.475	112.76	1692234.0
2014-07-28 13:00:00	IWM	ETF	112.75	113.5	112.61	113.33	3647604.0
2014-07-28 14:00:00	IWM	ETF	113.33	113.475	112.98	113.165	2303793.0
2014-07-28 15:00:00	IWM	ETF	113.165	113.27	113.03	113.05	3540308.0
2014-07-28 16:00:00	IWM	ETF	113.05	113.3254	112.98	112.99	3681098.0
2014-07-28 17:00:00	IWM	ETF	113.0	113.03	112.96	112.97	35070.0
2014-07-28 18:00:00	IWM	ETF	112.88	112.88	112.88	112.88	200.0
2014-07-28 19:00:00	IWM	ETF	112.98	112.98	112.85	112.85	1400.0
2014-07-28 08:00:00	DIA	ETF	169.25	169.35	169.25	169.35	2500.0
2014-07-28 09:00:00	DIA	ETF	169.26	169.3	168.6	168.7999	572977.0
2014-07-28 10:00:00	DIA	ETF	168.77	168.82	168.37	168.68	992023.0
2014-07-28 11:00:00	DIA	ETF	168.69	169.1	168.65	168.97	453167.0
2014-07-28 12:00:00	DIA	ETF	168.97	169.07	168.85	169.02	252707.0
2014-07-28 13:00:00	DIA	ETF	169.011	169.65	168.96	169.51	515161.0

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

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