PREVIEW / etf_1hour / 2011-10-07

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-10-07.parquet
  size:    183 KB
  rows:    5,655

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
2011-10-07 04:00:00	SPY	ETF	116.4	116.55	115.97	115.97	15450.0
2011-10-07 05:00:00	SPY	ETF	116.03	116.15	115.9	116.13	65850.0
2011-10-07 06:00:00	SPY	ETF	115.99	116.16	115.93	116.08	51070.0
2011-10-07 07:00:00	SPY	ETF	116.17	116.32	115.88	115.99	1701538.0
2011-10-07 08:00:00	SPY	ETF	116.08	117.95	115.9	117.37	18921247.0
2011-10-07 09:00:00	SPY	ETF	117.39	117.48	116.34	116.87	35778829.0
2011-10-07 10:00:00	SPY	ETF	116.86	117.245	116.4	116.42	43891751.0
2011-10-07 11:00:00	SPY	ETF	116.42	116.57	115.9	116.55	30270408.0
2011-10-07 12:00:00	SPY	ETF	116.56	116.64	115.24	115.37	44190912.0
2011-10-07 13:00:00	SPY	ETF	115.37	115.75	115.06	115.629	24092977.0
2011-10-07 14:00:00	SPY	ETF	115.63	116.2	115.46	116.02	27848419.0
2011-10-07 15:00:00	SPY	ETF	116.02	117.03	115.46	115.68	59747819.0
2011-10-07 16:00:00	SPY	ETF	115.7	116.683	115.5949	116.01	21501061.0
2011-10-07 17:00:00	SPY	ETF	116.02	116.02	115.81	115.85	827007.0
2011-10-07 18:00:00	SPY	ETF	115.84	116.01	115.75	115.96	456815.0
2011-10-07 19:00:00	SPY	ETF	115.93	116.02	115.87	115.95	60651.0
2011-10-07 05:00:00	QQQ	ETF	54.09	54.14	54.0	54.14	2300.0
2011-10-07 06:00:00	QQQ	ETF	54.14	54.14	54.1	54.1	700.0
2011-10-07 07:00:00	QQQ	ETF	54.21	54.22	54.03	54.07	108159.0
2011-10-07 08:00:00	QQQ	ETF	54.07	54.77	53.9	54.56	5025987.0
2011-10-07 09:00:00	QQQ	ETF	54.58	54.59	54.1	54.35	7167733.0
2011-10-07 10:00:00	QQQ	ETF	54.34	54.49	54.1201	54.1548	9999958.0
2011-10-07 11:00:00	QQQ	ETF	54.16	54.21	53.72	54.21	10293711.0
2011-10-07 12:00:00	QQQ	ETF	54.21	54.27	53.735	53.85	13427272.0
2011-10-07 13:00:00	QQQ	ETF	53.84	54.15	53.76	54.1	4067292.0
2011-10-07 14:00:00	QQQ	ETF	54.1	54.3	54.01	54.2	5747961.0
2011-10-07 15:00:00	QQQ	ETF	54.2	54.66	53.965	54.04	12521524.0
2011-10-07 16:00:00	QQQ	ETF	54.05	54.31	54.02	54.19	1771956.0
2011-10-07 17:00:00	QQQ	ETF	54.2	54.21	54.15	54.18	46322.0
2011-10-07 18:00:00	QQQ	ETF	54.15	54.2	54.14	54.14	22550.0
2011-10-07 19:00:00	QQQ	ETF	54.16	54.2	54.16	54.19	17841.0
2011-10-07 04:00:00	IWM	ETF	67.14	67.14	66.92	66.92	900.0
2011-10-07 05:00:00	IWM	ETF	66.93	66.93	66.92	66.92	500.0
2011-10-07 07:00:00	IWM	ETF	67.0	67.11	66.76	66.78	392189.0
2011-10-07 08:00:00	IWM	ETF	66.8	67.85	66.6	67.49	8621080.0
2011-10-07 09:00:00	IWM	ETF	67.54	67.54	66.55	67.09	9370129.0
2011-10-07 10:00:00	IWM	ETF	67.09	67.615	66.75	66.86	13591222.0
2011-10-07 11:00:00	IWM	ETF	66.86	66.9	66.03	66.51	8132483.0
2011-10-07 12:00:00	IWM	ETF	66.55	66.58	65.23	65.34	14473205.0
2011-10-07 13:00:00	IWM	ETF	65.34	65.86	65.2	65.83	6312124.0
2011-10-07 14:00:00	IWM	ETF	65.83	66.3	65.65	65.95	8250801.0
2011-10-07 15:00:00	IWM	ETF	65.96	66.99	65.4	65.44	16259240.0
2011-10-07 16:00:00	IWM	ETF	65.44	67.2951	65.43	65.68	3900256.0
2011-10-07 17:00:00	IWM	ETF	65.72	65.78	65.62	65.69	20930.0
2011-10-07 18:00:00	IWM	ETF	65.68	65.77	65.67	65.77	20929.0
2011-10-07 19:00:00	IWM	ETF	65.7	65.72	65.7	65.72	3200.0
2011-10-07 05:00:00	DIA	ETF	110.71	110.71	110.62	110.62	300.0
2011-10-07 07:00:00	DIA	ETF	110.7	110.7	110.7	110.7	15000.0
2011-10-07 08:00:00	DIA	ETF	110.71	112.28	110.64	111.96	94481.0
2011-10-07 09:00:00	DIA	ETF	112.0	112.0	111.4	111.86	919739.0

> showing 50 of 5,655 rows — these rows as CSV

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