PREVIEW / etf_1hour / 2013-06-06

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-06-06.parquet
  size:    210 KB
  rows:    6,549

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
2013-06-06 04:00:00	SPY	ETF	161.9	161.95	161.81	161.89	23500.0
2013-06-06 05:00:00	SPY	ETF	161.95	161.98	161.82	161.82	55215.0
2013-06-06 06:00:00	SPY	ETF	161.81	161.98	161.79	161.87	87786.0
2013-06-06 07:00:00	SPY	ETF	161.9	162.19	161.79	162.09	724480.0
2013-06-06 08:00:00	SPY	ETF	162.12	162.23	161.47	161.62	2379725.0
2013-06-06 09:00:00	SPY	ETF	161.59	161.82	160.94	161.7081	25773660.0
2013-06-06 10:00:00	SPY	ETF	161.7	161.96	161.14	161.68	28200041.0
2013-06-06 11:00:00	SPY	ETF	161.68	161.87	161.11	161.2	15456225.0
2013-06-06 12:00:00	SPY	ETF	161.19	161.28	160.25	160.57	33814726.0
2013-06-06 13:00:00	SPY	ETF	160.57	161.54	160.56	161.41	21200192.0
2013-06-06 14:00:00	SPY	ETF	161.41	162.24	161.12	161.95	18612751.0
2013-06-06 15:00:00	SPY	ETF	161.96	162.74	161.72	162.7	29396070.0
2013-06-06 16:00:00	SPY	ETF	162.71	162.97	161.3654	162.89	13282505.0
2013-06-06 17:00:00	SPY	ETF	162.88	162.88	162.75	162.78	7093087.0
2013-06-06 18:00:00	SPY	ETF	162.78	162.81	162.73	162.78	77850.0
2013-06-06 19:00:00	SPY	ETF	162.8	162.82	162.74	162.79	108196.0
2013-06-06 04:00:00	QQQ	ETF	72.3	72.31	72.26	72.3	3600.0
2013-06-06 05:00:00	QQQ	ETF	72.3	72.32	72.28	72.28	1400.0
2013-06-06 06:00:00	QQQ	ETF	72.3	72.32	72.28	72.3	4400.0
2013-06-06 07:00:00	QQQ	ETF	72.3	72.38	72.27	72.38	12191.0
2013-06-06 08:00:00	QQQ	ETF	72.38	72.43	72.24	72.27	152022.0
2013-06-06 09:00:00	QQQ	ETF	72.26	72.39	72.07	72.19	6029629.0
2013-06-06 10:00:00	QQQ	ETF	72.2	72.3	71.96	72.13	8879255.0
2013-06-06 11:00:00	QQQ	ETF	72.12	72.15	71.83	71.88	6987842.0
2013-06-06 12:00:00	QQQ	ETF	71.88	71.92	71.47	71.525	8803258.0
2013-06-06 13:00:00	QQQ	ETF	71.54	71.85	71.53	71.84	6550317.0
2013-06-06 14:00:00	QQQ	ETF	71.8425	72.26	71.74	72.1699	4096480.0
2013-06-06 15:00:00	QQQ	ETF	72.16	72.41	72.03	72.39	6302960.0
2013-06-06 16:00:00	QQQ	ETF	72.39	72.53	72.1002	72.42	2433280.0
2013-06-06 17:00:00	QQQ	ETF	72.42	72.45	72.37	72.44	68967.0
2013-06-06 18:00:00	QQQ	ETF	72.41	72.41	72.35	72.38	6625.0
2013-06-06 19:00:00	QQQ	ETF	72.39	72.39	72.36	72.39	7739.0
2013-06-06 04:00:00	IWM	ETF	95.78	95.78	95.78	95.78	463.0
2013-06-06 06:00:00	IWM	ETF	96.65	96.71	96.45	96.7	3900.0
2013-06-06 07:00:00	IWM	ETF	96.65	96.96	96.6	96.91	87077.0
2013-06-06 08:00:00	IWM	ETF	96.91	97.07	96.5	96.62	819730.0
2013-06-06 09:00:00	IWM	ETF	96.6	97.11	96.27	97.07	5617337.0
2013-06-06 10:00:00	IWM	ETF	97.08	97.23	96.38	96.75	8783629.0
2013-06-06 11:00:00	IWM	ETF	96.75	96.8	96.37	96.41	3884806.0
2013-06-06 12:00:00	IWM	ETF	96.41	96.48	95.73	96.05	8786712.0
2013-06-06 13:00:00	IWM	ETF	96.06	96.69	96.0	96.58	4703009.0
2013-06-06 14:00:00	IWM	ETF	96.58	97.0	96.39	96.82	3653389.0
2013-06-06 15:00:00	IWM	ETF	96.82	97.44	96.69	97.43	5399488.0
2013-06-06 16:00:00	IWM	ETF	97.44	97.61	96.6432	97.4295	1700707.0
2013-06-06 17:00:00	IWM	ETF	97.55	97.6	97.52	97.53	11388.0
2013-06-06 18:00:00	IWM	ETF	97.53	97.53	97.5	97.5	1744.0
2013-06-06 19:00:00	IWM	ETF	97.53	97.53	97.5	97.51	500.0
2013-06-06 04:00:00	DIA	ETF	149.88	149.88	149.88	149.88	200.0
2013-06-06 07:00:00	DIA	ETF	149.89	150.03	149.8	150.03	15970.0
2013-06-06 08:00:00	DIA	ETF	150.0	150.11	149.55	149.65	11085.0

> showing 50 of 6,549 rows — these rows as CSV

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