PREVIEW / etf_1hour / 2011-08-25

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-25.parquet
  size:    179 KB
  rows:    5,558

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-08-25 04:00:00	SPY	ETF	117.78	118.08	117.78	117.98	89921.0
2011-08-25 05:00:00	SPY	ETF	117.97	117.97	117.44	117.48	22260.0
2011-08-25 06:00:00	SPY	ETF	117.56	118.08	117.56	117.93	15460.0
2011-08-25 07:00:00	SPY	ETF	117.9	118.17	117.8	118.13	900900.0
2011-08-25 08:00:00	SPY	ETF	118.09	118.25	117.66	117.71	3482101.0
2011-08-25 09:00:00	SPY	ETF	117.73	119.4	117.58	118.08	46993138.0
2011-08-25 10:00:00	SPY	ETF	118.08	118.12	116.25	116.875	65351961.0
2011-08-25 11:00:00	SPY	ETF	116.875	117.319	116.55	117.013	29460726.0
2011-08-25 12:00:00	SPY	ETF	117.0	117.14	115.91	116.35	27678416.0
2011-08-25 13:00:00	SPY	ETF	116.36	117.0	116.27	116.91	22889197.0
2011-08-25 14:00:00	SPY	ETF	116.92	117.12	116.34	116.36	25951585.0
2011-08-25 15:00:00	SPY	ETF	116.35	117.06	115.87	116.32	60693614.0
2011-08-25 16:00:00	SPY	ETF	116.33	118.1056	115.35	116.09	25677344.0
2011-08-25 17:00:00	SPY	ETF	116.16	116.23	116.07	116.15	108411.0
2011-08-25 18:00:00	SPY	ETF	116.17	116.36	116.11	116.31	120760.0
2011-08-25 19:00:00	SPY	ETF	116.3	116.68	116.29	116.65	462160.0
2011-08-25 04:00:00	QQQ	ETF	52.33	52.42	52.33	52.36	2823.0
2011-08-25 05:00:00	QQQ	ETF	52.36	52.36	52.21	52.23	7132.0
2011-08-25 06:00:00	QQQ	ETF	52.32	52.4	52.31	52.31	9701.0
2011-08-25 07:00:00	QQQ	ETF	52.36	52.55	52.35	52.54	322541.0
2011-08-25 08:00:00	QQQ	ETF	52.51	52.58	52.33	52.34	1236491.0
2011-08-25 09:00:00	QQQ	ETF	52.34	52.905	52.29	52.54	15445300.0
2011-08-25 10:00:00	QQQ	ETF	52.54	52.58	51.89	51.93	21601170.0
2011-08-25 11:00:00	QQQ	ETF	51.93	52.37	51.93	52.25	8106207.0
2011-08-25 12:00:00	QQQ	ETF	52.26	52.32	51.74	51.92	6992119.0
2011-08-25 13:00:00	QQQ	ETF	51.92	52.14	51.85	52.09	6431875.0
2011-08-25 14:00:00	QQQ	ETF	52.095	52.17	51.8	51.801	6904941.0
2011-08-25 15:00:00	QQQ	ETF	51.79	52.13	51.65	51.85	13970937.0
2011-08-25 16:00:00	QQQ	ETF	51.85	52.0	51.8	51.84	1716170.0
2011-08-25 17:00:00	QQQ	ETF	51.86	51.9	51.84	51.84	24232.0
2011-08-25 18:00:00	QQQ	ETF	51.85	51.93	51.83	51.9	8181.0
2011-08-25 19:00:00	QQQ	ETF	51.83	52.06	51.83	52.03	76961.0
2011-08-25 04:00:00	IWM	ETF	69.17	69.45	69.17	69.45	277.0
2011-08-25 06:00:00	IWM	ETF	69.1	69.44	69.1	69.44	5600.0
2011-08-25 07:00:00	IWM	ETF	69.41	69.5	69.38	69.45	16821.0
2011-08-25 08:00:00	IWM	ETF	69.45	69.65	68.51	69.05	1097535.0
2011-08-25 09:00:00	IWM	ETF	69.01	70.29	68.63	68.89	14438596.0
2011-08-25 10:00:00	IWM	ETF	68.9	68.97	67.65	68.0	15809375.0
2011-08-25 11:00:00	IWM	ETF	68.0	68.6	67.86	68.17	7589090.0
2011-08-25 12:00:00	IWM	ETF	68.17	68.27	67.255	67.64	4814911.0
2011-08-25 13:00:00	IWM	ETF	67.65	68.28	67.575	68.22	5076338.0
2011-08-25 14:00:00	IWM	ETF	68.23	68.36	67.67	67.67	5370518.0
2011-08-25 15:00:00	IWM	ETF	67.66	68.25	67.39	67.51	12185777.0
2011-08-25 16:00:00	IWM	ETF	67.52	67.78	67.46	67.48	972800.0
2011-08-25 17:00:00	IWM	ETF	67.49	67.51	67.48	67.51	15256.0
2011-08-25 18:00:00	IWM	ETF	67.46	67.49	67.46	67.47	2200.0
2011-08-25 19:00:00	IWM	ETF	67.5	67.78	67.46	67.66	10999.0
2011-08-25 07:00:00	DIA	ETF	112.95	113.05	112.95	113.05	800.0
2011-08-25 08:00:00	DIA	ETF	113.0	113.04	112.7	112.7	27554.0
2011-08-25 09:00:00	DIA	ETF	112.72	113.7826	112.54	112.74	2055066.0

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

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