PREVIEW / etf_1hour / 2014-10-02

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-02.parquet
  size:    235 KB
  rows:    7,362

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-10-02 04:00:00	SPY	ETF	194.6	194.6	194.13	194.2	2612.0
2014-10-02 05:00:00	SPY	ETF	194.29	194.48	194.27	194.48	12217.0
2014-10-02 06:00:00	SPY	ETF	194.45	194.7	194.34	194.58	99381.0
2014-10-02 07:00:00	SPY	ETF	194.58	194.95	194.58	194.76	666363.0
2014-10-02 08:00:00	SPY	ETF	194.74	195.07	194.26	194.48	1966481.0
2014-10-02 09:00:00	SPY	ETF	194.46	194.77	193.91	194.46	17672992.0
2014-10-02 10:00:00	SPY	ETF	194.47	194.55	193.33	193.35	26108184.0
2014-10-02 11:00:00	SPY	ETF	193.35	193.65	192.35	192.94	28005445.0
2014-10-02 12:00:00	SPY	ETF	192.95	193.77	192.87	193.735	17394256.0
2014-10-02 13:00:00	SPY	ETF	193.74	194.4	193.6	194.1	19241788.0
2014-10-02 14:00:00	SPY	ETF	194.1	195.055	194.09	194.82	17463694.0
2014-10-02 15:00:00	SPY	ETF	194.815	194.85	194.22	194.39	21056656.0
2014-10-02 16:00:00	SPY	ETF	194.37	194.58	193.63	194.38	5852760.0
2014-10-02 17:00:00	SPY	ETF	194.38	194.45	194.35	194.38	94840.0
2014-10-02 18:00:00	SPY	ETF	194.39	194.4	194.2	194.26	60700.0
2014-10-02 19:00:00	SPY	ETF	194.24	194.49	194.11	194.49	56345.0
2014-10-02 04:00:00	QQQ	ETF	97.49	97.49	97.01	97.03	8970.0
2014-10-02 05:00:00	QQQ	ETF	97.13	97.21	97.1	97.21	1300.0
2014-10-02 06:00:00	QQQ	ETF	97.18	97.32	97.17	97.31	7900.0
2014-10-02 07:00:00	QQQ	ETF	97.31	97.48	97.31	97.41	114700.0
2014-10-02 08:00:00	QQQ	ETF	97.39	97.61	97.0	97.33	429328.0
2014-10-02 09:00:00	QQQ	ETF	97.32	97.429	97.05	97.22	5712800.0
2014-10-02 10:00:00	QQQ	ETF	97.21	97.29	96.49	96.5	8793278.0
2014-10-02 11:00:00	QQQ	ETF	96.51	96.72	95.97	96.35	9618362.0
2014-10-02 12:00:00	QQQ	ETF	96.341	96.9699	96.33	96.96	4991360.0
2014-10-02 13:00:00	QQQ	ETF	96.95	97.29	96.86	97.09	7811657.0
2014-10-02 14:00:00	QQQ	ETF	97.1	97.51	97.085	97.4	6235776.0
2014-10-02 15:00:00	QQQ	ETF	97.405	97.425	97.14	97.19	7016777.0
2014-10-02 16:00:00	QQQ	ETF	97.2	97.35	96.7027	97.15	3272765.0
2014-10-02 17:00:00	QQQ	ETF	97.14	97.21	97.11	97.21	2481.0
2014-10-02 18:00:00	QQQ	ETF	97.18	97.21	97.08	97.11	14952.0
2014-10-02 19:00:00	QQQ	ETF	97.1	97.25	97.05	97.25	22500.0
2014-10-02 04:00:00	IWM	ETF	107.71	107.72	107.69	107.71	1300.0
2014-10-02 06:00:00	IWM	ETF	108.05	108.05	108.05	108.05	25000.0
2014-10-02 07:00:00	IWM	ETF	108.15	108.28	108.13	108.17	142230.0
2014-10-02 08:00:00	IWM	ETF	108.26	108.43	107.86	107.97	737085.0
2014-10-02 09:00:00	IWM	ETF	107.93	108.67	107.62	108.38	6801851.0
2014-10-02 10:00:00	IWM	ETF	108.38	108.42	107.45	107.55	9507320.0
2014-10-02 11:00:00	IWM	ETF	107.55	107.96	106.94	107.1376	10145756.0
2014-10-02 12:00:00	IWM	ETF	107.12	108.06	107.12	108.04	7127926.0
2014-10-02 13:00:00	IWM	ETF	108.03	108.82	107.85	108.65	7504206.0
2014-10-02 14:00:00	IWM	ETF	108.66	109.28	108.62	109.1501	5626971.0
2014-10-02 15:00:00	IWM	ETF	109.165	109.21	108.63	108.82	7930351.0
2014-10-02 16:00:00	IWM	ETF	108.81	108.92	107.95	108.79	1868619.0
2014-10-02 17:00:00	IWM	ETF	108.75	108.83	108.75	108.77	21363.0
2014-10-02 19:00:00	IWM	ETF	108.7	108.85	108.7	108.81	8692.0
2014-10-02 07:00:00	DIA	ETF	167.91	168.02	167.91	167.94	700.0
2014-10-02 08:00:00	DIA	ETF	168.0	168.1	167.56	167.75	4854.0
2014-10-02 09:00:00	DIA	ETF	167.71	167.83	167.2	167.66	922566.0
2014-10-02 10:00:00	DIA	ETF	167.65	167.74	166.99	167.01	1534162.0

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

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